›› 2005, Vol. 26 ›› Issue (S1): 300-302.

• Fundamental Theroy and Experimental Research • Previous Articles     Next Articles

Construction and application of soil database based on SQL

XU Lei-yun, ZHU Jun-gao   

  1. Research Institute of Geotechnical Engineering, Hohai University, Nanjing 210098, China
  • Received:2005-01-11 Published:2005-12-15

PDF (PC)

69

Abstract: The significance and feasibility about the database based on SQL and the characteristics of SQL database were analyzed. After a lot of data about engineering tests packed up, the database of physico-mechanical parameters of soil was built up. How to use the database and how to maintain it were presented. An example using it to analyze the relationship between compression index and swelling index was presented. With the improvement of the database, it would be significant to investigate correlations between physical and mechanical parameters of soils.

Key words: SQL, database, soil parameter, mechanical parameter

CLC Number: 

  • TB 115
  • Please send e-mail to pingzhou3@126.com if you would like to read full paper in English for free. Parts of our published papers have English translations.
  • Please send e-mail to pingzhou3@126.com if you would like to read full paper in English for free. Parts of our published papers have English translations.
    • [1] GUO Chao, GAO Yong-tao, WU Shun-chuan, CHENG Zi-qiao, ZHANG Shi-huai, HAN Long-qiang, . Research of micro-seismic source location method in layered velocity medium based on 3D fast sweeping algorithm and arrival time differences database technique [J]. Rock and Soil Mechanics, 2019, 40(3): 1229-1238.
    [2] KANG Kwang-song, HU Nai-lian, HONG Gun-yi, LI Guo-qing, PANG Gyong-jin，. Determination of rock mass mechanical parameters based on quantification and correction method of GSI value [J]. , 2018, 39(6): 2211-2218.
    [3] ZHAO Xin-yao, CHEN Jian-gong, ZHANG Hai-quan, YANG Ze-Jun, HU Ri-cheng, . Random generation of soil-rock mixture models by rock shape database using digital imaging technology [J]. Rock and Soil Mechanics, 2018, 39(12): 4691-4697.
    [4] CUI Zhen, SHENG Qian, . Numerical modelling of structural effect of equivalent mechanical parameters of fractured rock mass [J]. , 2018, 39(10): 3830-3840.
    [5] SU Cheng-dong, WEI Si-jiang, QIN Ben-dong, YANG Yu-shun,. Experimental study of influence mechanism of high temperature on mechanical properties of fine-grained sandstone [J]. , 2017, 38(3): 623-630.
    [6] JIANG Quan, CUI Jie, FENG Xia-ting, LIU Guo-feng, WANG Bai-lin, LIU Ting, Lü Yong-gang，. Stochastic statistics and probability distribution estimation of mechanical parameters of basalt [J]. , 2017, 38(3): 784-792.
    [7] FENG Fan, QIU Xin-jiao, ZHANG Guo-xin, GUAN Jun-feng, WANG Dan，. Inversion of mechanical parameters of super-high arch dam based on deformation monitoring during construction period [J]. , 2017, 38(1): 237-246.
    [8] WEN Yong, YANG Guang-hua, TANG Lian-sheng, XU Chuan-bao,. Tests and parameters study of mechanical properties of granite residual soil in Guangzhou area [J]. , 2016, 37(S2): 209-215.
    [9] WANG Kai-he, LUO Xian-qi, SHEN Hui, ZHANG Hai-tao. GSA-BP neural network model for back analysis of surrounding rock mechanical parameters and its application [J]. , 2016, 37(S1): 631-638.
    [10] HU Zheng , LIU You-rong , WANG Ping-yi , TIAN Mao-zhong,. USMR method for evaluating macro-mechanical parameters of slope rock mass deteriorated due to excavation unloading [J]. , 2016, 37(12): 3491-3498.
    [11] HE Chun-can , HU Xin-li , GONG Hui , TAN Fu-lin , ZHANG Han , ZHANG Xiao-yong，. Analysis of mesoscopic damage and mechanical behaviors of soil-rock mixture based on template database of soft and hard rocks [J]. , 2016, 37(10): 2993-3002.
    [12] SU Shi-ding, YANG Zhong-xuan, GUO Wang-bo. Assessment of design methods for axial bearing capacity of driven piles in clay [J]. , 2015, 36(S2): 389-393.
    [13] MA Fei ，JIA Shan-po，. Back analysis of elastoplastic parameters of surrounding rock for roadway in mudstone and its long-term stability prediction [J]. , 2014, 35(7): 1987-1994.
    [14] LIU Cheng-yu , HE Man-chao,. Methods to obtain mechanical parameters of weathered rock constructional elements of ancient buildings [J]. , 2014, 299(2): 474-480.
    [15] SHEN Yan-jun , XU Guang-li , YANG Geng-she , YE Wan-jun，. Probability distribution characteristics of rock mass classification and its mechanical parameters based on fine description [J]. , 2014, 299(2): 565-572.
    Viewed
    Full text


    Abstract

    Cited
      Shared   
      Discussed   
    [1] MEI Guo-xiong, LU Ting-hao, CHEN Hao, LI Zhi. True triaxial experiment of foundation pit considering initial stress[J]. , 2010, 31(7): 2079 -2082 .
    [2] LIN Hang，CAO Ping，LI Jiang-teng，JIANG Xue-liang，HE Zhong-ming. Deformation stability of three-dimensional slope based on Hoek-Brown criterion[J]. , 2010, 31(11): 3656 -3660 .
    [3] RAN Long, HU Qi. Analysis of seepage failure of deep foundation pit in silty sand[J]. , 2009, 30(1): 241 -245 .
    [4] QIAN Ji-yun, ZHANG Ga, ZHANG Jian-min. Centrifuge model tests for deformation mechanism of soil slope during rainfall[J]. , 2011, 32(2): 398 -402 .
    [5] WEI Ning，LI Xiao-chun，WANG Yan，GU Zhi-meng. Resources quantity and utilization prospect of methane in municipal solid waste landfills[J]. , 2009, 30(6): 1687 -1692 .
    [6] YIN Hong-lei，XU Qian-jun，LI Zhong-kui. Effect of swelling deformation on stability of expansive soil slope[J]. , 2009, 30(8): 2506 -2510 .
    [7] LIN Da-ming1,2，SHANG Yan-jun1，SUN Fu-jun3，SUN Yuan-chun1,2，WU Feng-bo1,2，LIU Zhi. Study of strength assessment of rock mass and application[J]. , 2011, 32(3): 837 -842 .
    [8] WU Jian，FENG Shao-kong，LI Hong-jie. Study of automatically extracting structural plane parameters from borehole images[J]. , 2011, 32(3): 951 -957 .
    [9] WU Li-zhou，XU Qiang，HUANG Run-qiu. Analysis of freezing-thawing test process of unsaturated clay[J]. , 2011, 32(4): 1025 -1028 .
    [10] LIU Zhao-chun , CHAI Jun-rui , JIA Xiao-mei , QIN lei , SUN Xu-shu. Numerical simulation of concentration diffusion of harmful gas in heading face with forced ventilation[J]. , 2009, 30(S2): 536 -539 .
    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