Aggregate nearest neighbor queries in spatial databases

被引:172
作者
Papadias, D
Tao, YF
Mouratidis, K
Hui, CK
机构
[1] Hong Kong Univ Sci & Technol, Dept Comp Sci, Hong Kong, Hong Kong, Peoples R China
[2] City Univ Hong Kong, Dept Comp Sci, Hong Kong, Hong Kong, Peoples R China
来源
ACM TRANSACTIONS ON DATABASE SYSTEMS | 2005年 / 30卷 / 02期
关键词
algorithms; experimentation; spatial database; nearest neighbor queries; aggregation;
D O I
10.1145/1071610.1071616
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Given two spatial datasets P (e.g., facilities) and Q (queries), an aggregate nearest neighbor (ANN) query retrieves the point(s) of P with the smallest aggregate distance(s) to points in Q. Assuming, for example, n users at locations q(1),... q(n), an ANN query outputs the facility p is an element of P that minimizes the sum of distances \pq(i)\ for 1 <= i <= n that the users have to travel in order to meet there. Similarly, another ANN query may report the point p is an element of P that minimizes the maximum distance that any user has to travel, or the minimum distance from some user to his/her closest facility. If Q fits in memory and P is indexed by an R-tree, we develop algorithms for aggregate nearest neighbors that capture several versions of the problem, including weighted queries and incremental reporting of results. Then, we analyze their performance and propose cost models for query optimization. Finally, we extend our techniques for disk-resident queries and approximate ANN retrieval. The efficiency of the algorithms and the accuracy of the cost models are evaluated through extensive experiments with real and synthetic datasets.
引用
收藏
页码:529 / 576
页数:48
相关论文
共 45 条
  • [1] Acharya S, 1999, SIGMOD RECORD, VOL 28, NO 2 - JUNE 1999, P13, DOI 10.1145/304181.304184
  • [2] AGGRAWAL C, 2001, P ACM C MAN DAT SIGM, P37
  • [3] [Anonymous], 1994, P 2 ACMWORKSHOP ADV
  • [4] An optimal algorithm for approximate nearest neighbor searching in fixed dimensions
    Arya, S
    Mount, DM
    Netanyahu, NS
    Silverman, R
    Wu, AY
    [J]. JOURNAL OF THE ACM, 1998, 45 (06) : 891 - 923
  • [5] BECKMANN N, 1990, SIGMOD REC, V19, P322, DOI 10.1145/93605.98741
  • [6] Nearest neighbor and reverse nearest neighbor queries for moving objects
    Benetis, R
    Jensen, CS
    Karciauskas, G
    Saltenis, S
    [J]. IDEAS 2002: INTERNATIONAL DATABASE ENGINEERING AND APPLICATIONS SYMPOSIUM, PROCEEDINGS, 2002, : 44 - 53
  • [7] Berchtold S., 1997, Proceedings of the Sixteenth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, PODS 1997, P78, DOI 10.1145/263661.263671
  • [8] Beyer Kevin., 1999, INT C DATABASE THEOR, P217, DOI [DOI 10.1007/3-540-49257-7_15, 10.1007/3-540-49257-7_15]
  • [9] A cost model for query processing in high dimensional data spaces
    Böhm, C
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 2000, 25 (02): : 129 - 178
  • [10] Top-k selection queries over relational databases:: Mapping strategies and performance evaluation
    Bruno, N
    Chaudhuri, S
    Gravano, L
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 2002, 27 (02): : 153 - 187