Extending the dimensional templates approach to integrate complex multidimensional design concepts

Authors:
Rui Oliveira;Fátima Rodrigues;Paulo Martins;João Paulo Moura
Affiliations:
Informatics Department, School of Technology and Management, Polytechnic Institute of Leiria, Portugal;GECAD-Knowledge Engineering and Decision Support Research Center Informatics Engineering Dept., School of Engineering, Polytechnic Inst. of Porto, Portugal;GECAD-Knowledge Engineering and Decision Support Research Center Informatics Engineering Dept., University of Trás-os-Montes e Alto Douro, Portugal;GECAD-Knowledge Engineering and Decision Support Research Center Informatics Engineering Dept., University of Trás-os-Montes e Alto Douro, Portugal
Venue:
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Year:
2011

Citing 7
Cited 1

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
A Method for Demand-Driven Information Requirements Analysis in Data Warehousing Projects

HICSS '03 Proceedings of the 36th Annual Hawaii International Conference on System Sciences (HICSS'03) - Track 8 - Volume 8
A UML-based data warehouse design method

Decision Support Systems
Automating multidimensional design from ontologies

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
GRAnD: A goal-oriented approach to requirement analysis in data warehouses

Decision Support Systems
A model driven modernization approach for automatically deriving multidimensional models in data warehouses

ER'07 Proceedings of the 26th international conference on Conceptual modeling

Differentiated multiple aggregations in multidimensional databases

DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery

Quantified Score

Hi-index	0.00

Visualization

Abstract

In the past, several approaches have been devised to semiautomate the multidimensional design (MDD) of Data Warehouse (DW) projects. Such approaches highly contribute to more expertiseindependent and deterministic MDD results. Among them, only the Dimensional Templates Approach (DTA) focuses on solving the critical resource containment problems of DW prototypes. Originally, the DTA allows solely the generation of basic MDDs. In this paper, we depict an extension to address complex MDD issues. These include (i) date/time hierarchies, (ii) many-to-many relationships, (iii) hierarchically structured data and (iv) coverage facts. The proposed enhancements, including a rebuilt generation algorithm, allow more accurate and broadening results than the original DTA. Throughout the paper, references are made to a real case study to which the improved DTA has been applied using two developed prototype tools.