Development of Data Warehouse and Applications for Continuous Vehicle Class and Weigh-in-Motion Data

Kwon, Taek M.
2009-10
Thumbnail Image

View/Download File

Mn_DOT2009-33.pdf (3.2 MB)

Persistent link to this item

https://hdl.handle.net/11299/150973
Statistics
View Statistics

Journal Title

Journal ISSN

Volume Title

Title

Development of Data Warehouse and Applications for Continuous Vehicle Class and Weigh-in-Motion Data

Authors

Published Date

2009-10

Publisher

Minnesota Department of Transportation

Type

Report

Abstract

Presently, the Office of Transportation Data & Analysis (TDA) at the Minnesota Department of Transportation (Mn/DOT) manages 29 Vehicle Classification (VC) sites and 12 Weigh-in-Motion (WIM) sites installed on various Minnesota roadways. The data is collected 24/7 from all sites, resulting in a large amount of data. The total amount of data is expected to substantially grow with time due to the continuous accumulation of data from the present sites and future expansion of sites. Therefore, there is an urgent need to develop an efficient data management strategy for dealing with the present needs and future growth of this data. The solution proposed in this research project is to develop a centralized data warehouse from which all applications can acquire the data. The objective of this project was to develop software for creating a VC/WIM data warehouse and example applications that utilize it. This project was successfully completed by developing the software necessary to build the VC/WIM data warehouse and the application software packages that utilize the data. The main contribution of this project is that it provides a single access point for querying all of the Mn/DOT’s WIM and VC data, from which many more applications can be developed without concerns of proprietary binary formats.

Keywords

Description

Related to

Replaces

License

Collections

Research Reports

Series/Report Number

MnDOT
 2009-33

Funding information

Minnesota Department of Transportation

Isbn identifier

Doi identifier

Previously Published Citation

Suggested citation

Kwon, Taek M.. (2009). Development of Data Warehouse and Applications for Continuous Vehicle Class and Weigh-in-Motion Data. Retrieved from the University Digital Conservancy, https://hdl.handle.net/11299/150973.

Content distributed via the University Digital Conservancy may be subject to additional license and use restrictions applied by the depositor. By using these files, users agree to the Terms of Use. Materials in the UDC may contain content that is disturbing and/or harmful. For more information, please see our statement on harmful content in digital repositories.