starER: a conceptual model for data warehouse design
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Synthesizing third normal form relations from functional dependencies
ACM Transactions on Database Systems (TODS)
Requirements engineering in the year 00: a research perspective
Proceedings of the 22nd international conference on Software engineering
Building the Data Warehouse,3rd Edition
Building the Data Warehouse,3rd Edition
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Normal Forms for Multidimensional Databases
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
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
Towards Modeling and Reasoning Support for Early-Phase Requirements Engineering
RE '97 Proceedings of the 3rd IEEE International Symposium on Requirements Engineering
Multidimensional normal forms for data warehouse design
Information Systems
Modelling strategic relationships for process reengineering
Modelling strategic relationships for process reengineering
Information requirements engineering for data warehouse systems
Proceedings of the 2004 ACM symposium on Applied computing
MDA Distilled
Goal-oriented requirement analysis for data warehouse design
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Applying MDA to the development of data warehouses
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
MDA transformations applied to web application development
ICWE'05 Proceedings of the 5th international conference on Web Engineering
Solving summarizability problems in fact-dimension relationships for multidimensional models
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
Measures for ETL processes models in data warehouses
Proceedings of the first international workshop on Model driven service engineering and data quality and security
Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses
Information Sciences: an International Journal
ER'07 Proceedings of the 26th international conference on Conceptual modeling
A UML profile for modeling data warehouse usage
ER'07 Proceedings of the 2007 conference on Advances in conceptual modeling: foundations and applications
Automatic validation of requirements to support multidimensional design
Data & Knowledge Engineering
Information and Software Technology
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
Towards the definition of spatial data warehouses integrity constraints with spatial OCL
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Logic programming for data warehouse conceptual schema validation
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
A model-driven heuristic approach for detecting multidimensional facts in relational data sources
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
A systematic review of the use of requirements engineering techniques in model-driven development
MODELS'10 Proceedings of the 13th international conference on Model driven engineering languages and systems: Part II
View-based model-driven architecture for enhancing maintainability of data access services
Data & Knowledge Engineering
CAiSE'11 Proceedings of the 23rd international conference on Advanced information systems engineering
GrHyMM: a graph-oriented hybrid multidimensional model
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
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
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
Journal of Database Management
Tracing conceptual models' evolution in data warehouses by using the model driven architecture
Computer Standards & Interfaces
Hi-index | 0.00 |
Successful data warehouse (DW) design needs to be based upon a requirement analysis phase in order to adequately represent the information needs of DW users. Moreover, since the DW integrates the information provided by data sources, it is also crucial to take these sources into account throughout the development process to obtain a consistent reconciliation of data sources and information needs. In this paper, we start by summarizing our approach to specify user requirements for data warehouses and to obtain a conceptual multidimensional model capturing these requirements. Then, we make use of the multidimensional normal forms to define a set of Query/View/Transformation (QVT) relations to assure that the conceptual multidimensional model obtained from user requirements agrees with the available data sources that will populate the DW. Thus, we propose a hybrid approach to develop DWs, i.e., we firstly obtain the conceptual multidimensional model of the DW from user requirements and then we verify and enforce its correctness against data sources by using a set of QVT relations based on multidimensional normal forms. Finally, we provide some snapshots of the CASE tool we have used to implement our QVT relations.