Database Design for Data Mining Driven Forecasting Software Tool for Quality Function Deployment

Full Text (PDF, 796KB), PP.39-50

Views: 0 Downloads: 0

Author(s)

Shivani K. Purohit 1,* Ashish K. Sharma 1

1. Manoharbhai Patel Institute of Engineering and Technology ,Nagpur University, Gondia ,India

* Corresponding author.

DOI: https://doi.org/10.5815/ijieeb.2015.04.06

Received: 16 Mar. 2015 / Revised: 11 Apr. 2015 / Accepted: 1 Jun. 2015 / Published: 8 Jul. 2015

Index Terms

Data mining, Database design, Database, Forecasting, Quality Function Deployment (QFD)

Abstract

Efficient Database design is the key part of software development. A properly built database acts as the backbone of the software system and makes enhancing software more easily and quickly. Quality Function Deployment and data mining itself are very gordian processes. Thus, there is strong need of database for handling complex transactions of Quality Function Deployment along with data mining and accessing precise and up-to-date information concerned to this. Forecasting in Quality Function Deployment can be time consuming when computed manually. Hence, development of data mining driven forecasting software tool can give better results and also save time. This paper focuses on the database design for the development of data mining driven forecasting software tool for Quality Function Deployment. Here, first brief discussion on Quality Function Deployment and data mining followed by its concise literature review is presented. Later on, the integrated value chain needed by data mining driven forecasting system for Quality Function deployment is discussed. Then the flow chart illustrating the processes of the software tool is intended. Afterwards the tabulated schemas of logical part of database have been presented. Finally, the ER-diagram for the software and described the relationships among the tables have been designed followed by conclusion. Recognizing the general architecture and structural component of database system will lend a hand to designers and engineers successfully build up and sustain forecasting software tool.

Cite This Paper

Shivani K. Purohit, Ashish K. Sharma, "Database Design for Data Mining Driven Forecasting Software Tool for Quality Function Deployment", International Journal of Information Engineering and Electronic Business(IJIEEB), vol.7, no.4, pp.39-50, 2015. DOI:10.5815/ijieeb.2015.04.06

Reference

[1]G. Creech, Building a Relational Database with Microsoft Access. International Association of Administrative Professionals, EFAM, July 2013.

[2]E. E. Karsak, "Fuzzy Multiple Objective Programming Framework to Prioritize Design Requirements in Quality Function Deployment", Computers & Industrial Engineering, Elsevier, vol. 47, pp. 149-163, 2004.

[3]C. H. Hsu, S. Y. Wang and L. T. Lin. Using Data Mining to Identify Customer Needs in Quality Function Deployment for Software Design. In Proceedings of the 6th WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases, Corfu Island, Greece, February 16-19, 2007.

[4]F. Olaiya and A. B. Adeyemo, "Application of Data Mining Techniques in Weather Prediction and Climate Change Studies", I.J. Information Engineering and Electronic Business, MECS, vol. 1 pp. 51-59, February 2012.

[5]Y. Akao, Quality Function Deployment: Integrating Customers Requirements into Product Design,. Cambridge. MA: Productivity Press. 1990.

[6]S. Barut?u,"Quality Function Deployment in Effective Website Design:An Application in E-Store Design", Isletme Fakültesi Dergisi, Cilt, vol. 7, no. 1, pp. 41-63, 2006.

[7]C. Kahraman, T. Ertay and G. Buyukozkan, "A Fuzzy Optimization Model for QFD Planning Process using Analytic Network Approach", European Journal of Operational Research, Elsevier, vol. 171, no. 2, pp. 390-411, 2004.

[8]M. C. Lin, C. Y. Tsai, C. C. Cheng, and C. A. Chang, "Using Fuzzy QFD for Design of Low-end Digital Camera", International Journal of Applied Science and Engineering, vol. 2, no. 3, pp. 222-233, 2004.

[9]G. Ioannou, K. C. Pramataris and G.P. Prastacos," A Quality Function Deployment Approach to Web Site Development: Applications for Electronic Retailing" Les Cahiers du Management Technologique, vol. 13, no. 3, 2004.

[10]S. Zaim and M. Sevkli, "The Methodology of Quality Function Deployment with Crisp and Fuzzy Approaches and an Application in the Turkish Shampoo Industry," Journal of Economic and Social Research, vol. 4, no.1, pp. 27-53, 2002.

[11]A. Dhond, A. Gupta and S. Vadhavkar. Data Mining Techniques for optimizing Inventories for Electronic Commerce. KDD 2000, Boston, MA USA, 2000.

[12]P. Pujari and J. B. Gupta, "Exploiting Data Mining Techniques for Improving the Efficiency of Time Series Data using SPSS-CLEMENTINE," Researchers World Journal of Arts, Science & Commerce vol. 3 no. 2-3, pp. 69-80, April 2012.

[13]X. Zheng and P. Pulli, "Improving Mobile Services Design: A QFD Approach", Computing and Informatics, vol. 26, pp. 369–381, January 2007

[14]R. B. Kazemzadeh, M. Behzadian, M. Aghdasi, and A. Albadvi,"Integration of Marketing Research Techniques into House Of Quality and Product Family Design." The International Journal of Advanced Manufacturing Technology, vol. 41, no. 9-10, pp 1019-1033, April 2009.

[15]A. H. I. Lee, Y. H. Kang and C. Y. Yang, "An Evaluation Framework for Product Planning using FANP, QFD and multi-Choice Goal Programming," International Journal of Production Research, vol. 48, no. 13, 2010.

[16]X. X. Shen, C. K. Tan and M. Xie, "Benchmarking in QFD for Quality Improvement," Benchmarking: An International Journal, vol. 7, pp.282 – 291, 2000.

[17]A. Alemam and S. Li, "Integration of Quality Function Deployment and Functional Analysis for Eco-design", International Journal of Mechanical Engineering and Mechatronics, vol. 2, no. 1, 2014.

[18]S. Telang and C. Vichoray, "Development in Agricultural Tractor Brakes through QFD Application-A Conceptual Analysis," IOSR Journal of Mechanical and Civil Engineering (IOSR-JMCE), pp. 55-59, 2014.

[19]C. Zhang and Z. Fang, "An Improved K-means Clustering Algorithm," Journal of Information & Computational Science, vol. 10, pp.193–199, January 1, 2013.

[20]R. Hu, "Data Mining in the Application of Criminal Cases Based on Decision Tree," International Journal of Engineering Sciences, vol. 2, no. 2,pp. 24-27, February 2013.

[21]G. C. Onwubolu, "Data Mining using Inductive Modeling Approach", pp. 78-86, 2007.

[22]J. Yang. Research and Design of Hotel Management System Model. International Conference on Education Technology and Information System, 2013.

[23]H. Dev and A. Seth, "MDA based Approach towards Design of Database for Banking System", International Journal of Computer Applications (0975 –8887) vol. 49, no.16, July 2012.

[24]U. A. Umoh, E. O. Nwachukwu, A. A. Umoh, and E. B. Isong, "A Web-Based Database System: An Industrial Application", Research Journal in Engineering and Applied Sciences vol. 1, no. 3, pp. 203-208, 2012.

[25]M. A. Casanova, S. D. J. Barbosa, K. K. Breitman and A. L. Furtado, "Three Decades of Research on Database Design at PUC-Rio", Journal of Information and Data Management, vol. 3, no. 1, pp19–34, February 2012.

[26]I. Adusei, O. Kuljaca and K. Agyepong, "Intelligent Mammography Database Management System for a Computer Aided Breast Cancer Detection and Diagnosis", International Journal of Managing Information Technology (IJMIT), vol.2, no.2, May 2010.

[27]R. S. Khan and M. Saber, "Design of a Hospital-Based Database System (A Case Study of BIRDEM)", International Journal on Computer Science and Engineering (IJCSE), vol. 02, no. 08, pp. 2616-2621,2010.

[28]J. B. Cushing, N. Nadkarn, M. Finch, A. Fiala, E. Murphy-Hill, L. Delcambre and D. Maier, "Component-based end-user database design for ecologists", Journal of Intelligent Information System, vol. 29, no. 1, pp. 7, 2007.

[29]E. J. L. Lu and Y. Y. Cheng, "Design and implementation of a mobile database for Java phones", Computer Standards & Interfaces, vol. 26, pp 401–410, 2004.

[30]I. Y. Song and K. Y. Whang. Database Design for Real-World E-Commerce Systems. IEEE Computer Society Technical Committee on Data Engineering, 2000.

[31]D. R. McCarthy and U. Dayal. The Architecture of an Active Data Base Management System. Association for Computing Machinery, 1989.

[32]S. Finkelstein, M. Schkolnick and P. Tiberio. Physical database design for relational databases. ACM Transactions on Database Systems (TODS), vol. 13, no. 1, pp. 91-128, March 1988.

[33]E. Kwan. Designing Databases using a Customized SAS/AF? Frame Entry Application. Ischemia Research and Education Foundation, San Francisco, Callifornia, USA.

[34]I. Sentarli, A. Erdursun and Deha Caman. Development of a Database Management System Design Involving Quality Related Costs. Lund University, Campus Helsingborg.

[35]L. Ying and C. L. Ling, "Research on Spatial Database Design and Tuning Based on Oracle and ARCSDE".

[36]G. Wiederhold. Databases in Healthcare. National Institutes of Health, Stanford Computer Science Department, Report No. STAN-CS-80-790

[37]A. Badia, and D. Lemire ," A Call to Arms: Revisiting Database Design",SIGMOD Record, vol. 40, no. 3, September 2011.

[38]http://home.ubalt.edu/abento/300/DBdesign/ retrieved on 31 November 2014.

[39]http://searchcrm.techtarget.com/defination/entity-relatioship-diagram/ retrieved on 14 December 2014.