3 ms·

For example, XML databases are handy when you have large XML datasets that you like to query. The database indexes the XML, allowing you to execute most XPath

For example, XML databases are handy when you have large XML datasets that you like to query. The database indexes the XML, allowing you to execute most XPath queries and XQuery programs quickly.

taspeotis 13y ago
I had a quick Google and MSSQL [1], DB2 [2] and Oracle [3] all support indexing XML. [1] http://technet.microsoft.com/en-us/library/ms191497.aspx http://technet.microsoft.com/en-us/library/ms191497.aspx [2] http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.swg.vs.addins.doc%2Fhtml%2Fibmdevori-DB2XMLIndexes.htm http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.j... [3] http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb_indexing.htm#CHDJECDA http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb_in...
- danieldk 13y ago
  It's not about indexing paths you indicate, XML databases are about indexing the whole structure (remember, XML is not relational, but are graphs). Besides that they provide XPath/XQuery processing and optimization. You can query large XML documents or sets of documents, like you'd query them with e.g. XQilla. Of course, it is possible to implement all of this on top of existing database technology. E.g. Oracle's Berkeley DB XML is implemented on top of Berkeley DB. But, a relational database with some indexing of XML does not provide the same functionality as an XML database.
  - sixbrx 13y ago
    Oracle for one does allow full document xml indexing (via XMLIndex) which is trivial to implement, also a rather full featured XQuery integrated with SQL.
  - taspeotis 13y ago
    > It's not about indexing paths you indicate, XML databases are about indexing the whole structure From my first link, MSSQL does both: The primary XML index indexes all tags, values, and paths within the XML instances in an XML column ... To enhance search performance, you can create secondary XML indexes. A primary XML index must first exist before you can create secondary indexes And it supports some reasonable subset of XQuery [1]. [1] http://technet.microsoft.com/en-us/library/ms187854.aspx http://technet.microsoft.com/en-us/library/ms187854.aspx

For example, XML databases are handy when you have large XML datasets that you like to query. The database indexes the XML, allowing you to execute most XPath queries and XQuery programs quickly.

taspeotis 13y ago

I had a quick Google and MSSQL [1], DB2 [2] and Oracle [3] all support indexing XML. [1] http://technet.microsoft.com/en-us/library/ms191497.aspx http://technet.microsoft.com/en-us/library/ms191497.aspx [2] http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.swg.vs.addins.doc%2Fhtml%2Fibmdevori-DB2XMLIndexes.htm http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.j... [3] http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb_indexing.htm#CHDJECDA http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb_in...

danieldk 13y ago
It's not about indexing paths you indicate, XML databases are about indexing the whole structure (remember, XML is not relational, but are graphs). Besides that they provide XPath/XQuery processing and optimization. You can query large XML documents or sets of documents, like you'd query them with e.g. XQilla. Of course, it is possible to implement all of this on top of existing database technology. E.g. Oracle's Berkeley DB XML is implemented on top of Berkeley DB. But, a relational database with some indexing of XML does not provide the same functionality as an XML database.
- sixbrx 13y ago
  Oracle for one does allow full document xml indexing (via XMLIndex) which is trivial to implement, also a rather full featured XQuery integrated with SQL.
- taspeotis 13y ago
  > It's not about indexing paths you indicate, XML databases are about indexing the whole structure From my first link, MSSQL does both: The primary XML index indexes all tags, values, and paths within the XML instances in an XML column ... To enhance search performance, you can create secondary XML indexes. A primary XML index must first exist before you can create secondary indexes And it supports some reasonable subset of XQuery [1]. [1] http://technet.microsoft.com/en-us/library/ms187854.aspx http://technet.microsoft.com/en-us/library/ms187854.aspx