Schema Based Storage of Xml Documents in Relational Databases

Sharma, Divyesh

doi:10.5121/ijwsc.2013.4202

Cited by 2 publications

(1 citation statement)

References 5 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Schema-based mapping: This approach uses the structure of a schema for that document (DTD or XML Schema) to generate the relational schema for storing an XML document [8], [9], [11], [13], [14]. The structure of the model of the relational database will be generated using the foreign key and the primary key that points to the parent-child relationship in the XML Tree (extracted from DTD or XML Schema).…”

Section: Introductionmentioning

confidence: 99%

XMap: A Novel Approach to Store and Retrieve XML Document in Relational Databases

Bousalem¹,

Cherti²

2015

JSW

View full text Add to dashboard Cite

Due to Its simplicity, its flexibility and its expansion possibilities, XML can be adapted to multiple domains. Its self-described structure and nesting, allows XML to become the dominant standard for storing and transferring data through the World Wide Web. In addition the relational database systems are mature and extremely powerful. Therefore, many researches have been done to propose an efficient approach to store and query an XML document in Relational Database. In this paper we present a new approach to store and query an XML document using relational databases, which decompose an XML document into three tables without using any XML schema or DTD. Our approach supports efficiently the structural modifications to the XML tree, and achieves lower storage consumption. Also, we propose two powerful algorithms for mapping XML data to relational databases and from relational database to XML data.

show abstract

Section: Introductionmentioning

confidence: 99%

XMap: A Novel Approach to Store and Retrieve XML Document in Relational Databases

Bousalem¹,

Cherti²

2015

JSW

View full text Add to dashboard Cite

show abstract

A Survey on Mapping Semi-Structured Data and Graph Data to Relational Data

Yuan

Lu²,

Yan

et al. 2023

ACM Comput. Surv.

View full text Add to dashboard Cite

The data produced by various services should be stored and managed in an appropriate format for gaining valuable knowledge conveniently. This leads to the emergence of various data models, including relational, semi-structured, and graph models, etc. Considering the fact that the mature relational databases established on relational data model are still predominant in today’s market, it has fueled interest in storing and processing semi-structured data and graph data in relational databases so that mature and powerful relational databases’ capabilities can all be applied to these various data. In this survey, we review existing methods on mapping semi-structured data and graph data into relational tables, analyze their major features, and give a detailed classification of those methods. We also summarize the merits and demerits of each method, introduce open research challenges, and present future research directions. With this comprehensive investigation of existing methods and open problems, we hope this survey could motivate new mapping approaches through drawing lessons from each model’s mapping strategies, as well as a new research topic - mapping multi-model data into relational tables.

show abstract

Schema Based Storage of Xml Documents in Relational Databases

Cited by 2 publications

References 5 publications

XMap: A Novel Approach to Store and Retrieve XML Document in Relational Databases

XMap: A Novel Approach to Store and Retrieve XML Document in Relational Databases

A Survey on Mapping Semi-Structured Data and Graph Data to Relational Data

Contact Info

Product

Resources

About