Review of Materialized Views Selection Algorithm for Cyber Manufacturing

Authors

  • Nor Amalina Mohd Sabri Computational Intelligence Technologies (CIT), Center of Advanced Computing Technologies (CACT), Universiti Teknikal Malaysia Melaka (UTeM), 76100 Durian Tunggal, Melaka, Malaysia.
  • Nurul A. Emran Computational Intelligence Technologies (CIT), Center of Advanced Computing Technologies (CACT), Universiti Teknikal Malaysia Melaka (UTeM), 76100 Durian Tunggal, Melaka, Malaysia.
  • Nor’azah Md Khushairi Computational Intelligence Technologies (CIT), Center of Advanced Computing Technologies (CACT), Universiti Teknikal Malaysia Melaka (UTeM), 76100 Durian Tunggal, Melaka, Malaysia. SilTerra Malaysia Sdn Bhd, 09000 Kulim, Malaysia

Keywords:

Materialised View Selection, Bio-Inspired Algorithm, Optimisation Algorithm, Cyber Manufacturing, Industry 4.0,

Abstract

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.

Downloads

Published

2018-07-05

How to Cite

Mohd Sabri, N. A., Emran, N. A., & Md Khushairi, N. (2018). Review of Materialized Views Selection Algorithm for Cyber Manufacturing. Journal of Telecommunication, Electronic and Computer Engineering (JTEC), 10(2-8), 15–19. Retrieved from https://jtec.utem.edu.my/jtec/article/view/4451

Issue

Vol. 10 No. 2-8: Embracing The 4th Industrial Revolution: Innovation in Telecommunication, Electronic & Computer Engineering IV

Section

Articles

License

TRANSFER OF COPYRIGHT AGREEMENT

The manuscript is herewith submitted for publication in the Journal of Telecommunication, Electronic and Computer Engineering (JTEC). It has not been published before, and it is not under consideration for publication in any other journals. It contains no material that is scandalous, obscene, libelous or otherwise contrary to law. When the manuscript is accepted for publication, I, as the author, hereby agree to transfer to JTEC, all rights including those pertaining to electronic forms and transmissions, under existing copyright laws, except for the following, which the author(s) specifically retain(s):

  1. All proprietary right other than copyright, such as patent rights
  2. The right to make further copies of all or part of the published article for my use in classroom teaching
  3. The right to reuse all or part of this manuscript in a compilation of my own works or in a textbook of which I am the author; and
  4. The right to make copies of the published work for internal distribution within the institution that employs me

I agree that copies made under these circumstances will continue to carry the copyright notice that appears in the original published work. I agree to inform my co-authors, if any, of the above terms. I certify that I have obtained written permission for the use of text, tables, and/or illustrations from any copyrighted source(s), and I agree to supply such written permission(s) to JTEC upon request.