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.