摘要
在激烈的市场竞争中,企业纷纷建立了自己的数据库系统,以此来收集、存储、管理业务操作数据,改善办公环境,提高操作人员的工作效率,同时,企业也希望从海量的数据中获得有价值的信息,以支持企业决策.
To make up the shortage of current database in information distilling, we need to integrate mass data in data warehouse so that it can offer better reference to business manage and decision-making for enterprise. By using relational database SQL Server 2000 of Microsoft as resolution scheme of data warehouse, an enterprise data warehouse with star schema is established. Data cubes are constructed and measures are calculated by Analysis Services tools in SQL Server,and these cubes are online analyzed through OLAP, then user can easily get relationship of data or attributes which can provide reference to their business, and utilize data in existence fully and effectively
出处
《计算机科学》
CSCD
北大核心
2003年第12期92-94,共3页
Computer Science
