Dear all,
I have a database with suppliers/parts/orders/customers/listitems and I'm trying to gain performance for queries like "sum up all orders where customers are in Japan". This results to many joins of documents representing each type of entity. With a relational database I'd use foreign keys.
It looks like BaseX supports DTD's. Would creating DTD's improve the query speed? In the mailing list I saw only one reference to this https://www.mail-archive.com/basex-talk@mailman.uni-konstanz.de/msg02586.htm.... In the response "a DTD-aware XQuery processor can
supply the id() and idref() XPath functions. However, these do not work across documents, and the values must be legal XML identifiers. Having said that, most XML databases make indexes, so joins using FLWOR and values will work based on values."
Based on that, I'd need to create a DTD for a structure that has id's and idref's and the corresponding document would be 1 GB large (to contain all the suppliers/parts/orders/customers/listitems). Would this make sense?
Mark