Research Management Database Business Analysis, TPF-5(181)

This report presents the results of an analysis of business needs for state department of transportation (DOT) research project and
program management databases. DOTs currently track their research information in a variety of ways. While a few agencies have
implemented full featured research program and project management database systems (RPMDs), many are using spreadsheets or
simple desktop databases to manage their information. Many agencies – particularly those with smaller research programs -- seek
improvements to research data management and reporting capabilities but are constrained by staffing and information technology
resource limitations. This research was conducted to provide a common base of foundational information for agencies wishing to
develop or improve an existing RPMD and to explore options for future collective RPMD development activities that could benefit
multiple agencies.

The research involved synthesis of business, functional, data and transition requirements for an RPMD.
Requirements development was based on review of existing research manuals, RPMD documentation, and interviews with
research stakeholders at DOTs, universities, the Transportation Research Board (TRB) and the Federal Highway Administration
(FHWA). Based on the requirements, the research identifies several future initiatives for consideration to improve research data
management and sharing practices. These initiatives include development of a research data exchange standard, creation of a
model research data mart, and collaborative development of a basic, web-based RPMD through a collaborative effort by interested

Publication Date: 
Tuesday, July 31, 2018
Publication Number: 
WA-RD 879.1
Last modified: 
08/20/2018 - 15:52
Frances D. Harrison
Spy Pond Partners, LLC
Number of Pages: 
Research, State departments of transportation, Research projects, Research management, Data management, Project management, Needs assessment, Business practices, Database management systems, Analysis, Information dissemination, Product development.