Topological operators: a relaxed query processing approach

Relaxation and approximation techniques have been proposed as approaches for improving the quality of query results, in terms of completeness and accuracy, in environments where the user may not be able to specify the query in a complete and exact way, since data are quite heterogeneous or she may not know all the characteristics of data at hand. This problem, mainly addressed for relational and XML data, is nowadays quite relevant also for geo-spatial data, due to their increasing usage in highly critical decisional processes. Among geo-spatial queries, those based on spatial and more precisely topological relations are currently used in an increasing number of applications. As far as we know, no approach has been proposed so far for relaxing queries based on topological predicates when they return an empty or insufficient answer, in order to improve result quality and user satisfaction. In this paper, we consider this problem and we present a general relaxation strategy for, possibly multi-domain, topological selection and join queries. Two specific semantics are also provided: the first applies the minimum amount of relaxation in order to get an acceptable answer; the second relaxes the given query of a certain fixed amount, depending on the considered topological predicate. Index-based processing algorithms, for efficiently executing relaxed queries based on the proposed semantics, are also presented and a specific topological similarity function, to be used for relaxation purposes, is proposed. Experimental results show that the overhead given by query relaxation is acceptable.

[1]  Jianzhong Li,et al.  Efficient Algorithms for Skyline Top-K Keyword Queries on XML Streams , 2009, DASFAA.

[2]  Jing Shan,et al.  On Spatial-Range Closest-Pair Query , 2003, SSTD.

[3]  Barbara Catania,et al.  Relaxing Topological Selection Operators: an Index-based Approach , 2009, SEBD.

[4]  Man Lung Yiu,et al.  Top-k Spatial Preference Queries , 2007, 2007 IEEE 23rd International Conference on Data Engineering.

[5]  Wenfei Fan,et al.  Conditional functional dependencies for capturing data inconsistencies , 2008, TODS.

[6]  Ihab F. Ilyas,et al.  A survey of top-k query processing techniques in relational database systems , 2008, CSUR.

[7]  Donald Kossmann,et al.  The Skyline operator , 2001, Proceedings 17th International Conference on Data Engineering.

[8]  Yunjun Gao,et al.  Direction-based spatial skylines , 2010, MobiDE '10.

[9]  Dimitris Papadias,et al.  Top-k spatial joins , 2005, IEEE Transactions on Knowledge and Data Engineering.

[10]  Jonathan Goldstein,et al.  When Is ''Nearest Neighbor'' Meaningful? , 1999, ICDT.

[11]  Marios Hadjieleftheriou,et al.  R-Trees - A Dynamic Index Structure for Spatial Searching , 2008, ACM SIGSPATIAL International Workshop on Advances in Geographic Information Systems.

[12]  Bernhard Seeger,et al.  Progressive skyline computation in database systems , 2005, TODS.

[13]  Meng-Han Yang,et al.  Approximate Continuous K Nearest Neighbor Queries for Continuous Moving Objects with Pre-defined Paths , 2005, ER.

[14]  Eliseo Clementini,et al.  A Small Set of Formal Topological Relationships Suitable for End-User Interaction , 1993, SSD.

[15]  Cyrus Shahabi,et al.  The spatial skyline queries , 2006, VLDB.

[16]  Anthony K. H. Tung,et al.  Relaxing join and selection queries , 2006, VLDB.

[17]  Yuan Tian,et al.  Finding skyline paths in road networks , 2009, GIS.

[18]  Barbara Catania,et al.  Towards Similarity-Based Topological Query Languages , 2006, EDBT Workshops.

[19]  Wolf-Tilo Balke,et al.  Query relaxation using malleable schemas , 2007, SIGMOD '07.

[20]  Cyrus Shahabi,et al.  Processing spatial skyline queries in both vector spaces and spatial network databases , 2009, TODS.

[21]  Elena Ferrari,et al.  Spatial Data on the Web, Modeling and Management , 2007, Spatial Data on the Web.

[22]  Max J. Egenhofer,et al.  On the Equivalence of Topological Relations , 1995, Int. J. Geogr. Inf. Sci..

[23]  Dimitris Papadias,et al.  Approximate Processing of Multiway Spatial Joins in Very Large Databases , 2002, EDBT.

[24]  Agnès Voisard,et al.  Spatial Databases: With Application to GIS , 2001 .

[25]  Seung-won Hwang,et al.  Spatial Skyline Queries: An Efficient Geometric Algorithm , 2009, SSTD.

[26]  TheodoridisYannis,et al.  Topological relations in the world of minimum bounding rectangles , 1995 .

[27]  Juliana Freire,et al.  Supporting Exploratory Queries in Databases , 2004, DASFAA.

[28]  Fernando Sansò,et al.  Dealing with Multiple Accuracy Levels in Spatial Databases with Continuous Update , 2006 .

[29]  Raghu Ramakrishnan,et al.  When Is Nearest Neighbors Indexable? , 2005, ICDT.

[30]  Nick Koudas,et al.  Interactive query refinement , 2009, EDBT '09.

[31]  Yannis Manolopoulos,et al.  Closest pair queries in spatial databases , 2000, SIGMOD '00.

[32]  Nick Roussopoulos,et al.  Nearest neighbor queries , 1995, SIGMOD '95.

[33]  Yang Du,et al.  On Computing Top-t Most Influential Spatial Sites , 2005, VLDB.

[34]  Dongwon Lee,et al.  Query relaxation for xml model , 2002 .

[35]  Hanan Samet,et al.  Distance browsing in spatial databases , 1999, TODS.

[36]  Hanan Samet,et al.  Spatial join techniques , 2007, TODS.

[37]  Anant Jhingran Enterprise information mashups: integrating information, simply , 2006, VLDB.

[38]  Barbara Catania,et al.  Using Qualitative Information in Query Processing over Multiresolution Maps , 2007, Spatial Data on the Web.

[39]  Hans-Peter Kriegel,et al.  The R*-tree: an efficient and robust access method for points and rectangles , 1990, SIGMOD '90.

[40]  Divesh Srivastava,et al.  Approximate Joins: Concepts and Techniques , 2005, VLDB.