整合異質資料結構之運動競賽成績資料庫：以全民運動會競賽成績查詢網站為例

目的：本研究旨在發展一個可以用來涵括各種運動項目之競賽成績資料庫系統，並可應用於綜合運動賽會中。方法：依物件導向系統分析與設計方法論，建構出競賽成績查詢系統之架構與流程，而在解決各運動種類成績異質性的問題上，則採用資料抽象化的技巧，將各類型之競賽成績，經過一般化、集合化、聚合化後，建構出統一化的資料庫欄位，最後以對戰型比賽、非對戰型比賽、非對戰特殊型比賽三種資料庫的結構來呈現。結果：以105年全民運動會為實作案例完成競賽成績查詢系統開發，建立了10種成績查詢功能，涵蓋了全部共27種競賽種類，並於不同查詢需求下以資料動態整合即時生成報表，減少資料重複記錄、抄錄次數。結論：綜合賽會中不同競賽成績統一化之記錄與呈現，可藉由本研究所提出的資料庫結構，解決異質性資料整合的問題，並降低系統設計的複雜度，以簡化依各個運動項目進行客製化的需求，其成果可做為往後舉辦相關賽會之參考。

關鍵字

競賽資訊系統；運動賽會管理；統一資料模型

並列摘要

Purpose: The study was to develop a competition score database system by integrating heterogeneous data schema from various sports competitions. An empirical study of the citizens games was presented to verify the appropriateness. Methods: The methodology of object-oriented system analysis and design was adapted to construct the system architecture and processing flow. The techniques of data abstraction, were applied to solve the problem of the heterogeneous data gather from various sport competition. The unified data schemas were constructed by generalizing, associating, and aggregating. Three types of schemas named as match, non-match, and non-match special were derived to present the competition scores. Results: The competition score database was implemented as a real case of the 2016 Taiwan citizens games. 10 kinds of query functions coving 27 competitions were built. The query results were retrieved by dynamic data integration in real time to avoid duplicate recording. Conclusion: The proposed unified data schemas could be used in developing the competition scores system covering various kinds of sports with the benefits of reducing the complexity and avoiding customized requests. The real case demonstrated in this study could provide a valuable reference for large-scale sports events.