1 / 67

Bentley and Oracle

Bentley and Oracle. Anil Saboo, Oracle Robert Mankowski, Bentley Systems. Agenda. Bentley and Oracle relationship Oracle Spatial Technologies What is Oracle Spatial? What is the Oracle Workspace Manager? Using Oracle Spatial Technologies in Bentley Products Desktop Server

patia
Download Presentation

Bentley and Oracle

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Bentley and Oracle Anil Saboo, Oracle Robert Mankowski, Bentley Systems

  2. Agenda • Bentley and Oracle relationship • Oracle Spatial Technologies • What is Oracle Spatial? • What is the Oracle Workspace Manager? • Using Oracle Spatial Technologiesin Bentley Products • Desktop • Server • Geo Web Publisher • What’s coming in Oracle 11G? • What’s coming in Bentley Support of Oracle?

  3. Bentley and OracleRelationship

  4. Bentley Geospatial and Oracle Spatial • Bentley is an Oracle Certified Partner • Solid long-term relationship • Complementary products • Oracle: Geospatial Datastore • Bentley Geospatial: Design, Build, Data capture, Data analysis, Mapping, etc • Bentley Geospatial products using Oracle • Bentley Geospatial Extension • Bentley Map • Bentley Cadastre • Bentley Geospatial Server • Bentley Geo Web Publisher • Bentley Geospatial Industry Applications • Oracle is the interoperability standard

  5. Bentley Geospatial and Oracle SpatialCollaboration • Participant in Oracle 11 Beta program • Bentley contributes to Oracle specifications • Open channel to Oracle Development • Co-presented on several occasions • Bentley attends Oracle Spatial conferences

  6. Bentley Geospatial Oracle Strategy • Excellent Oracle Database Citizen • Create 100% Oracle Spatial Standard data • Use Oracle Spatial metadata and coordinate systems • Use Oracle standard versioning (Workspace Manager) • Not requiring any proprietary schemas, tables or fields (no MSLink) • Implementation reviewed by Oracle Spatial team

  7. Architecture Bentley Geo Web Publisher Oracle Locator Oracle Spatial • Simultaneous Multi User Editing • Long transactions, optimistic and pessimistic locking • Time component Bentley Geospatial Server • Direct editing of Oracle Spatial databases • Full support of Oracle 10G topology model • Short transactions Bentley Geospatial Industry Applications Bentley Geospatial Desktop

  8. Oracle Spatial Technologies Anil Saboo Server Technologies, Oracle Corporation

  9. Oracle SpatialSpatially-enable your enterprise with Oracle • Consolidating spatial information holdings • Eliminate proprietary silos, centralize administration • Make spatial data and technology available enterprise-wide • Utilize your database infrastructure and IT resources • Growing challenges and costs of spatial data • Scalability, Accessibility, Security, Performance, Manageability • Benefits of Oracle Spatial • Increases productivity and streamlines processes • Enables better business decisions and customer service • Reduces risk – secure, reliable, open and non-proprietary • Drives down admin, maintenance, training and support costs

  10. Delivering Enterprise-class Geospatial Database Management • Data load • Editing/transformation • Visualization • Mapping • Analysis Business Applications • Storage & Admin • Indexing • Security • User Mgmt • Query • Versioning • Scalability Data

  11. Asset Management Planning Engineering Homeland Security Logistics Consolidating Geospatial Data Management Multiple Apps Multiple Users

  12. Spatial Information Management Challenges • Scalability - large data volume • Availability – tens of thousands of users • Security – protect sensitive location data • Performance – timely query response • Accessibility – to enterprise applications • Manageability – leverage IT resources =Oracle Database Strengths

  13. Oracle Locator & Spatial Capabilities Spatial Analysis • Spatial Indexing Spatial Data Types Fast Access to Spatial Data All Location/Spatial Data Stored in the Database Spatial Access Through SQL

  14. Manage ALL Geospatial Data Types Networks (Connectivity) Parcels (polygons) Locations (points) Data Imagery (Raster) Addresses (geocoded points) Structured Networks/Boundaries (persistent topology)

  15. Workspace Manager • Feature of the Oracle Database for application developers and DBAs • Manages current, proposed and historical values for data in the same database • Isolate a collection of changes to production data • Keep a history of changes to data • Perform “what if” analysis • Benefits • Saves Money – Ability to consolidate a number of databases into a single database • Saves Time – Concurrent access to current, proposed and historical data • Saves Labor – Single point of update and management; easy to manage through OEM; no custom code or app specific version data

  16. Workspace Manager with Spatial • Allows application developers to version topologies stored in the Oracle Spatial Topoplogy data model • Can be used • To isolate a collection of changes in one or more topologies • Keep a history of changes • Create multiple scenarios for “what if” analysis in the same database

  17. Using Oracle Spatial Technologiesin Bentley Products

  18. Product Framework Enterprise Integration Bentley Geospatial Web Publishing Bentley Geospatial Server Bentley Geospatial Industry Applications Bentley Geospatial Desktop Bentley Geospatial Mobile Applications

  19. Geospatial Extension • Development framework • Data Model customization with XFM • Interoperability framework • Oracle Spatial direct support • Native SHP, MXD, OGC support among others • The NEW Map Manager • Topology and Geometry Editing

  20. Bentley Map A solution to create, maintain, and analyze spatial data sets ... • Use thematic and analytical tools to create detailed maps and reports • Use finishing tools for professional output • Create PDF map books • Based primarily on the XFM architecture

  21. Geospatial Desktop-Oracle Spatial Direct Connect Functionality • Attach/Open directly from Oracle • Import from Oracle • Geometry support • Topology Support • Coordinate Systems • Text, Feature-Linked text • Coded Domains • Loading Tools (DGN2SDO) • Short Transaction (Pessimistic) • Fully customizable - XFM API • Administration Tool Bentley Geospatial Industry Applications Bentley Geospatial Desktop

  22. Importing Oracle Spatial Data • One way import • Meant for including Oracle Spatial data in engineering design process • Doesn’t require any XFM Schema What you will see: • Importing Oracle Spatial data in current DGN • Defining symbology

  23. Opening Oracle Spatial Data • Read/Write access to Oracle What you will see: • Opening Oracle Spatial data in current DGN • Change Display using Map Manager • Lock the geometry • Edit the geometry using Geospatial Extension • Post the result • View the results in Map Builder

  24. Demo

  25. What Did You Just See? • Opening Oracle Spatial data in current DGN • Change Display using Map Manager • Lock the geometry • Edit the geometry using Geospatial Extension • Post the result • View the results in Map Builder

  26. Bentley Topology Types • Session topology • Build the topology information on-the-fly each time it is necessary • Like in GeoGraphics 8.5 • Persistent topology • Topological primitives are created only once • Topological primitives (node, edge, face) information is in the DGN • These modes are supported with or without Oracle

  27. DGN Persistent Topology in the DGN Bentley Persistent Topology Model • Topology is stored in the DGN • XFM features in the main DGN model • Topology primitives in an hidden model

  28. Editing topology • Place features like any other XFM features • Use shared editing command to move common node • Ex: moving a lot corner moves all the parcels with it • Split/Merge polygon command • Line Cleaning tools • Find Dangles, Gaps, Duplicates • From Spaghetti Line Work • SHP file, DGN, DWG, Oracle Geometry, etc • Topology graph is maintained while editing

  29. Spatial Analysis on topology • Overlay Operations • Buffer

  30. Oracle Spatial DGN2SDO Oracle SQLLOADER Loading Data in Oracle • DGN2SDO • Data loading tool for Administrator or DBA • Convert into SQL Loader Scripts (.SQL, .CTL, .DAT) • Supports two modes: SDO Geometry, SDO Topology • Command-line only, no GUI Attributes OBDC OLEDB ORACLE .SQL .CTL .DAT DGN .BAT

  31. Benefits of using Geospatial Desktop with Oracle • View and edit your Oracle Spatial database directly • Bringing Geospatial Engineering information into mainstream IT world -> Oracle Standard • Excellent Database Citizen->Oracle reviewed

  32. Benefits of using Geospatial Desktop with Oracle • Easily migrate from DGN to Oracle Spatial->DGN2SDO • Avoid conflict->Pessimistic Locking • Keep data consistent at all time and interact easily with Oracle 10G Topology

  33. Geospatial Server

  34. Product Framework Enterprise Integration Bentley Geospatial Web Publishing Bentley Geospatial Server Bentley Geospatial Industry Applications Bentley Geospatial Desktop Bentley Geospatial Mobile Applications

  35. What is the Bentley Geospatial Server? • Geospatial Server is an Enterprise GIS • Using a unique Federated Information Management approach. • The idea is simple: • Index rather than convert • Find rather than search • Allows managing, indexing, editing, and plotting of : • Structured information, fixed schema • Spatial Database, DGN/XFM, Shapefile, … • Unstructured information, no schema • Raw DGN, DWG, Word, PowerPoint, …

  36. Indexes, Metadata, Settings Architecture Oracle 10g Spatial, Topology SHP, MXD DGN XFM DGN with RDBMS Oracle 10G Bentley Geospatial Server Spatial Indexing/Searching Service Workflow Management Service Spatial Database Service Plotting Service Document Service Clients Applications

  37. Bentley Geospatial Server Bentley Geospatial Industry Applications Bentley Geospatial Desktop Geospatial Server-Oracle Spatial All 2-tier functionality + n-tier… • Live Viewing/Editing • Disconnected Editing (batch extraction/post) • Long transaction • Pessimistic or optimistic • Conflict Resolution • Multi-user editing on same area • Workflow management • Spatial Indexing • Collaboration • Time Component Support • Fully customizable – web services

  38. Geospatial Server - Oracle Spatial • Database Connection Document (Live Viewing/Editing) • LIVE extraction/posting from Oracle • Create once, share many to PW users • Allow editing of database data in a fixed extent • Document integrated in PW for workflow, audit trail, security (ex: hide document from some users), etc • Allows pessimistic short/long transaction

  39. Database Connection DocumentLive Viewing/Editing • What you will see • Creation of live connection document • Bentley Map opening document • Live fetch of spatial data • Lock of spatial data • Edit of spatial data • Post of spatial data

  40. Demo: Creating Information

  41. What Did You Just See? • Creation of live connection document • Bentley Map opening document • Live fetch of spatial data • Lock of spatial data • Edit of spatial data • Post of spatial data

  42. Geospatial Server - Oracle Spatial • Disconnected Database Document • Extraction/Post done in Batch mode • Optimistic/Pessimistic Locking • Workstation or Field editing disconnected from the database

  43. Disconnected Database DocumentDisconnected Viewing/Editing What you will see: • Creation of disconnected database document • Extraction and editing of Oracle Spatial data • Workflows management • Communication in context • Posting of spatial data

  44. What Did You Just See? • Creation of disconnected database document • Extraction and editing of Oracle Spatial data • Workflows management • Communication in context • Posting of spatial data

  45. Multi-user editing Spatial database multi-user editing What you will see: • Multi-user editing in Optimistic Long Transaction, project can last for a very long time without disturbing operations • Geospatial Reconciliation Extension, rare conflicts can be solved • Committing any Project Version to LIVE production data

  46. Demo

  47. What Did You Just See? • How the Geospatial Server can be used for Multi-user editing in Optimistic Long Transaction, conflict resolution, reviewing and committing Oracle versions

  48. Time Component • Track Edits History in the Database • Query back in time • E.g.: show me the census blocks as they were on the Census 2000 • Act on feature now and it reflected in the future • Query in the future • E.g.: show me this planned section of highway as it will be in 2007

  49. Keeping History of changes What you will see: • Query current time • Disconnected Editing of time enable information • Query of edited information back in time

More Related