Water Science and Engineering 2008, 1(3) 112-120  DOI:   10.3882/j.issn.1674-2370.2008.03.012   ISSN: 1674-2370 CN: 32-1785/TV

Current Issue | Archive | Search                                                            [Print]   [Close]
Information and Service
This Article
Supporting info
Service and feedback
Email this article to a colleague
Add to Bookshelf
Add to Citation Manager
Cite This Article
Email Alert
dam safety
multi-dimensional database
conceptual data model
database mode
monitoring system
Er-feng ZHAO
Ya-chao WANG
Yu-feng JIANG
Hong YU
Article by
Article by
Article by
Article by
Article by

Multi-dimensional database design and implementation of dam safety monitoring system

Er-feng ZHAO*1, 2, Ya-chao WANG1, 2, Yu-feng JIANG1, 2, Lei ZHANG1, 2, Hong YU1, 2

1. National Engineering Research Center of Water Resources Efficient Utilization and Engineering Safety, Hohai University, Nanjing 210098, P. R. China
2. College of Water Conservancy and Hydropower Engineering, Hohai University, Nanjing 210098, P. R. China


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 was achieved 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.

Keywords dam safety   multi-dimensional database   conceptual data model   database mode   monitoring system  
Received 2008-04-29 Revised 2008-08-13 Online:  
DOI: 10.3882/j.issn.1674-2370.2008.03.012
Corresponding Authors: Er-feng ZHAO
About author:

Similar articles
1.Zi-wu FAN*;Shu-hai JIANG;Ming ZHANG.Dynamic probability evaluation of safety levels of earth-rockfill dams using Bayesian approach[J]. Water Science and Engineering, 2009,2(2): 61-70

Copyright by Water Science and Engineering