| 表分区在分界开关监控系统数据库的应用 |
| |
| 引用本文： | 李亚龙,朱岩. 表分区在分界开关监控系统数据库的应用[J]. 计算机系统应用, 2016, 25(2): 235-238 |
| |
| 作者姓名： | 李亚龙 朱岩 |
| |
| 作者单位： | 南京理工大学 自动化学院, 南京 210094,南京理工大学 自动化学院, 南京 210094 |
| |
| 摘 要： | 针对分界开关监控系统数据库实时状态表数据量急剧增大造成查询效率降低并且维护困难的问题,提出了对此类表进行分区的优化方案.详细阐述了表分区优化处理的过程,并通过分区窗口的滑动对实时状态表过时数据进行删除.通过大量测试数据,对比了分区前后的查询时间.测试结果表明,采用表分区技术能够显著提高查询效率,改善数据库性能.
|
| 关 键 词： | 数据库性能优化 表分区 索引分区 监控系统 |
| 收稿时间： | 2015-05-17 |
| 修稿时间： | 2015-06-08 |
Application of Table Partition in Boundary Load Switch Monitoring System Database |
| |
| LI Ya-Long and ZHU Yan. Application of Table Partition in Boundary Load Switch Monitoring System Database[J]. Computer Systems& Applications, 2016, 25(2): 235-238 |
| |
| Authors: | LI Ya-Long and ZHU Yan |
| |
| Affiliation: | School of Automation, Nanjing University of Science and Technology, Nanjing 210094, China and School of Automation, Nanjing University of Science and Technology, Nanjing 210094, China |
| |
| Abstract: | In face of problems such as low query speed and difficult maintenance caused by data volumes increasing in real-time state table of boundary load switch monitoring system database, this paper proposes data table partition optimization method, expounds the implementation process in detail, and removes obsolete data by sliding partitioned window. Through a large number of test data, the query efficiency of a same table before and after partitioning are compared. Results indicate that using the technology of table partition can shorten data query time dramatically and improve the stability of the database. |
| |
| Keywords: | database optimization table partition index partition monitoring system |
|
| 点击此处可从《计算机系统应用》浏览原始摘要信息 |
|
点击此处可从《计算机系统应用》下载全文 |
|
