Data Warehouse Design for Electronic Manufacturing Company

International Journal of Computer Trends and Technology (IJCTT)          
© 2018 by IJCTT Journal
Volume-56 Number-1
Year of Publication : 2018
Authors : Fauziyah, Metty Mustikasari, Irwan Bastian
DOI :  10.14445/22312803/IJCTT-V56P107


Fauziyah, Metty Mustikasari,Irwan Bastian "Data Warehouse Design for Electronic Manufacturing Company". International Journal of Computer Trends and Technology (IJCTT) V56(1):47-53, February 2018. ISSN:2231-2803. Published by Seventh Sense Research Group.

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 forelectronic 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 decisionmaking process. Database Management System used is Oracle Database XE. This StudyincludesIntegrity check process and User Acceptance Test.This study reflects that user find the data warehouse fulfill the user needs.

[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:
[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.

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