3
Days (RM1,800.00)
Overview
ArcGIS Server includes ArcSDE technology, a server-side software product that acts as the GIS gateway to spatial data stored in relational database management systems (RDBMS). It is an integrated part of ArcGIS and a core element of any enterprise GIS solution. This course prepares Oracle database administrators to implement an enterprise geodatabase by teaching how to build an individual ArcSDE server. Students get familiar with the ArcSDE architecture and learn how to configure Oracle to support ArcSDE, install and configure ArcSDE, and identify and troubleshoot connection types and issues. The course emphasizes the importance of managing storage settings for loading vector and raster data and teaches techniques for maintaining geodatabase performance in an editing environment. Additionally, the course explains how ArcSDE interacts with Oracle databases and presents solid strategies for maintaining and managing an enterprise geodatabase.
Topics Covered
- ArcSDE installation: Evaluating the Oracle server configuration; Preparing Oracle to use ArcSDE; Installing ArcSDE; Starting and stopping the ArcSDE server; Exploring ArcSDE system tables.
- Data loading: Creating storage space; Creating users and assigning privileges; Creating vector feature classes; Creating raster datasets; Examining feature class components; Customizing storage with the DBTUNE table; Integrating the new ST_GEOMETRY Spatial Type.
- Monitoring data access: Creating application server and direct connections; Monitoring connections with ArcSDE and Oracle tools; Managing multiple geodatabases in one Oracle instance.
- Editing in a nonversioned environment and managing a multiversioned geodatabase: Registering feature classes as versioned; Compressing the geodatabase; Monitoring changes to the adds, deletes, and system tables.
Prerequisites and
recommendations
Students should have experience with Oracle database administration or application development. Although these courses are not required, students will benefit from completion of Introduction to ArcGIS I, Introduction to ArcGIS II, or Building Geodatabases.
