Mapping XML Data to Relational Data: A DOM-Based Approach

XML has emerged as the standard for representing and exchanging data on the World Wide Web. It is critical to have efficient mechanisms to store and query XML data to exploit the full power of this new technology. Several researchers have proposed to use relational databases to store and query XML d...

Full description

Saved in:
Bibliographic Details
Published in:arXiv.org 2010-10
Main Authors: Atay, Mustafa, Sun, Yezhou, Liu, Dapeng, Lu, Shiyong, Fotouhi, Farshad
Format: Article
Language:English
Subjects:
Algorithms
Mapping
New technology
Object oriented programming
Queries
Query languages
Relational data bases
Software reviews
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites
container_end_page
container_issue
container_start_page
container_title arXiv.org
container_volume
creator Atay, Mustafa
Sun, Yezhou
Liu, Dapeng
Lu, Shiyong
Fotouhi, Farshad
description XML has emerged as the standard for representing and exchanging data on the World Wide Web. It is critical to have efficient mechanisms to store and query XML data to exploit the full power of this new technology. Several researchers have proposed to use relational databases to store and query XML data. While several algorithms of schema mapping and query mapping have been proposed, the problem of mapping XML data to relational data, i.e., mapping an XML INSERT statement to a sequence of SQL INSERT statements, has not been addressed thoroughly in the literature. In this paper, we propose an efficient linear algorithm for mapping XML data to relational data. This algorithm is based on our previous proposed inlining algorithm for mapping DTDs to relational schemas and can be easily adapted to other inlining algorithms.
format article
fullrecord <record><control><sourceid>proquest</sourceid><recordid>TN_cdi_proquest_journals_2087563932</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>2087563932</sourcerecordid><originalsourceid>FETCH-proquest_journals_20875639323</originalsourceid><addsrcrecordid>eNpjYuA0MjY21LUwMTLiYOAtLs4yMDAwMjM3MjU15mSw9E0sKMjMS1eI8PVRcEksSVQoyVcISs1JLMnMz0vMAQtZKTgquPj76jolFqemKDgWFBTlJyZn8DCwpiXmFKfyQmluBmU31xBnD12gdGFpanFJfFZ-aRHQjOJ4IwMLc1MzY0tjI2PiVAEAfXw0TA</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>2087563932</pqid></control><display><type>article</type><title>Mapping XML Data to Relational Data: A DOM-Based Approach</title><source>Publicly Available Content Database (ProQuest)</source><creator>Atay, Mustafa ; Sun, Yezhou ; Liu, Dapeng ; Lu, Shiyong ; Fotouhi, Farshad</creator><creatorcontrib>Atay, Mustafa ; Sun, Yezhou ; Liu, Dapeng ; Lu, Shiyong ; Fotouhi, Farshad</creatorcontrib><description>XML has emerged as the standard for representing and exchanging data on the World Wide Web. It is critical to have efficient mechanisms to store and query XML data to exploit the full power of this new technology. Several researchers have proposed to use relational databases to store and query XML data. While several algorithms of schema mapping and query mapping have been proposed, the problem of mapping XML data to relational data, i.e., mapping an XML INSERT statement to a sequence of SQL INSERT statements, has not been addressed thoroughly in the literature. In this paper, we propose an efficient linear algorithm for mapping XML data to relational data. This algorithm is based on our previous proposed inlining algorithm for mapping DTDs to relational schemas and can be easily adapted to other inlining algorithms.</description><identifier>EISSN: 2331-8422</identifier><language>eng</language><publisher>Ithaca: Cornell University Library, arXiv.org</publisher><subject>Algorithms ; Mapping ; New technology ; Object oriented programming ; Queries ; Query languages ; Relational data bases ; Software reviews</subject><ispartof>arXiv.org, 2010-10</ispartof><rights>2010. This work is published under http://arxiv.org/licenses/nonexclusive-distrib/1.0/ (the “License”). Notwithstanding the ProQuest Terms and Conditions, you may use this content in accordance with the terms of the License.</rights><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://www.proquest.com/docview/2087563932?pq-origsite=primo$$EHTML$$P50$$Gproquest$$Hfree_for_read</linktohtml></links><search><creatorcontrib>Atay, Mustafa</creatorcontrib><creatorcontrib>Sun, Yezhou</creatorcontrib><creatorcontrib>Liu, Dapeng</creatorcontrib><creatorcontrib>Lu, Shiyong</creatorcontrib><creatorcontrib>Fotouhi, Farshad</creatorcontrib><title>Mapping XML Data to Relational Data: A DOM-Based Approach</title><title>arXiv.org</title><description>XML has emerged as the standard for representing and exchanging data on the World Wide Web. It is critical to have efficient mechanisms to store and query XML data to exploit the full power of this new technology. Several researchers have proposed to use relational databases to store and query XML data. While several algorithms of schema mapping and query mapping have been proposed, the problem of mapping XML data to relational data, i.e., mapping an XML INSERT statement to a sequence of SQL INSERT statements, has not been addressed thoroughly in the literature. In this paper, we propose an efficient linear algorithm for mapping XML data to relational data. This algorithm is based on our previous proposed inlining algorithm for mapping DTDs to relational schemas and can be easily adapted to other inlining algorithms.</description><subject>Algorithms</subject><subject>Mapping</subject><subject>New technology</subject><subject>Object oriented programming</subject><subject>Queries</subject><subject>Query languages</subject><subject>Relational data bases</subject><subject>Software reviews</subject><issn>2331-8422</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2010</creationdate><recordtype>article</recordtype><sourceid>PIMPY</sourceid><recordid>eNpjYuA0MjY21LUwMTLiYOAtLs4yMDAwMjM3MjU15mSw9E0sKMjMS1eI8PVRcEksSVQoyVcISs1JLMnMz0vMAQtZKTgquPj76jolFqemKDgWFBTlJyZn8DCwpiXmFKfyQmluBmU31xBnD12gdGFpanFJfFZ-aRHQjOJ4IwMLc1MzY0tjI2PiVAEAfXw0TA</recordid><startdate>20101008</startdate><enddate>20101008</enddate><creator>Atay, Mustafa</creator><creator>Sun, Yezhou</creator><creator>Liu, Dapeng</creator><creator>Lu, Shiyong</creator><creator>Fotouhi, Farshad</creator><general>Cornell University Library, arXiv.org</general><scope>8FE</scope><scope>8FG</scope><scope>ABJCF</scope><scope>ABUWG</scope><scope>AFKRA</scope><scope>AZQEC</scope><scope>BENPR</scope><scope>BGLVJ</scope><scope>CCPQU</scope><scope>DWQXO</scope><scope>HCIFZ</scope><scope>L6V</scope><scope>M7S</scope><scope>PHGZM</scope><scope>PHGZT</scope><scope>PIMPY</scope><scope>PKEHL</scope><scope>PQEST</scope><scope>PQGLB</scope><scope>PQQKQ</scope><scope>PQUKI</scope><scope>PRINS</scope><scope>PTHSS</scope></search><sort><creationdate>20101008</creationdate><title>Mapping XML Data to Relational Data: A DOM-Based Approach</title><author>Atay, Mustafa ; Sun, Yezhou ; Liu, Dapeng ; Lu, Shiyong ; Fotouhi, Farshad</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-proquest_journals_20875639323</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2010</creationdate><topic>Algorithms</topic><topic>Mapping</topic><topic>New technology</topic><topic>Object oriented programming</topic><topic>Queries</topic><topic>Query languages</topic><topic>Relational data bases</topic><topic>Software reviews</topic><toplevel>online_resources</toplevel><creatorcontrib>Atay, Mustafa</creatorcontrib><creatorcontrib>Sun, Yezhou</creatorcontrib><creatorcontrib>Liu, Dapeng</creatorcontrib><creatorcontrib>Lu, Shiyong</creatorcontrib><creatorcontrib>Fotouhi, Farshad</creatorcontrib><collection>ProQuest SciTech Collection</collection><collection>ProQuest Technology Collection</collection><collection>Materials Science &amp; Engineering Collection (ProQuest)</collection><collection>ProQuest Central (Alumni Edition)</collection><collection>ProQuest Central UK/Ireland</collection><collection>ProQuest Central Essentials</collection><collection>ProQuest Central</collection><collection>Technology collection</collection><collection>ProQuest One Community College</collection><collection>ProQuest Central</collection><collection>SciTech Premium Collection (ProQuest)</collection><collection>ProQuest Engineering Collection</collection><collection>Engineering Database</collection><collection>ProQuest Central (New)</collection><collection>ProQuest One Academic (New)</collection><collection>Publicly Available Content Database (ProQuest)</collection><collection>ProQuest One Academic Middle East (New)</collection><collection>ProQuest One Academic Eastern Edition (DO NOT USE)</collection><collection>ProQuest One Applied &amp; Life Sciences</collection><collection>ProQuest One Academic</collection><collection>ProQuest One Academic UKI Edition</collection><collection>ProQuest Central China</collection><collection>Engineering Collection (ProQuest)</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Atay, Mustafa</au><au>Sun, Yezhou</au><au>Liu, Dapeng</au><au>Lu, Shiyong</au><au>Fotouhi, Farshad</au><format>book</format><genre>document</genre><ristype>GEN</ristype><atitle>Mapping XML Data to Relational Data: A DOM-Based Approach</atitle><jtitle>arXiv.org</jtitle><date>2010-10-08</date><risdate>2010</risdate><eissn>2331-8422</eissn><abstract>XML has emerged as the standard for representing and exchanging data on the World Wide Web. It is critical to have efficient mechanisms to store and query XML data to exploit the full power of this new technology. Several researchers have proposed to use relational databases to store and query XML data. While several algorithms of schema mapping and query mapping have been proposed, the problem of mapping XML data to relational data, i.e., mapping an XML INSERT statement to a sequence of SQL INSERT statements, has not been addressed thoroughly in the literature. In this paper, we propose an efficient linear algorithm for mapping XML data to relational data. This algorithm is based on our previous proposed inlining algorithm for mapping DTDs to relational schemas and can be easily adapted to other inlining algorithms.</abstract><cop>Ithaca</cop><pub>Cornell University Library, arXiv.org</pub><oa>free_for_read</oa></addata></record>
fulltext fulltext
identifier EISSN: 2331-8422
ispartof arXiv.org, 2010-10
issn 2331-8422
language eng
recordid cdi_proquest_journals_2087563932
source Publicly Available Content Database (ProQuest)
subjects Algorithms
Mapping
New technology
Object oriented programming
Queries
Query languages
Relational data bases
Software reviews
title Mapping XML Data to Relational Data: A DOM-Based Approach
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-03-06T03%3A24%3A10IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest&rft_val_fmt=info:ofi/fmt:kev:mtx:book&rft.genre=document&rft.atitle=Mapping%20XML%20Data%20to%20Relational%20Data:%20A%20DOM-Based%20Approach&rft.jtitle=arXiv.org&rft.au=Atay,%20Mustafa&rft.date=2010-10-08&rft.eissn=2331-8422&rft_id=info:doi/&rft_dat=%3Cproquest%3E2087563932%3C/proquest%3E%3Cgrp_id%3Ecdi_FETCH-proquest_journals_20875639323%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_pqid=2087563932&rft_id=info:pmid/&rfr_iscdi=true