s-XML: An efficient mapping scheme to bridge XML and relational database

XML has recently emerged as the leading medium for data storage and data transfer over the World Wide Web due to its adaptable structure and flexibility in defining the tags. Many organizations had adopted XML as the principal facet in their online business applications. On the other hand, relational database is still widely used as the back-end database in most organizations. The diversity of these models need to be taken into account to ensure transparent and seamless integration. In this paper, we propose s-XML, an effective mapping scheme to bridge XML and relational database. Experimental results indicate that (1) s-XML is robust in terms of database storage and data loading; (2) s-XML processes query efficiently for complex chain and twig queries; and (3) s-XML is able to support large and skew-structured dataset as compared to relational DTD, Attribute and Edge approaches.

[1]  Jeffrey F. Naughton,et al.  A general technique for querying XML documents using a relational database system , 2001, SGMD.

[2]  Ioana Manolescu,et al.  Answering XML Queries on Heterogeneous Data Sources , 2001, VLDB.

[3]  Lee Chien-Sing,et al.  Node Labeling Schemes in XML Query Optimization: A Survey and Trends , 2009 .

[4]  Amadou Ndiaye,et al.  Answering queries that may have results in the future: A case study in food science , 2010, Knowl. Based Syst..

[5]  Steven J. DeRose,et al.  XML Path Language (XPath) , 1999 .

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

[7]  Jignesh M. Patel,et al.  The Michigan benchmark: towards XML query performance diagnostics , 2006, Inf. Syst..

[8]  Sihem Amer-Yahia.  Storage Techniques and Mapping Schemas for XML , 2003 .

[9]  Dan Suciu,et al.  SilkRoute: A framework for publishing relational data in XML , 2002, TODS.

[10]  Alban Gabillon,et al.  A persistent labelling scheme for XML and tree databases , 2005, SITIS.

[11]  Alin Deutsch,et al.  Storing Semistructured Data in Relations , 1999, ICDT 1999.

[12]  Sihem Amer-Yahia,et al.  A mapping schema and interface for XML stores , 2002, WIDM '02.

[13]  Hongjun Lu,et al.  Path Materialization Revisited: An Efficient Storage Model for XML Data , 2002, Australasian Database Conference.

[14]  Fusheng Wang,et al.  Bridging relational database history and the web: the XML approach , 2006, WIDM '06.

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

[16]  Sourav S. Bhowmick,et al.  SUCXENT: An Efficient Path-Based Approach to Store and Query XML Documents , 2004, DEXA.

[17]  Su-Cheng Haw,et al.  Data storage practices and query processing in XML databases: A survey , 2011, Knowl. Based Syst..

[18]  Sihem Amer-Yahia,et al.  Logical and physical support for heterogeneous data , 2002, CIKM '02.

[19]  Haifeng Jiang,et al.  Mapping-driven XML transformation , 2007, WWW '07.

[20]  Elke Pulvermüller,et al.  A concept and implementation of higher-level XML transformation languages , 2009, Knowl. Based Syst..

[21]  Sihem Amer-Yahia,et al.  ShreX: Managing XML Documents in Relational Databases , 2004, VLDB.

[22]  Ioana Manolescu,et al.  Agora: Living with XML and Relational , 2000, VLDB.

[23]  Latifur Khan,et al.  A performance evaluation of storing XML data in relational database management systems , 2001, WIDM '01.

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