An etl processes modeling approach based on unified: Views model
XuDong Song,Xiaobing Liu
2010-01-01
Abstract:Extraction-Transformation-Loading (ETL) tools are pieces of softwareresponsible for the extraction of data, from, several sources; their cleaning,customization and, insertion, into Data, Warehouse (DW). Complexity, usabilityand maintainability are the primary problems concerning ETL processes. To dealwith these problems, this paper proposes a new architecture based on UnifiedViews Model (UVM) for ETL processes, in which Unified view layer is addedbetween source data level and DW level. The unified views model serves as themeans to conform, the structure and, semantics of the source data, to the onesof the data, warehouse, and, help designers understand, and, analyze themeaning, relationships and, lineage of information. Under a, data, warehousingintegrated, modeling framework, this paper provides a, new modeling approach forETL processes based, on UVM. Finally, we present an ETL tool based, on UVM(UVETL) with the goal of facilitating the design, modeling and, realization ofETL processes. ICIC International © 2010.