1 / 60

Editing Versioned Geodatabases : An Introduction

Editing Versioned Geodatabases : An Introduction. Cheryl Cleghorn and Shawn Thorne. Assumptions:. Basic knowledge of relational databases Basic knowledge of the Geodatabase data model Other sessions that focus on the geodatabase data model. Requests:.

ormand
Download Presentation

Editing Versioned Geodatabases : An Introduction

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

More Related