Data Management in the Multiuser Geodatabase (10.0)

Description

Organizations using ArcGIS Server can deploy a multiuser ArcSDE geodatabase to centrally manage their GIS data, improve its security and integrity, and deliver access and editing capabilities to many users. This course teaches database administrators how to successfully load and manage data in preparation for a multiuser geodatabase implementation. You will learn best practices for designing, interacting with, and maintaining the performance of a multiuser geodatabase and explore multiuser editing workflows and options, including versioning. While this course focuses primarily on the enterprise ArcSDE geodatabase, course concepts apply to both workgroup and enterprise geodatabases.

Who Should Attend

GIS and database administrators who need to implement a workgroup or enterprise ArcSDE geodatabase.

Note: Database administrators who need to install and configure ArcSDE should also enroll in ArcGIS Server Enterprise Configuration and Tuning for Oracle or ArcGIS Server Enterprise Configuration and Tuning for SQL Server, which complement this course.

Learn How To

• Understand the architecture of a multiuser geodatabase.
• Create connections to an ArcSDE geodatabase.
• Set and manage user permissions.
• Create an efficient data storage design to support a multiuser editing workflow.
• Load and manage vector and raster data.
• Apply client optimization techniques.

Esri will provide the following software to use during class:

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

Exploring the geodatabase

• Geodatabase types, behaviors, and options
• Classifying geodatabase data
• Elements of a workgroup and enterprise installation

Geodatabase architecture

• Multitier architecture
• Enterprise ArcSDE geodatabase installation
• Management tools

Creating geodatabase connections

• Connection types, files, and information
• Authentication

Users and permissions

• Access levels
• User roles
• Data permissions

Loading data

• Geodatabase environment settings
• Methods of creating data
• Configuration keywords
• Deleting geodatabase data

Managing vector data

• Feature class and spatial reference properties
• Upgrading data
• Z- and m-values
• Geodatabase field types
• Geometry storage
• DBMS spatial column type
• Table registry
• Query layers and Layers table

Indexes

• Query filters
• Attribute and ArcSDE indexes
• Spatial index types
• Multiple grid sizes
• Modifying the spatial grid index

Managing raster data

• Raster data types
• Schema overview
• Pyramids
• Compression options
• NoData storage
• Color maps
• Raster tiles and statistics
• Raster geodatabase settings

Organizing multiple raster datasets

• Mosaicking options
• Mosaic datasets
• Raster catalogs and raster datasets
• Tips for loading multiple rasters
• Raster attributes

Multiuser editing

• Transaction models
• Nonversioned editing
• Versioned editing
• Geodatabase archiving
• Geodatabase replication

Versioning

• Registering objects as versioned
• Storing versioned edits
• Viewing versions and version differences
• Merging changes and resolving conflicts
• Version permissions
• Move to base option

Associating data

• Database normalization and cardinality
• ArcMap joins and relates
• Geodatabase relationship classes
• ArcSDE spatial views
• Data associations processed by client
• Data associations processed by server

Maintaining performance

• Performance bottlenecks
• Compressing the geodatabase
• Maintaining statistics and rebuilding indexes
• Generalizing data
• Best practices for ArcMap users
• Best practices for data managers

Completion of ArcGIS Desktop II: Tools and Functionality or Learning ArcGIS Desktop or equivalent knowledge is required. Familiarity with basic RDBMS concepts is also required.