A logical approach to multidimensional databases
Author(s) -
Luca Cabibbo,
Riccardo Torlone
Publication year - 1998
Publication title -
lecture notes in computer science
Language(s) - English
Resource type - Book series
SCImago Journal Rank - 0.249
H-Index - 400
eISSN - 1611-3349
pISSN - 0302-9743
DOI - 10.1007/bfb0100985
Subject(s) - online analytical processing , computer science , multidimensional data , database , logical data model , relational database , database design , database model , relational model , multidimensional systems , scheme (mathematics) , multidimensional analysis , data mining , data warehouse , data modeling , mathematics , mathematical analysis , statistics
In this paper we present MD, a logical model for OLAP systems, and show how it can be used in the design of multidimensional databases. Unlike other models for multidimensional databases, MD is independent of any specific implementation (relational or proprietary multidimensional) and as such it provides a clear separation between practical and conceptual aspects. In this framework, we present a design methodology, to obtain an MD scheme from an operational database. We then show how an MD database can be implemented, describing translations into relational tables and into multidimensional arrays.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom