Abstract
Enterprise information systems (EIS) often employ relational database systems to store their content. At the same time, XML constitutes the dominant standard for data exchange as well as for the hypertext level of web-enabled EIS. Thus, the integration of XML with relational database systems to allow the storage, retrieval, and update of XML documents is of paramount importance in the context of EIS. Data model heterogeneity and schema heterogeneity, however, make this a challenging task. This paper proposes X-Ray, a generic approach facilitating the composition of XML documents out of a relational database system as well as the decomposition of XML documents to store them within a relational database system in a fully transparent way. This is achieved by means of a generic meta schema that stores all relevant information for the composition and decomposition process. This meta schema covers both, the concepts of DTDs and XML Schema concepts.
Chapter PDF
Keywords
- Relational Schema
- Mapping Knowledge
- Document Type Definition
- Relational Database System
- Enterprise Information System
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
S.E. Benham, IBM XML-Enabled Data Management Product Architecture and Technology, XML Data Management, Native XML and XML-Enable Database Systems, A. Chaudhri, et al. (eds.), Addison Wesley, 2003.
P. Bohannon, J. Freire, J. Haritsa, M. Ramanath, R. Prasan, and J. Simeon, Bridging the XML-Relational Divide with LegoDB: A Demonstration, In the Proceedings of ICDE, 2003.
A. Deutsch, et al., MARS: A System for Publishing XML from Mixed and Redundant Storage, Proc. of the Int. Conf. On Very Large Databases (VLDB), Germany, 2003.
M.F. Fernandez, et al., SilkRoute: A Framework for Publishing Relational Data in XML, ACM Transactions on Database Technology 27(4), (2002).
J. Funderburk, G. Kiernan, J. Shanmugasundaram, E. Shekita, and C. Wei, XTABLES: Bridging Relational Technology and XML, IBM Systems Journal 41(4), (2002).
U. Hohenstein, Supporting XML in Oracle9i. XML Data Management, Native XML and XML-Enable Database Systems, A. Chaudhri, et al. (eds.), Addison Wesley, 2003.
G. Kappel, E. Kapsammer, S. Rausch-Schott, W. Retschitzegger, X-Ray — Towards Integrating XML and Relational Database Systems, In the Proceedings of the 19th International Conference on Conceptual Modeling (ER), LNCS 1920, Springer, USA, October, 2000.
G. Kappel, E. Kapsammer, and W. Retschitzegger, Architectural Issues for Integrating XML and Relational Database Systems — The X-Ray Approach, In the Proceedings of the Workshop on XML Technologies and Software Engineering, Toronto, May 2001.
G. Kappel, E. Kapsammer, and W. Retschitzegger, Integrating XML and Relational Database Systems, World Wide Web Journal 7(4), 343–384 (2004).
G. Kappel, E. Kapsammer, and W. Retschitzegger, XML and Relational Database Systems — A Comparison of Concepts, In the Proceedings of the 2nd International Conference on Internet Computing (IC), CSREA Press, Las Vegas, USA, June 2001.
E. Kapsammer, et al., Bridging Relational DB to Context-Aware Services, In the Proceedings of the Workshop on Ubiquitous Mobile Information Systems (UMICS), Portugal, June 2005.
E. Rahm and P. A. Bernstein, A Survey of Approaches to Automatic Schema Matching, VLDB Journal, 10(4), 334–350 (2001).
M. Rys, XML Support in Microsoft SQL Server 2000, Native XML and XML-Enable Database Systems, A. Chaudhri, et al. (eds.), Addison Wesley, 2003.
M. Schrefl, M. Bernauer, E. Kapsammer, B. Pröll, W. Retschitzegger, and T. Thalhammer, Self-Maintaining Web Pages, International Journal of Information Systems, 28(8), (2003).
W3C, Namespaces, January 1999; http://www.w3.org/TR/1999/REC-xml-names-19990114.
W3C, XML 1.0 (2nd ed.), October 2000; http://www.w3.org/TR/2000/REC-xml-20001006.
W3C, XML Schema, May 2001; http://www.w3.org/XML/Schema.
W3C, XQuery 1.0, May 2003; http://www.w3.org/TR/xquery.
Y.-H. Yao, A. J. C. Trappey, and P.-S. Ho, XML-based ISO9000 Electronic Document Management System, Robotics and Computer Manufacturing 19(4), (2004).
D.C. Yen, S.-M. Huang, and C.-Y. Ku, The Impact and Implementation of XML on Business-to-Business Commerce, Computer Standards & Interfaces, 24(4), (2002).
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 International Federation for Information Processing
About this paper
Cite this paper
Kapsammer, E. (2006). XML-based EIS — A Meta Schema for Mapping XML Schema to Relational DBS. In: Tjoa, A.M., Xu, L., Chaudhry, S.S. (eds) Research and Practical Issues of Enterprise Information Systems. IFIP International Federation for Information Processing, vol 205. Springer, Boston, MA. https://doi.org/10.1007/0-387-34456-X_8
Download citation
DOI: https://doi.org/10.1007/0-387-34456-X_8
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-34345-7
Online ISBN: 978-0-387-34456-0
eBook Packages: Computer ScienceComputer Science (R0)