Object-oriented systems analysis: a model-driven approach
Object-oriented systems analysis: a model-driven approach
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals
Data Mining and Knowledge Discovery
Extending Practical Pre-Aggregation in On-Line Analytical Processing
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
From a Procedural to a Visual Query Language for OLAP
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Finding Your Way through Multidimensional Data Models
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
The Eyes Have It: A Task by Data Type Taxonomy for Information Visualizations
VL '96 Proceedings of the 1996 IEEE Symposium on Visual Languages
Advanced visualization for OLAP
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
Implementing operations to navigate semantic star schemas
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
An analysis of additivity in OLAP systems
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Ontology based object-oriented domain modelling: fundamental concepts
Requirements Engineering
On the architectural alignment of ATL and QVT
Proceedings of the 2006 ACM symposium on Applied computing
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
Efficient approaches for materialized views selection in a data warehouse
Information Sciences: an International Journal
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
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
Data warehouse enhancement: A semantic cube model approach
Information Sciences: an International Journal
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
An MDA approach for the development of data warehouses
Decision Support Systems
Information Sciences: an International Journal
Bridging the semantic gap in OLAP models: platform-independent queries
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
A UML profile for the conceptual modelling of data-mining with time-series in data warehouses
Information and Software Technology
An index selection method without repeated optimizer estimations
Information Sciences: an International Journal
Incremental integrity checking of UML/OCL conceptual schemas
Journal of Systems and Software
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
Using UML/OCL constraints for relational database design
UML'99 Proceedings of the 2nd international conference on The unified modeling language: beyond the standard
Graphical querying of multidimensional databases
ADBIS'07 Proceedings of the 11th East European conference on Advances in databases and information systems
A model-driven goal-oriented requirement engineering approach for data warehouses
ER'07 Proceedings of the 2007 conference on Advances in conceptual modeling: foundations and applications
Model driven engineering: an emerging technical space
GTTSE'05 Proceedings of the 2005 international conference on Generative and Transformational Techniques in Software Engineering
On the need of a reference algebra for OLAP
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
Information Sciences: an International Journal
A labeled-tree approach to semantic and structural data interoperability applied in hydrology domain
Information Sciences: an International Journal
Specifying aggregation functions in multidimensional models with OCL
ER'10 Proceedings of the 29th international conference on Conceptual modeling
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Monitoring strategic goals in data warehouses with awareness requirements
Proceedings of the 27th Annual ACM Symposium on Applied Computing
Towards ontology-based OLAP: datalog-based reasoning over multidimensional ontologies
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Conceptualizing and specifying key performance indicators in business strategy models
CASCON '12 Proceedings of the 2012 Conference of the Center for Advanced Studies on Collaborative Research
Using OCL for automatically producing multidimensional models and ETL processes
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
Multi-dimensional navigation modeling using BI analysis graphs
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Conceptualizing and specifying key performance indicators in business strategy models
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
Expert Systems with Applications: An International Journal
Hi-index | 0.07 |
The development of data warehouses begins with the definition of multidimensional models at the conceptual level in order to structure data, which will facilitate decision makers with an easier data analysis. Current proposals for conceptual multidimensional modelling focus on the design of static data warehouse structures, but few approaches model the queries which the data warehouse should support by means of OLAP (on-line analytical processing) tools. OLAP queries are, therefore, only defined once the rest of the data warehouse has been implemented, which prevents designers from verifying from the very beginning of the development whether the decision maker will be able to obtain the required information from the data warehouse. This article presents a solution to this drawback consisting of an extension to the object constraint language (OCL), which has been developed to include a set of predefined OLAP operators. These operators can be used to define platform-independent OLAP queries as a part of the specification of the data warehouse conceptual multidimensional model. Furthermore, OLAP tools require the implementation of queries to assure performance optimisations based on pre-aggregation. It is interesting to note that the OLAP queries defined by our approach can be automatically implemented in the rest of the data warehouse, in a coherent and integrated manner. This implementation is supported by a code-generation architecture aligned with model-driven technologies, in particular the MDA (model-driven architecture) proposal. Finally, our proposal has been validated by means of a set of sample data sets from a well-known case study.