Comparison of relational database management systems: Difference between revisions

Revision as of 00:48, 11 July 2024

Revision as of 00:54, 11 July 2024

Line 79:

| 2021-04-23

| {{free|BSL,CCL,MIT,BSD}}

| {{Yes}}<ref>{{Cite web |url=https://github.com/cockroachdb/cockroach/issues |title=cockroachdb Issue tracker |website=[[GitHub]] |access-date=2021-05-03 |archive-date=2021-05-06 |archive-url=https://web.archive.org/web/20210506023814/https://github.com/cockroachdb/cockroach/issues |url-status=dead }}</ref>

|-

! [[CUBRID]]

Line 305:

| MonetDB Solutions <ref>{{Cite web|url=https://www.monetdbsolutions.com/|title = MonetDB Solutions}}</ref>

| 2004

| Dec2023 <ref>{{Cite web|url=https://www.monetdb.org/release-notes/|title = MonetDB Latest Release| date=21 December 2023 }}</ref>

| 2023-12-28

| {{free|Mozilla Public License, version 2.0<ref>{{Citation

Line 313:

| date = 8 February 2022

}}</ref>}}

| {{Yes}}<ref>{{Cite web |url=https://github.com/MonetDB/MonetDB/issues |title=MonetDB Issues |website=[[GitHub]] |access-date=2021-06-08 |archive-date=2021-05-13 |archive-url=https://web.archive.org/web/20210513162053/https://github.com/MonetDB/MonetDB/issues |url-status=dead }}</ref>

|-

! [[mSQL]]

Line 387:

| 2018-08-15

| {{partial|[[GNU General Public License|GPL]] v2 or [[Proprietary software|Proprietary]]}}

| {{Yes}}<ref>{{Cite web |url=https://github.com/openlink/virtuoso-opensource/issues |title=Issues · openlink/virtuoso-opensource · GitHub |website=[[GitHub]] |access-date=2017-11-01 |archive-date=2020-12-23 |archive-url=https://web.archive.org/web/20201223232822/https://github.com/openlink/virtuoso-opensource/issues |url-status=dead }}</ref>

|-

! [[Oracle Database|Oracle DB]]

Line 930:

| {{no}}

| {{no}}

| {{yes}}<ref>{{Cite web|url=https://developer.mimer.com/mimer-sql-is-now-available-for-openvms-on-x86/|title=Mimer SQL is now available for OpenVMS on x86|date=31 March 2023 }}</ref>

| {{no}}

| {{yes}}

Line 1,535:

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

| {{yes}}^{[[#feat 2|2]]} except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL"/>

| {{yes}} (Row-level locking)<ref>{{Cite web |url=https://dev.mysql.com/doc/refman/5.6/en/internal-locking.html |title=MySQL :: MySQL 5.6 Reference Manual :: 8.10.1 Internal Locking Methods |access-date=2018-03-05 |archive-date=2018-03-06 |archive-url=https://web.archive.org/web/20180306023025/https://dev.mysql.com/doc/refman/5.6/en/internal-locking.html |url-status=dead }}</ref>

| {{yes}}

| {{yes}}

Line 2,246:

| series = MSDN

| title = Library

| date = 21 May 2024

}}</ref>

* <cite id="limit_3">[[#limit 3 back|Note (3):]]</cite> InnoDB is limited to 8,000 bytes (excluding <code>VARBINARY</code>, <code>VARCHAR</code>, <code>BLOB</code>, or <code>TEXT</code> columns).<ref name = "MySQL column count limit">{{Citation

| chapter-url = https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html

Line 2,907 ⟶ 2,908:

| title = Library

| chapter = Spatial Indexing Overview

| date = 4 October 2012

}}</ref>

| {{dunno}}

| {{no}}

Line 3,000 ⟶ 3,002:

}}</ref> and, since v5.7.5, InnoDB tables<ref>{{Citation

| publisher = Oracle

| series = MySQL

| url = https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-5.html#mysqld-5-7-5-spatial-support

| title = Changes in MySQL 5.7.5

Line 3,699 ⟶ 3,700:

| title = Library

| chapter = SQL Server Parallel Query Processing

| date = 4 October 2012

}}</ref>

| {{yes}}<ref name="system-versioning"/>

Line 4,227 ⟶ 4,229:

| chapter-url = http://msdn.microsoft.com/en-us/library/ms187752.aspx

| chapter = SQL Server Data Types

| date = 21 May 2024

}}</ref>

| Static

| {{mono|TINYINT}}, {{mono|SMALLINT}}, {{mono|INT}}, {{mono|BIGINT}}

Line 4,244 ⟶ 4,247:

| chapter-url = http://msdn.microsoft.com/en-us/library/ms172424.aspx

| chapter = SQL Server Compact Data Types

| date = 24 March 2011

}}</ref>

| Static

| {{mono|TINYINT}}, {{mono|SMALLINT}}, {{mono|INT}}, {{mono|BIGINT}}