Architecture graph-based approach for modeling ETL process

ETL is an important part for the data warehouse to gain data with high quality,and it plays a key role in building the data warehouse system.The paper proposed a methodology for modeling ETL process based on an architecture graph,with the goal of facilitating the designment,maintenance and modification of the ETL process.On the basis of this modeling approach,the paper completed the design of ETL conceptual model.By representing the elements and relationships of the ETL process diagrammatically,it expressed the data's coming and going,as well as their mapping and transformation relationships clearly and intuitively.It also supported the ETL designer to design the ETL process and develope the code efficiently,and improved the flexibility and reliability of the ETL process designment greatly.