大坝安全监测数据仓库的设计与构建——以小浪底大坝为例

Design and construction of dam safety monitoring data warehouse: with Xiaolangdi Dam taken as an example

针对现有的大坝安全监控系统中存在的历史数据量大、难以集成和访问数据能力不足的问题,研究了大坝安全监测数据仓库的设计和构建方法.以小浪底大坝安全监测数据仓库设计与构建为例,设计了数据仓库系统的框架结构,详细介绍了大坝安全监测数据仓库的设计方法和具体步骤,着重研究了主题域及其内容的确定、逻辑模型和物理模型的设计、数据集成、数据的访问设计和维护等内容,最后还分析了基于DTS的小浪底大坝安全监测数据仓库的数据集成方法和步骤.

In consideration of some limitations in current dam safety monitoring system, such as great amount of historical data, difficulties in data integration, and low capacity in data accessing, the method for design and construction of dam safety monitoring data warehouse was studied. A framework was presented for construction of the dam safety monitoring data warehouse system for the Xiaolangdi Project, and the method and process for its design were introduced with emphasis on the determination of main issues and contents, design of logic model and physical model, data integration, and data accessing design and maintenance. Finally, the method and steps of data integration in the data warehouse system based on data transformation service （DTS） were analyzed as well.