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

This inter-disciplinary comprehensive text shows how to manage spatial data in GIS, CAD, and multimedia systems and their application domains. This book helps readers master various stages of traditional spatial database design and implementation, introducing conceptual models (e.g. pictogram-enhanced ERD), explaining query languages (e.g. OGIS, SQL3), and finally describing efficient implementations using query optimization algorithms as well as spatial storage and indexing methods (e.g. R-trees). For students or professionals, this book balances cutting-edge research and practice to provide many firsts.

OUTSTANDING FEATURES

• Comprehensive yet concise overview of Spatial Databases for students and practitioners.
• Self-contained treatment without assuming pre-requisite knowledge of GIS or Databases.
• Extensive use of industry standards, such as OGIS spatial data types and operations.
• Complete coverage of spatial networks including modeling, querying and storage methods.
• Detailed discussion of issues related to Spatial Data Mining.
• Balance between cutting-edge research and commercial trends.
• Variety of exercises at the end of each chapter.
• Easy-to-understand examples from common knowledge application-domains.

This book by leading experts in the field provides readers with a wide range of applications and methods for spatial database management systems, and allows readers to gain hands-on experience with examples in the book. It balances theory (cutting-edge research) and practice (commercial trends) to provide a comprehensive and clear overview. Includes coverage of GIS application trends as spatial networks; discussion of spatial data mining; overview of OGIS standard spatial datatypes and operations; object-relational database framework applied in each chapter. For professionals in the field of Databases, Geographic Information Systems, Geography, Remote Sensing, Multimedia Information, Civil and Mechanical Engineering, Forestry, CAD/CAM, Health Informatics, and Natural Resource Management. This text aims to provide students with the basics in the applications and methods of spatial database management systems. It balances theory (cutting-edge research) and practice (commercial trends)