大坝安全监控系统的多维数据模型设计

Multi-dimensional data model design about dam safety monitoring system

如何提高大坝安全监控系统的有效性,是系统开发的难点。基于E/R建模原理,分析了大坝安全监控系统的E/R模型构建过程中出现的连接陷阱、数据冗余及更新异常问题,给出了这些问题的解决方案。在此基础上,进行了概念数据模型开发,构建了监测信息系统的E/R模型,并对该模型进行逻辑设计,建立起了能够有效反映大坝安全监控系统对监测数据的分析处理和对监测信息管理的多维数据模型,实现了监测信息管理高效数据库系统的建立。系统开发实例表明,多维数据模型能帮助系统快速地处理分析大量的监测信息,大大提高了系统的运行效率。

In order to enhance the validity of dam safety monitoring system,based on E/R modeling principles,problems of link traps, data redundancy and unusual updating in the construction course of E/R model have been analyzed in depth and corresponding solutions have been given.Then a conceptual data model has been developed and the E/R model of the monitoring information system has been built.After the logic design has been taken on the model, corresponding multidimensional data model has been established, which can reflect the data dealing and information managing process effectively.Finally, a high effective database system about monitoring information management has been constructed based on the model.The system development example indicates that the multidimensional data model can make the system deal with mass monitoring information quickly and thereby improve the system operating efficiency greatly.