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 a 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 |