editing versioned geodatabases an introduction n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Editing Versioned Geodatabases : An Introduction PowerPoint Presentation
Download Presentation
Editing Versioned Geodatabases : An Introduction

play fullscreen
1 / 60

Editing Versioned Geodatabases : An Introduction

85 Views Download Presentation
Download Presentation

Editing Versioned Geodatabases : An Introduction

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Editing Versioned Geodatabases : An Introduction Cheryl Cleghorn and Shawn Thorne

  2. Assumptions: • Basic knowledge of relational databases • Basic knowledge of the Geodatabase data model • Other sessions that focus on the geodatabase data model Editing Versioned Geodatabases : An Introduction

  3. Requests: • Please hold questions until Q&A • Please silence smart devices Editing Versioned Geodatabases : An Introduction

  4. Session Path • Introduction to the Multi-user Geodatabase • Versioning • Types of Editing • Archiving • Geodatabase Replication • Q & A Editing Versioned Geodatabases : An Introduction

  5. Session Path • Introduction to the Multi-user Geodatabase • What is the Geodatabase? • The Geodatabase Management Approach • Different types of Geodatabases • The Multi-user Geodatabase • Versioning • Types of Editing • Archiving • Geodatabase Replication • Q & A Editing Versioned Geodatabases : An Introduction

  6. What is the Geodatabase? • Physical data store • Core ArcGIS data model • Transactional model • COM components Editing Versioned Geodatabases : An Introduction

  7. Three Types of Geodatabases Editing Versioned Geodatabases : An Introduction

  8. Mulit-user Geodatabase Data Management Approach Simple classes logic DBMS Short transactions Integrity Reliability Flexibility Scalability Extend functionality and data integrity Editing Versioned Geodatabases : An Introduction A

  9. Multi-user Geodatabase Data Management Approach… Editing and data compilation Oops! Editing Versioned Geodatabases : An Introduction

  10. Multi-user Geodatabase Data Management Approach… • Versioning workflows • Long transactions • Distributed data management • Robust, customizable framework Editing Versioned Geodatabases : An Introduction

  11. What is a Multi-user Geodatabase? • Previously called an ArcSDE Geodatabase • ESRI’s geospatial technology • Unique capabilities: • Many supported DBMSs • Full, open SQL access • Versioning • Archiving • Replication Editing Versioned Geodatabases : An Introduction

  12. Multi-user Geodatabase How is ArcSDE technology included in ArcGIS? ArcGIS Geodatabase ArcSDE technology DBMS Operating system Editing Versioned Geodatabases : An Introduction A

  13. Three editions of Multi-user Geodatabase • Same functionalities Scales from small, personal systems up to workgroups and very large enterprises Editing Versioned Geodatabases : An Introduction

  14. Which Multi-user Geodatabase edition? Editing Versioned Geodatabases : An Introduction

  15. Which Multi-user Geodatabase edition? Editing Versioned Geodatabases : An Introduction

  16. Which Multi-user Geodatabase edition? Editing Versioned Geodatabases : An Introduction

  17. Session Path • Introduction to the Multi-user Geodatabases • Versioning • What is it? • Why Use Versioning? • Types of Editing • Archiving • Geodatabase Replication • Q & A Editing Versioned Geodatabases : An Introduction

  18. Versioning: What is it? • Multi-user Technology Editing Versioned Geodatabases : An Introduction

  19. Version: • An alternative view of the Geodatabase • Edits independent of other versions Parks Editing Versioned Geodatabases : An Introduction

  20. Version: • An alternative view of the Geodatabase • Edits independent of other versions Parks Editing Versioned Geodatabases : An Introduction

  21. Why Use Versioning? • Multiple Editors • Different Views of the Data • Editing Complex Data (e.g. Geometric Networks) • Replication Editing Versioned Geodatabases : An Introduction

  22. Why Use Versioning?... • Editing with long transactions • Isolate work across multiple sessions • Edits do not impact others • Model what-if scenarios Editing Versioned Geodatabases : An Introduction

  23. Session Path • Introduction to the Multi-user Geodatabase • Versioning • Types of Multi-user Geodatabase Editing • Versioned Editing • Non-Versioned Editing • Editing through SQL • Archiving • Geodatabase Replication • Q & A Editing Versioned Geodatabases : An Introduction

  24. Farmland Residential Editing Multi-user Geodatabases • Short Transactions • E.g., ATM transactions, Library records, Timecards • Long Transactions • E.g., Parcel updates • General geographic editing • GIS editors need both short and long transactions Editing Versioned Geodatabases : An Introduction

  25. Three ways to edit Multi-user Geodatabases • Versioned Editing (Long Transactions) • Non-Versioned Editing (Short Transactions) • Editing through SQL (Short Transactions) Editing Versioned Geodatabases : An Introduction

  26. Versioned Editing • Versioned Edit Sessions • Through a version • Concurrent editing • Long transactions (hours/days) • Undo/Redo DEFAULT Design Work Order Editing Versioned Geodatabases : An Introduction

  27. How Versioning Works • ….Register as Versioned Business or Base table Editing Versioned Geodatabases : An Introduction

  28. How Versioning Works • Registered as Versioned • Creates Adds and Deletes tables for tracking edits Editing Versioned Geodatabases : An Introduction

  29. How Versioning Works • Adding Features • Record added to the Adds Table • Version will be referenced (SDE_State_ID Field) Editing Versioned Geodatabases : An Introduction

  30. How Versioning Works • Deleting Features • Record added to Deletes Table • Version will be referenced (Deleted_At field) Editing Versioned Geodatabases : An Introduction

  31. How Versioning Works • Updating Features • Record added to both Adds and Deletes table • Version will be referenced (SDE_State_ID Field) Editing Versioned Geodatabases : An Introduction

  32. How Versioning Works • Versioned feature classes: • Base Tables, Adds Tables & Deletes Tables ArcGIS Client Base Tables Adds Tables + Deletes Tables Editing Versioned Geodatabases : An Introduction A

  33. Versioned Editing Demo Shawn Thorne Editing Versioned Geodatabases : An Introduction

  34. Versioned Editing – Reconcile and Post • How can versions be consolidated? Editing Versioned Geodatabases : An Introduction

  35. Versioned Editing – Reconcile • Incorporate changes from the target version No locks on edit Editing Versioned Geodatabases : An Introduction

  36. Reconcile and Conflicts • No locks on edit • Data overwritten? • Conflict detection • Conflict Resolution Dialog Editing Versioned Geodatabases : An Introduction A

  37. Versioned Editing – Post • Incorporate with target version • After a post versions are identical Editing Versioned Geodatabases : An Introduction

  38. Reconcile & Post Demo Shawn Thorne Editing Versioned Geodatabases : An Introduction

  39. Non-Versioned Editing • Directly editing the base tables • Benefits IT integration • Database integrity rules • Simple data only (Points, Lines, Polygons) • No Undo/Redo Base Tables Adds Tables + Deletes Tables Editing Versioned Geodatabases : An Introduction

  40. But I want both… Base Tables Base Tables Adds Tables Adds Tables Deletes Tables Deletes Tables Non-versioned Versioned Editing Versioned Geodatabases : An Introduction

  41. Versioned Editing - Move to Base Option • Hybrid • versioned and non-versioned • Simple data only • Points, lines, polygons, annotation, relationship classes IT integration Database constraints Editing Versioned Geodatabases : An Introduction

  42. SQL Editing • Attributes • Geometry • Spatial Types • Non-ArcGIS Client • SQL access to geometries • Versions • No geodatabase functionality Editing Versioned Geodatabases : An Introduction

  43. Multi-user Geodatabase Editing Summary • Three ways to edit data • Versioned Editing • Non-Versioned Editing • SQL Editing • Which one do I use? • Depends: >Short vs. Long Transactions? >non-ArcGIS clients? > Multi-editor requirement? Editing Versioned Geodatabases : An Introduction

  44. Session Path • Introduction to the Multi-user Geodatabases • Versioning • Types of Editing • Archiving • What is it? • How is it used? • Geodatabase Replication • Q & A Editing Versioned Geodatabases : An Introduction

  45. Time Geodatabase Archiving: What is it? • Edit history • Versioned data • Non-versioned data • Temporal queries Editing Versioned Geodatabases : An Introduction

  46. F T Delta Tables Adds Deletes Archive Table Versioned Archiving: How it works • Extends versioning • Register as Versioned • Enable Archiving Base Table Default version A

  47. Archive Table F T Delta Tables Adds Deletes Versioned Archiving: How it works • Save edits on the Default version • changes added to archive table Base Table Editing Versioned Geodatabases : An Introduction A

  48. Non-versioned Archiving: How it works Edits Business Table F T Enable archiving Current Data View Business Table Editing Versioned Geodatabases : An Introduction

  49. Geodatabase Archiving: usage • Two query methods • specific date and time • historical marker Editing Versioned Geodatabases : An Introduction A

  50. Geodatabase Archiving Demo Shawn Thorne Editing Versioned Geodatabases : An Introduction