数据仓库中数据存储与访问的实现

从分析国内外的数据仓库应用现状入手,指出银行在应用数据仓库过程中存在的存储效率低,访问权限难以控制等问题。然后基于对数据存储的分类,提出关系数据库和多维数据库混合存储的方法,测试表明该系统达到节省存储空间和提高访问速度的效果。

From analyzing the current application situation of the domestic and foreign data warehouse, it is pointed out that the storage efficiency was very low and it was very difficult to control the visit jurisdiction during the application of data warehouse. Based on the classification of data storage, the method of combining relational database and multidimensional database was put forward. The tests indicate that the system has saved the storage space and has enhanced the visiting speed effectively.