Does Altibase support standard SQL and other interfaces?
Yes, Altibase supports SQL-92 and SQL:1999 as well as other SQL provided by other DBMSs. Furthermore, Altibase provides high compatibility with standard interfaces. As an SQL compliant DBMS, Altibase enables its customers to utilize a readily available pool of application developers and administrators at low cost.
SQL
Function |
Altibase |
Oracle |
SAP HANA |
IBM DB2 |
Hint |
Supported |
Supported |
Supported |
Supported |
In-line View |
Supported |
Supported |
Supported |
Supported |
Join |
Supported |
Supported |
Supported |
Supported |
Outer Join |
Supported |
Supported |
Supported |
Supported |
Hierarchical Query |
Supported |
Supported |
Supported |
Supported |
Grouping Set |
Supported |
Supported |
Supported |
Supported |
Parallel Insert |
Supported |
Supported |
Supported |
Supported |
Array Processing |
Supported |
Supported |
Supported |
Supported |
Cost Optimizer |
Supported |
Supported |
Supported |
Supported |
Table Analyzer |
Supported |
Supported |
Supported |
Supported |
Built-Function |
Supported |
Supported |
Supported |
Supported |
TPC-H Query |
Supported |
Supported |
Supported |
Supported |
Move |
Supported |
Not supported |
Not supported |
Not supported |
Interface
Function |
Altibase |
Oracle |
SAP HANA |
IBM DB2 |
JDBC |
Supported |
Supported |
Supported |
Supported |
OLE DB |
Supported |
Supported |
Supported |
Supported |
.NET Provider |
Supported |
Supported |
Supported |
Supported |
ODBC |
Supported |
Supported |
Supported |
Supported |
PHP |
Supported |
Supported |
Supported |
Supported |
Embedded SQL |
APRE |
PROC |
CPRE |
Supported |
CLI |
CLI |
OCI |
Supported |
Supported |
Altibase – Downloading is Believing.