表分区在分界开关监控系统数据库的应用  

Application of Table Partition in Boundary Load Switch Monitoring System Database

作　　者：李亚龙[1] 朱岩[1] 

机构地区：[1]南京理工大学自动化学院,南京210094

出　　处：《计算机系统应用》2016年第2期235-238,共4页Computer Systems & Applications

摘　　要：针对分界开关监控系统数据库实时状态表数据量急剧增大造成查询效率降低并且维护困难的问题,提出了对此类表进行分区的优化方案.详细阐述了表分区优化处理的过程,并通过分区窗口的滑动对实时状态表过时数据进行删除.通过大量测试数据,对比了分区前后的查询时间.测试结果表明,采用表分区技术能够显著提高查询效率,改善数据库性能.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.

关 键 词：数据库性能优化 表分区 索引分区 监控系统 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]