Database Administration

Database Administrators are responsible for ensuring the smooth operation of an 
﻿ 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. 
Walkthroughs
﻿User Control﻿
These pages explain Ocient user management, including controlling security and priority for user groups: 
﻿Manage Users, Groups, and Roles﻿﻿
﻿Workload Management and Service Classes﻿ 
﻿Workload Management Walkthrough﻿ 
﻿Authentication Methods﻿  
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: 
﻿Time Keys, Clustering Keys, and Indexes﻿﻿
﻿Secondary Indexes﻿﻿
﻿CREATE TABLE SQL Statement Examples﻿  
Storage
These pages explain compression and caching options in the Ocient System: 
﻿Table Compression Options﻿﻿
﻿Global Dictionary Compression﻿ 
﻿Result Set Caching﻿ 
SQL Reference Pages
For detailed documentation on supported DDL or DCL commands and syntax, see:
﻿General SQL Syntax﻿﻿
﻿Data Definition Language (DDL) Command Reference﻿﻿
﻿Data Control Language (DCL) Command Reference﻿ 
Related Links
﻿Connect to Ocient﻿﻿
﻿Load Data﻿﻿