Fundamental Features
Information about what fundamental RDBMS features are implemented natively.
| ACID | Referential integrity | Transactions | Unicode | Interface | |
|---|---|---|---|---|---|
| 4th Dimension | Yes | Yes | Yes | Yes | GUI & SQL |
| ADABAS | Yes | No | Yes | Yes | proprietary direct call & SQL (via 3rd party) |
| Adaptive Server Enterprise | Yes | Yes | Yes | Yes | SQL |
| Advantage Database Server | Yes | Yes | Yes | Yes4 | API & SQL |
| Altibase | Yes | Yes | Yes | Yes | API & GUI & SQL |
| Apache Derby | Yes | Yes | Yes | Yes | SQL |
| CUBRID | Yes | Yes | Yes | Yes | GUI & SQL |
| Drizzle | Yes | Yes | Yes | Yes | SQL |
| DB2 | Yes | Yes | Yes | Yes | GUI & SQL |
| Empress Embedded Database | Yes | Yes | Yes | Yes | API & SQL |
| Firebird | Yes | Yes | Yes | Yes | SQL |
| HSQLDB | Yes | Yes | Yes | Yes | SQL |
| H2 | Yes | Yes | Yes | Yes | SQL |
| Informix Dynamic Server | Yes | Yes | Yes | Yes | SQL |
| Ingres | Yes | Yes | Yes | Yes | SQL & QUEL |
| InterBase | Yes | Yes | Yes | Yes | SQL |
| Linter SQL RDBMS | Yes | Yes | Yes | Yes | GUI & SQL |
| LucidDB | Yes | No | No | Yes | SQL |
| MariaDB | Yes2 | Partial3 | Yes2 except for DDL | Yes | SQL |
| MaxDB | Yes | Yes | Yes | Yes | SQL |
| Microsoft Access (JET) | Yes | Yes | Yes | Yes | GUI & SQL |
| Microsoft Visual FoxPro | No | Yes | Yes | No | GUI & SQL |
| Microsoft SQL Server | Yes | Yes | Yes | Yes | GUI & SQL |
| Microsoft SQL Server Compact (Embedded Database) | Yes | Yes | Yes | Yes | GUI & SQL |
| MonetDB/SQL | Yes | Yes | Yes | Yes | SQL |
| MySQL | Yes2 | Partial3 | Yes2 except for DDL | Yes | SQL |
| OpenBase SQL | Yes | Yes | Yes | Yes | GUI & SQL |
| Oracle | Yes | Yes | Yes except for DDL | Yes | API & GUI & SQL |
| Oracle Rdb | Yes | Yes | Yes | Yes | SQL |
| OpenLink Virtuoso | Yes | Yes | Yes | Yes | API & GUI & SQL |
| Polyhedra DBMS | Yes | Yes | Yes | Yes | API & SQL |
| PostgreSQL | Yes | Yes | Yes | Yes | API & GUI & SQL |
| RDM Embedded | Yes | Yes | Yes | Yes | SQL & API |
| RDM Server | Yes | Yes | Yes | Yes | SQL & API |
| ScimoreDB | Yes | Yes | Yes | Partial | SQL |
| SQL Anywhere | Yes | Yes | Yes | Yes | SQL |
| SQLBase | Yes | Yes | Yes | Yes | API & GUI & SQL |
| SQLite | Yes | Yes | Yes | Optional | SQL |
| Teradata | Yes | Yes | Yes | Yes | SQL |
| UniData | Yes | No | Yes | Yes | Multiple |
| UniVerse | Yes | No | Yes | Yes | Multiple |
| Xeround Cloud Database | Yes | No | Yes | Yes | SQL |
| ACID | Referential integrity | Transactions | Unicode | Interface |
Note (1): Currently only supports read uncommited transaction isolation. Version 1.9 adds serializable isolation and version 2.0 will be fully ACID compliant.
Note (2):MySQL provides ACID compliance through the default InnoDB storage engine.
Note (3):"For other storage engines, MySQL Server parses and ignores the FOREIGN KEY and REFERENCES syntax in CREATE TABLE statements. The CHECK clause is parsed but ignored by all storage engines."
Note (4): Support for Unicode is new in version 10.0.
Read more about this topic: Comparison Of Relational Database Management Systems
Famous quotes containing the words fundamental and/or features:
“This leads us to note down in our psychological chart of the mass-man of today two fundamental traits: the free expansion of his vital desires, and, therefore, of his personality; and his radical ingratitude towards all that has made possible the ease of his existence. These traits together make up the well-known psychology of the spoilt child.”
—José Ortega Y Gasset (1883–1955)
“It is a tribute to the peculiar horror of contemporary life that it makes the worst features of earlier times—the stupefaction of the masses, the obsessed and driven lives of the bourgeoisie—seem attractive by comparison.”
—Christopher Lasch (b. 1932)