臺灣博碩士論文加值系統

近年來世界各地開始發展工業4.0技術以及物聯網之熱潮，也讓人們開始重視嵌入式系統開發，使其應用於各項產業並且提升工作效率之優勢。
本文主旨將針對半導體產業利用超純水來進行沖洗晶片或電子元件時，需要非常精密的監控水量，一旦水量的供應發生異常，不僅造成整條生產線都受到影響且停工外，還可能導致晶片及電子元件損壞使科技業損失慘重。
因此，本研究的目的是開發一種用於液體流量監控的嵌入式系統介面，以自來水為例，藉由物聯網(Internet Of Things; IOT)技術中的訊息佇列遙測傳輸(Message Queuing Telemetry Transport; MQTT)將超音波流量計的數據傳輸至樹莓派中，並建立人機介面(Node-RED)來進行資料讀取與監控，另外，為了能確保其穩定度，會建立MySQL資料庫存取資料並使用分析軟體來進行數據對照，找出兩者之間的校準誤差並執行修正，使其提高準確度。

In recent years, the development of Industry 4.0 and the Internet of Things (IoT) around the world has led people to emphasize the development of embedded systems, which can be applied to various industries and enhance the efficiency of their work.
This paper focuses on the semiconductor industry that utilizes ultrapure water for rinsing wafers or electronic components, which requires very precise monitoring of the amount of water. Once the water supply is abnormal, it not only causes the entire production line to be affected and shut down, but also may lead to the damage of the wafers and electronic components, resulting in heavy losses for the technology industry.
Therefore, the purpose of this study is to develop an embedded system interface for liquid flow monitoring, taking tap water as an example, by using Message Queuing Telemetry Transport (MQTT) in the Internet of Things (IOT) technology to transmit the data from the ultrasonic flow meter to the Raspberry Pi, and to build a system to monitor the flow of water. Raspberry Pi, and set up Node-RED to read and monitor the data. In addition, in order to ensure the stability, MySQL database is set up to access the data, and analyzing software is used to compare the data to find out the calibration error between the two and make corrections to improve the accuracy.

摘要................................................................... I
Abstract............................................................... II
誌謝................................................................... III
目錄................................................................... IV
表目錄................................................................. VI
圖目錄................................................................. VII
第一章 緒論........................................................... 1
1.1研究動機與目的....................................................... 1
1.2文獻探討............................................................ 2
1.3研究方法............................................................ 3
1.4論文架構............................................................ 4
第二章 超音波流量計與實驗設備介紹........................................ 5
2.1超音波流量計簡介..................................................... 5
2.1.1時差式超音波流量計.................................................. 5
2.1.2都卜勒超音波流量計................................................. 6
2.1.3非滿管超音波流量計................................................. 7
2.2實驗設備介紹......................................................... 7
2.2.1可程式邏輯控制器................................................... 7
2.2.2電動球閥........................................................... 8
2.2.3電流轉電壓信號轉換模組.............................................. 9
2.2.4 HX711電子秤重模組................................................. 10
2.2.5 Arduino UNO板 & W5100網路模組................................... 11
2.2.6樹莓派4B開發板..................................................... 13
2.2.7 Ubuntu作業系統.................................................... 14
第三章 流量監控系統設計與規劃............................................ 16
3.1前言................................................................ 16
3.2人機介面設計架構..................................................... 16
3.2.1數值資訊顯示....................................................... 19
3.2.2雲端資料庫與本地存檔設置............................................ 22
3.2.3異常警示通知系統................................................... 26
3.2.4 Node-RED平台之登入介面............................................ 28
3.3 PLC程式設計架構..................................................... 30
3.3.1 PLC符號名稱宣告................................................... 31
3.3.2簡易開關控制面板................................................... 32
3.3.3 PLC程式設計....................................................... 33
3.3.4 PLC裝置監控表..................................................... 39
3.4 人機介面遠端監控連線................................................. 39
第四章 實作與結果....................................................... 40
4.1前言................................................................ 40
4.2人機介面成果展示..................................................... 42
4.3 PLC控制成果展示..................................................... 49
4.4數據分析與成果....................................................... 52
第五章 結論與未來展望.................................................... 58
5.1結論................................................................ 58
5.2未來展望............................................................ 58
參考文獻............................................................... 59

[1] “物聯網”, WIKIPEDIA, April 2023.
[2] “MQTT”, WIKIPEDIA, April 2023.
[3] “工業4.0” ,WIKIPEDIA, April 2023.
[4] N S Kamaruidzaman, Siti Nazahiyah Rahmat, “Water Monitoring System Embedded with Internet of Things (IoT) Device: A Review”, IOP Conference Series: Earth and Environmental Science, 2020.
[5] Thinagaran Perumal, Md Nasir Sulaiman, C. Y. Leong, “Internet of Things (IoT) Enabled Water Monitoring System”, 2015 IEEE 4th Global Conf. on Consum. Electron. (Japan) 86-8, October 2015.
[6] K. Sathish Kannan, G. Thilagavathi, “Online farming based on embedded systems and wireless sensor networks”, 2013 International Conference on Computation of Power, Energy, Information and Communication (ICCPEIC) 71, April 2013.
[7] Mohd Amirul Aizad M. Shahrani, Safaa Najah Saud Al-Humairi, Nurul Shahira Mohammad Puad, Muhammad Asyraf Zulkipli, “River Water Quality Robot Embedded with Real-Time Monitoring System: Design and Implementation”, 2021 IEEE 12th Control and System Graduate Research Colloquium (ICSGRC), August 2021.
[8] G. Rajita, Nirupama Mandal, “Review on transit time ultrasonic flowmeter”, 2016 2nd International Conference on Control, Instrumentation, Energy & Communication (CIEC), January 2016.
[9] T.T. Yeh, P.I. Espina, S.A. Osella, “An intelligent ultrasonic flowmeter for improved flow measurement and flow calibration facility”, IMTC 2001. Proceedings of the 18th IEEE Instrumentation and Measurement Technology Conference. Rediscovering Measurement in the Age of Informatics (Cat. No.01CH 37188), May 2001.
[10] 詠業科技股份有限公司_超音波流量計，https://www.unictron.com/ultrasonic-transducers/applications/ultrasonic-flow-meter/?lang=zh-hant
[11] 李伯勳(2013)，管夾式超音波流量測量之換能器引致聲場研究，國立交通大學機械工程學系碩士班碩士論文，新竹市。
[12] 【產品/介紹】Raspberry Pi 4 Model B 樹莓派 | 樹莓派4 | Pi 4 | Pi 4B | Pi4B / 1GB / 2GB / 4GB / 8GB (英國UK製，現貨)， https://piepie.com.tw/28040/raspberry-pi-4-model-b
[13] 陳會安(2021)，Raspberry Pi樹莓派從不懂，到玩上手，台北市:旗標科技股份有限公司。
[14] 酆士昌(2019)，Ubuntu 19 完全自學手冊:桌面、系統與網路應用全攻略，新北市:博碩文化股份有限公司。
[15] 趙英傑(2019)，超圖解Arduino互動設計入門第3版，台北市:旗標科技股份有限公司。
[16] 張宥凱、張榮洲(2021)，三菱PLC與人機介面應用，新北市:新文京開發出版股份有限公司。
[17] 宓哲民、王文義、陳文耀、陳文軒 (2019)，PLC原理與應用實務，新北市:全華圖書股份有限公司。
[18] “Ubuntu”, WIKIPEDIA, April 2023.
[19] “MySQL”, WIKIPEDIA, April 2023.
[20] “HeidiSQL”, WIKIPEDIA, July 2023.
[21] HeidiSQL官方網站，https://www.heidisql.com/
[22] LINE Notify官方網站，https://notify-bot.line.me/zh_TW/
[23] 士林電機 AX2N-2DA類比輸出模組安裝使用說明書
[24] KEYENCE 嵌入式流量感測器 FD-Q系列操作手冊
[25] 微型電動執行器系列_電動球閥 使用說明書
[26] Node-RED官方網站，https://nodered.org/
[27] 嵌入式人機流量監控系統，https://reurl.cc/d73W7M
[28] HX711數據手冊(HX711 Datasheet by SparkFun Electronics)，https://www.digikey.com/htmldatasheets/production/1836471/0/0/1/hx711.html