OLAP在银行数据仓库中的设计和实现  

Realization and application of OLAP in data warehouse of bank

作　　者：江键[1] 陈福生[1] 

机构地区：[1]同济大学计算机系,上海200092

出　　处：《计算机工程与设计》2006年第20期3884-3886,共3页Computer Engineering and Design

摘　　要：如何对海量数据进行科学的分析处理以便为决策者提供决策支持已经成为银行面临的新课题。对此,通过对数据仓库在银行业务应用的研究,围绕银行领域的数据仓库和联机分析处理的部分设计开发过程进行了广泛的论述。主要综述了实体关系模型、星型模型、立方体(CUBE)、汇总表的设计以及在开发中所要注意的问题,并且特别对目前使用比较多的立方体设计进行深入有效的讨论,提出了一种高效的建立数据仓库和实现联机分析处理的设计方案和实现思想。How to analyse large quantity of information in the bank with scientific technique and to provide decision supports for decision maker, has become a new subject to banking industry. The data warehouse of banking industry and partial designs about the on-line analysis processing are discussed deeply after the application of data warehouse in the banks is researched. The entity relational model design, the star-scheme design, the cube designs, the summary table designs and the question which is paid attention to are dissertated mainly. Especially, the cube design is elaborated in detail. In conclusion, a kind of the design and realization methodology of building data warehouse and realizing OLAP effectively is proposed.

关 键 词：数据仓库 联机分析处理 实体关系模型 星型模型 立方体 

分 类 号：TP311.131[自动化与计算机技术—计算机软件与理论]