Paper Info
Title
Improving the maintainability of data warehouse designs: modeling relationships between sources and user concepts
Abstract
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.
Year
DOI
Venue
2012
10.1145/2390045.2390050
DOLAP
Keywords
Field
DocType
whole dw,data warehouse,data source element,dw design,dw evolves,data warehouse design,dw repository,incremental change,data source,etl process,user concept,data warehouses,evolution,reconciliation,maintainability
Data warehouse,Data source,Data mining,Computer science,Digital library,Database,Maintainability
Conference
Citations 
PageRank 
References 
2
0.37
15
Authors
4
Name
Order
Citations
PageRank
Alejandro Maté113417.94
Juan Trujillo21869149.78
Elisa de Gregorio3163.30
Il-Yeol Song42041301.54