Abstract
The base fact tables of a data warehouse are generally of huge size. In order to shorten query response time and to improve maintenance performance, a base fact table is generally partitioned into multiple instances of same schema. To facilitate multidimensional data analysis, common methods are to create different multidimensional data models (MDDM) for different instances which may make it difficult to realize transparent multi-instance queries and maintenance. To resolve the problems, this paper proposes a logically integrated and physically distributed multidimensional data model.
Preview
Unable to display preview. Download preview PDF.
References
Venky Harinarayan, Anad Rajaraman, etc.: Implementing Data Cubes Efficiently, Proceedings of SIGMOD, (1996) 205–227.
Inderpal Singh Mumick, Dallan Quass etc.: Maintenance of Data Cubes and Summary Tables in a Warehouse, Proceedings of SIGMOD, (1997)100–111
C. A. Hurtado, A. O. Mendelzon, A. A. Vaisman: Maintaining Data Cubes under Dimension Updates. Proceedings of the 15th IEEE-ICDE 99.
E. Baralis, S. Paraboschi, E. Teniente: Materialized View Selection in a Multidimensional Database. Proceedings of the 23th International VLDB Conference. (1997)156–165.
A. Shukla, P. M. Deshpande, J. F. Naughton: Materialized View Selection for Multidimensional Datasets. Proceedings of the 24th International VLDB Conference. (1998)488–499.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lin, Y., Huang, H., Li, H. (2003). A Distributed Multidimensional Data Model of Data Warehouse. In: Wang, G., Liu, Q., Yao, Y., Skowron, A. (eds) Rough Sets, Fuzzy Sets, Data Mining, and Granular Computing. RSFDGrC 2003. Lecture Notes in Computer Science(), vol 2639. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-39205-X_112
Download citation
DOI: https://doi.org/10.1007/3-540-39205-X_112
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-14040-5
Online ISBN: 978-3-540-39205-7
eBook Packages: Springer Book Archive