Query evaluation and optimization in deductive and object-oriented spatial databases

Abstract A deductive and object-oriented spatial (DOOS) database system enhances a spatial database system with deductive and object-oriented features. Two major kinds of computations co-exist in a DOOS database system: (1) spatial reasoning based on spatial relationships specified by spatial (deduction) rules, and (2) spatial computation based on computationally intensive geometric algorithms (methods). The impedance mismatch between set-oriented spatial query evaluation and tuple-oriented spatial algorithmic computation poses a major challenge in the implementation of such a system. This study attacks this problem in the following three aspects: (1) deduction rule compilation and high-level, relational and geo-relational algebraic simplification; (2) query plan generation by dynamic connection graph analysis and access path selection; and (3) set-oriented processing of spatial methods. The study presents an integrated view on set-oriented query processing in deductive and object-oriented spatial database systems and leads to a set of spatial query processing and optimization techniques which are useful not only at the processing of deductive and object-oriented spatial queries but also at the possible extensions towards query processing and optimization in other deductive and object-oriented database systems containing both declaratively defined deduction rules and procedurally defined computational routines.

[1]  Lawrence O'Gorman,et al.  An object model for image recognition , 1989, Computer.

[2]  Ralf Hartmut Güting,et al.  Rule-based optimization and query processing in an extensible geometric database system , 1992, TODS.

[3]  Wu-chun Feng,et al.  Map data processing in geographic information systems , 1989, Computer.

[4]  Hanan Samet,et al.  The Design and Analysis of Spatial Data Structures , 1989 .

[5]  Walid G. Aref,et al.  Optimization for Spatial Query Processing , 1991, Very Large Data Bases Conference.

[6]  Frank Manola,et al.  PROBE Spatial Data Modeling and Query Processing in an Image Database Application , 1988, IEEE Trans. Software Eng..

[7]  Robert M. Haralick,et al.  Knowledge-based computer vision-integrated programming language and data management system design , 1989, Computer.

[8]  Max J. Egenhofer,et al.  Reasoning about Binary Topological Relations , 1991, SSD.

[9]  Rangasami L. Kashyap,et al.  An Object-Oriented Knowledge Representation for Spatial Information , 1988, IEEE Trans. Software Eng..

[10]  Donald D. Chamberlin,et al.  Access Path Selection in a Relational Database Management System , 1989 .

[11]  Norman W. Paton,et al.  Deduction and Deductive Databases for Geographic Data Handling , 1993, SSD.

[12]  Hamid Pirahesh,et al.  Extensions to Starburst: objects, types, functions, and rules , 1991, CACM.

[13]  Goetz Graefe,et al.  Query evaluation techniques for large databases , 1993, CSUR.

[14]  Beng Chin Ooi,et al.  Extending a DBMS for geographic applications , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[15]  Patrick Valduriez,et al.  Extending the Search Strategy in a Query Optimizer , 1991, VLDB.

[16]  Michael Kifer,et al.  Querying object-oriented databases , 1992, SIGMOD '92.

[17]  Jiawei Han,et al.  Information-Associated Join Indices for Spatial Range Search , 1995, Int. J. Geogr. Inf. Sci..

[18]  Hans-Jörg Schek,et al.  The DASDBS Project: Objectives, Experiences, and Future Prospects , 1990, IEEE Trans. Knowl. Data Eng..

[19]  Christos Faloutsos,et al.  Analysis of object oriented spatial access methods , 1987, SIGMOD '87.

[20]  Ralf Hartmut Güting,et al.  Gral: An Extensible Relational Database System for Geometric Applications , 1989, VLDB.

[21]  Oliver Günther,et al.  Efficient computation of spatial joins , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[22]  Carlo Zaniolo,et al.  Optimization in a Logic Based Language for Knowledge and Data Intensive Applications , 1988, EDBT.

[23]  Laura M. Haas,et al.  Exploiting Extensible DBMS in Integrated Geographic Information Systems , 1991, SSD.

[24]  Michael Stonebraker,et al.  Database systems: achievements and opportunities , 1990, SGMD.

[25]  Jeffrey D. Ullman,et al.  Principles Of Database And Knowledge-Base Systems , 1979 .