OLAP在现代企业DSS中的应用研究

Research on the Application of OLAP in Enterprise Decision Support System

如何迅速从海量数据中获得准确的决策信息是现代商业企业致胜的关键。以数据仓库及OLAP Services为工具,通过建立多维数据模型和数据立方体,针对企业销售数据设计一个数据仓库管理系统,把事务数据库中原始混乱的数据集成转化变成数据仓库中规范的数据方便用户的查询,进而辅助企业决策。实际证明系统实用方便,大大提高企业信息管理效率。

It is crucial for modern enterprise to rapidly obtain correct information from huge data. With the aid of data warehouse and OLAP Services, a data warehouse management system can be set up on the basis of multi - dimension data model and data cube. The above - mentioned system can transform the originally chaotic data into normal data for user to inquire conveniently, which may benefit the determination of enterprise. It has been proved that the system has much practical value, and has improved the management efficiency of enterprise.