期刊名称：International Journal of Computer Science and Information Technologies
电子版ISSN：0975-9646
出版年度：2015
卷号：6
期号：2
页码：1787-1791
出版社：TechScience Publications
摘要：As the data warehouse is a living IT system, sources and targets might change. Those changes must be maintained and tracked through the lifespan of the system without overwriting or deleting the old information. We need to load data warehouse regularly so that it can serve its purpose of facilitating business analysis and keep updated. The process of extracting data from source systems and bringing it into the data warehouse is commonly called ETL, which stands for extraction, transformation, and loading. The intention of this survey is to present the research work in the field of ETL technology in a structured way. ETL process is described in detail in the paper.
关键词：extract; transform and loading; data warehouse;online analytical processing; online transaction protocol
