基于Access的汶川地震水库土石坝震害数据库系统的构建
|
摘要
水库震害数据库建设是防震减灾工作的一项基础性工作。利用关系模型的数据库管理系统Access,创建了汶川地震水库土石坝震害数据库,依次阐述了该数据库系统结构中的表、查询、窗体及宏四个对象的基本组成、基本功能及创建步骤。为防止非法用户打开数据库,设置了数据库访问密码及登陆界面的用户名和口令,利用双重密码,提高了数据库系统的安全性能。该数据库系统的建立,为地震专家研究水坝典型震害特性及影响因素提供了详实可靠的依据,亦为今后科学合理地录入大量的水坝震害资料提供了良好的数据库平台,具有重要的社会效益和工程应用价值。
Construction of seismic damage database of reservoirs is the groundwork for preventing against and mitigating earthquake disasters.Damage database of Wenchuan earthquake was created by access-based management system 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 database 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 seismic data.Therefore,it is a basic work for disaster prevention and mitigation work,which yields important social benefit and engineering application value.
Construction of seismic damage database of reservoirs is the groundwork for preventing against and mitigating earthquake disasters.Damage database of Wenchuan earthquake was created by access-based management system 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 database 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 seismic data.Therefore,it is a basic work for disaster prevention and mitigation work,which yields important social benefit and engineering application value.
引文
[1]梁海安,景立平,李永强,等.汶川地震溃坝险情土石坝烈度分布及震害特征[J].岩土工程学报,2012,34(7):1323-1328.LIANG Haian,JING Liping,LI Yongqiang,et al.Intensity distribution and characteristics of severely damaged earth-rock dams induced by Wenchuan Earthquake[J].Chinese Journal of Geotechnical Engineering,2012,34(7):1323-1328.(in Chinese)
[2]陈国兴,景立平,王志华,等.汶川地震中绵阳市梓潼县水库土坝震害调查与分析[J].地震工程与工程振动,2009,29(5):102-111.CHEN Guoxing,JING Liping,WANG Zhihua,et al.Investigation and analysis of earthquake-induced damage to earth dams of reservoirs in Zitong County of Mianyang City during Wenchuan earthquake[J].Journal of Earthquake Engineering and Engineering Vibration,2009,29(5):102-111.(in Chinese)
[3]梁海安,景立平,李永强,等.汶川地震土石坝震损水坝特征及震害影响因素分析[J].水电能源科学,2012,30(1):28-31.LIANG Haian,JING Liping,LI Yongqiang,et al.Charateristics of Damaged Dams and Influencing Factors in Wenchuan Earthquake[J].Water Resources and Power,2012,30(1):28-31.(in Chinese)
[4]叶亚三,陈国兴,王志华.汶川大地震中土坝破坏程度与坝体几何形状的关系分析[J].地震工程与工程振动,2012,32(1):146-153.YE Yasan,CHEN Guoxing,WANG Zhihua.Relationships between damage extent and geometry of reservoir’s earth dams in Wenchuan earthquake[J].Journal of Earthquake Engineering and Engineering Vibration,2012,32(1):146-153.(in Chinese)
[5]米红娟,李海燕.Access2007数据库应用程序[M].北京:科学出版社,2012.MI Hongjuan,LI Haiyan.Access2007 database application system[M].Beijing:Science Press,2012.(in Chinese)
[6]邹志云,张席洲.利用Access开发城市交通基础数据库[J].交通与计算机,1999,17(3):54-56.ZOU Zhiyun,ZHANG Xizhou.Basic database development of urban traffic based Access[J].Computer and Communications,1999,17(3):54-56.(in Chinese)
[7]何养育,韩慧莲.数据库系统概述[J].机械管理开发,2008,23(1):93-95.HE Yangyu,HAN Huilian.Data base System Introduction[J].Mechanical Management and Development,2008,23(1):93-95.(in Chinese)
[8]崔杰.“强震及地震工程震害资料基础数据库”项目成果介绍[J].国际地震动态,2006,9(333):13-19.Cui Jie.Introduction of the program“fundamental Database for strong earthquakes and seismic disaster materials for seismic engineering”[J].Recent Developments in World Seismology,2006,9(333):13-19.(in Chinese)
[2]陈国兴,景立平,王志华,等.汶川地震中绵阳市梓潼县水库土坝震害调查与分析[J].地震工程与工程振动,2009,29(5):102-111.CHEN Guoxing,JING Liping,WANG Zhihua,et al.Investigation and analysis of earthquake-induced damage to earth dams of reservoirs in Zitong County of Mianyang City during Wenchuan earthquake[J].Journal of Earthquake Engineering and Engineering Vibration,2009,29(5):102-111.(in Chinese)
[3]梁海安,景立平,李永强,等.汶川地震土石坝震损水坝特征及震害影响因素分析[J].水电能源科学,2012,30(1):28-31.LIANG Haian,JING Liping,LI Yongqiang,et al.Charateristics of Damaged Dams and Influencing Factors in Wenchuan Earthquake[J].Water Resources and Power,2012,30(1):28-31.(in Chinese)
[4]叶亚三,陈国兴,王志华.汶川大地震中土坝破坏程度与坝体几何形状的关系分析[J].地震工程与工程振动,2012,32(1):146-153.YE Yasan,CHEN Guoxing,WANG Zhihua.Relationships between damage extent and geometry of reservoir’s earth dams in Wenchuan earthquake[J].Journal of Earthquake Engineering and Engineering Vibration,2012,32(1):146-153.(in Chinese)
[5]米红娟,李海燕.Access2007数据库应用程序[M].北京:科学出版社,2012.MI Hongjuan,LI Haiyan.Access2007 database application system[M].Beijing:Science Press,2012.(in Chinese)
[6]邹志云,张席洲.利用Access开发城市交通基础数据库[J].交通与计算机,1999,17(3):54-56.ZOU Zhiyun,ZHANG Xizhou.Basic database development of urban traffic based Access[J].Computer and Communications,1999,17(3):54-56.(in Chinese)
[7]何养育,韩慧莲.数据库系统概述[J].机械管理开发,2008,23(1):93-95.HE Yangyu,HAN Huilian.Data base System Introduction[J].Mechanical Management and Development,2008,23(1):93-95.(in Chinese)
[8]崔杰.“强震及地震工程震害资料基础数据库”项目成果介绍[J].国际地震动态,2006,9(333):13-19.Cui Jie.Introduction of the program“fundamental Database for strong earthquakes and seismic disaster materials for seismic engineering”[J].Recent Developments in World Seismology,2006,9(333):13-19.(in Chinese)
版权所有：© 2023 中国地质图书馆 中国地质调查局地学文献中心