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.
![[img]](http://eprints.utem.edu.my/style/images/fileicons/application_msword.png) |
Microsoft Word
MdKhushairi_NorAzah_ICMRP_v4FINALClaimCRIM.docx - Accepted Version Download (692kB) |
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: | Conference or Workshop Item (Speech) |
|---|---|
| Subjects: | Z Bibliography. Library Science. Information Resources > ZA Information resources 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: | 03 Feb 2014 16:02 |
| Last Modified: | 21 Nov 2016 08:24 |
| URI: | http://eprints.utem.edu.my/id/eprint/10992 |
| Statistic Details: | View Download Statistic |
Actions (login required)
 |
View Item |