The Research on Querying Road-Closing Alert Messages

• Main Authors: He, Shu-Han, 何書涵
• Other Authors: Chang, Ya-Hui
• Format: Others
• Language: zh-TW
• Published: 2019
• Online Access: http://ndltd.ncl.edu.tw/handle/73ceuu

碩士 === 國立臺灣海洋大學 === 資訊工程學系 === 107 === In recent years, the government has actively promoted the open data policy. By integrating the open data offered by different organizations into a single portal, citizen and program developers can query and use. This paper specifically aims at the road-closing alert messages got from the disaster warning platform, and discusses how to create a system that can manage the road-closing information. We consider three types of queries, which are spatial queries, temporal queries and mixed queries. In order to provide these three types of querying methods, we pre-process the road-closing alert messages to create the spatial index and the temporal index, respectively. We perform several experiments to evaluate our system. The final results show that both indices will improve query efficiencies, and the spatial index is even better. Therefore, we use the spatial index to process the mixed query and obtain good performance.