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
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.
• Completion of ArcGIS 2: Essential Workflows or equivalent knowledge
• Experience managing a relational database management system
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
• Use ModelBuilder
• Data users
• Creating data users
• Manage users
• Defining roles
• Designing roles
• Securing credentials
• Configuration parameters
• Configuration keywords
• Supported spatial types
• DBTUNE table
• Create and update keywords
Maintaining the geodatabase
• Attribute indexes
• Manage attribute indexes and statistics
• Spatial indexes
• The Compress tool
• Scheduling tasks
• Manage performance tasks with Python
• Schema locks
• View and clear locks
• 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