Model-Driven Metadata for OLAP Cubes from the Conceptual Modelling of Data Warehouses

Authors:
Jesús Pardillo;Jose-Norberto Mazón;Juan Trujillo
Affiliations:
Lucentia Research Group, Department of Software and Computing Systems, University of Alicante, Spain;Lucentia Research Group, Department of Software and Computing Systems, University of Alicante, Spain;Lucentia Research Group, Department of Software and Computing Systems, University of Alicante, Spain
Venue:
DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
Year:
2008

Citing 15
Cited 6

An overview of data warehousing and OLAP technology

ACM SIGMOD Record
Object-oriented data warehouse design: building a star schema

Object-oriented data warehouse design: building a star schema
Automatically generating OLAP schemata from conceptual graphical models

Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Hand-OLAP: A System for Delivering OLAP Services on Handheld Devices

ISADS '03 Proceedings of the The Sixth International Symposium on Autonomous Decentralized Systems (ISADS'03)
Building the Data Warehouse

Building the Data Warehouse
YAM2: a multidimensional conceptual model extending UML

Information Systems
Research in data warehouse modeling and design: dead or alive?

DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
A UML profile for multidimensional modeling in data warehouses

Data & Knowledge Engineering - Special issue: ER 2003
A UML-based data warehouse design method

Decision Support Systems
OLAP preferences: a research agenda

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
An MDA approach for the development of data warehouses

Decision Support Systems
Towards the Automatic Generation of Analytical End-User Tools Metadata for Data Warehouses

BNCOD '08 Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge
Model driven engineering: an emerging technical space

GTTSE'05 Proceedings of the 2005 international conference on Generative and Transformational Techniques in Software Engineering
Integrating clustering data mining into the multidimensional modeling of data warehouses with UML profiles

DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery

Designing Data Warehouses for Geographic OLAP Querying by Using MDA

ICCSA '09 Proceedings of the International Conference on Computational Science and Its Applications: Part I
A Conceptual Modeling Approach for OLAP Personalization

ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
A family of experiments to validate measures for UML activity diagrams of ETL processes in data warehouses

Information and Software Technology
Model driven data warehouse using MDA and 2TUP

Journal of Computational Methods in Sciences and Engineering - Special Supplement Issue in Section A and B: Selected Papers from the ISCA International Conference on Software Engineering and Data Engineering, 2009
RETRACTED: Model-driven development of OLAP metadata for relational data warehouses

Computer Standards & Interfaces
Modeling data warehouse schema evolution over extended hierarchy semantics

Journal on Data Semantics XIII

Quantified Score

Hi-index	0.00

Visualization

Abstract

The development of a data warehouse is based on the definition of a conceptual multidimensional model. This model is used to obtain the required database metadata for implementing the data- warehouse repository. Surprisingly, current approaches for multidimensional modelling overlook the necessity of generating additional data-cube metadata to allow end-user tools to query the data warehouse. To overcome this situation, we propose an approach based on "model-driven engineering" techniques in order to automatically derive both kinds of metadata in a systematic and integrated way. Specifically, in this paper, we describe how to obtain the data-cube metadata for "on-line analytical processing" (OLAP) tools. As a proof of concept, our approach has been implemented in the Eclipsedevelopment platform, thus showing its feasibility.