DocumentCode :
2182812
Title :
A generic load/extract utility for data transfer between XML documents and relational databases
Author :
Bourret, R. ; Bornhövd, C. ; Buchmann, A.
Author_Institution :
Dept. of Comput. Sci., Tech. Hochschule Darmstadt, Germany
fYear :
2000
fDate :
2000
Firstpage :
134
Lastpage :
143
Abstract :
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 document type definition (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
Keywords :
Internet; electronic commerce; electronic data interchange; hypermedia markup languages; relational databases; utility programs; DBMS-independent utility; Internet-based information exchange; XML documents; custom-defined tags; data loading; data transfer; document type definition; electronic commerce; generic load/extract utility; mapping language; on-the-fly storage; platform-independent utility; relational databases; relational schemas; relational tables; semantics-preserving data exchange format; structured data extraction; Computer science; Data mining; Domain specific languages; Electrical capacitance tomography; Electronic commerce; Internet; Java; Relational databases; Search engines; XML;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Advanced Issues of E-Commerce and Web-Based Information Systems, 2000. WECWIS 2000. Second International Workshop on
Conference_Location :
Milpitas, CA
Print_ISBN :
0-7695-0610-0
Type :
conf
DOI :
10.1109/WECWIS.2000.853868
Filename :
853868
Link To Document :
بازگشت