Transportation Enterprise Data Warehouse Implementation Guide

As part of a robust data governance strategy, transportation agencies must decide how to best manage the storage, access, and dissemination of data products and services for internal use/reuse and external distribution within its data architecture. An important piece of modern data architecture is an enterprise data warehouse, which, conceptually, will provide a way to reduce data redundancy, improve data consistency, and enable data usage for better decision-making. Effective data warehouse implementations are complex, especially when an entity has highly diverse data sets and technology infrastructure. State departments of transportation (DOTs) need guidance on how to best architect and implement an enterprise data warehouse strategy. DOTs would also benefit from guidance on the complete set of functional requirements including, but not limited to, federation (aggregating from multiple sources), data extract-transform-load (ETL) and extract-load-transform (ELT), storage, naming convention, structure (model), roles and responsibilities, web services, data publishing processes, access by third-party applications, and records management. Any conventions, models, and structure covered by the guidance will also need to support and align with standard frameworks used in transportation, such as Industry Foundation Classes (IFC), to the greatest extent practical. The objective of this research is to develop a guide for enterprise data warehouse development, implementation, and best practices to support DOT business needs. DOT business needs include, but are not limited to, efficient upload, use, sharing, security of data, data analytics, operations management, performance management, asset management, safety management, data-driven decision-making, data integration, and federal and state data reporting.


  • English


  • Status: Active
  • Funding: $350000
  • Contract Numbers:

    Project 23-29

  • Sponsor Organizations:

    National Cooperative Highway Research Program

    Transportation Research Board
    500 Fifth Street, NW
    Washington, DC  United States  20001

    American Association of State Highway and Transportation Officials (AASHTO)

    444 North Capitol Street, NW
    Washington, DC  United States  20001

    Federal Highway Administration

    1200 New Jersey Avenue, SE
    Washington, DC  United States  20590
  • Project Managers:

    Barcena, Roberto

  • Performing Organizations:

    Iowa State University, Ames

    Institute for Transportation
    2711 South Loop Drive, Suite 4700
    Ames, Iowa  United States  50010-8664
  • Principal Investigators:

    Nlenanya, Inya

  • Start Date: 20240405
  • Expected Completion Date: 20251130
  • Actual Completion Date: 0

Subject/Index Terms

Filing Info

  • Accession Number: 01847466
  • Record Type: Research project
  • Source Agency: Transportation Research Board
  • Contract Numbers: Project 23-29
  • Files: TRB, RIP
  • Created Date: May 27 2022 12:57PM