International Journal of Computer
Trends and Technology

Research Article | Open Access | Download PDF

Volume 56 | Number 1 | Year 2018 | Article Id. IJCTT-V56P107 | DOI : https://doi.org/10.14445/22312803/IJCTT-V56P107

Data Warehouse Design for Electronic Manufacturing Company

Fauziyah, Metty Mustikasari, Irwan Bastian

Citation :

Fauziyah, Metty Mustikasari, Irwan Bastian, "Data Warehouse Design for Electronic Manufacturing Company," International Journal of Computer Trends and Technology (IJCTT), vol. 56, no. 1, pp. 47-53, 2018. Crossref, https://doi.org/10.14445/22312803/IJCTT-V56P107

Abstract

Recently, managing data in electronic manufacturing company has become a challenge .This paper presents the design of a data warehouse based on user needs for electronic manufacturing company. The data warehouse is designed using Kimball’s Method. The purpose of the proposed design is to help decision makers in performing data processing and data analysis over the data stored in the warehouse. The data warehouse design based on user needs which provides a data source to support corporate leaders for enhance the decision making process. Database Management System used is Oracle Database XE. This Study includes Integrity check process and User Acceptance Test. This study reflects that user find the data warehouse fulfill the user needs.

Keywords

Data Warehouse, Kimball method, Dimensional Model, Integrity Check.

References

[1] Connolly, T, M., and Begg C. E, Database Systems: A Practical Approach to Design, Implementation and Management, 6th Edition, Pearson Education, 2015.
[2] IBM Corporation, Database Fundamental, IBM Canada, Canada,2010.
[3] Patel, Alpa R., Patel, Jayesh M, “Data Modeling Techniques for Data Warehouse”, International Journal of Multidisciplinary Research, Vol. 2, Issue 2, February 2012.
[4] Oketunji, Temitope A., Omodara, Raufu O, “Design of Data Warehouse and Business Intelligence System: A Case Study of a Retail Industry”, thesis, School of Computing Blekinge Institute of Technology, Sweden, 2011.
[5] Türkmen, Güzin, “Developing a Data Warehouse for a University Decision Support System”. A Master’s Thesis. Turkey, 2007.
[6] Mohammed, Khalid Ibrahim, “Data Warehouse Design and Implementation Based on Quality Requirement”. International Journal of Advances in Engineering & Technology, July. 2014.
[7] Leonard, Edward M. (2011) Design and Implementation of an Enterprise Data Warehouse. Paper 119. Available: http://epublications.marquette.edu/theses_open/119.
[8] Sauter, Vicki L, “Decision Support Systems for Business Intelligence”, John Wiley & Sons, Inc. Canada, 2010.
[9] Kimball, Ralph., Ross, Margy, “The Data Warehouse Tool Kit”, John Wiley & Sons, Inc, Canada, 2013.