SQLite数据库在煤矿现代化信息管理中的应用研究

详细信息

Application Research of SQLite Database in Modern Information Management of Coal Mine

Chongqing Research Institute of China Coal Technology and Engineering Group Corporation, Chongqing 400037, China

摘要: 针对大型数据库应用在煤矿现代化信息管理中存在操作复杂、维护成本高的问题，提出了一种将SQLite数据库应用在煤矿现代化信息管理中的方案；介绍了SQLtie数据库的基本结构及特点，给出了该方案的模拟测试分析。测试结果表明，对煤矿现代化信息管理中的门户网站、办公自动化等系统，SQLite数据库能充分发挥其高效、易用的优点；对于需要大量并发操作的瓦斯监控系统，SQLite数据库具有一定的局限性。
- 煤矿 /
- 信息管理 /
- SQLite数据库
Abstract: In view of problems of complex operation and high maintenance cost existed in application of large databases in modern information management of coal mine, the paper proposed a scheme of modern information management of coal mine by use of SQLite database. It introduced basic structure and characteristics of SQLite database and gave simulation analysis of the scheme. The test result showed that SQLite database can fully play advantages of high efficiency and useability for portal website and office automation system in modern information management of coal mine, but SQLite database has certain limitation for gas monitoring and control system which needs a lot of concurrent operation.
- coal mine, information management, SQLite database