A DATA WAREHOUSE FOR UNCONTROLLED DECISION MAKING AND DECISION MAKING IN GREENHOUSES

Resumen

Agriculture has been studied by scientists using empirical methods to analyze the low profitability of production and which factors predominate for this purpose. To improve agricultural production, agricultural greenhouses were created, which are closed environments and allow for the control of conditions necessary for the development of plants, such as temperature, humidity, and light. A greenhouse allows the construction of models and systems that help to improve production and crop quality. Temperature, humidity, and light sensors are examples of components that receive information from the environment and enable greater control of these variables. The readings taken by sensors in greenhouses bring a wealth of information that could be stored and used to assist in decision support and long-term greenhouse improvements, not just be verified in real-time. One way to manage large volumes of data is through the use of Data warehouses (DW), which store summarized, aggregated, and consolidated data for long periods. Based on this reality, this article presents an analysis of a DW that enables strategic support in the planning and control of greenhouses, storing information on temperature, humidity, greenhouse luminosity, as well as external factors such as weather conditions, investments, costs, and productivity.

Keywords: Greenhouses, Data Warehouse, Decision Making.