The Design And Implementation Of Opening Highway Database Managing System

The highway database is a fundamental data platform at the highway department. All kinds of applications at the highway department such as Bridge Management System, Pavement Management System and ITS etc. all employ part of data of highway database. Before, it was typical that each application used alone its own database due to the limitation of software tools of developing and technologies of application designing. In this case, repeated construction, lack of flexibility, inextensibility, not meeting users' need to be changed and difficulty of maintenance were brought about. With the promotion of the technology of software developing, implementing a flexible and extensible application is prevailing. Furthermore, as far as highway database's traits are concerned, designing an opening highway database managing system is good for building a basic data platform, furthering share of data and speeding the pace of being info.This paper is plunged into opening highway database system and some important theories and technologies related to highway managing after analyzing the traits of need of the current highway database. And based on reference system of the road network and dynamic segmentation technology, it puts forward a kind of spatial database conceptual model of highway facilities. What's more, based on the designing thought of opening highway database system, the Highway Database Managing System is implemented. The system Implements not only basic maintaining & managing functions but also the opening functions such as interface Managing, dynamic maintaining of data relationship, Maintaining of table structure and creating combined tables based on dynamic segmentation technology etc. the research fruits of this paper are of significance for the fundamental data construction at the highway department. The developing practice of the system is a good sample for development of the like system. Some solutions of basic functions relevant to maintaining and managing of the database such as right managing, querying, statistics and recording can be used for reference by some other database applications.