东南大学学报（自然科学版）2011，Vol.41Issue(z1)：130-133,4.DOI:10.3969/j.issn.1001-0505.2011.S1.028
GPS定位监控系统数据库的分区优化及其实现
Data table zoning optimization of database for GPS monitoring systems
摘要
Abstract
The realization process of data table partition optimization method is expounded. Partitions of large data table are stored in different file groups. By dispersing the visit to each partition table , the amount of data visited in each data retrieval is reduced. Finally through a large number of data test, the query efficiency of a same table before and after zoning optimization are compared. Results show that the table after zoning optimization costs less time to execute the same inquiry commands. When the time span of querying data contains less zonings, the performance improvement is more obvious. It shows that appropriate data table zoning optimization has obvious ascending effect on performance.关键词
数据库/分区优化/监控系统Key words
monitor system/ database/ zoning optimization分类
交通工程引用本文复制引用
徐述书,叶桦,仰燕兰..GPS定位监控系统数据库的分区优化及其实现[J].东南大学学报（自然科学版）,2011,41(z1):130-133,4.基金项目
江苏省徐工集团院士工作站资助项目(BM2009562)、江苏省重大科技成果转化资助项目(BA2008042). （BM2009562）
