数据仓库增量维护技术的研究

提出了数据仓库设计中的一种新的"基于多delta文件的选择增量维护算法",该算法实现了加载、维护的较小结果集,另外采用多层体系结构,用基库将操作型OLTP环境和DSS和OLAP环境桥接起来,在基库端和仓库端采用多版本控制思想控制抽取动态结果集大小以及在数据仓库端采用增量维护的算法,从而在维护后台进程中用的是较小的数据结果集批量加载,并不影响数据仓库端的查询操作,明显地减少了对OLAP和OLTP环境的影响.该算法和体系结构宜于实现,具有较强的工程参考价值.

On technigue of increment maintenance for database

In this paper,we describe a new increment maintenance algorithm,which is know as"increment maintenance algorithm based on multiple delta files".It makes the smaller result sets of data warehouse loading and maintenance as real.In addition,it adopts multiple tiers infrastructure;by using data warehouse base,it links operation model OLTP environment and DDS/OLAP environment together.In both data warehouse base side and data warehouse side,we all use multiple version control mechanism to get the size of result sets dynamically and in data warehouse side,we use "increment maintenance methodology" at same time.Thereby,during the backend processes maintenance,we can use the smaller result sets for batch loading.Based on this design,it does not affect the data warehouse query operation,and in the meantime,it affects the OLAP and OLTP environment very slightly.This methodology and its infrastructure are very easy to implement and has very useful engineering reference values.