原文传递
Truck Data Warehouse
| 题名： | Truck Data Warehouse |
| 作者： | empty |
| 关键词： | Truck data##Weigh in motion system##Database management##Warehouse##Feasibility study##Automating process## |
| 摘要： | This project was started to develop a user friendly database to house the data from the statewide system of Weigh in Motion sites. The project was ended early when a decision was made to put this data into the Caltrans Performance Management System Database (PeMS). The primary objectives for the Caltrans project: “Truck Data Warehouse” (TDW) include the following: • Produce a feasibility study report for the effort in automating the process of storing, retrieving, analyzing and generating reports based on the Caltrans Weight-in-Motion (WIM) truck data. • Develop an expandable prototype database system for truck data collected at Caltrans WIM stations throughout the state of California. • Develop a set of user tools to generate various reports for different stakeholders. The tools will be accessible through web interfaces. We have accomplished all of the aforementioned objectives. Beyond these requirements, the CSUS team developed a Google Earth based geographic information interface to enhance WIM data accessibility to certain stakeholders of the system. The infrastructure for the TDW system is a Pentium dual core workstation running a Linux operating system (SUSE 9) [4]. The computer is connected to the College of Engineering and Computer Science network and is protected behind the firewall. The database system used to support the applications is Oracle 10g [3]. The user tools are developed using JSP technology [1]. All the technologies utilized in developing the TDW system are in compliance with the Caltrans IT policies. This final report intends to provide a panoramic view of the functionality of the TDW system from the user’s perspective. The remainder of the report is organized as follows. Section 2 describes the top level interfaces for the TDW system. Section 3 discusses the Oracle Discoverer Viewer interface and the types of graphic reports it supports. Section 4 focuses on the web page interface for generating various reports. Section 5 deals with the Google Earth based geographic information interface. Finally, Section 6 concludes the report.This project was started to develop a user friendly database to house the data from the statewide system of Weigh in Motion sites. The project was ended early when a decision was made to put this data into the Caltrans Performance Management System Database (PeMS). |
| 总页数： | 67 |
| 报告类型： | 科技报告 |
相关文献
- Development of an Aeromedical Scientific Information System for Aviation Safety
- Truck Terminal and Warehouse Survey Results.
- Central Florida Data Warehouse (CFDW), Phase-2-The Central ITS Office Funding.
- Network Science Research Laboratory (NSRL) Telemetry Warehouse. Technical Report October 1, 2014-September 30, 2015.
- Central Florida Data Warehouse (CFDW), Phase-2-The Central ITS Office Funding. Final rept.
- Buffalo-Niagara Transportation Data-Warehouse Prototype and Real-Time Incident Detection.
检索历史
应用推荐
