ABSTRACT
A large amount of data needed in decision-making processes is stored in the XML data format, which is widely used for e-commerce and Internet-based information exchange. Thus, as more organizations view the web as an integral part of their communication and business, the importance of integrating XML data in data warehousing environments is becoming increasingly high. In this paper we show how the design of a data mart can be carried out starting directly from an XML source. Two main issues arise: on the one hand, since XML models semi-structured data, not all the information needed for design can be safely derived; on the other, different approaches for representing relationships in XML DTDs and Schemas are possible, each with different expressive power. After discussing these issues, we propose a semi-automatic approach for building the conceptual schema for a data mart starting from the XML sources.
- Abiteboul, S., Buneman, P., and Suciu, D. Data on the Web: From Relations to Semistructured Data and XML. Morgan Kaufman Publishers, 2000. Google ScholarDigital Library
- Cabibbo, L., and Torlone, R. A logical approach to multidimensional databases. In Proc. EDBT, 1998. Google ScholarDigital Library
- Datta, A., and Thomas, H. A conceptual model and algebra for on-line analytical processing in data warehouses. In Proc. WITS, 1997.Google Scholar
- Deutsch, A., Fernandez, M., Florescu, D., Levy, A., and Suciu, D. A Query Language for XML. In Proc. 8th World Wide Web Conference, 1999. Google ScholarDigital Library
- Florescu, D., and Kossmann, D. Storing and Querying XML Data using an RDBMS. IEEE Data Engineering Bulletin 22, 3, 1999.Google Scholar
- Franconi, E., and Sattler, U. A data warehouse conceptual model for multidimensional aggregation. In Proc. DMDW, 1999.Google Scholar
- Golfarelli, M., Maio, D., and Rizzi, S. The Dimensional Fact Model: a conceptual model for data warehouses. Int. Jour. of Cooperative Inf. Systems 7, 2&3, 1998.Google ScholarCross Ref
- Hüsemann, B., Lechtenbörger, J., and Vossen, G. Conceptual data warehouse design. In Proc. DMDW, 2000.Google Scholar
- Kimball, R. The data warehouse toolkit. John Wiley & Sons, 1996.Google ScholarDigital Library
- Lee, D., and Chu, W.W. Constraints-preserving Transformation from XML Document Type Definition to Relational Schema. In Proc. 19th ER (Salt Lake City), 2000. Google ScholarDigital Library
- Mannila, H., and Räihä, K.J. Algorithms for inferring functional dependencies. Data & Knowledge Engineering, 12, 1, 1994. Google ScholarDigital Library
- Savnik, I., and Flach, P. Bottom-up induction of functional dependencies from relations. In Piatesky-Shapiro (ed.), Knowledge Discovery in Databases, AAAI, 1993.Google Scholar
- Shanmugasundaram, J., et al. Relational Databases for Querying XML Documents: Limitations and Opportunities. In Proc. 25th VLDB (Edinburgh), 1999. Google ScholarDigital Library
- Vassiliadis, P. Modeling multidimensional databases, cubes and cube operations. In Proc. 10th SSDBM Conf. (Capri, Italy), 1998. Google ScholarDigital Library
- World Wide Web Consortium (W3C). XML 1.0 Specification. http://www.w3.org/TR/2000/REC-xml-20001006.Google Scholar
- World Wide Web Consortium (W3C). XML Schema. http://www.w3.org/XML/Schema.Google Scholar
- World Wide Web Consortium (W3C). Xpath Specification 1.0. http://www.w3.org/TR/xpath.Google Scholar
- World Wide Web Consortium (W3C). XQuery 1.0: An XML Query Language (Working Draft), http://www.w3.org/TR/xquery/.Google Scholar
Index Terms
- Data warehouse design from XML sources
Recommendations
A practical approach to extracting DTD-conforming XML documents from heterogeneous data sources
XML documents are becoming popular for business process integration. To achieve interoperability between applications, XML documents must also conform to various commonly used data type definitions (DTDs). However, most business data are not maintained ...
Mapping of bibliographical standards into XML
The most popular bibliographical standards, which prescribe the exchange of bibliographical data in machine readable form, are MARC (Machine Readable Cataloguing) and UNIMARC (Universal Machine Readable Cataloguing). This paper presents two schemas, ...
Semistructured data and XML
Information organization and databasesXML poses a new set of challenges for semistructured data research. The Extensible Markup Language, XML, is a new recommendation from World Wide Web Consortium that will become a universal data exchange format for the Web. XML shares many common ...
Comments