数据仓库的数据抽取技术研究

Data Extraction Techniques Research on Data Warehouse

介绍了数据抽取的几种技术,包括静态数据的捕获、通过日志文件捕获、通过数据库触发器捕获、基于日期和时间标记的捕获、在 源应用程序中捕获、通过文件的比较捕获。阐述了各种技术的优缺点,以及在实际环境中对各种技术的选择。

This article introduces data extraction techniques including capture of static data, capture through transaction logs files,capture through database triggers, capture based on date and time stamp, capture in source applications,capture by comparing files. The paper discusses the advantages and disadvantages of the different techniques, and how to make choice of them in practical environment.