Abstract
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.
The major problems addressed and solutions provided are: (1) a classification of DWH schema and instance heterogeneities at the fact and dimension level, (2) a methodology to combine independent data cubes taking into account the special characteristics of conceptual DWH schemata, i.e., OLAP dimension hierarchies and facts, and (3) a novel query language for bridging these heterogeneities in cross-DWH OLAP queries.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Lenzerini, M.: Data Integration: A Theoretical Perspective. In: Popa, L. (ed.) Proc. of PODS, pp. 233–246. ACM, New York (2002)
Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model:a Conceptual Model for Data Warehouses. Int.J.Cooperative Inf.Syst. (7), 215–247 (1998)
Vassiliadis, P., Sellis, T.K.: A Survey of Logical Models for OLAP Databases. SIGMOD Record (28), 64–69 (1999)
Schrefl, M., Thalhammer, T.: On Making Data Warehouses Active. In: Kambayashi, Y., Mohania, M., Tjoa, A.M. (eds.) DaWaK 2000. LNCS, vol. 1874, pp. 34–46. Springer, Heidelberg (2000)
International Organization for Standardization: (ISO/IEC 9075:1992: Information technology—Database languages—SQL)
Gingras, F., Lakshmanan, L.V.S.: nD-SQL: A Multi-dimensional Language for Interoperability and OLAP. In: Gupta, A., Shmueli, O., Widom, J. (eds.) VLDB, pp. 134–145. Morgan Kaufmann, San Francisco (1998)
Abelló, A., Samos, J., Saltor, F.: On Relationships Offering New Drill-across Possibilities. In: Theodoratos, D. (ed.) Proc. of DOLAP, pp. 7–13. ACM, New York (2002)
Hurtado, C., Gutiérrez, C., Mendelzon, A.: Capturing Summarizability with Integrity Constraints in OLAP. ACM Trans. Database Syst. (30), 854–886 (2005)
Cabibbo, L., Torlone, R.: Integrating Heterogeneous Multidimensional Databases. In: Frew, J. (ed.) Proc. of SSDBM, pp. 205–214 (2005)
Pedersen, D., Riis, K., Pedersen, T.B.: A Powerful and SQL-compatible Data Model and Query Language for OLAP. In: Zhou, X. (ed.) Australasian Database Conference. CRPIT, vol. (5) (2002)
Özsu, M.T., Valduriez, P.: Principles of Distributed Database Systems, 2nd edn. Prentice-Hall, Englewood Cliffs (1999)
Litwin, W., Mark, L., Roussopoulos, N.: Interoperability of Multiple Autonomous Databases. ACM Comput. Surv. (22), 267–293 (1990)
Sheth, A.P., Larson, J.A.: Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Comput. Surv.(̃22), 183–236 (1990)
Grant, J., Litwin, W., Roussopoulos, N., Sellis, T.K.: Query Languages for Relational Multidatabases. VLDB Journal (2), 153–171 (1993)
Litwin, W., Abdellatif, A., Zeroual, A., Nicolas, B., Vigier, P.: MSQL: A Multidatabase Language. Inf. Sci. (49), 59–101 (1989)
Suardi, L., Rusinkiewicz, M., Litwin, W.: Execution of Extended Multidatabase SQL. In: ICDE, pp. 641–650. IEEE Computer Society, Los Alamitos (1993)
Mullen, J.G., Elmagarmid, A.K.: InterSQL: A Multidatabase Transaction Programming Language. In: Beeri, C., Ohori, A., Shasha, D. (eds.) DBPL. Workshops in Computing, pp. 399–416. Springer, Heidelberg (1993)
Lakshmanan, L.V.S., Sadri, F., Subramanian, S.: SchemaSQL: An Extension to SQL for Multidatabase Interoperability. ACM Trans. Database Syst. (26), 476–519 (2001)
Torlone, R., Panella, I.: Design and Development of a Tool for Integrating Heterogeneous Data Warehouses. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 105–114. Springer, Heidelberg (2005)
Dehne, F., Eavis, T., Rau-Chaplin, A.: Parallel Querying of ROLAP Cubes in the Presence of Hierarchies. In: Song, I.Y., Trujillo, J. (eds.) Proc. of DOLAP, pp. 89–96. ACM Press, New York (2005)
Berger, S., Schrefl, M.: SQL-MDi Extended Syntax Reference. Technical report, available at http://www.dke.jku.at
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Berger, S., Schrefl, M. (2006). Analysing Multi-dimensional Data Across Autonomous Data Warehouses. In: Tjoa, A.M., Trujillo, J. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2006. Lecture Notes in Computer Science, vol 4081. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11823728_12
Download citation
DOI: https://doi.org/10.1007/11823728_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-37736-8
Online ISBN: 978-3-540-37737-5
eBook Packages: Computer ScienceComputer Science (R0)