An ETL Services Framework Based on Metadata

An ETL Services Framework Based on Metadata,10.1109/IWISA.2010.5473575,Huamin Wang,Zhiwei Ye

An ETL Services Framework Based on Metadata   (Citations: 1)
BibTex | RIS | RefWorks Download
This paper first analyzed the problems of existing ETL tools, and proposed an ETL service model based on metadata, and then summarizes the types of metadata and their application scope. Based on this ETL service model, a concrete ETL service framework was put forward; many important services were also discussed, such as metadata management service, metadata definition services, ETL transformation rules service, process definition service, SQL code generation and optimization services, process control services and so on. At last, definition method and related algorithms of ETL rules are designed and analyzed. Practice has proved that the model and framework proposed in this paper can improve the ETL efficiency to a large extent.
Cumulative Annual
View Publication
The following links allow you to view full publications. These links are maintained by other sources not affiliated with Microsoft Academic Search.
    • ...ETL (Extraction-Transformation-Loading), which is the process of extracting data from a variety of heterogeneous data sources, and then transforming those extracted data into needed format, and at last loading those data into the data warehouse, can also be considered as a category of specialized tools with the task of dealing with data warehouse homogeneity, cleaning and loading problems [1]...

    Liutong Xuet al. A PaaS based metadata-driven ETL framework

Sort by: