The dimensional fact model: A conceptual model for data warehouses

International Journal of Cooperative Information Systems

Volumn 7, Issue 2-3, 1998, Pages 215-247

  Golfarelli, Matteo ^a   Maio, Dario ^a   Rizzi, Stefano ^a  

^a UNIVERSITY OF BOLOGNA   (Italy)

Author keywords

Conceptual models; Data warehouse; Entity relationship model; Multidimensional data model

Indexed keywords

EID: 0006822834     PISSN: 02188430     EISSN: None     Source Type: Journal    
DOI: 10.1142/s0218843098000118     Document Type: Article

References (16)

1. R. Agrawal, A. Gupta and S. Sarawagi, Modeling multidimensional databases, IBM Research Report, IBM Almaden Research Center, 1995.
2. E. Baralis, S. Paraboschi and E. Teniente, Materialized view selection in multidimensional database, Proc. 23rd Int. Conf. on Very Large Data Bases, Athens, Greece, 1997, 156-165.
3. R. Barquin and S. Edelstein, Planning and Designing the Data Warehouse (Prentice Hall, 1996).
4. L. Cabibbo and R. Torlone, A logical approach to multidimensional databases, eds. H. J. Schek, F. Saltor, I. Ramos, G. Alonso, Advances in DB technology - EDBT 98 (LNCS 1377, Springer, 1998), 183-197.
5. S. Chaudhuri and U. Dayal, An overview of data warehousing and OLAP technology, SIGMOD Record 26, 1 (1997) 65-74.
6. S. Chaudhuri and K. Shim, Including group-by in query optimization, Proc. 20th Int. Conf. on Very Large Data Bases, 1994, 354-366.
7. G. Colliat, OLAP, Relational and multidimensional database systems, SIGMOD Record 25, 3 (1996) 64-69.
8. C. Fahrner and G. Vossen, A survey of database transformations based on the entity-relationship model, Data and Knowledge Engineering 15, 3 (1995) 213-250.
9. U. M. Fayyad, G. Piatetsky-Shapiro and P. Smyth, Data mining and knowledge discovery in databases: An overview, Comm. ACM 39, 11, 1996.
10. M. Golfarelli, D. Maio and S. Rizzi, Conceptual design of data warehouses from E/R schemes, Proc. Hawaii Int. Conf. on System Sciences, Kona, Hawaii, 1998, 334-343.
11. J. Gray, A. Bosworth, A. Lyman and H. Pirahesh, Data-cube: A relational aggregation operator generalizing group-by, cross-tab and sub-totals, Technical Report MSR-TR-95-22, Microsoft Research, 1995.
12. A. Gupta, V. Harinarayan and D. Quass, Aggregate-query processing in data-warehousing environments, Proc. 21th Int. Conf. on Very Large Data Bases, Zurich, Switzerland, 1995.
13. H. Gupta, V. Harinarayan and A. Rajaraman, Index selection for OLAP, Proc. Int. Conf. Data Engineering, Binghamton, UK, 1997.
14. M. Gyssens and L. V. S. Lakshmanan, A foundation for multi-dimensional databases, Proc. 23rd Int. Conf. on Very Large Data Bases, Athens, Greece, 1997, 106-115.
15. V. Harinarayan, A. Rajaraman and J. Ullman, Implementing data cubes efficiently, Proc. ACM Sigmod Conf., Montreal, Canada, 1996.
16. T. Johnson and D. Shasha, Hierarchically split cube forests for decision support: Description and tuned design, Bullettin of Technical Committee on Data Engineering 20, 1, 1997.