Real-time Data Superaddition method based on triggers
Ming Cen, Jianchun Jiang, Ruifei Hu · 2008
Data Superaddition is main means of data updating of DW (Data Warehouses). With many business intelligence systems now having to integrate just-in-time data to support real-time analysis, to improve the efficiency and real-time performance of data superaddition, a real-time data superaddition method based on triggers is presented. In the method, data changes of DB (Data Base) tables are captured by triggers, transferred to data-manipulation command sequences which could executed on DW according to extraction and transform logic in triggers and grammar of DW, then recorded to delta data file and loaded to DW in time. Focused on the difficulties of writing a great deal of triggers code, a method of automatic code generation based on metadata is presented and the relevant development tool is designed. Application instance shows that the method can perform real-time data superaddition with low expense and favourable generality.