1 / 67

Understanding our world.

Understanding our world. 2013 Esri International User Conference July 8–12, 2013 | San Diego, California. Technical Workshop. Editing Versioned Geodatabases : An Introduction. Cheryl Cleghorn Shawn Thorne. Assumptions:. Basic knowledge of relational databases

reece-oneill
Download Presentation

Understanding our world.

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. Understanding our world.

  2. 2013 Esri International User Conference July 8–12, 2013 | San Diego, California Technical Workshop Editing Versioned Geodatabases : An Introduction Cheryl Cleghorn Shawn Thorne

  3. Assumptions: • Basic knowledge of relational databases • Basic knowledge of the Geodatabase data model • Many other sessions that focus on this

  4. Requests: • Please hold questions until Q&A • Please silence smart devices

  5. Session Path • Introduction to the Multi-user Geodatabase • Versioning • Types of Editing • Archiving • Geodatabase Replication • Q & A

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

  7. What is the Geodatabase? • Physical data store • Core ArcGIS data model • Transactional model • COM components

  8. Three Types of Geodatabases

  9. Geodatabase Data Management Approach Simple classes logic DBMS Short transactions Integrity Reliability Flexibility Scalability Extend functionality and data integrity A

  10. Geodatabase Data Management Approach… Editing and data compilation Oops!

  11. Geodatabase Data Management Approach… • Versioning workflows • Long transactions • Distributed data management • Robust, customizable framework

  12. What is a Multi-user Geodatabase? • Also called an ArcSDE Geodatabase • ESRI’s geospatial technology • Unique capabilities: • Many supported DBMSs • Full, open SQL access • Versioning • Replication • Archiving

  13. Multi-user Geodatabase How is ArcSDE technology included in ArcGIS? ArcGIS Geodatabase ArcSDE DBMS Operating system A

  14. Three editions of Multi-user Geodatabase Scale from small, personal systems up to workgroups and very large enterprises

  15. Which Multi-user Geodatabase edition?

  16. Which Multi-user Geodatabase edition?

  17. Which Multi-user Geodatabase edition?

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

  19. Versioning: What is it? • Multi-user Technology

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

  21. Version: • An alternative view of the Geodatabase • Edits independent of other versions Parks

  22. Why Use Versioning? • Multiple Editors • Different Views of the Data • Editing Complex Data (e.g. Geometric Networks) • Replication and Archiving

  23. Analyst Public Public Flood Why Use Versioning?... • Editing with long transactions • Isolate work across multiple sessions • Edits do not impact others • Model what-if scenarios

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

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

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

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

  28. How Versioning Works • ….Register as Versioned Business or Base table

  29. How Versioning Works • Registered as Versioned • Creates Adds and Deletes tables for tracking edits

  30. How Versioning Works • Adding Features • Record added to the Adds Table • Version will be referenced (SDE_State_ID Field)

  31. How Versioning Works • Deleting Features • Record added to Deletes Table • Version will be referenced (Deleted_At field)

  32. How Versioning Works • Updating Features • Record added to both Adds and Deletes table • Version will be referenced (SDE_State_ID Field)

  33. How Versioning Works Versioned feature classes: • Base Tables, Adds Tables & Deletes Tables ArcGIS Base Tables Adds Tables + Deletes Tables A

  34. Versioned Editing Demo

  35. Versioned Editing – Reconcile and Post • How can versions be merged?

  36. Versioned Editing – Reconcile • Incorporate changes from the target version

  37. Reconcile and Conflicts No locks on edit • Data overwritten? • Conflict detection Conflict Resolution Dialog A

  38. Versioned Editing – Post • Incorporate with target version • After a post versions are identical

  39. Reconcile & Post Demo

  40. Non-Versioned Editing • Directly editing the base tables • Benefits IT integration • Database integrity rules • Simple data only (Points, Lines, Polygons) Base Tables Adds Tables + Deletes Tables

  41. But I want both… Base Tables Base Tables Adds Tables Adds Tables Deletes Tables Deletes Tables Non-versioned Versioned

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

  43. SQL Editing • Attributes • Geometry • Spatial Types • Non-ESRI Client • SQL access to geometries • Versions • No geodatabase functionality

  44. 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-ESRI clients? > Multi-editor requirement?

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

  46. Time Geodatabase Archiving: What is it? • Versioned edit history • Default version only • Temporal queries

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

  48. Base Table Archive Table F T Delta Tables Adds Deletes Geodatabase Archiving: How it works • Save edits on the Default version • changes added to archive table A

  49. Geodatabase Archiving: usage • Two query methods • specific date and time • historical marker A

  50. Geodatabase Archiving Demo

More Related