DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition

Summary

Spatial Extender leverages the power of SQL in a relational database for geographical data. Each database must be enabled to add the new UDTs, functions, and procedures. A coordinate system is selected to determine how points are influenced by the shape of the earth. A spatial reference system defines the properties of a coordinate system. Geometries can be stored in a single-feature, multifeature, or mixed-feature UDT. Geocoding is used to map existing data, such as addresses, into geographical data. UDFs are called from SQL statements from applications to manage and analyze geographical data.