Skip to content

What interface does Altibase provide?#

Overview#

This document explains the interfaces provided by Altibase.

Version#

Altibase 6.1.1 or later

Interface provided by Altibase#

  • Altibase complies with the international standard ANSI SQL-1999 and provides various standard interfaces such as ODBC, ADO.NET, JDBC, and Embedded SQL.

Client development environment#

Interface type Support function
ODBC
  • RAD (Rapid Application Development) tools such as Visual Basic and PowerBuilder, as well as used when accessing Altibase in most development environments
  • Reinforced standard support with re-implementation
JDBC
  • Used when developing Altibase application programs in JAVA environment
  • Also used when configuring a connection pool in WAS
  • Improved performance with re-implementation
  • JDBC 2.0 API support up to Altibase 6.1.1, JDBC 3.0 API support partially.
  • JDBC 3.0 API support from Altibase 6.3.1.
  • Altibase 7.1 or later: Supports JDBC 3.0 API and partial support for JDBC 4.2 API.
  • Altibase 7.3 or later: Provides full support for JDBC 4.2 API.
SQLCLI
  • Altibase's low-level API based on C language
  • Provide LOB API, ALA (Altibase Log Analyzer) API, ACS (Altibase Call-Level for Spatial) API
Embedded

SQL (Pre-Compiler)
  • Interface used by the host language of C or C++
  • Improved development productivity by using SQL statements as they are in the host language
ADO.NET
  • Up to Altibase 6.5.1: Provided .NET Data Provider based on the .NET Framework.
  • From Altibase 7.1.0.8.3 / 7.3.0.0.5 or later: Provides Altibase ADO.NET based on .NET Core 3.1.
Unix ODBC
  • Standard DB connection API compatible with Windows ODBC source on Unix
  • Provide compatibility with ETL tools such as DataStage and Informatica and OLAP tools such as MSTR and Sagent
PDO
  • PDO interface is provided based on PHP 5.3.3, PHP 7.1.20, and PHP 8.1.8.
Hibernate Support
  • Support for Hibernate 6.4 is available starting from Altibase 7.1.0.9.2 and Altibase 7.3.0.0.2.

Server development environment#

Function Characteristic
SQL
  • Support Full Featured SQL92
  • Support international standard complex query such as Sub Query INLINE view
Built-in Function
  • Provides more than 100 built-in functions
  • Users can perform various operations in SQL statements by using Built-in Function
Stored Procedure & Function
  • Support Stored Procedure and Stored Function based on ANSI SQL standard
  • Result Set can be sent to the client in the procedure
  • Support structured type and array type within procedure
  • Support Dynamic SQL/DDL within the procedure
View
  • Efficiently query by unioning multiple tables or creating a specific SQL as a view
Trigger
  • Support Trigger by standard for business function in the form of data events
  • Support Update Trigger for a specific column