Geek Answers Handbook

Which database has the best XML support?

I have a system that generates a large number of XML documents every day (about 1 million), and I would like to be able to store and index them so that I can, for example, search for all documents with a specific field, given for a given value.

I understand that there are fundamentally two types of XML databases, those that provide XML support on top of a regular relational database and those that are the "native" XML database. Given that I am open to use either, what would you recommend?

+5
source share
8 answers

Microsoft SQL Server supports XML columns. This is more than just BLOB / TEXT support.

XML , SQL Server , XML. XML- SQL Server, , XML, /. SQL Server XQuery.

XML, XSD. , SQL Server XML, XPath .

. " XML SQL Server 2008". ( XML SQL Server 2005.)

+6

MarkLogic Server eXist.

( GB), eXist . , , , MarkLogic.

, eXist , MarkLogic , .

+4

XML-db, Sedna. .

+4

, , Oracle XmlDB. , . Oracle, .

+3

DB2 9.x PureXML.

+3

, monetDB xml. , xquery , -, . XML-, , rdbms. , . dbms xml BLOB ( ). BLOB . xml, xml . MonetDB, , .

+1

DB2 Viper, IBM DB2 XML, XML.

DB2 XML , ++,.NET, COBOL, Java PHP.

xQuery - , XML- DB2

-:

create table person(name varchar(20), data xml);

insert into person values('bane', XMLPARSE(DOCUMENT '
<person>
<first-name>Tom</first-name>
<last-name>Hardy</last-name>
<mobile>89898989</mobile>

</person>
' STRIP WHITESPACE))


some simple xQueries

SELECT *
FROM googolplex.person
WHERE xmlexists('$s[person/first-name="bane"]' PASSING person AS "s");
+1

MS-SQL, Oracle , XQuery.

XML, , , XML BLOB XML (s).

0

More articles:


All Articles