Does Altibase support standard SQL and other interfaces?
- Post by
- Altibase
- Date
- 2021-03-10
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 |
