Cannot seem to create the database on BaseX 10.5 properly using an XML file, any help?

[Khondokar Abu Saleheen]

Trying to create a database using the "Cities_XML_Data".xml file in BaseX 10.5. But when I create the database and go to Table view, all the attractions for each of the cities are under a single column and separated by semi-colons (;), hence I have not been able to query the database properly. Any help in this regard?

Have attached a screenshot for what the problem is, can also share the XML file if anyone wants to assist.

Much appreciated!

[Paul Clapham]

Are the semicolons in the XML file, or are they inserted into that column in that database table by some process which you ran?

It seems to me that there should be two tables, one for city data and the other for attraction data. Was that what you expected, or was the conversion process supposed to produce only one?

[Khondokar Abu Saleheen]

Hi Paul,

Thank you for your time.

So as far I can see in the XML file, there is no such semicolons. When I go to create a database using the XML file and using BaseX 10.5 as the platformfor query purposes, the database is being created like this.

Any idea what I can do in this regard?

[Khondokar Abu Saleheen]

Also, to answer another one of your query, yes there was only supposed to be a single table, where I can find results using xPath and xQuery instructions,

[Paul Clapham]

If you want only one table then you would naturally have all of the attractions for a city packed into a single column of the city table. So how would you like to separate them if not with a semicolon?

And you keep saying things like "the database is being created" as if this was happening by magic. I have no doubt that there is some software involved in this creation; you should strongly consider looking into that.

[Paul Clapham]

Khondokar Abu Saleheen wrote:Also, to answer another one of your query, yes there was only supposed to be a single table, where I can find results using xPath and xQuery instructions,

But those are XML technologies. Do you really plan to apply them to a database table, instead of the original XML document?