Oracle Database 11g Unstructured Data

Competitive Analysis of Spatial and Multimedia Features in Oracle Database 11g and IBM DB2 9.5 for LUW

Spatial Extender (included with all DB2 Editions)

• Supports “flat earth” coordinates, not accurate for calculations on geometries spanning the earth or poles
• Indexing (grid) is older, maintenance intensive & less performant
• Geocoder converts only US addresses to Lat./Long. coordinates
• Upgrade from 8.0 or 9.1 requires data migration that may require index rebuild
• Limited 3rd Party support: ESRI, MapInfo, Open Source (GeoTools, GeoServer and uDig)

Geodetic Data Management Feature (Option for ESE only)

• IBM’s whole Earth (geodetic) model; Requires Spatial Extender
• Priced option with less capabilities than Oracle’s free Locator
• No advanced features like those in Oracle Spatial

Competitive Benchmark at NOAA

National Polar Orbiting Environmental Satellite System

• Data Exploitation Project
  • Create, disseminate and communicate “products” generated from the images and information captured by the NPOESS Satellites to government agencies, weather services, etc.
• Requirements
  • Process streaming data files of point metadata
  • Import each file and create spatial indexes in under 30 seconds
  • Ingest a continuous stream of data over a 3 day period
  • Offline data on the 3rd day
• Challenges
  • IBM based systems and infra-structure commonly used
  • Benchmark system administered by customer
  • Storage, network and AIX journaled file system limitations

© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Oracle Database 11g Transparent Data Encryption
2. Oracle Database 11g: BI and Data Warehousing Student Guide
3. Oracle 11g Competing Against IBM DB2 9.5 for Linux,Unix and Windows
4. Oracle Data Integrator 11g Product Overview and New Features
5. Oracle Database 11g: High Availability Student Guide
6. Oracle Database 11g: XML Development Student Guide
7. Oracle Database 11g: Scheduler Student Guide
8. Readme Information for Oracle Database 11g Release 2 (11.2.0.2)
9. Protecting Applications Using Oracle 11g Database Vault
10. Oracle database 11g r2最新安装体验