The purpose of this study is to perform database’s planning that supports Prototype Modeling Data Warehouse in the Ministry of Agriculture, especially in the Distribution Center and Reserves in the field of distribution, reserve and price. With the prototype of Data Warehouse, the process of data analysis anddecision-making process by the top management will be easier and more accurate. Research’s method used was data collection and design method. Data warehouse’s design method was done by using Kimball’s nine stepsmethodology. Database design was done by using the ERD (Entity Relationship Diagram) and activity diagram. The data used for the analysis was obtained from an interview with the head of Distribution, Reserve and Food Price. The results obtained through the analysis incorporated into the Data Warehouse Prototype have been designed to support decision-making. To conclude, Prototype Data Warehouse facilitates the analysis of data, the searching of history data and decision-making by the top management.
Rice is a strategic food commodity in Indonesia, so the availability and consumption needs of rice need to be considered. in line with population growth and the decline in the area of agricultural land also influences the management of rice availability and has the potential to become a rice supply deficit if it is not managed properly. The purpose of this paper is to develop a pattern of relations between rice availability and rice consumption so that a balance occurs in the management of rice availability. The method used is the System Dynamics model, where this method is able to formulate a complex system by utilizing historically existing data to form a model, therefore this approach is expected to form a performance model of balance between rice availability and consumption which can then be simulated to predict needs in the future so that it can be used for faster and more accurate decision making
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.