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

Full description

Saved in:
Bibliographic Details
Main Authors: Nurul A., Emran, Khushairi, N. M, Yusof, M. M. M.
Format: Article
Language:English
Published: IDOSI Publications 2014
Subjects:
ZA4450 Databases
Online Access:http://eprints.utem.edu.my/id/eprint/12143/1/Norazah.pdf
http://eprints.utem.edu.my/id/eprint/12143/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.utem.eprints.12143
record_format eprints
spelling my.utem.eprints.121432021-09-02T13:41:19Z http://eprints.utem.edu.my/id/eprint/12143/ Database Performance Tuning Methods for Manufacturing Execution System Nurul A., Emran Khushairi, N. M Yusof, M. M. M. 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. IDOSI Publications 2014 Article PeerReviewed text en http://eprints.utem.edu.my/id/eprint/12143/1/Norazah.pdf 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
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 ZA4450 Databases
spellingShingle ZA4450 Databases
Nurul A., Emran
Khushairi, N. M
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 Article
author Nurul A., Emran
Khushairi, N. M
Yusof, M. M. M.
author_facet Nurul A., Emran
Khushairi, N. M
Yusof, M. M. M.
author_sort Nurul A., Emran
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
publisher IDOSI Publications
publishDate 2014
url http://eprints.utem.edu.my/id/eprint/12143/1/Norazah.pdf
http://eprints.utem.edu.my/id/eprint/12143/
_version_ 1710679397000806400
score 13.211869

Similar Items