A data model for supporting on-line analytical processing
CIKM '96 Proceedings of the fifth international conference on Information and knowledge management
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
A toolkit for negotiation support interfaces to multi-dimensional data
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
A dimensional modeling manifesto
DBMS - Special issue on data warehousing
A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
Database abstractions: aggregation and generalization
ACM Transactions on Database Systems (TODS)
A survey of logical models for OLAP databases
ACM SIGMOD Record
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Modeling Multidimensional Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Materialized Views Selection in a Multidimensional Database
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
What can Hierarchies do for Data Warehouses?
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
A Foundation for Multi-dimensional Databases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Normal Forms for Multidimensional Databases
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Extending the E/R Model for the Multidimensional Paradigm
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
Finding Your Way through Multidimensional Data Models
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Conceptual Design of Data Warehouses from E/R Schema
HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Implementing operations to navigate semantic star schemas
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
A UML-based data warehouse design method
Decision Support Systems
Solving summarizability problems in fact-dimension relationships for multidimensional models
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
Inferring aggregation hierarchies for integration of data marts
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
Improving the development of data warehouses by enriching dimension hierarchies with WordNet
ODBIS'05/06 Proceedings of the First and Second VLDB conference on Ontologies-based databases and information systems
Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS)
International Journal of Business Intelligence and Data Mining
Combining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems
Data & Knowledge Engineering
Enriching data warehouse dimension hierarchies by using semantic relations
BNCOD'06 Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling
Hi-index | 0.00 |
Data for decision-making applications are based on dimensions, such as time, customer, and product. These dimensions are naturally related by hierarchies. Hierarchies are crucial to multidimensional modeling. Defining hierarchies using star or snowflake schemas can be misleading, since they are not explicitly well-modeled. However, deriving them from conceptual UML or ER schemas is a non-trivial task since they have no direct equivalent in conceptual models. This paper focuses on the definition of multidimensional hierarchies. We present and illustrate rules for defining multidimensional hierarchies from UML schemas, especially based on aggregation and generalization hierarchies. The definition of hierarchies is part of a data warehouse design method based on the three usual modeling levels : conceptual, logical, and physical. The conceptual schema is based on the UML notation. The logical schema is represented using a unified pivot multidimensional model. The physical schema depends on the target ROLAP or MOLAP tool.