Review of materialized views selection algorithm for cyber manufacturing

Technological advancement in data transfer and connection has driven massive data growth. Within the semiconductor cyber manufacturing environment, in order to cope with rapid data transfer enabled by the Internet of Things (IoT) technology, rapid query processing becomes a priority. Especially, in...

Full description

Saved in:
Bibliographic Details
Main Authors: Mohd Sabri, Nor Amalina, Emran, Nurul Akmar, Md Khushairi, Norazah
Format: Article
Language:English
Published: Penerbit Universiti,UTeM 2018
Subjects:
Online Access:http://eprints.utem.edu.my/id/eprint/21969/2/published%20JTEC.pdf
http://eprints.utem.edu.my/id/eprint/21969/
http://journal.utem.edu.my/index.php/jtec/article/view/4451
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Universiti Teknikal Malaysia Melaka
Language: English
Description
Summary:Technological advancement in data transfer and connection has driven massive data growth. Within the semiconductor cyber manufacturing environment, in order to cope with rapid data transfer enabled by the Internet of Things (IoT) technology, rapid query processing becomes a priority. Especially, in the era of Industry 4.0, semiconductor manufacturing that operates within cyber-physical systems (CPS) relies heavily on the reporting function to monitor delicate wafer processing. Thus, delay in reporting which is usually caused by slow query processing is intolerable. Materialized views (MVs) are usually used in order to improve query processing speed. Nevertheless, as MVs requires database space and maintenance, the decision to use MVs is not determined by time factor only. Thus,MVs selection is a problem that calls for an efficient selection algorithm that can deal with several constraints at a time. In this paper, we reveal the criteria of optimisation algorithms that were proposed to deal with MVs selection problem. In particular, this paper attempts to evaluate the coverage and limitations of the algorithm under study.