The National Academies Press

Currently Skimming:

Pages 43-59

The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.

From page 43... ... 43 C H A P T E R 4 Pavement-Maintenance Database Software Application The PMDb framework includes a two-part record processing system and a single page web application acting as the user interface to filter, search, and download records. In the first phase of ingestion, source files are archived to the server and records are then extracted from the files to be put into the source record database. Read the entire page →
From page 44... ... 44 Framework for a Pavement-Maintenance Database System and aggregations, data views and cache tables will be created by the database during the system record processing. The following section describes the key elements of the system in further detail. Read the entire page →
From page 45... ... Pavement-Maintenance Database Software Application 45 Source Record Data Source record data exists in a multitude of formats and structures across and within agencies. To provide a common language to ingest the data into PMDb, a standardized source record input format was developed. Read the entire page →
From page 46... ... 46 Framework for a Pavement-Maintenance Database System source data "Agency_Field" moniker in the filter interface. An example data bag can be seen in Figure 9 for data that was generated from the National Highway Planning Network (NHPN) Read the entire page →
From page 47... ... Pavement-Maintenance Database Software Application 47 Following validation, the source record data file will be ingested into the source record archive database for subsequent processing steps to become the system data records. Source Record Archive The source record archive is a database representation of each source data record. Read the entire page →
From page 48... ... 48 Framework for a Pavement-Maintenance Database System records must either transform their route value to match an existing route during the index translation process or the route will not be archived and searchable within the database. System Record Database System record data for each category of data (maintenance, inventory, and condition) Read the entire page →
From page 49... ... Pavement-Maintenance Database Software Application 49 The system record index fields also define the segments by which all source record data is normalized using data field mappings and data field aggregations as described later. The primary system record index fields in the database system are described in Table 50. Read the entire page →
From page 50... ... 50 Framework for a Pavement-Maintenance Database System Field Mappings Data field mappings represent how data elements are grouped within the system record database. It is where a user performs a function similar to that of the source record index translation although across different dimensions within the data. Read the entire page →
From page 51... ... Pavement-Maintenance Database Software Application 51 Data type aggregations will be expanded once sample data is collected and tested within the system. However, only the following aggregations are currently supported: • Average. Read the entire page →
From page 52... ... 52 Framework for a Pavement-Maintenance Database System System Record Access Data within the system record database is used by the system record access function to quickly search, filter, and aggregate data across thousands of records to find specific result sets. The result sets can then be downloaded and subsequently analyzed using tools chosen by the user. Read the entire page →
From page 53... ... Pavement-Maintenance Database Software Application 53 registered users are granted access to view and extract data within the system. It is anticipated that registered users will include state agency personnel and researchers who are interested in accessing the data for subsequent analysis. Read the entire page →
From page 54... ... 54 Framework for a Pavement-Maintenance Database System Users Users are members of a particular organization who can then have additional rights granted to them to conduct the administrative actions of a contributor when their access is elevated by an administrator. The only attributes particular to users involve their username, name, and email. Read the entire page →
From page 55... ... Pavement-Maintenance Database Software Application 55 Figure 15. Home page of the PMDb system. Read the entire page →
From page 56... ... 56 Framework for a Pavement-Maintenance Database System Figure 17. Screenshot of the user modification interface. Read the entire page →
From page 57... ... Pavement-Maintenance Database Software Application 57 Figure 18. Screenshot of the route inventory listing for PMDb with sample data from the NHPN route inventory. Read the entire page →
From page 58... ... 58 Framework for a Pavement-Maintenance Database System Index Translation. To allow for translation of the key source index fields to map to an existing route in the route index dataset, a source record transformation function has been developed. Read the entire page →
From page 59... ... Pavement-Maintenance Database Software Application 59 Figure 21. Browser application interface displaying the search results from the filter. Read the entire page →

From page 43...

... 43 C H A P T E R 4 Pavement-Maintenance Database Software Application The PMDb framework includes a two-part record processing system and a single page web application acting as the user interface to filter, search, and download records. In the first phase of ingestion, source files are archived to the server and records are then extracted from the files to be put into the source record database.