Configuring and Managing the Multiuser Geodatabase Course Resources

[#1]

Note: This is for the ArcGIS 10.2 version of the Configuring and Managing the Multiuser Geodatabase course.

Esri web pages

• Esri.com – Esri’s primary web site
  • Training – Esri Training gateway for instructor-led and virtual training
• ArcGIS Resources – ArcGIS Help and software resources
  • ArcGIS Help
    • Current version
    • Previous versions
• Esri Support – Esri’s online support center
  • GIS Dictionary
• GeoNet
• ArcGIS Online
• ArcGIS Blogs

Geodatabase

• Geodatabase / Geodata Community
• Geodata in ArcGIS 10.2 Help
• Geodata in ArcGIS 10.1 Help

Essential readings about the geodatabase

• What is a geodatabase?
• The architecture of a geodatabase
• A quick tour of the geodatabase
• Types of geodatabases
• Building a geodatabase tutorial - A multi-lesson tutorial on organizing, importing, and creating geodatabase objects. Requires you to install the ArcGIS for Desktop tutorial data.

Enterprise geodatabases

• Enterprise Geodatabase 101 - A review of design and key features for GIS managers and database admin...
• Geodatabase product information
• Multiuser geodatabase
• Multiuser functionality
• Storage in an RDBMS

Geodatabase Tools & Utilities

X-Ray for ArcCatalog - add-in for ArcCatalog used to develop, refine and document your geodatabase designs

• X-Ray for ArcCatalog (ArcGIS 10.2)
• X-Ray for ArcCatalog (ArcGIS 10.1)
• X-Ray for ArcCatalog (ArcGIS 10.0)

PerfQAnalyzer – utility for capturing render and edit times.

1. Calibrating ArcGIS Performance with PerfQAnalyzer: New Build Available for Download – Blog includes links to download the tool.

ArcGIS Diagrammer - a productivity tool for GIS professionals to create, edit or analyze geodatabase schema

• ArcGIS Diagrammer for 10.2
• ArcGIS Diagrammer for 10.1
• Geodatabase Diagrammer for 10x

Geodatabase design – For more information on geodatabase design, see the ArcGIS 10.1 Help section Designing a geodatabase (Help > Geodata > Geodatabases > Designing a geodatabase)

     Esri Press books on geodatabase design

• Modeling Our World, 2^nd ed: The Esri Guide to Geodatabase Concepts
• Designing Geodatabases: Case Studies in GIS Data Modeling
• Designing Geodatabases for Transportation
• Thinking About GIS: Geographic Information System Planning for Managers, 4^th ed. Roger Tomlinson

     Other books

• Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, 3^rd ed by Michael Hernandez. It’s also available on Google Books here.

Data-loading tools - See the following ArcGIS Desktop Help articles:

• Conversion tools – See An overview of the Conversion toolbox
• Simple Data Loader – see Loading data in the Catalog tree
• Object Loader – see About loading data in ArcMap, Adding the Load Objects command to ArcMap, and Loading data with the Load Objects command
• Append tool – see Append (Data Management)

Versioning – Versioning is the primary editing workflow in a multi-user geodatabase, allow multiple editors to work collaboratively or in isolation.

• Versioning 101
• Working with versioned data [book] in the ArcGIS 10.1 Help
• Version scenarios
• Managing geodatabase versions
• Versioning Workflows - Esri White Paper - April 20, 2004

ArcGIS Functionality Matrixes - Desktop and server functionality by license level

• ArcGIS for Desktop
• ArcGIS for Server

Geodatabase repository schema – Detailed listings of the geodatabase system tables found in an enterprise geodatabase are available in ArcGIS Help articles for each supported RDBMS: SQL Server, Oracle, PostgreSQL. Object model diagrams of each geodatabase are available in the Documentation folder of the ArcGIS for Desktop install (C:\Program Files (x86)\ArcGIS\Desktop10.1\Documentation): SS_ for SQL Server, O_ for Oracle, and pgsql_ for PostgreSQL.

Course Topics and References:

1. Using the geodatabase

• Types of geodatabases
• A comparison of geodatabase types
• Essential readings about the geodatabase

2. What is ArcSDE?

• A quick tour of administering geodatabases
• Essential geodatabase administration vocabulary
• A quick tour of administering ArcSDE geodatabases with ArcGIS for Desktop
• Storage in a Relational Database Management System (RDBMS) [from Geodatabase product information]
• Enterprise Geodatabase 101 [from ArcUser, Winter, 2008]

     Geodatabase Repository Schema

• SQL Server
• Oracle
• PostgreSQL

3. Connecting to the geodatabase

• Database connections in ArcGIS for Desktop

     Direct connections

• Setting up a connection to SQL Server
• Setting up a connection to Oracle
• Setting up a connection to PostgreSQL

    Application server connections

• SQL Server
• Oracle
• PostgreSQL

     ArcSDE application server installation guide

• SQL Server
• Oracle
• PostgreSQL

     Deprecation plans

• KB 41175: FAQ What are the deprecation plans for ArcGIS 10.1 and the upcoming release of ArcGIS 10.2...
• Deprecation Plan for ArcGIS 10.1 and ArcGIS 10.2

4. Loading data into the geodatabase

• Workflow strategies for loading data
• User privileges

     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 (folder)
• Loading data (folder)
• Conversion tools – An overview of the Conversion toolbox
• Simple Data Loader – Loading data in the Catalog tree
• Object Loader – Loading data in ArcMap (folder)
• Append tool – Append (Data Management)

5. Managing storage

• Configuration keywords in the geodatabase
• Configuration keywords for ArcSDE geodatabases

     DBTUNE in

• SQL Server
• Oracle
• PostgreSQL

6. Spatial types

     ArcSDE compressed binary storage

• SQL Server
• Oracle

     Spatial types

• SQL Server - ArcGIS and Microsoft spatial types
• Oracle – What is the ST_GEOMETRY storage type? What is Oracle Spatial?
• PostgreSQL - What is the ST_GEOMETRY storage type? What is the PostGIS geometry type?

     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)

7.Configuring permissions

• User privileges

     User administration

• Adding and administrating users in SQL Server (folder)
• What are user privileges?
• User privileges for geodatabase in SQL Server
• Granting and revoking privileges on datasets
• Adding and administrating users in Oracle (folder)
• What are user privileges?
• User privileges for geodatabase in Oracle
• Granting and revoking privileges on datasets
• Adding and administrating users in PostgreSQL (folder)
• What are user privileges?
• User privileges for geodatabase in PostgreSQL
• Granting and revoking privileges on datasets

8. Associating data

     Database views

• Using views in SQL Server (folder)
• Using views in Oracle (folder)
• Using views in PostgreSQL (folder)
• Create Database View (Data Management)
• Make Table View (Data Management)

     Query layers

• Adding and working with query layers (folder)
• Make Query Layer (Data Management)
• Make Query Table (Data Management)
• Support Services Blog > The Evolution of Query Layers

     SQL

• Joins (SQL)
• SQL JOIN and different types of JOINs

9. Managing the geodatabase

• Updating statistics on a dataset using the Analyze Datasets tool
• Updating statistics on a dataset using Analyze
• Using the Rebuild Indexes tool to rebuild indexes on geodatabase system tables
• Rebuilding indexes on geodatabase system tables using a Python script
• Using the Analyze Datasets tool to update statistics on geodatabase system tables
• Updating statistics on geodatabase system tables using a Python script

10. Managing geodatabase locks

• Schema locking
• Viewing connected user sessions
• Geodatabase locks
• Managing locks in the geodatabase
• Concurrency and locking

11. Geodatabase workflow

Recommended Training/Follow-on Classes

On geodatabases

• Configuring and Managing the Multiuser
• Implementing Versioned Workflows in a Multiuser Geodatabase
• Distributing Data Using Geodatabase Replication
• Archiving Data in a Multiuser Geodatabase (for ArcGIS 10.1)

On editing and sharing geodatabases

• Creating and Sharing Map Packages (for ArcGIS 10.1)
• Editing Data with ArcGIS for Desktop (10.2)
• ArcGIS for Server: Sharing GIS Content on the Web (for 10.1)
• ArcGIS 4: Sharing Content on the Web (for ArcGIS 10.2)

On Python

• Python for Everyone Using ArcGIS 10.1
• Basics of Python (for ArcGIS 10.1)
• Introduction to Geoprocessing Scripts Using Python

[GregoryEmmanuel]

Thanks Rudy!

-g.