Abstract
In this paper we present a conceptual and dimensional level of modelling data warehouses. A four-level architecture is proposed and the conceptual and dimensional levels are discussed in detail. A dimensional model based on dimension tables and fact tables is developed. Some new aspects of dimensional modelling, which extend the previous approaches, are shown, e.g. query constraints and ISA-hierarchies combined with dimension hierarchies.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Literature
AgrawalR., Gupta A., Sarawagi S. Modeling Multidimensional Databases, Research Report, IBM Almaden Research Centre, San Jose, California, 1995, Also in: Proceeding of ICDE’97
Buytendijk F.A. Multidimensional Data Analysis for OLAP. April 1996
Chaudhuri S., Dayal U. An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record 26(1), March, 1997
Cabibbo L., Torlone R. A logical Approach to Multidimensional Databases. Proc. of 6th Int. Conf. on Extended Database Technology, Valencia, 1998
Gyssens M., Lakshmanan V.S., Subramanian I.N. Tables As a Paradigm for Querying and Restructuring. Proc. ACM Symp. on Principles of Database Systems, Montreal, 1996
Golfarelli M., Maio D., Rizzi S. Conceptual Design of Data Warehouses from E/R Schemes. Proc. of the Hawaii Int. Conference on System Sciences, 1998, Kona, Hawaii, 1998
Kimball R. The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Willey, 1996
Kimball R. A Dimensional Manifesto. DBMS, August 1997
Lehner W. Modeling Large Scale OLAP Scenarios, 6th International Conference on Extending Database Technology (EDBT’98), Valencia, Spain, 23–27, March, 1998
Li Ch., Wang X.S. A Data model for Supporting On-Line Analytical Processing. Proc. Of Conf. On Integration and Knowledge Management, November, 1996, pp. 81–88
McGuff F. Data Modeling for Data Warehouses, http://members.aol.com/fmcguff/dwmodel, 1996
Pokorny J. Conceptual modelling of statistical data. Proc. of Int. Conf. DEXA’96, Zurich, 1996, pp 377–382
Pokorny J. Conceptual modelling in OLAP. Proc. of the ECIS’98 Conf., Aix-en-Provence, 1998, pp. 273–288
Pokorny J. Data Warehouses: a Modelling Perspective. In: Wojtkowski W.G., Wrycza S., Zupancic J. (eds.) Evolution and Challenges in System Development, Proc. of 7th Int. Conf. on Information Systems, Bled, Slovenia, 1998 (to appear in Plenum Press, January 1999 )
Raden N. Modelling the Data Warehouse. Archer Decision Sciences, Inc., 1995
Raden N. Star schema 101. http://www.netmar.com/nraden/strl01_q.htm
Red Brick: Star Schemas and STARjoinTM Technology™. White paper, 1996
Shoshani A. OLAP and Statistical Databases_ Similarity and Differences. In: 16th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, (PODS 97), Tuscon, 1997, pp. 185–196
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag London Limited
About this paper
Cite this paper
Pokorný, J. (1999). To the Stars through Dimensions and Facts. In: Abramowicz, W., Orlowska, M.E. (eds) BIS ’99. Springer, London. https://doi.org/10.1007/978-1-4471-0875-7_12
Download citation
DOI: https://doi.org/10.1007/978-1-4471-0875-7_12
Publisher Name: Springer, London
Print ISBN: 978-1-85233-167-2
Online ISBN: 978-1-4471-0875-7
eBook Packages: Springer Book Archive