An Application of Stored Procedures in a GPS-Based Slope Online Monitoring System for Open-Pit Mine

Zhen Shan Liu; Ren Qiang Gao; Ming Chen; Hai Sheng Yang; Qi Wang; Yang Shen Zhou

doi:10.4028/www.scientific.net/AMM.351-352.1193

Paper Titles

FBG Earth Pressure Sensors Applied in Surrounding Rock Pressure of Tunnel
p.1173

Monitoring Data Analysis of Piezometer in Xiao Langdi Sediment Tunnels
p.1179

Experimental Research on Embankment Hidden Defects Monitoring Using Distributed Optical Fiber Sensor
p.1183

The Low Strain Detection Test to Pile-Foundations of a Communication Hinge Engineering
p.1189

An Application of Stored Procedures in a GPS-Based Slope Online Monitoring System for Open-Pit Mine
p.1193

A Study on High-Rise Building Structure Selections Using Artificial Intelligence Methods
p.1198

Testing Technology for Grouted Density and Empty Hole of Prestressed Corrugated Pipe Based on Ultrasonic Wave
p.1202

Monitor and Analysis of the Foundation Pit Combination Support of Jinan West Railway Station Ground
p.1207

Field Monitoring and Analysis of Reinforcement Concrete Slab
p.1217

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 351-352An Application of Stored Procedures in a GPS-Based...

An Application of Stored Procedures in a GPS-Based Slope Online Monitoring System for Open-Pit Mine

Abstract:

As for implementing functions in slope online monitoring system by exploiting data acquired via GPS, good and high efficient stored procedures are essential. More importantly, a good designed stored procedure can simultaneously provide decision services for multiple users. By integrating the Client/Server and Browser/Server subsystems, this system explores a much convenient and automatic way to manages the mining area. 18 database tables are designed to support the database operation, such as the GPSSTATICRESULT table that storeds accurate static data and the STATIONINFO table that records all equipment information. Moreover, the design and implementation of stored procedures is analysed to flexibly support complicated system functions. The results indicate that system working with stored procedures has high performance on applications open-pit mine. The results not only confirmed the applicability and effectiveness of stored procedures, but also revealed system with stored procedures has advantages of conveniently managing mining data, timely sending real-time monitoring information, optimizing security of mine production and making auxiliary decision for enterprise.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Applied Mechanics and Materials (Volumes 351-352)

Pages:

1193-1197

DOI:

https://doi.org/10.4028/www.scientific.net/AMM.351-352.1193

Citation:

Cite this paper

Online since:

August 2013

Authors:

Zhen Shan Liu, Ren Qiang Gao, Ming Chen, Hai Sheng Yang, Qi Wang, Yang Shen Zhou

Keywords:

GPS, Open-Pit Mine, Slope Online Monitoring System, Stored Procedures

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] H. Wu, L.Y. Yuan, X.P. LI, J.C. Wu, F.P. Li, X.W. Chi, H. Li, J. Tao, Journal of Safety and Environment. Vol. 12(2012), p.177. In Chinese.

Google Scholar

[2] W. Shao, W. Gao, Q. Wang, G. Zhang, L. Yu, G. Zhang, J. Du, An Application of Stored Procedure in an On-line Monitor System for Key Pollution Sources, in Proc. World Automation Congress(WAC), China, 19-23 Septemper (2010).

Google Scholar

[3] H. Wu, L. Zhou, X. Chi, Y. Li and Y. R. Sun, Earth Sci. Inform. Vol. 5 (2012), p.77.

Google Scholar

[4] H. Wu, J. Tao, X.P. Li, X.W. Chi, H. Li, X.H. Hua, R.H. Yang, S. Wang, N. Chen, Safety Science. Vol. 51(2003), p.338.

Google Scholar

[5] H. Wu, Y. Li, N. Chen, S. Xiao and W. Cui: Advanced Science Letters. Vol. 4 (2011), p.3233.

Google Scholar

[6] Y.Y. Teng, Z.G. He, Design and Implementation of Stored Procedure Router Based on Dynamic SQL, in proc. International Forum on Information Technology and Applications, China, 15-17 May (2009).

DOI: 10.1109/ifita.2009.260

Google Scholar

[7] F. Leymann, D. Roller, Building A Robust Workflow Management System With Persistent Queues and Stored Procedures, in Proc. IEEE 14th International Conference on Data Engineering, Orlando, 23-27 February (1998).

DOI: 10.1109/icde.1998.655784

Google Scholar