A novel automatic virtual metrology system architecture for TFT-LCD industry based on main memory database

Min Hsiung Hung, Wen Huang Tsai, Haw Ching Yang, Yi Jhong Kao, Fan Tien Cheng

Research output: Contribution to journalArticlepeer-review

12 Citations (Scopus)


The semiconductor and thin-film-transistorliquid-crystal-display (TFT-LCD) industries widely value Automatic Virtual Metrology System (AVMS). AVMS needs to handle a large volume of VM-related data, which may cause poor internal database performance. In general, AVMS adopts efficient but expensive commercial database management systems (DBMSs) to yield good AVMS performance. This usually makes the AVMS construction cost very high. Therefore, the industries require a novel AVMS architecture with lower cost and greater efficiency in database. This paper proposes a novel AVMS architecture based on Main Memory Database (MMDB) technology. Specifically, the MMDB is used to improve the performance bottlenecks of the current Disk Resident Database (DRDB). Also, we design automatic data-backup and automatic data-query sources integration mechanisms to effectively relieve rapidly increased data volume in the original AVMS architecture. In addition, the novel AVMS architecture adopts a free commercial MMDB to significantly reduce total system cost. Integrated testing results show that the proposed AVMS architecture and developed technologies can enable the AVMS to have better data-storage efficiency, superior data-query performance, and lower database cost. The proposed AVMS architecture and research results in this paper can be a useful reference for TFT-LCD manufacturing companies in constructing their own AVM systems. The proposed AVMS architecture can also be applied in the semiconductor and solar-cell industries.

Original languageEnglish
Pages (from-to)559-568
Number of pages10
JournalRobotics and Computer-Integrated Manufacturing
Issue number4
Publication statusPublished - 2012 Aug

All Science Journal Classification (ASJC) codes

  • Control and Systems Engineering
  • Software
  • Mathematics(all)
  • Computer Science Applications
  • Industrial and Manufacturing Engineering


Dive into the research topics of 'A novel automatic virtual metrology system architecture for TFT-LCD industry based on main memory database'. Together they form a unique fingerprint.

Cite this