Database tuning using oracle materialized view for manufacturing industry
The need to maintain database performance in Silterra Malaysia is crucial as data produced from complex manufacturing processes must be recorded in timely manner for reporting purposes. Query rewriting using Oracle Materialized View (MV) is one form of corrective action adopted by Silterra in order...
Saved in:
Main Authors: | , , |
---|---|
Format: | Article |
Language: | English |
Published: |
Machine Intelligence Research (MIR) Labs
2018
|
Subjects: | |
Online Access: | http://eprints.utem.edu.my/id/eprint/21968/2/IJCISIM_5.pdf http://eprints.utem.edu.my/id/eprint/21968/ http://www.mirlabs.org/ijcisim/regular_papers_2018/IJCISIM_5.pdf |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.utem.eprints.21968 |
---|---|
record_format |
eprints |
spelling |
my.utem.eprints.219682023-07-17T16:13:12Z http://eprints.utem.edu.my/id/eprint/21968/ Database tuning using oracle materialized view for manufacturing industry Md Khushairi, Norazah Emran, Nurul Akmar Menon, Anil Kumar Q Science (General) The need to maintain database performance in Silterra Malaysia is crucial as data produced from complex manufacturing processes must be recorded in timely manner for reporting purposes. Query rewriting using Oracle Materialized View (MV) is one form of corrective action adopted by Silterra in order to tune its database, which is usually affected by problematic SQLs. However, whether MVs are useful in most cases of query rewriting is an open problem. In this paper, the flow of SQL query rewriting process using MVs is presented. Steps to identify problematic SQLs and to rewrite them are given based on DBA’s experience in dealing with database performance issue in this industry. The result of using MVs shown using real fabrication data in Silterra reveals that, even though most MVs perform better than queries without MVs, there are cases that require alternative for MVs. Machine Intelligence Research (MIR) Labs 2018 Article PeerReviewed text en http://eprints.utem.edu.my/id/eprint/21968/2/IJCISIM_5.pdf Md Khushairi, Norazah and Emran, Nurul Akmar and Menon, Anil Kumar (2018) Database tuning using oracle materialized view for manufacturing industry. International Journal Of Computer Information Systems And Industrial Management Applications., 10. pp. 38-46. ISSN 2150-7988 http://www.mirlabs.org/ijcisim/regular_papers_2018/IJCISIM_5.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 |
Q Science (General) |
spellingShingle |
Q Science (General) Md Khushairi, Norazah Emran, Nurul Akmar Menon, Anil Kumar Database tuning using oracle materialized view for manufacturing industry |
description |
The need to maintain database performance in Silterra Malaysia is crucial as data produced from complex manufacturing processes must be recorded in timely manner for reporting purposes. Query rewriting using Oracle Materialized View (MV) is one form of corrective action adopted by Silterra in order to tune its database, which is usually affected by problematic SQLs. However, whether MVs are useful in most cases of query rewriting is an open problem. In this paper, the flow of SQL query rewriting process using MVs is presented. Steps to identify problematic SQLs and to rewrite them are given based on DBA’s experience in dealing with database performance issue in this industry. The result of using MVs shown using real fabrication data in Silterra reveals that, even though most MVs perform better than queries without MVs, there are cases that require alternative for MVs. |
format |
Article |
author |
Md Khushairi, Norazah Emran, Nurul Akmar Menon, Anil Kumar |
author_facet |
Md Khushairi, Norazah Emran, Nurul Akmar Menon, Anil Kumar |
author_sort |
Md Khushairi, Norazah |
title |
Database tuning using oracle materialized view for manufacturing industry |
title_short |
Database tuning using oracle materialized view for manufacturing industry |
title_full |
Database tuning using oracle materialized view for manufacturing industry |
title_fullStr |
Database tuning using oracle materialized view for manufacturing industry |
title_full_unstemmed |
Database tuning using oracle materialized view for manufacturing industry |
title_sort |
database tuning using oracle materialized view for manufacturing industry |
publisher |
Machine Intelligence Research (MIR) Labs |
publishDate |
2018 |
url |
http://eprints.utem.edu.my/id/eprint/21968/2/IJCISIM_5.pdf http://eprints.utem.edu.my/id/eprint/21968/ http://www.mirlabs.org/ijcisim/regular_papers_2018/IJCISIM_5.pdf |
_version_ |
1772816010701701120 |
score |
13.19449 |