计算机应用 ›› 2011, Vol. 31 ›› Issue (11): 3078-3083.DOI: 10.3724/SP.J.1087.2011.03078

• 数据库技术 • 上一篇    下一篇

路网中移动对象快照K近邻查询处理

卢秉亮1,刘娜2   

  1. 1. 沈阳航空航天大学 计算机学院,沈阳110136
    2. 沈阳航空航天大学 计算机学院,沈阳 110136
  • 收稿日期:2011-01-24 修回日期:2011-03-06 发布日期:2011-11-16 出版日期:2011-11-01
  • 通讯作者: 刘娜
  • 作者简介:卢秉亮(1953-),男(满族),辽宁本溪人,副教授,硕士,主要研究方向:数据库系统;
    刘娜(1984-),女,山东泰安人,硕士研究生,主要研究方向:数据库系统。

Snapshot K neighbor query processing on moving objects in road networks

LU Bing-liang,LIU Na   

  1. School of Computer, Shenyang Aerospace University, Shenyang Liaoning 110136, China
  • Received:2011-01-24 Revised:2011-03-06 Online:2011-11-16 Published:2011-11-01
  • Contact: LIU Na

摘要: 扩展了一种支持路网中移动对象的位置相关查询框架的功能,利用存在磁盘上的R树来存储网络连通性和一种基于内存的网格结构来维持移动对象的位置更新,提出了基于范围查询(MNDR)的快照K近邻查询算法(SKNN),对空间中的任意一条边,分析可能受影响的最大数量和最小数量的网格单元格,说明用于快照范围查询处理的搜索空间的最大范围,预估包含查询结果的子空间,使用这个子空间作为范围调用MNDR来有效地计算路网中查询点的KNN POI,降低I/O成本,缩短查询时间。通过实验对比,当规模扩展到数十万的移动对象时,SKNN比种有效查询处理空间网络数据的预计算方法S-GRID有更好大的系统吞吐量。

关键词: 空间数据库, 范围查询, 位置相关, K近邻

Abstract: The functionality of a framework that supported location-based services on moving objects in road networks was extended and Snapshot K Nearest Neighbor (SKNN) queries based on Mobile Network Distance Range (MNDR) queries was proposed using an on-disk R-tree to store the network connectivity and an in-memory grid structure to maintain the moving object position updates. The minimum and maximum number of grid cells of a given arbitrary edge in the space that were possibly affected were analyzed. The maximum bound that could be used in snapshot range query processing to prune the search space was shown. SKNN estimated the subspace containing the query results and used the subspace as range to efficiently compute the KNN POI from the query points to reduce I/O cost and time of query. Analysis shows that the maximum bound can be used in snapshot range query processing to prune the search space. The contrast experiments show that SKNN has better system throughput than S-GRID while scaling to hundreds of thousands of moving objects.

Key words: spatial database, range query, location-dependent, K Nearest Neighbor (KNN)

中图分类号: