The Design of Data Warehouse for Highway Maintenance Management
| Autor: | Wen-Fu Wang, 王文甫 |
|---|---|
| Rok vydání: | 2008 |
| Druh dokumentu: | 學位論文 ; thesis |
| Popis: | 96 The government has been dedicating to electronic managements in the last few years. Organizations, such as the Ministry of Transportation and Communications, have been aiming at the development of maintenance management systems for bridges, pavement, slope, and assets, etc. These systems have helped to improve the efficiency of the entire highway maintenance works. However, since highway maintenance works are usually inter-connected and the fact that most developed systems seemed to only focus on the patrol related information, there is still lack of a complete system that can thoroughly support the highway maintenance works. In addition, some data are identical and duplicated in many existing systems. This leads to further problems such as data inconsistency and waste of resources. Therefore, the purpose of this research is to establish a complete highway maintenance database to resolve the previous problems and form as the foundation for any highway maintenance related system. This research implemented the Data Warehouse concepts to the data preservation of highway maintenance works. According to previous studies, the overall highway maintenance works can roughly be classified into 5 different groups with 20 major tasks. In order to design an ideal data warehouse, this research conducted a series of interviews to study the standard operation procedures as well as critical data for supporting operation and management for each of the 20 maintenance tasks. A data warehouse consisted of 169 tables was designed. This research also studied the corporation of data warehouse with existing highway maintenance systems. An XML data exchange mechanism was also established. |
| Databáze: | Networked Digital Library of Theses & Dissertations |
| Externí odkaz: |
|