Abstract
In general, the objectives of this study were to identify and solve various issues in linking pavement performance related database. The detailed objectives were: to evaluate the state-of-the-art in information technology for data integration and data mining, to review the existing KyTC databases and study their potentiality for being linked for pavement performance evaluation, to prepare data linking alternatives for the KyTC’s review, to prepare an implementation plan for linking pavement related databases. The study reviewed the current practices of data integration by other organizations that face the similar challenges as KyTC. In addition, a review was conducted of the current major data sources in KyTC for possible integration. By using an example to examine the requirement for pavement performance modeling, the study identified pieces of important information currently missing.
The following recommendations were made: the missing critical information should be added to the existing or future databases; it is recommended that whenever a database is updated in the future, the existing data should be well archived; data integrity and consistency should be checked when an engineer or operator adds data to a database; based on the status of current data in KyTC, it is recommended that an offline separate database can be made by extracting critical information from historical and existing data sources to serve the purpose of pavement analysis; the data processing method used in this study may be used to update other existing data sources; the basic information of a pavement section can be queried through a GIS map. In the future, the GIS map, along with the concise offline database, can be posted online for reviewing and downloading.
Report Date
3-2007
Report Number
KTC-07-11/SPR272-04-1F
Digital Object Identifier
http://dx.doi.org/10.13023/KTC.RR.2007.11
Repository Citation
Wang, Yuhong and Allen, David L., "Evaluation of Linking Pavement Related Databases" (2007). Kentucky Transportation Center Research Report. 144.
https://uknowledge.uky.edu/ktc_researchreports/144
Notes
The contents of this report reflect the views of the authors, who are responsible for the facts and accuracy of the data presented herein. The contents do not necessarily reflect the official views or policies of the University of Kentucky, the Kentucky Transportation Cabinet, nor the Federal Highway Administration. This report does not constitute a standard, specification, or regulation. The inclusion of manufacturer names or trade names is for identification purposes only and are not to be considered as endorsements.