Bringing object-relational technology to the mainstream
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Towards an Industrial Strength SQL/XML Infrastructure
ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Native Xquery processing in oracle XMLDB
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Towards an enterprise XML architecture
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Conquering the heterogeneity and evolutionary nature of XML using XML union views
DBA'06 Proceedings of the 24th IASTED international conference on Database and applications
A database for medical image management
Computer Methods and Programs in Biomedicine
Effective and efficient update of xml in RDBMS
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Query rewrite for XML in Oracle XML DB
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
The MPEG-7 Multimedia Database System (MPEG-7 MMDB)
Journal of Systems and Software
Towards a physical XML independent XQuery/SQL/XML engine
Proceedings of the VLDB Endowment
Towards an MPEG-7 Query Language
Advanced Internet Based Systems and Applications
Hi-index | 0.01 |
The W3C XML Scheme language is becomimg increasingly popular for expressing the data model for XML documents. It is a powerful language that incorporates both strutural and datatype modeling features. There are many benefits to storing XML Schema compliant data in a database system, including better queryability, optimied updates and stronger validation. However, the fidelity of the XML document cannot be sacrificed. Thus, the fundamental problem facing database implementers is: how can XML Schemes be mapped to relational (and object-relational) database without losing schema semantics or data-fidelity? In this paper, we present the Oracle XML DB solution for a flexible mapping of XML Schemas to object-relational database. It preserves document fidelity, including ordering, namespaces, comments, processing instructions etc., and handles all the XML Schema semantics including cyclic definitions, dervations (extension and restriction), and wildcards. We also discuss various query and update optimiations that involve rewriting XPath operations to directly operate on the underlying relational data.