Overview

This two-day course details the architecture and fundamental concepts of ArcSDE software and storage structures. Through lectures and hands-on exercises, you view and query layers in an ArcSDE database using ArcCatalog and ArcMap. You also create new ArcSDE layers by loading existing, file-based geographic data sources, such as shapefiles, coverages and images, into an ArcSDE server. Exercises are supported with in-depth discussions and demonstrations of how ArcSDE clients, servers and the underlying DBMS work together.

This course is for GIS and DBMS custodians who need to become proficient end users of an ArcSDE geodatabase. GIS managers and analysts who oversee ArcSDE database implementation also benefit from this course by achieving an understanding of how a healthy system functions. General knowledge of DBMS systems would be beneficial. For many ArcGIS users, this course concentrates on the ArcSDE monitoring and operations, which may not be appropriate.

Therefore, the Building Geodatabases I course includes the Chapter 6 multi-user editing and Chapter 7 versioning lectures from this course. This course will be run on  version 8.3 of the software.

Audience

This course is for GIS and DBMS users who need to become proficient end users of an ArcSDE geodatabase. GIS managers who oversee ArcSDE database implementation also benefit from this course by achieving an understanding of how a healthy system functions.

Goals

  • Understand the geodatabase storage formats for each DBMS

  • Learn the ArcSDE software architecture

  • Load file-based vector and raster data into an ArcSDE geodatabase

  • Create ArcSDE application server and direct connections to query the database

  • Perform multi-user editing.

  • Work with multiple database versions.

Topics

Spatial data formats: Description of vector and raster file formats; Explanation of the geodatabase and ArcSDE; Geodatabase functionality; Valid entity types for feature classes; Client/Server model.

ArcSDE software and storage architecture: ArcSDE system components; Application server connections; ArcSDE Direct Connects; Communication over the TCP/IP network; Feature class storage; Retrieving data with Structured Query Language (SQL); Spatial index.

ArcSDE raster: Description of ArcSDE raster data; Raster storage; Loading raster data; Raster tiles, pyramids and compression; Mosaics and raster catalogs.

Vector data loading: Calculating the feature class properties of precision, shifts and spatial index; Loading vector data using ArcCatalog and ArcSDE commands; Modifying properties of a loaded layer (permissions and grid size).

Multi-user editing: Explanation of multi-user editing; Explanation of how versioning works; Understanding A and D tables; Multi-user editing example; Conflict detection and resolution; Editing in ArcMap.

Versioning: Explanation of versions; Creating and managing versions; Version properties; Merging versions; Work flow diagrams; Procedures.

Prerequisites

  • You should have a basic understanding of the following:

    • Vector and raster GIS concepts

    • Projections and coordinate systems

    • Fundamental relational database concepts

    • SQL queries

    • Communication over a network

Duration: Two days

Further Studies

 


 

Company Profile | Products | Training | Solutions | Support | Contact Us