Abstract: “This research aims to develop the data warehouse system for applying to a decision support system based on rice cultivation. The study area is Amphoe Phimai, Nakhon Ratchasima Province, Thailand. The data warehouse system for rice cultivation (DWR) aimed to enhance the analysis of rice cultivation datasets compare to currently used statistical methods. The factor of rice growth has been collected which is proving the rice related information to the agricultural expert in an integrated manner or generating a quality advice. DWR would suggest efficient information for rice growth and monitoring the rice situation by using OLAP. It allows for quick analysis of all possible interesting aggregated data by employing drag-drop and mouse-click and is used into forecast the yield of rice. The assessment of user satisfaction was used to evaluate the system. Then this system was published to the government agencies and the public via the online system. The result of the study showed that the user”

Keywords: rice cultivation, data warehouse, decision support system, snowflake schema, OLAP