A Decade of XML Data Management: An Industrial Experience Report from Oracle

XML and its related technologies have now been in use for almost a decade. There has been considerable amount of effort both from research and industry focusing on XML, XQuery/XPath, XSLT and SQL/XML processing in the database. Many research prototypes and industrial products have been built to satisfy the XML use cases. This paper reviews several use cases where XML databases are leveraged to build real-world XML applications. We discuss the lessons learnt in supporting both data-centric and document-centric XMLDB applications within a single database system and the need for the implementation of different XML storage, index and query optimisation techniques for different XML use cases. We show the value of managing XML in databases, the current challenges and improvements that will hopefully promote future research directions. This paper also provides a timely checkpoint of XML data management from industrial perspective with experience of developing and supporting Oracle XML products.

[1]  Jeffrey Naughton,et al.  The case for a wide-table approach to manage sparse relational data sets , 2007, SIGMOD '07.

[2]  Yuan-Chi Chang,et al.  Schema advisor for hybrid relational-XML DBMS , 2007, SIGMOD '07.

[3]  Ahmad Ashari,et al.  Storing And Querying XML Data Using RDBMS , 2004, iiWAS.

[4]  Vishu Krishnamurthy,et al.  Performance Challenges in Object-Relational DBMSs , 1999, IEEE Data Eng. Bull..

[5]  Vikas Arora,et al.  XMLTable Index - An Efficient Way of Indexing and Querying XML Property Data , 2007, 2007 IEEE 23rd International Conference on Data Engineering.

[6]  Juliana Freire,et al.  From XML schema to relations: a cost-based approach to XML storage , 2002, Proceedings 18th International Conference on Data Engineering.

[7]  Chun Zhang,et al.  Storing and querying ordered XML using a relational database system , 2002, SIGMOD '02.

[8]  D. Askin.  What Goes Around Comes Around? , 2005, Neonatal Network.

[9]  Vikas Arora,et al.  Query Rewrite for XML in Oracle XML DB , 2004, VLDB.

[10]  Michael J. Carey,et al.  Data delivery in a service-oriented world: the BEA aquaLogic data services platform , 2006, SIGMOD Conference.

[11]  Michael Stonebraker,et al.  C-Store: A Column-oriented DBMS , 2005, VLDB.

[12]  Adriane Chapman,et al.  Making database systems usable , 2007, SIGMOD '07.

[13]  Jeffrey F. Naughton,et al.  Extending RDBMSs To Support Sparse Datasets Using An Interpreted Attribute Storage Format , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[14]  Vikas Arora,et al.  Native Xquery processing in oracle XMLDB , 2005, SIGMOD '05.

[15]  Michael Rys.  XML and relational database management systems: inside Microsoft® SQL Server™ 2005 , 2005, SIGMOD '05.

[16]  Toshiyuki Amagasa,et al.  XRel: a path-based approach to storage and retrieval of XML documents using relational databases , 2001, ACM Trans. Internet Techn..

[17]  Cong Yu,et al.  TIMBER: A native XML database , 2002, The VLDB Journal.

[18]  Matthias Nicola,et al.  On the path to efficient XML queries , 2006, VLDB.

[19]  Eugene J. Shekita,et al.  Querying XML Views of Relational Data , 2001, VLDB.

[20]  Michael J. Carey,et al.  Query processing in the aqualogic data services platform , 2006, VLDB.

[21]  Matthias Nicola,et al.  An XML transaction processing benchmark , 2007, SIGMOD '07.

[22]  Vikas Arora,et al.  Towards an enterprise XML architecture , 2005, SIGMOD '05.

[23]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.

[24]  Thomas J. Eggebraaten,et al.  A health-care data model based on the HL7 Reference Information Model , 2007, IBM Syst. J..

[25]  Sam Lightstone,et al.  DB2 Design Advisor: Integrated Automatic Physical Database Design , 2004, VLDB.

[26]  Alessandro Campi,et al.  XQuery layers , 2007, SGMD.

[27]  David J. DeWitt,et al.  The design and performance evaluation of alternative XML storage strategies , 2002, SGMD.

[29]  David J. DeWitt,et al.  Relational Databases for Querying XML Documents: Limitations and Opportunities , 1999, VLDB.

[30]  Sandeepan Banerjee,et al.  XML Schemas in Oracle XML DB , 2003, VLDB.

[31]  Michael Stonebraker,et al.  Object-Relational DBMSs, Second Edition , 1998 .

[32]  Setrag Khoshafian,et al.  A decomposition storage model , 1985, SIGMOD Conference.

[33]  Viswanathan Krishnamurthy.  Oracle XML DB Repository , 2003, SIGMOD Conference.

[34]  Zhen Hua Liu,et al.  Towards a physical XML independent XQuery/SQL/XML engine , 2008, Proc. VLDB Endow..

[35]  Rakesh Agrawal,et al.  Storage and Querying of E-Commerce Data , 2001, VLDB.

[36]  Michael Stonebraker,et al.  Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[37]  Zhen Hua Liu,et al.  XVM - A Hybrid Sequential-Query Virtual Machine for Processing XML Languages , 2008, PLAN-X.

[38]  Jennifer Widom,et al.  The Lowell database research self-assessment , 2003, CACM.

[39]  Benoît Dageville,et al.  Automatic SQL Tuning in Oracle 10g , 2004, VLDB.

[40]  J EggebraatenThomas,et al.  A health-care data model based on the HL7 reference information model , 2007 .

[41]  Serge Abiteboul,et al.  Querying Semi-Structured Data , 1997, Encyclopedia of Database Systems.

[42]  Dan Suciu,et al.  Efficient evaluation of XML middle-ware queries , 2001, SIGMOD '01.

[43]  Vikas Arora,et al.  Towards an industrial strength SQL/XML infrastructure , 2005, 21st International Conference on Data Engineering (ICDE'05).