Modelling of Data Warehouse on Food Distribution Center and Reserves in the Ministry of Agriculture
DOI:
https://doi.org/10.21512/comtech.v6i3.2251Keywords:
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.
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
Issue
Section
License
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
USER RIGHTS
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: