Abstract
Efficient query processing is a prerequisite to the use of any new methodology for data intensive applications. To optimize queries against constraint databases, one combines techniques from spatial query processing, relational query processing, as well as constraint solving. In this chapter, we present some preliminary results on optimizing such queries, and indicate possible directions of future research.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Bibliographic Notes
J. A. Orenstein. Spatial query processing in an object-oriented database system. In Proceedings of the 1986 ACM SIGMOD International Conference on Management of Data (SIGMOD’86), pages 326–336. ACM Press, 1986.
J. A. Orenstein and F. Manola. PROBE spatial data modeling and query processing in an image database application. IEEE Transactions on Software Engineering (TSE), 14 (5): 611–629, 1988.
B. C. Ooi, R. Sack-Davis, and K. J. Mc Donell. Extending a DBMS for geographic applications. In Proceedings of the 5th IEEE International Conference on Data Engineering (ICDE’89), pages 590–597. IEEE Computer Society Press, 1989.
B. C. Ooi. Efficient Query Processing in a Geographic Information System, volume 471 of Lecture Notes in Computer Science. Springer-Verlag, 1990.
T. Brinkhoff, H.-P. Kriegel, R. Schneider, and B. Seeger. Multistep processing of spatial joins. In Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data (SIGMOD’94), pages 197–208. ACM Press, 1994.
V. Gaede and O. Günther. Multidimensional access methods. ACM Computing Surveys, 30 (2): 170–231, 1998.
T. Brinkhoff, H.-P. Kriegel, and B. Seeger. Efficient processing of spatial joins using R-trees. In Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data (SIGMOD’93), pages 237–246. ACM Press, 1993.
M.-L. Lo and C. V. Ravishankar. Spatial joins using seeded trees. In Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data (SIGMOD’94), pages 209–220. ACM Press, 1994.
J. M. Patel and D. J. DeWitt. Partition based spatial-merge join. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data (SIGMOD’96)pages 259–270. ACM Press, 1996.
N. Koudas and K. C. Sevcik. Size separation spatial join. In Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data (SIGMOD’97), pages 324–335. ACM Press, 1997.
J. C. Freytag. A rule-based view of query optimization. In Proceedings of the 1987 ACM SIGMOD International Conference on Management of Data (SIGMOD’87), pages 173–180. ACM Press, 1987.
R. H. Güting. Geo-Relational algebra: A model and query language for geometric database systems. In Proceedings of the 1st International Conference on Extending Database Technology (EDBT’88), volume 303 of Lecture Notes in Computer Science, pages 506–527. Springer-Verlag, 1988.
L. Becker and R. H. Güting. Rule-based optimization and query processing in an extensible geometric database system. ACM Transactions on Databases Systems (TODS), 17 (2): 247–303, 1992.
R. H. Güting. Geo-Relational algebra: A model and query language for geometric database systems. In Proceedings of the 1st International Conference on Extending Database Technology (EDBT’88), volume 303 of Lecture Notes in Computer Science, pages 506–527. Springer-Verlag, 1988.
Y. Theodoridis, E. Stephanakis, and T. K. Sellis. Cost models for join queries in spatial databases. In Proceedings of the 14th IEEE International Conference on Data Engineering (ICDE’98), pages 476–483. IEEE Computer Society Press, 1998.
S. Grumbach and Z. Lacroix. Computing queries on linear constraint databases. In Proceedings of the 5th International Workshop on Database Programming Languages (DBPL’95), Electronic Workshops in Computing, page 11. Springer-Verlag, 1995.
S. Grumbach, P. Rigaux, and L. Segoufin. On the orthographic dimension of constraint databases. In 7th International Conference on Database Theory (ICDT’99), volume 1540 of Lecture Notes in Computer Science, pages 199–216. Springer-Verlag, 1999.
J. Chomicki, D. Goldin, and G. M. Kuper. Variable independence and aggregation closure. In Proceedings of the 15th ACM SIGACTSIGMOD-SIGART Symposium on Principles of Database Systems (PODS’96), pages 40–48. ACM Press, 1996.
S. Grumbach, P. Rigaux, and L. Segoufin. Spatio-temporal data handling with constraints. In Proceedings of the 6th International Symposium on Advances in Geographic Information Systems (ACMGIS’98), pages 106–111, 1998.
S. Grumbach, P. Rigaux, and L. Segoufin. The DEDALE system for complex spatial queries. In Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data (SIGMOD’98), pages 213–224. ACM Press, 1998.
S. Grumbach and J. Su. Towards practical constraint databases. In Proceedings of the 15th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS’96), pages 28–39. ACM Press, 1996.
S. Grumbach and J. Su. Finitely representable databases. Journal of Computer and System Sciences (JCSS), 55 (2): 273–298, 1997.
O. H. Ibarra and J. Su. On the containment and equivalence of database queries with linear constraints. In Proceedings of the 16th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS’97), pages 32–43. ACM Press, 1997.
A. Belussi, E. Bertino, and B. Catania. Manipulating spatial data in constraint databases. In Max J. Egenhofer and John R. Herring, editors, 5th Symposium on Large Spatial Databases (SSD’97), volume 1262 of Lecture Notes in Computer Science, pages 115–141. Springer-Verlag, 1997.
S. Grumbach, P. Rigaux, and L. Segoufin. The DEDALE system for complex spatial queries. In Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data (SIGMOD’98), pages 213–224. ACM Press, 1998.
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Grumbach, S., Lacroix, Z., Rigaux, P., Segoufin, L. (2000). Optimization Techniques. In: Kuper, G., Libkin, L., Paredaens, J. (eds) Constraint Databases. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-04031-7_14
Download citation
DOI: https://doi.org/10.1007/978-3-662-04031-7_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-08542-0
Online ISBN: 978-3-662-04031-7
eBook Packages: Springer Book Archive