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

Authors

  • Edi Purnomo Putra Bina Nusantara University
  • Fifilia Fifilia Bina Nusantara University
  • Lay Christian Bina Nusantara University
  • Hantze Sudarma Bina Nusantara University

DOI:

https://doi.org/10.21512/comtech.v6i3.2251

Keywords:

data warehouse, database, distribution, modeling.

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 and
decision-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 steps
methodology. 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.

Dimensions

Plum Analytics

References

Connoly, T.M., Begg, C.E. (2005). Database Systems: a practical approach to design, implementation, and management, Fourth Edition. Harlow, England: Addison-Wesley.

Inmon, W.H. (2002). Building the Data Warehouse, Third Edition. John Wiley & Sons, Inc, New York.

Kimball, R., Ross, M. (2002). The Data Warehouse Toolkit: the complete guide to dimensional modelling, Second Edition. New York: John Wiley & Sons, Inc.

McLeod, R., Schell, G. (2007). Management Information System. Tenth Edition. New Jersey: Pearson Prentice Hall.

Ponniah, P. (2001). Data Warehousing Fundamentals. USA: John Wiley & Sons, Inc.

Turban, E., Rainer, R. K., & Potter, R. E. (2005). Introduction to Information Technology. 3rd Edition. Canada: John Wiley & Sons.

Downloads

Published

2015-09-01

Issue

Section

Articles
Abstract 725  .
PDF downloaded 557  .