Overview
Database design usually takes the form of a schema, which formally describes the database structure, including the tables, their relationships, and constraints on data value types and lengths. Rather than defining an implementable schema, this chapter presents example tables that can store information generated during all steps of the reliability monitoring computation process, from the raw data to the travel time density functions and reliability metrics. The exact tables, fields, and relationships are flexible to the needs of the agency, the data available, and the desired reporting capabilities.
Related Artifacts: L02 - Supplement B - Methodological Details; L02 - Supplement C - Case Studies; L02 - Supplement D - Use Case Analyses
Operations Area of Practice
Detection Systems
ITS standards and specifications
SHRP2 Tools
Communicating Reliability Information
Data Acquisition, Support and Hosting
Content Type
Standards & Recommended Practices
Role in Organization
Transportation Planner
Public
Senior Engineer
Researcher/Academic
Principal Engineer
Manager / First Line Supervisor
Director / Program Manager
Technician
CEO / GM / Commissioner
Engineer
Senior Manager
Transit Professional
Associate Engineer
Publishing Organization
SHRP2 Program