Deploying and Maintaining a Multiuser Geodatabase Class Resources

RudyProsser

These are references and resources for the Esri instructor-led course Deploying and Maintaining a Multiuser Geodatabase. All references are for working with multiuser geodatabases using ArcGIS 10.5 / 10.6. 

 

---

 

General References:

 

GeoNet Resources

Deploying and Maintaining a Multiuser Geodatabase (10.6)

• Course Description
• Course Resources
• Q&A

 

ArcGIS Help (All geodatabase help is found in Desktop Help)

 

Geodata

• Data management
• Geodatabase
• Geodatabase administration

 

RDBMS

• Geodatabases in Oracle
• Geodatabases in PostgreSQL
• Geodatabases in SQL Server

 

---

 

Course Topics & References:

Note: This section is a work-in-progress. For a current version see the Course Resources on GeoNet.

1: What is a multiuser geodatabase?

   Administering Geodatabases

• Geodatabase administration
• Geodatabase administration terminology
• Migrate from ArcSDE administration commands to ArcGIS Desktop
• Geodatabase storage in a relational database
• How are geodatabases stored in a DBMS?
• Geodatabases in SQL Server
  • Setting up a geodatabase in SQL Server
  • A comparison of geodatabase owners in SQL Server
  • System tables of a geodatabase in SQL Server
  • The geodatabase administrator in SQL Server
• Geodatabases in Oracle
  • Setting up a geodatabase in Oracle
  • System tables of a geodatabase in Oracle
  • The geodatabase administrator in Oracle
• Geodatabases in PostgreSQL
  • Setting up a geodatabase in PostgreSQL in Windows or Linux
  • System tables of a geodatabase in PostgreSQL

Other resources

• Product information: Data Management
• Enterprise Geodatabase 101 [from ArcUser, Winter, 2008] An older article but with some good info.

 

Geodatabase Administration toolset

• An overview of the Geodatabase Administration toolset
• Create Enterprise Geodatabase
• Enable Enterprise Geodatabase

2: Connecting to the geodatabase

• Database connections
  • Database clients
  • Database connections in ArcMap
• Geodatabase connections
  • Connect to SQL Server
  • Connect to SQL Server from ArcGIS
  • Connecting to Oracle
  • Connect to Oracle from ArcGIS
  • Connecting to PostgreSQL
  • Connect to PostgreSQL from ArcGIS

 

3: Loading data into the geodatabase

• Geodatabase Administration tools
  • Create Database Users (Data Management)
• Data management tools
  • Truncate Table (Data Management)
  • Append (Data Management)
• Loading data
  • Adding datasets and other geodatabase elements
  • Loading data
  • Conversion tools – An overview of the Conversion toolbox
  • Simple Data Loader – Loading data in the Catalog tree
  • Object Loader – Loading data in ArcMap
  • Append tool – Append (Data Management)
• Geoprocessing environment settings
  • What is a geoprocessing environment setting?
• Creating custom tools
  • A quick tour of creating custom tools

 

4: Configuring permissions

• User administration
  • SQL Server
    • Add logins and users to SQL Server
    • Privileges for geodatabases in SQL Server
    • Granting and revoking privileges on datasets
    • Managing connections in Sql Server
  • Oracle
    • Add logins and users to Oracle
    • Privileges for geodatabases in Oracle
    • Granting and revoking privileges on datasets
    • Managing connections in Oracle
  • PostgreSQL
    • Add login roles to PostgreSQL
    • Privileges for geodatabases in PostgreSQL
    • Granting and revoking privileges on datasets
    • Managing connections in PostgreSQL
• Tools
  • Create Role (Data Management)
  • Create Database User (Data Management)
  • Change Privileges (Data Management)

5: Managing storage

• Configuration keywords
  • What are configuration keywords?
  • Configuration keywords for enterprise geodatabases
• DBTUNE table
  • SQL Server
    • SQL Server DBTUNE configuration parameters
    • Altering the contents of the SDE_dbtune table
  • Oracle
    • Oracle DBTUNE configuration parameters
    • Altering the contents of the SDE_dbtune table
  • PostgreSQL
    • PostgreSQL DBTUNE configuration parameters
    • Altering configuration keywords
• Spatial data types
  • Spatial types in databases
  • Geodatabases in Microsoft SQL Server (folder)
    • SQL Server data types supported in ArcGIS
    • SQL Server spatial types and ArcGIS
  • Geodatabases in Oracle (folder)
    • Oracle data types supported in ArcGIS
    • What is the ST_GEOMETRY storage type?
    • ST_GEOMETRY storage in Oracle
    • SDO_GEOMETRY and ArcGIS
  • Geodatabases in PostgreSQL (folder)
    • PostgreSQL data types supported in ArcGIS
    • What is the ST_GEOMETRY storage type?
    • ST_GEOMETRY storage in PostgreSQL
• Migrating storage
  • SQL Server - Data migration from one storage type to another
  • Oracle - Data migration from one storage type to another
  • PostgreSQL - Data migration from one storage type to another
  • Migrate Storage (Data Management)
• Altering configuration
  • Server_Config system table (mostly legacy)
  • Geodatabase Log File Tables

6: Maintaining the geodatabase

• Geodatabase maintenance (RDBMS specific links)
  • Maintenance overview: Sql Server | Oracle | PostgreSQL
  • Backups: Sql Server | Oracle | PostgreSQL
  • Update database statistics: Sql Server | Oracle | PostgreSQL
  • Rebuild system table indexes: Sql Server | Oracle | PostgreSQL
  • Versioning administration (reconcile, post, compress): Sql Server | Oracle | PostgreSQL
  • Upgrade geodatabase: Sql Server | Oracle | PostgreSQL
• Administering enterprise geodatabase using ArcGIS Desktop
  • Updating statistics on a dataset using the Analyze Datasets tool
  • Rebuild dataset indexes using the Rebuild Indexes tool
  • Compress a versioned geodatabase
• Attribute indexes
  • Creating attribute indexes
• Managing indexes and statistics (Data Management tools)
  • Analyze Datasets
  • Analyze
  • Add Attribute Index
  • Remove Attribute Index
  • Add Spatial Index
  • Remove Spatial Index
  • Rebuild Indexes
• Spatial Indexes
  • An overview of spatial indexes in the geodatabase
  • ArcGIS and Microsoft spatial types
  • Spatial indexes and ST_Geometry
• RDBMS specific
  • SQL Server (Microsoft links)
    • Spatial indexes overview
    • Create, modify, and drop spatial indexes
    • Statistics Includes concepts, when to create, and when to update

 

• Compress
  • The compress operation and geodatabases
  • Compress a versioned geodatabase
  • Geodatabase compression: Sql Server | Oracle | PostgreSQL
  • Compress (Data management)
• Locks
  • Schema locking
  • Manage connections : Sql Server | Oracle | PostgreSQL
  • Prevent geodatabase connections : Sql Server | Oracle | PostgreSQL
  • Geodatabase locks : Sql Server | Oracle | PostgreSQL
  • Managing geodatabase locks : Sql Server | Oracle | PostgreSQL
  • Managing geodatabase locks : Sql Server | Oracle | PostgreSQL
• Locks during non-versioned editing
  • Concurrency and locking

 

7: Associating data

• Database views
  • Create a database view in ArcGIS for Desktop
  • Views in an enterprise geodatabase: Sql Server | Oracle | PostgreSQL
  • Create Database View (Data Management)
  • Make Table View (Data Management)
• Query layers
  • What is a query layer? (folder)
  • Creating a query layer
  • Make Query Layer (Data Management)
  • Make Query Table (Data Management)
• SQL
  • Joins (SQL)
  • SQL JOIN and different types of JOINs
  • W3schools SQL tutorial

 

8: Geodatabase workflow

 

---

Additional Resources:

 

Essential Esri web sites

Esri.com – Esri’s primary website. Provides product information plus links to training, services and support.

Training – Esri Training gateway for instructor-led and virtual training

Esri blogs – Esri InsiderArcGIS

ArcGIS.com

Esri Support – Esri's online support center

GIS Dictionary

ArcGIS Ideas

GeoNet – The Esri Community

Esri Training

Discussions Lobby

Solutions

Marketplace

 

Learn ArcGIS – Self-study learning about GIS through hands-on projects.

Trust ArcGIS – resource for security, privacy, and compliance information.

ArcGIS 10.4

 

ArcGIS for Desktop

Home

Help

Product information

Functionality matrix

System requirements – ArcGIS for Desktop  ArcGIS Pro

Install guides – ArcGIS for Desktop  ArcGIS Pro

 

ArcGIS 10.4 for Server

Home

Help

Product information

Functionality matrix – ArcGIS for Server functionality by license level

System Requirements – Windows  Linux

Install guides – Windows  Linux

 

---

Recommended Training/Follow-on Classes

On geodatabases

Esri Training > Instructor led

Building Geodatabases

Deploying and Maintaining a Multiuser Geodatabase

Implementing Versioned Workflows in a Multiuser Geodatabase

Distributing Data Using Geodatabase Replication

 

Esri Training > Web courses

Getting Started with the Geodatabase (3 hrs)

Versioned Editing Workflows for the Multiuser Geodatabase (1 hr Training seminar)

Archiving Data in a Multiuser Geodatabase (2 hrs)