Comparison of relational database management systems: Difference between revisions

Revision as of 09:23, 13 July 2023

Revision as of 06:16, 15 August 2023

Line 1,294:

| {{yes}}

| {{yes}}

| {{Yes|Yes|align=|style=|color=}} (Row-level locking)

| {{Yes||align=|style=|color=}}Yes

| {{yes}}

|[[API]] & [[GUI]] & [[SQL]]

Line 1,751:

|}

* <cite id="feat_1">[[Comparison of relational database management systems#feat 1|Note (1):]]</cite> Currently only supports read uncommited transaction isolation. Version 1.9 adds serializable isolation and version 2.0 will be fully ACID compliant.

* <cite id="feat_2">[[#feat 2 back|Note (2):]]</cite> MariaDB and MySQL provide ACID compliance through the default InnoDB storage engine.<ref>{{cite web

<cite id="feat_2">[[#feat 2 back|Note (2):]]</cite> MariaDB and MySQL provide ACID compliance through the default InnoDB storage engine.<ref>{{cite web

| url = http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html

| title = MySQL - The InnoDB Storage Engine

Line 1,760 ⟶ 1,759:

| title = InnoDB - Oracle Wiki

}}</ref>

* <cite id="feat_3">[[#feat 3 back|Note (3):]]</cite> "For other than [[InnoDB]] storage engines, MySQL Server parses and ignores the {{mono|FOREIGN KEY}} and {{mono|REFERENCES}} syntax in {{mono|CREATE TABLE}} statements. The {{mono|CHECK}} clause is parsed but ignored by all storage engines."<ref>{{cite web

<cite id="feat_3">[[#feat 3 back|Note (3):]]</cite> "For other than [[InnoDB]] 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."<ref>{{cite web

| url = http://dev.mysql.com/doc/refman/5.6/en/create-table.html

| title = MySQL 5.6 Reference Manual

}}</ref>

* <cite id="feat_5feat_4">[[Comparison of relational database management systems#feat 54|Note (54):]]</cite> MySQLSupport providesfor GUIUnicode interfaceis throughnew [[MySQLin Workbench]]version 10.0.

* <cite id="feat_4feat_5">[[Comparison of relational database management systems#feat 45|Note (45):]]</cite> SupportMySQL forprovides UnicodeGUI isinterface newthrough in[[MySQL version 10.0Workbench]].

* <cite id="feat_7">[[#feat 6 back|Note (6):]]</cite> OpenEdge SQL database engine uses Referential Integrity, OpenEdge ABL Database engine does not and is handled via database triggers.

<cite id="feat_5">[[Comparison of relational database management systems#feat 5|Note (5):]]</cite> MySQL provides GUI interface through [[MySQL Workbench]].

<cite id="feat_7">[[#feat 6 back|Note (6):]]</cite> OpenEdge SQL database engine uses Referential Integrity, OpenEdge ABL Database engine does not and is handled via database triggers.

==Limits==