An automatic load/extract scheme for XML documents through object-relational repositories
Journal of Systems and Software
XPath query transformation based on XSLT stylesheets
WIDM '03 Proceedings of the 5th ACM international workshop on Web information and data management
Software—Practice & Experience
Integrating XML and Relational Database Systems
World Wide Web
Looking at mapping, indexing & querying of MPEG-7 descriptors in RDBMS with SM3
Proceedings of the 2nd ACM international workshop on Multimedia databases
Reformulating XPath queries and XSLT queries on XSLT views
Data & Knowledge Engineering
An empirical study of XML data management in business information systems
Journal of Systems and Software - Special issue: Selected papers from the 11th Asia Pacific software engineering conference (APSEC 2004)
DBA'06 Proceedings of the 24th IASTED international conference on Database and applications
ShreX: managing XML documents in relational databases
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
A database ontology for signal transduction pathways
International Journal of Bioinformatics Research and Applications
XPred: a new model-mapping-schema-based approach for efficient access to XML data
Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services
Methods for a Synchronised Evolution of Databases and Associated Ontologies
Proceedings of the 2007 conference on Databases and Information Systems IV: Selected Papers from the Seventh International Baltic Conference DB&IS'2006
A practical approach to extracting DTD-conforming XML documents from heterogeneous data sources
Information Sciences: an International Journal
X-ray: towards integrating XML and relational database systems
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Mapping XML Schema to Entity Relationship and Extended Entity Relationship Models
International Journal of Intelligent Information and Database Systems
Note: modulewriter: a program for automatic generation of database interfaces
Computational Biology and Chemistry
| Hi-index | 0.00 |
XML is rapidly gaining momentum in e-commerce and Internet-based information exchange, where its simplicity and custom-defined tags make it usable as a semantics-preserving data exchange format. However, to realize this potential, it is necessary to be able to extract structured data from XML documents and store it in a database, as well as to generate XML documents from data extracted from a database. Although many DBMS vendors are scrambling to extend their products to handle XML, there is a need for a lightweight, DBMS- and platform-independent load/extract utility as well. In this paper we describe such a utility, that solves the following problems: 1) loading data from XML documents into relational tables with a known schema, 2) creating XML documents according to a known DTD from data extracted from a database, 3) generating relational schemas from XML DTDs for on-the-fly storage of XML documents, and 4) generating XML DTDs from relational schemas for on-the-fly extraction of relational data. We introduce a language to describe a mapping between an existing XML DTD and an existing relational schema and discuss some of the interesting issues arising from such a mapping.