ArcGIS 9'2 Geodatabase Enhancements

1
ArcGIS 9.2 Geodatabase Enhancements

• Arthur Robinson
• ESRI-Charlotte

2
Geodatabase Enhancement Overview

• Value of Geodatabases
• New Geodatabase storage options - Microsoft SQL
  Server Express- File Geodatabases
• Geodatabase Archiving
• Geodatabase Replication

3
Advantages of the Geodatabase

• An RDBMS for Spatial and Attribute Data

History / Archiving
Enhanced line topology
Scalable storage solutions
Topology rules (validation)
Object subtypes (support rules)
Geodatabase
Attribute validation (domains, null values)
Relationships (referential integrity)
Multiuser editing
Custom features
GeodatabaseReplication
4
New Geodatabase Types for 9.2

• Workgroup Geodatabase
• Personal Geodatabase
• File Geodatabase

ArcGIS
File Geodatabase

• SQL Server Express RDBMS Based
• Geodatabase

5
SQL Server Express based Geodatabases - New

• Workgroup Geodatabase
• SQL Server 2005 Express Edition
• Supports Versions, Replicas, Archives
• 4 GB size limit per geodatabase
• Multi-user editing and viewing (10)
• Unlimited connections for web applications
• Available with ArcGIS Server - Workgroup
• Personal Geodatabase
• SQL Server 2005 Express Edition
• Supports Versions, Replicas, Archives
• 4 GB size limit per geodatabase
• Single-user editing (per geodatabase)
• 3 concurrent connections
• Web application connections not allowed
• Available with ArcInfo and ArcEditor

Workgroup Geodatabase
Personal Geodatabase
SQL Server Express
6
Simplified Administration directly in ArcGIS

• 9.2 ArcCatalog will allow administrators to
• Manage the Database Server
• Start, Stop, Pause, Resume Server
• Add, Remove Users
• Manage Geodatabases
• Create, Delete and Upgrade
• Attach and Detach
• Backup and Restore
• Compress a multi-version geodatabase
• Set user permissions

Workgroup Geodatabase
Personal Geodatabase
SQL Server Express
7
File Geodatabase - New

• Supports all components of geodatabase(raster,
  vector, terrain, annotation, etc.)
• Scales to support 1 TB of data storage
• Single User Editing / Multi-User Read Access
• Supports data compression
• Cross Platform
• Multiple OS support(Windows, Linux, Solaris)
• No Versioning
• No Archiving
• No Replication (only checkout)

File Based Geodatabase
8

• DEMO - New Geodatabase Types

9
Geodatabase Archiving

• Preserve edit transactions
• Determine objects to archive
• Supports full Geodatabase data model
• Register as versioned
• Enable archiving
• Archive class is created
• Edit data
• Archive edits saved or posted to SDE.DEFAULT

10

• DEMO Geodatabase Archiving

11
Geodatabase Replication

• Allows you to distribute copies of data across 2
  or more geodatabases
• Databases can be edited independently and then
  synchronize them as needed
• Implement as part of business workflow, example
• Mobile field crews disconnected from network
• Distribute work to contractors
• Maintain copies of data at different
  organizational levels

State
County
Central parent replica can be used as a hub to
propagate changes between multiple child replicas
City
Replicas can be organized into a tree
12
Geodatabase Replication
Enterprise, Workgroup, Personal, File, Personal
(Access)
Enterprise, Workgroup, Personal
Enterprise, Workgroup, Personal
13

• DEMO Geodatabase Replication

14
ArcGIS 9.2 Geodatabase Enhancements Summary

• Geodatabases provide a valuable method of
  modeling the real world with flexible options.
• New Geodatabase Types
• New Geodatabase Archiving
• New Geodatabase Replication
• http//webhelp.esri.com/arcgisdesktop/9.2/index.cf
  m?TopicNameAn_overview_of_the_Geodatabase

15

• Questions