Download:
by Enrico Franconi
In Proc. 5th International Conference on Data Warehousing and Knowledge Discovery
http://www.cs.man.ac.uk/~franconi/papers/dmdw-02.pdf
Add To MetaCart
Abstract:
In this short abstract we introduce a novel data model for multidimensional informa-tion, GMD, generalising the MD data model first proposed in [Cabibbo and Torlone, 1998]. The aim of this work is not to propose yet another data model, but to find the most general formalism encompassing all the proposals for a logical data model in the data warehouse field, as for example summarised in [Vassiliadis and Sellis, 1999]. Our proposal is compatible with all these proposals, making therefore possible a formal com-parison of the different expressivities of the models in the literature. In this first proposal we concentrate only on the logical model, disregarding a possible algebra built on top of the basic types; this will be the necessary next step of our research. Still, we believe that the GMD data model is already very useful in its current form, since it provides a very precise and, we believe, very elegant and uniform way to model multidimensional infor-mation. For example, interestingly enough, GMD reduces as expected to the standard relational model for dimensionless information; and obviously the star and the snowflake schemas (together with their variants) can be encoded as GMD schemas. It turns out that most of the proposals in the literature make many hidden assumptions which may
Citations
|
507
|
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals
– Gray, Bosworth, et al.
- 1996
|
|
260
|
The data warehouse toolkit
– Kimball
- 1996
|
|
203
|
An overview of data warehousing and OLAP technology
– Chaudhuri, Dayal
- 1997
|
|
106
|
Modeling multidimensional databases
– Agrawal, Gupta, et al.
- 1997
|
|
84
|
A foundation for multi-dimensional databases
– Gyssens, Lakshmanan
- 1997
|
|
79
|
A logical approach to multidimensional databases
– Cabibbo, Torlone
- 1998
|
|
65
|
The Dimensional Fact Model: A Conceptual Model for Data Warehouses
– Golfarelli, Maio
- 1998
|
|
56
|
OLAP and statistical databases: similarities and differences
– Shoshani
|
|
47
|
Sellis: A survey of logical models for OLAP Databases
– Vassiliadis, T
- 1999
|
|
37
|
Modeling multidimensional databases, cubes and cube operations
– Vassiliadis
- 1998
|
|
34
|
A data warehouse conceptual data model for multidimensional aggregation: a preliminary report
– Franconi, Sattler
|
|
12
|
Understanding Analysis Dimensions in a Multidimensional Object-Oriented Model
– Abello, Samos, et al.
- 2001
|
|
11
|
Conceptual data modeling for OLAP
– MAC
- 2001
|
|
9
|
Efficient implementation of data cubes via materialized views
– Ullman
- 1996
|
|
8
|
Multidimensional data models and aggregation
– Franconi, Baader, et al.
|
|
5
|
Modelling and optimisation issues for multidimensional databases
– Vassiliadis, Skiadopoulos
- 2000
|
|
1
|
Modelling and optimisation isues for multidimensional databases
– Vassiliadis, Skiadopoulos
- 2000
|