臺灣博碩士論文加值系統

在現今時代人們因肺部長期吸收空氣中的有害粒子如化學氣體、粉塵、抽菸或二手菸，因而造成慢性阻塞性肺疾病的患者日以俱增，目前肺部運動復健是此類患者維持身體不繼續惡化的主要治療方法。一般針對擁有慢性肺阻塞病患的復健方法是需要物理治療師在旁引導病患復健，所以在實際復健上將限制於成本以及依賴性。本論文中我們以穿戴式復健監控系統為基礎，透過MySQL資料庫的建構來紀錄患者的生理狀態，並以伺服器系統建立患者個人資訊並上傳回報生理狀態資料，進而提升遠端復健系統的監控品質與穩定性，讓醫護端能即時依據患者的復健狀況做出適應性的調整。

Air pollution has been a problem since the beginning of the industrial revolution in the late 1700s, which leads to the increasing number of COPD patients. In order to reduce symptoms, pulmonary rehabilitation may be the key to maintain pulmonary function and improve exercise capacity. Generally speaking, during a conventional rehabilitation procedure, a patient needs a physical therapist to provide information on recovery and rehabilitation guidance, which limits the effectiveness of pulmonary rehabilitation, considering its cost and operation dependence. Accordingly, based on a pervasive rehabilitation with wearable computing system, a MySQL database is used to record patients’ physiological information, and a web server is applied for the benefit of patients to establish personal information and upload the physiological data generated during the remote rehabilitation procedure such that the integrity and reliability of the rehabilitation system can be improved.

摘要....................................................i
Abstract...............................................ii
Contents..............................................iii
List of Tables..........................................v
List of Figures........................................vi
1. Introduction......................................1
1. 1. COPD..............................................1
1. 2. Wearable Computing................................2
1. 3. MySQL.............................................3
1. 4. Thesis Outline....................................3
2. Related Works.....................................5
2. 1. The MAFC Protocol.................................5
2. 2. Fuzzy Logic Architecture..........................6
2. 3. System Implementation............................10
2. 4. Bluetooth and Software...........................14
2. 5. Discussion.......................................17
2.5.1. Web-based application on medical system.........17
2.5.2.System architecture..............................19
3. Information Management System....................21
3. 1. Apache HTTP web server...........................21
3.1.1. Comparison of web server software...............22
3.1.2. The procedure of Apache.........................23
3. 2. MySQL............................................25
3.2.1. MySQL outside connection........................28
3. 3. PHP..............................................30
3. 4. phpMyAdmin.......................................32
4. Android SQLite database..........................34
4. 1. SQLite...........................................34
4.1.1. SQLite compare with MySQL.......................35
4. 2. SQLite on Android................................36
5. System Implementation............................40
5. 1. Software.........................................41
5.1.1. Browser.........................................43
5.1.2. Client side.....................................44
5.1.3. Hospital side...................................47
5.1.4. Other Function..................................49
5.1.5. Android App.....................................51
6. Conclusion......................................54
References.............................................55

[1]Carlin, B. W. (2009). Pulmonary rehabilitation and chronic lung disease: opportunities for the respiratory therapist. Respiratory care, 54 (8), 1091-1099.
[2]Casaburi, R. (2008). A brief history of pulmonary rehabilitation. Respiratory care, 53 (9), 1185-1189.
[3]McArdle, W. D., Katch, F. I., & Katch, V. L. (1991). Exercise physiology: energy, nutrition, and human performance. Medicine & Science in Sports & Exercise, 23 (12), 1403.
[4]McArdle, W. D., Katch, F. I., & Katch, V. L. (2010). Exercise physiology: nutrition, energy, and human performance: Lippincott Williams & Wilkins.
[5]Jolly, K., Taylor, R. S., Lip, G. Y., Singh, S., & Committee, B. S. (2008). Reproducibility and safety of the incremental shuttle walking test for cardiac rehabilitation. International journal of cardiology, 125 (1), 144-145.
[6]Steele, B. (1996). Timed walking tests of exercise capacity in chronic cardiopulmonary illness. Journal of Cardiopulmonary Rehabilitation and Prevention, 16 (1), 25-33.
[7]Turner, S. E., Eastwood, P. R., Cecins, N. M., Hillman, D. R., & Jenkins, S. C. (2004). Physiologic responses to incremental and self-paced exercise in COPD: a comparison of three tests. CHEST Journal, 126 (3), 766-773.
[8]Wu, M.-F., & Wen, C.-Y. (2012). A novel shuttle walking model using networked sensing and control for chronic obstructive pulmonary disease: A preliminary study. Paper presented at the 2012 6th International Conference on Pervasive Computing Technologies for Healthcare (Pervasive Health) and Workshops.
[9]Wen, T-M., & Wen, C.-Y (2016). Using Adaptive Fuzzy Control and Wearable Computing for COPD Rehabilitation, Master Thesis, Department of Electrical Engineering, National Chung Hsing University.
[10]Bluno (6 June 2016 ). Retrieved from
http://www.dfrobot.com/wiki/index.php/Bluno_SKU:DFR0267
[11]Bluno - An Arduino with Bluetooth 4.0. (2016). Retrieved from http://www.dfrobot.com/index.php?route=product/product&product_id=1044#.V26dyvl95hF
[12]Fabrício Ferracioli, Maria Angélica de O. Camargo-Brunetto (2015). A web-based application to help on assessment of respiratory system. Departamento de Computação – Universidade Estadual de Londrina (UEL) Caixa Postal 6001 – 86.051-990 – Londrina -PR – Brazil
[13]About the Apache HTTP Server Project (2008). Apache Software Foundation. Retrieved from http://httpd.apache.org/ABOUT_APACHE.html .
[14]PHP7 ChangeLog (2017). php.net. Retrieved from http://php.net/ChangeLog-7.php#7.1.6 .
[15]Lerdorf, Rasmus (2007-04-26). "PHP on Hormones – history of PHP presentation by Rasmus Lerdorf given at the MySQL Conference in Santa Clara, California". The Conversations Network. Retrieved from http://web.archive.org/web/20130729204354id_/http://itc.conversationsnetwork.org/shows/detail3298.html
[16] phpMyAdmin (2013) . phpMyAdmin. Retrieved from https://www.phpmyadmin.net/ .
[17]SQLite Release (June 8, 2017). Retrieved from https://www.sqlite.org/releaselog/3_19_3.html .
[18] PGCon 2014: Clustering and VODKA(Jan 6, 2017).
Lwn.net. Retrieved from https://lwn.net/Articles/601144/ .