DEVELOPMENT OF DATABASE SYSTEM FOR UNDERGROUND POWERHOUSES OF HYDROPOWER PROJECT AND ITS APPLICATION
HU Tianqing1，2，XIAO Ming1，2，XIONG Qingrong1，2
(1. State Key Laboratory of Water Resources and Hydropower Engineering Science，Wuhan University，Wuhan，Hubei 430072，China；2. Key Laboratory of Ministry of Education for Rock Mechanics in Hydraulic Structural Engineering，
Wuhan University，Wuhan，Hubei 430072，China)
摘要基于百余个水电站地下厂房资料，采用SQL Server 2005设计后台数据库，C#编程语言作为前台开发工具，开发“地下厂房数据库系统”，达到对水电工程地下厂房重要设计参数及洞室围岩稳定计算分析成果的数据存储、检索、统计、分析的目的。该数据库收录上百个实际工程关于工程介绍、地质条件、地应力场、厂房规模、锚固支护设计、开挖方案设计、反演分析、渗流场分析、围岩稳定分析等方面的内容。该系统实现地下厂房设计及围岩稳定分析工程类比的方法及数据分析的功能，并以云南澜沧江黄登水电站地下厂房为例，通过厂房特征参数检索数据库，得到相关工程，配合使用经验支护参数，实现对黄登地下厂房主厂房支护参数的设计，并运用三维弹塑性有限元软件进行数值分析，验证其合理性。同时，该系统能够利用全面的数据资料充分发掘蕴藏于丰富地下厂房资料中的各种数字特征、从而深化对水电工程地下厂房工程的各种规律性认识，为开发、设计地下厂房专家库系统，并建立全面而系统的地下工程围岩稳定分析和预测方法奠定基础。
Abstract：Based on the rich engineering data of hundreds of underground powerhouses which are accumulated by our team，SQL Server 2005 is used as design tool and C# programming language is selected as front-end development tool to develop the database system of underground powerhouse，achieving the purposes of data storage，retrieval，statistics，analysis of significant design parameters of underground powerhouse and the results of stability analysis of surrounding rock. Engineering data of hundreds of projects are stored in the database，including engineering description，geological conditions，geostress field，size of powerhouse，supporting design，excavation scheme design，back-analysis，seepage field analysis，stability analysis of surrounding rock，etc.. The system realizes the functions of engineering analogue method，data analysis of underground powerhouse design and surrounding rock stability analysis. Taking underground powerhouse of Huangdeng hydropower station on Lancang river in Yunnan province for example，related engineering by using characteristic parameters of underground powerhouse is obtained to retrieve the database. With the empirical supporting parameters，the supporting parameters design of main powerhouses are achieved. Lastly，the rationality of the design is verified by 3D elastoplastic finite element software. At the same time，the system can help to deepen the understanding of all kinds of laws of underground powerhouses by adequately exploring various kinds of digital information where the rich data of underground powerhouse are contained. The system also have laid foundation for the design of expert database system of underground powerhouses which can contribute to establish a comprehensive and systematic method of surrounding rock stability analysis as well as the forecasting of underground engineering.
胡田清1，2，肖 明1，2，熊清蓉1，2. 水电工程地下厂房数据库系统的开发及应用[J]. 岩石力学与工程学报, 2011, 30(S1): 3074-3080.
HU Tianqing1，2，XIAO Ming1，2，XIONG Qingrong1，2. DEVELOPMENT OF DATABASE SYSTEM FOR UNDERGROUND POWERHOUSES OF HYDROPOWER PROJECT AND ITS APPLICATION. , 2011, 30(S1): 3074-3080.
[1] 邬爱清，丁秀丽，陈胜宏，等. DDA方法在复杂地质条件下地下厂房围岩变形与破坏特征分析中的应用研究[J]. 岩石力学与工程学报，2006，25(1)：1–8.(WU Aiqing，DING Xiuli，CHEN Shenghong，et al. Researches on deformation and failure characteristics of surrounding rock of underground powerhouse with complicated geological conditions by DDA method[J]. Chinese Journal of Rock Mechanics and Engineering，2006，25(1)：1–8.(in Chinese))
[2] 王 涛，陈晓玲，杨 建. 基于3DGIS和3DEC的地下洞室围岩稳定性研究[J]. 岩石力学与工程学报，2005，24(19)：3 476–3 481. (WANG Tao，CHEN Xiaoling，YANG Jian. Study on stability of underground cavern based on 3DGIS and 3DEC[J]. Chinese Journal of Rock Mechanics and Engineering，2005，24(19)：3 476–3 481.(in Chinese))
[3] 王 涛，陈晓玲，于利宏. 地下洞室群围岩稳定的离散元计算[J]. 岩土力学，2005，26(12)：1 936–1 940.(WANG Tao，CHEN Xiaoling，YU Lihong. Discrete element calculation of surrounding rock mass stability of underground cavern group[J]. Rock and Soil Mechanics，2005，26(12)：1 936–1 940.(in Chinese))
[4] 安红刚. 大型洞室群稳定性与优化的综合集成智能方法研究[J]. 岩石力学与工程学报，2003，22(10)：1 760–1 766.(AN Honggang. Study on stability and optimization of large cavern group using synthetic integrated intelligent method[J]. Chinese Journal of Rock Mechanics and Engineering，2003，22(10)：1 760–1 766.(in Chinese))
[5] 王水林，李春光，史贵才，等. 小湾水电站地下厂房洞室群弹脆塑性分析[J]. 岩石力学与工程学报，2005，24(24)：4 449–4 454. (WANG Shuilin，LI Chunguang，SHI Guicai，et al. Analysis of underground powerhouses in Xiaowan Hydropower Station by elastic- brittle-plastic constitutive models[J]. Chinese Journal of Rock Mechanics and Engineering，2005，24(24)：4 449–4 454.(in Chinese))
[6] 秦小华，付成华，魏 斌，等. 地下洞室施工监测预报信息系统研究[J]. 武汉大学学报：工学版，2006，39(1)：30–34.(QIN Xiaohua，FU Chenghua，WEI Bin，et al. Study on monitoring and prediction information system for underground cavern construction[J]. Engineering Journal of Wuhan University，2006，39(1)：30–34.(in Chinese))
[7] 王 浩，吴振君，汤 华，等. 地下厂房监测信息管理、预测系统的设计与应用[J]. 岩土力学，2006，27(1)：163–167.(WANG Hao，WU Zhenjun，TANG Hua，et al. Development and application of monitoring information management and prediction software system for underground powerhouse[J]. Rock and Soil Mechanics，2006，27(1)：163–167.(in Chinese))
[8] 王民寿，李仕奇，李艳玲，等. 试论地下洞室群施工专家系统的开发[J]. 云南水力发电，2003，19(1)：87–90.(WANG Minshou，LI Shiqi，LI Yanling，et al. Discussion on development of underground cavities construction expert system[J]. Yunnan Water Power，2003，19(1)：87–90.(in Chinese))
[9] 张 清，田盛丰，莫元彬，等. 隧道及地下工程岩溶危害预报的专家系统[J]. 岩石力学与工程学报，1992，11(3)：230–242.(ZHANG Qing，TIAN Shengfeng，MO Yuanbin，et al. An expert system for predicting karst hazards encountered in the construction of tunnels or underground openings[J]. Chinese Journal of Rock Mechanics and Engineering，1992，11(3)：230–242.(in Chinese))
[10] ZHU W S，LI X J，ZHANG Q B，et al. A study on sidewall displacement prediction and stability evaluations for large underground power station caverns[J]. International Journal of Rock Mechanics and Mining Sciences，2010，47(7)：1 055–1 062.
[11] 朱维申，孙爱花，王文涛，等. 大型洞室群高边墙位移预测和围岩稳定性判别方法[J]. 岩石力学与工程学报，2007，26(9)：1 729–1 736. (ZHU Weishen，SUN Aihua，WANG Wentao，et al. Study on prediction of high wall displacement and stability judging method of surrounding rock for large cavern groups[J]. Chinese Journal of Rock Mechanics and Engineering，2007，26(9)：1 729–1 736.(in Chinese))
[12] 撒师煊，王 珊. 数据库系统概论[M]. 3版. 北京：高等教育出版社，2000：206–208.(SA Shixuan，WANG Shan. Introduction to database system[M]. 3rd ed. Beijing：Higher Education Press，2000：206–208.(in Chinese))
2011, Vol. 30 
