Research and Design of the Incremental Updates of Drug Data Warehouse

摘要：

To solve the date updates problem of drug Data Warehouse(DW), the General methods of data updates in DW and the problems that may exist in the process of data extraction.transmission and uploading were analyzed and studied. To achieve the requirements of reliability and rapidity of drug data updates, a method of incremental updates with triggers and intermediate table was proposed, and the design of trigger algorithms and intermediate tables was completed. At last, this method was used in the incremental updates of drug data. It is effectively for the incremental updates of large amounts of data such as insert, delete and update.

关键词： data warehouse (DW) trigger incremental updates ETL

作者: Hao Ping Huang GuoJun

作者单位: College of Computer Science and Technology, Zhejiang University of Technology Hangzhou 310032, China

会议类型: 国际会议

会议名称: The 2010 International Conference on Computer Application and System Modeling(2010计算机应用与系统建模国际会议 ICCASM 2010)

会议地点: 太原

会议语种:英文

页码: 628-630

在线出版日期: 2010-10-22（万方平台首次上网日期，不代表论文的发表时间）