簡易檢索 / 詳目顯示

研究生: 吳晨榕
Wu, Chen-Jung
論文名稱: 鐵路養護管理資訊系統架構之初探
A Preliminary Study of the Framework of Railway Maintenance Management Information System
指導教授: 郭振銘
Kuo, Chen-Ming
學位類別: 碩士
Master
系所名稱: 工學院 - 土木工程學系
Department of Civil Engineering
論文出版年: 2021
畢業學年度: 109
語文別: 中文
論文頁數: 86
中文關鍵詞: 鐵路養護資訊管理系統資料庫軌道規範MySQL
外文關鍵詞: Railway maintenance, Information management system, Database, Track specification, MySQL
相關次數: 點閱:231下載:10
分享至:
查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統 勘誤回報
  • 近年來鐵路事故頻頻登上媒體版面,皆反映出鐵路單位目前的檢修管理模式流程需要改革。臺灣鐵路(簡稱臺鐵)的養護檢修資訊多以紙本方式儲存,取用和分析上較不便,本研究欲將鐵路檢修紀錄電子化,並建立資料庫架構,提供養護資料管理系統雛型,增加養護資訊的利用價值,進而提高鐵路營運安全與服務品質。
    本研究以1067公厘軌距軌道橋隧檢查養護規範、1067公厘軌距鐵路長焊鋼軌鋪設及養護規範、高雄工務段提供之養護檢查紀錄表單作為資料庫系統關聯項目,以Microsoft Excel作為讀取資料表單、Python作為系統運作程式語言、MySQL作為鐵路養護資料庫,實現養護檢修資料進入系統後能依據規範標準判定軌道狀態,並產出檢查報告,同時將該筆資料存入資料庫,使用者能從資料庫中依需求抓取所需資料進行更多處理。
    將鐵路養護檢查之真實記錄輸入系統,並與原先人工判定方式做比對,發現判定結果大致相同,並選定軌溫監測記錄、噴泥檢查、線形不整資料進行處理分析,可以分別看出檢查項目在不同路況、時間的數量變化與量測值大小。透過本系統,大量養護數據能被簡易查找利用,與紙本紀錄相比,數據處理效率明顯提高,但本系統雛型仍有非常多需要完善的部分,也需擴增更多功能,才能發揮系統最大價值。

    Most of the maintenance information of Taiwan Railways is stored in paper format, which is inconvenient to access and analyze. This research intends to digitize maintenance data and establish a database. Establishing a prototype of maintenance management information system can increase the use-value of maintenance information.
    This study uses the maintenance specifications and the maintenance record form provided by Taiwan Railways as the related items of the database system. Microsoft Excel as the interface for reading data, Python as the system operation program, and MySQL as the railway maintenance database. After the maintenance and repair data enter the system, the track status can be judged according to the norms, and the inspection report can be output. At the same time, the data is stored in the database, and the user can filter the required data from the database for more processing.
    Input the real record of railway maintenance inspection into the system and compare it with the manual method, it is found that the judgment results are roughly the same, and the data in the database can be easily searched and used. Compared with paper records, the data processing efficiency of this system is improved. The prototype of the system still has many parts that need to be improved, and more functions need to be expanded to maximize the value of the system.

    摘要 I 誌謝 V 目錄 VI 表目錄 VIII 圖目錄 IX 第1章 緒論 1 1.1研究動機與目的 1 1.2研究範圍 2 1.3研究流程 2 1.4章節規劃 5 第2章 文獻回顧 6 2.1鐵路養護管理資訊系統相關文獻 6 2.1.1系統效能 6 2.1.2系統架構 8 2.2國內鐵路養護規範 12 2.2.1 1067公厘軌距軌道橋隧檢查養護規範[2] 13 2.2.2 1067公厘軌距鐵路長焊鋼軌鋪設及養護規範[3] 16 第3章 鐵路養護數據關聯架構 17 3.1規範篩選結果與分類項目 17 3.2臺鐵養護表單與現況 20 3.2.1表單種類與檢測項目 20 3.2.2養護檢查與記錄 22 3.3系統資料項目選擇 25 3.3.1分類流程 25 3.3.2結果 29 第4章 系統雛型建立 31 4.1架構雛型與系統運作邏輯 31 4.1.1需核對規範判定項目 32 4.1.2免核對規範判定項目 37 4.1.3系統改善期許 39 4.2使用軟體 40 4.2.1 Microsoft Excel試算表 40 4.2.2 Python 44 4.2.3 MySQL 46 4.3系統驗證 51 4.3.1資料判定比較 51 4.3.2真實資料輸入系統之資料管理應用 55 第5章 鐵路養護管理資訊系統應用藍圖 69 5.1感測器設置 71 5.1.1裝設項目 71 5.1.2應用 72 5.2軌道劣化趨勢預測 73 5.3區域特點報告分析 74 5.4連結BIM、智慧鐵道 75 第6章 結論與建議 79 6.1結論 79 6.2建議 80 參考文獻 81 附錄 83

    [1] 交通部臺灣鐵路管理局, "考察英國鐵路營運管理系統與軌道相關產業發展現況," pp. 39-43, 2009.
    [2] 交通部, "1067公厘軌距軌道橋隧檢查養護規範," 2014.
    [3] 交通技術標準規範鐵路類工務部, "1067公厘軌距鐵路長焊鋼軌鋪設及養護規範," 2018. 交通部技監室.
    [4] V. Stuchly, J. Grencik, and R. Poprocky, "Railway vehicle maintenance and information systems," WIT Transactions on The Built Environment, vol. 50, 2000.
    [5] S. Jovanovic and D. Bozovic, "Optimal structure and two case study implementations of a railway maintenance management system," Journal of Management in Engineering, vol. 31, no. 2, p. 05014013, 2015.
    [6] T. Jiang, X. An, and C. Liu, "Research on Rail Track Maintenance Management Information Systems," Springer Berlin Heidelberg, 2016, pp. 765-775.
    [7] K. Gjordeni and A. Kaya, "Digitizing the Maintenance Management Operation: Exploring the Opportunities of an Information System in a Railway Maintenance Organization," ed, 2019.
    [8] 陈建伟, "信息系统在香港地铁运营管理中的应用," 城市軌道交通研究, vol. 10, no. 9, pp. 1-5, 2007.
    [9] M.-Y. Li, K.-Q. Han, X.-Y. Zhang, X.-L. Li, Y.-J. Zhai, and W.-H. Yu, "A management information system for mine railway transportation equipment," Journal of China University of Mining and Technology, vol. 18, no. 3, pp. 373-376, 2008.
    [10] 甄勇 and 吕清华, "铁路限界综合管理信息系统设计," 廣西科學院學報, vol. 24, no. 4, pp. 331-333, 2008.
    [11] 郭辉, "铁路营销信息化项目管理的探讨," 鐵道貨運, vol. 2009, no. 2, pp. 16-19, 2009.
    [12] 鄭明淵, 吳育偉, 邱永芳, 曾文傑, 許育誠, and 王大同, "工程資訊管理系統開發技術與運用之研究," 港灣季刊, no. 108, pp. 16-34, 2017.
    [13] 交通部, "鐵路修建養護規則," 2017.
    [14] 交通部台灣鐵路管理局, "交通部台灣鐵路管理局鐵路建設作業程序," 2018.
    [15] http://rhinohcp.blogspot.com/2008/03/em80.html.
    [16] https://www.microsoft.com/zh-tw/microsoft-365.
    [17] https://www.microsoft.com/zh-tw/sql-server/.
    [18] https://www.mysql.com.
    [19] https://www.oracle.com/tw/database/technologies/.
    [20] E. 2014, "Directive 2014/24/EU of the European Parliament and of the Council of 26 February 2014 on Public Procurement and Union Repealing Directive 2004/18/EC."
    [21] G. Dell’Acqua, S. G. De Oliveira, and S. Biancardo, "Railway-BIM: Analytical review, data standard and overall perspective," Ingegneria Ferroviaria, vol. 73, no. 11, pp. 901-923, 2018.
    [22] 蘇瑞育, 林志全, and 陳昭惠, "世曦大樓導入 BIM 智慧型設施管理系統的整合與應用經驗," 技師期刊, no. 79, pp. 39-51, 2017.
    [23] https://www.bentley.com/en/products/product-line/civil-design-software/openrail-designer.
    [24] https://www.microsoft.com/en-us/hololens.

    下載圖示 校內:立即公開
    校外:立即公開
    QR CODE