To improve the effectiveness of dam safety monitoring database systems, the development process of a multi-dimensional conceptual data model was analyzed and a logic design wasachieved in multi-dimensional database mo...To improve the effectiveness of dam safety monitoring database systems, the development process of a multi-dimensional conceptual data model was analyzed and a logic design wasachieved in multi-dimensional database mode. The optimal data model was confirmed by identifying data objects, defining relations and reviewing entities. The conversion of relations among entities to external keys and entities and physical attributes to tables and fields was interpreted completely. On this basis, a multi-dimensional database that reflects the management and analysis of a dam safety monitoring system on monitoring data information has been established, for which factual tables and dimensional tables have been designed. Finally, based on service design and user interface design, the dam safety monitoring system has been developed with Delphi as the development tool. This development project shows that the multi-dimensional database can simplify the development process and minimize hidden dangers in the database structure design. It is superior to other dam safety monitoring system development models and can provide a new research direction for system developers.展开更多
Based on the principal component analysis, principal components that have major influence on data variance are determined by the energy percentage method according to the correlation between monitoring effects. Then p...Based on the principal component analysis, principal components that have major influence on data variance are determined by the energy percentage method according to the correlation between monitoring effects. Then principal components are extracted through reconstructing multi effects. Moreover, combining with the optimal estimation theory, the method of singular value diagnosis in dam safety monitoring effect values is proposed. After dam monitoring information matrix is obtained, single effect state estimation matrix and multi effect fusion estimation matrix are constructed to make diagnosis on singular values to reduce false alarm rate. And the diagnosis index is calculated by PCA. These methods have already been applied to an actual project and the result shows the ability of the monitoring effect reflecting dam evolution behavior is improved as dam safety monitoring effect fusion estimation can take accurate identification on singular values and achieve data reduction, filter out noise and lower false alarm rate effectively.展开更多
基金supported by the National Natural Science Foundation of China (Grant No. 50539010, 50539110, 50579010, 50539030 and 50809025)
文摘To improve the effectiveness of dam safety monitoring database systems, the development process of a multi-dimensional conceptual data model was analyzed and a logic design wasachieved in multi-dimensional database mode. The optimal data model was confirmed by identifying data objects, defining relations and reviewing entities. The conversion of relations among entities to external keys and entities and physical attributes to tables and fields was interpreted completely. On this basis, a multi-dimensional database that reflects the management and analysis of a dam safety monitoring system on monitoring data information has been established, for which factual tables and dimensional tables have been designed. Finally, based on service design and user interface design, the dam safety monitoring system has been developed with Delphi as the development tool. This development project shows that the multi-dimensional database can simplify the development process and minimize hidden dangers in the database structure design. It is superior to other dam safety monitoring system development models and can provide a new research direction for system developers.
基金supported by the National Natural Science Foundation of China (Grant Nos. 51079046, 50909041, 50809025, and 50879024)the National Science and Technology Support Plan (Grant Nos. 2008BAB29B03and 2008BAB29B06)+6 种基金the Special Fund of State Key Laboratory of China (Grant Nos. 2009586012, 2009586912, and 2010585212)the Fundamental Research Funds for the Central Universities (Grant Nos. 2009B08514, 2010B20414, 2010B01414, and 2010B14114)the China Hydropower Engineering Consulting Group Co. Science and Technology Support Pro-ject (Grant No. CHC-KJ-2007-02)Jiangsu Province "333 High-Level Personnel Training Project" (Grant No. 2017-B08037)Graduate Innovation Program of Universities in Jiangsu Province (Grant No. CX09B_ 163Z)Dominant Discipline Construction Program Funded Projects of University in Jiangsu ProvineScience Foundation for the Excellent Youth Scholars of Ministry of Education of China (Grant No. 20070294023)
文摘Based on the principal component analysis, principal components that have major influence on data variance are determined by the energy percentage method according to the correlation between monitoring effects. Then principal components are extracted through reconstructing multi effects. Moreover, combining with the optimal estimation theory, the method of singular value diagnosis in dam safety monitoring effect values is proposed. After dam monitoring information matrix is obtained, single effect state estimation matrix and multi effect fusion estimation matrix are constructed to make diagnosis on singular values to reduce false alarm rate. And the diagnosis index is calculated by PCA. These methods have already been applied to an actual project and the result shows the ability of the monitoring effect reflecting dam evolution behavior is improved as dam safety monitoring effect fusion estimation can take accurate identification on singular values and achieve data reduction, filter out noise and lower false alarm rate effectively.