ABSTRACT
In response to the widespread use of the XML format for document representation and message exchange, major database vendors support XML in terms of persistence, querying and indexing. Specifically, the recently released IBM DB2 9 (for Linux, Unix and Windows) is a hybrid data server with optimized management of both XML and relational data. With the new option of storing and querying XML in a relational DBMS, data architects face the the decision of what portion of their data to persist as XML and what portion as relational data. This problem has not been addressed yet and represents a serious need in the industry. Hence, this paper describes ReXSA, a schema advisor tool that is being prototyped for IBM DB2 9. ReXSA proposes candidate database schemas given an information model of the enterprise data. It has the advantage of considering qualitative properties of the information model such as reuse, evolution and performance profiles for deciding how to persist the data. Finally, we show the viability and practicality of ReXSA by applying it to custom and real usecases.
- R. Al-Kamha, D. W. Embley, and S. W. Liddle. Representing Generalization/Specialization in XML Schema. In Proc. of EMISA, 2005.Google Scholar
- M. F. Alin Deutsch and D. Suciu. Storing semistructured data with stored. In Proc. of SIGMOD Conference, 1999.Google ScholarDigital Library
- K. S. Beyer et.al. System RX: One Part Relational, One Part XML. In Proc. of SIGMOD Conference, 2005. Google ScholarDigital Library
- L. Bird, A. Goodchild, and T. Halpin. Object Role Modelling and XML-Schema. In Proc. of ER, 2000. Google ScholarDigital Library
- P. Bohannon, J. Freire, P. Roy, and J. Simeon. From XML Schema to Relations: A Cost-based Approach to XML Storage. In Proc. of ICDE, 2002. Google ScholarDigital Library
- S. Y. Chien et.al. Supporting Complex Queries on Multiversion XML Documents. ACM Trans. Inter. Tech., 6(1):5384, 2006. Google ScholarDigital Library
- C. Combi and B. Oliboni. Conceptual modeling of XML data. In Proc. of SAC, 2006.Google ScholarDigital Library
- R. Conrad, D. Scheffner, and J. C. Freytag. XML Conceptual Modeling Using UML. In Proc. of ER, 2000. Google ScholarDigital Library
- R. Elmasri and S. B. Navathe. Fundamentals of Database Systems. Benjamin/Cummings, 5th edition, 2006.Google Scholar
- R. Elmasri et.al. Conceptual Modeling for Customized XML Schemas. In Proc. of ER, 2002. Google ScholarDigital Library
- D. W. Embley and W. Y. Mok. Developing XML Documents with Guaranteed "Good" Properties. In Proc. of ER, 2001. Google ScholarDigital Library
- HL7 Reference Information Model. http://www.hl7.org/library/data-model/RIM/C30204/rim.htm.Google Scholar
- IBM Alphaworks. Model Transformation Framework. http://www.alphaworks.ibm.com/tech/mtf.Google Scholar
- IBM Rational Software. Generating XSD schemas from UML models. http://publib.boulder.ibm.com/infocenter/rtnlhelp/v6r0m0/topic/com.ibm.xtools.transformations.doc/topics/txsdover.html.Google Scholar
- IBM Rational Software. http://www.ibm.com/software/rational.Google Scholar
- H. Liu, Y. Lu, and Q. Yang. XML Conceptual Modeling with XUML. In Proc. of ICSE, 2006.Google ScholarDigital Library
- M. Nicola and B. V. der Linden. Native XML Support in DB2 Universal Database. In Proc. of VLDB, 2005. Google ScholarDigital Library
- M. Rys, D. Chamberlin, and D. Florescu. XML and Relational Database Management Systems: the Inside Story. In Proc. of SIGMOD Conference, 2005.Google ScholarDigital Library
- Sparx system's uml to xml schema transformation. http://www.sparxsystems.com/resources/mda/xsd_transformation.html.Google Scholar
- M. Stonebraker and D. Moore. Object-Relational DBMSs: The Next Great Wave. Morgan Kaufmann, 1996. Google ScholarDigital Library
Index Terms
- Schema advisor for hybrid relational-XML DBMS
Recommendations
Constraint Preserving Transformation from Relational Schema to XML Schema
XML has become the standard for publishing and exchanging data on the Web. However, most business data is managed and will remain to be managed by relational database management systems. As such, there is an increasing need to efficiently and accurately ...
Bridging XML-schema and relational databases: a system for generating and manipulating relational databases using valid XML documents
DocEng '01: Proceedings of the 2001 ACM Symposium on Document engineeringMany organizations and enterprises establish distributed working environments, where different users need to exchange information based on a common model. XML is widely used to facilitate this information exchange. The extensibility of XML allows the ...
Translating relational schema into XML schema definition with data semantic preservation and XSD graph
Many legacy systems have been created by using relational database operating not for the Internet expression. Since the relational database is not an efficient way for data explosion, electronic transfer of data, and electronic business on the Web, we ...
Comments