DBMaker Features

DBMaker supports a wealth of advanced features and a full complement of traditional database functions. The following list is a brief overview of some of the more visible features within DBMaker. For additional information about any of the features below, please contact us.

Open Interface

• ANSI SQL-99 compliant
• ODBC 3.0 Level 2 support
• JDBC type I & II support
• ESQL/C preprocessor
• COBOL Interface

Security Management

• User- and group-level security
• Privilege management on both tables and individual columns
• Privilege management on stored commands and stored procedures
• Network encryption

Embedded Application Support

• Embedded database engine
• Read-only media application support
  

Database - COBOL Interface

• API for storing COBOL records in database tables
• COBOL applications retain high performance transaction processing
• Stored data benefits from database reliability and flexibility

Database Administration Tool

• Java-based database administration tool
• Database monitor for run-time status and historical statistics
• Data transfer tool
• Database diagnosis and repair tool
  

Data Reliability

• Online transaction processing
• Online full and incremental backup
• Automatic crash recovery
• Automatic statistic updates
• Database consistency checking
• MTS (Microsoft Transaction Service) support

Extended Relational Database Functions

• Trigger
• Stored procedure
• User Defined Function
• Intelligent cost-based optimizer
• Referential constraint actions

Full-text Search

• Built-in high performance text search engine
• Low requirement text search kernel
• Multi-language support
• Exact, near and fuzzy search

Storage Management

• Autoextend and regular tablespaces
• Raw device support on UNIX
• Maximum database size of 32TB
  

Distributed Database Management

• Distributed queries
• Two-phase commit
• Access to remote data objects
• Asynchronous/synchronous table replication
• Database mirror replication