Real-time Data Superaddition Method Based on Triggers

被引：0

作者：

Cen, Ming ^{[1
]}

Jiang, Jianchun ^{[1
,2
]}

Hu, Ruifei ^{[3
]}

机构：

[1] Chongqing Univ Posts & Telecommun, Sch Automat, Chongqing 400065, Peoples R China

[2] Chongqing Univ, Sch Opt & Elect Engn, Chongqing 400030, Peoples R China

[3] Sichuan Univ, sch Mfg Sci & Engn, Chengdu, Peoples R China

来源：

2008 7TH WORLD CONGRESS ON INTELLIGENT CONTROL AND AUTOMATION, VOLS 1-23 | 2008年

关键词：

data warehouses; real-time data superaddition; trigger; automatic code generation;

D O I：

10.1109/WCICA.2008.4593867

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

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.

引用

页码：6232 / +

页数：2

共 8 条

[1] BRUCKNER RM, 2002, P 4 INT C DAT WAR KN, P317
[2] OLTP and OLAP data integration: A review of feasible implementation methods and architectures for real time data analysis
Conn, SS
[J]. PROCEEDINGS OF THE IEEE SOUTHEASTCON 2004: EXCELLENCE IN ENGINEERING, SCIENCE, AND TECHNOLOGY, 2005, : 515 - 520
[3] Synchronization options for data warehouse designs
Italiano, IC
Ferreira, JE
[J]. COMPUTER, 2006, 39 (03) : 53 - +
[4] Li Zhao, 2004, Fifth World Congress on Intelligent Control and Automation (IEEE Cat. No.04EX788), P4227, DOI 10.1109/WCICA.2004.1342307
[5] *OBJ MAN GROUP, 2001, COMM WAR MET CWM SPE
[6] Ram P., 2000, Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073), P220, DOI 10.1109/ICDE.2000.839415
[7] WINTER R, 2001, P 34 ANN HAW INT C S, P1
[8] XU W, 2005, INT C CONTR AUT, V2, P1108

← 1 →