Transportation Enterprise Data Warehouse Implementation Guide

Project Details
STATUS

In-Progress

START DATE

04/05/24

END DATE

11/30/25

RESEARCH CENTERS InTrans, CTRE
SPONSORS

National Cooperative Highway Research Program (NCHRP)

Researchers
Principal Investigator
Inya Nlenanya

Research Scientist, CTRE

Co-Principal Investigator
Alireza Sassani

Research Scientist, CTRE

Co-Principal Investigator
Skylar Knickerbocker

Research Engineer, CTRE

Co-Principal Investigator
Omar Smadi

Director, CTRE

About the research

State departments of transportation (DOTs) and other transportation organizations have a wealth of data. This data is stored in multiple environments and formats and is accessible by various methods. Some of these environments easily integrate, while others require complex programming. At times, the cost of this integration outweighs the potential benefit.

This research aims to develop a guide for enterprise data warehouse (EDW) development and best practices to support DOT business needs. While many warehousing technologies can be chosen and implemented, from SAS to Snowflake, for example, many of these can meet the basic needs of a DOT. What gets overlooked when deploying an enterprise data environment is not directly related to the technology. This research will not only look at technology and traditional data governance practices but address how best practices in services/APIs, software ecosystems, security of data and systems, and the culture of an organization complement a thriving data ecosystem.

TOP