On the complexity of inferring functional dependencies
Discrete Applied Mathematics - Special issue on combinatorial problems in databases
Closest pair queries in spatial databases
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Modeling Multidimensional Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
Normal Forms for Multidimensional Databases
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
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
Multidimensional normal forms for data warehouse design
Information Systems
Transforming an Operational System Model to a Data Warehouse Model: A Survey of Techniques
SWSTE '05 Proceedings of the IEEE International Conference on Software - Science, Technology & Engineering
Goal-oriented requirement analysis for data warehouse design
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
YAM2: a multidimensional conceptual model extending UML
Information Systems
GORDIAN: efficient and scalable discovery of composite keys
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
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-based data warehouse design method
Decision Support Systems
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
Automating multidimensional design from ontologies
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Functional dependencies distorted by errors
Discrete Applied Mathematics
An MDA approach for the development of data warehouses
Decision Support Systems
Discovering functional dependencies for multidimensional design
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Multidimensional design by examples
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
On the need of a reference algebra for OLAP
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
Using ontologies to discover fact IDs
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Multiversion data warehouse constraints
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
GEM: requirement-driven generation of ETL and multidimensional conceptual designs
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Describing analytical sessions using a multidimensional algebra
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
A comprehensive framework on multidimensional modeling
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Hybrid methodology for data warehouse conceptual design by UML schemas
Information and Software Technology
ORE: an iterative approach to the design and evolution of multi-dimensional schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Requirement-driven creation and deployment of multidimensional and ETL designs
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
ProtOLAP: rapid OLAP prototyping with on-demand data supply
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
| Hi-index | 0.00 |
It is widely accepted that the conceptual schema of a data warehouse must be structured according to the multidimensional model. Moreover, it has been suggested that the ideal scenario for deriving the multidimensional conceptual schema of the data warehouse would consist of a hybrid approach (i.e., a combination of data-driven and requirement-driven paradigms). Thus, the resulting multidimensional schema would satisfy the end-user requirements and would be conciliated with the data sources. Most current methods follow either a data-driven or requirement-driven paradigm and only a few use a hybrid approach. Furthermore, hybrid methods are unbalanced and do not benefit from all of the advantages brought by each paradigm. In this paper we present our approach for multidimensional design. The most relevant step in our framework is Multidimensional Design by Examples (MDBE), which is a novel method for deriving multidimensional conceptual schemas from relational sources according to end-user requirements. MDBE introduces several advantages over previous approaches, which can be summarized as three main contributions. (i) The MDBE method is a fully automatic approach that handles and analyzes the end-user requirements automatically. (ii) Unlike data-driven methods, we focus on data of interest to the end-user. However, the user may not be aware of all the potential analyses of the data sources and, in contrast to requirement-driven approaches, MDBE can propose new multidimensional knowledge related to concepts already queried by the user. (iii) Finally, MDBE proposes meaningful multidimensional schemas derived from a validation process. Therefore, the proposed schemas are sound and meaningful.