Enterprise Data Warehouse Implementation Guide
| 项目名称： | Enterprise Data Warehouse Implementation Guide |
| 摘要： | As part of a robust data governance strategy, agencies must decide how to best manage storage, access, and dissemination of data products and services for internal use/reuse and external distribution within its data architecture. An important piece of a 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 decisions. Effective implementation of a data warehouse is complex, especially when an entity has highly diverse data sets and technology infrastructure. Thus, departments of transportation (DOTs) will benefit greatly from guidance on how to best architect and implement an enterprise data warehouse strategy that will meet diverse business needs while remaining performant. However, the industry lacks a guidebook on how to develop and implement a comprehensive data warehouse for DOTs. This research is intended to develop a guide on data warehouse implementation to support efficient use, sharing, and reporting of data and address transportation agency business needs. The deployable product from this research is a best practice guide for state DOTs to use in guiding the development and implementation of an enterprise data warehousing strategy that encompasses data in structured (tabular), semi- or un-structured (non-tabular), and geospatial file formats (includes geometry). Benefits of data warehousing include routine decision-making by improving data quality and increasing accessibility and security through using inventory best practices and improving organizational productivity through improved interoperability of data and automation of common analysis and reporting activities. Additional value is realized through time and cost savings to agencies by providing guidance on enterprise data warehouse strategies that can be quickly applied to improve the current state of data, rather than duplicating efforts with multiple or unknown outcomes. Moreover, collaboration and sharing of data across business units and agencies will be timelier and more efficient by adopting common standards. |
| 状态： | Proposed |
| 资金： | 350000 |
| 资助组织： | National Cooperative Highway Research Program；American Association of State Highway and Transportation Officials (AASHTO)；Federal Highway Administration |
| 项目负责人： | Barcena, Roberto |
| 开始时间： | 20220607 |
| 主题领域： | Administration and Management；Data and Information Technology；Highways |
相关文献
- NCHRP Implementation Support Program. Implementation of the AASHTO Guide for Enterprise Risk Management
- Exploring Novel Applications of Archived Transportation Data: Predicting Freeway Crash Risk, Border Crossing Delay and Inclement Weather Impacts
- NCHRP Implementation Support Program. Pilot Test of Climate Change Design Practices Guide for Hydrology and Hydraulics
- Data Management and Analytics for UF Smart Testbed
- Development of a Flexible Database for Local Calibration of MEPG
- West Virginia Department of Commerce Enterprise GIS Data Portal
检索历史
应用推荐
