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)
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
Multidimensional normal forms for data warehouse design
Information Systems
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
ER'07 Proceedings of the 26th international conference on Conceptual modeling
Improving the development of data warehouses by enriching dimension hierarchies with WordNet
ODBIS'05/06 Proceedings of the First and Second VLDB conference on Ontologies-based databases and information systems
Hybrid methodology for data warehouse conceptual design by UML schemas
Information and Software Technology
A model driven process for spatial data sources and spatial data warehouses reconcilation
ICCSA'10 Proceedings of the 2010 international conference on Computational Science and Its Applications - Volume Part I
A case study on model-driven data warehouse development
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
| Hi-index | 0.00 |
It is widely accepted that a requirement analysis phase is necessary to develop data warehouses (DWs) which 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 representation. In this paper, we use multidimensional normal forms to define a set of Query/View/Transformation (QVT) relations to assure that the DW designed 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 schema 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.