Abstract
The paper introduces different extended relational concepts to model and query OLAP data. In the first approach we will use the concept of nested relations
to model multi-dimensional OLAP-data.
In the second approach we will model OLAP by using the extended relational model which was introduced by Codd for
use in OLAP-modeling. The general requirements for all two
extended relational data models which could serve as a
foundation for multidimensional database systems, are
similar to those that made the relational model
successful, namely the existence of an implementation independent formalism, the separation of structure and
contents, and the existence of declarative query language.
All two approaches will be compared with the modeling
based on the traditional flat relations, which is widely
used in the OLAP-community, i.e. the modeling of
OLAP star and snow-flake schemas.
| Original language | English |
|---|---|
| Title of host publication | Proceedings of the Ninth International Database Conference "Heterogeneous and Internet Databases 1999" |
| Number of pages | 16 |
| Publication status | Published - 1999 |
Fields of science
- 102001 Artificial intelligence
- 102006 Computer supported cooperative work (CSCW)
- 102010 Database systems
- 102014 Information design
- 102015 Information systems
- 102016 IT security
- 102028 Knowledge engineering
- 102019 Machine learning
- 102022 Software development
- 102025 Distributed systems
- 502007 E-commerce
- 505002 Data protection
- 506002 E-government
- 509018 Knowledge management
- 202007 Computer integrated manufacturing (CIM)
- 102033 Data mining
- 102035 Data science
