TRB Pubsindex
Text Size:

Title:

SYNCHRONIZING AN AGENCY'S BRIDGE INFORMATION BETWEEN MULTIPLE VENDOR SYSTEMS: KANSAS DEPARTMENT OF TRANSPORTATION APPROACH
Cover of SYNCHRONIZING AN AGENCY'S BRIDGE INFORMATION BETWEEN MULTIPLE VENDOR SYSTEMS: KANSAS DEPARTMENT OF TRANSPORTATION APPROACH

Accession Number:

00941375

Record Type:

Component

Availability:

N/A
Find a library where document is available


Order URL: http://worldcat.org/issn/00978515

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
Washington, DC 20001 United States

Authors:

Marshall, A R
Hackforth, C
Scherschligt, D

Pagination:

p. 102-111

Publication Date:

2003-4

Serial:

Transportation Research Circular

Issue Number: E-C049
Publisher: Transportation Research Board
ISSN: 0097-8515

Conference:

9th International Bridge Management Conference

Location: Orlando, Florida
Date: 2003-4-28 to 2003-4-30
Sponsors: Transportation Research Board, Federal Highway Administration

Features:

Figures (2) ; References (3)

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: