Selectively storing XML data in relations

Wenfei Fan, Lisha Ma

Research output: Chapter in Book/Report/Conference proceedingConference contribution

2 Citations (Scopus)


This paper presents a new framework for users to select relevant data from an XML document and store it in an existing relational database, as opposed to previous approaches that shred the entire XML document into a newly created database of a newly designed schema. The framework is based on a notion of XML2DB mappings. An XML2DB mapping extends a (possibly recursive) DTD by associating element types with semantic attributes and rules. It extracts either part or all of the data from an XML document, and generates SQL updates to increment an existing database using the XML data. We also provide an efficient technique to evaluate XML2DB mappings in parallel with SAX parsing. These yield a systematic method to store XML data selectively in an existing database. © Springer-Verlag Berlin Heidelberg 2006.

Original languageEnglish
Title of host publicationDatabase and Expert Systems Applications - 17th International Conference, DEXA 2006, Proceedings
Number of pages11
Volume4080 LNCS
Publication statusPublished - 2006
Event17th International Conference on Database and Expert Systems Applications - Krakow, Poland
Duration: 4 Sept 20068 Sept 2006

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume4080 LNCS
ISSN (Print)0302-9743


Conference17th International Conference on Database and Expert Systems Applications
Abbreviated titleDEXA 2006


Dive into the research topics of 'Selectively storing XML data in relations'. Together they form a unique fingerprint.

Cite this