An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Why and Where: A Characterization of Data Provenance
ICDT '01 Proceedings of the 8th International Conference on Database Theory
MDA Explained: The Model Driven Architecture: Practice and Promise
MDA Explained: The Model Driven Architecture: Practice and Promise
Modelling strategic relationships for process reengineering
Modelling strategic relationships for process reengineering
Building the Data Warehouse
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
GRAnD: A goal-oriented approach to requirement analysis in data warehouses
Decision Support Systems
Modelling ETL Processes of Data Warehouses with UML Activity Diagrams
OTM '08 Proceedings of the OTM Confederated International Workshops and Posters on On the Move to Meaningful Internet Systems: 2008 Workshops: ADI, AWeSoMe, COMBEK, EI2N, IWSSA, MONET, OnToContent + QSI, ORM, PerSys, RDDS, SEMELS, and SWWS
Data integration flows for business intelligence
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Defining ETL worfklows using BPMN and BPEL
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
A survey of traceability in requirements engineering and model-driven development
Software and Systems Modeling (SoSyM)
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
Incorporating traceability in conceptual models for data warehouses by using MDA
ER'11 Proceedings of the 30th international conference on Conceptual modeling
Proceedings of the 21st ACM international conference on Information and knowledge management
| Hi-index | 0.00 |
In data warehouse (DW) development, a series of mappings must be specified between user concepts and data source elements, in order to identify which sources must undergo an integration process. Until now, these mappings are either assumed to be implied by name matching or identified according to the designer's experience. Then, the result is implemented as Extraction/Transformation/Loading (ETL) processes. Since ETL processes relate elements at the logical level, designers cannot adequately analyze how a change in requirements or in the data sources affects the analysis capabilities. Furthermore, this approach makes it difficult to perform incremental changes in DW design, requiring in some cases to perform the whole analysis again. In this paper we present a set of semantic mappings that relate user concepts specified by requirements to those obtained from data sources. In turn, this allows us to accurately identify how any potential change affects the different structures and ETL processes. As a DW evolves over time, our approach easily allows us to incorporate new concepts, as well as any change introduced at requirements or data sources into the DW repository with no need to redesign the whole DW. In order to show the application of our proposal, we show a real case study focusing on the Digital library of the University of Alicante.