商业智能系统数据库的规划.docVIP

商业智能系统数据库的规划 　　 摘要:信息化在中国经历数十年的发展,各企事业单位已经拥有了不同种类的成熟的基础信息系统,这些系统称为联机业务系统,如今根据自身发展的迫切需要,企业已经进入了商业智能(BI)分析的信息化阶段,商业智能所要解决的问题:如何充分利用这些分散在各个基础系统的信息,帮助企业更好的管理和决策以及为客户提供个性化的服务。商业智能系统与联机业务系统不一样,首先面临的问题是:数据量的急剧增长,联机业务系统也有,但是,联机业务系统通常的做法:定期会清理数据,而数据仓库系统里面通常至少保留数年的数据,所以膨胀的数据都要在数据仓库里面存储,比如以金融业的自然规律来讲:每年增40%的数据,如何设计和规划这些后台的数据,成为商业智能系统的设计的核心问题之一。本文提出的正是商业智能系统数据库的规划。 　　 关键词:商业智能系统;BI;数据库的规划 　　 中图分类号:TN915.5文献标识码:A文章编号:1007-9599 (2010) 11-0000-03 　　 The Planning of Business Intelligence System Database 　　 Jiang Shifeng 　　 (Guangzhou Ke Teng Information Technology Co.,Ltd.Guangzhou528231,China) 　　 Abstract:Information technology in China has experienced several decades of development,the enterprises already have the basis different types of information systems mature,these systems are called online business systems,and now an urgent need for the development according to their own enterprises have entered the business intelligence (BI) information analysis phase,business intelligence problems to be solved:how to take advantage of these scattered in various basic system information to help businesses better management and decision-making and provide personalized customer service.Business intelligence systems and online business system is different,first of all the problems are:the amount of data the rapid growth of online business systems has,however,online business systems,the usual practice:regularly clean up data,and data warehouse systems which are usually kept for at least a few years of data,so the expansion of data to be stored in a data repository,such as the financial sector in terms of natural law:40% annual increase in the data,how to design and planning of these background data,a business intelligence system,the core of the design problems.The proposed database business intelligence system is planning. 　　 Keywords:Business intelligence system;BI;Database programming 　　 一、基本规划 　　 商业智能系统数据库的规划是一件较为复杂的综合性的工作,需要对系统做全方位的分析和规划。同时也需要较深厚的数据库管理经验与设计的知识,还要着眼于未来数据库中的数据量的不断