Optimization Techniques

  • Stéphane Grumbach
  • Zoé Lacroix
  • Philippe Rigaux
  • Luc Segoufin
Chapter

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.

Keywords

Hull 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Bibliographic Notes

  1. [Ore86]
    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.Google Scholar
  2. [OM88]
    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.CrossRefGoogle Scholar
  3. [OSDD89]
    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.Google Scholar
  4. [Ooi90]
    B. C. Ooi. Efficient Query Processing in a Geographic Information System, volume 471 of Lecture Notes in Computer Science. Springer-Verlag, 1990.Google Scholar
  5. [BKSS94]
    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.Google Scholar
  6. [GG98a]
    V. Gaede and O. Günther. Multidimensional access methods. ACM Computing Surveys, 30 (2): 170–231, 1998.CrossRefGoogle Scholar
  7. [BKS93]
    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.Google Scholar
  8. [LR94]
    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.Google Scholar
  9. [PD96]
    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. Google Scholar
  10. [KS97a]
    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.Google Scholar
  11. [Fre87]
    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.Google Scholar
  12. [GD87]
    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.Google Scholar
  13. [BG92]
    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.CrossRefGoogle Scholar
  14. [Güt88]
    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.Google Scholar
  15. [TSS98]
    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.Google Scholar
  16. [GL95]
    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.Google Scholar
  17. [GRS99]
    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.Google Scholar
  18. [CGK96]
    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.Google Scholar
  19. [GRS98b]
    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.Google Scholar
  20. [GRS98a]
    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.Google Scholar
  21. [GS96]
    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.Google Scholar
  22. [GS97a]
    S. Grumbach and J. Su. Finitely representable databases. Journal of Computer and System Sciences (JCSS), 55 (2): 273–298, 1997.MathSciNetMATHCrossRefGoogle Scholar
  23. [IS97]
    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.Google Scholar
  24. [BBC97]
    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.Google Scholar
  25. [GRS98a]
    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.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2000

Authors and Affiliations

  • Stéphane Grumbach
  • Zoé Lacroix
  • Philippe Rigaux
  • Luc Segoufin

There are no affiliations available

Personalised recommendations