October 04, 2004
Spatially and Geodetically Extending
Please note that contributed articles, blog entries, and comments posted on GIScafe.com are the views and opinion of the author and do not necessarily represent the views and opinions of the management and staff of Internet Business Systems and its subsidiary web-sites.
Message from the Editor -
Welcome to GISWeekly!IBM has been in the news lately with its revised version of DB2 Spatial Extender technology in the DB2 Universal Database version 8.2, previously codenamed “Stinger,” that was developed jointly by IBM and ESRI. The Spatial Extender is now included in all versions of IBM DB2 Universal Database and enables spatial access and analysis.. More ESRI components are embedded directly into the DB2 Spatial Extender database. Read about this technology in this week's Industry News.
GISWeekly examines select top news each week, picks out worthwhile reading from around the web, and special interest items you might not find elsewhere. This issue will feature Industry News, Acquisitions/Alliances/Agreements, Announcements, Appointments, New Products, Around the Web and Upcoming Events.
GISWeekly examines select top news each week, picks out worthwhile reading from around the web, and special interest items you might not find elsewhere. This issue will feature Industry News, Acquisitions/Alliances/Agreements, Announcements, New Products, Going on Around the Web, and Upcoming Events.
GISWeekly welcomes letters and feedback from readers, so let us know what you think. Send your comments to me at
Susan Smith, Managing Editor
Spatially and Geodetically Extending
By Susan Smith
IBM has been in the news lately with its revised version of DB2 Spatial Extender technology in the DB2 Universal Database version 8.2, previously codenamed “Stinger,” that was developed jointly by IBM and ESRI. The Spatial Extender is now included in all versions of IBM DB2 Universal Database and enables spatial access and analysis.. More ESRI components are embedded directly into the DB2 Spatial Extender database.
For many years, GIS professionals (or perhaps mostly vendors?) have claimed that roughly 80 percent of all data has spatial characteristics. Even postal code information is inherently spatial, and the advent of Spatial databases have enabled users to exploit spatial data to do analysis of distance, driving times or proximity, capabilities heavily used in business and retail analysis.
database developers today.
Included here are key features and capabilities of Spatial Extender, directly from IBM.
Key features of DB2 Spatial Extender include:
According to David Beddoe and Robert Uleman of IBM's DB2 Information Management, Software Group, the Stinger version of DB2 supports Version 2.6 of the Linux kernel, which will help database clusters perform faster and take advantage of the speed of 64 bit databases and servers that rely on multiple processors. Stinger is a direct competitor of Oracle 10g, which we profiled in last week's GISWeekly.
An example of a customer might be a retail business owner who wants to expand the business and explore what the best location for a new store might be to attract upscale customers. Using existing data such as addresses and income data for each customer and census demographic data, the business owner wants to find out which customers live farther than 10 miles from the existing stores and have an income greater than $50,000 per year. Using DB2 Spatial Extender's geocoder function, the owner can translate the stores' and customers' address from this database into spatial data.
ArcExplorer, a pure Java spatial visualization application, works with Spatial Extender to visually identify where the stores and customers are.
DB2 Extender's software requirements include a licensed copy of DB2 Universal Database Enterprise Server Edition, Workgroup Server Edition, Personal Edition, Express Edition, Personal Developer's Edition or Universal Developer's Edition.
Capabilities offered in DB2 Spatial Extender include:
For spatial data modeling:
For Spatial data access:
Tackling a Problem Spherically
indexing method called the geodetic Voronoi index. The index has the ability to adapt to the nature of the data and unique properties that can help increase speed for calculating distances combined with the simplicity of a grid. The Geodetic Extender also uses a latitude-longitude coordinate system on an ellipsoidal earth model to precisely manage objects defined on the earth's surface.
In short, some highlights of this system include:
For traditional map based technology, professionals can use DB2 Spatial Extender, but for a more global approach DB2 Geodetic Extender will depict the world as round rather than flat. Military command and control and asset management, meteorology and oceanography (scientific, government and commercial), and satellite imagery and digital map providers are among those who use a round earth.
You can find the full GISCafe event calendar here.
To read more news, click here.
-- Susan Smith, GISCafe.com Managing Editor.
Be the first to review this article