Deploying and Maintaining a Multiuser Geodatabase

Description
This course prepares you to successfully create a multiuser geodatabase to store and manage your organization’s geographic data. You will learn about the multiuser geodatabase architecture, configuration options, and techniques to efficiently load data, assign user privileges, and maintain performance over time. Course concepts apply to both enterprise and workgroup geodatabases. During course exercises, you may work with the RDBMS product that is relevant for your organization (Oracle, Microsoft SQL Server, or PostgreSQL).

Who Should Attend
Spatial database administrators and GIS data managers who need to create, configure, and manage a multiuser geodatabase

Goals
After completion of this course you will be able to:
• Configure the multiuser geodatabase for your relational database management system.
• Create a multiuser geodatabase and configure connections to it.
• Efficiently load data into a multiuser geodatabase.
• Configure storage settings to support your organization’s data management workflows.
• Set up user roles and privileges to provide secure data access.
• Apply best practices to maintain high geodatabase performance.

Prerequisites
• Completion of ArcGIS 2: Essential Workflows or equivalent knowledge
• Experience managing a relational database management system

Course Outline

What is a multiuser geodatabase?
• Multi-tier architecture
• Identifying the appropriate software tier
• Multiuser geodatabase components
• Hierarchy of users
• Comparing tools for making a multiuser geodatabase
• Create an enterprise geodatabase
• Explore the repository
• Exercise flow

Connecting to the geodatabase
• RDBMS client software
• Create a connection
• Software version compatibility
• Authentication methods
• Connection files

Loading data into the geodatabase
• Data owner account
• Create the data owner account
• RDBMS considerations
• Geoprocessing environment settings
• Choosing a data-loading tool
• Updating datasets
• Automation
• Use ModelBuilder

Configuring privileges
• Data users
• Creating data users
• Roles
• Manage users
• Defining roles
• Designing roles
• Securing credentials

Managing storage
• Configuration parameters
• Configuration keywords
• Supported spatial types
• DBTUNE table
• Create and update keywords

Maintaining the geodatabase
• Attribute indexes
• Statistics
• Manage attribute indexes and statistics
• Spatial indexes
• The Compress tool
• Scheduling tasks
• Manage performance tasks with Python
• Schema locks
• View and clear locks

Associating data
• Query layers
• Create query layers
• Database views
• Create database views
• Choosing between query layers and database views
• Determining whether to create query layers or database views

Applying the geodatabase workflow
• Geodatabase workflow
• Geodatabase responsibilities
• Geodatabase tasks