Cover Image

Database Performance Tuning Methods for Manufacturing Execution System

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-t...

Full description

Saved in:
Bibliographic Details
Main Authors: Khushairi, N. M, Nurul A., Emran, Yusof, M. M. M.
Format: Conference or Workshop Item
Language:English
Published: 2013
Subjects:
ZA Information resources
ZA4450 Databases
Online Access:http://eprints.utem.edu.my/id/eprint/10992/1/MdKhushairi_NorAzah_ICMRP_v4FINALClaimCRIM.docx
http://eprints.utem.edu.my/id/eprint/10992/
http://www.globalilluminators.org/wp-content/uploads/2013/08/proceeding-final.pdf
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.utem.eprints.10992
record_format eprints
spelling my.utem.eprints.109922016-11-21T08:24:53Z http://eprints.utem.edu.my/id/eprint/10992/ Database Performance Tuning Methods for Manufacturing Execution System Khushairi, N. M Nurul A., Emran Yusof, M. M. M. ZA Information resources ZA4450 Databases 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. 2013 Conference or Workshop Item PeerReviewed application/msword en http://eprints.utem.edu.my/id/eprint/10992/1/MdKhushairi_NorAzah_ICMRP_v4FINALClaimCRIM.docx Khushairi, N. M and Nurul A., Emran and Yusof, M. M. M. (2013) Database Performance Tuning Methods for Manufacturing Execution System. In: INTERNATIONAL CONFERENCE ON INNOVATION CHALLENGES IN MULTIDISCIPLINARY RESEARCH AND PRACTICE (ICMRP 2013), 13-14 DECEMBER 2013, KUALA LUMPUR MALAYSIA. http://www.globalilluminators.org/wp-content/uploads/2013/08/proceeding-final.pdf
institution Universiti Teknikal Malaysia Melaka
building UTEM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknikal Malaysia Melaka
content_source UTEM Institutional Repository
url_provider http://eprints.utem.edu.my/
language English
topic ZA Information resources
ZA4450 Databases
spellingShingle ZA Information resources
ZA4450 Databases
Khushairi, N. M
Nurul A., Emran
Yusof, M. M. M.
Database Performance Tuning Methods for Manufacturing Execution System
description 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.
format Conference or Workshop Item
author Khushairi, N. M
Nurul A., Emran
Yusof, M. M. M.
author_facet Khushairi, N. M
Nurul A., Emran
Yusof, M. M. M.
author_sort Khushairi, N. M
title Database Performance Tuning Methods for Manufacturing Execution System
title_short Database Performance Tuning Methods for Manufacturing Execution System
title_full Database Performance Tuning Methods for Manufacturing Execution System
title_fullStr Database Performance Tuning Methods for Manufacturing Execution System
title_full_unstemmed Database Performance Tuning Methods for Manufacturing Execution System
title_sort database performance tuning methods for manufacturing execution system
publishDate 2013
url http://eprints.utem.edu.my/id/eprint/10992/1/MdKhushairi_NorAzah_ICMRP_v4FINALClaimCRIM.docx
http://eprints.utem.edu.my/id/eprint/10992/
http://www.globalilluminators.org/wp-content/uploads/2013/08/proceeding-final.pdf
_version_ 1665905445005426688
score 13.211869

Similar Items