银行信贷管理信息系统数据抽取的实现

Implementation of Data Extract in the Credit Management Information System of China Construction Bank

给出了中国建设银行信贷管理信息系统 (CMIS)中数据仓库数据抽取的实现方法 :应用Informix数据库的触发器 (Trigger)存储过程 (StoreProcedure) ,在业务变动库中记录业务数据库数据的变动信息 ,在抽取周期中用变动数据库中的信息对数据仓库新增加的数据进行更新处理 ,完成数据仓库数据的更新。

The paper illustrates the method of data extract of the data warehouse in the CMIS(Credit Management Information System of China Construction Bank), record the varying information of data in the base database using the trigger and store procedure of the informix database system, and put in the varying database. During the procedure of data extract, using the data in the varying database to refresh the data in the data warehouse, it is completed the process of data extracting.