> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://ocient.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server.

# Database Administration

> Manage and maintain Ocient data warehouse with essential database administration practices for optimized performance.

Database Administrators are responsible for ensuring the smooth operation of an Ocient® System and learning how to maximize performance to meet the goals of their organization.

See these pages for key concepts that are useful for understanding Ocient System dynamics and managing users.

## Tutorials

### Security

These pages explain system authentication, SSO, network security, and encryption options.

* [**Ocient Security Guide**](/guides/database-administration/ocient-security-guide)
* [**Set Up Data Encryption**](/guides/database-administration/ocient-security-guide/set-up-data-encryption)
* [**Authentication Methods**](/guides/database-administration/authentication-methods)
* [**Database Password Security Settings**](/guides/database-administration/authentication-methods/database-password-security-settings)

### User Control

These pages explain Ocient user management, including controlling security and priority for user groups:

* [**Manage Users, Groups, and Roles**](/guides/database-administration/manage-users-groups-and-roles)
* [**Workload Management and Service Classes**](/guides/database-administration/manage-users-groups-and-roles/workload-management-and-service-classes)
* [**Workload Management Walkthrough**](/guides/database-administration/manage-users-groups-and-roles/workload-management-walkthrough)
* [**Object-Type Level Privileges Management**](/guides/database-administration/manage-users-groups-and-roles/object-type-level-privileges-management)

### Query Performance and Tuning

Configure keys and indexes before loading large amounts of data into a table. These pages provide detailed information on how to optimize query performance by setting up Ocient keys and indexing:

* [**TimeKeys and Clustering Keys**](/guides/database-administration/schema-design/timekeys-and-clustering-keys)
* [**Secondary Indexes**](/guides/database-administration/schema-design/secondary-indexes)
* [**CREATE TABLE SQL Statement Examples**](/guides/database-administration/schema-design/create-table-sql-statement-examples)
* [**Manage Distributed Tasks**](/guides/database-administration/manage-distributed-tasks)

### Storage

These pages explain compression and caching options in the Ocient System:

* [**Table Compression Options**](/guides/database-administration/schema-design/table-compression-options)
* [**Global Dictionary Compression**](/guides/database-administration/schema-design/table-compression-options/global-dictionary-compression)
* [**Result Set Caching**](/guides/database-administration/manage-users-groups-and-roles/result-set-caching)
* [**Remove Records from an Ocient System**](/guides/database-administration/remove-records-from-an-ocient-system)

## SQL Reference Pages

For detailed documentation on supported DDL or DCL commands and syntax, see:

* [**General SQL Syntax**](/guides/query-ocient/general-sql-syntax)
* [**Data Definition Language (DDL) Statement Reference**](/guides/sql-reference/data-definition-language-ddl-statement-reference)
* [**Data Control Language (DCL) Statement Reference**](/guides/sql-reference/data-control-language-dcl-statement-reference)

## Related Links

[**Connect to Ocient**](/guides/connect-to-ocient)

[**Ingest Data with Legacy LAT Reference**](/guides/lat-reference/ingest-data-with-legacy-lat-reference)