The definition of Standard ML
Storing semistructured data with STORED
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Query rewriting for semistructured data
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Computational problems related to the design of normal form relational schemas
ACM Transactions on Database Systems (TODS)
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
Database Management Systems
A Rule Engine for Query Transformation in Starburst and IBM DB2 C/S DBMS
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Efficiently Publishing Relational Data as XML Documents
VLDB '00 Proceedings of the 26th 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
Querying XML Views of Relational Data
Proceedings of the 27th International Conference on Very Large Data Bases
Object Fusion in Mediator Systems
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Everything You Ever Wanted to Know About DTDs, But Were Afraid to Ask (Extended Abstract)
Selected papers from the Third International Workshop WebDB 2000 on The World Wide Web and Databases
Optimizing view queries in ROLEX to support navigable result trees
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
A comprehensive XQuery to SQL translation using dynamic interval encoding
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Efficient ordering for XML data
CIKM '03 Proceedings of the twelfth international conference on Information and knowledge management
Benchmarking SAP R/3 Archiving Scenarios
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Constraint-based XML query rewriting for data integration
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Secure XML querying with security views
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Managing XML Data: An Abridged Overview
Computing in Science and Engineering
Unraveling the duplicate-elimination problem in XML-to-SQL query translation
Proceedings of the 7th International Workshop on the Web and Databases: colocated with ACM SIGMOD/PODS 2004
Integrating XML and Relational Database Systems
World Wide Web
Rewriting Rules To Permeate Complex Similarity and Fuzzy Queries within a Relational Database System
IEEE Transactions on Knowledge and Data Engineering
Towards an Industrial Strength SQL/XML Infrastructure
ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Sub-document queries over XML with XSQirrel
WWW '05 Proceedings of the 14th international conference on World Wide Web
System RX: one part relational, one part XML
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Querying and maintaining ordered XML data using relational databases
ADC '05 Proceedings of the 16th Australasian database conference - Volume 39
Designing information-preserving mapping schemes for XML
VLDB '05 Proceedings of the 31st international conference on Very large data bases
XQuery implementation in a relational database system
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Join minimization in XML-to-SQL translation: an algebraic approach
ACM SIGMOD Record
Reformulating XPath queries and XSLT queries on XSLT views
Data & Knowledge Engineering
DB2 goes hybrid: integratng native XML and XQuery with relational data and SQL
IBM Systems Journal
Virtual XML: a toolbox and use cases for the XML world view
IBM Systems Journal
Data & Knowledge Engineering - Special issue: ER 2004
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
PATAXÓ: A framework to allow updates through XML views
ACM Transactions on Database Systems (TODS)
Mapping-driven XML transformation
Proceedings of the 16th international conference on World Wide Web
XML subtree reconstruction from relational storage of XML documents
Data & Knowledge Engineering
Querying xml with update syntax
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Expressiveness and complexity of xml publishing transducers
Proceedings of the twenty-sixth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
From XML view updates to relational view updates: old solutions to a new problem
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Indexing XML data stored in a relational database
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
A uniform system for publishing and maintaining XML data
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
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)
Proceedings of the 17th ACM conference on Information and knowledge management
Speeding-up data-driven applications with program summaries
IDEAS '09 Proceedings of the 2009 International Database Engineering & Applications Symposium
From XQuery to relational logics
ACM Transactions on Database Systems (TODS)
Optimizing updates of recursive XML views of relations
The VLDB Journal — The International Journal on Very Large Data Bases
Preserving SQL access control policies over published XML data
Proceedings of the 2009 EDBT/ICDT Workshops
XQuery speedup by deploying structural redundancy in mapping XML into relations
Information and Software Technology
A practical approach to extracting DTD-conforming XML documents from heterogeneous data sources
Information Sciences: an International Journal
Automatic generation of model translations
CAiSE'07 Proceedings of the 19th international conference on Advanced information systems engineering
Query and update through XML views
DNIS'07 Proceedings of the 5th international conference on Databases in networked information systems
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
An optimized two-step solution for updating XML views
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
XML: some papers in a haystack
ACM SIGMOD Record
Updating XML views and querying XML views with update syntax
International Journal of Computational Science and Engineering
A generic framework for extracting XML data from legacy databases
Journal of Web Engineering
Incremental maintenance of materialized XML views
DEXA'11 Proceedings of the 22nd international conference on Database and expert systems applications - Volume Part II
ACM Transactions on Information and System Security (TISSEC)
XML subtree queries: specification and composition
DBPL'05 Proceedings of the 10th international conference on Database Programming Languages
s-XML: An efficient mapping scheme to bridge XML and relational database
Knowledge-Based Systems
A design of spatial XQuery for mobile and location-based applications
ICWE'05 Proceedings of the 5th international conference on Web Engineering
Updating XML using object-relational database
BNCOD'05 Proceedings of the 22nd British National conference on Databases: enterprise, Skills and Innovation
Translating XQuery to SQL based on query forests
DASFAA'05 Proceedings of the 10th international conference on Database Systems for Advanced Applications
A framework for XML-Based integration of data, visualization and analysis in a biomedical domain
XSym'05 Proceedings of the Third international conference on Database and XML Technologies
TempoXML: Nested bitemporal relationship modeling and conversion tool for fuzzy XML
Information Sciences: an International Journal
Mappings make data processing go 'round
GTTSE'05 Proceedings of the 2005 international conference on Generative and Transformational Techniques in Software Engineering
Conflict resolution in updates through XML views
EDBT'06 Proceedings of the 2006 international conference on Current Trends in Database Technology
C-Mapping: a flexible XML-RDB mapping method based on functional and inclusion dependencies
Proceedings of the 27th Annual ACM Symposium on Applied Computing
Learning queries for relational, semi-structured, and graph databases
Proceedings of the 2013 Sigmod/PODS Ph.D. symposium on PhD symposium
Hi-index | 0.00 |
XML is the "lingua franca" for data exchange between interenterprise applications. In this work, we describe SilkRoute, a framework for publishing relational data in XML. In SilkRoute, relational data is published in three steps: the relational tables are presented to the database administrator in a canonical XML view; the database administrator defines in the XQuery query language a public, virtual XML view over the canonical XML view; and an application formulates an XQuery query over the public view. SilkRoute composes the application query with the public-view query, translates the result into SQL, executes this on the relational engine, and assembles the resulting tuple streams into an XML document. This work makes some key contributions to XML query processing. First, it describes an algorithm that translates an XQuery expression into SQL. The translation depends on a query representation that separates the structure of the output XML document from the computation that produces the document's content. The second contribution addresses the optimization problem of how to decompose an XML view over a relational database into an optimal set of SQL queries. We define formally the optimization problem, describe the search space, and propose a greedy, cost-based optimization algorithm, which obtains its cost estimates from the relational engine. Experiments confirm that the algorithm produces queries that are nearly optimal.