DATABASE TECHNOLOGY IN BRIDGE MANAGEMENT SYSTEM

At present, the study and application of databases is one of the hot research fields in computer science, and a huge number of testing data are needed to be handled in the Bridge Management System. If there is no good handling and keeping method, these testing data will be omitted or lost since they are extremely bulky. So database technology is adopted to supervise testing data in the Bridge Management System. Because the database structure and relationship among the data lies of great significance, which is related to the effective data transfer and the realization of data sharing, 84 data tables, 184 stored procedures and 12 data cubes have been carried out in the database to meet the requirements of the testing data. Based on the Dotnet2.0 frameworks, the Bridge Inspection Rating Maintenance and Management System is developed by employing object-oriented programming technology aided by the Visual Studio 2005 C# and SQL Server 2005. Meanwhile, data mining and data analyzing functioning as online data processing offered by SQL Server 2005 have also been used to aid the decision making of assessment. In Chongqing, China, the system has already been successfully applied to the management of three tong-span bridges of certain expressway. Therefore, this can guarantee the three bridges serve the traffic effectively and safely.