Oracle 10g: A Platform for Enterprise GeoSpatial Applications

1
(No Transcript)
2
Oracle 10g A Platform for Enterprise GeoSpatial
Applications

• Daniel M. Seurer
• Technical Sales Consultant
• Oracle Public Sector
• Oracle Corporation

3
Overview

• Market Technology Trends
• Spatial Strategy and Customers
• Oracle Spatial
• Customer Examples
• Whats New in Oracle 10g

4
Location has become ubiquitous

• Location Aware and Enabled Infrastructure
• Mobile devices Commercial commoditization
• Web Portals MapQuest -Yahoo, Vicinity
  Microsoft
• Defense RT asset management
• Logistics RT supply chain management
• Automobiles by 2008, 80 of new cars will have
  some telematics navigation access (eyeforauto
  2004)
• Location-enabled Business Apps
• CRM, Sales, Marketing, Billing, Supply Chain

5
Transformation of Spatial Computing
3-Tier Architecture
Client Server
Spatial Components
GIS Program
XML, GML SVG, PDF
Proprietary Spatial Data
Spatial Databases
Proprietary Middleware
Department GIS
Enterprises Web Services
6
Oracle10g Spatial
7
Why Manage Spatial Data in a Database?

• Fast access for many simultaneous users
• Common environment for spatial and tabular data
• SQL access
• Database Administration (user accounts, resource
  management, security, fine-grained auditing,
  Virtual Private database)
• Advanced Security
• Backup and Recovery
• Failover Support
• Advanced Replication

9
8
Oracle Spatial History
Oracle 10g
Oracle 9.2.0
Geocoder, GeoRaster, Network Data Model,
Topology, Spatial Analytic Functions
Oracle 9i
Whole Earth Geometry Model,Function-based
indexes,Object replication, Partitioning
Oracle 8.1.7
Oracle 8.1.6
Java Classes Projections Linear
Referencing R-Tree Indexing
Oracle8i Oracle Spatial
Points, Lines, Polygons Circles, Arcs Additional
Spatial Operators Faster Performance Objects,
Geocoding Framework
Capability
Oracle 8.0.4 Spatial Cartridge
Points, Lines, Polygons Spatial Operators 40
Faster Performance
Oracle7
No Spatial Capability
1995
1997
1998
1999
1994
2000
2001
2002
2003
2004
9
Oracle9i Location Capabilities
Oracle Spatial
Spatial Access Through SQL

• SELECT STREET_NAME FROM ROADS, COUNTIES
• WHERE SDO_RELATE(road_geom, county_geom,
  MASKANYINTERACT QUERYTYPEWINDOW) TRUE
• AND COUNTYNAMEPASSAIC

10
Storing Simple Geometry in a DBMS
11
Spatial Data in Oracle9i Tables
CREATE TABLE ROAD ( Road_id NUMBER name
VARCHAR2(4), surface VARCHAR2(10), Lanes
NUMBER, LOCATION MDSYS.SDO_GEOMETRY)
12
Indexing Spatial Data
create index road_SIDX on road(GEOM)
indextype is mdsys.spatial_index parameters
('layer_gtypemultiline')
13
A Location Query
Find all Indian restaurants within 5 miles of my
hotel
SQLgt SELECT R.Restaurant_name 2gt FROM
Restaurants R, 3gt Hotels H 4gt WHERE
R.Restaurant_type INDIAN 5gt AND
H.Hotel_name HILTON 6gt AND
MDSYS.SDO_WITHIN_DISTANCE( 6gt R.Location,
H.Location, 7gt distance5 unitmile)
8gt TRUE
14
Spatial Operators

• Full range of spatial operators
• Implemented as functional extensions in SQL
• Topological Masks
• Inside Contains
• Touch Disjoint
• Covers Covered By
• Equal Overlap Boundary
• Distance Operators
• Within Distance
• Nearest Neighbor

15
Spatial Functions

• Returns a geometry
• Union
• Difference
• Intersect
• XOR
• Buffer
• Centroid
• ConvexHull
• Returns a number
• LENGTH
• AREA
• Distance

ConvexHull
ABC Plastics Co
Well123
Well409
Acme Industry
Well14
XYX Chemicals
Well345
Well596
Well334
16
Spatial Index Advisor

• Oracle Enterprise Manager (OEM)
• One tool to manage spatial and non-spatial data
• Tuning wizards
• Indexing Techniques
• Quadtree
• R-tree

17
MapViewer

• Build / visualize custom maps using XML APIs,
  Java and JSP tag libraries
• Executes in OC4J
• Supports business geographics and spatial
  analysis
• Identify / Query complex data
• Uses 9i DB Spatial / Locator
• Designed for integration with Locationbased
  Services, Business Applications and Wireless
  platforms

18
Oracle10g Defining a Spatial DBMS

• SQL Spatial Type
• R-tree index
• Spatial Operators
• Spatial Reference System
• Geodetic (lat/long) Support
• Linear Referencing
• Spatial Aggregates
• Long Transactions
• Parallel Index, Query, Load
• Partitioning

• GeoRaster Type
• Network Data Schema
• Topology Data Schema
• Geocoding Engine
• Routing Engine
• Spatial Data Analysis / Mining
• GML Support
• SVG Support
• Oriented Point Storage

19
Security of GeoSpatial and Design Data
Points of Interest
Buildings
Infrastructure
Data Security
Boundaries
User Security
Network Security
uthenticate
Privacy integrity of data
Privacy integrity of communications
Access control
Comprehensive auditing
Authenticate
20
DeFacto Standard for GeoSpatial Types in DBMS
Networks (lines)
Parcels (polygons)
Locations (points)
Data
Imagery (raster, grids)
Addresses (geocoded points)
Topological Relations (persistent topology)
21
GIS and Spatial DatabasesComplementary
Technologies
Technology
Task

• Data load
• Editing
• Visualization
• Mapping
• Analysis
• Cartography

GIS and Spatial Components

• Storage Admin
• Indexing
• Security
• User Mgmt
• Query
• Versioning
• Scalability

Spatial Database
Data
22
Integrating all Information

• Relate associated information to spatial
  locations
• records
• images
• drawings
• maps
• documents

23
Approach 1 Enterprise GeoSpatial Solutions
Data Collection
Production

Dissemination
Records
Spatial

• Surveys
• GPS
• New Features
• Photogrammetry
• Online Updates

Parcel Updates Integration Long
Transactions Versioning Topology Mgmt. Quality
Control Security
Compilation Media Production Web Delivery Online
Query Online updates Personalization Billing
Enterprise Databases Applications
24
Approach 2 Spatially-enabled Business Apps
Mobile Clients
Outage Mgmt
Asset Mgmt
Web Services
CIM/CRM
MicroStation ProjectWise
SQL
XML/SOAP
Java
SQL

Oracle10g Spatial
Files
25
Oracle Spatial Benefits

• Location-enable ALL Business Applications
• Manage vector, raster and business data
• Out-of-box data models and schemas
• Geometry, Networks, Topology, Addresses, etc.
• Easier integration with core business data
  realize value from geo spatial data investments
• Scales from department to enterprise from
  Internet, wireless and web services
• Open programming standards, Java, SQL, XML, .NET,
  OGC, ISO and emerging interoperability standards

26
What the Analysts are Saying about Oracle Spatial

• In repeated surveys, IDC has found that Oracle
  is used in an 80-90 share of Spatial
  Information Management oriented database
  installations.
• IDC, December 2002

27
Bentley / Oracle Spatial Serving Customers for
8 Years

• AEM Torino (Italy)
• Brussels Cadastre (Belgium)
• Berlin Brandenburg International Airport
  (Germany)
• City of Paris (France)
• City of Helsinki (Finland)
• Czech Cadastre (Czech Republic)
• Czech Telecom (Czech Republic)
• EPCOR, Edmonton (Canada)
• USACE Savannah District (USA)
• US Dept. of Energy, Savannah River (USA)
• Fort Hood, DPWRMD (USA)
• City of Toronto (Canada)
• City of Minneapolis Public Works (USA)
• Maryland State Highway Administration (USA)

28
Fleet Management
29
ESRI/Oracle Technology Architecture
ArcPad
Application Server
ArcIMS
ArcSDE
eBusiness Applications
10g Application Server
Data Server
Oracle 10g
30
Oracle ESRI Platform
Via Read-Write Direct Connect Or ArcSDE
Application Server
Via Read-Only Direct Connect Or ArcSDE
ArcIMS
Oracle 10g AS
ArcSDE
Oracle 10g/ Spatial
31
ESRI/Oracle Solutions

• Pre-integrated GIS platform
• Scalable enterprise capability
• Make location mainstream
• Point Solutions (mapping)
• Embedded Solutions (CRM)
• Internet, Intranet, Wireless
• Open, standards-based technology

• Shell Oil
• Mobilekom
• New York City
• U.S. EPA
• NIMA
• Dutch Transport
• Palm Beach County

32
Oracle/ESRIBest Practices
33
Performance Expectations
No longer performance difference between Oracle
Spatial type and ESRI SDE binary type

• Fetch performance of Spatial DBMS objects
  compared to proprietary binaries should be no
  more than /- 10 to 15 percent
• Anything above 15 percent difference indicates an
  anomaly
• Poor application or database design
• Incorrect configuration
• software bugs
• Check rendering engine for performance bottlenecks

34
New York City

• Developed standardized digital basemap for all
  agencies
• 6,000 miles of underground pipes
• 1 million water/sewer connections
• 32,000 sq. miles of Infrastructure Data
• 7,500 digital photographs
• Using Bentley, ESRI, MapInfo, GE Smallworld ..
• The Office of Emergency Management created a
  public site for emergency preparedness

35
Integrated NYC Spatial Architecture
GIS Specialist Systems
Location-enabled Business Applications
Environmental Management
Logistics Management
Core Spatial Business Data Repository
Transportation
Financial Management
Crime Monitoring
Citizen Portal
Oracle Spatial
DPW Services
Asset Maintenance
Topographic/Raster Cadastre Geo-coded
Address Street Center Lines Assets Environmental T
ransport Health/Social services Education Crime
Health Social Services
Criminal Justice
Education
Health Planning
36
UK Ordnance Survey
Data Collection
Production

Dissemination

• Surveys
• GPS
• New Features
• Photogrammetry
• Online Updates
• Secure extraction

Parcel Updates Integration Long
Transactions Versioning Topology Mgmt. Quality
Control Security
Compilation Media Production Web Delivery Online
Query Online updates Personalization Billing Secur
ity
Records
Spatial
Records
Records
Spatial
Spatial
37
UK Ordnance Survey

• Store and maintain once, use many times
• Reduce deployment costs
• Reduce maintenance costs
• Improve data integration
• Improve systems integration
• Facilitate new product opportunities
• Increase business agility
• Standards and COTS based

38
Current Environment

• Existing systems lack agility
• Difficult to integrate/interoperate
• Very costly to maintain
• Complex bespoke developments

39
Sizing
450 million features
40
US Census Bureau 2010 TIGER

• Worlds largest Topology Maintenance Project
• Census standardized on Oracle10g Spatial for 2010
  Topology Modernization Project
• Using Oracle10g Topology
• Data Maintenance
• Referential Integrity
• Persistent Topology
• Open Solution

41
Oracle Spatial in Agriculture, Mapping Agencies,
Cadastres

• Agriculture Agencies
• Ireland Ministry of Agric.
• Netherlands Min of Agric.
• Poland Min of Agric.
• Italian Min of Agric.
• Cadastres
• The Netherlands
• Poland
• Denmark
• Czech Republic
• Environment
• UK Environment Agency
• U.S. EPA

• Mapping Agencies
• UK Ordnance Survey
• NI Ordnance Survey
• Ordnance Survey Ireland
• SOGEI (Italy)
• NGA (USA)
• USGS (USA)
• Census Bureau (USA)
• Australia
• Hydrographic Agencies
• Canada
• Australia
• United Kingdom
• US Navy

42
The Most Popular Spatial Database

• Local Authorities
• New York City, Chicago, Los Angeles, San Jose,
  San Mateo, Washington DC, Cleveland, Cincinnati,
  Detroit, Phoenix, Helsinki, Toronto, Winnipeg,
  Vancouver, Edmonton, Malmo, Stockholm, Paris,
• Utilities
• Omaha Public Power, Reliant, Epcor, US DoE,
  Western Power Corp, Severn Trent, Bejing Power,
  Czech Telem, Copenhagen Energy, Electrabel, Gaz
  de France, Hydro-Quebec, Equitable Resources,
  Nova Naturgas, Sao Paulo Electric
• National Mapping, Cadasters Hydrographic
  Agencies
• National GeoSpatial Intelligence Agency, Dept. of
  Homeland Security, US Geological Survey, US Army,
  Ordnance Survey (UK, IR, NI), Denmark, Sweden,
  The Netherlands, Poland, Australia, Belgium,
  Czech Republic, Russia
• Transportation Management
• California, Iowa, Florida, Maine, Maryland,
  Minnesota, New York, Oklahoma, Pennsylvania,
  Alabama, Alberta, London Rail, Netherlands
  Transport, Australia, Austrian Rail, German Rail,
• Telco Wireless LBS
• ATT, Bell South, British Telecom, Cingular,
  DoCoMo, KDDI, Intrado, JPhone, Nextel, Sprint,
  T-Mobile, Telkom, Telenor, Telstra, Telus, Telia,
  Cellcom, Verizon, Vodafone, Wind, Czech Telecom,
  

43
Whats New?
44
10g Network Data Model

• Network Data Model
• A data model to store network (graph) structure
  in the database
• Explicitly stores and maintains connectivity of
  the network
• Attributes at link and node level
• Routing Engine
• Street navigation for single or multiple
  destinations
• Provide network analysis functionality in the
  database
• Supports network solutions (Tracing Routing)
• Transportation and Transit Solutions
• Field Service, Logistics
• Location based Services and Telematics
• VP Bio-Info Pathways (Life Sciences)

45
10g Topology Data Model

• New data model to store persistent topology
• Easier to do data consistency checks in this
  model
• Example when the road moves, the property
  boundary automatically moves with it
• Topology Data Model and Schema
• Describes how different spatial features are
  related to each other
• A land parcel shares the boundary with a road
• 10g continues to support transient topology
• Topology computed on demand

Conference Center
Oracle Pkwy
46
10g GeoRaster

• What is GeoRaster
• A new data type to store raster data
• Satellite images, remote sensing data
• An XML schema to store Metadata
• Data source, layer information
• Geo Referencing information
• How to relate a pixel in the image to a
  longitude/latitude on Earths surface
• Functionality
• Open, general purpose raster data model
• storage and indexing of raster data
• No size limit for each raster object
• querying and analyzing raster data
• delivering GeoRaster to external consumers
• Publish as JPEG, GIFF images

47
10g Geocoder

• Generates latitude/longitude (points) from
  address
• International addressing standardization
• Formatted and unformatted addresses
• Tolerance parameters support fuzzy matching
• 100 Java, open and scalable
• Record-level and batch processes
• Data provided by leading data vendors

48
10g Spatial Analytic Functions

• Discovery based on Spatial Patterns
• Explicitly materialize spatial relationships
• Usage
• Insurance risk analysis, crime analysis
• Demographic analysis, customer profiling
• Epidemiology, Facility placement
• Insurance Risk analysis
• cluster house-holds based on high risk
  neighborhoods
• Indentify business prospects across a region
• examine the average incomes across different
  regions of the space

49
Support for Spatial Standards

• OGC Simple Features, GML, OpenLS
• SQL92, SQLMM
• ISO211
• W3C (HTTP, HTML, SVG)

50
Advantages of Managing Spatial Data in a Database

• Same access methods (SQL)
• Select, insert, update, delete
• Same features available
• Replication, security, parallel, ...
• Same utilities
• Load, import, export, backup
• SAME DATABASE
• for spatial and non-spatial data

51
A
http//technet.oracle.com/products/spatial
52
(No Transcript)