Open Interface
- ANSI SQL-99 compliant
- ODBC 3.0 Level 2 support
- JDBC type I & II support
- ESQL/C preprocessor
- COBOL interface
- Native OLEDB Provider
|
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
- Access Control List
|
Embedded Application Support
- Embedded database engine
- Read-only media application support
|
Database Administration Tool
- Java-based database administration tool
- Database monitor for run-time status and historical statistics
- Data transfer tool
- Database diagnose and repair tool
- Web-based DBA Tool
|
Storage Management
- Auto extend and regular table spaces
- Raw device support on UNIX
- Maximum database size of 256 PB
- Read Only Tablespace
- User-defined page size
|
|
Data Reliability
- Online transaction processing
- Online full and incremental backup
- Automatic crash recovery
- Automatic statistic updates
- Database consistency checking
|
Extended Relational Database Functions
- Trigger
- Java and C stored procedure
- User Defined Function
- Intelligent cost base 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
|
Distributed Database Management
- Distributed queries
- Two-phase commit
- Access to remote data objects
- Asynchronous/synchronous table replication
- Database mirror replication
|
XML support
- XML Transfer API
- XML export template tool
- XML import mapping tool
- XML Data Type
|
|
