Oracle 10g: A Platform for Enterprise GeoSpatial Applications

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 • What’s 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 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

9. 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

10. 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

11. 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');

12. 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’;

13. 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

14. 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

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

16. 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

17. 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

18. 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

19. DeFacto Standard for GeoSpatial Types in DBMS Networks (lines) Parcels (polygons) Locations (points) Data Imagery (raster, grids) Addresses (geocoded points) Topological Relations (persistent topology)

20. 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

21. Integrating all Information • Relate associated information to spatial locations • records • images • drawings • maps • documents

22. 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

23. 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

24. 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

25. 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

26. 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)

27. Fleet Management

28. 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

29. Oracle/ESRIBest Practices

30. 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

31. 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

32. 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

33. 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

34. 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

35. 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

36. 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

37. 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

38. 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

39. 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,

40. What’s New?

41. 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)

42. 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

43. 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

44. 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

45. 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

46. Support for Spatial Standards • OGC: Simple Features, GML, OpenLS • SQL92, SQLMM • ISO211 • W3C: (HTTP, HTML, SVG)

47. 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

48. Q & Q U E S T I O N S A N S W E R S A http://technet.oracle.com/products/spatial