An introduction to spatial database systems

We propose a definition of a spatial database system as a database system that offers spatial data types in its data model and query language, and supports spatial data types in its implementation, providing at least spatial indexing and spatial join methods. Spatial database systems offer the underlying database technology for geographic information systems and other applications. We survey data modeling, querying, data structures and algorithms, and system architecture for such systems. The emphasis is on describing known technology in a coherent manner, rather than listing open problems.

[1]  Jon Louis Bentley,et al.  Multidimensional binary search trees used for associative searching , 1975, CACM.

[2]  Michael Stonebraker,et al.  GEO-OUEL: a system for the manipulation and display of geographic data , 1977, SIGGRAPH.

[3]  Eric D. Carlson,et al.  Integrated Geographic Data Bases: The GADS Experience , 1979, Data Base Techniques for Pictorial Applications.

[4]  A. Blaser,et al.  Data Base Techniques for Pictorial Applications , 1980, Lecture Notes in Computer Science.

[5]  Ning-San Chang,et al.  A Relational Database System for Images , 1980, Pictorial Information Systems.

[6]  J. T. Robinson,et al.  The K-D-B-tree: a search structure for large multidimensional dynamic indexes , 1981, SIGMOD '81.

[7]  Andrew U. Frank,et al.  Application of DBMS to Land Information Systems , 1981, VLDB.

[8]  Shi-Kuo Chang Pictorial Information Systems - Guest Editor's Introduction , 1981, Computer.

[9]  André Frank,et al.  MAPQUERY: Data base query language for retrieval of geometric data and their graphical representation , 1982, SIGGRAPH.

[10]  Markku Tamminen,et al.  The extendible cell method for closest point problems , 1982, BIT.

[11]  Franco P. Preparata,et al.  Plane-sweep algorithms for intersecting geometric figures , 1982, CACM.

[12]  Irene Gargantini,et al.  An effective way to represent quadtrees , 1982, CACM.

[13]  Michael Stonebraker,et al.  Application of Abstract Data Types and Abstract Indices to CAD Data Bases , 1986, Engineering Design Applications.

[14]  J. L. Smith,et al.  A data structure and algorithm based on a linear key for a rectangle retrieval problem , 1983, Comput. Vis. Graph. Image Process..

[15]  Jürg Nievergelt,et al.  The Grid File: An Adaptable, Symmetric Multikey File Structure , 1984, TODS.

[16]  Prof. Dr. Kurt Mehlhorn,et al.  Data Structures and Algorithms 3 , 2012, EATCS Monographs on Theoretical Computer Science.

[17]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.

[18]  Kurt Mehlhorn,et al.  Data Structures and Algorithms 3: Multi-dimensional Searching and Computational Geometry , 2012, EATCS Monographs on Theoretical Computer Science.

[19]  Klaus Hinrichs,et al.  The grid file system , 1985 .

[20]  Klaus H. Hinrichs The grid file system: implementation and case studies of applications , 1985 .

[21]  Matthäus Schilcher Interactive graphic data processing in cartography , 1985, Comput. Graph..

[22]  Michael Ian Shamos,et al.  Computational geometry: an introduction , 1985 .

[23]  Jack A. Orenstein Spatial query processing in an object-oriented database system , 1986, SIGMOD '86.

[24]  A. Frank,et al.  Cell Graphs: A Provable Correct Method for the Storage of Geometry * , 1986 .

[25]  Umeshwar Dayal,et al.  Traversal recursion: a practical approach to supporting recursive applications , 1986, SIGMOD '86.

[26]  Karl Neumann,et al.  Modelling and Manipulating Objects in Geoscientific Databases , 1986, ER.

[27]  Sylvia L. Osborn,et al.  The design of a relational database system with abstract data types for domains , 1986, TODS.

[28]  Michael Stonebraker,et al.  The design of POSTGRES , 1986, SIGMOD '86.

[29]  Don Batory,et al.  Genesis: A Reconfigurable Database Management System , 1986 .

[30]  F. Frances Yao,et al.  Finite-resolution computational geometry , 1986, 27th Annual Symposium on Foundations of Computer Science (sfcs 1986).

[31]  David J. DeWitt,et al.  The EXODUS optimizer generator , 1987, SIGMOD '87.

[32]  Thomas C. Waugh,et al.  The GEO VIEW design A relational data base approach to geographical data handling , 1987, Int. J. Geogr. Inf. Sci..

[33]  W. Kent,et al.  Proceedings of the Thirteenth International Conference on Very Large Data Bases, Brighton, England, 1987 , 1987 .

[34]  Herbert Freeman,et al.  On the Problem of Placing Names in a Geographic Map , 1987, Int. J. Pattern Recognit. Artif. Intell..

[35]  Michael Freeston,et al.  The BANG file: A new kind of grid file , 1987, SIGMOD '87.

[36]  Christos Faloutsos,et al.  The R+-Tree: A Dynamic Index for Multi-Dimensional Objects , 1987, VLDB.

[37]  Alberto O. Mendelzon,et al.  A graphical query language supporting recursion , 1987, SIGMOD '87.

[38]  Terence R. Smith,et al.  Requirements and principles for the implementation and construction of large-scale geographic information systems , 1987, Int. J. Geogr. Inf. Sci..

[39]  Patrick Valduriez,et al.  FAD, a Powerful and Simple Database Language , 1987, VLDB.

[40]  Catriel Beeri,et al.  On the power of languages for manipulation of complex objects , 1987, VLDB 1987.

[41]  Rakesh Agrawal Alpha: An extension of relational algebra to express a class of recursive queries , 1987, 1987 IEEE Third International Conference on Data Engineering.

[42]  Ralf Hartmut Güting,et al.  A practical divide-and-conquer algorithm for the rectangle intersection problem , 1987, Inf. Sci..

[43]  Umeshwar Dayal,et al.  Simplifying Complex Objects: The PROBE Approach to Modelling and Querying Them , 1987, BTW.

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

[45]  Patrick Valduriez,et al.  Join indices , 1987, TODS.

[46]  Hans-Jörg Schek,et al.  Incorporating Data Types in an Extensible Database Architecture , 1988, JCDKB.

[47]  Hans-Peter Kriegel,et al.  Techniques for Design and Implementation of Efficient Spatial Access Methods , 1988, VLDB.

[48]  Oliver Günther,et al.  Efficient Structures for Geometric Data Management , 1988, Lecture Notes in Computer Science.

[49]  Ralf Hartmut Güting,et al.  Geo-Relational Algebra: A Model and Query Language for Geometric Database Systems , 1988, EDBT.

[50]  Christos Faloutsos,et al.  An Efficient Pictorial Database System for PSQL , 1988, IEEE Trans. Software Eng..

[51]  Andrew U. Frank,et al.  Towards a Spatial Query Language: User Interface Considerations , 1988, VLDB.

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

[53]  Don S. Batory,et al.  GENESIS: An Extensible Database Management System , 1988, IEEE Trans. Software Eng..

[54]  Thomas Joseph,et al.  PICQUERY: A High Level Query Language for Pictorial Database Management , 1988, IEEE Trans. Software Eng..

[55]  Max J. Egenhofer,et al.  A Formal Definition of Binary Topological Relationships , 1989, FODO.

[56]  Jack A. Orenstein Strategies for Optimizing the Use of Redundancy in Spatial Databases , 1989, SSD.

[57]  Hans-Werner Six,et al.  The LSD tree: Spatial Access to Multidimensional Point and Nonpoint Objects , 1989, VLDB.

[58]  Diane Greene,et al.  An implementation and performance analysis of spatial data access methods , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[59]  Erland Jungert,et al.  The Design of Pictorial Databases Based Upon the Theory of Symbolic Projections , 1989, SSD.

[60]  Andrew U. Frank,et al.  A Topological Data Model for Spatial Databases , 1990, SSD.

[61]  Agnès Voisard,et al.  Thematic Map Modeling , 1989, SSD.

[62]  Dominique Pastre,et al.  Managing Complex Objects in an Extensible Relational DBMS , 1989, VLDB.

[63]  Ralf Hartmut Güting,et al.  An algebra for structured office documents , 1989, TOIS.

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

[65]  Jeff A. Bilmes,et al.  The Implementation of the Cell Tree: Design Alternatives and Performance Evaluation , 1989, BTW.

[66]  Andreas Wolf,et al.  The DASDBS GEO-Kernel: Concepts, Experiences, and the Second Step , 1989, SSD.

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

[68]  David J. Abel SIRO-DBMS SIRO-DBMS: a database tool-kit for geographical information systems , 1989, Int. J. Geogr. Inf. Sci..

[69]  D. B. Lomet,et al.  A robust multi-attribute search structure , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

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

[71]  Peter Widmayer,et al.  The LSD tree: spatial access to multidimensional and non-point objects , 1989, VLDB 1989.

[72]  Hamid Pirahesh,et al.  Extensible query processing in starburst , 1989, SIGMOD '89.

[73]  Oliver Günther,et al.  Research issues in spatial databases , 1990, SGMD.

[74]  C. Tomlin Geographic information systems and cartographic modeling , 1990 .

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

[76]  Hans-Peter Kriegel,et al.  The Buddy-Tree: An Efficient and Robust Access Method for Spatial Data Base Systems , 1990, VLDB.

[77]  Hans-Jörg Schek,et al.  Erweiterbarkeit in DASDBS , 1990, Inform. Forsch. Entwickl..

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

[79]  F. Frances Yao,et al.  Computational Geometry , 1991, Handbook of Theoretical Computer Science, Volume A: Algorithms and Complexity.

[80]  Marc Gyssens,et al.  A graph-oriented object database model , 1990, IEEE Trans. Knowl. Data Eng..

[81]  Michel Mainguenaud,et al.  CIGALES : A GRAPHICAL QUERY LANGUAGE FOR GEOGRAPHICAL INFORMATION SYSTEMS , 1990 .

[82]  David M. Mark,et al.  Cognitive and Linguistic Aspects of Geographic Space: New Perspectives on Geographic Information Research , 1991 .

[83]  Jack A. Orenstein An Algorithm for Computing the Overlay of k-Dimensional Spaces , 1991, SSD.

[84]  Walid G. Aref,et al.  Extending a DBMS with Spatial Operations , 1991, SSD.

[85]  Hans-Peter Kriegel,et al.  The Performance of Object Decomposition Techniques for Spatial Query Processing , 1991, SSD.

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

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

[88]  Enrico Nardelli,et al.  Abstract data types for the logical modeling of complex data , 1991, Inf. Syst..

[89]  Max J. Egenhofer,et al.  Extending SQL for Graphical Display , 1991 .

[90]  Andrew U. Frank Properties of Geographic Data: Requirements for Spatial Access Methods , 1991, SSD.

[91]  Doron Rotem Spatial join indices , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[92]  Joshua Zhexue Huang,et al.  Geo-SAL: A Query Language for Spatial Data Analysis , 1991, SSD.

[93]  Terry E. Weymouth,et al.  Semantic Queries with Pictures: The VIMSYS Model , 1991, VLDB.

[94]  Agnès Voisard,et al.  Towards a Toolbox for Geographic User Interfaces , 1991, SSD.

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

[96]  S. de Hoop,et al.  Storage and manipulation of topology in Postgres. , 1992 .

[97]  Max J. Egenhofer,et al.  Why not SQL! , 1992, Int. J. Geogr. Inf. Sci..

[98]  Michael F. Worboys,et al.  A generic model for planar geographical objects , 1992, Int. J. Geogr. Inf. Sci..

[99]  Andrew U. Frank,et al.  Qualitative spatial reasoning about distances and directions in geographic space , 1992, J. Vis. Lang. Comput..

[100]  Agnès Voisard,et al.  Object-Oriented Database Systems for Geographic Applications: an Experiment with O2 , 1992 .

[101]  Jiawei Han,et al.  Distance-associated join indices for spatial range search , 1992, [1992] Eighth International Conference on Data Engineering.

[102]  P. V. Oosterom,et al.  The GEO++ system: An extensible GIS , 1992 .

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

[104]  Bernd Meyer,et al.  Beyond Icons: Towards New Metaphors for Visual Query Languages for Spatial Information Systems , 1992 .

[105]  Anthony G. Cohn,et al.  Qualitative and Topological Relationships in Spatial Databases , 1993, SSD.

[106]  Oliver Günther Efficient Computation of Spatial Joins , 1993, ICDE.

[107]  Michael Stonebraker,et al.  The SEQUOIA 2000 Project , 1993, SSD.

[108]  Hans-Jörg Schek,et al.  Query-Adaptive Data Space Partitioning using Variable-Size Storage Clusters , 1993, SSD.

[109]  Hans-Peter Kriegel,et al.  Comparison of approximations of complex objects used for approximation-based query processing in spatial database systems , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[110]  Klaus H. Hinrichs,et al.  A new algorithm for computing joins with grid files , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[111]  Ralf Hartmut Güting,et al.  Second-order signature , 1993, SIGMOD Conference.

[112]  Michael Stonebraker,et al.  The SEQUOIA 2000 storage benchmark , 1993, SIGMOD '93.

[113]  Anthony G. Cohn,et al.  Qualitative and Topological Relationships , 1993 .

[114]  Dominique Pastre,et al.  Strong Integration of Spatial Domains and Operators in a relational Database System , 1993, SSD.

[115]  Hans-Peter Kriegel,et al.  Efficient processing of spatial joins using R-trees , 1993, SIGMOD Conference.

[116]  Benoit David,et al.  GeO2: Why Objects in a Geographical DBMS? , 1993, SSD.

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

[118]  Bernd-Uwe Pagel,et al.  The Transformation Technique for Spatial Objects Revisited , 1993, SSD.

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

[120]  Ralf Hartmut Güting,et al.  Realms: A Foundation for Spatial Data Types in Database Systems , 1993, SSD.

[121]  Hans-Jörg Schek,et al.  From Extensible Databases to Interoperability between Multiple Databases and GIS Applications , 1993, SSD.

[122]  Ralf Hartmut Güting,et al.  GraphDB: Modeling and Querying Graphs in Databases , 1994, VLDB.

[123]  Ming-Ling Lo,et al.  Spatial joins using seeded trees , 1994, SIGMOD '94.

[124]  Max J. Egenhofer,et al.  Spatial SQL: A Query and Presentation Language , 1994, IEEE Trans. Knowl. Data Eng..

[125]  Ralf Hartmut Güting,et al.  Explicit Graphs in a Functional Model for Spatial Databases , 1994, IEEE Trans. Knowl. Data Eng..

[126]  Ralf Hartmut Güting,et al.  GraphDB: A Data Model and Query Language for Graphs in Databases , 1994 .

[127]  Claudia Bauzer Medeiros,et al.  Databases for GIS , 1994, SGMD.