s-XML: An efficient mapping scheme to bridge XML and relational database

Authors:
Samini Subramaniam;Su-Cheng Haw;Poo Kuan Hoong
Affiliations:
Faculty of Information Technology, Multimedia University, 63100 Cyberjaya, Malaysia;Faculty of Information Technology, Multimedia University, 63100 Cyberjaya, Malaysia;Faculty of Information Technology, Multimedia University, 63100 Cyberjaya, Malaysia
Venue:
Knowledge-Based Systems
Year:
2012

Citing 15
Cited 1

XRel: a path-based approach to storage and retrieval of XML documents using relational databases

ACM Transactions on Internet Technology (TOIT)
The design and performance evaluation of alternative XML storage strategies

ACM SIGMOD Record
Path materialization revisited: an efficient storage model for XML data

ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
SilkRoute: A framework for publishing relational data in XML

ACM Transactions on Database Systems (TODS)
Logical and physical support for heterogeneous data

Proceedings of the eleventh international conference on Information and knowledge management
A mapping schema and interface for XML stores

Proceedings of the 4th international workshop on Web information and data management
A general technique for querying XML documents using a relational database system

ACM SIGMOD Record
Agora: Living with XML and Relational

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Answering XML Queries on Heterogeneous Data Sources

Proceedings of the 27th International Conference on Very Large Data Bases
Bridging relational database history and the web: the XML approach

WIDM '06 Proceedings of the 8th annual ACM international workshop on Web information and data management
Mapping-driven XML transformation

Proceedings of the 16th international conference on World Wide Web
ShreX: managing XML documents in relational databases

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
A concept and implementation of higher-level XML transformation languages

Knowledge-Based Systems
The Michigan benchmark: towards XML query performance diagnostics

Information Systems
Short communication: Answering queries that may have results in the future: A case study in food science

Knowledge-Based Systems

Short Communication: Time efficient reconciliation of mappings in dynamic web ontologies

Knowledge-Based Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

XML has recently emerged as the leading medium for data storage and data transfer over the World Wide Web due to its adaptable structure and flexibility in defining the tags. Many organizations had adopted XML as the principal facet in their online business applications. On the other hand, relational database is still widely used as the back-end database in most organizations. The diversity of these models need to be taken into account to ensure transparent and seamless integration. In this paper, we propose s-XML, an effective mapping scheme to bridge XML and relational database. Experimental results indicate that (1) s-XML is robust in terms of database storage and data loading; (2) s-XML processes query efficiently for complex chain and twig queries; and (3) s-XML is able to support large and skew-structured dataset as compared to relational DTD, Attribute and Edge approaches.