Bis composed of three subsystem : rtfs ( routine transaction processing system ) , dwms ( data warehouse management system ) , dwcs ( data warehouse client system ) . this paper detailed demonstrate the extract of data from data source , loading data into dw ( data warehouse ) , the creating and management of data source , dimension and cube of dw , and implementing of data mining and olap 对数据从数据源提取、加载进入数据仓库、数据仓库数据源、维、立方体的创建和管理、数据挖掘及olap的实施等进行了详细的说明。
First of all , the data system in the article is discussed and the goal function used to optimize the agricultural structure and the inhabitable condition are offered . then according to the characteristic of agricultural data system the logical structure of data bazaar in the data warehouse in the system is designed and the program for drawing out the data for data warehouse are offered . and we use the analysis services in sql server 2000 to design the multi - dimension data volume , which laid the groundwork for the later olap and data mining , we make use of the technique of mining the association rules to discover the rules in the data which are processed in a certain extent 本文首先探讨了该系统中的数据指标体系，给出了相应的优化农业结构使用的目标函数和约束条件；然后根据农业数据的特点，设计了该系统中的数据仓库中的数据集市的逻辑结构，给出了相应的数据仓库数据的抽取程序；利用sqlserver2000中的analysisservices设计了数据仓库的多维数据集，为后面的联机分析处理和数据挖掘打好了基础，并利用关联规则挖掘技术，对经过一定处理之后的数据进行挖掘；最后选择windows2000作为网络服务器、 sqlserver2000数据仓库的服务器、利用microsoftvisualinterdev 、结合asp 、 frontpage 、 photoshop等作为系统开发平台，设计开发基于intranet的农业结构优化决策支持系统，使得决策支持系统在intranet进一步扩展。
In this paper , on the one hand , based on the properties of data merger from mis into data warehouse along with the relationship between data warehouse and mis , the principles of mis design scheme as a solution to this problem are discussed , and a technology method of mis design with data merger is given as well . on the other hand , after introducing some characteristics of data warehouse , this paper states that those are just what the decision support system needs . to discuss the necessities of the rise of dss as a complement of mis and corresponding key technologies , this paper introduces a real project : the project exploration management information system 本文一方面在分析数据仓库中数据归集的基础上，讨论了面向数据仓库数据归集的mis系统设计特点，并给出了基于数据归集的mis系统设计的一些具体思路和技术方法；另一方面，介绍了dss出现的必然性，指出了数据仓库技术的固有特点可满足dss对数据组织的要求，提出了基于数据仓库技术的决策支持系统的体系结构，并结合实际的工程勘测管理信息系统给出了实现的一些关键技术。
