University of California Pavement Research Center

This document covers the design, implementation and usage of the heavy vehicle simulator (HVS) database in use by the Pavement Research Center (PRC) at the University of California (UC), which is referred to as the PRC-HVS database. This report describes the portion of the database used to store all of the data collected directly from HVS test sections. The same database is used to store data from both flexible and rigid pavement sections. Not included in this report are discussions of the environmental data, long term pavement performance data, and laboratory testing data, which are also included in the PRC database and which have been collected since 1995 during the operation of the two Caltrans heavy vehicle simulators. This report is broken into three main sections. The first provides some background about the HVS activities and the reasons for various choices in the database design. The second covers the design of the database. The final section covers the processing of the data as it is loaded into the database. Besides the raw data files collected during testing, the database consists of two components: a Microsoft Access® database, PRC-HVS.mdb (referred to as the database) and a Microsoft Excel® spreadsheet, PRC-HVSLoader.xls, (referred to as the loader). The database is also stored in an Oracle® database, which is used to drive a World Wide Web site. The Web site can be used to view the data.