Managing Editing Workflows in a Multiuser Geodatabase (10.0)

GIS data managers and experienced ArcGIS users who need to manage their editing environment in a multiuser geodatabase.

Prerequisites

• Completion of ArcGIS Desktop II: Tools and Functionality or Learning ArcGIS Desktop or equivalent knowledge is required.
• Familiarity with ArcSDE architecture and working on a Windows platform is also required.

• Design and implement various multiuser editing workflows.
• Edit data in a nonversioned and versioned environment.
• Manage multiple geodatabase versions.
• Use geodatabase archiving to track changes to data over time.
• Use geodatabase replication to support data collection, updates, and sharing.
• Create and use multiversioned views.
• Monitor versioned geodatabase performance.
• Implement techniques to maintain performance.

Download table of contents [PDF 131kb]

Overview of editing workflow options

• Short and long transactions
• Nonversioned editing
• Versioned editing
• Workflow considerations and strategies

Nonversioned editing

• Concurrency issues
• DBMS locking
• DBMS blocking issues
• Workflow considerations
• Implementing DBMS integrity

Versioned editing

• Versioning workflow
• Tracking and merging changes
• How changes are stored
• Registering feature classes as versioned

Versioning system tables

• System table examples
• Representing different versions

State tree - single editor

• States and the state tree
• Single-user editing examples

State tree - multiple editors

• Autoreconcile options
• Refreshing versions
• State tree branching
• Multiuser editing examples

Versions

• Viewing version differences
• Merging versions
• Auto versus explicit reconcile
• Reconcile and the state tree
• Describing the post action
• Deleting versions

Conflicts

• Conflict detection options
• Conflict resolution
• Reviewing conflicts

Version workflow

• Version scenarios and considerations
• Workflow examples
• Developing version hierarchy
• QA/QC, security, design, and editing stages
• Potential reconcile and post issues

Move to base editing

• Architecture of move to base
• How to register with move to base
• Workflow considerations
• Conflict detection
• Integrating with non-Esri applications

Geodatabase archiving

• Preserving data changes
• Architecture of geodatabase archiving
• Archiving time
• Answering common historical questions
• Workflow benefits and considerations
• Disabling archiving

Geodatabase replication

• Workflow requirements
• Understanding checkout/check-in, one-way, and two-way replication
• Creating replicas
• Synchronizing edits

Multiversioned views

• Non-Esri client access
• SQL access
• Creating, querying, and editing a multiversioned view
• Workflow considerations

Bulk editing and loading

• Understanding bulk data changes
• Workflow recommendations
• Application considerations

Management and performance

• Factors that decrease performance
• Maintaining nonversioned and versioned performance
• Compressing the database
• Maintaining statistics and indexes

Esri will provide the following software to use during class:

• ArcGIS 10.0 for Desktop (ArcEditor or ArcInfo)
• ArcGIS 10.0 for Server Enterprise (Basic, Standard, or Advanced)
• Microsoft SQL Server Standard 2008
• Microsoft SQL Server Express 2008