| GPS定位监控系统数据库的分区优化及其实现 |
| |
| 引用本文： | 徐述书,叶桦,仰燕兰. GPS定位监控系统数据库的分区优化及其实现[J]. 东南大学学报(自然科学版), 2011, 41(Z1): 130-133. DOI: 10.3969/j.issn.1001-0505.2011.S1.028 |
| |
| 作者姓名： | 徐述书 叶桦 仰燕兰 |
| |
| 作者单位： | 东南大学自动化学院,南京,210096 |
| |
| 基金项目： | 江苏省徐工集团院士工作站资助项目(BM2009562); 江苏省重大科技成果转化资助项目(BA2008042) |
| |
| 摘 要： | 针对监控系统数据库中历史数据表数据量大且需要频繁处理的特点,确定了对此类表进行分区优化处理的方案.阐述了表分区的优化处理方法的实现过程,将大数据量表分区存放于不同文件组,通过分散访问各个分区表,减少每次检索的数据量.最后通过大量的测试数据,对比了同一张大数据表按月份分区优化前后查询效率的变化.测试结果表明,表分区之后执...
|
| 关 键 词： | 数据库 分区优化 监控系统 |
Data table zoning optimization of database for GPS monitoring systems |
| |
| Xu Shushu,Ye Hua,Yang Yanlan. Data table zoning optimization of database for GPS monitoring systems[J]. Journal of Southeast University(Natural Science Edition), 2011, 41(Z1): 130-133. DOI: 10.3969/j.issn.1001-0505.2011.S1.028 |
| |
| Authors: | Xu Shushu Ye Hua Yang Yanlan |
| |
| Affiliation: | Xu Shushu Ye Hua Yang Yanlan (School of Automation,Southeast University,Nanjing 210096,China) |
| |
| 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 spa... |
| |
| Keywords: | monitor system database zoning optimization |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
