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 declared indifference, but as I must think, covert real zeal for the spread of slavery, I can not but hate. I hate it because of the monstrous injustice of slavery itself. I hate it because it deprives our republican example of its just influence in the world ... and especially because it forces so many really good men amongst ourselves into an open war with the very fundamental principles of civil liberty.”
—Abraham Lincoln (1809–1865)
“The features of our face are hardly more than gestures which force of habit made permanent. Nature, like the destruction of Pompeii, like the metamorphosis of a nymph into a tree, has arrested us in an accustomed movement.”
—Marcel Proust (1871–1922)