Query rewriting using multitier materialized views for Cyber manufacturing reporting
Within cyber manufacturing context, Internet of Data (IoD) technology has enabled manufacturing sector to store and transfer mass data rapidly for processing. Data growth which is driven by advancement in the way data are produced and interconnected has caused volume of data a crucial issue to addre...
Saved in:
Main Authors: | , , |
---|---|
Format: | Article |
Language: | English |
Published: |
Penerbit UTeM
2018
|
Subjects: | |
Online Access: | http://eprints.utem.edu.my/id/eprint/21970/2/JAMT%20published.pdf http://eprints.utem.edu.my/id/eprint/21970/ http://journal.utem.edu.my/index.php/jamt/article/view/4008 |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.utem.eprints.21970 |
---|---|
record_format |
eprints |
spelling |
my.utem.eprints.219702023-07-17T16:32:58Z http://eprints.utem.edu.my/id/eprint/21970/ Query rewriting using multitier materialized views for Cyber manufacturing reporting Md Khushairi, Norazah Emran, Nurul Akmar Mohd Yusof, Mokhtar Q Science (General) Within cyber manufacturing context, Internet of Data (IoD) technology has enabled manufacturing sector to store and transfer mass data rapidly for processing. Data growth which is driven by advancement in the way data are produced and interconnected has caused volume of data a crucial issue to address. As such, in monitoring delicate wafer processing in semiconductor manufacturing, reporting delay problem caused by databases of high data volumes is intolerable. This is because, various reports (that require access to large databases) need to be frequently generated in the shortest time possible. Reporting delay is usually handled through SQL query rewriting.In this paper, the results of experimenting SQL query rewriting by utilizing multitier materialized views structure is presented.In particular, we define sub-materialized views (SMVs) concept, and implement it using real data sets from SilTerra (a semiconductor industry). The outcome of the experiment supports the hypothesis that SQL query rewriting using SMV outperforms the classic rewriting. The results reveal that the performance of SMV is far better (than without SMV) for complex queries against large data sets. The benefits of SMV are not limited to cyber manufacturing domain as the use of SMV can contribute other industries with similar problem. Penerbit UTeM 2018 Article PeerReviewed text en http://eprints.utem.edu.my/id/eprint/21970/2/JAMT%20published.pdf Md Khushairi, Norazah and Emran, Nurul Akmar and Mohd Yusof, Mokhtar (2018) Query rewriting using multitier materialized views for Cyber manufacturing reporting. Journal of Advanced Manufacturing Technology (JAMT) , 12. pp. 393-407. ISSN 1985-3157 http://journal.utem.edu.my/index.php/jamt/article/view/4008 |
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 Mohd Yusof, Mokhtar Query rewriting using multitier materialized views for Cyber manufacturing reporting |
description |
Within cyber manufacturing context, Internet of Data (IoD) technology has enabled manufacturing sector to store and transfer mass data rapidly for processing. Data growth which is driven by advancement in the way data are produced and interconnected has caused volume of data a crucial issue to address. As such, in monitoring delicate wafer processing in semiconductor manufacturing, reporting delay problem caused by databases of high data volumes is intolerable. This is because, various reports (that require access to large databases) need to be frequently generated in the shortest time possible. Reporting delay is usually handled through SQL query rewriting.In this paper, the results of experimenting SQL query rewriting by utilizing multitier materialized views structure is presented.In particular, we define sub-materialized views (SMVs) concept, and implement it using real data sets from SilTerra (a semiconductor industry). The outcome of the experiment supports the hypothesis that SQL query rewriting using SMV outperforms the classic rewriting. The results reveal that the performance of SMV is far better (than without SMV) for complex queries against large data sets. The benefits of SMV are not limited to cyber manufacturing domain as the use of SMV can contribute other industries with similar problem. |
format |
Article |
author |
Md Khushairi, Norazah Emran, Nurul Akmar Mohd Yusof, Mokhtar |
author_facet |
Md Khushairi, Norazah Emran, Nurul Akmar Mohd Yusof, Mokhtar |
author_sort |
Md Khushairi, Norazah |
title |
Query rewriting using multitier materialized views for Cyber manufacturing reporting |
title_short |
Query rewriting using multitier materialized views for Cyber manufacturing reporting |
title_full |
Query rewriting using multitier materialized views for Cyber manufacturing reporting |
title_fullStr |
Query rewriting using multitier materialized views for Cyber manufacturing reporting |
title_full_unstemmed |
Query rewriting using multitier materialized views for Cyber manufacturing reporting |
title_sort |
query rewriting using multitier materialized views for cyber manufacturing reporting |
publisher |
Penerbit UTeM |
publishDate |
2018 |
url |
http://eprints.utem.edu.my/id/eprint/21970/2/JAMT%20published.pdf http://eprints.utem.edu.my/id/eprint/21970/ http://journal.utem.edu.my/index.php/jamt/article/view/4008 |
_version_ |
1772816010947067904 |
score |
13.19449 |