游标技术在数据仓库统计效率中的研究与应用

STUDY AND APPLICATION OF CURSOR TECHNIQUE IN EFFICIENCY OF DWH

结合上海轨道交通AFC(Automatic Fare Collection)运营管理数据仓库海量高维数据的特点,通过对传统和游标两种不同访问数据编程方法的比较和应用,研究和提出利用游标技术提高数据仓库数据统计效率的方法,并给出这两种数据访问方法关于部分统计效率的对比结果。

Combined with data properties of the data warehouse of shanghai rail transit automatic fare collection operation management which is of huge quantity and in high dimension,a method to enhance the efficiency of data statistics at data warehouse by using cursor tech- nique is studied and presented in this paper,which is obtained from comparing the traditional programming method with the cursor programming method and their applications in accessing data, and the comparison results with regard to the partial statistical efficiency of these two different data access methods are presented too.