Agenda

1. Integrating Oracle 10g Workflows via the Geospatial Enterprise Oracle ConnectorFrancois ValoisGeospatial Product Manager

2. Agenda • Bentley Support of Oracle Spatial • What is the Oracle Connector? • Oracle Connector Top Features and Benefits • Examples of use cases • What’s coming in Bentley Support of Oracle?

3. 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 Geospatial Server • Bentley Geo Web Publisher • Bentley Cadastre • Bentley Geospatial Industry Applications • Oracle is the interoperability standard

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

5. Interoperability with Oracle Spatial

6. Oracle Version Support • Support: • Oracle Locator and Spatial • Support 9i (9.2.0.5 and +) • Support 10g R1 and R2 • Oracle Express Edition

7. What’s Oracle Locator? • All geometry types • Points, lines, polygons • 2D, 3D, 4D • All indexing methods • Rtrees, Quadtrees (fixed or hybrid) • All spatial queries • Inside, touch, overlap, … • Proximity searches • within distance, nearest neighbor • Distance calculations • Multiple projections Base Features Included with Oracle Database Express, Standard Edition and Enterprise Edition

8. What’s Oracle Spatial? • Locator plus : • Geometry operations • Spatial aggregates • Linear referencing • Coordinate system transformation • User-defined coordinate systems • Network Management • Topology • Raster integration • Geocoder • Spatial Data Mining Advanced features An option of Oracle Enterprise Edition Large data volumes, high user population Complex queries, Advanced manipulations.

9. What is the Oracle Connector? • Server technology allowing connection to Oracle • Marketed in two different ways • As a component of the Geospatial Server product • As a addition to ProjectWise and Geospatial Management

10. Oracle Connector As part of the Geospatial Server

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

12. 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, …

13. The Geospatial Federated System Way • Federated System allows dealing with a wider range of information help considering all aspects of a project

14. Indexes, Metadata, Settings Oracle Connector- Geospatial Server 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 (Oracle Connector) Plotting Service Document Service Clients Applications

15. Oracle Connector As an additional module to ProjectWise

16. Oracle Connector-Oracle Spatial • Live Viewing/Editing • Disconnected Editing (batch extraction/post) • Geometry and topology support • Text, Feature-Linked text • Coded Domains • Loading Tools (DGN2SDO) • Long transaction • Pessimistic • Optimistic • Multi-user editing on same area • Conflict Resolution • Time Component Support • Oracle Valid Time • Oracle History • Fully customizable – web services Bentley Geospatial Server Bentley Geospatial Industry Applications Bentley Geospatial Desktop

17. Oracle Connector - Functionality • Oracle Spatial Geometry • Point, Linestring, Polygon, Polygon w/ Holes, Arcs, Circles, Multipoint, Multilinestring, Multipolygon • Tabular Attributes • Oracle field types supported • Coordinate systems support (On-the-fly Transformation) • All Oracle coordinate systems supported and more (5000+) • Oracle workspace manager • Leveraged Oracle Standard versioning system

18. Oracle Connector - Functionality • Oracle views • Support of database view • Ex: To hide Social Security Number information from data editor • Simple Text • Simple text support based on point • Feature-Linked Text • Coded Domains • Restrict possible input values when editing • Reconciliation Extension to MicroStation/GeoGraphics • Allow version (Oracle Workspace) merging • Conflict resolution • Version content visualization

19. Version Management Multiple copies of data with a “copy-on-write” approach Permanent copies and versioned copies in same database Advantages Amount of data copied optimal Conflicts detected as they occur Collaborative transactions supported Allows pessimistic and optimistic transaction What’s Oracle Workspace Manager? Long transactions and multi-versions Live Data V2 V1 V3

20. Transaction Type • Short Transaction • Database Editing Session lasting for a short time, i.e.: within one MicroStation Session • E.g.: split a parcel or open a valve • Locking: Only pessimistic • Pros: less overhead database side • Cons: single user editing in same area, cannot work on same project for long time

21. Transaction Type • Long Transaction • Database Editing Session lasting for a long time, i.e.: across multiple MicroStation Session • E.g.: creating new subdivision, engineering workflow • Locking: Pessimistic or Optimistic • Pros: Allows working on more complex projects requiring intervention multiple people • Cons: database side overhead

22. Locking Type • Pessimistic Locking • Database Rows are locked for the duration of the transaction • Pros: Avoid conflicts • Cons: No possibility for different alternative

23. Locking Type • Optimistic Locking • Database Rows are NEVER locked for the duration of the transaction • Pros: Allows evaluation of multiple alternatives, allows projects and maintenance to co-exist very well • Cons: Possibility of conflicts

24. Live Database Document • LIVE extraction/posting from Oracle • Create connection once, share to many users • Open a window into the spatial database • Allow editing of database data in a fixed extent or access to full extent • Allows pessimistic short/long transaction

25. Live Database Document • Document integrated in workflow, messaging, audit trail, security, etc • Can be referenced by other projects (always up to date reference) • Requires Constant Database Connection • Ideal for controlled Live Editing Scenario

26. Live Database Document • 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 • Workflow and communication in context

27. Demo: Creating Information

28. 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 • Workflow and communication in context

29. Disconnected Database Document • Batch Disconnected extraction/posting from Oracle • Create document once re-extraction can be commanded • Allows pessimistic/optimistic long transaction • Document integrated in workflow, messaging, audit trail, security, etc

30. Disconnected Database Document • Can be referenced by other projects (snap-shot reference) • Do not requires Constant Database Connection • Ideal for controlled Disconnected Editing Scenario • Field editing • Dispatching work to Sub-contractor

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

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

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

35. Demo

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

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

38. Oracle Temporal Model • Oracle supports two modes • Valid time • Allows modeling real world dates • Allows management of past and future • Based on WM_PERIOD field • Supported for Geometry only • History • Allows to model database transaction history • Supported for Geometry and Topology • Both are based on Workspace Manager Technology

39. Valid Time • Queries • Any SQL Client see only the current data • SQL client has to take specific actions to see past or future • All SQL Clients are bound by valid time

40. History • Keep a history of changes to data • The history option lets you timestamp changes • Save of all changes or only most recent changes • GotoDate procedure allows to go back in time • Works with topology

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

42. Demo

43. What Did You Just See? • Query current time • Disconnected Editing of time enable information • Query of edited information back in time

44. Oracle Spatial Topology Model • Persistent topology model in a standard RDBMS • Explicit spatial relationship existing among features • Based on topological primitives: • Nodes, Edges, Faces • Each topological primitive is stored once in the database • Each topological primitive can be associated with one or more features. For example: • An edge may be associated with two adjacent county boundaries • An edge may be associated with a land parcel and a river • Shared Editing is easier • Analysis is done using topological algorithms, using persistent relationships

45. Topology primitives Topology Features Features/Topology Primitives Allow finding relationships between features->Spatial Query Relationships Between Nodes/Edges/Faces Relationships Between Primitives and Feature

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

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

48. Open from Oracle Spatial Topology What you will see: • Open Oracle Spatial Topology features in current DGN • View the topological features • Show the hidden topology model • Nodes, Edges, Faces

49. Demo

50. What Did You Just See? • Open Oracle Spatial Topology features in current DGN • View the topological features • Show the hidden topology model • Nodes, Edges, Faces