基于Access的汶川地震水库土石坝震害数据库系统的构建

System construction of access-based earthquake damage database of reservoir earth-rock dams during the Wenchuan great earthquake

水库震害数据库建设是防震减灾工作的一项基础性工作。利用关系模型的数据库管理系统Access,创建了汶川地震水库土石坝震害数据库,依次阐述了该数据库系统结构中的表、查询、窗体及宏四个对象的基本组成、基本功能及创建步骤。为防止非法用户打开数据库,设置了数据库访问密码及登陆界面的用户名和口令,利用双重密码,提高了数据库系统的安全性能。该数据库系统的建立,为地震专家研究水坝典型震害特性及影响因素提供了详实可靠的依据,亦为今后科学合理地录入大量的水坝震害资料提供了良好的数据库平台,具有重要的社会效益和工程应用价值。

Construction of seismic damage database of reservoirs is the groundwork for preventing against and mitiga- ring earthquake disasters. Damage database of Wenchuan earthquake was created by access-based management sys- tem of relational model. The basic functions and creation steps of four basic components of this database system structure, including basic tables, queries, forms and macro, were expounded successively. Access password of da- tabase system as well as login user name and corresponding password were designed to prevent illegal users to open the database. And the system＇ s safety performance was improved by using double passwords. The establishment of database system is not only beneficial to the study of seismic damage characteristics and influential factors of reservoir earth-rock dams, but also provides a good database platform for the entry of dam seis- mic data. Therefore, it is a basic work for disaster prevention and mitigation work, which yields important social benefit and engineering application value.