The data warehouse toolkit: practical techniques for building dimensional data warehouses
The data warehouse toolkit: practical techniques for building dimensional data warehouses
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
An object oriented approach to multidimensional database conceptual modeling (OOMD)
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
WAIM '00 Proceedings of the First International Conference on Web-Age Information Management
The GOLD Model: An OO Multidimensional Data Model for Multidimensional Databases
Proceedings of the Workshop on Object-Oriented Technology
th Workshop for PhD Students in Object Oriented Systems
ECOOP '02 Proceedings of the Workshops and Posters on Object-Oriented Technology
Multidimensional Modeling with UML Package Diagrams
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
A Framework for the Classification and Description of Multidimensional Data Models
DEXA '01 Proceedings of the 12th International Conference on Database and Expert Systems Applications
Finding Your Way through Multidimensional Data Models
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Conceptual multidimensional models
Multidimensional databases
YAM2: a multidimensional conceptual model extending UML
Information Systems
Hi-index | 0.00 |
Multidimensional modeling is nowadays recognized to best reflect the decision makers' analytical view on data. In this paper, we address some modeling features that we believe existing multidimensional models do not fully cover, such as considering real life entities that are meant to be analyzed as complex objects, allowing for simple and complex measures, treating facts and dimension members equally and observing hierarchies within and between complex entities. We propose a layered multidimensional model based on the concept of complex object which encapsulates data and structure complexity and eases the creation and manipulation of complex data cubes. We need to define our model at three layers. The first layer class diagram describes complex objects and captures the hierarchical organization of their attributes. The second layer package of classes describes the multidimensional model as a set of complex objects that are connected by relationships and some of which are organized in hierarchies. The third layer package of packages describes complex cubes which are derived from the multidimensional model. We show the benefits and feasibility of our proposals through their implementation in a real-life case study.