Spatial Extender

Spatial Extender leverages the power of SQL for geographical analysis by providing a set of structured UDTs for storing geographical data such as coordinates. It also provides UDFs for comparing and analyzing the data in SQL statements.

Analyzing Geographical Data

Standard SQL is limited in its ability to analyze geographical data stored in a database. Simple arithmetic operations and math functions exist to manipulate numeric data such as addition, subtraction, multiplication, and division. When attempting more complex calculation, such as geometric intersections, the SQL statements will be very complicated. It is difficult to perform these calculations in SQL statements.

Spatial Extender simplifies geographical analysis by ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.