Database Performance Tuning Methods for Manufacturing Execution System

Nurul A., Emran and Khushairi, N. M and Yusof, M. M. M. (2014) Database Performance Tuning Methods for Manufacturing Execution System. World Applied Sciences Journal. pp. 91-99. ISSN 1818-4952

Text Norazah.pdf - Published Version Restricted to Registered users only Download (701kB)

Abstract

In manufacturing industry where data are produced and shared every day, data volumes could be large enough for the database performance to become an issue. Manufacturing Execution System (MES) is such a system that cannot tolerate with poor database performance as the system relies heavily on real-time reporting that requires instance query responses. Manufacturing products’ quality and production targets can be affected as the result of delayed queries. Therefore, the need to maintain the acceptable level of database performance in this domain is crucial. One task in maintaining database performance is identification and diagnosis of the root causes that may cause delayed queries. Poor query design has been identified as one major cause of delayed queries that affect real-time reporting. Nevertheless, as various methods available to deal with poor query design, it is important for a database administrator to decide the method or combination of methods that work best. In this paper, we present a case study on the methods used by a real manufacturing industry company called as Silterra and the methods proposed in the literature that deal with poor query design. For each method, we elicit its strength and weaknesses and analyse the practical implementation of it.

Item Type:	Article
Uncontrolled Keywords:	Query rewriting; Database performance tuning
Subjects:	Z Bibliography. Library Science. Information Resources > ZA Information resources > ZA4450 Databases
Divisions:	Faculty of Information and Communication Technology > Department of Software Engineeering
Depositing User:	Nurul A. Emran
Date Deposited:	18 Apr 2014 07:38
Last Modified:	02 Sep 2021 13:41
URI:	http://eprints.utem.edu.my/id/eprint/12143
Statistic Details:	View Download Statistic

Actions (login required)

View Item