Join processing in database systems with large main memories
ACM Transactions on Database Systems (TODS)
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
SQL/NF: a query language for ¬ 1NF relational databases
Information Systems
A performance evaluation of pointer-based joins
SIGMOD '90 Proceedings of the 1990 ACM SIGMOD international conference on Management of data
Efficient assembly for complex objects
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Extensible/rule based query rewrite optimization in Starburst
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
A complete guide to DB2 universal database
A complete guide to DB2 universal database
Storing semistructured data with STORED
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
WWW '99 Proceedings of the eighth international conference on World Wide Web
Multivalued dependencies and a new normal form for relational databases
ACM Transactions on Database Systems (TODS)
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
Efficient evaluation of XML middle-ware queries
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Object-Relational DBMSs: Tracking the Next Great Wave
Object-Relational DBMSs: Tracking the Next Great Wave
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Designing A Generalized NF2 Model with an SQL-Type Language Interface
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
Relational Databases for Querying XML Documents: Limitations and Opportunities
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Query Languages for Nested Relational Databases
Papers from the Workshop ``Theory and Applications of Nested Relations and Complex Objects' on Nested Relations and Complex Objects
Oracle8i"The XML Enabled Data Management System
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Storage and Retrieval of XML Data Using Relational Databases
Proceedings of the 27th International Conference on Very Large Data Bases
Deriving relation keys from XML keys
ADC '03 Proceedings of the 14th Australasian database conference - Volume 17
Capturing both types and constraints in data integration
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Composing XSL transformations with XML publishing views
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Efficiently supporting order in XML query processing
WIDM '03 Proceedings of the 5th ACM international workshop on Web information and data management
NEXSORT: Sorting XML in External Memory
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Benchmarking SAP R/3 Archiving Scenarios
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Optimization of query streams using semantic prefetching
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Journal of Biomedical Informatics - Special issue: Unified medical language system
Integrating XML and Relational Database Systems
World Wide Web
General purpose database summarization
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Efficiently supporting order in XML query processing
Data & Knowledge Engineering - Special issue: WIDM 2003
Optimization of query streams using semantic prefetching
ACM Transactions on Database Systems (TODS) - Special Issue: SIGMOD/PODS 2004
The Michigan benchmark: towards XML query performance diagnostics
Information Systems
Tables and trees don't mix (very well)
Proceedings of the 15th international conference on World Wide Web
Reformulating XPath queries and XSLT queries on XSLT views
Data & Knowledge Engineering
Towards practical meta-querying
Information Systems
Expressiveness and complexity of xml publishing transducers
Proceedings of the twenty-sixth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
DTD-directed publishing with attribute translation grammars
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
FleDEx: flexible data exchange
Proceedings of the 9th annual ACM international workshop on Web information and data management
XTRON: An XML data management system using relational databases
Information and Software Technology
Expressiveness and complexity of XML publishing transducers
ACM Transactions on Database Systems (TODS)
A Generic Data Level Implementation of ModelGen
BNCOD '08 Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge
STBenchmark: towards a benchmark for mapping systems
Proceedings of the VLDB Endowment
Flexible approach for representing object oriented databases in XML format
Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services
A relational data harmonization approach to XML
Journal of Information Science
Speeding-up data-driven applications with program summaries
IDEAS '09 Proceedings of the 2009 International Database Engineering & Applications Symposium
Preserving SQL access control policies over published XML data
Proceedings of the 2009 EDBT/ICDT Workshops
The Michigan benchmark: towards XML query performance diagnostics
Information Systems
VIREX: visual relational to XML conversion tool
Journal of Visual Languages and Computing
Xml publishing: bridging theory and practice
DBPL'07 Proceedings of the 11th international conference on Database programming languages
Holistic constraint-preserving transformation from relational schema into XML schema
DASFAA'08 Proceedings of the 13th international conference on Database systems for advanced applications
Access control policy translation and verification within heterogeneous data federations
Proceedings of the 15th ACM symposium on Access control models and technologies
Mapping OWL to the Entity Relationship and Extended Entity Relationship models
International Journal of Knowledge and Web Intelligence
Mapping XML Schema to Entity Relationship and Extended Entity Relationship Models
International Journal of Intelligent Information and Database Systems
VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML
Journal of Intelligent Information Systems
Editorial: BioDB: An ontology-enhanced information system for heterogeneous biological information
Data & Knowledge Engineering
CBMS'03 Proceedings of the 16th IEEE conference on Computer-based medical systems
ACM Transactions on Information and System Security (TISSEC)
A graph-theoretic approach to map conceptual designs to XML schemas
ACM Transactions on Database Systems (TODS)
Hi-index | 0.00 |
XML is rapidly emerging as a standard for exchanging business data on the World Wide Web. For the foreseeable future, however, most business data will continue to be stored in relational database systems. Consequently, if XML is to fulfill its potential, some mechanism is needed to publish relational data as XML documents. Towards that goal, one of the major challenges is finding a way to efficiently structure and tag data from one or more tables as a hierarchical XML document. Different alternatives are possible depending on when this processing takes place and how much of it is done inside the relational engine. In this paper, we characterize and study the performance of these alternatives. Among other things, we explore the use of new scalar and aggregate functions in SQL for constructing complex XML documents directly in the relational engine. We also explore different execution plans for generating the content of an XML document. The results of an experimental study show that constructing XML documents inside the relational engine can have a significant performance benefit. Our results also show the superiority of having the relational engine use what we call an “outer union plan” to generate the content of an XML document.