数据仓库与OLAP技术在果蔬仓储环境数据监测中的应用

Application of data warehouse and OLAP technology in fruit storage environment monitoring

在论述数据仓库与OLAP(On-Line Analytical Processing)技术的基础上,从我国目前监测系统存在的对实时数据和历史数据利用不够充分的现状出发,将这两项技术用于果蔬仓储温湿度监测系统,更好地为我国果蔬仓储产业服务。数据仓库与在线分析技术的结合更好地实现了对仓储环境中的温湿度数据的实时监测和分析,能充分利用历史数据,实现对数据的多维度、多层次的查询和分析,能更好地挖掘潜藏在数据中有价值的信息。

Based on the discussion of data warehousing and OLAP（On-Line Analytical Processing） technology,considering the drawbacks that the current monitoring system can＇t make well use of the real-time data and historical data,this paper applies these two technologies to fruit and vegetable storage temperature and humidity monitoring system,to service for the fruit and vegetable storage industry better.The combining of data warehouse and online analytical processing technology achieve a better real-time monitoring and analysis on storage temperature and humidity data,can make full use of historical data,achieve multi-dimensional,multi-level query and analysis,can mine the valuable information hidden in the data better.