ABSTRACT Digitalization of agricultural technology has led to the emergence of precision dairy farming, which strives for the simultaneous improvement of productivity as well as animal well-being in dairy farming through advanced use of technology such as movement sensors and milking parlors to monitor, control, and improve dairy production processes. The data warehouse serves as the appropriate technology for effective and efficient data management, which is paramount to the success of precision dairy farming. This paper presents a joint effort between industry and academia on the experimental development of an active semantic data warehouse to support business intelligence and business analytics in precision dairy farming. The research follows an action research approach, deriving lessons for theory and practice from a set of actions taken in the course of the project. Among these actions are the development of a loading stage to facilitate data integration, the definition of an analysis view as well as the introduction of semantic OLAP patterns to facilitate analysis, and analysis rules to automate periodic analyses. The large volumes of generated sensor data in precision dairy farming required careful decision-making concerning the appropriate level of detail of the data stored in the data warehouse. Semantic technologies played a key role in rendering analysis accessible to end users.

中文翻译：

---

为精准奶牛建立主动语义数据仓库

摘要 农业技术的数字化催生了精准奶牛养殖，它通过先进的运动传感器和挤奶厅等技术来监测、控制、控制奶牛养殖，力求同时提高奶牛养殖的生产力和动物福利。并改进乳制品生产工艺。数据仓库是有效和高效数据管理的适当技术，这对于精准奶牛养殖的成功至关重要。本文介绍了工业界和学术界在实验性开发活动语义数据仓库方面的共同努力，以支持精准奶牛养殖中的商业智能和商业分析。该研究遵循行动研究方法，从项目过程中采取的一系列行动中汲取理论和实践经验。其中包括开发加载阶段以促进数据集成、定义分析视图以及引入语义 OLAP 模式以促进分析，以及分析规则以自动执行定期分析。精准奶牛养殖中生成的大量传感器数据需要就存储在数据仓库中的数据的适当详细程度做出谨慎的决策。语义技术在呈现最终用户可访问的分析方面发挥了关键作用。和分析规则来自动进行定期分析。精准奶牛养殖中生成的大量传感器数据需要就存储在数据仓库中的数据的适当详细程度做出谨慎的决策。语义技术在呈现最终用户可访问的分析方面发挥了关键作用。和分析规则来自动进行定期分析。精准奶牛养殖中生成的大量传感器数据需要就存储在数据仓库中的数据的适当详细程度做出谨慎的决策。语义技术在呈现最终用户可访问的分析方面发挥了关键作用。