Which of the following best describes the difference between the DB2 Spatial Extender and the
DB2 Geodetic Extender?
A.
The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic
Extender uses a planar, x- and y-coordinate system
B.
The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial
Extender is used to find area, endpoints, and intersects
C.
The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the
world as a round globe
D.
The DB2 Geodetic Extender can be used to manage information like the locations of office
buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and
visualizations in disciplines like military command/control and asset management, meteorology
and oceanography
DB2 Spatial Extender
This extender allows you to store, manage, and analyze spatial data — information
about the location of geographic features — in DB2 alongside traditional data for text
and numbers. With this capability, you can generate, analyze, and exploit spatial
information about geographic features, such as the locations of office buildings or
the size of a flood zone. The DB2 Spatial Extender extends the function of DB2 with
a set of advanced spatial data types that represent geometries such as points, lines,
and polygons. It also includes many functions and features that interoperate with
those data types. These capabilities let you integrate spatial information with your
business data, adding another element of intelligence to your database. This
extender is free in DB2 9 (and has been since DB2 8.2).
DB2 Geodetic Extender
developerWorks® ibm.com/developerWorks
DB2 planning
Page 12 of 65 © Copyright IBM Corporation 1994, 2008. All rights reserved.
This extender allows you to enhance the type of applications you can build with the
DB2 Spatial Extender. The DB2 9 Geodetic Extender lets you treat the earth as a
globe and removes inaccuracies caused by operations like projections. Using the
same spatial data types and functions provided in the DB2 Spatial Extender, you can
use the DB2 Geodetic Extender to run seamless queries of data around the earth’s
poles and data that crosses the 180th meridian. You can maintain data that is
referenced to a precise location on the surface of the earth.
DB2 Geodetic Extender is named for the discipline of geodesy, which is the study of
the size and shape of the earth (or any body modeled by an ellipsoid, such as the
sun or a celestial sphere). The DB2 Geodetic Extender is designed to handle objects
defined on the earth’s surface with a high degree of precision. The DB2 Geodetic
Extender is only available for DB2 Enterprise 9.
0
0