| More long-span bridges have been built with the rapid development of the human society, civil engineering techniques and communication, more attention has been drawn to the safety, durability and normal functions of these bridges, Health monitoring systems and data warehouse technologies have been introduced into these long-span bridge and are developing rapidly, which makes health monitoring becoming an active domain of academe and engineering all over the world.In this paper, the Bridge Healthy Monitoring Data Analysis & Process System Based on Data Warehouse was developed based on summarizing and studying bridge's health monitoring and assessment technologies in world, as well as the features of long-span cable-stayed bridge.Based on introducing the working theory of SQL Server2000 and the visiting-technology of Visual Basic accessing to SQL Server2000, the article gives the designing of the data-analysis system about data analysis system of bridge's long-term healthy monitoring system. Development of the system will improve science, efficiency and intellect in the analysis to bridge's observing data.The main researches in this paper are as follows:1. According to the development in the current level of data management and the requirement in the data analysis system of bridge's long-term healthy monitoring system, on-line analytical processing (OLAP) was believed the most suitable application on database warehouses;2. Thinking all kinds of interface-form through which Visual Basic visits SQL Server2000 current, the article selected the fitting technology—ADO(MD);3. For the using after, the article created initial data-base and target data-base warehouse on SQL Server2000;4. Pre-treating to the observing data, including;the deleting unlawful data and the mending to the observing data, In-line analysis to data using mature correlating-analysis method;5. Creating the system of data-querying which has luxuriant function in the Visual Basic program. |
PDF Full Text Request