Comparison of relational database management systems: Difference between revisions

Revision as of 00:54, 11 July 2024

Revision as of 01:00, 11 July 2024

Line 63:

| 2023-11-14

| {{free|[[Apache license|Apache License]]}}

| {{Yes}}<ref>[{{Cite web|url=https://issues.apache.org/jira/projects/DERBY Derby |title=- ASF JIRA]|website=issues.apache.org}}</ref>

|-

! [[Clustrix]]DB

Line 87:

| 2023-01-31

| {{free|[[Apache license|Apache License]] 2.0, BSD license for APIs and GUI tools}}

| {{Yes}}<ref>[{{Cite web|url=http://jira.cubrid.org/browse/TOOLS-4308?jql=|title=Issue CUBRIDNavigator /- JiraCUBRID IssueBug trackerTracking for CUBRID]System|website=jira.cubrid.org}}</ref>

|-

! [[CA Datacom|Datacom]]

Line 190:

| 2022-06-13

| {{free|[[Eclipse Public License|EPL]] and modified [[Mozilla Public License|MPL]]}}

| {{Yes}}<ref>[{{Cite web|url=https://github.com/h2database/h2database/issues|title=Issues h2database· issues]h2database/h2database|website=GitHub}}</ref>

|-

! [[Informix Dynamic Server]]

Line 244:

| title = MariaDB licenses

}}</ref>}}

| {{Yes}}<ref>[{{Cite web|url=https://jira.mariadb.org/projects/MDEV/issues MariaDB |title=- JIRA]Jira|website=jira.mariadb.org}}</ref>

|-

! [[MaxDB]]

Line 252:

| 2014

| {{Proprietary}}

| {{Yes}}<ref>[http{{Cite web|url=https://maxdb.sap.com/webpts /|title=MaxDB PTS - Problem Tracking]|website=maxdb.sap.com}}</ref>

|-

![[SingleStore|SingleStore (formerly MemSQL)]]

Line 339:

| {{wikidata|qualifier|raw|Q850|P548=Q2804309|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q850|P548=Q2804309|P348|P577}}}}

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

| {{Yes}}<ref>[{{Cite web|url=https://bugs.mysql.com/ |title=MySQL Bugs]|website=bugs.mysql.com}}</ref>

|-

! [[NexusDB]]

Line 453:

|website=PostgreSQL

|access-date=2023-11-29}}</ref>

| {{free|[[Postgres License]]}}<ref>[{{Cite web|url=https://www.postgresql.org/about/licence/ Postgres|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>

|-

! [[R:Base]]

Line 502:

| {{wikidata|qualifier|raw|Q319417|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q319417|P348|P577}}}}

| {{free|[[Public ___domain]]}}

| {{Yes}}<ref>[http{{Cite web|url=https://www.sqlite.org/src/reportlist |title=SQLite: Ticket Main Menu]|website=www.sqlite.org}}</ref>

|-

! [[SQream DB]]

Line 802:

| {{no}}

| {{partial}}

| {{yes}}<ref>{{Cite web|url=https://docs.actian.com/ingres/11.0/index.html#page/Ing_Install/Install_Ingres_for_OpenVMS.htm|title=Ingres 11.0 Documentation|website=docs.actian.com}}</ref>

| {{no}}

| {{no}}

Line 1,305:

| {{yes}}

| {{yes}}

| {{yes}} (Row-level locking) <ref>[{{Cite web|url=https://db.apache.org/derby/docs/10.14/devguide/cdevconcepts23810.html Derby Developer's Guide (10.14)>|title=Lock granularity]|website=db.apache.org}}</ref>

| {{dunno}}

| {{yes}}

Line 1,454:

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

| {{yes}}

| {{yes}}^{[[#feat 2|2]]} except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL">[{{Cite web|url=https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis |title=Transactional DDL in PostgreSQL: A Competitive Analysis] - PostgreSQL wiki|website=wiki.postgresql.org}}</ref><ref name="Transactional DDL in MariaDB">[{{Cite web|url=https://jira.mariadb.org/browse/MDEV-4259|title=[MDEV-4259] Transactionaltransactional DDL in- MariaDB]Jira|website=jira.mariadb.org}}</ref>

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

| {{yes}}

Line 1,495:

| {{yes}}

| {{yes}}

| {{yes}} (Row-level locking)<ref>[{{Cite web|url=https://technet.microsoft.com/en-us/library/jj856598.aspx |title=SQL Server Transaction Locking and Row Versioning Guide]}}</ref>

| {{yes}}

| {{yes}}

Line 1,565:

| {{yes}}

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

| {{yes}} (Row-level locking)<ref>[{{Cite web|url=http://www.dba-oracle.com/t_locks_row_level_locking_update.htm Oracle Row Lock and Row Level Locking]|title=dba-oracle.com}}</ref>

| {{yes}}

| {{yes}}

Line 1,609:

| {{yes}}

| [[API]] & [[graphical user interface|GUI]] & [[SQL]]

| {{No}}<ref>[{{Cite web|url=https://www.postgresql.org/message-id/9799.1302719551%40sss.pgh.pa.us|title=Re: BUG #5974: UNION construct type cast gives poor error message]|first=Tom|last=Lane|date=April 13, 2011|website=PostgreSQL Mailing List Archives}}</ref>

|-

! [[SAP HANA]]

Line 1,635:

| {{yes}}

| {{yes}}

| {{yes}} (Row-level locking)<ref>{{Cite web|url=[https://help.sap.com/viewer/e38b2f6217f24bdb90a3ff8ae57b1dd5/17.0/en-US/3bee03b56c5f1014ab68e3eff32515dd.html |title=SAP SQLHelp Anywhere Reference - Types of Lock]Portal|website=help.sap.com}}</ref>

| {{yes}}<ref>[{{Cite web|url=https://help.sap.com/viewer/e38b2f6217f24bdb90a3ff8ae57b1dd5/17.0/en-US/3bf0656e6c5f1014bb32fe2f7ce00302.html |title=SAP SQL AnywhereHelp Reference - Snapshot Isolation]{{dead linkPortal|datewebsite=July 2024help.sap.com}}</ref>

| {{yes}}

| [[API]] & [[graphical user interface|GUI]] & [[HTTP|HTTP(S)]] (REST & SOAP)<ref>https://help.sap.com/viewer/98ad9ec940e2465695685d98e308dff5/17.0/en-US/3bd460b56c5f10148922c11d39abc0b3.html | SAP SQL Anywhere Reference - HTTP Web Services</ref> & [[SQL]]

Line 1,655:

| {{yes}}

| {{yes}}

| {{no}} (Database-level locking)<ref>[{{Cite web|url=https://www.sqlite.org/lockingv3.html |title=File Locking And Concurrency In SQLite Version 3]|website=www.sqlite.org}}</ref>

| {{no}}

| {{optional}}<ref>[http://www.sqlite.org/faq.html#q18 SQLite Full Unicode support is optional and not installed by default in most systems] (like [[Android (operating system)|Android]], [[Debian]]...)</ref>

Line 1,685:

| {{yes}}

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

| {{yes}} (Row-level locking)<ref>[{{Cite web|url=https://docs.pingcap.com/tidb/stable/basic-features /|title=TiDB Features]|website=docs.pingcap.com}}</ref>

| {{yes}}

| {{yes}}

Line 2,169:

| 254

|-

! style="text-align:left" | [[SQL Anywhere]]<ref>[{{Cite web|url=https://help.sap.com/viewer/61ecb3d4d8be4baaa07cc4db0ddb5d0a/17.0/en-US/813836f16ce210149e89f219dc353b7e.html |title=SAP SQL Anywhere - Physical limitations on size and number of databases]{{deadHelp linkPortal|datewebsite=July 2024help.sap.com}}</ref>

| 104 TB (13 files, each file up to 8 TB (32 KB pages))

| Limited by file size

Line 3,045:

}}</ref>

| {{dunno}}

| {{yes}}<ref>[{{Cite web|url=https://www.techonthenet.com/oracle/errors/ora01408.php |title=Oracle / PLSQL: ORA-01408 Error Message]|website=www.techonthenet.com}}</ref>

|-

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

Line 3,163:

|-

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

| {{yes}}<ref>[{{Cite web|url=http://www.sqlite.org/rtree.html |title=The SQLite R*Tree Module]|website=www.sqlite.org}}</ref>

| {{no}}

| {{yes}}<ref>[http{{Cite web|url=https://sqlite.org/expridx.html|title=Indexes SQLiteOn Expression Indexes]Expressions|website=sqlite.org}}</ref>

| {{yes}}

| {{no}}

Line 3,171:

| {{no}}

| {{no}}

| {{yes}}<ref>[http{{Cite web|url=https://www.sqlite.org/fts5.html |title=SQLite FTS5 Extension]|website=www.sqlite.org}}</ref>

| style="background:#ffd;"| SpatiaLite<ref>{{Citation

| url = http://www.gaia-gis.it/spatialite/

Line 3,507:

| {{yes}}

| {{yes}}

| {{yes}}<ref name="New Features in HyperSQL 2.2">[{{Cite web|url=http://hsqldb.org/web/features200.html|title=HyperSQL 2.5 New Features in HyperSQL 2|website=hsqldb.2]org}}</ref>

| {{yes}}

| {{yes}}

Line 3,524:

| {{no}}

| {{yes}}

| experimental<ref>[{{Cite web|url=http://h2database.com/html/advanced.html#recursive_queries H2 > |title=Advanced > Recursive Queries]|website=h2database.com}}</ref>

| {{yes}}<ref>[{{Cite web|url=https://www.h2database.com/html/functions.html H2 |title=Functions]|website=www.h2database.com}}</ref>

| {{dunno}}

| {{dunno}}

Line 3,541:

| {{yes}}

| {{yes}}

| {{yes}}<ref>[{{Cite web|url=http://portal.acm.org/citation.cfm?id=382443 |title=Informix parallel data query (PDQ)]{{dead link|first=David|last=Clay|date=JulyJanuary 1, 1993|publisher=IEEE Computer Society Press|pages=71–73|via=ACM Digital 2024Library}}</ref>

| {{dunno}}

Line 3,929:

| {{no}}

| {{yes}}

| {{yes|3.8.3+}}<ref>[http{{Cite web|url=https://sqlite.org/lang_with.html SQLite Query Language:|title=The WITH clause]Clause|website=sqlite.org}}</ref>

| {{yes|3.25+}}<ref>[{{Cite web|url=https://sqlite.org/windowfunctions.html |title=Window Functions]|website=sqlite.org}}</ref>

| {{no}}

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