slide1
Download
Skip this Video
Download Presentation
Oracle 10g: A Platform for Enterprise GeoSpatial Applications

Loading in 2 Seconds...

play fullscreen
1 / 49

Oracle 10g: A Platform for Enterprise GeoSpatial Applications - PowerPoint PPT Presentation


  • 190 Views
  • Uploaded on

Oracle 10g: A Platform for Enterprise GeoSpatial Applications. Daniel M. Seurer Technical Sales Consultant Oracle Public Sector Oracle Corporation. Overview. Market & Technology Trends Spatial Strategy and Customers Oracle Spatial Customer Examples What’s New in Oracle 10 g.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle 10g: A Platform for Enterprise GeoSpatial Applications' - anakin


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle 10g a platform for enterprise geospatial applications

Oracle 10g: A Platform for Enterprise GeoSpatial Applications

Daniel M. Seurer

Technical Sales Consultant

Oracle Public Sector

Oracle Corporation

overview
Overview
  • Market & Technology Trends
  • Spatial Strategy and Customers
  • Oracle Spatial
  • Customer Examples
  • What’s New in Oracle 10g
location has become ubiquitous
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
transformation of spatial computing
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

why manage spatial data in a database
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

oracle spatial history
Oracle 7.3.3

Spatial Data Option

Oracle 7.1.6

MultiDimension

Points, Lines, Polygons

Spatial Operators

Points Only

Oracle 10g

Oracle Spatial History

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

1994

1995

1997

1998

1999

2000

2001

2002

2003

2004

slide9
Spatial Indexing

Spatial Data Types

Fast Access to

Spatial Data

All Spatial Data

Stored in the Database

Oracle9i Location Capabilities

SELECT STREET_NAME FROM ROADS, COUNTIES

WHERE SDO_RELATE(road_geom, county_geom, ‘MASK=ANYINTERACT QUERYTYPE=WINDOW’) =‘TRUE’

AND COUNTYNAME=‘PASSAIC’;

Oracle

Spatial

Spatial Access Through SQL

storing simple geometry in a dbms
Fisher Circle

Coop Court

85th St.

Road

ROAD_ID

1

2

3

NAME

Pine Cir.

2nd St.

3rd St.

SURFACE

Asphalt

Asphalt

Asphalt

LANES

4

2

2

LOCATION

Storing Simple Geometry in a DBMS
indexing spatial data
Fisher Circle

Coop Court

85th St.

Road

ROAD_ID

1

2

3

NAME

Fisher Cir.

Coop Ct.

85th St.

SURFACE

Asphalt

Asphalt

Asphalt

LANES

4

2

2

LOCATION

Indexing Spatial Data

create index road_SIDX on road(GEOM)

indextype is mdsys.spatial_index

parameters ('layer_gtype=multiline');

a location query
Bengali

Curry House

5 miles

First Street

The Madras

Hilton

Main Street

A Location Query

Find all Indian restaurants within 5 miles of my hotel

SQL> SELECT R.Restaurant_name

2> FROM Restaurants R,

3> Hotels H

4> WHERE R.Restaurant_type =‘INDIAN’

5> AND H.Hotel_name = ‘HILTON’

6> AND MDSYS.SDO_WITHIN_DISTANCE(

6> R.Location, H.Location,

7> ‘distance=5 unit=mile’)

8> = ‘TRUE’;

spatial operators
INSIDE

Hospital #2

X Distance

First Street

Hospital #1

Main Street

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
spatial functions
Original

Union

Difference

Intersect

XOR

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

ConvexHull

ABC Plastics Co

Well#123

Well#409

Acme Industry

Well#14

XYX

Chemicals

Well#345

Well#596

Well#334

spatial index advisor
Spatial Index Advisor
  • Oracle Enterprise Manager (OEM)
  • One tool to manage spatial and non-spatial data
  • Tuning wizards
  • Indexing Techniques
    • Quadtree
    • R-tree
mapviewer
MapViewer
  • Build / visualize custom maps using XML API’s, 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 Location–based Services, Business Applications and Wireless platforms
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

Oracle10g: Defining a Spatial DBMS
  • GeoRaster Type
  • Network Data Schema
  • Topology Data Schema
  • Geocoding Engine
  • Routing Engine
  • Spatial Data Analysis / Mining
  • GML Support
  • SVG Support
  • Oriented Point Storage
security of geospatial and design data
Patakos

Boundary a

brown

Infrastructure

cho

Boundary b

931

Point a

ellison

Building a

ang

Building b

Infra B

973

fitzger

Point b

Boundary c

johnso

garcia

Building C

els

Build D

666

Infra C

duffy

Infrastructure D

Point c

nussbaum

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

defacto standard for geospatial types in dbms
DeFacto Standard for GeoSpatial Types in DBMS

Networks

(lines)

Parcels

(polygons)

Locations

(points)

Data

Imagery

(raster, grids)

Addresses

(geocoded points)

Topological Relations

(persistent topology)

gis and spatial databases complementary technologies
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

integrating all information
Integrating all Information
  • Relate associated information to spatial locations
    • records
    • images
    • drawings
    • maps
    • documents
approach 1 enterprise geospatial solutions
Approach 1: Enterprise GeoSpatial Solutions

Data Collection

Production

Dissemination

Surveys

GPS

New Features

Photogrammetry

Online Updates

Records

Spatial

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

approach 2 spatially enabled business apps
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

oracle spatial benefits
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
what the analysts are saying about oracle spatial
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

bentley oracle spatial serving customers for 8 years
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)
oracle esri platform
ArcIMS Client

ArcEditor/ArcInfo

ArcView

Oracle & ESRI Platform

Via Read-Write

Direct Connect

Or ArcSDE

Via Read-Only

Direct

Connect

Or ArcSDE

Application Server

ArcIMS

Oracle 10g AS

ArcSDE

Oracle 10g/ Spatial

performance expectations
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
new york city
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
integrated nyc spatial architecture
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

Transport

Health/Social services

Education

Crime

Health & Social

Services

Criminal Justice

Education

Health Planning

uk ordnance survey
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

Security

Records

Spatial

Records

Records

Spatial

Spatial

uk ordnance survey1
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
current environment
APS

FEP

DMS

LMS

Editors

DCQTCS

GRACE

Sls & Mktng

Stats

Prod Sched

Systems

MOSAIC

ROADS

DDMS

DCS

CFS

RAMS

HSM

CMS

Def Reg

GMS

GDW/S

CSAM

eDCS

GMS2

Mercury

(GOS)

FTP

Current Environment
  • Existing systems lack agility
  • Difficult to integrate/interoperate
  • Very costly to maintain
  • Complex bespoke developments
slide36
Type of Data

Size (GB)

Raw Data

350

Spatial Indexes

70

Transient Tables required during

Spatial Index Creation / Re-Build

40

Non-Spatial Indexes

20

175

History (10% change per year for 5 years)

History Spatial Indexes

20

Transient Tables required during

Spatial Index Creation / Re-Build

10

History Non-Spatial Indexes

10

Database Structures (system, undo, etc.)

100

Contingency at 25%

200

995 GB

Total

Sizing

450 million features

us census bureau 2010 tiger
US Census Bureau 2010 TIGER
  • World’s 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
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 …

Oracle Spatial in Agriculture, Mapping Agencies, Cadastres
the most popular spatial database
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
    • AT&T, Bell South, British Telecom, Cingular, DoCoMo, KDDI, Intrado, JPhone, Nextel, Sprint, T-Mobile, Telkom, Telenor, Telstra, Telus, Telia, Cellcom, Verizon, Vodafone, Wind, Czech Telecom,
10 g network data model
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)
10 g topology data model
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

10 g georaster
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 Earth’s 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
10 g geocoder
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
10 g 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

10g: Spatial Analytic Functions
support for spatial standards
Support for Spatial Standards
  • OGC: Simple Features, GML, OpenLS
  • SQL92, SQLMM
  • ISO211
  • W3C: (HTTP, HTML, SVG)
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

Advantages of Managing Spatial Data in a Database
slide48
Q

&

Q U E S T I O N S

A N S W E R S

A

http://technet.oracle.com/products/spatial

ad