Datatek --  Expanding the Possibilities
 
Datatek/SQL Benefits   home > products > datatek/sql > datatek/sql benefits  
Very Large User Counts
Datatek/SQL supports more than 500 users per system in real world environments (not just in the benchmarking lab).

 

Multiple Databases on the Same System
Supports as many databases as your application logically requires, without any performance degradation or the purchasing of additional licenses.

 

Fuzzy Checkpointing
Checkpoints the database on a continual basis, eliminating the impact of performance degradation caused by a checkpoint.

 

Excellent Locking Mechanism for Better Concurrency
Locks are tuned to maximize concurrency while ensuring consistency. Read-only transactions never obtain a lock.

 

Sophisticated Query Optimizer
Chooses the best optimization regardless of the complexity of the query.

 

Two-phase Commit
Provides consistency for applications distributed across multiple hosts.

 

Advanced Recovery Features
Recovers at a region level if desired. Tunable parameters are available to tradeoff between runtime performance and recovery time.

 

Precompilers for C, COBOL, FORTRAN, and PL/1
Allows embedded SQL statements from a variety of programming languages.

 

Tuning Tools
Database administrators have access to the familiar utilities SQL-Tune and SQL-Monitor to maximize the performance of your application.