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:
“No drug, not even alcohol, causes the fundamental ills of society. If we’re looking for the sources of our troubles, we shouldn’t test people for drugs, we should test them for stupidity, ignorance, greed and love of power.”
—P.J. (Patrick Jake)
“However much we may differ in the choice of the measures which should guide the administration of the government, there can be but little doubt in the minds of those who are really friendly to the republican features of our system that one of its most important securities consists in the separation of the legislative and executive powers at the same time that each is acknowledged to be supreme, in the will of the people constitutionally expressed.”
—Andrew Jackson (1767–1845)