周志艳, 罗锡文. 农作物生产管理信息数据仓库维度建模初探[J]. 农业工程学报, 2005, 21(11): 112-115.
    引用本文: 周志艳, 罗锡文. 农作物生产管理信息数据仓库维度建模初探[J]. 农业工程学报, 2005, 21(11): 112-115.
    Zhou Zhiyan, Luo Xiwen. Dimensional modeling of crop production management information data warehouse[J]. Transactions of the Chinese Society of Agricultural Engineering (Transactions of the CSAE), 2005, 21(11): 112-115.
    Citation: Zhou Zhiyan, Luo Xiwen. Dimensional modeling of crop production management information data warehouse[J]. Transactions of the Chinese Society of Agricultural Engineering (Transactions of the CSAE), 2005, 21(11): 112-115.

    农作物生产管理信息数据仓库维度建模初探

    Dimensional modeling of crop production management information data warehouse

    • 摘要: 根据维度建模的一般方法,结合农作物生产管理信息数据的特点,提出了农作物生产管理信息数据仓库的维度模型,包括数据仓库的总线矩阵、值链图、星型连接图以及详尽的维度表和相关业务主题的事实表等,并分别对各表进行了适当的属性字段填充,以期为建立基于数据仓库的农作物生产管理信息数据挖掘和知识发现提供可靠的实现方案,并为最终实现数字农业优化决策支持系统打下基础。

       

      Abstract: In order to carry out a reliable scheme for the data mining and knowledge discovery, and develop a foundation for Decision Support System (DSS) of digital agriculture, it is necessary to study the dimensional modeling of crop production nanagement information data warehouse. According to the general methods of dimensional modeling and the characteristic of the crop production management information data, a dimensional model of the crop information data warehouse was developed, including the Data Warehouse Bus Matrix, Value Chain Figure, Star-join Schema, the Dimension Table and Fact Table of the relevant business, etc.

       

    /

    返回文章
    返回