节点文献
基于数据仓库的决策支持系统研究与实现
【作者】 王克龙;
【导师】 王玲;
【作者基本信息】 南京理工大学 , 模式识别与智能系统, 2004, 硕士
【摘要】 数据仓库技术是当前信息技术领域的研究热点。数据仓库系统以传统的数据库为主要的信息源,通过联机分析处理和数据挖掘等技术对各类大量的数据和信息进行分析处理,实现了数据向信息的转换,为管理者的决策提供有效的支持。 目前市场虽已有众多的数据仓库产品,但数据仓库不是简单的可以买来的,将数据仓库应用到企业实际,还需要进行深入的应用研究。本文在对数据仓库理论及技术研究的基础上,探讨了基于数据仓库的决策支持系统的体系结构。重点从应用角度分析并解决了数据仓库设计与实现中的关键技术。最后结合具体实例详细论述了基于数据仓库的业务分析系统的设计和实现过程。提出了一套行之有效的企业数据仓库设计方法和实施策略,对于今后建立企业级的数据仓库和决策支持系统具有重要的实际参考价值。
【Abstract】 Data warehouse has became one hot research field in current Information Technology field.The traditional database is the main information source of data warehouse system.Through the technology of On-Line Analytical Processing, Data Mining and so on, data warehouse can analyse a great deal of data and information and transform data into information.The results of analysis can support the governors’ decisions.At present many data warehouse products have appeared on the market.But data warehouse is a project, not a product that you can buy on the shelf.ln order to avoid a data warehouse project meltdown, many key technologies need to be further studied.This thesis introduced the theories and technologies of data warehouse, and then established the architecture of DSS based on data warehouse and discussed the relation between data warehouse and DSS.Some of key problems about designing and implementating of data warehouse are concentrated on. Finally, as a good case in point, some ideas of designing and implementing data warehouse mentioned in this thesis have been applied in Business Analyzing System based on Data Warehouse project successfully, which is useful for constructing the whole enterprise data warehouse in the future.
【Key words】 data warehouse; data mart; OLAP; data mining; DSS; ETL; multidimensional data model; star schema;
- 【网络出版投稿人】 南京理工大学 【网络出版年期】2004年 04期
- 【分类号】TP311.13
- 【被引频次】17
- 【下载频次】642