Spatial Databases: A Tour

Who Can Benefit from Spatial Data Management? -- GIS and SDBMS -- Three Classes of Users for Spatial Databases -- An Example of an SDBMS Application -- A Stroll through Spatial Databases -- Space Taxonomy and Data Models -- Query Language -- Query Processing -- File Organization and Indices -- Query Optimization -- Data Mining -- Spatial Concepts and Data Models -- Models of Spatial Information -- Field-Based Model -- Object-Based Models -- Spatial Data Types -- Operations on Spatial Objects -- Dynamic Spatial Operations -- Mapping Spatial Objects into Java -- Three-Step Database Design -- The ER Model -- The Relational Model -- Mapping the ER Model to the Relational Model -- Trends: Extending the ER Model with Spatial Concepts -- Extending the ER Model with Pictograms -- Trends: Object-Oriented Data Modeling with UML -- Comparison between ER and UML -- Spatial Query Languages -- Standard Database Query Languages -- World Database -- RA -- The Select and Project Operations -- Set Operations -- Join Operation -- Basic SQL Primer -- DDL -- DML -- Basic Form of an SQL Query -- Example Queries in SQL -- Summary of RA and SQL -- Extending SQL for Spatial Data -- The OGIS Standard for Extending SQL -- Limitations of the Standard -- Example Queries that Emphasize Spatial Aspects -- Trends: Object-Relational SQL -- A Glance at SQL3 -- Object-Relational Schema -- Example Queries -- Appendix: State Park Database -- Example Queries in RA -- Spatial Storage and Indexing -- Storage: Disks and Files -- Disk Geometry and Implications