---
title: Database Administration
slug: 1dK9gmiMEg-ycjeVhvg-U
description: Manage and maintain Ocient data warehouse with essential database administration practices for optimized performance.
docTags: 
createdAt: Thu Jul 21 2022 17:05:13 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Mar 30 2026 18:52:36 GMT+0000 (Coordinated Universal Time)
---

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.&#x20;

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

## Tutorials

### Security

These pages explain system authentication, SSO, network security, and encryption options.&#x20;

- [Ocient Security Guide](<./Database Administration/Ocient Security Guide.md>)&#x20;
- [Set Up Data Encryption](<./Database Administration/Ocient Security Guide/Set Up Data Encryption.md>)&#x20;
- [Authentication Methods](<./Database Administration/Authentication Methods.md>) &#x20;
- [Database Password Security Settings](<./Database Administration/Authentication Methods/Database Password Security Settings.md>)&#x20;

### User Control

These pages explain Ocient user management, including controlling security and priority for user groups:&#x20;

- [Manage Users, Groups, and Roles](<./Database Administration/Manage Users_ Groups_ and Roles.md>)
- [Workload Management and Service Classes](<./Database Administration/Manage Users_ Groups_ and Roles/Workload Management and Service Classes.md>)&#x20;
- [Workload Management Walkthrough](<./Database Administration/Manage Users_ Groups_ and Roles/Workload Management Walkthrough.md>)&#x20;
- [Object-Type Level Privileges Management](<./Database Administration/Manage Users_ Groups_ and Roles/Object-Type Level Privileges Management.md>)&#x20;

### 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:&#x20;

- [TimeKeys and Clustering Keys](<./Database Administration/Schema Design/TimeKeys and Clustering Keys.md>)
- [Secondary Indexes](<./Database Administration/Schema Design/Secondary Indexes.md>)
- [CREATE TABLE SQL Statement Examples](<./Database Administration/Schema Design/CREATE TABLE SQL Statement Examples.md>) &#x20;
- [Manage Distributed Tasks](<./Database Administration/Manage Distributed Tasks.md>)&#x20;

### Storage

These pages explain compression and caching options in the Ocient System:&#x20;

- [Table Compression Options](<./Database Administration/Schema Design/Table Compression Options.md>)
- [Global Dictionary Compression](<./Database Administration/Schema Design/Table Compression Options/Global Dictionary Compression.md>)&#x20;
- [Result Set Caching](<./Database Administration/Manage Users_ Groups_ and Roles/Result Set Caching.md>)&#x20;
- [Remove Records from an Ocient System](<./Database Administration/Remove Records from an Ocient System.md>)&#x20;

## SQL Reference Pages

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

- [General SQL Syntax](<./Query Ocient/General SQL Syntax.md>)
- [Data Definition Language (DDL) Statement Reference](<./SQL Reference/Data Definition Language _DDL_ Statement Reference.md>)
- [Data Control Language (DCL) Statement Reference](<./SQL Reference/Data Control Language _DCL_ Statement Reference.md>)&#x20;

## Related Links

[Connect to Ocient](<./Connect to Ocient.md>)

[Ingest Data with Legacy LAT Reference](<./LAT Reference/Ingest Data with Legacy LAT Reference.md>)

