XML database

from Wikipedia, the free encyclopedia

The term XML database characterizes the property of a database or a database management system to store and search documents marked with XML .

classification

XML is a markup language for structuring text-oriented information. XML databases therefore belong to the document-oriented databases . Techniques that go beyond the SQL standard or completely replace it are often used to query and modify XML databases . In a broader sense, they therefore also belong to the group of NoSQL systems. The database models used by XML databases differ in relational , object-oriented or proprietary techniques.

XML recommendations

After the widespread acceptance of XML, the W3C published further recommendations that are more or less supported by XML database systems:

  • XPath . Language to address nodes in XML documents.
  • XSLT . Transformation language to convert XML documents into other formats.
  • XQuery . Query language to search XML structures.
  • XQuery and XPath Data Model (XDM). Introduction of data types.
  • XQuery fulltext. Extension of XQuery and XPath to include full text search.
  • XQuery Update. Extension of XQuery to include the ability to modify data.

Comparison with SQL

What SQL is (for querying and manipulation) in relational database systems is primarily XPath , XQuery and XQuery Update in XML databases . In turn, XQuery or XSL ( XSLT , XSL-FO ) can be used to transform and display the XML data .

Implementations

In general, two forms of implementation can be distinguished.

  • XML-enabled : Conventional database systems (e.g. relational database systems ) that allow an assignment to or into the XML format. This procedure is called data-oriented . The query and modification takes place with the means of the database system (e.g. SQL).
  • Native XML database systems : These have developed their own storage and indexing technologies that have been optimized for XML documents. The query and modification are carried out using standardized or proprietary methods.

Native XML databases

Surname Manufacturer costs Product description
BaseX BaseX team Open source
download
  • XQuery 3.1, XPath 2.0, XQuery Update, XQuery Full Text
  • XSLT 1.0 (integrated), XSLT 2.0 (via Saxon), JSON, HTML5, SQL
  • interactive and user-friendly GUI
  • Interfaces: REST, WebDAV, XML: DB, XQJ, 15 other programming languages
  • Focus on performance and scalability
Berkeley DB XML Oracle free
download 		...
eXist-db eXist-db team Open source
download
  • XQuery 1.0, XPath 2.0, partly XQuery 3.0
  • XSLT 1.0 (integrated), XSLT 2.0 (via Saxon)
  • HTTP interfaces: REST, WebDAV, SOAP, XML-RPC, and Atom Publishing Protocol
  • XML database specific:
    • XMLDB
    • XUpdate
    • XQuery Update Extension
MonetDB / XQuery monetdb team Open source
download 		Development of the XQuery extension "frozen" as of May 2011
Sedna Sedna team Open source Feature list
Xindice Apache Software Foundation Open source
download
  • Continuation of dbXML Core (Dec. 2001)
  • uses X-Path as the query language
  • XML: DB X update for updates
  • XML: DB API through Java
  • has XML-RPC API
  • has not been further developed since August 2011

XML-enabled databases

literature

  • Bastian Gorke: XML databases in practice. A practical insight into the world of XML databases and their use in programming languages. bomots Verlag, Saarbrücken 2006, ISBN 3-939316-19-9 .
  • Uwe Hess: XML and databases. Use the interfaces of Access and SQl server professionally. Markt-und-Technik-Verlag, Munich 2002, ISBN 3-8272-6304-2 .
  • Wassilios Kazakos, Andreas Schmidt, Peter Tomczyk: Databases and XML. Concepts, applications, systems. Springer, Berlin et al. 2002, ISBN 3-540-41956-X .
  • Meike Klettke, Holger Meyer: XML & Databases. Concepts, languages ​​and systems. dpunkt-Verlag, Heidelberg 2003, ISBN 3-89864-148-1 .
  • Harald Schöning: XML and databases. Concepts and Systems. Hanser, Munich et al. 2002, ISBN 3-446-22008-9 .
  • Michael Seeman: Native XML databases in practice. Software and Support Verlag, Frankfurt am Main 2003, ISBN 3-935042-35-3 .
  • Michael Wagner: SQL / XML: 2006. Evaluation of the standard conformity of selected database systems. Diplomica-Verlag, Hamburg 2010, ISBN 978-3-8366-9609-8 .

Web links

Individual evidence

  1. ↑ Archived copy ( memento of the original dated November 10, 2013 in the Internet Archive ) Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. @1@ 2Template: Webachiv / IABot / exist-db.org
  2. ↑ http://exist-db.org/exist/apps/doc/update_ext.xml
  3. ↑ http://www.monetdb.org/XQuery
  4. ↑ http://attic.apache.org/projects/xindice.html