The data warehouse toolkit: practical techniques for building dimensional data warehouses
The data warehouse toolkit: practical techniques for building dimensional data warehouses
A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Conceptual modeling for ETL processes
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
YAM2 (Yet Another Multidimensional Model): An Extension of UML
IDEAS '02 Proceedings of the 2002 International Symposium on Database Engineering & Applications
Extending the UML for Multidimensional Modeling
UML '02 Proceedings of the 5th International Conference on The Unified Modeling Language
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Goal-oriented requirement analysis for data warehouse design
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Multidimensional database design from document-centric XML documents
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
Effective data warehouse for information delivery: a literature survey and classification
International Journal of Networking and Virtual Organisations
Hi-index | 0.00 |
Data warehouses (DW) main objective is to facilitating decision- making. Thus their development has to take into account DW project actor requirements. While much recent research has been focused on the design of multidimensional conceptual models, only few works were done to develop models and tools to analyze them. Despite specificities (OLAP, historicization, ...) of these requirements, most of the previous works used an E/R or UML schemas which do not allow designers to represent these specific principles. A main property of DW is that they are derived from existing data sources. Therefore, Extraction-Transformation-Loading (ETL) processes from these sources to the DW are very useful to define a reliable DW. In this paper, we fill this gap by showing how to systematically derive a conceptual schema of actors requirements using a rule-based mechanism. We provide a conceptual model which tries to be close to user vision of data by extending an object-oriented multidimensional model. Hence, in the early step of DW engineering, designers can formalize actors requirements about information and ETL processes at the same time to make easier understandability, confrontation and validation by all DW actors.