Database Management Systems for Urban Facilities

Janson, Bruce N.; Chahine, Jacques R.; ,

Database Management Systems for Urban Facilities

by Bruce N. Janson, Carnegie Mellon Univ, Pittsburgh, PA, USA,
Jacques R. Chahine, Carnegie Mellon Univ, Pittsburgh, PA, USA,

Document Type: Proceeding Paper

Part of: Managing Urban Transportation as a Business

Abstract:

This paper discusses design and implementation issues associated with the development of database management systems (DBMS) for urban facilties. Many of the experiences described here are related to our building a retaining wall database management system for the City of Pittsburgh. The objective of that project was to provide the City with a DBMS that would assist them in the planning, design and budgeting of retaining wall inspection, maintenance, rehabilitation, replacement and construction activities performed by both the Planning Department and the Engineering and Construction Department of Pittsburgh. To meet this objective, the database system would be required to store geographical, historical, structural, and material information on each wall for which the City is responsible. In addition, data describing surrounding structures, roadways, utilities, and right-of-ways would also need to be maintained within the system. Finally, cost estimation spreadsheets for different types of walls would be integrated into the system for budgeting purposes. A system of three relational databases was developed and linked together so that this information could be stored, updated and extended.

Return to search