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

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.