The following list defines some of the terms used when discussing geodatabase management:
| Term | Definition |
|---|---|
compact | The compact operation cleans up file and personal geodatabase file storage on disk, reorders records, and eliminates unused space. |
compress | When referring to file geodatabase vector data, a compress operation condenses the data. As a result, the data takes up less disk space. Compressed file geodatabase data cannot be edited; you must decompress it to edit. When referring to data in an enterprise, workgroup, or desktop geodatabase that uses traditional versioning, a compress operation removes unreferenced states and their associated delta table rows and moves delta table entries that are common to all versions into the base tables. This reduces the amount of data the database must search through for each version query, thereby improving query performance and system response time. |
database authentication | Database authentication is one method of validating the credentials of a user attempting to connect to the database; in this case, the user provides the name and password of a database user, and the database authorizes or denies authorization of the user's connection. |
desktop geodatabases | Geodatabases on a database server that are licensed through ArcGIS Desktop are referred to as desktop geodatabases. Desktop geodatabases can be accessed by a few users and edited by one user at a time For additional terms related to desktop geodatabases and database servers, see Database server vocabulary. |
enterprise geodatabase | An enterprise geodatabase is a multiuser geodatabase stored in a database management system and licensed through ArcGIS Enterprise or ArcGIS GIS Server Basic (enterprise edition). |
geodatabase administrator | The geodatabase administrator is the login account used to administer an enterprise geodatabase. Administration tasks include geodatabase creation, compress operations, upgrades, lock and user connection administration, and system table maintenance. The system objects of the geodatabase are owned by or stored in the schema of the geodatabase administrator. |
geodatabase repository | The geodatabase repository comprises the minimum components needed to make a geodatabase; these include system tables, stored procedures, functions, and types. In enterprise geodatabases, the geodatabase repository is stored in a database management system. |
geodatabase versioning | Geodatabase versioning is the method by which multiple users can edit the same data without overwriting each other's edits or blocking others from reading or editing the data. When you use traditional versioning, this is accomplished by using separate tables for each versioned dataset to track edits as well as system tables to track different states of the data. For additional terms related to traditional versioning, see Versioning vocabulary. |
operating system authentication | Operating system authentication is one method of validating the credentials of a user attempting to connect to the database; in this case, the user's login information is read from the operating system of the connecting client computer. The database uses this information to authorize the connection. The user or application making the connection does not have to provide a separate user name and password. |
spatial views | Spatial views are database views that contain one spatial field from a feature class in addition to other attribute fields. |
upgrade | In the context of geodatabases, an upgrade operation updates the system tables, stored procedures, functions, and types to provide new functionality or bug fixes. You use either the Upgrade Geodatabase geoprocessing tool or a Python script to upgrade a geodatabase. When upgrading a geodatabase, you must run these from a computer on which either ArcGIS Desktop (Desktop Standard or Desktop Advanced), ArcGIS Engine with the Geodatabase Update extension, or ArcGIS GIS Server is installed. The login you use to connect must have sufficient privileges to run the upgrade. When upgrading a file or personal geodatabase, you can also run the geoprocessing tool or Python script from a computer on which ArcGIS Desktop (Desktop Basic) is installed. |
versioned views | A versioned view incorporates a database view, stored procedures, triggers, and functions to allow you to use Structured Query Language (SQL) to read or edit data in a geodatabase that has been registered to use traditional versioning. When you query a versioned view, you can see the data in the base (business) table and the edits that are stored in the delta tables. The triggers used by the versioned views update the delta tables when you edit the versioned view using SQL. |
workgroup geodatabases | Geodatabases on a database server that are licensed through ArcGIS Server (Basic) Workgroup or ArcGIS Enterprise Workgroup are referred to as workgroup geodatabases. Workgroup geodatabases can be accessed by up to 10 users at a time, all of whom can be editing concurrently. You can also use web services and applications to access data in workgroup geodatabases. For additional terms related to workgroup geodatabases and database servers, see Database server vocabulary. |