Cover Image

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

Full description

Saved in:
Bibliographic Details
Main Authors: Md Khushairi, Norazah, Emran, Nurul Akmar, Mohd Yusof, Mokhtar
Format: Article
Language:English
Published: Penerbit UTeM 2018
Subjects:
Q Science (General)
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.211869

Similar Items