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

# Database Administration

## Docs

- [Database Administration](https://ocient.ferndocs.com/guides/database-administration/database-administration.md): Manage and maintain Ocient data warehouse with essential database administration practices for optimized performance.
- [Authentication Methods](https://ocient.ferndocs.com/guides/database-administration/authentication-methods.md): Learn about various authentication methods supported by Ocient, ensuring secure and controlled access to your data warehouse.
- [Manage Distributed Tasks](https://ocient.ferndocs.com/guides/database-administration/manage-distributed-tasks.md): Distributed tasks are processes that run in the background of the Ocient System to keep the system running smoothly and efficiently. These tasks provide persistent storage of task information in the global metadata storage cluster.
- [Manage Users, Groups, and Roles](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles.md): Set up and manage users, groups, and roles within Ocient, ensuring secure and organized access control in the database.
- [Ocient Security Guide](https://ocient.ferndocs.com/guides/database-administration/ocient-security-guide.md): Enhance your Ocient System security with our comprehensive guide. Learn best practices for authentication, network security, data encryption, access control, auditing, and compliance with privacy regulations.
- [Remove Records from an Ocient System](https://ocient.ferndocs.com/guides/database-administration/remove-records-from-an-ocient-system.md): Discover methods for safely and efficiently removing records from an Ocient system, ensuring data integrity.
- [Database Password Security Settings](https://ocient.ferndocs.com/guides/database-administration/authentication-methods/database-password-security-settings.md): Secure your Ocient System with best practices for authentication, access control, encryption, network security, auditing, and compliance. Strengthen data privacy and protect SaaS or customer-deployed systems with our comprehensive security guide.
- [Object-Type Level Privileges Management](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/object-type-level-privileges-management.md)
- [Result Set Caching](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/result-set-caching.md): Optimize performance with result set caching in Ocient, reducing query times and improving efficiency for frequent data requests.
- [Workload Management and Service Classes](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/workload-management-and-service-classes.md): Understand service classes and workload management to allocate resources effectively and maximize Ocient performance.
- [Workload Management Walkthrough](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/workload-management-walkthrough.md): Learn how to manage workloads within Ocient, balancing resources for optimized query performance and efficiency.
- [Set Up Data Encryption](https://ocient.ferndocs.com/guides/database-administration/ocient-security-guide/set-up-data-encryption.md): Optimize data security with Ocient® System data encryption setup for drives supporting TCG Opal Specification. This guide covers configuring encryption secrets using the Thales CipherTrust Manager KMS via KMIP.
- [CREATE TABLE SQL Statement Examples](https://ocient.ferndocs.com/guides/database-administration/schema-design/create-table-sql-statement-examples.md): Access examples of SQL CREATE TABLE statements in Ocient, illustrating best practices for table structure and data types.
- [Secondary Indexes](https://ocient.ferndocs.com/guides/database-administration/schema-design/secondary-indexes.md): Explore the benefits of secondary indexes in Ocient, designed to enhance data retrieval speed and efficiency for large datasets.
- [Table Compression Options](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-compression-options.md): Learn about table compression options in Ocient, optimizing data storage and reducing costs for large-scale data warehousing.
- [Table Retention Policies](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-retention-policies.md): Ocient table retention policies automate data lifecycle management by removing aged records based on time-key columns, reducing manual maintenance and optimizing database performance.
- [TimeKeys and Clustering Keys](https://ocient.ferndocs.com/guides/database-administration/schema-design/time-keys-and-clustering-keys.md): Discover how to use time keys, clustering keys, and indexes in Ocient to improve data organization and query performance.
- [Global Dictionary Compression](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-compression-options/global-dictionary-compression.md): Understand global dictionary compression in Ocient, a technique to reduce data redundancy and improve query performance.