›› 2010, Vol. 31 ›› Issue (2): 565-570.

• Geotechnical Engineering • Previous Articles     Next Articles

Basic application of OLAP to safety monitoring in underground engineering

WANG Hao, GE Xiu-run   

  1. State Key Laboratory of Geomechanics and Geotechnical Engineering, Institute of Rock and Soil Mechanics, Chinese Academy of Sciences, Wuhan 430071, China
  • Received:2009-02-02 Online:2010-02-10 Published:2010-03-24

PDF (Chinese)

2569

Abstract:

As a type of multi-dimensional data analytical tool, OLAP (on-line analytical processing) and data warehouse have got a lot of uses in finance and business but had few uses in underground engineering. Some of these applications made a good profit for enterprises. The conception, function, features of data warehouse and OLAP are introduced briefly. A basic OLAP application was built for Xiaowan hydropower plant underground powerhouse. The example shows that OLAP can provide quick, easy and visualized queries from multi-viewpoint, such as observed time, measure point types and construction types, and different stages for top managers. Combining with data warehouse, OLAP will be very useful in safety management for geotechnical engineering. And the future direction of OLAP application to underground engineering is discussed.

Key words: underground engineering, monitoring, data warehouse, OLAP, multi-dimensional data analyses

CLC Number: 

  • TP 311
[1] ZHANG Ding-wen, LIU Zhi-xiang, SHEN Guo-gen, E Jun-yu, . Measurement of earth pressure of shallow buried tunnel with super large diameter and applicability evaluation of calculation method [J]. Rock and Soil Mechanics, 2019, 40(S1): 91-98.
[2] ZHENG Shuai, JIANG An-nan, ZHANG Feng-rui, ZHANG Yong, SHEN Fa-yi, JIANG Xu-dong, . Dynamic classification method of surrounding rock and its engineering application based on machine learning and reliability algorithm [J]. Rock and Soil Mechanics, 2019, 40(S1): 308-318.
[3] LI Qiao, MENG Fan-zeng, NIU Yuan-zhi. Bridge pier deformation and control technology of jacking framed bridge with loading under crossing high speed railway [J]. Rock and Soil Mechanics, 2019, 40(9): 3618-3624.
[4] CHEN Bing-rui, WU Hao, CHI Xiu-wen, LIU Hui, WU Meng-die, YAN Jun-wei, . Real-time recognition algorithm for microseismic signals of rock failure based on STA/LTA and its engineering application [J]. Rock and Soil Mechanics, 2019, 40(9): 3689-3696.
[5] LI Tong, FENG Xia-ting, WANG Rui, XIAO Ya-xun, WANG Yong, FENG Guang-liang, YAO Zhi-bin, NIU Wen-jing, . Characteristics of rockburst location deflection and its microseismic activities in a deep tunnel [J]. Rock and Soil Mechanics, 2019, 40(7): 2847-2854.
[6] ZHAO Jiu-bin, LIU Yuan-xue, LIU Na, HU Ming, . Spatial prediction method of regional landslide based on distributed bp neural network algorithm under massive monitoring data [J]. Rock and Soil Mechanics, 2019, 40(7): 2866-2872.
[7] YANG Jie, MA Chun-hui, CHENG Lin, LÜ Gao, LI Bin, . Research advances in the deformation of high-steep slopes and its influence on dam safety [J]. Rock and Soil Mechanics, 2019, 40(6): 2341-2353.
[8] WANG Jian-feng, LI Tian-bin, MA Chun-chi, ZHANG Hang, HAN Yu-xuan, ZHOU Xiong-hua, JIANG Yu-peng, . Gravitational search algorithm based microseismic positioning in tunnel surrounding rock [J]. Rock and Soil Mechanics, 2019, 40(11): 4421-4428.
[9] HOU Gong-yu, HAN Yu-chen, XIE Bing-bing, WEI Guang-qing, LI Zi-xiang, XIAO Hai-lin, ZHOU Tian-ci, . Pretension strain loss of fixed-point optical fiber in tunnel structural health monitoring [J]. Rock and Soil Mechanics, 2019, 40(10): 4120-4128.
[10] HU Shuai-wei, CHEN Shi-hai, . Analytical solution of dynamic response of rock bolt under blasting vibration [J]. Rock and Soil Mechanics, 2019, 40(1): 281-287.
[11] LIU Yong, FENG Shuai, QIN Zhi-meng. Similarity evaluation method of landslide monitoring points based on motion-angle-difference [J]. Rock and Soil Mechanics, 2019, 40(1): 288-296.
[12] JIANG Xiong, XU Nu-wen, ZHOU Zhong, HOU Dong-qi, LI Ang, ZHANG Min, . Failure mechanism of surrounding rock of bus-bar tunnels at Lianghekou hydropower station subjected to excavation [J]. Rock and Soil Mechanics, 2019, 40(1): 305-314.
[13] HE Hai-jie, LAN Ji-wu, GAO Wu, CHEN Yun-min, MA Peng-cheng, XIAO Dian-kun, . Application and analysis of compressed air drainage wells in landfill slip control [J]. Rock and Soil Mechanics, 2019, 40(1): 343-350.
[14] DONG Zhi-hong, DING Xiu-li, HUANG Shu-ling, WU Ai-qing, CHEN Sheng-hong, ZHOU Zhong, . Analysis of ageing-stress characteristics and long-term bearing risk of anchor cable for a large cavern in high geo-stress area [J]. Rock and Soil Mechanics, 2019, 40(1): 351-362.
[15] DONG Zhi-hong, NIU Xin-qiang, DING Xiu-li, WENG YongHong, HUANG Shu-ling, PEI Qi-tao, ZHANG Lian, . Deformation characteristics and feedback analysis of surrounding rock of underground powerhouse at left bank of Wudongde Hydropower Station [J]. Rock and Soil Mechanics, 2018, 39(S2): 326-336.
Viewed
Full text


Abstract

Cited
  Shared   
  Discussed   
[1] ZHOU Huo-yao，SHI Jian-yong. Test research on soil compacting effect of full scale jacked-in pile in saturated soft clay[J]. , 2009, 30(11): 3291 -3296 .
[2] MA Shao-kun，HUANG Mao-song，HU Ping，QIN Hui-lai. Application of modified logarithmic model for suction strength to bearing capacity of subsoil[J]. , 2010, 31(6): 1853 -1857 .
[3] DONG Yun ，HE Wei-zhong， SUN Wei. Analysis of stability & deformation and destruction mode of road embankment built aside dam[J]. , 2010, 31(8): 2471 -2478 .
[4] YE Bin, YE Guan-lin , NAGAYA Junichi. Dynamic numerical simulation of a new quay wall structure with geosynthetics[J]. , 2010, 31(S2): 442 -446 .
[5] ZHU Zhan-yuan，LING Xian-zhang，HU Qing-li2，YU Yang，CHANG Xiao-xiao. Experimental research of vibration excited subsidence of frozen soil under long-term dynamic loads[J]. , 2009, 30(4): 955 -959 .
[6] PANG Da-peng, CHEN Jian-ping, WANG Dan-wei. Application of fractal description of rock mass joint and cracks network to advanced geological forecast of tunnels[J]. , 2009, 30(5): 1415 -1420 .
[7] YANG Rong-wei, CHENG Xiao-hui. Direct shear experiments of photoelastic granular materials[J]. , 2009, 30(S1): 103 -109 .
[8] SUN Bo，ZHOU Zhong-hua，ZHANG Hu-yuan，ZHANG Yong-xia，ZHENG Long. Characteristics and prediction model of surface temperature for rammed earthen architecture ruins[J]. , 2011, 32(3): 867 -871 .
[9] LIN Ping , YE Guan-lin , CHEN Nan , WANG Jian-hua , HASHIMOTO Tadashi. In-situ monitoring method for frozen soil pressure during cross passage construction by freezing method[J]. , 2011, 32(8): 2555 -2560 .
[10] JIA Shan-po , WU Guo-jun , CHEN Wei-zhong. Application of finite element inverse model based on improved particle swarm optimization and mixed penalty function[J]. , 2011, 32(S2): 598 -603 .
Copyright © Rock and Soil Mechanics, All Rights Reserved.
Tel: 027-87198484, 87199252, 87199253, 87198752　E-mail: ytlx@whrsm.ac.cn
Powered by Beijing Magtech Co. Ltd