XCube: XML for data warehouses

ABSTRACT

Data warehouse systems are nowadays a well known and widely spread approach for supporting management decisions. In several companies or even across companies the idea of integrating several data warehouses into a virtual or federated data warehouse is of growing interest. But the technical and semantic problems are very demanding. An essential part for solving this problem is a standardized, vendor independent format for describing multidimensional data. This paper introduces XCube, a family of XML based document templates to exchange data warehouse data, i. e. data cubes, over any kind of network. XCube is organized in a modular fashion, so the multidimensional schema, the descriptions of the single dimensions and the fact data itself can be transmitted in separate steps. In addition to the describing formats XCube also offers two kinds of dynamic document types that can be used to explore the (multidimensional) content of another warehouse in a vendor independent way. They are primarily meant to reduce the amount of data transferred over the network.

REFERENCES

• 1: Bray, T.; Paoli, J.; Sperberg- McQueen, C. M.; Maler, E.: Extensible Markup Language (XML) 1.0 (Second Edition) W3C Recommendation 6 October 2000 http://www.w3org/TR/REC-xml
• 2: Fallside, D. C.: XML Schema Part 0: Primer W3C Recommendation 2 May 2001 http://www.w3.org/TR/xmlschema-0/
• 3: Jarke, M.; Jeusfeld, M. A.; Quix, C.; Vassiliadis, P.: Architecture and Quality in Data Warehouses: An extended Repository Approach. In: Information Systems, 24(3), 1999.
• 4: David S. Linthicum, Enterprise application integration, Addison-Wesley Longman Ltd., Essex, UK, 2000
• 5: Linthicum, D. S.: B2B Application Integration. AddisonWesley, Boston, 2001.
• 6: http://www.xcube-open.org
• 7: Bourret, R.: XML Database Products. 2003 http://www.rpbourret.com/xml/XMLDatabaseProds.htm
• 8: Clarke, J.: XSL Transformations (XSLT) Version 1.0 W3C Recommendation, 16 November 1999 http://www.w3.org/TR/xslt
• 9: DeRose, S.; Maler, E.; Orchard, D.: XML Linking Language (XLink) Version 1.0 W3C Recommendation 27 June 2001 http://www.w3. rg/TR/xlink/
• 10: Grosso, P.; Maler, E.; Marsh, J.; Walsh, N.: XPointer Framework W3C Recommendation 25 March 2003 http://www.w3.org/TR/2003/REC-xptr-framework20030325/
• 11: J. Albrecht , A. Bauer , O. Deyerling , H. Günzel , W. Hümmer , W. Lehner , L. Schlesinger, Management of Multidimensional Aggregates for Efficient Online Analytical Processing, Proceedings of the 1999 International Symposium on Database Engineering & Applications, p.156, August 02-04, 1999
• 12: Sapia, C.; Blaschka, M.; Höfling, G.; Dinter, B.: Extending the E/ R Model for the Multidimensional Paradigm. In: Advances in Database Technologies, Lecture Notes in Computer Science, Vol. 1552, Springer, Heidelberg, 1999.
• 13: Herden, O.; Harren, A.: MML und mUML -- Sprache und Werkzeug zur Unterstützung des konzeptionellen Data Warehouse-Designs. In: DMDW, Magdeburg, Germany, 1999.
• 14: N. N.: Common Warehouse Metamodel (CWM) Specification. Version 1.0, OMG, 2001 http://www.omg.org/docs/ad/01-02-01.pdf
• 15: http://www.omg.org
• 16: John Poole , David Mellor, Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration, John Wiley & Sons, Inc., New York, NY, 2001
• 17: Nguyen, T. B.; Tjoa, A. M.; Mangisengi, O.: MetaCube-X: An XML Metadata Foundation for Interoperability Search among Web Warehouses. In: DMDW, Interlaken, Switzerland, 2001.
• 18: N. N.: XML for Analysis Specification. Version 1.0. Microsoft Corporation, Hyperion Solutions Corporation, 2001 http://xmla.org/download.asp?id=2
• 19: http://xmla.org
• 20: Harde, G.: XML Schemata for XCubeSchema, version 0.4. 2002 http://www.xcube-open.org/V0_4/XCubeSchema.xcsd
• 21: Harde, G.: Basic XML Schemata for XCubeDimension, version 0.4. 2002 http://www.xcube-open.org/V0_4 XCubeDimension.xcsd
• 22: Hümmer, W.; Lehner, W.; Bauer, A.; Schlesinger, L.: A Decathlon in Multidimensional Modeling: Open Issues and Some Solutions. In: DAWAK, Aix-en-Provence, France, 2002.
• 23: Harde, G.: Basic XML Schemata for XCubeFact, version 0.4. 2002 http://www.xcube-open.org/V0_4/XCubeFact.xcsd
• 24: Harde, G.: XML Schemata for XCubeText, version 0.4. 2002 http://www.xcube-open.org/V0_4/XCubeText.xcsd
• 25: Harde, G.: XML Schemata for XCubeQuery, version 0.4. 2002 http://www.xcube-open.org/V0_4/XCubeQuery.xcsd
• 26: http://www.w3.org/2002/ws/
• 27: Kimball, R.; Ross, M.: The Datawarehouse Toolkit, 2 nd ed. John Wiley & Sons, Chichester, 2002.
• 28: N.N.: TPC Benchmark H (Decision Support) Standard Specification, Revision 2.0.0. Transaction Processing Performance Council, 2002 http://www.tpc.org/tpch/spec/tpch2.0.0.pdf

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages
          Subjects: Data description languages (DDL)

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages
          Subjects: Query languages
      H.2.7 Database Administration
          Subjects: Data warehouse and repository

General Terms:
Design, Languages, Management, Standardization

Keywords:
based on XML documents, between data warehouses, exchange of data cubes