Analysing Multi-dimensional Data Across Autonomous Data Warehouses

Business cooperations frequently require to analyse data across enterprises, where there is no central authority to combine and manage cross-enterprise data. Thus, rather than integrating independent data warehouses into a Distributed Data Warehouse (DDWH) for cross-enterprise analyses, this paper introduces a multi data warehouse OLAP language for integrating, combining, and analysing data from several, independent data warehouses (DWHs). The approach may be best compared to multi-database query languages for database integration. The key difference to these prior works is that they do not consider the multi-dimensional organisation of data warehouses.

[1]  Luca Cabibbo,et al.  Integrating Heterogeneous Multidimensional Databases , 2005, SSDBM.

[2]  Timos K. Sellis,et al.  Query languages for relational multidatabases , 1993, The VLDB Journal.

[3]  Maurizio Lenzerini,et al.  Data integration: a theoretical perspective , 2002, PODS.

[4]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[5]  Andrew Rau-Chaplin,et al.  Parallel querying of ROLAP cubes in the presence of hierarchies , 2005, DOLAP '05.

[6]  Laks V. S. Lakshmanan,et al.  nD-SQL: A Multi-Dimensional Language for Interoperability and OLAP , 1998, VLDB.

[7]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[8]  Patrick Valduriez,et al.  Principles of Distributed Database Systems, Second Edition , 1999 .

[9]  Riccardo Torlone,et al.  Design and Development of a Tool for Integrating Heterogeneous Data Warehouses , 2005, DaWaK.

[10]  Laks V. S. Lakshmanan,et al.  SchemaSQL: An extension to SQL for multidatabase interoperability , 2001, ACM Trans. Database Syst..

[11]  A. Zeroual,et al.  MSQL: A Multidatabase Language , 1989, Inf. Sci..

[12]  Marek Rusinkiewicz,et al.  Execution of extended multidatabase SQL , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[13]  Ahmed K. Elmagarmid,et al.  InterSQL: A Multidatabase Transaction Programming Language , 1993, DBPL.

[14]  José Samos,et al.  On relationships offering new drill-across possibilities , 2002, DOLAP '02.

[15]  Nick Roussopoulos,et al.  Interoperability of multiple autonomous databases , 1990, CSUR.

[16]  Timos K. Sellis,et al.  A survey of logical models for OLAP databases , 1999, SGMD.

[17]  Torben Bach Pedersen,et al.  A Powerful and SQL-Compatible Data Model and Query Language for OLAP , 2002, Australasian Database Conference.

[18]  Alberto O. Mendelzon,et al.  Capturing summarizability with integrity constraints in OLAP , 2005, TODS.

[19]  Michael Schrefl,et al.  On Making Data Warehouses Active , 2000, DaWaK.