Data Warehouse Design: A Schema-Transformation Approach
SCCC '02 Proceedings of the XII International Conference of the Chilean Computer Science Society
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
Extending visual OLAP for handling irregular dimensional hierarchies
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Schema design alternatives for multi-granular data warehousing
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
Hi-index | 0.00 |
Hierarchies represent substantial part of the multidimensional view of data based on exploring measures of facts for business or non-business domain along various dimensions. In data warehousing and on-line analytical processing they provide for examining data at different levels of detail. Several types of hierarchies have been presented with issues concerning dependencies and summarizability of data along the levels. Design mechanism for implementation of dimensional hierarchies in datawarehouse logical scheme has been proposed. Algorithms for enforcing dependencies on dimensional hierarchies for achieving correct summarizability of data have been developed. An implementation of the algorithms as procedures in logical scheme's metadata has been presented.