Using the new DB2: IBM's object-relational database system
Using the new DB2: IBM's object-relational database system
Lore: a database management system for semistructured data
ACM SIGMOD Record
Storing semistructured data with STORED
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
XMill: an efficient compressor for XML data
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
SilkRoute: trading between relations and XML
Proceedings of the 9th international World Wide Web conference on Computer networks : the international journal of computer and telecommunications netowrking
XML data management (panel session): go native or spruce up relational systems?
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Relational Databases for Querying XML Documents: Limitations and Opportunities
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Efficient Relational Storage and Retrieval of XML Documents
Selected papers from the Third International Workshop WebDB 2000 on The World Wide Web and Databases
Storage and Retrieval of XML Documents Using Object-Relational Databases
DEXA '99 Proceedings of the 10th International Conference on Database and Expert Systems Applications
XML and Object-Relational Database Systems - Enhancing Structural Mappings Based on Statistics
Selected papers from the Third International Workshop WebDB 2000 on The World Wide Web and Databases
From XML Schema to Relations: A Cost-Based Approach to XML Storage
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Constraints-preserving transformation from XML document type deffinition to relational schema
ER'00 Proceedings of the 19th international conference on Conceptual modeling
X-ray: towards integrating XML and relational database systems
ER'00 Proceedings of the 19th international conference on Conceptual modeling
The VLDB Journal — The International Journal on Very Large Data Bases
A comprehensive solution to the XML-to-relational mapping problem
Proceedings of the 6th annual ACM international workshop on Web information and data management
Storing and querying GML in object-relational databases
GIS '06 Proceedings of the 14th annual ACM international symposium on Advances in geographic information systems
Fuzzy XML data modeling with the UML and relational data models
Data & Knowledge Engineering
From tree patterns to generalized tree patterns: on efficient evaluation of XQuery
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Quantity comparison of concurrency control methods for XML database systems based on DOM API
International Journal of Web Engineering and Technology
Semantic clustering of XML documents
ACM Transactions on Information Systems (TOIS)
Optimizing XML-to-SQL query translation for analytical databases using intelligent path derivation
Proceedings of the 48th Annual Southeast Regional Conference
Converting XML schema data to object-relational data with DOM
WISM'11 Proceedings of the 2011 international conference on Web information systems and mining - Volume Part II
Structural similarity mining in semi-structured microarray data for efficient storage construction
OTM'06 Proceedings of the 2006 international conference on On the Move to Meaningful Internet Systems: AWeSOMe, CAMS, COMINF, IS, KSinBIT, MIOS-CIAO, MONET - Volume Part I
Storing XML documents in databases using existing object-relational features
Proceedings of the Fifth Balkan Conference in Informatics
XML-to-SQL query mapping in the presence of multi-valued schema mappings and recursive XML schemas
DEXA'07 Proceedings of the 18th international conference on Database and Expert Systems Applications
Formal Framework of XML Document Schema Design
International Journal of Information Retrieval Research
Hi-index | 0.00 |
As the popularity of eXtensible Markup Language (XML) continues to increase at an astonishing pace, data management systems for storing and querying large repositories of XML data are urgently needed. In this paper, we investigate an Object-Relational DBMS (ORDBMS) for storing and querying XML data. We present an algorithm, called XORator, for mapping XML documents to tables in an ORDBMS. An important part of this mapping is assigning a fragment of an XML document to a new XML data type. We demonstrate that using the XO-Rator algorithm, an ORDBMS is usually more efficient than a Relational DBMS (RDBMS). Based on an actual implementation in DB2 V.7.2, we compare the performance of the XORator algorithm with a well-known algorithm for mapping XML data to an RDBMS. Our experiments show that the XORator algorithm requires less storage space, has much faster loading times, and in most cases can evaluate queries faster. The primary reason for this performance improvement is that the XORator algorithm results in a database that is smaller in size, and queries that usually have fewer number of joins.