1 / 11

Understanding XML Storage: Benefits, Challenges, and Database Solutions

This article delves into XML (Extensible Markup Language), highlighting its significance in encoding information with meaningful structure. It explores various storage methods, including relational and native XML databases, and discusses their respective benefits, such as improved search capabilities and original format preservation. Additionally, it addresses challenges faced by XML databases, including issues similar to hierarchical databases and increased CPU consumption. This overview provides insights into effective XML data management and references key studies in the field.

cleave
Télécharger la présentation

Understanding XML Storage: Benefits, Challenges, and Database Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. XML Data Storage Joe Carroll Russell Gibbons

  2. Agenda • What is XML • Storage of XML • Benefits of XML Databases • Problems with XML Databases • Discussion

  3. What is XML “XML (Extensible Markup Language) is a W3C initiative that allows information and services to be encoded with meaningful structure and semantics that computers and humans can understand. XML is great for information exchange, and can easily be extended to include user-specified and industry-specified tags.” www.orafaq.com/glossary/faqglosx.htm 

  4. Storage of XML • Character • Relational (shredded) • Native XML

  5. Character • Storage options • Large character fields in DBMS • Flat files • .xml files • Fast insert & retrieval • Poor search

  6. Relational • Data still stored as character • Portions of the data extracted into additional relational tables • Increased parse time • Increased search capabilities

  7. Native XML • Exclusive XML DBMS • Sedna • Timber • Integrated XML DBMS • DB2 • Oracle

  8. Native XML Benefits • XML messages stored in their original format • Documents can be transformed straight from the database via XPath or XSLT. • Increased search capabilities for documents that must be stored as XML.

  9. Native XML Problems • Same problems as hierarchical databases • Many-to-many relationships • Referential Integrity • Difficult to handle within legacy applications. • Increased CPU consumption.

  10. Discussion

  11. References • [1] Shalaka Natu, John Mendonca, “Digital Asset Management Using A Native XML Database Implementation”, CITC4 ’03, October 16-18, 2003, Lafayette, Indiana, USA. • [2] Matthias Nicola, Jasmi John, “XML Parsing: A Threat to Database Performance”, CIKM ’03, November 3-8, 2003, New Orleans, Louisiana, USA. • [3] Mattias Nicola, Bert van der Linden, “Native XML Support in DB2 Universal Database”, Proceedings of the 31st VLDB Conference, Trondheim, Norway, 2005. • [4] “Native XML data store overview”, http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.apdv.embed.doc/doc/c0022308.htm • [5] “Use XML databases to empower Java Web services”, http://www.javaworld.com/javaworld/jw-12-2004/jw-1206-xml.html

More Related