Abstract
On-Line Analytical Processing (OLAP) systems based on multidimensional databases are essential elements of decision support. However, most existing data is stored in ordinary relational OLTP databases, i.e., data has to be (re-) modeled as multidimensional cubes before the advantages of OLAP tools are available. In this paper we present an approach for the automatic construction of multidimensional OLAP database schemas from existing relational OLTP databases, enabling easy OLAP design and analysis for most existing data sources. This is achieved through a set of practical and effective algorithms for discovering multidimensional schemas from relational databases. The algorithms take a wide range of available metadata into account in the discovery process, including functional and inclusion dependencies, and key and cardinality information.
| Originalsprog | Engelsk |
|---|---|
| Titel | Proceedings of the Sixth International Conference on Data Warehousing and Knowledge Discovery : Lecture Notes in Computer Science |
| Redaktører | Yahiko Kambayashi, Mukesh K. Mohania, and Wolfram Wöß |
| Forlag | IEEE Computer Society Press |
| Publikationsdato | 2004 |
| Udgave | 3181 |
| Sider | 138-148 |
| ISBN (Trykt) | 35402293X |
| Status | Udgivet - 2004 |
| Begivenhed | Sixth International Conference on Data Warehousing and Knowledge Discovery (DAXA'04) - Zaragoza, Spanien Varighed: 30 aug. 2004 → 3 sep. 2004 Konferencens nummer: 6 |
Konference
| Konference | Sixth International Conference on Data Warehousing and Knowledge Discovery (DAXA'04) |
|---|---|
| Nummer | 6 |
| Land/Område | Spanien |
| By | Zaragoza |
| Periode | 30/08/2004 → 03/09/2004 |