Design and realization of rock salt gas storage database management system based on SQL Server

Abstract

Projects involving the construction of rock salt underground gas storage have several disadvantages, for example, effective management is not employed to manage the production information and data in the process of the project, resulting in duplication of data storage, waste of storage space, lower efficiency of data calling, and negative effects on the efficiency of data update. Therefore, a database and its management systems for a rock salt gas storage was constructed based on an SQL Server database system, primarily including the management forms of the geological modeling, storage simulation, stability evaluation, economic evaluation, and covering the addition and delete checks of static and dynamic data. The security of the system was improved by setting the administrator permission. The establishment of the database management system was of tremendous importance and it provided a significant technical support for the development of the gas storage project.

Keywords

Computer technology and application / Database system / SQL Server / Rock salt gas storage

Acknowledgments

The Authors gratefully acknowledge the financial support given by the National Natural Science foundation of China (Grant No. 51174170).

References

[1] M.L. Barja, A.A.A. Fernandes, N.W. Paton, et al., Design and implementation of rock & roll: a deductive object-oriented database system[J], Infomation Syst. 20 (3) (1995) 185-211.

[2] M. Galster, P. Avgeriou, An industrial case study on variability handling in large enterprise software systems[J], Inf. Softw. Technol. 60 (2015) 16-31.

[3] S.L. Zhao, J.L. Yang, An overview of the study on properties of underground rock salt cavity for geo-stock[J], China Well Rock Salt (03) (2003) 22-25.

[4] H. Zhen, Y.F. Shi, The technology of database programming and database storage[J], Electron. Technol. Softw. Eng. (14) (2015) 202.

[5] Y. Yang, The Research on Underground Natural Gas Storage[D], Southwest Petroleum Institute, 2003.

[6] N.R. Swain, K. Latu, S.D. Christensen, et al., A review of open source software solutions for developing water resources web applications[J], Environ. Model. Softw. 67 (2015) 108-117.

[7] J.Q. Deng, Study on Global Stability Evaluation and Failure Mechanism of Dense Storage Cavern Group in Salt Rock[D], Tsinghua University, 2013.

[8] M. Kurihara, J. Liang, F. Fujimoto,Development and Application of Underground Gas Storage Simulator[Z], 2000.

[9] X.P. Luo, Data Base Technique[M], Tsinghua University Press, Beijing, 1999.

[10] Y.L. Yuan, Database System Development through Server SQL 2008[M], Publishing House of Electronics Industry, Beijing, 2009.

[11] C.D. Zhou, Design and Realization of the Safe Disposal of Waste Comprehensive Information Platform Database[D], Yunnan University, 2015.

[12] J.B. Zhang, Application of PL SQL programming in oilfield production data[J], Special Oil Gas Reservoirs 14 (04) (2007) 97-100.

[13] Y.L. Ma, Y.L. Liu, et al., The development of the inquiry system of an oilfield development database on the Base of.NET[J], Comput. Appl. Petroleum (02) (2005) 21-23.

[14] G. Appelgren Lara, M. Delgado, N. Marin, Fuzzy Multidimensional Modelling for Flexible Querying of Learning Object Repositories, Springer Berlin Heidelberg, Berlin, Heidelberg, 2013, pp. 112-123.

[15] B. Malysiak-Mrozek, D. Mrozek, S. Kozielski, Processing of Crisp and Fuzzy Measures in the Fuzzy Data Warehouse for Global Natural Resources, Springer Berlin Heidelberg, Berlin, Heidelberg, 2010, pp. 616-625.

[16] S. Zhang, Research on Techniques for Query Processing on Graph Database[D], Harbin Institute of Technology, 2010.

[17] S.Q. Zhang, Z.Z. Liu, X.H. Chen, et al., Research and application of data information management system for oil and gas field development[J], Nat. Gas. Ind. (03) (2002) 64-66.

[18] Y.X. Liu, Application of genetic simulated annealing algorithm in database query optimization research[J], J. Dalian Jiaot. Univ. (5) (2009) 85-87.

[19] X.M. Gou, J.G. Chen, H.Y. Zhang, et al., Establishing oil and gas exploration development database on the basis of GIS[J], Nat. Gas. Ind. (S) (2002) 126-129.

[20] F.X. Gao, Development and application of reservoir engineering information management system[J], J. Oil Gas Technol. (J.JPI) (S1) (2005) 231-232.

[21] L.P. He, The construction of digital performance analysis system in Changqing gas field[J], J. Southwest Petroleum Univ. (S1) (2007) 39-42.

[22] C. Liu, Research of Rock and Soil Mechanics Parameters Database and Choice of Parameters[D], Chinese Academy of Science, 2003.

[23] K. Liu, Configuration and Management Guide of Server SQL Database[M], Tsinghua University Press, Beijing, 2010.

[24] X.F. Meng, L.X. Zhou, S. Wang, State of art and trends in database research[J], J. Softw. 12 (15) (2004) 1822-1836.

[25] H. Zhen, Y.F. Shi, Research on database programming and database storage technology[J], Electron. Technol. Softw. Eng. (14) (2015) 202.

[26] J.Y. Gong, Concepts and development of spatial database management system[J], Sci. Surv. Mapp. 26 (3) (2001) 4-9.

[27] Z.Y. Li, The requirements analysis of the database application[J], Electron. Technol. Softw. Eng. (04) (2015), 197-197.