Query rewriting using multitier materialized views for Cyber manufacturing reporting

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

Text JAMT published.pdf Download (1MB)

Abstract

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.

Item Type:	Article
Uncontrolled Keywords:	Multitier materialized views, SQL query rewriting, Cyber manufacturing, Cyber-physical systems, Industry 4.0
Subjects:	Q Science > Q Science (General)
Divisions:	Faculty of Information and Communication Technology
Depositing User:	Mohd. Nazir Taib
Date Deposited:	12 Jun 2019 07:14
Last Modified:	17 Jul 2023 16:32
URI:	http://eprints.utem.edu.my/id/eprint/21970
Statistic Details:	View Download Statistic

Actions (login required)

View Item