Implementing Versioned Workflows in a Multiuser Geodatabase

[#1]

Learn a sound versioning workflow that minimizes disruption to editors, ensures the integrity of your organization's GIS data, and integrates well with existing business workflows. This course explores a variety of versioned editing workflows and examines how versioning decisions impact data accuracy and database performance.

Resources

Lesson 1 – Establishing the multiuser editing environment

• Overview of versioning
• Versioning Types

Lesson 2 – Organizing versions

• Create a traditional version
• Delete a traditional version
• Connect to a traditional version
• Manage traditional versions

Lesson 3 – Edit isolation using delta tables

• Register a dataset as traditional versioned
• The traditional versioning editing process

Lesson 4 – Exploring versioning repository tables

• System tables of a geodatabase in SQL Server
• System tables of a geodatabase in Oracle
• System tables of a geodatabase in PostgreSQL

Lesson 5 – Merging lineages through reconcile and post

• View traditional version changes
• The traditional versioning editing process
• Reconcile and post edits to a traditional version

Lesson 6 – Reviewing conflicts

• Manage traditional version conflicts

Lesson 7 – Migrating edits to the base tables

• Using Python scripting to batch reconcile and post traditional versions
• Recommended traditional version administration workflow

Lesson 8 – Creating two-way replicas

• Distributed data scenarios
• Geodatabase replication fundamentals
• Replication and versioning
• Prepare data for replication
• Create a two-way replica
• Connected replica synchronization
• Synchronization and versioning

Lesson 9 – Creating one-way replicas

• Create a one-way replica
• What is synchronization?

Lesson 10 – Creating check-out replicas

• Create a checkout replica

Lesson 11 – Versioned editing with third-party apps

• What is a versioned view?
• Reading versioned data using SQL in SQL Server
• A quick tour of editing versioned data using SQL

Additional Web Based and Instructor-Led Training

• Deploying and Maintaining a Multiuser Geodatabase:  This course prepares you to successfully create a multiuser geodatabase that stores and manages your organization's authoritative geographic data. Learn about the multiuser geodatabase architecture and apply techniques to efficiently load data, assign user privileges, and maintain performance over time.
  
  
• Distributing Data Using Geodatabase Replication:  This course teaches best practices to plan and implement geodatabase replication to support enterprise editing workflows and data-sharing initiatives. Learn how to protect the integrity and performance of your production database as data is collected and updated to reflect real-world conditions.
  
  
• Managing Geospatial Data in ArcGIS:  This course takes you on an in-depth exploration of the geodatabase, the native data storage format for ArcGIS software. Best practices to create a geodatabase to centrally store and efficiently manage your organization's authoritative geospatial data are covered. You will develop skills needed to configure unique geodatabase features that ensure data integrity and accuracy over time and a thorough understanding of file and enterprise geodatabase capabilities.
  
  
• Archiving Data in a Multiuser Geodatabase:  Archive your GIS data to preserve a record of feature-level changes. View data snapshots at specific points in time and examine how patterns have evolved over time. This course teaches basic geodatabase concepts to archive data stored in a versioned multiuser geodatabase.