The geodatabase is the foundation with which the ArcGIS integrated platform is built upon. Walter demonstrated how central the geodatabase is to all levels of the ESRI product suite from field data capture with Collector for ArcGIS, to versioned editing in the office, and even replication of data across physical locations.
Client data usage is quite varied and to fill these requirements the geodatabase comes in many forms. Such as personal and file geodatabases, and multiuser geodatabases built on top of database systems such as SQL Express, SQL Server, Oracle, DB2, Infomix, and PostGreSQL.
The multiuser geodatabase provides the flexibility to edit data in short or long transactions via editing base tables directly or via isolated versions. Conflict resolution between versions is handled by the geodatabase and provides the user fine grained tools to resolve conflicts.
One thing that is commonly overlooked is the regular maintenance that is required to keep a multiuser geodatabase running at optimum performance. The following steps should be run on a regular basis to ensure the multiuser geodatabase is running soundly:
- Reconcile & Post
- Rebuild Indexes
- Analyse Datasets
The geodatabase is fundamental to Esri’s integrated solution, hopefully the Ozri session has provided you a greater understanding of the functions and capabilities of the multiuser geodatabase.