XML database
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 |
|
Berkeley DB XML | Oracle | free download |
... |
eXist-db | eXist-db team | Open source download |
|
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 |
|
XML-enabled databases
- Db2 (pureXML, XML Extender)
- Microsoft SQL Server
- Oracle Database
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
- Extensible Markup Language (XML). Retrieved February 24, 2015 .
- XQuery 3.0: An XML Query Language. Retrieved February 24, 2015 .
- XQuery and XPath Full Text 1.0. Retrieved February 24, 2015 .
- XQuery Update Facility 3.0. Retrieved February 24, 2015 .
- Ronald Bourret: Native XML Databases. Very extensive list of all native XML database systems. Retrieved October 15, 2011 .
- Theses. Retrieved October 15, 2011 .
Individual evidence
- ↑ 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.
- ↑ http://exist-db.org/exist/apps/doc/update_ext.xml
- ↑ http://www.monetdb.org/XQuery
- ↑ http://attic.apache.org/projects/xindice.html