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:
“The science, the art, the jurisprudence, the chief political and social theories, of the modern world have grown out of Greece and Rome—not by favor of, but in the teeth of, the fundamental teachings of early Christianity, to which science, art, and any serious occupation with the things of this world were alike despicable.”
—Thomas Henry Huxley (1825–95)
“These, then, will be some of the features of democracy ... it will be, in all likelihood, an agreeable, lawless, particolored commonwealth, dealing with all alike on a footing of equality, whether they be really equal or not.”
—Plato (c. 427–347 B.C.)