Comparison of relational database management systems: Difference between revisions

Revision as of 20:10, 3 May 2021

Revision as of 20:15, 3 May 2021

Line 1,269:

Information about what fundamental RDBMS features are implemented natively.

{| style="text-align: center; width: 95%" class="wikitable sortable"

|-

! style="width:16em" |Database Name

! [[ACID]]

! [[Referential integrity]]

Line 1,281:

! [[Type inference]]

|-

! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]

| {{yes}}

| {{yes}}

Line 1,291:

| {{Yes}}

|-

! style="text-align:left" | [[ADABAS]]

| {{yes}}

| {{no}}

Line 1,301:

| {{Yes}}

|-

! style="text-align:left" | [[Adaptive Server Enterprise]]

| {{yes}}

| {{yes}}

Line 1,311:

| {{Yes}}

|-

! style="text-align:left" | [[Advantage Database Server]]

| {{yes}}

| {{yes}}

Line 1,321:

| {{Yes}}

|-

! style="text-align:left" | [[Altibase]]

| {{yes}}

| {{yes}}

Line 1,331:

| {{Yes}}

|-

! style="text-align:left" | [[Apache Derby]]

| {{yes}}

| {{yes}}

Line 1,341:

| {{Yes}}

|-

! style="text-align:left" | [[Clustrix|ClustrixDB]]

| {{yes}}

| {{yes}}

Line 1,351:

| {{Yes}}

|-

! [[CockroachDB]]

! style="text-align:left" | [[CUBRID]]

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}} (Row-level locking)

| {{yes}}

| {{yes}}

| [[SQL]]

| {{No}}

|-

! [[CUBRID]]

| {{yes}}

| {{yes}}

Line 1,361 ⟶ 1,371:

| {{Yes}}

|-

! style="text-align:left" | [[IBM DB2|DB2]]

| {{yes}}

| {{yes}}

Line 1,371 ⟶ 1,381:

| {{Yes}}

|-

! style="text-align:left" | [[Empress database|Empress Embedded Database]]

| {{yes}}

| {{yes}}

Line 1,381 ⟶ 1,391:

| {{Yes}}

|-

! style="text-align:left" | [[EXASOL|EXASolution]]

| {{yes}}

| {{yes}}

Line 1,391 ⟶ 1,401:

| {{Yes}}

|-

! style="text-align:left" | [[Firebird (database server)|Firebird]]

| {{yes}}

| {{yes}}

Line 1,401 ⟶ 1,411:

| {{Yes}}

|-

! style="text-align:left" | [[HSQLDB]]

| {{yes}}

| {{yes}}

Line 1,411 ⟶ 1,421:

| {{Yes}}

|-

! style="text-align:left" | [[H2 (DBMS)|H2]]

| {{yes}}

| {{yes}}

Line 1,421 ⟶ 1,431:

| {{Yes}}

|-

! style="text-align:left" | [[Informix Dynamic Server]]

| {{yes}}

| {{yes}}

Line 1,431 ⟶ 1,441:

| {{Yes}}

|-

! style="text-align:left" | [[Ingres (database)|Ingres]]

| {{yes}}

| {{yes}}

Line 1,441 ⟶ 1,451:

| {{Yes}}

|-

! style="text-align:left" | [[InterBase]]

| {{yes}}

| {{yes}}

Line 1,451 ⟶ 1,461:

| {{Yes}}

|-

! style="text-align:left" | [[Linter SQL RDBMS]]

| {{yes}}

| {{yes}}

Line 1,461 ⟶ 1,471:

| {{Yes}}

|-

! style="text-align:left" | [[LucidDB]]

| {{yes}}

| {{no}}

Line 1,471 ⟶ 1,481:

| {{Yes}}

|-

! style="text-align:left" | [[MariaDB]]

| {{yes}}<sup id="feat_2_back">[[#feat 2|2]]</sup>

| {{yes}}

Line 1,481 ⟶ 1,491:

| {{Yes}}

|-

! style="text-align:left" | [[MaxDB]]

| {{yes}}

| {{yes}}

Line 1,491 ⟶ 1,501:

| {{Yes}}

|-

! style="text-align:left" | [[Microsoft Access]] (JET)

| {{yes}}

| {{yes}}

Line 1,501 ⟶ 1,511:

| {{Yes}}

|-

! style="text-align:left" | [[Microsoft Visual FoxPro]]

| {{Yes}}

| {{Yes}}

Line 1,511 ⟶ 1,521:

| {{Yes}}

|-

! style="text-align:left" | [[Microsoft SQL Server]]

| {{yes}}

| {{yes}}

Line 1,521 ⟶ 1,531:

| {{Yes}}

|-

! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]

| {{yes}}

| {{yes}}

Line 1,531 ⟶ 1,541:

| {{Yes}}

|-

! style="text-align:left" | [[Mimer SQL]]

| {{yes}}

| {{yes}}

Line 1,541 ⟶ 1,551:

| {{Yes}}

|-

! style="text-align:left" | [[MonetDB]]

| {{yes}}

| {{yes}}

Line 1,551 ⟶ 1,561:

| {{Yes}}

|-

! style="text-align:left" | [[MySQL]]

| {{yes}}<sup id="feat_2_back">[[#feat 2|2]]</sup>

| {{yes}}<sup id="feat_3_back">[[#feat 3|3]]</sup>

Line 1,561 ⟶ 1,571:

| {{Yes}}

|-

! style="text-align:left" | [[OpenEdge Database|OpenEdge]]

| {{yes}}

| {{yes}}<sup id="feat_6_back">[[#feat 6|6]]</sup>

Line 1,571 ⟶ 1,581:

| {{Yes}}

|-

! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]

| {{yes}}

| {{yes}}

Line 1,581 ⟶ 1,591:

| {{Yes}}

|-

! style="text-align:left" | [[Oracle Database|Oracle]]

| {{yes}}

| {{yes}}

Line 1,591 ⟶ 1,601:

| {{Yes}}

|-

! style="text-align:left" | [[Oracle Rdb]]

| {{yes}}

| {{yes}}

Line 1,601 ⟶ 1,611:

| {{Yes}}

|-

! style="text-align:left" | [[Pervasive PSQL]]

| {{yes}}

| {{yes}}

Line 1,611 ⟶ 1,621:

| {{Yes}}

|-

! style="text-align:left" | [[Polyhedra DBMS]]

| {{yes}}

| {{yes}}

Line 1,621 ⟶ 1,631:

| {{Yes}}

|-

! style="text-align:left" | [[PostgreSQL]]

| {{yes}}

| {{yes}}

Line 1,631 ⟶ 1,641:

| {{No}}<ref>[https://www.postgresql.org/message-id/9799.1302719551%40sss.pgh.pa.us BUG #5974: UNION construct type cast gives poor error message]</ref>

|-

! style="text-align:left" | [[Raima Database Manager]]

| {{yes}}

| {{yes}}

Line 1,641 ⟶ 1,651:

| {{Yes}}

|-

! style="text-align:left" | [[RDM Server]]

| {{yes}}

| {{yes}}

Line 1,661 ⟶ 1,671:

| {{Yes}}

|-

! style="text-align:left" | [[solidDB]]

| {{yes}}

| {{yes}}

Line 1,671 ⟶ 1,681:

| {{Yes}}

|-

! style="text-align:left" | [[SQL Anywhere]]

| {{yes}}

| {{yes}}

Line 1,681 ⟶ 1,691:

| {{Yes}}

|-

! style="text-align:left" | [[SQLBase]]

| {{yes}}

| {{yes}}

Line 1,691 ⟶ 1,701:

| {{Yes}}

|-

! style="text-align:left" | [[SQLite]]

| {{yes}}

| {{yes}}

Line 1,701 ⟶ 1,711:

| {{Yes}}

|-

! style="text-align:left" | [[Superbase database | Superbase NG]]

| {{dunno}}

| {{dunno}}

Line 1,711 ⟶ 1,721:

| {{Yes}}

|-

! style="text-align:left" | [[Teradata]]

| {{yes}}

| {{yes}}

Line 1,721 ⟶ 1,731:

| {{Yes}}

|-

! style="text-align:left" | [[Tibero]]

| {{yes}}

| {{yes}}

Line 1,731 ⟶ 1,741:

| {{Yes}}

|-

! style="text-align:left" | [[UniData]]

| {{yes}}

| {{no}}

Line 1,741 ⟶ 1,751:

| {{Yes}}

|-

! style="text-align:left" | [[UniVerse]]

| {{yes}}

| {{no}}