|
Title: SYNCHRONIZING AN AGENCY'S BRIDGE INFORMATION BETWEEN MULTIPLE VENDOR SYSTEMS: KANSAS DEPARTMENT OF TRANSPORTATION APPROACH
Accession Number: 00941375
Record Type: Component
Availability: N/AFind a library where document is available Abstract: The Kansas Department of Transportation (KDOT) has implemented the American Association of State Highway and Transportation Officials' (AASHTO's) Pontis Bridge Management System in its Bridge Management Section, where the AASHTO product serves a number of important roles in managing the state's structures. At the same time, KDOT has implemented Exor Corportation's Highways product, which provides a Structures Manager module for bridge information, where data created and managed within the Pontis system must also be stored and changed. KDOT business practices mandate that new structures be set up initially within the Exor Highways software and be transmitted to the Bridge Management Section for incorporation in the Pontis database. In attempting to maintain data consistency and high levels of availability across disparate software systems, KDOT faces challenges very similar to those of other transportation agencies. To facilitate the transmission process and eliminate significant staff intervention wherever possible, a suite of automated data synchronization brokerage routines has been created by KDOT that periodically synchronizes all changes for shared data items between the two software systems. A combination of Oracle database procedures effects this synchronization nightly and generates automatic reports with database log tables and e-mail notification to track data exchange activities. The organization of the synchronization system is described within the context of KDOT business rules, the data organization of the separate software packages, and user requirements. The results of a period of active service for the brokerage software were reviewed to identify benefits realized or anticipated, difficulties encountered, and potential improvements to the system that KDOT may undertake in the future, including application of extensible markup language technology to enhance and strengthen the brokerage mechanism.
Supplemental Notes: Distribution, posting, or copying of this PDF is strictly prohibited without written permission of the Transportation Research Board of the National Academy of Sciences. Unless otherwise indicated, all materials in this PDF are copyrighted by the National Academy of Sciences. Copyright © National Academy of Sciences. All rights reserved
Report/Paper Numbers: E-C049,
IBMC03-036 IBMC03-041 Language: English
Corporate Authors: Transportation Research Board 500 Fifth Street, NW Authors: Marshall, A RHackforth, CScherschligt, DPagination: p. 102-111
Publication Date: 2003-4
Serial: Conference:
9th International Bridge Management Conference
Location:
Orlando, Florida Features: Figures
(2)
; References
(3)
TRT Terms: Identifier Terms: Uncontrolled Terms: Subject Areas: Bridges and other structures; Design; Highways; I24: Design of Bridges and Retaining Walls
Files: TRIS, TRB
Created Date: Apr 17 2003 12:00AM
More Articles from this Serial Issue:
|