Title: Oracle 10g: A Platform for Enterprise GeoSpatial Applications
1(No Transcript)
2Oracle 10g A Platform for Enterprise GeoSpatial
Applications
- Daniel M. Seurer
- Technical Sales Consultant
- Oracle Public Sector
- Oracle Corporation
3Overview
- Market Technology Trends
- Spatial Strategy and Customers
- Oracle Spatial
- Customer Examples
- Whats New in Oracle 10g
4Location 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
5Transformation 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
6Oracle10g Spatial
7Why 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
8Oracle 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
9Oracle9i 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
10Storing Simple Geometry in a DBMS
11Spatial Data in Oracle9i Tables
CREATE TABLE ROAD ( Road_id NUMBER name
VARCHAR2(4), surface VARCHAR2(10), Lanes
NUMBER, LOCATION MDSYS.SDO_GEOMETRY)
12Indexing Spatial Data
create index road_SIDX on road(GEOM)
indextype is mdsys.spatial_index parameters
('layer_gtypemultiline')
13A 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
14Spatial 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
15Spatial 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
16Spatial Index Advisor
- Oracle Enterprise Manager (OEM)
- One tool to manage spatial and non-spatial data
- Tuning wizards
- Indexing Techniques
- Quadtree
- R-tree
17MapViewer
- 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
18Oracle10g 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
19Security 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
20DeFacto Standard for GeoSpatial Types in DBMS
Networks (lines)
Parcels (polygons)
Locations (points)
Data
Imagery (raster, grids)
Addresses (geocoded points)
Topological Relations (persistent topology)
21GIS 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
22Integrating all Information
- Relate associated information to spatial
locations - records
- images
- drawings
- maps
- documents
23Approach 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
24Approach 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
25Oracle 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
26What 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
27Bentley / 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)
28Fleet Management
29ESRI/Oracle Technology Architecture
ArcPad
Application Server
ArcIMS
ArcSDE
eBusiness Applications
10g Application Server
Data Server
Oracle 10g
30Oracle 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
31ESRI/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
32Oracle/ESRIBest Practices
33Performance 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
34New 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
35Integrated 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
36UK 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
37UK 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
38Current Environment
- Existing systems lack agility
- Difficult to integrate/interoperate
- Very costly to maintain
- Complex bespoke developments
39Sizing
450 million features
40US 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
41Oracle 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
42The 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,
43Whats New?
4410g 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)
4510g 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
4610g 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
4710g 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
4810g 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
49Support for Spatial Standards
- OGC Simple Features, GML, OpenLS
- SQL92, SQLMM
- ISO211
- W3C (HTTP, HTML, SVG)
50Advantages 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
51A
http//technet.oracle.com/products/spatial
52(No Transcript)