Comparison of relational database management systems: Difference between revisions

Revision as of 07:56, 21 February 2025

Latest revision as of 11:58, 17 July 2025

(9 intermediate revisions by 4 users not shown)

Line 195:

| [[IBM]] / [[HCLTech|HCL Technologies]]

| <span style="display:none">1981????</span>1980

| 15.0.0.01

| 20242025-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>

| 20222024-05-06

| {{Proprietary}}

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

| {{No}}

|-

Line 297:

| Mimer Information Technology

| 1978

| 11.0.8E9D

| 20242025-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

| Aug2024Mar2025 <ref>{{Cite web|url=https://www.monetdb.org/release-notes/|title = MonetDB Latest Release| date=2627 AugustMarch 20242025 }}</ref>

| 20242025-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=20212025-05-13 |archive-url=https://web.archive.org/web/20210513162053/https://github.com/MonetDB/MonetDB/issues |url-status=dead01 }}</ref>

|-

! [[mSQL]]

Line 424:

| [[Actian]]

| 1982

| v15v16

| 2024-06-30

| 2021

| {{Proprietary}}

| {{No}}

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,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^{[[#ac 1|1]]}

! [[Brute-force attack|Brute-force protection]]

Line 5,215 ⟶ 5,237:

! Run unprivileged^{[[#ac 4|4]]}

! Audit

! {{verth|va=middle|Resource limit}}

! {{verth|va=middle|Separation of duties <br/>([[Role-based access control|RBAC]])^{[[#ac 5|5]]}}}

! {{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^{[[#ac 4|4]]}

! Audit

! {{verth|va=middle|Resource limit}}

! {{verth|va=middle|Separation of duties <br/>([[Role-based access control|RBAC]])^{[[#ac 5|5]]}}}

! {{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.