Comparison of relational database management systems: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 20:36, 16 February 2025 edit 178.235.4.27 (talk) →Data types ← Previous edit		Latest revision as of 11:58, 17 July 2025 edit undo 217.27.182.86 (talk) Latest Mimer SQL release is v11.0.9D.
(12 intermediate revisions by 6 users not shown)
Line 195: \| [[IBM]] / [[HCLTech\|HCL Technologies]] \| <span style="display:none">1981????</span>1980 \| 15.0.0.01 \| ~~2024~~2025-1103-2015 \| {{Proprietary}} \| {{No}} \|- ! [[Ingres (database)\|Ingres]] \| [[Actian(HCLSoftware)]] \| 1974 \| 1112.20.0<ref>{{cite web \| title = Actian X & Ingres - Lifecycle Dates \| url = https://communities.actian.com/s/supportservices/lifecycle-dates/actian-x-ingres }}</ref> \| ~~2022~~2024-05-06 \| {{Proprietary}} ~~\| {{partial\|[[GNU General Public License\|GPL]] and [[Proprietary software\|Proprietary]]}}~~ \| {{No}} \|- Line 297: \| Mimer Information Technology \| 1978 \| 11.0.8E9D \| ~~2024~~2025-1007-2216 \| {{Proprietary}} \| {{No}} Line 305: \| MonetDB Foundation <ref>{{Cite web\|url=https://www.monetdb.org/about-us/monetdb-foundation//\|title = MonetDB Foundation\| date=4 April 2023 }}</ref> \| 2004 \| ~~Aug2024~~Mar2025 <ref>{{Cite web\|url=https://www.monetdb.org/release-notes/\|title = MonetDB Latest Release\| date=2627 ~~August~~March ~~2024~~2025 }}</ref> \| ~~2024~~2025-0803-2627 \| {{free\|Mozilla Public License, version 2.0<ref>{{Citation \| url = https://www.monetdb.org/about-us/privacy-and-legals/ 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~~2025-05-~~13 \|archive-url=https://web.archive.org/web/20210513162053/https://github.com/MonetDB/MonetDB/issues \|url-status=dead~~01 }}</ref> \|- ! [[mSQL]] Line 424: \| [[Actian]] \| 1982 \| ~~v15~~v16 \| 2024-06-30 ~~\| 2021~~ \| {{Proprietary}} \| {{No}} Line 445: \| PostgreSQL Global Development Group \| 1989-06 \| 17.24 \| ~~2024~~2025-1102-21<ref>{{Cite web \|url=https://www.postgresql.org/about/news/postgresql-~~172~~174-~~166~~168-~~1510~~1512-~~1415-1318~~1417-and-~~1222~~1320-released-~~2965~~3018/ \|title=PostgreSQL 17.24, 16.68, 15.1012, 14.~~15, 13.18~~17, and 1213.2220 Released! \|publisher=The PostgreSQL Global Development Group \|date=~~2024~~2025-1102-2120 \|website=PostgreSQL \|access-date=~~2024~~2025-1102-3021}}</ref> \| {{free\|[[Postgres License]]}}<ref>{{Cite web\|url=https://www.postgresql.org/about/licence/\|title=PostgreSQL: License\|website=www.postgresql.org}}</ref> \| {{No}}<ref>{{Cite web\|url=https://lwn.net/Articles/660468/\|title=A bug tracker for PostgreSQL? [LWN.net]\|website=lwn.net}}</ref> Line 561: \| {{No}} \|- ! [[Actian Vector\|Vector]] \| [[Actian(HCLSoftware)]] \| 2010 \| 7.0<ref>{{cite web \| title = Vector - Lifecycle Dates \| url = https://communities.actian.com/s/supportservices/lifecycle-dates/actian-x-ingres }}</ref> \| 2024-12-17 \| {{Proprietary}} \| {{No}} \|- ! [[YugabyteDB]] \| Yugabyte, Inc. Line 569 ⟶ 581: \| {{Yes}}<ref>{{Cite web\|url=https://github.com/YugaByte/yugabyte-db/issues\|title=Issues · yugabyte/Yugabyte-db\|website=[[GitHub]]}}</ref> \|- ! [[Actian Zen (PSQL)]] \| [[Actian]] \| 1982 \| v16 \| 2024-06-30 \| {{Proprietary}} \| {{No}} \|- ! ! Maintainer Line 4,126 ⟶ 4,147: }}</ref> \| {{dunno}} \| {{mono\|INT128}}, {{mono\|INT64}}, {{mono\|INTEGER}}, {{mono\|SMALLINT}} \| {{mono\|DOUBLE}}, {{mono\|FLOAT}} \| {{mono\|DECIMAL}}, {{mono\|NUMERIC}}, {{mono\|DECIMAL}}(38, 4), {{mono\|DECIMAL}}(10, 4) \| {{mono\|BLOB}}, {{mono\|CHAR}}, {{mono\|CHAR(''x'')}} {{mono\|CHARACTER}} {{mono\|SET}} {{mono\|UNICODE_FSS}}, {{mono\|VARCHAR(''x'')}} {{mono\|CHARACTER}} {{mono\|SET}} {{mono\|UNICODE_FSS}}, {{mono\|VARCHAR}} \| {{mono\|BLOB}} {{mono\|SUB_TYPE}} {{mono\|TEXT}}, {{mono\|BLOB}} \| {{mono\|DATE}}, {{mono\|TIME}}, {{mono\|TIMESTAMP}} (without time zone and with time zone) \| {{mono\|BOOLEAN}} \| {{mono\|TIMESTAMP}}, {{mono\|TIMESTAMP WITH TIME ZONE}}, {{mono\|CHAR}}(38), User defined types (Domains) \|- ! style="width:16em" \| Line 4,281 ⟶ 4,302: \| {{mono\|FLOAT}}, {{mono\|FLOAT(''n'')}}, {{mono\|REAL}}, {{mono\|DOUBLE}}, {{mono\|DOUBLE}} {{mono\|PRECISION}} \| {{mono\|DECIMAL}}, {{mono\|NUMERIC}} \| {{mono\|CHAR}}, {{mono\|CHAR(''n'')}}, {{mono\|VARCHAR}}, {{mono\|VARCHAR(''n'')}}, {{mono\|CLOB}}, {{mono\|CLOB(''n'')}}, {{mono\|TEXT}}, {{mono\|STRING}} \| {{mono\|BLOB}}, {{mono\|BLOB(''n'')}} \| {{mono\|DATE}}, {{mono\|TIME}}, {{mono\|TIME}} {{mono\|WITH}} {{mono\|TIME}} {{mono\|ZONE}}, {{mono\|TIMESTAMP}}, {{mono\|TIMESTAMP}} {{mono\|WITH}} {{mono\|TIME}} {{mono\|ZONE}}, {{mono\|INTERVAL}} {{mono\|YEAR}}, {{mono\|INTERVAL}} {{mono\|MONTH}}, {{mono\|INTERVAL}} {{mono\|DAY}}, {{mono\|INTERVAL}} {{mono\|HOUR}}, {{mono\|INTERVAL}} {{mono\|MINUTE}}, {{mono\|INTERVAL}} {{mono\|SECOND}} \| {{mono\|BOOLEAN}} \| {{mono\|JSON}}, {{mono\|JSON(''n'')}}, {{mono\|URL}}, {{mono\|URL(''n'')}}, {{mono\|INET}}, {{mono\|UUID}}, {{mono\|GIS}} data types ({{mono\|Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon}}), User Defined Types Line 5,205 ⟶ 5,226: ==Access control== Information about access control functionalities. {{sort-under}} {\| style="text-align: center~~; width: 95%~~; font-size: 80%" class="wikitable sortable sort-under" \|- ! ~~! style="width:16em" \|~~ ! Native network encryption<sup>[[#ac 1\|1]]</sup> ! [[Brute-force attack\|Brute-force protection]] Line 5,215 ⟶ 5,237: ! Run unprivileged<sup>[[#ac 4\|4]]</sup> ! Audit ! {{verth\|va=middle\|Resource limit}} ! {{verth\|va=middle\|Separation of duties <br/>([[Role-based access control\|RBAC]])<sup>[[#ac 5\|5]]</sup>}} ! {{verth\|va=middle\|Security Certification}} ! {{verth\|va=middle\|[[Attribute-based access control~~\|Attribute-Based Access Control~~ ]]<br/>(ABAC)]]}} \|- ! style="text-align:left" \| [[4th Dimension (software)\|4D]] Line 5,556 ⟶ 5,578: \| date = September 2022 }}</ref> \| {{yes}} \| {{yes}} Line 5,639 ⟶ 5,660: ! Run unprivileged<sup>[[#ac 4\|4]]</sup> ! Audit ! {{verth\|va=middle\|Resource limit}} ! {{verth\|va=middle\|Separation of duties <br/>(~~[[Role-based access control\|~~RBAC]])<sup>[[#ac 5\|5]]</sup>}} ! {{verth\|va=middle\|Security Certification}} ! {{verth\|va=middle\|[[Attribute-based access control~~\|Attribute-Based Access Control~~ ]]<br/>(ABAC)]]}} \|} * <cite id="ac_1">[[Comparison of relational database management systems#ac 1\|Note (1):]]</cite> Network traffic could be transmitted in a secure way (not clear-text, in general SSL encryption). Precise if option is default, included option or an extra modules to buy.