Cited By
View all- Qtaish AAhmad K(2016)XAncestorKnowledge-Based Systems10.1016/j.knosys.2016.10.009114:C(167-192)Online publication date: 15-Dec-2016
A comparative analysis of managing XML data in relational database
Pages 100 - 108
Abstract
The eXtensible Markup Language (XML) has recently emerged as a standard for data representation and interchange on the web. Based on its popularity used in most application, the critical issues are to store and to query XML data to exploit the full power of this technology. Since relational database is widely used technology for storing and querying, therefore replacing it with pure XML database is not a good choice and very expensive process. It is thus crucial to map XML data into relational data and this process is one that occurs frequently. Many existing methods exist in the literature, and defining what the best mapping method is explicitly important. The intention of this paper is to the existing mapping methods in terms of generating good relational schema. At the end a new mapping method is developed to overcome the limitations the limitations and shows that it is efficient in terms of removing relation redundancy.
References
[1]
Ahmad, K., Mamat, A., Ibrahim, H., Mohd Noah, S.A.: Defining functional dependency for XML. Journal for Information Systems Research and Practices (2008)
[2]
Amer-Yahia, S.A., Du, F., Freire, J.: A Comprehensive Solution to the XML to Relational Mapping Problem. In: Proceedings of the 6th Annual ACM International Workshop on Web Information and Data Management, pp. 31-38 (2004)
[3]
Atay, M., Chebotko, A., Liu, D., Lu, S., Fotouhi, F.: Efficient Schema-based XML-to-Relational Data Mapping. Journal of Information System 32, 458-476 (2007)
[4]
Bohannon, P., Freire, J., Roy, P., Simeon, J.: From XML Schema to Relations: A Cost-Based Approach to XML Storage. In: Proceedings of the 18th International Conference on Data Engineering, pp. 64-74 (2002)
[5]
Chen, Y., Davidson, S., Hara, C., Zheng, Y.: RRXS: Redundancy Reducing XML Storage in Relations. In: Proceedings of 29th International Conference on Very Large Data Base, pp. 189-200 (2003)
[6]
Chen, Y., Davidson, S., Zheng, Y.: Constraint Preserving XML Storage in Relations. In: Proceeding of the 9th International Conference of Database Theory, pp. 7-12 (2002)
[7]
Davidson, S., Fan, W., Hara, C., Qin, J.: Propagating XML Constraints to Relations. In: Proceedings of the 19th International Conference on Data Engineering, pp. 543-554 (2003)
[8]
Fan, W.: XML Constraints: Specification, Analysis, and Application. In: Proceedings of the 16th International Workshop on Database and Expert Systems Applications, pp. 805- 809 (2005)
[9]
Florescu, D., Kossman, D.: A Performance Evaluation of Alternative Mapping Schemes for Storing XML Data in A Relational Database. In: Proceedings of the VLDB (1999)
[10]
Lee, D., Chu, W.W.: CPI- Constraint-Preserving Inlining Algorithms For Mapping XML DTD to Relational Schema. Journal of Data Knowledge and Engeering 39(1), 3-25 (2001)
[11]
Lee, Q., Bressan, S.,Rahayu, W.: XShreX:Maintaining Integrity Constraints in the Mapping of XML Schema to Relational. Proceedings of the 17th International Conference on Database and Expert Systems Application, pp.492-496 (2006)
[12]
Liu, C., Vincent, M., Liu, J.: Constraint Preserving Transformation from Relational Schema to XML Schema. Journal of World Wide Web 9(1), 93-110 (2006)
[13]
Lv, T., Yan, P.: Mapping DTDs to Relational Schemas with Semantic Constraints. Journal of Information and Software Technology 48(4), 245-252 (2006)
[14]
Qin, J., Zhao, S., Yang, S., Dou, W.: XPEV: A Storage Model for Well-Formed XML Documents. In: Wang, L., Jin, Y. (eds.) FSKD 2005. LNCS (LNAI), vol. 3613, pp. 360- 369. Springer, Heidelberg (2005)
[15]
Schewe, K.: Redundancy, Dependencies and Normal Forms for XML Databases. In: Sixteenth Australasian Database Conference, vol. 39 (2005)
[16]
Shanmugasundaram, J.: Relational Databases for Querying XML Documents: Limitations and Opportunities. In: Proceedings of the 25th VLDB Conference, pp. 302-314 (1999)
[17]
Tian, F., DeWitt, J., Chen, J., Zhang, C.: The Design and Performance Evaluation of Alternative XML Storage Strategies. SIGMOD Record 31(1), 5-10 (2002)
[18]
Yoshikawa, M., Amagasa, T., Shimura, T.: XRel: A Path-based Approach To Storage and Retrieval of XML Documents Using Relational Database. ACM Transactions on Internet Technology 1, 110-141 (2001)
[19]
Zhanga, S., Gana, J., Xua, J., Lva, G.: Study On Native XML Database Based GML Storage Model. In: The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, Beijing, vol. XXXVII (2008).
Recommendations
XML data mediator integrated solution for xml roundtrip from xml to relational
WWW Alt. '04: Proceedings of the 13th international World Wide Web conference on Alternate track papers & postersThis paper presents a system for efficient data transformations between XML and relational databases, called XML Data Mediator (XDM). XDM enables the transformation by externalizing the specification of the mapping in a script and using an efficient run-...
XLight, An Efficient Relational Schema to Store and Query XML Data
DSDE '10: Proceedings of the 2010 International Conference on Data Storage and Data EngineeringBecause of increasing use of XML data on the internet, the need for an efficient method of storing and querying XML data is vital. So far, two major types of system for XML data management have been introduced: XML Enabled systems and XML native ...
Alternatives to relational database: Comparison of NoSQL and XML approaches for clinical data storage
Clinical data are dynamic in nature, often arranged hierarchically and stored as free text and numbers. Effective management of clinical data and the transformation of the data into structured format for data analysis are therefore challenging issues in ...
Comments
Please enable JavaScript to view thecomments powered by Disqus.Information & Contributors
Information
Published In
Publisher
Springer-Verlag
Berlin, Heidelberg
Publication History
Published: 20 April 2011
Author Tags
Qualifiers
- Article
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 0Total Downloads
- Downloads (Last 12 months)0
- Downloads (Last 6 weeks)0
Reflects downloads up to 02 Oct 2024
Other Metrics
Citations
Cited By
View all- Qtaish AAhmad K(2016)XAncestorKnowledge-Based Systems10.1016/j.knosys.2016.10.009114:C(167-192)Online publication date: 15-Dec-2016