臺灣博碩士論文加值系統

EduTalk是一個3D互動式程式設計的教學平台，可為不同的傳感器實現異構連接，並為用戶提供在其上進行物理實驗的能力。但是由於它缺乏處理大規模物理實驗數據的功能。因此，在本篇論文中，我們描述如何使用FileLogger設備在EduTalk中記錄大規模物理實驗數據，以及如何將其導出到Excel文件，和如何通過DataBank管理模組，將導出之文件下載到用戶本地端，供用戶進行進一步的分析。
由於我們需要為用戶提供計算和服務資源，基於雲端平台是一個合適的解決方案，因此我們在本篇論文中，描述如何開發一個自動部署系統，讓用戶能夠輕鬆地於雲端平台部署EduTalk等系統，並操作其中華電信雲端服務帳戶內的虛擬機。

EduTalk, a 3D interactive programming education platform with IoT, enables heterogeneous connection for different sensors and provides users to do physics experiments on it. But it lacks the functions to process large scale physics experiment data. Therefore, in this thesis, we describe how to record large scale physics experiment data in EduTalk with the FileLogger device and to export them to the Excel files and download the export file to localhost through the DataBank management module for user to do further analysis.
Since we need to provide users with computing and service resources, cloud-based platform is a suitable solution. In this thesis, we describe how to implement the Automatic deployment CLI for users to easily deploy a cloud-based physics experiment platform and operate the cloud virtual machines (VMs) in their CHT Hicloud account.

摘要 i
Abstract ii
誌謝 iii
List of contents iv
List of figures v
1. Introduction 1
1.1. Related Works 2
1.2. FileLogger and EduTalk automatic deployment 4
2. Architecture 6
2.1. IoTtalk architecture 6
2.2. Edutalk architecture 7
2.3. The FileLogger device and Databank Management architecture 11
2.4. Automatic deployment architecture 15
3. FileLogger device Implementation 17
3.1. Sending sensor data samples with timestamps 17
3.2. Receiving sampled sensor data with timestamps 20
3.3. Implementation of the SA/DA of FileLogger device 22
4. Databank implementation 27
4.1. Inserting the data sources to Elasticsearch DB 27
4.2. Querying and exporting data from the DataBank management 30
5. The Automatic deployment system implementation 34
5.1. The Automatic deployment CLI 34
5.2. The Event handler of the Automatic deployment system 36
5.3. The Management procedures of the Automatic deployment system 37
5.4. The operation example of the Automatic deployment system 37
6. Conclusion and future work 40
6.1. Conclusion 40
6.2. Future work 40
7. References 44

[1]Parker Hannifin Corp, Inertial Sensors Spec, https://reurl.cc/GV4RmW, https://ww
w.microstrain.com/inertial/3DM-GX5-25, 2020
[2]XSens, MEMS sensor high sample rate, https://www.xsens.com/accelerometers
[3]National Chip Implementation Center, MorSensor, https://www.youtube.com/watch
?v=zCgJ_B9_f5M
[4]Taiwan Communication Survey, TCS Newsletter, “Survey on Internet Use of Gene-
ration Z Youth about high school students Smartphone utilization”, Vol. 76, 2018, ht
tp://www.crctaiwan.nctu.edu.tw/epaper/%E7%AC%AC76%E6%9C%9F20181121.
htm
[5]Min-Zheng Shieh, Yu-Hsuan Hu, Yi-Bing Lin, “EduTalk: A 3D Interactive Progra-
mming Education Platform with IoT”, 2020
[6]Syslog, syslog-ng introduction, https://www.syslog-ng.com/
[7]Elasticsearch, Logstash introduction, https://www.elastic.co/logstash
[8]Fluentd, Fluentd Introduction, https://www.fluentd.org/
[9]Wiki, Logstash, https://wikitech.wikimedia.org/wiki/Logstash
[10]Elasticsearch, Logstash Input plug-ins, https://www.elastic.co/guide/en/logstash/cu
rrent/input-plugins.html
[11]Elasticsearch, Elasticsearch introduction, https://www.elastic.co/elasticsearch/
[12]Elasticsearch, Logstash Output plug-ins, https://www.elastic.co/guide/en/logstash/ current/output-plugins.html
[13]Sampo Suonsyrjä,Tommi Mikkonen, "Designing an Unobtrusive Analytics Fram-
ework for Monitoring Java Applications", pp. 170–173 in Software Measurement,
Springer, 2015
[14]Fluentd, Fluentd key features, https://www.fluentd.org/architecture
[15]Fluentd, Input and output plug-ins of Fluentd, https://www.fluentd.org/datasources, https://www.fluentd.org/dataoutputs
[16]CHT, CHT Hicloud introduction, http://hicloud.hinet.net/
[17]Google Cloud Platform, Google Cloud Platform pricing calculator, https://cloud.g
oogle.com/products/calculator/#id=292838cc-f672-455f-9c91-b6caa5a74bed
[18]Amazon Web Service, AWS pricing calculator, https://calculator.aws/#/createCalc
ulator
[19]Azure, Azure pricing calculator, https://azure.microsoft.com/zh-tw/pricing/calculat
or/
[20]Chunghwa Telecom Co., CHT Hicloud pricing calculator, https://userportal.hiclou
d.hinet.net/cloud/
[21]NCC, the Mobile communication market statistics, https://www.ncc.gov.tw/chines
e/files/19070/3773_41619_190927_1.pdf, 2019
[22]OpenSignal, Taiwan Mobile Network's experience report, https://www.opensignal.
com/zh-hant/reports/2019/12/taiwan/mobile-network-experience, 2019
[23]Arcivanov, The usage of the FluentdSender interface, https://github.com/fluent/flu
ent-logger-python#usage
[24]Treasure Data, the td-agent instruction and the installation steps illustration, https:/
/docs.fluentd.org/installation/install-by-deb, 2020
[25]Treasure Data, The td-agent installation script, http://toolbelt.treasuredata.com/sh/i
nstall-ubuntu-xenial-td-agent2.5.sh
[26]Treasure Data, fluent-logger-python (A python client library for Fluentd), https://d
ocs.fluentd.org/v/0.12/articles/python, 2019
[27]DB-Engines, DB-Engines Ranking of Search Engines, https://db-engines.com/en/r
anking_trend/search+engine, 2020
[28]Elasticsearch, Network settings, https://www.elastic.co/guide/en/elasticsearch/refe
rence/current/modules-network.html
[29]Elasticsearch, Discovery and cluster formation settings, https://www.elastic.co/gui
de/en/elasticsearch/reference/current/modules-discovery-settings.html
[30]Elasticsearch, Setting the heap size, https://www.elastic.co/guide/en/elasticsearch/r
eference/current/heap-size.html
[31]Excel Easy, Worksheet, https://www.excel-easy.com/basics/worksheets.html
[32]Ying-Ying, Automatic deployment, https://gitlab.com/Ying-Ying/automatic-deploy
ment, 2020
[33]CHT, Applying Access Key, http://hws.hicloud.hinet.net/hws-doc/zh_TW/rest/tuto
rial/accessKey.html, 2017
[34]Ying-Ying, EduTalk v2 Benchmark test, https://docs.google.com/spreadsheets/d/1
_NtMFbe-RIn7fukmSpjUtGj-1H0U2oTRHOsVLc2cGXs/edit?usp=sharing, 2020