奶牛饲料配方DSS数据仓库的设计与实现

Design and Implementation of the Cow Feed Formula DSS Data Warehouse

从奶牛、饲料、配方和饲料供应商4个基准点出发,为奶牛饲料配方DSS建立了雪花模型数据仓库、联机事务处理、数据抽取和OLAP,实现了针对不同阶段的不同奶牛个体选取最佳饲料匹配方案的决策支持,解决了当前各类奶牛饲养过程中大量历史数据的存储和分析问题,提高决策结果的准确性以及奶牛饲料配方DSS的普及、应用和推广。

This paper from the cow, feed, formulas and feed suppliers starting four benchmarks for cow feed formula established snowflakes DSS model data warehouses, online transaction processing, data extraction and OLAP, achieving different stages in selecting the best individual cow feed matching program decision support, solving large amount of historical data storage of the current process of feeding cows, analysis and decision - making to improve the accuracy of the results and cow feed formula DSS universal.application and promotion.