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
DynaMat: a dynamic view management system for data warehouses
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
A survey of logical models for OLAP databases
ACM SIGMOD Record
A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
A Foundation for Multi-dimensional Databases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
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
Conceptual multidimensional models
Multidimensional databases
YAM2: a multidimensional conceptual model extending UML
Information Systems
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Professional Microsoft SQL Server Analysis Services 2008 with MDX
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
Graphical querying of multidimensional databases
ADBIS'07 Proceedings of the 11th East European conference on Advances in databases and information systems
The planning OLAP model: a multidimensional model with planning support
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Extending the dimensional templates approach to integrate complex multidimensional design concepts
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
Hi-index | 0.00 |
Many models have been proposed for multidimensional data warehouse modeling and most consider a same function to determine how measure values are aggregated according to different data detail levels. We provide a conceptual model that supports (1) multiple aggregations, associating to the same measure a different aggregation function according to analysis axes, and (2) differentiated aggregation, allowing specific aggregations at each detail level. Our model is based on a graphical formalism that allows controlling the validity of aggregation functions (distributive, algebraic or holistic). We also show how conceptual modeling can be used, in an R-OLAP environment, for building lattices of pre-computed aggregates.