Modelling of Data Warehouse on Food Distribution Center and Reserves in the Ministry of Agriculture

Abstract

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.

Rancangan Data Warehouse Akademik Politeknik Pariwisata Bali Berbasis Linux Opensuse

“…Data warehouse adalah data yang disalin dari berbagai sumber secara berkala yang terkoordinasi dan dirancang untuk mengoptimalkan proses analisis informasi [10]. Data warehouse berfungsi sebagai media penyimpanan historical data yang sudah terintegrasi, biasanya berasal dari beberapa sumber data yang digunakan sebagai pendukung untuk membantu top management dalam mengambil sebuah keputusan yang tepat pada suatu instansi [11]. Evolusi data warehouse di masa depan adalah integrasi data dari berbagai tipe data dan berbagai kebutuhan dalam penggunaan [12].…”

The Development of Data Warehouse from Payment Point Services of IT Business Solution Provider

“…It is based on different view by simplifying and tracking the flow of distribution between regions. Moreover, it can analyze the fluctuations of food price using historical data (Putra, Fifilia, Christian, & Sudarma, 2015).…”

Information System Development Using Microsoft Visual Studio to Speed Up Approved Sample Distribution Process

“…Information technology in this era can influence the success or failure of the business. (Putra, Fifilia, Christian & Sudarma, 2015) To develop information technology, an information system is made with the function to combine it with people, and data to provide support for business. To develop an information system, some steps needed to be passed.…”