Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/2245276.2245440acmconferencesArticle/Chapter ViewAbstractPublication PagessacConference Proceedingsconference-collections
research-article

C-Mapping: a flexible XML-RDB mapping method based on functional and inclusion dependencies

Published: 26 March 2012 Publication History

Abstract

So far, many XML-RDB mapping methods have been proposed, but all of them deal only with either one-to-one or one-to-N mapping from XML elements to relational attributes, even though other mappings, such as N-to-one mapping, are possible. To extend the expressiveness, this paper proposes C-Mapping, which enables us to deal with N-to-one mapping as well as one-to-one and one-to-N mappings in XML-RDB mapping. C-Mapping takes functional and inclusion dependencies in XML data as input, and generates an XML view constructed over relational tables. An important feature of C-Mapping is that, since dependencies in XML data are captured and represented in XML-RDB mapping, we can make the best use of RDB's functionality to maintain the consistencies in the XML view. In addition, we show that C-Mapping is powerful enough to simulate a variety of mapping schemes proposed so far.

References

[1]
Jayavel Shanmugasundaram, Kristin Tufte, Gang He, Chun Zhang, David De Witt, Jeffrey Naughton: Relational Databases for Querying XML Documents: Limitations and Opportunities. the 25th VLDB Conference: 302--314 (1999).
[2]
M. Yoshikawa, T. Amagasa, T. Shimura, S. Uemura: XRel: A path-based approach to storage and retrieval of XML documents using relational databases. ACM Transactions on Internet Technology 1(1): 110--141 (2001).
[3]
Daniela Florescu, Donald Kossmann: Storing and Querying XML Data using an RDBMS. Bulletin of the Technical Committee on Data Engineering 22(3): 27--34 (1999).
[4]
Yi Chen, Susan Davidson, Carmem Hara, Yifeng Zheng: RRXS: Redundancy reducing XML storage in relations. the 29th VLDB Conference: 189--200 (2003).
[5]
Yi Chen, Susan B. Davidson, Yifeng Zheng: Constraint Preserving XML Storage in Relations. WebDB 2002.
[6]
David C. Fallside, Priscilla Walmsley: XML Schema Part 0: Primer Second Edition. 2004, http://www.w3.org/TR/xmlschema-0/.
[7]
B. Box: The XML Data Model. 1997, http://www.w3.org/XML/Datamodel.html.
[8]
Serge Abiteboul, Richard Hull, Victor Vianu: Foundations of Databases. Addison-Wesley 1995, ISBN 0-201-53771-0.
[9]
ISO/IEC 9075: 1999: Information Technology-Database Language-SQL-Part 1--5 (1999).
[10]
Michael Karlinger, Millist W. Vincent, Michael Schrefl: Inclusion Dependencies in XML: Extending Relational Semantics. In Database and Expert Systems Applications 2009: 23--37.
[11]
Sosuke Ota, Atsuyuki Morishima, Toshiyuki Amagasa, Norihide Shinagawa: C-Mapping: A Flexible XML-RDB Mapping Method based on Functional and Inclusion Dependencies (Full version). Technical report.
[12]
Mary F. Fernandez, Yana Kadiyska, Atsuyuki Morishima, Dan Suciu, Wang-Chiew Tan: SilkRoute: A Framework for Publishing Relational Data in XML. ACM TODS 27(4): 438--493 (2002).

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SAC '12: Proceedings of the 27th Annual ACM Symposium on Applied Computing
March 2012
2179 pages
ISBN:9781450308571
DOI:10.1145/2245276
  • Conference Chairs:
  • Sascha Ossowski,
  • Paola Lecca
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 26 March 2012

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Funding Sources

Conference

SAC 2012
Sponsor:
SAC 2012: ACM Symposium on Applied Computing
March 26 - 30, 2012
Trento, Italy

Acceptance Rates

SAC '12 Paper Acceptance Rate 270 of 1,056 submissions, 26%;
Overall Acceptance Rate 1,650 of 6,669 submissions, 25%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • 0
    Total Citations
  • 112
    Total Downloads
  • Downloads (Last 12 months)0
  • Downloads (Last 6 weeks)0
Reflects downloads up to 11 Sep 2024

Other Metrics

Citations

View Options

Get Access

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media