Skip to main content
Article
Capacity Constrained Assignment in Spatial Databases
SIGMOD '08: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data: June 9-12, 2008, Vancouver, Canada
  • Hou U LEONG, University of Hong Kong
  • Man Lung YIU, Aalborg University
  • Kyriakos MOURATIDIS, Singapore Management University
  • Nikos MAMOULIS, University of Hong Kong
Publication Type
Conference Proceeding Article
Version
submittedVersion
Publication Date
6-2008
Abstract

Given a point set P of customers (e.g., WiFi receivers) and a point set Q of service providers (e.g., wireless access points), where each q 2 Q has a capacity q.k, the capacity constrained assignment (CCA) is a matching M Q × P such that (i) each point q 2 Q (p 2 P) appears at most k times (at most nce) in M, (ii) the size of M is maximized (i.e., it comprises min{|P|,P q2Q q.k} pairs), and (iii) the total assignment cost (i.e., the sum of Euclidean distances within all pairs) is minimized. Thus, the CCA problem is to identify the assignment with the optimal overall quality; intuitively, the quality of q’s service to p in a given (q, p) pair is anti-proportional to their distance. Although max-flow algorithms are applicable to this problem, they require the complete distance-based bipartite graph between Q and P. For large spatial datasets, this graph is expensive to compute and it may be too large to fit in main memory. Motivated by this fact, we propose efficient algorithms for optimal assignment that employ novel edge-pruning strategies, based on the spatial properties of the problem. Additionally, we develop approximate (i.e., suboptimal) CCA solutions that provide a trade-off between result accuracy and computation cost, abiding by theoretical quality guarantees. A thorough experimental evaluation demonstrates the efficiency and practicality of the proposed techniques.

Keywords
  • Algorithms,
  • efficiency,
  • spatial databases
ISBN
9781605581026
Identifier
10.1145/1376616.1376621
Publisher
ACM
City or Country
New York
Creative Commons License
Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International
Additional URL
http://dx.doi.org/10.1145/1376616.1376621
Citation Information
Hou U LEONG, Man Lung YIU, Kyriakos MOURATIDIS and Nikos MAMOULIS. "Capacity Constrained Assignment in Spatial Databases" SIGMOD '08: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data: June 9-12, 2008, Vancouver, Canada (2008) p. 15 - 28
Available at: http://works.bepress.com/kyriakos_mouratidis/8/