数据仓库技术在路政管理系统中的研究与应用

【作者】 李莉；

【导师】 王树梅； 黄河燕；

【作者基本信息】 南京理工大学 ， 计算机应用， 2004， 硕士

【摘要】 《山东路政管理信息系统》是一套供路政人员利用计算机对路政管理工作进行实际业务操作、信息处理、档案管理的办公自动化软件。由于路政管理工作主要是关于各公路／高速公路的管理，所以涉及到的数据类型众多，数据量庞大，需要一种技术能自动从这些数据中得出规律，为领导者提供参考。本文以数据仓库及其相关技术为出发点，主要致力于研究路政管理系统中的决策支持，制定适合于路政系统的决策支持方案。数据仓库是实现决策支持的基础，本文作者通过比较现有的几种数据仓库建模方式，得出一种最优的建模方式，并基于该方式提出对经典的数据仓库三层建模方式的改进。在决策支持的实现上，作者通过两种途径来实现，即统计分析和数据挖掘，这两者是决策支持的逐步深入。作者利用先进的技术实现了统计分析功能，即数据转换、数据集市的建立和OLAP(联机分析处理)展示。在对系统中数据挖掘技术的研究上，作者综合考虑了路政工作的需求，选用了一种最优的分类算法CMAR，并结合实际情况对该算法提出改进方法。本文在论述理论基础的过程中给出系统设计和实现，将理论与实际结合在一起，有效地增强了路政管理系统中的决策支持功能。更多还原

【Abstract】 "Shandong Road Administration System" satisfied the need for civil servants use computers to manage road clerical work. It makes general operation, information management and document management more convenience. Because road clerical work is about the management on road/highway affair, so it deals with many data types and a great deal of data. We need a technology to draw disciplinarians from these data automatically. Then we can provide references for leaders. Regards the data warehouse and relevant technology as the starting point, this paper is devoted to researching the decision support function for the "Shandong Road Administration System", and try to make the decision support scheme which is suitable for this system. Data Warehouse is the base of realizing decision support. The author got a best modeling fashion from comparing several models, and brought forward the improvement of the classical "Three Floor Modeling Fashion". The author realized the decision support through two kinds of ways , namely statistical analysis and data mining . These two can be regarded as the stepwise deepening in decision support.The author used some advanced technology to realize statistical analysis, namely datatraction, building the data mark, and OLAP show. In the research of data mining, theauthor considered the need of road clerical work synthetically, selects an excellentclassification algorithm CMAR. Combining the fact, the author proposed improves ofthis algorithm. This paper provided system design and realization on the process of discussing correlative theories, combined theories with practice, strengthened the decision support function in the "Shandong Road Administration System".更多还原