Oracle 10g a platform for enterprise geospatial applications
This presentation is the property of its rightful owner.
Sponsored Links
1 / 49

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


  • 126 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

Oracle 10g: A Platform for Enterprise GeoSpatial Applications

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


Oracle10g spatial

Oracle10g Spatial


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


Oracle 10g a platform for enterprise geospatial applications

  • 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

      • InsideContains

      • TouchDisjoint

      • CoversCovered By

      • EqualOverlap 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 10g a platform for enterprise geospatial applications

Fleet Management


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


Oracle esri best practices

Oracle/ESRIBest Practices


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


    Oracle 10g a platform for enterprise geospatial applications

    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,


    What s new

    What’s New?


    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


    Oracle 10g a platform for enterprise geospatial applications

    Q

    &

    Q U E S T I O N S

    A N S W E R S

    A

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


  • Login