数据仓库和OLAP技术在农业生产决策系统中的应用研究  

Application Study of Data Warehouse and Olap Technology in Agricultural Production Decision System

作　　者：赵菡 ZHAO Han(College of Information Engineering,Tarim University,Alar 843300,China)

机构地区：[1]塔里木大学信息工程学院,新疆阿拉尔843300

出　　处：《安徽农学通报》2021年第17期143-144,185,共3页Anhui Agricultural Science Bulletin

摘　　要：随着信息技术的不断发展,政府借助互联网、大数据和人工智能等新兴技术不断提升治理的现代化水平。农业数字管理是实现政府管理现代化的重要一环,其中,农业生产是农业管理中必不可少的一部分,但目前农业生产数据分散、数据量大、利用率低。该文利用数据同步工具ETL将适合主题的数据存入数据仓库,利用OLAP技术对数据多维分析,分析结果在农业生产决策系统中进行展示,为农业未来的发展决策提供科学依据。With the continuous development of information technology, the government with the help of the Internet, big data and artificial intelligence emerging technologies continue to improve the level of governance modernization, agricultural digital management is an important part of the realization of government management modernization, agricultural production is an essential part of agricultural management. At present, the agricultural production data is scattered, the data is large, the utilization rate is low. This paper uses the data synchronization tool ETL to store the data suitable for the topic in the data warehouse, uses the OLAP technology to analyze the data multi-dimensional, and displays the analysis results in the agricultural production decision system, it provides a strong basis for the future development and decision of agriculture.

关 键 词：数据同步 数据仓库 OLAP技术 多维分析 农业生产决策系统 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]