Comparison of Database Models for Developing a Pavement Performance Analysis System

  • Published : 2004.08.01

Abstract

One of the most difficult tasks in pavement management information systems is establishing the links between performance measures of a structure and the design and construction inputs. In-situ pavement performance can be considered a response variable to many project input variables, such as design, construction, and traffic loading effects. If we are to fully understand the component of pavement performance and specify the inputs through design and construction specifications to achieve that performance we must develop quantitative relationship between input and response variables through a scientific, fully integrated Pavement Performance Analysis System (PPAS). Hence, the objective of this study is to design a database model required for developing an effective database template that will allow analysis of pavement performance measures based on design and construction information linked by location. In order to select the most appropriate database model, a conceptual database model (Entity Relationship Model) and dimensional model, which is believed to be the most effective modeling technique for data warehouse project, are designed and compared. It is believed that other state highway agencies could adopt the proposed design strategy for implementing a PPAS at the discretion of the state highway agencies.

Keywords

References

  1. Nyerges, T.L. (1990). Locational Referencing and Highway Segmentation in a Geographic Information System. ITE Journal, Vol. 27
  2. Quality Management Program Guide/Procedure Manual. (1999). Wisconsin Department of Transportation, Div. of Transportation Infrastructure Development, Bureau of Highway Construction
  3. Schmit, R.L. (1998). Development of Statistically-Based Methods to Determine QC/QA Testing Levels for Hot-Mix Asphalt Construction, PhD thesis. Div. Of Const. Engr. And Mange,University of Wisconsin, Madison
  4. Choi, Jae-ho. (2002). Framework of Developing Performancerelated Specifications at WisDOT, PhD thesis. Div. Of Const. Engr. And Mange, University of Wisconsin, Madison
  5. Kimball, R. (1998). The Data Warehouse, Life Cycle Toolkit, expert methods for designing, developing, and deploying data warehouses. Wiley, Inc., New York
  6. Matthias, et al. (2000). Fundamentals of Data Warehouses, Springer, New York
  7. Song, ll-yeol and Kelly Levan-Shultz. (1999). Data Warehouse Design for E-Commerce Environments. Lecture notes in computer science. ISSUE 1727, Springer Verlag, New York.
  8. Mennecke, B. and Higgins, G. (1999). Spatial Data in the Data Warehouse : A Nomenclature for Design and Use. Proceedings of the Americas conference on information systems. Americas conference $5^{th}$, Milwaukee, WI