Content deleted Content added
→General information: CockroachDB |
Latest Mimer SQL release is v11.0.9D. |
||
| (196 intermediate revisions by 70 users not shown) | |||
Line 1:
{{short description|
The following tables compare general and technical information for a number of [[relational database management system]]s. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.
Line 5:
{| class="wikitable sortable"
|-
!
! Maintainer
! First public release date
Line 17:
| 1984
| v16.0
| 2017-01-10<ref>{{Cite web|url=http://www.4d.com/products/lifecycle.html|title = Product Release Life Cycle|date = 10 January 2020}}</ref>
| {{Proprietary}}
| {{No}}
Line 50:
| 7.1.0.1.2
| 2018-03-02
| {{Proprietary}}
| {{No}}
|-
Line 56:
| [[Apache Software Foundation|Apache]]
| 2004
| 10.
| title = Apache Derby: Downloads
| url = http://db.apache.org/derby/derby_downloads.html
| access-date =
}}</ref>
|
| {{free|[[Apache license|Apache License]]}}
| {{Yes}}<ref>
|-
! [[Clustrix
| [[MariaDB|MariaDB Corporation]]
| 2010
Line 76:
| Cockroach Labs
| 2015
|
|
| {{free|BSL,CCL,MIT,BSD}}
| {{Yes}}<ref>
|-
! [[CUBRID]]
| CUBRID
| 2008-11
|
|
| {{free|[[
| {{Yes}}<ref>
|-
! [[CA Datacom|Datacom]]
Line 102:
| date = Oct–Dec 2009
| doi = 10.1109/MAHC.2009.108
|
| issn = 1058-6180
}}</ref>
| 14<ref>{{cite web
| title = CA Datacom - CA Technologies
| url
| access-date = 2014-07-06
| archive-date = 2016-02-14
| archive-url = https://web.archive.org/web/20160214142439/http://www.ca.com/us/opscenter/ca-datacom.aspx
| url-status = dead
}}</ref>
| 2012<ref>{{cite web
Line 115 ⟶ 120:
| {{No}}
|-
! [[IBM
| [[IBM]]
| 1983
| {{wikidata|property|reference|edit|Q431195|P348}}
| {{wikidata|qualifier|raw|Q431195|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q431195|P348|P577}}}}
| {{Proprietary}}
| {{No}}
Line 131 ⟶ 136:
| {{No}}
|-
! [[EXASolution|Exasol]]
| [[EXASOL|EXASOL AG]]
| 2004
|
| 2021-09-15; {{Time ago|2021-09-15}}
| {{Proprietary}}
| {{No}}
Line 150 ⟶ 155:
| Firebird project
| 2000-07-25
| {{wikidata|property|reference|edit|Q261744|P348}}
| {{wikidata|qualifier|raw|Q261744|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q261744|P348|P577}}}}
| {{free|IPL<ref>{{Citation
| url = http://www.firebirdsql.org/index.php?op=doc&id=ipl
Line 161 ⟶ 166:
| publisher = Firebird SQL
}}</ref>}}
| {{Yes}}<ref>
|-
! [[GPUdb]]
Line 174 ⟶ 179:
| HSQL Development Group
| 2001
| 2.
|
| {{free|[[BSD license|BSD]]}}
| {{Yes}}<ref>
|-
! [[H2 (DBMS)|H2]]
| H2 Software
| 2005
|
|
| {{free|[[Eclipse Public License|EPL]] and modified [[Mozilla Public License|MPL]]}}
| {{Yes}}<ref>
|-
! [[Informix Dynamic Server]]
| [[IBM]] / [[HCLTech|HCL Technologies]]
| <span style="display:none">1981????</span>1980
|
|
| {{Proprietary}}
| {{No}}
|-
! [[Ingres (database)|Ingres]]
| [[
| 1974
| 12.0.0<ref>{{cite web
| title = Actian X & Ingres - Lifecycle Dates
| url = https://communities.actian.com/s/supportservices/lifecycle-dates/actian-x-ingres
}}</ref>
| 2024-05-06
| {{Proprietary}}
| {{No}}
|-
! [[InterBase]]
| [[
| 1984
| XE7 v12.0.4.357
Line 217 ⟶ 225:
| 2018-02-15
| {{Proprietary}}
| {{Yes}}<ref>
|-
! [[LucidDB]]
Line 230 ⟶ 238:
| [[MariaDB|MariaDB Community]]
| 2010-02-01
| {{wikidata|property|reference|edit|Q787177|P348|P548=Q2804309}}
| {{wikidata|qualifier|raw|Q787177|P348|P577|P548=Q2804309}}; {{Time ago|{{wikidata|qualifier|raw|Q787177|P348|P577|P548=Q2804309}}}}
| {{free|[[GNU General Public License|GPL]] v2, [[GNU Lesser General Public License|LGPL]] (for client-libraries)<ref name="MariaDB licenses">{{cite web
| url = https://mariadb.com/kb/en/mariadb-license/
| title = MariaDB licenses
}}</ref>}}
| {{Yes}}<ref>
|-
! [[MaxDB]]
Line 244 ⟶ 252:
| 2014
| {{Proprietary}}
| {{Yes}}<ref>
|-
![[SingleStore|SingleStore (formerly MemSQL)]]
Line 273 ⟶ 281:
| [[Microsoft]]
| 1989
| {{wikidata|property|reference|edit|Q215819|P348}}
| {{wikidata|qualifier|raw|Q215819|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q215819|P348|P577}}}}
| {{Proprietary}}
| {{No}}
Line 289 ⟶ 297:
| Mimer Information Technology
| 1978
| 11.0.
|
| {{Proprietary}}
| {{No}}
|-
! [[MonetDB]]
| MonetDB Foundation <ref>{{Cite web|url=https://www.monetdb.org/about-us/monetdb-foundation//|title = MonetDB Foundation| date=4 April 2023 }}</ref>
| 2004
| Mar2025 <ref>{{Cite web|url=https://www.monetdb.org/release-notes/|title = MonetDB Latest Release| date=27 March 2025 }}</ref>
|
| {{free|Mozilla Public License, version 2.0<ref>{{Citation
| url = https://www.monetdb.org/
| publisher = MonetDB
| title = MonetDB License MPL2.0
| date = 8 February 2022
}}</ref>}}
| {{Yes}}<ref>{{Cite web |url=https://github.com/MonetDB/MonetDB/issues |title=MonetDB Issues |website=[[GitHub]] |access-date=2025-05-01 }}</ref>
|-
! [[mSQL]]
Line 310 ⟶ 319:
| 1994
| 4.1<ref>{{Citation
|url
|publisher
|___location
|series
|title
|access-date = 2009-09-13
|archive-date = 2009-10-15
|archive-url = https://web.archive.org/web/20091015100648/http://www.hughes.com.au/products/msql/
|url-status = dead
}}</ref>
| 2017-06-30
| {{Proprietary}}
Line 323 ⟶ 336:
| [[Oracle Corporation]]
| 1995-11
| {{wikidata|property|reference|edit|Q850|P348}}
| {{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>
|-
! [[NexusDB]]
Line 336 ⟶ 349:
| {{No}}
|-
! [[
| [[Hewlett
| 1987
| SQL/MX 3.4
Line 348 ⟶ 361:
| 2013
| 4.1
|
| {{Proprietary}}
| {{No}}
Line 363 ⟶ 376:
| [[Progress Software Corporation]]
| 1984
|
|
| {{Proprietary}}
| {{No}}
Line 374 ⟶ 387:
| 2018-08-15
| {{partial|[[GNU General Public License|GPL]] v2 or [[Proprietary software|Proprietary]]}}
| {{Yes}}<ref>
|-
! [[Oracle Database|Oracle DB]]
| [[Oracle Corporation]]
| 1979-11
| {{wikidata|property|reference|edit|Q185524|P348}}
| {{wikidata|qualifier|raw|Q185524|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q185524|P348|P577}}}}
| {{Proprietary}}
| {{No}}
Line 408 ⟶ 421:
| {{Yes}}
|-
! [[
| [[
| 1982
|
| 2024-06-30
| {{Proprietary}}
| {{No}}
Line 425 ⟶ 438:
| series = Press Release
| publisher = EECatalog
| title = Polyhedra
}}.</ref>
| {{No}}
Line 432 ⟶ 445:
| PostgreSQL Global Development Group
| 1989-06
| 17.4
| 2025-02-21<ref>{{Cite web
|
|title=PostgreSQL 17.4, 16.8, 15.12, 14.17, and 13.20 Released!
|publisher=The PostgreSQL Global Development Group
|date=2025-02-20
|website=PostgreSQL
|access-date=2025-02-21}}</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>
|-
! [[R:Base]]
Line 442 ⟶ 461:
| 10.0
| 2016-05-26
| {{Proprietary}}
| {{No}}
Line 496 ⟶ 499:
| [[D. Richard Hipp]]
| 2000-09-12
| {{wikidata|property|reference|edit
| {{
| {{free|[[Public ___domain]]}}
| {{Yes}}<ref>
|-
! [[SQream DB]]
Line 506 ⟶ 509:
| 2.1<ref>{{Citation
| url = http://docs.sqream.com/2.1/manual/sql_reference.html
| publisher = SQream Technologies
| title = SQream DB Version 2.1 SQL Reference Guide
| access-date = 2018-02-12
| archive-date = 2018-02-12
| archive-url = https://web.archive.org/web/20180212201639/http://docs.sqream.com/2.1/manual/sql_reference.html
| url-status = dead
}}</ref>
| 2018-01-15
Line 527 ⟶ 534:
| 2017
| {{Proprietary}}
| {{Yes}}<
|-
Line 535 ⟶ 542:
| 15
| 2014-04
| {{Proprietary}}
| {{No}}
|-
! [[TiDB]]
| PingCAP Inc.
| 2016
| {{wikidata|property
| {{
| {{free|[[Apache license|Apache License]]}}
| {{Yes}}<ref>
|-
! [[UniData]]
Line 562 ⟶ 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.
| 2018
| {{YugabyteDB version}}
| {{YugabyteDB version|releasedate}}
| {{free|[[Apache license|Apache License]]}}
| {{Yes}}<ref>
|-
! [[Actian Zen (PSQL)]]
| [[Actian]]
| 1982
| v16
| 2024-06-30
| {{Proprietary}}
| {{No}}
|-
!
! Maintainer
! First public release date
Line 581 ⟶ 601:
==Operating system support==
The [[operating system]]s that the RDBMSes can run on.
{|
|-
!
! [[Microsoft Windows|Windows]]
! [[macOS]]
Line 591 ⟶ 611:
! [[AmigaOS]]
! [[z/OS]]
! [[OpenVMS]]
! [[iOS]]
! [[Android (operating system)|Android]]
|-
!
| {{yes}}
| {{yes}}
Line 607 ⟶ 627:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 619 ⟶ 639:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 631 ⟶ 651:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 643 ⟶ 663:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 655 ⟶ 675:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 663 ⟶ 683:
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{no}}
|-
!
| {{no}}
| {{no}}
Line 679 ⟶ 699:
| {{no}}
|-
! [[CockroachDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! [[CUBRID]]
| {{yes}}
| {{partial}}
Line 691 ⟶ 723:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 709 ⟶ 741:
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
|-
!
| {{no}}
| {{no}}
Line 727 ⟶ 759:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
Line 737 ⟶ 770:
| {{Yes}}
| {{No}}
|-
!
| {{yes}}
| {{yes}}
Line 748 ⟶ 780:
| {{partial|Maybe}}
| {{no}}
| {{yes}}<ref>{{Cite web|url=https://www.firebirdsql.org/en/firebird-3-0/|title = Firebird: The true open source database for Windows, Linux, Mac OS X and more}}</ref>
| {{
|-
!
| {{yes}}
| {{yes}}
Line 759 ⟶ 791:
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
!
| {{yes}}
| {{yes}}
Line 771 ⟶ 803:
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{yes}}
|-
!
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}} ([[AIX (operating system)|AIX]])
| {{no}}
| {{no}}
Line 787 ⟶ 819:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 795 ⟶ 827:
| {{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}}
|-
!
| {{yes}}
| {{yes}}
Line 805 ⟶ 837:
| {{no}}
| {{yes}} ([[Solaris (operating system)|Solaris]])
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
|-
!
| {{yes}}
| {{yes}}
Line 823 ⟶ 855:
| {{yes}}
|-
!
| {{yes}}
| {{yes}}
Line 835 ⟶ 867:
| {{no}}
|-
!
| {{yes}}
| {{yes}}<ref>{{cite web
Line 849 ⟶ 881:
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{yes}}<ref>https://play.google.com/store/apps/details?id=com.esminis.server.mariadb&hl=de MariaDB Android Version by Tautvydas Andrikys</ref>
|-
!
| {{yes}}
| {{no}}
Line 867 ⟶ 899:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 879 ⟶ 911:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 891 ⟶ 923:
| {{no}}
|-
!
| {{yes}}
| {{no}}
| {{yes}}<ref>{{Cite web|url=http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux|title = Announcing SQL Server on Linux|date = 7 March 2016}}</ref>
| {{no}}
| {{no}}
Line 903 ⟶ 935:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 915 ⟶ 947:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 923 ⟶ 955:
| {{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}}
|-
|-
!
| {{yes}}
| {{yes}}
Line 940 ⟶ 972:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 948 ⟶ 980:
| {{yes}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{yes}}<ref>http://techotv.com/run-apache-mysql-php-http-web-server-android-os-phone-tablet/ Run Apache, Mysql, Php – Web server on Android mobile or Tablet</ref>
|-
!
| {{yes}}
| {{yes}}
Line 964 ⟶ 996:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 976 ⟶ 1,008:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 988 ⟶ 1,020:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 995 ⟶ 1,027:
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
|-
!
| {{no}}
| {{no}}
Line 1,008 ⟶ 1,040:
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
|-
!
| {{yes}}
| {{yes}} (OEM only)
Line 1,021 ⟶ 1,053:
| {{no}}
| {{no}}
| {{
| {{
|-
!
| {{yes}}
| {{no}}
Line 1,036 ⟶ 1,068:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 1,042 ⟶ 1,074:
| {{yes}}
| {{yes}}
| {{yes}} ([[MorphOS]])<ref>{{Cite web|url=http://aminet.net/package/dev/gg/postgresql632-mos-bin|title=Aminet - dev/Gg/Postgresql632-mos-bin.lha|access-date=2017-03-14|archive-date=2017-03-14|archive-url=https://web.archive.org/web/20170314154720/http://aminet.net/package/dev/gg/postgresql632-mos-bin|url-status=dead}}</ref>
| Under [[Linux on IBM Z]]<ref>{{Cite web |url=http://www.oss4zos.org/mediawiki/index.php?title=PostgreSQL#z.2FOS |title=
| {{no}}
| {{no}}
| {{yes}}
|-
!
| {{yes}}
| {{no}}
Line 1,060 ⟶ 1,092:
| {{no}}
|-
! [[SAP HANA]]
| {{yes}}
| {{no}}
Line 1,096 ⟶ 1,104:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 1,108 ⟶ 1,116:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 1,117 ⟶ 1,125:
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
|-
!
| {{yes}}
| {{no}}
Line 1,132 ⟶ 1,140:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 1,140 ⟶ 1,148:
| {{yes}}
| {{partial|Maybe}}
| {{no}}
| {{Yes}}
| {{Yes}}
|-
!
| {{no}}
| {{no}}
Line 1,156 ⟶ 1,164:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 1,168 ⟶ 1,176:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 1,180 ⟶ 1,188:
| {{no}}
|-
! [[Teradata]]
| {{yes}}
| {{no}}
Line 1,193 ⟶ 1,200:
| {{no}}
|-
! [[TiDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{partial}}
| {{no}}
| {{no}}
| {{no}}
Line 1,205 ⟶ 1,212:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 1,217 ⟶ 1,224:
| {{no}}
|-
!
| {{yes}}
| {{no}}
Line 1,229 ⟶ 1,236:
| {{no}}
|-
!
| {{yes}}
| {{yes}}
Line 1,241 ⟶ 1,248:
| {{no}}
|-
!
! [[Microsoft Windows|Windows]]
! [[macOS]]
Line 1,249 ⟶ 1,256:
! [[AmigaOS]]
! [[z/OS]]
! [[OpenVMS]]
! [[iOS]]
! [[Android (operating system)|Android]]
|}
Line 1,257 ⟶ 1,264:
Information about what fundamental RDBMS features are implemented natively.
{|
|-
!
! [[ACID]]
! [[Referential integrity]]
Line 1,269 ⟶ 1,276:
! [[Type inference]]
|-
!
| {{yes}}
| {{yes}}
Line 1,279 ⟶ 1,286:
| {{Yes}}
|-
!
| {{yes}}
| {{no}}
Line 1,289 ⟶ 1,296:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{Yes
| {{Yes
| {{yes}}
|[[API]] & [[GUI]] & [[SQL]]
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,309 ⟶ 1,316:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,319 ⟶ 1,326:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking) <ref>
| {{dunno}}
| {{yes}}
Line 1,329 ⟶ 1,336:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,339 ⟶ 1,346:
| {{Yes}}
|-
! [[CockroachDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)
| {{
| {{yes}}
| [[SQL]]
| {{No}}
|-
! [[CUBRID]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)
| {{yes}}
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{dunno}}
| {{yes}}
Line 1,359 ⟶ 1,376:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,369 ⟶ 1,386:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,379 ⟶ 1,396:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,389 ⟶ 1,406:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,399 ⟶ 1,416:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}<ref>{{Cite web|url=http://www.h2database.com/html/advanced.html#mvcc|title = Advanced}}</ref>
| {{yes}}
| [[SQL]]
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,416 ⟶ 1,433:
| {{yes}}
| {{yes}}
| [[SQL]], REST, MQ, and [[JSON]]
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,429 ⟶ 1,446:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,439 ⟶ 1,456:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,449 ⟶ 1,466:
| {{Yes}}
|-
!
| {{yes}}
| {{no}}
Line 1,459 ⟶ 1,476:
| {{Yes}}
|-
!
| {{yes}}<sup id="feat_2_back">[[#feat 2|2]]</sup>
| {{yes}}
| {{yes}}<sup>[[#feat 2|2]]</sup> except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL">
| {{yes}} (Row-level locking)
| {{yes}}
Line 1,469 ⟶ 1,486:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,479 ⟶ 1,496:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,489 ⟶ 1,506:
| {{Yes}}
|-
!
| {{Yes}}
| {{Yes}}
Line 1,499 ⟶ 1,516:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
Line 1,509 ⟶ 1,526:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,519 ⟶ 1,536:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,529 ⟶ 1,546:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,539 ⟶ 1,556:
| {{Yes}}
|-
!
| {{yes}}<sup id="feat_2_back">[[#feat 2|2]]</sup>
| {{yes}}<sup id="feat_3_back">[[#feat 3|3]]</sup>
| {{yes}}<sup>[[#feat 2|2]]</sup> except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL"/>
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
Line 1,549 ⟶ 1,566:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}<sup id="feat_6_back">[[#feat 6|6]]</sup>
Line 1,559 ⟶ 1,576:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,569 ⟶ 1,586:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}} except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL" />
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
Line 1,579 ⟶ 1,596:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,589 ⟶ 1,606:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,599 ⟶ 1,616:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,609 ⟶ 1,626:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
| {{No}}<ref>
|-
! [[SAP HANA]]
| {{yes}}
| {{yes}}
Line 1,649 ⟶ 1,646:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,659 ⟶ 1,656:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>{{Cite web|url=https://help.sap.com/viewer/e38b2f6217f24bdb90a3ff8ae57b1dd5/17.0/en-US/3bee03b56c5f1014ab68e3eff32515dd.html
| {{yes}}<ref>
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[HTTP|HTTP(S)]] (REST & SOAP)<ref>{{Cite web|url=https://help.sap.com/
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,679 ⟶ 1,676:
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}} (Database-level locking)<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]]
| [[API]] & [[SQL]]
| {{Yes}}
|-
!
| {{dunno}}
| {{dunno}}
Line 1,696 ⟶ 1,693:
| {{dunno}}
| {{yes}}
| [[GUI]] & [[
| {{Yes}}
|-
!
| {{yes}}
| {{yes}}
Line 1,709 ⟶ 1,706:
| {{Yes}}
|-
! [[TiDB]]
| {{yes}}
| {{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}}
| [[graphical user interface|GUI]] <sup>[[#feat 5|5]]</sup> & [[SQL]]
| {{Yes}}
|-
!
| {{yes}}
| {{no}}
Line 1,729 ⟶ 1,726:
| {{Yes}}
|-
!
| {{yes}}
| {{no}}
Line 1,749 ⟶ 1,746:
![[Type inference]]
|}
* <cite id="feat_1">[[Comparison of relational database management systems#feat 1|Note (1):]]</cite> Currently only supports read uncommitted 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
| url = http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html
| title = MySQL - The InnoDB Storage Engine
Line 1,759 ⟶ 1,754:
| 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
| url = http://dev.mysql.com/doc/refman/5.6/en/create-table.html
| title = MySQL 5.6 Reference Manual
}}</ref>
* <cite id="feat_4">[[Comparison of relational database management systems#feat 4|Note (4):]]</cite> Support for Unicode is new in version 10.0.
* <cite id="
* <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==
Line 1,802 ⟶ 1,793:
| Unlimited
| 16 [[exbibyte|EiB]]
| {{val|65530|u=B|fmt=commas}}
| 65,135 / (10+ AvgFieldNameLength)
| 4 [[gibibyte|GiB]]
Line 1,817 ⟶ 1,808:
| 1,012 (5,000 in views)
| 2,147,483,647 chars
| 254 (
| 64 bits
| 0001-01-01
Line 1,823 ⟶ 1,814:
| 128
|-
! style="text-align:left" | [[Clustrix
| Unlimited
| Unlimited
Line 1,847 ⟶ 1,838:
| 254
|-
! style="text-align:left" | [[IBM
| Unlimited
| {{val|2
| {{val|1048319|u=B|fmt=commas}}
| 1,012
| {{val|2
| {{val|32
| 64 bits
| 0001-01-01
Line 1,861 ⟶ 1,852:
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| Unlimited
| 2<sup>63</sup>
| 2 GB
| 32,767
Line 1,876 ⟶ 1,867:
| Unlimited
| 10,000
| {{N/A}}
| 2 MB
| 128 bits
Line 1,890 ⟶ 1,881:
| 4 GB
| 10,000,000
| 1 billion characters, {{10^|-400}} to {{10^|400}},
| 0001-01-01
| 4000-12-31
Line 1,896 ⟶ 1,887:
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| Unlimited<sup id="limit_1_back">[[#limit 1|1]]</sup>
|
| 65,536 B
| Depends on data types used
| 32 GB
| 32,767 B
|
| 100
| 32768
|
|-
! style="text-align:left" | [[HSQLDB]]
Line 1,944 ⟶ 1,935:
|-
! style="text-align:left" | [[Informix Dynamic Server]]
|
|
| 32,765 bytes (exclusive of large objects)
| 32,765
| 4 TB
| 32,765<sup id="limit_14_back">[[#limit 14|14]]</sup>
| 10<sup>
| 01/01/0001<sup id="limit_10_back">[[#limit 10|10]]</sup>
| 12/31/9999
Line 1,969 ⟶ 1,960:
! style="text-align:left" | [[InterBase]]
|Unlimited<sup id="limit_1_back">[[#limit 1|1]]</sup>
|
| 65,536 B
| Depends on data types used
Line 1,982 ⟶ 1,973:
| Unlimited
| 2<sup>30</sup> rows
| 64 KB (w/o BLOBs),<br />2GB (each BLOB value)
| 250
| 2 GB
Line 1,993 ⟶ 1,984:
! style="text-align:left" | [[MariaDB]]
| Unlimited
| MyISAM storage limits: 256 TB;<br />Innodb storage limits: 64 TB;<br />Aria storage limits: ???
| 64 KB<sup id="limit_3_back">[[#limit 3|3]]</sup>
| 4,096<sup id="limit_4_back">[[#limit 4|4]]</sup>
Line 2,013 ⟶ 2,004:
| 16 MB
| 255
| 64 KB (memo field),<br />1 GB ("OLE Object" field)
| 255 B (text field)
| 32 bits
Line 2,033 ⟶ 2,024:
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| 524,272 TB (32 767 files
16ZB per instance
| 524,272 TB
| 8,060 bytes /
| 1,024 / 30,000(with sparse columns)
| 2 GB / Unlimited (using RBS/FILESTREAM object)
| 2 GB<sup id="limit_6_back">[[#limit 6|6]]</sup>
| 126 bits<sup id="limit_2_back">[[#limit 2|2]]</sup>
Line 2,077 ⟶ 2,068:
| 2 GB
| 128 bits
| -
| 9999-12-31
| 1024
Line 2,094 ⟶ 2,085:
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| 32 TB per instance<br />(Unlimited via elastic cluster)
| DB size (or 32 TB)
| 4 KB
Line 2,106 ⟶ 2,097:
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{val|2|u=PB}} (with standard 8k block)<br />{{val|8|u=PB}} (with max 32k block)<br />{{val|8|u=EB}} (with max 32k block and BIGFILE option)
| 4 GB × block size<br />(with BIGFILE tablespace)
| 8 KB
| 1,000
Line 2,131 ⟶ 2,120:
! Max column name size
|-
! style="text-align:left" | [[
| 4 billion objects
| 256 GB
Line 2,155 ⟶ 2,144:
| 255
|-
! style="text-align:left" | [[PostgreSQL]]<ref>{{cite web
| title = PostgreSQL Limits
| url = https://www.postgresql.org/docs/current/limits.html
| access-date = 2021-05-13
}}</ref>
| Unlimited
| 32 TB
| 1.6 TB
| 250–1600 depending on type
| 1 GB (text, bytea)
<ref>{{cite web
| title = Large Objects: Introduction
| url = https://www.postgresql.org/docs/current/lo-intro.html
| access-date = 2021-05-13
}}</ref>
| 1 GB
| Unlimited
| −4,713
<ref>{{cite web
| title = Date/Time Types
| url = https://www.postgresql.org/docs/current/datatype-datetime.html
| access-date = 2021-05-13
}}</ref>
| 5,874,897
| 63
|-
! style="text-align:left" | [[SAP HANA]]
Line 2,215 ⟶ 2,194:
| 254
|-
! style="text-align:left" | [[SQL Anywhere]]<ref>{{Cite web|url=https://help.sap.com/viewer/61ecb3d4d8be4baaa07cc4db0ddb5d0a/17.0/en-US/813836f16ce210149e89f219dc353b7e.html
| 104 TB (13 files, each file up to 8 TB (32 KB pages))
| Limited by file size
Line 2,228 ⟶ 2,207:
|-
! style="text-align:left" | [[SQLite]]
| 128 TB (2<sup>31</sup> pages
| Limited by file size
| Limited by file size
Line 2,242 ⟶ 2,221:
| Unlimited
| Unlimited
| 64000 wo/lobs<br />(64 GB w/lobs)
| 2,048
| 2 GB
Line 2,275 ⟶ 2,254:
! Max column name size
|}
* <cite id="limit_1">[[#limit 1 back|Note (1):]]</cite> Firebird 2.x maximum database size is effectively unlimited with the largest known database size >980 GB.<ref>
{{Citation
| url = http://www.firebirdsql.org/index.php?op=guide&id=techspec
Line 2,288 ⟶ 2,266:
}}
</ref> Firebird 1.5.x maximum database size: 32 TB.
* <cite id="limit_2">[[#limit 2 back|Note (2):]]</cite> Limit is 10<sup>38</sup> using <code>DECIMAL</code> datatype.<ref>{{Citation
| url = http://msdn.microsoft.com/en-us/library/ms187746.aspx
| publisher = Microsoft
| 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
| publisher = Oracle
Line 2,303 ⟶ 2,280:
| chapter = Column count limit
}}</ref>
* <cite id="limit_4">[[#limit 4 back|Note (4):]]</cite> InnoDB is limited to 1,017 columns.<ref name = "MySQL column count limit" />
* <cite id="
| chapter-url = https://technet.microsoft.com/en-us/library/ms186981.aspx
| publisher = Microsoft
Line 2,314 ⟶ 2,289:
| chapter = Row-Overflow Considerations
}}</ref>
* <cite id="limit_7">[[#limit 7 back|Note (7):]]</cite> When using a page size of 32 KB, and when BLOB/CLOB data is stored in the database file.
* <cite id="
* <cite id="limit_9">[[#limit 9 back|Note (9):]]</cite> Despite the lack of a date datatype, SQLite does include date and time functions,<ref>{{Citation
| chapter-url = http://www.sqlite.org/lang_datefunc.html
| publisher = SQLite
Line 2,325 ⟶ 2,297:
| chapter = Date functions
}}</ref> which work for timestamps between 24 November 4714 B.C. and 1 November 5352.
* <cite id="limit_10">[[#limit 10 back|Note (10):]]</cite> Informix DATETIME type has adjustable range from YEAR only through 1/10000th second. DATETIME date range is 0001-01-01 00:00:00.00000 through 9999-12-31 23:59:59.99999.
* <cite id="
* <cite id="limit_12">[[#limit 12 back|Note (12):]]</cite> The {{val|0.5|u=YB}} limit refers to the storage limit of a single Informix server instance beginning with v15.0. Informix v12.10 and later versions support using sharding techniques to distribute a table across multiple server instances. A distributed Informix database has no upper limit on table or database size.
* <cite id="
* <cite id="limit_14">[[#limit 14 back|Note (14):]]</cite> The LONGLVARCHAR type supports strings up to 4TB.
==Tables and views==
Line 2,365 ⟶ 2,336:
| {{no}}
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[CUBRID]]
| {{
| {{no}} (only common views)
|-
! style="text-align:left" | [[IBM
| {{yes}}
| {{yes}}
Line 2,465 ⟶ 2,436:
| {{yes}}
|-
! style="text-align:left" | [[
| {{yes}}
| {{no}}
Line 2,475 ⟶ 2,446:
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SAP HANA]]
Line 2,501 ⟶ 2,464:
| {{no}}
|-
! style="text-align:left" | [[Superbase database
| {{yes}}
| {{yes}}
Line 2,521 ⟶ 2,484:
! [[Materialized view]]
|}
* <cite id="tb_1">[[#tb 1 back|Note (1):]]</cite> Server provides tempdb, which can be used for public and private (for the session) temp tables.<ref>{{Citation
| url = http://sybooks.sybase.com/onlinebooks/group-as/asg1250e/sag/@Generic__BookTextView/3225;
| archive-url = https://web.archive.org/web/20051023153932/http://sybooks.sybase.com/onlinebooks/group-as/asg1250e/sag/@Generic__BookTextView/3225;
Line 2,530 ⟶ 2,492:
| title = Online books
}}</ref>
* <cite id="tb_2">[[#tb 2 back|Note (2):]]</cite> Materialized views are not supported in Informix; the term is used in IBM's documentation to refer to a temporary table created to run the view's query when it is too complex, but one cannot for example define the way it is refreshed or build an index on it. The term is defined in the Informix Performance Guide.<ref>{{Citation
| publisher = IBM
| url = http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.perf.doc/ids_prf_534.htm
Line 2,537 ⟶ 2,498:
| title = Informix Performance Guide
}}</ref>
* <cite id="tb_4">[[#tb 4 back|Note (4):]]</cite> Materialized views can be emulated using [[stored procedure]]s and triggers.<ref>{{Citation
| publisher = Red Noize
| series = Pure
Line 2,548 ⟶ 2,508:
|year=2005
}}</ref>
==Indexes==
Line 2,570 ⟶ 2,524:
! [[Full text search|Full-text]]
! [[Spatial index|Spatial]]
!
! Duplicate index prevention
|-
Line 2,649 ⟶ 2,603:
| {{no}}
|-
! style="text-align:left" | [[Clustrix
| {{no}}
| {{yes}}
Line 2,668 ⟶ 2,622:
| {{yes}}<ref name="CUBRID 9.0 release">{{cite web
| url = http://www.cubrid.org/blog/news/announcing-cubrid-9-0-with-3x-performance-increase-and-sharding-support/
| title = CUBRID 9.0 release
| access-date = 2013-02-05
| archive-date = 2013-02-14
| archive-url = https://web.archive.org/web/20130214205927/http://www.cubrid.org/blog/news/announcing-cubrid-9-0-with-3x-performance-increase-and-sharding-support
| url-status = dead
}}</ref>
| {{yes}}<ref name="CUBRID 9.0 release"/>
Line 2,680 ⟶ 2,638:
| {{no}}
|-
! style="text-align:left" | [[IBM
| {{Yes}}
| {{Yes}}
Line 2,693 ⟶ 2,651:
| publisher = IBM
| series = Developer Works
| title = Full-text search with
}}</ref>
| {{dunno}}
Line 2,731 ⟶ 2,689:
| {{no}}
| {{yes}}
| {{
| {{yes}}
| {{no}}
Line 2,795 ⟶ 2,753:
| {{yes}}
| {{yes}}<ref>{{Citation
| publisher = IBM
| url = https://www.ibm.com/docs/en/informix-servers/15.0.0?topic=indexes-forest-trees
|
| date = 19 November 2024
}}</ref>
| {{yes}}
Line 2,972 ⟶ 2,930:
| title = Library
| chapter = Spatial Indexing Overview
| date = 4 October 2012
}}</ref>
| {{dunno}}
| {{no}}
Line 3,065 ⟶ 3,024:
}}</ref> and, since v5.7.5, InnoDB tables<ref>{{Citation
| publisher = Oracle
| 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,109 ⟶ 3,067:
}}</ref>
| {{dunno}}
| {{yes}}<ref>
|-
! style="text-align:left" | [[Oracle Rdb]]
Line 3,125 ⟶ 3,083:
| {{no}}
|-
! style="text-align:left" | [[
| {{no}}
| {{no}}
Line 3,160 ⟶ 3,118:
| {{yes}}<sup id="idx_7_back">[[#idx 7|7]]</sup>
| {{yes}}
| {{yes}}<ref>{{Citation
| publisher = PostgreSQL community
| series = Documentation
| url = https://www.postgresql.org/docs/current/indexes-types.html
| title = Index Types
| date = 11 November 2021
}}</ref>
| {{yes}}
| {{yes}}<ref>{{Citation
| publisher = PostgreSQL community
| series = Documentation
| url = https://www.postgresql.org/docs/
| title = Full Text Search
| date = 11 November 2021
}}</ref>
| style="background:#ffd;"| PostGIS<ref>{{Citation
| publisher = The PostGIS
| series
|
| title = Building Spatial
|
| archive-date = 2021-05-03
| archive-url = https://web.archive.org/web/20210503205533/https://postgis.net/docs/postgis_usage.html#build-indexes
| url-status = dead
}}</ref>
| {{no}}
| {{no}}
Line 3,249 ⟶ 3,189:
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}<ref>
| {{no}}
| {{yes}}<ref>
| {{yes}}
| {{no}}
Line 3,257 ⟶ 3,197:
| {{no}}
| {{no}}
| {{yes}}<ref>
| style="background:#ffd;"| SpatiaLite<ref>{{Citation
| url
| publisher = Gaia GIS 2.3.1
| place = IT
| title = SpatiaLite
| access-date = 2010-12-06
| archive-date = 2011-07-22
| archive-url = https://web.archive.org/web/20110722033735/http://www.gaia-gis.it/spatialite/
| url-status = dead
}}</ref>
| {{dunno}}
Line 3,325 ⟶ 3,269:
! [[Full text search|Full-text]]
! [[Spatial index|Spatial]]
!
! Duplicate index prevention
|}
* <cite id="idx_1">[[#idx 1 back|Note (1):]]</cite> The users need to use a function from freeAdhocUDF library or similar.<ref>{{Citation
| url = http://www.udf.adhoc-data.de/index_eng.html
| publisher = Ad Hoc Data
| title = UDF
| access-date = 2007-01-11
| archive-date = 2019-09-14
| archive-url = https://web.archive.org/web/20190914222246/http://www.udf.adhoc-data.de/index_eng.html
| url-status = dead
}}</ref>
* <cite id="idx_2">[[#idx 2 back|Note (2):]]</cite> Can be implemented for most data types using expression-based indexes.
* <cite id="
| series = MSDN
| chapter-url = http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_8os3.asp
Line 3,358 ⟶ 3,303:
| page = 300
}}</ref>).
* <cite id="idx_4">[[#idx 4 back|Note (4):]]</cite> Used for InMemory ColumnStore index, temporary hash index for hash join, Non/Cluster & fill factor.
* <cite id="
| publisher = Oracle
| chapter-url = http://dev.mysql.com/doc/refman/5.0/en/innodb-adaptive-hash.html
Line 3,368 ⟶ 3,311:
| series = Development documentation
}}</ref> entries as needed.
* <cite id="idx_6">[[#idx 6 back|Note (6):]]</cite> Can be implemented using Function-based Indexes in Oracle 8i and higher, but the function needs to be used in the sql for the index to be used.
* <cite id="
* <cite id="idx_10">[[#idx 10 back|Note (10):]]</cite> B+ tree and full-text only for now.
* <cite id="
* <cite id="idx_12">[[#idx 12 back|Note (12):]]</cite> FOT or Forest of Trees indexes is a type of B-tree index consisting of multiple B-trees which reduces contention in multi-user environments.<ref>{{Citation
| publisher = IBM
| chapter-url =https://www.ibm.com/docs/en/informix-servers/15.0.0?topic=indexes-forest-trees =
| title = Informix 15.0 online documentation
| chapter = Forest of Trees
| series = Development documentation
}}</ref>
==Database capabilities==
Line 3,382 ⟶ 3,328:
! style="width:16em" |
! [[Union (SQL)|Union]]
! [[Intersect (
! [[Except (SQL)|Except]]
! [[Inner join]]s
Line 3,388 ⟶ 3,334:
! Inner selects
! [[Join (SQL)#Merge join|Merge joins]]
! [[Binary large object|Blobs]] and [[Character large object|
! [[Common table expressions
! [[Window function (SQL)|Windowing
! Parallel
! [[Temporal database|System-versioned
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
Line 3,483 ⟶ 3,429:
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
Line 3,507 ⟶ 3,453:
| {{yes}}
| {{yes}}
| {{
| {{yes}}<ref name="CUBRID 9.0 release"/>
| {{dunno}}
Line 3,513 ⟶ 3,459:
|-
! style="text-align:left" | [[IBM
| {{yes}}
| {{yes}}
Line 3,531 ⟶ 3,477:
| chapter = Article
}}</ref>
| {{yes}}<ref name="system-versioning">{{cite web |url=https://modern-sql.com/blog/2018-08/whats-new-in-mariadb-10.3#3.system-versioned-tables |title = What's new in MariaDB 10.3}}</ref>
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
Line 3,585 ⟶ 3,531:
| {{yes}}
| {{yes}}
| {{yes}}<ref name="New Features in HyperSQL 2.2">
| {{yes}}
| {{yes}}
Line 3,602 ⟶ 3,548:
| {{no}}
| {{yes}}
| experimental<ref>
| {{yes}}<ref>
| {{dunno}}
| {{dunno}}
Line 3,619 ⟶ 3,565:
| {{yes}}
| {{yes}}
| {{yes}}<ref>
| {{dunno}}
Line 3,632 ⟶ 3,578:
| {{yes}}
| {{yes}}
| {{yes}}<ref>{{cite web | url=https://docs.actian.com/ingres/10S/index.html#page/RelSum%2FCommon_Table_Expressions.htm | title=Ingres }}</ref>
| {{yes}}<ref>{{cite web | url=https://docs.actian.com/ingres/10.2/index.html#page/RelSum%2FWindow_Functions.htm | title=Ingres }}</ref>
| {{yes}}<ref>{{cite web | url=https://docs.actian.com/ingres/10s/index.html#page/DatabaseAdmin/Parallel_Query_Execution.htm | title=Ingres }}</ref>
| {{dunno}}
Line 3,759 ⟶ 3,705:
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
Line 3,778 ⟶ 3,724:
| title = Library
| chapter = SQL Server Parallel Query Processing
| date = 4 October 2012
}}</ref>
| {{yes}}<ref name="system-versioning"/>
Line 3,829 ⟶ 3,776:
! style="text-align:left" | [[MySQL]]
| {{yes}}
| {{yes|8+}}<ref name="intersect_in_mysql">{{Cite web |url=https://dev.mysql.com/doc/refman/8.0/en/intersect.html |title=INTERSECT |website=mysql.com}}</ref>
| {{yes|8+}}<ref name="except_in_mysql">{{Cite web |url=https://dev.mysql.com/doc/refman/8.0/en/except.html |title=EXCEPT |website=mysql.com}}</ref>
| {{yes}}
| {{yes}}
Line 3,843 ⟶ 3,790:
| chapter = Feature request #16244: SQL-99 Derived table WITH clause (CTE)
}}</ref>
| {{
| url = https://dev.mysql.com/doc/refman/8.0/en/window-functions.html
| title = Window Functions
| publisher = mysql.com
| access-date = 20 July 2021
}}</ref>
| {{no}}<ref name="ReferenceA"/>
| {{no}}<ref name="system-versioning"/>
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
Line 3,894 ⟶ 3,832:
| title = Parallel Query
}}</ref>
| {{yes}}<ref>{{Cite web|title=New Features Oracle 12.1.0.1|url=https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/Changes-in-This-Release-for-Oracle-Database-SQL-Language-Reference.html#GUID-10675CB5-32F6-4E2B-8D01-A9C6B9649839|url-status=live|archive-url=https://web.archive.org/web/20201025063656/https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/Changes-in-This-Release-for-Oracle-Database-SQL-Language-Reference.html |archive-date=2020-10-25 }}</ref>
|-
! style="text-align:left" | [[Oracle Rdb]]
Line 3,912 ⟶ 3,849:
|-
! style="text-align:left" | [[
| {{yes}}
| {{no}}
Line 3,954 ⟶ 3,891:
| {{yes}}
| {{yes}}<ref>{{Citation
| url = https://
| publisher = PostgreSQL
| title = Parallel Query
| date = 11 August 2022
}}</ref>
| {{no}}<ref name="system-versioning"/>
|-
Line 4,041 ⟶ 3,949:
| {{yes}}
| {{yes}}
| {{yes|3.43.0+}}<ref>{{Cite web|url=https://www.sqlite.org/releaselog/3_43_0.html|title=SQLite Release 3.43.0 On 2023-08-24|website=sqlite.org}}</ref>
| {{yes}}
| {{no}}
| {{yes}}
| {{yes|3.8.3+}}<ref>
| {{yes|3.25+}}<ref>
| {{no}}
| {{no}}<ref name="system-versioning"/>
Line 4,104 ⟶ 4,012:
! Inner selects
! [[Join (SQL)#Merge join|Merge joins]]
! [[Binary large object|Blobs]] and [[Character large object|
! [[Common table expressions
! [[Window function (SQL)|Windowing
! Parallel
! [[Temporal database|System-versioned
|}
* <cite id="capa_1">[[#capa 1 back|Note (1):]]</cite> Recursive CTEs introduced in 11gR2 supersedes similar construct called CONNECT BY.
==Data types==
Line 4,132 ⟶ 4,038:
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| Static
| {{mono|UUID}} (16-bit), {{mono|SMALLINT}} (16-bit), {{mono|INT}} (32-bit), {{mono|BIGINT}} (64-bit), {{mono|NUMERIC}} (64-bit)
| {{mono|REAL}}, {{mono|FLOAT}}
| {{mono|REAL}}, {{mono|FLOAT}}
| {{mono|CLOB}}, {{mono|TEXT}}, {{mono|VARCHAR}}
| {{mono|BIT}}, {{mono|BIT}} {{mono|VARYING}}, {{mono|BLOB}}
| {{mono|DURATION}}, {{mono|INTERVAL}}, {{mono|TIMESTAMP}}
| {{mono|BOOLEAN}}
| {{mono|PICTURE}}
|-
! style="text-align:left" | [[Altibase]]<ref name="Altibase-datatypes">{{Citation
| publisher = Altibase
| series = HDB
| chapter-url
| title = General Reference
| chapter = Data Types
}}</ref>
| Static
| {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|REAL}} (32-bit), {{mono|DOUBLE}} (64-bit)
| {{mono|DECIMAL}}, {{mono|NUMERIC}}, {{mono|NUMBER}}, {{mono|FLOAT}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|CLOB}}
| {{mono|BLOB}}, {{mono|BYTE}}, {{mono|NIBBLE}}, {{mono|BIT}}, {{mono|VARBIT}}
| {{mono|DATE}}
|
| {{mono|GEOMETRY}}
|-
! style="text-align:left" | [[Clustrix
| Static
| {{mono|TINYINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|MEDIUMINT}} (24-bit), {{mono|INT}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|FLOAT}} (32-bit), {{mono|DOUBLE}}
| {{mono|DECIMAL}}
| {{mono|CHAR}}, {{mono|BINARY}}, {{mono|VARCHAR}}, {{mono|VARBINARY}}, {{mono|TEXT}}, {{mono|TINYTEXT}}, {{mono|MEDIUMTEXT}}, {{mono|LONGTEXT}}
| {{mono|TINYBLOB}}, {{mono|BLOB}}, {{mono|MEDIUMBLOB}}, {{mono|LONGBLOB}}
| {{mono|DATETIME}}, {{mono|DATE}}, {{mono|TIMESTAMP}}, {{mono|YEAR}}
| {{mono|BIT(''1'')}}, {{mono|BOOLEAN}}
| {{mono|ENUM}}, {{mono|SET}},
|-
! style="text-align:left" | [[CUBRID]]<ref name="CUBRID-datatypes">{{Citation
|publisher
|series
|title
|chapter
}}{{Dead link|date=April 2023 |bot=InternetArchiveBot |fix-attempted=yes }}</ref>
| Static
| {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|FLOAT}}, {{mono|REAL}}(32-bit), {{mono|DOUBLE}}(64-bit)
| {{mono|DECIMAL}}, {{mono|NUMERIC}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|CLOB}}
| {{mono|BLOB}}
| {{mono|DATE}}, {{mono|DATETIME}}, {{mono|TIME}}, {{mono|TIMESTAMP}}
| {{mono|BIT}}
| {{mono|MONETARY}}, {{mono|BIT}} {{mono|VARYING}}, {{mono|SET}}, {{mono|MULTISET}}, {{mono|SEQUENCE}}, {{mono|ENUM}}
|-
! style="text-align:left" | [[IBM Db2
| {{dunno}}
| {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|DECFLOAT}}, {{mono|REAL}}, {{mono|DOUBLE}}
| {{mono|DECIMAL}}
| {{mono|CLOB}}, {{mono|CHAR}}, {{mono|VARCHAR}}
| {{mono|BINARY}}, {{mono|VARBINARY}}, {{mono|BLOB}}
| {{mono|DATE}}, {{mono|TIME}}, {{mono|TIMESTAMP}} {{mono|WITH}} {{mono|TIME}} {{mono|ZONE}}, {{mono|TIMESTAMP}} {{mono|WITHOUT}} {{mono|TIME}} {{mono|ZONE}}
| {{mono|BOOLEAN}}
| {{mono|XML}}, {{mono|GRAPHIC}}, {{mono|VARGRAPHIC}}, {{mono|DBCLOB}}, {{mono|ROWID}}
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| Static
| {{mono|TINYINT}}, {{mono|SQL_TINYINT}}, or {{mono|INTEGER8}}; {{mono|SMALLINT}}, {{mono|SQL_SMALLINT}}, or {{mono|INTEGER16}}; {{mono|INTEGER}}, {{mono|INT}}, {{mono|SQL_INTEGER}}, or {{mono|INTEGER32}}; {{mono|BIGINT}}, {{mono|SQL_BIGINT}}, or {{mono|INTEGER64}}
| {{mono|REAL}}, {{mono|SQL_REAL}}, or {{mono|FLOAT32}}; {{mono|DOUBLE}} {{mono|PRECISION}}, {{mono|SQL_DOUBLE}}, or {{mono|FLOAT64}}; {{mono|FLOAT}}, or {{mono|SQL_FLOAT}}; {{mono|EFLOAT}}
| {{mono|DECIMAL}}, {{mono|DEC}}, {{mono|NUMERIC}}, {{mono|SQL_DECIMAL}}, or {{mono|SQL_NUMERIC}}; {{mono|DOLLAR}}
| {{mono|CHARACTER}}, {{mono|ECHARACTER}}, {{mono|CHARACTER}} {{mono|VARYING}}, {{mono|NATIONAL}} {{mono|CHARACTER}}, {{mono|NATIONAL}} {{mono|CHARACTER}} {{mono|VARYING}}, {{mono|NLSCHARACTER}}, {{mono|CHARACTER}} {{mono|LARGE}} {{mono|OBJECT}}, {{mono|TEXT}}, {{mono|NATIONAL}} {{mono|CHARACTER}} {{mono|LARGE}} {{mono|OBJECT}}, {{mono|NLSTEXT}}
| {{mono|BINARY}} {{mono|LARGE}} {{mono|OBJECT}} or {{mono|BLOB}}; {{mono|BULK}}
| {{mono|DATE}}, {{mono|EDATE}}, {{mono|TIME}}, {{mono|ETIME}}, {{mono|EPOCH_TIME}}, {{mono|TIMESTAMP}}, {{mono|MICROTIMESTAMP}}
| {{mono|BOOLEAN}}
| {{mono|SEQUENCE}} 32, {{mono|SEQUENCE}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| Static
| {{mono|TINYINT}}, {{mono|SMALLINT}}, {{mono|INTEGER}}, {{mono|BIGINT}},
| {{mono|REAL}}, {{mono|FLOAT}}, {{mono|DOUBLE}}
| {{mono|DECIMAL}}, {{mono|DEC}}, {{mono|NUMERIC}}, {{mono|NUMBER}}
| {{mono|CHAR}}, {{mono|NCHAR}}, {{mono|VARCHAR}}, {{mono|VARCHAR2}}, {{mono|NVARCHAR}}, {{mono|NVARCHAR2}}, {{mono|CLOB}}, {{mono|NCLOB}}
| {{N/A|N/A}}
| {{mono|DATE}}, {{mono|TIMESTAMP}}, {{mono|INTERVAL}}
| {{mono|BOOLEAN}}, {{mono|BOOL}}
| {{mono|GEOMETRY}}
|-
! style="text-align:left" | [[FileMaker]]<ref>{{cite web
Line 4,225 ⟶ 4,131:
}}</ref>
| Static
| {{N/A|Not Supported}}
| {{N/A|Not Supported}}
| {{mono|NUMBER}}
| {{mono|TEXT}}
| {{mono|CONTAINER}}
| {{mono|TIMESTAMP}}
| {{N/A|Not Supported}}
|
|-
Line 4,241 ⟶ 4,147:
}}</ref>
| {{dunno}}
| {{mono|INT128}}, {{mono|INT64}}, {{mono|INTEGER}}, {{mono|SMALLINT}}
| {{mono|DOUBLE}}, {{mono|FLOAT}}
| {{mono|DECIMAL}}, {{mono|NUMERIC}}, {{mono|DECIMAL}}(
| {{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,269 ⟶ 4,175:
}}</ref>
| Static
| {{mono|TINYINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|DOUBLE}} (64-bit)
| {{mono|DECIMAL}}, {{mono|NUMERIC}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|LONGVARCHAR}}, {{mono|CLOB}}
| {{mono|BINARY}}, {{mono|VARBINARY}}, {{mono|LONGVARBINARY}}, {{mono|BLOB}}
| {{mono|DATE}}, {{mono|TIME}}, {{mono|TIMESTAMP}}, {{mono|INTERVAL}}
| {{mono|BOOLEAN}}
| {{mono|OTHER}} (object), {{mono|BIT}}, {{mono|BIT}} {{mono|VARYING}}, {{mono|ARRAY}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]<ref name="informix-datatypes">{{cite web
Line 4,283 ⟶ 4,189:
| url = http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC=SRX&PBL=SC23-7750-04
| title = IBM Informix Guide to SQL: Reference, v11.50 (SC23-7750-04)
|
| access-date = August 7, 2013
}}</ref>
| Static + {{mono|UDT}}
| {{mono|SMALLINT}} (16-bit), {{mono|INT}} (32-bit), {{mono|INT8}} (64-bit proprietary), {{mono|BIGINT}} (64-bit)
| {{mono|SMALLFLOAT}} (32-bit), {{mono|FLOAT}} (64-bit)
| {{mono|DECIMAL}} (32 decimal digits float/fixed, range {{10^|130}} to +{{10^|125}}), {{mono|MONEY}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|LVARCHAR}}, {{mono|CLOB}}, {{mono|TEXT}}, {{mono|LONGLVARCHAR}}
| {{mono|TEXT}}, {{mono|BYTE}}, {{mono|BLOB}}, {{mono|CLOB}}
| {{mono|DATE}}, {{mono|DATETIME}}, {{mono|INTERVAL}}
| {{mono|BOOLEAN}}
| {{mono|SET}}, {{mono|LIST}}, {{mono|MULTISET}}, {{mono|ROW}}, {{mono|TIMESERIES}}, {{mono|SPATIAL}}, {{mono|GEODETIC}}, {{mono|NODE}}, {{mono|JSON}}, {{mono|BSON}}, {{mono|USER}} {{mono|DEFINED}} {{mono|TYPES}}
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]<ref name="ingres-datatypes">{{Citation
|publisher
|series
|title
|chapter
|access-date = 2009-11-16
|archive-date = 2011-07-13
|archive-url = https://web.archive.org/web/20110713033627/http://docs.ingres.com/Ingres/9.3/SQL%20Reference%20Guide/understandingsqldatatypes.htm#o3623
|url-status = dead
}}</ref>
| Static
| {{mono|TINYINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|FLOAT4}} (32-bit), {{mono|FLOAT}} (64-bit)
| {{mono|DECIMAL}}
| C, {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|LONG}} {{mono|VARCHAR}}, {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|LONG}} {{mono|NVARCHAR}}, {{mono|TEXT}}
| {{mono|BYTE}}, {{mono|VARBYTE}}, {{mono|LONG}} {{mono|VARBYTE}} ({{mono|BLOB}})
| {{mono|DATE}}, {{mono|ANSIDATE}}, {{mono|INGRESDATE}}, {{mono|TIME}}, {{mono|TIMESTAMP}}, {{mono|INTERVAL}}
| {{N/A|N/A}}
| {{mono|MONEY}}, {{mono|OBJECT_KEY}}, {{mono|TABLE_KEY}}, {{mono|USER}}-{{mono|DEFINED}} {{mono|DATA}} {{mono|TYPES}} (via {{mono|OME}})
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| Static + Dynamic (in stored procedures)
| {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|REAL}}(32-bit), {{mono|DOUBLE}}(64-bit)
| {{mono|DECIMAL}}, {{mono|NUMERIC}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|BLOB}}
| {{mono|BYTE}}, {{mono|VARBYTE}}, {{mono|BLOB}}
| {{mono|DATE}}
| {{mono|BOOLEAN}}
| {{mono|GEOMETRY}}, {{mono|EXTFILE}}
|-
! style="text-align:left" | [[MariaDB]]<ref name="mdb_data_types">{{cite web
Line 4,330 ⟶ 4,241:
}}</ref>
| Static
| {{mono|TINYINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|MEDIUMINT}} (24-bit), {{mono|INT}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|FLOAT}} (32-bit), {{mono|DOUBLE}} (aka {{mono|REAL}}) (64-bit)
| {{mono|DECIMAL}}
| {{mono|CHAR}}, {{mono|BINARY}}, {{mono|VARCHAR}}, {{mono|VARBINARY}}, {{mono|TEXT}}, {{mono|TINYTEXT}}, {{mono|MEDIUMTEXT}}, {{mono|LONGTEXT}}
| {{mono|TINYBLOB}}, {{mono|BLOB}}, {{mono|MEDIUMBLOB}}, {{mono|LONGBLOB}}
| {{mono|DATETIME}}, {{mono|DATE}}, {{mono|TIMESTAMP}}, {{mono|YEAR}}
| {{mono|BIT(''1'')}}, {{mono|BOOLEAN}} (aka {{mono|BOOL}}) = synonym for {{mono|TINYINT}}
| {{mono|ENUM}}, {{mono|SET}}, {{mono|GIS}} data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon)
|-
! style="text-align:left" | [[Microsoft SQL Server]]<ref name="sql-server-datatypes">{{Citation
Line 4,345 ⟶ 4,256:
| 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}}
| {{mono|FLOAT}}, {{mono|REAL}}
| {{mono|NUMERIC}}, {{mono|DECIMAL}}, {{mono|SMALLMONEY}}, {{mono|MONEY}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|TEXT}}, {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|NTEXT}}
| {{mono|BINARY}}, {{mono|VARBINARY}}, {{mono|IMAGE}}, {{mono|FILESTREAM}}, {{mono|FILETABLE}}
| {{mono|DATE}}, {{mono|DATETIMEOFFSET}}, {{mono|DATETIME2}}, {{mono|SMALLDATETIME}}, {{mono|DATETIME}}, {{mono|TIME}}
| {{mono|BIT}}
| {{mono|CURSOR}}, {{mono|TIMESTAMP}}, {{mono|HIERARCHYID}}, {{mono|UNIQUEIDENTIFIER}}, {{mono|SQL_VARIANT}}, {{mono|XML}}, {{mono|TABLE}}, Geometry, Geography, Custom .NET datatypes
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]<ref name="sqlce-datatypes">{{Citation
Line 4,362 ⟶ 4,274:
| 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}}
| {{mono|FLOAT}}, {{mono|REAL}}
| {{mono|NUMERIC}}, {{mono|DECIMAL}}, {{mono|MONEY}}
| {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|NTEXT}}
| {{mono|BINARY}}, {{mono|VARBINARY}}, {{mono|IMAGE}}
| {{mono|DATETIME}}
| {{mono|BIT}}
| {{mono|TIMESTAMP}}, {{mono|ROWVERSION}}, {{mono|UNIQUEIDENTIFIER}}, {{mono|IDENTITY}}, {{mono|ROWGUIDCOL}}
|-
! style="text-align:left" | [[Mimer SQL]]
| Static
| {{mono|SMALLINT}}, {{mono|INT}}, {{mono|BIGINT}}, {{mono|INTEGER(''n'')}}
| {{mono|FLOAT}}, {{mono|REAL}}, {{mono|DOUBLE}}, {{mono|FLOAT(''n'')}}
| {{mono|NUMERIC}}, {{mono|DECIMAL}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|NCHAR}}, {{mono|NVARCHAR}}, {{mono|CLOB}}, {{mono|NCLOB}}
| {{mono|BINARY}}, {{mono|VARBINARY}}, {{mono|BLOB}}
| {{mono|DATE}}, {{mono|TIME}}, {{mono|TIMESTAMP}}, {{mono|INTERVAL}}
| {{mono|BOOLEAN}}
| {{mono|DOMAINS}}, {{mono|USER-DEFINED TYPES}} (including the pre-defined spatial data types ___location, latitude, longitude and coordinate, and {{mono|UUID}})
|-
! style="text-align:left" | [[MonetDB]]
| Static, extensible
| {{mono|TINYINT}}, {{mono|SMALLINT}}, {{mono|INT}}, {{mono|INTEGER}}, {{mono|BIGINT}}, {{mono|HUGEINT}}, {{mono|SERIAL}}, {{mono|BIGSERIAL}}
| {{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
|-
! style="text-align:left" | [[MySQL]]<ref name="mysql-datatypes">{{Citation
Line 4,403 ⟶ 4,316:
}}</ref>
| Static
| {{mono|TINYINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|MEDIUMINT}} (24-bit), {{mono|INT}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|FLOAT}} (32-bit), {{mono|DOUBLE}} (aka {{mono|REAL}}) (64-bit)
| {{mono|DECIMAL}}
| {{mono|CHAR}}, {{mono|BINARY}}, {{mono|VARCHAR}}, {{mono|VARBINARY}}, {{mono|TEXT}}, {{mono|TINYTEXT}}, {{mono|MEDIUMTEXT}}, {{mono|LONGTEXT}}
| {{mono|TINYBLOB}}, {{mono|BLOB}}, {{mono|MEDIUMBLOB}}, {{mono|LONGBLOB}}
| {{mono|DATETIME}}, {{mono|DATE}}, {{mono|TIMESTAMP}}, {{mono|YEAR}}
| {{mono|BIT(''1'')}}, {{mono|BOOLEAN}} (aka {{mono|BOOL}}) = synonym for {{mono|TINYINT}}
| {{mono|ENUM}}, {{mono|SET}}, {{mono|GIS}} data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon)
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]<ref name="Virtuoso-datatypes">{{Citation
Line 4,419 ⟶ 4,332:
}}</ref>
| Static + Dynamic
| {{mono|INT}}, {{mono|INTEGER}}, {{mono|SMALLINT}}
| {{mono|REAL}}, {{mono|DOUBLE}} {{mono|PRECISION}}, {{mono|FLOAT}}, {{mono|FLOAT
| {{mono|DECIMAL}}, {{mono|DECIMAL
| {{mono|CHARACTER}}, {{mono|CHAR
| {{mono|BLOB}}
| {{mono|TIMESTAMP}}, {{mono|DATETIME}}, {{mono|TIME}}, {{mono|DATE}}
|
| {{mono|ANY}}, {{mono|REFERENCE}} ({{mono|IRI}}, {{mono|URI}}), {{mono|UDT}} (User Defined Type), {{mono|GEOMETRY}} ({{mono|BOX}}, {{mono|BOX2D}}, {{mono|BOX3D}}, {{mono|BOXM}}, {{mono|BOXZ}}, {{mono|BOXZM}}, {{mono|CIRCULARSTRING}}, {{mono|COMPOUNDCURVE}}, {{mono|CURVEPOLYGON}}, {{mono|EMPTY}}, {{mono|GEOMETRYCOLLECTION}}, {{mono|GEOMETRYCOLLECTIONM}}, {{mono|GEOMETRYCOLLECTIONZ}}, {{mono|GEOMETRYCOLLECTIONZM}}, {{mono|LINESTRING}}, {{mono|LINESTRINGM}}, {{mono|LINESTRINGZ}}, {{mono|LINESTRINGZM}}, {{mono|MULTICURVE}}, {{mono|MULTILINESTRING}}, {{mono|MULTILINESTRINGM}}, {{mono|MULTILINESTRINGZ}}, {{mono|MULTILINESTRINGZM}}, {{mono|MULTIPOINT}}, {{mono|MULTIPOINTM}}, {{mono|MULTIPOINTZ}}, {{mono|MULTIPOINTZM}}, {{mono|MULTIPOLYGON}}, {{mono|MULTIPOLYGONM}}, {{mono|MULTIPOLYGONZ}}, {{mono|MULTIPOLYGONZM}}, {{mono|POINT}}, {{mono|POINTM}}, {{mono|POINTZ}}, {{mono|POINTZM}}, {{mono|POLYGON}}, {{mono|POLYGONM}}, {{mono|POLYGONZ}}, {{mono|POLYGONZM}}, {{mono|POLYLINE}}, {{mono|POLYLINEZ}}, {{mono|RING}}, {{mono|RINGM}}, {{mono|RINGZ}}, {{mono|RINGZM}})
|-
! style="width:16em" |
Line 4,440 ⟶ 4,353:
|-
! style="text-align:left" | [[Oracle Database|Oracle]]<ref name="oracle-datatypes">{{Citation
|publisher
|series
|title
|chapter
|access-date = 2009-09-21
|archive-date = 2010-03-14
|archive-url = https://web.archive.org/web/20100314015040/http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/sql_elements001.htm#i45441
|url-status = dead
}}</ref>
| Static + Dynamic (through {{mono|ANYDATA}})
| {{mono|NUMBER}}
| {{mono|BINARY_FLOAT}}, {{mono|BINARY_DOUBLE}}
| {{mono|NUMBER}}
| {{mono|CHAR}}, {{mono|VARCHAR2}}, {{mono|CLOB}}, {{mono|NCLOB}}, {{mono|NVARCHAR2}}, {{mono|NCHAR}}, {{mono|LONG}} (deprecated)
| {{mono|BLOB}}, {{mono|RAW}}, {{mono|LONG}} {{mono|RAW}} (deprecated), {{mono|BFILE}}
| {{mono|DATE}}, {{mono|TIMESTAMP}} (with/without {{mono|TIME}} {{mono|ZONE}}), {{mono|INTERVAL}}
| {{N/A|N/A}}
| {{mono|SPATIAL}}, {{mono|IMAGE}}, {{mono|AUDIO}}, {{mono|VIDEO}}, {{mono|DICOM}}, XMLType, {{mono|UDT}}, {{mono|JSON}}
|-
! style="text-align:left" | [[
| publisher = Pervasive
| series = Product documentation
Line 4,464 ⟶ 4,381:
}}</ref>
| Static
| {{mono|BIGINT}}, {{mono|INTEGER}}, {{mono|SMALLINT}}, {{mono|TINYINT}}, {{mono|UBIGINT}}, {{mono|UINTEGER}}, {{mono|USMALLINT}}, {{mono|UTINYINT}}
| {{mono|BFLOAT4}}, {{mono|BFLOAT8}}, {{mono|DOUBLE}}, {{mono|FLOAT}}
| {{mono|DECIMAL}}, {{mono|NUMERIC}}, {{mono|NUMERICSA}}, {{mono|NUMERICSLB}}, {{mono|NUMERICSLS}}, {{mono|NUMERICSTB}}, {{mono|NUMERICSTS}}
| {{mono|CHAR}}, {{mono|LONGVARCHAR}}, {{mono|VARCHAR}}
| {{mono|BINARY}}, {{mono|LONGVARBINARY}}, {{mono|VARBINARY}}
| {{mono|DATE}}, {{mono|DATETIME}}, {{mono|TIME}}
| {{mono|BIT}}
| {{mono|CURRENCY}}, {{mono|IDENTITY}}, {{mono|SMALLIDENTITY}}, {{mono|TIMESTAMP}}, {{mono|UNIQUEIDENTIFIER}}
|-
! style="text-align:left" | [[Polyhedra DBMS|Polyhedra]]<ref>
Line 4,486 ⟶ 4,403:
</ref>
| Static
| {{mono|INTEGER8}} (8-bit), {{mono|INTEGER}}(16-bit), {{mono|INTEGER}} (32-bit), {{mono|INTEGER64}} (64-bit)
| {{mono|FLOAT32}} (32-bit), {{mono|FLOAT}} (aka {{mono|REAL}}; 64-bit)
| {{N/A|N/A}}
| {{mono|VARCHAR}}, {{mono|LARGE}} {{mono|VARCHAR}} (aka {{mono|CHARACTER}} {{mono|LARGE}} {{mono|OBJECT}})
| {{mono|LARGE}} {{mono|BINARY}} (aka {{mono|BINARY}} {{mono|LARGE}} {{mono|OBJECT}})
| {{mono|DATETIME}}
| {{mono|BOOLEAN}}
| {{N/A|N/A}}
|-
! style="text-align:left" | [[PostgreSQL]]<ref name="postgresql-datatypes">{{Citation
Line 4,501 ⟶ 4,418:
| title = Manual
| chapter = Data Types
| date = 11 August 2022
}}</ref>
| Static
| {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|REAL}} (32-bit), {{mono|DOUBLE}} {{mono|PRECISION}} (64-bit)
| {{mono|DECIMAL}}, {{mono|NUMERIC}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|TEXT}}
| {{mono|BYTEA}}
| {{mono|DATE}}, {{mono|TIME}} (with/without {{mono|TIME}} {{mono|ZONE}}), {{mono|TIMESTAMP}} (with/without {{mono|TIME}} {{mono|ZONE}}), {{mono|INTERVAL}}
| {{mono|BOOLEAN}}
| {{mono|ENUM}}, {{mono|POINT}}, {{mono|LINE}}, {{mono|LSEG}}, {{mono|BOX}}, {{mono|PATH}}, {{mono|POLYGON}}, {{mono|CIRCLE}}, {{mono|CIDR}}, {{mono|INET}}, {{mono|MACADDR}}, {{mono|BIT}}, {{mono|UUID}}, {{mono|XML}}, {{mono|JSON}}, {{mono|JSONB}}, arrays, composites, ranges, custom
|-
! style="text-align:left" | [[SAP HANA]]
| Static
| {{mono|TINYINT}}, {{mono|SMALLINT}}, {{mono|INTEGER}}, {{mono|BIGINT}}
| {{mono|SMALLDECIMAL}}, {{mono|REAL}}, {{mono|DOUBLE}}, {{mono|FLOAT}}, {{mono|FLOAT(''n'')}}
| {{mono|DECIMAL}}
| {{mono|VARCHAR}}, {{mono|NVARCHAR}}, {{mono|ALPHANUM}}, {{mono|SHORTTEXT}}
| {{mono|VARBINARY}}, {{mono|BINTEXT}}, {{mono|BLOB}}
| {{mono|DATE}}, {{mono|TIME}}, {{mono|SECONDDATE}}, {{mono|TIMESTAMP}}
| {{mono|BOOLEAN}}
| {{mono|CLOB}}, {{mono|NCLOB}}, {{mono|TEXT}}, {{mono|ARRAY}}, {{mono|ST_GEOMETRY}}, {{mono|ST_POINT}}, {{mono|ST_MULTIPOINT}}, {{mono|ST_LINESTRING}}, {{mono|ST_MULTILINESTRING}}, {{mono|ST_POLYGON}}, {{mono|ST_MULTIPOLYGON}}, {{mono|ST_GEOMETRYCOLLECTION}}, {{mono|ST_CIRCULARSTRING}}
|-
! style="text-align:left" | [[solidDB]]
| Static
| {{mono|TINYINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|REAL}} (32-bit), {{mono|DOUBLE}} (64-bit), {{mono|FLOAT}} (64-bit)
| {{mono|DECIMAL}}, {{mono|NUMERIC}} (51 digits)
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|LONG}} {{mono|VARCHAR}}, {{mono|WCHAR}}, {{mono|WVARCHAR}}, {{mono|LONG}} {{mono|WVARCHAR}}
| {{mono|BINARY}}, {{mono|VARBINARY}}, {{mono|LONG}} {{mono|VARBINARY}}
| {{mono|DATE}}, {{mono|TIME}}, {{mono|TIMESTAMP}}
|
|
|-
! style="text-align:left" | [[SQLite]]<ref name="sqlite-datatypes">{{Citation
Line 4,572 ⟶ 4,458:
}}</ref>
| Dynamic
| {{mono|INTEGER}} (64-bit)
| {{mono|REAL}} (aka {{mono|FLOAT}}, {{mono|DOUBLE}}) (64-bit)
| {{N/A|N/A}}
| {{mono|TEXT}} (aka {{mono|CHAR}}, {{mono|CLOB}})
| {{mono|BLOB}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
|-
! style="text-align:left" | [[SQream DB]]<ref name="sqreamdb-datatypes">{{Citation
Line 4,587 ⟶ 4,473:
}}</ref>
| Static
| {{mono|TINYINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|REAL}} (32-bit), {{mono|DOUBLE}} (aka {{mono|FLOAT}}) (64-bit)
| {{N/A|N/A}}
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|NVARCHAR}}
| {{N/A|N/A}}
| {{mono|DATE}}, {{mono|DATETIME}} (aka {{mono|TIMESTAMP}})
| {{mono|BOOL}}
| {{N/A|N/A}}
|-
! style="width:16em" |
Line 4,609 ⟶ 4,495:
! style="text-align:left" | [[Teradata]]
| Static
| {{mono|BYTEINT}} (8-bit), {{mono|SMALLINT}} (16-bit), {{mono|INTEGER}} (32-bit), {{mono|BIGINT}} (64-bit)
| {{mono|FLOAT}} (64-bit)
| {{mono|DECIMAL}}, {{mono|NUMERIC}} (38 digits)
| {{mono|CHAR}}, {{mono|VARCHAR}}, {{mono|CLOB}}
| {{mono|BYTE}}, {{mono|VARBYTE}}, {{mono|BLOB}}
| {{mono|DATE}}, {{mono|TIME}}, {{mono|TIMESTAMP}} (w/wo {{mono|TIME}} {{mono|ZONE}})
|
| {{mono|PERIOD}}, {{mono|INTERVAL}}, {{mono|GEOMETRY}}, {{mono|XML}}, {{mono|JSON}}, {{mono|UDT}} (User Defined Type)
|-
! style="text-align:left" | [[UniData]]
| Dynamic
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
|-
! style="text-align:left" | [[UniVerse]]
| Dynamic
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
| {{N/A|N/A}}
|-
! |
Line 4,657 ⟶ 4,543:
|-
! style="width:16em" |
! [[Data
! [[Cursor (databases)|Cursor]]
! [[Database trigger|Trigger]]
! [[Function (computer programming)|Function]]
! [[Subroutine|Procedure]]
! External routine
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
Line 4,708 ⟶ 4,594:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Clustrix
| {{no}}
| {{yes}}
Line 4,725 ⟶ 4,611:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
Line 4,744 ⟶ 4,630:
| {{yes}}
|-
! style="text-align:left" | [[IBM
| {{yes}} via CHECK CONSTRAINT
| {{yes}}
Line 4,771 ⟶ 4,657:
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
Line 4,782 ⟶ 4,668:
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
Line 4,812 ⟶ 4,698:
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[MariaDB]]
| {{yes}}<ref name="constraint_in_mariadb">{{Cite web |url=https://mariadb.com/kb/en/library/constraint/#check-constraints |title=
| {{yes}}
| {{yes}}
Line 4,849 ⟶ 4,735:
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
| {{yes}}
Line 4,881 ⟶ 4,767:
|-
! style="text-align:left" | [[MySQL]]
| {{no}}
| {{yes}}
| {{yes}}
Line 4,920 ⟶ 4,798:
| {{yes}}
|-
! style="text-align:left" | [[
| {{yes}}
| {{yes}}
Line 4,941 ⟶ 4,819:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
Line 5,017 ⟶ 4,879:
|-
! |
! [[Data
! [[Cursor (databases)|Cursor]]
! [[Database trigger|Trigger]]
! [[Function (computer programming)|Function]]
! [[Subroutine|Procedure]]
! External routine
|}
* <cite id="other_1">[[#other 1 back|Note (1):]]</cite> Both '''function''' and '''procedure''' refer to internal routines written in SQL and/or procedural language like [[PL/SQL]]. '''External routine''' refers to the one written in the host languages, such as C, Java, Cobol, etc. "[[Stored procedure]]" is a commonly used term for these routine types. However, its definition varies between different database vendors.
* <cite id="other_2">[[#other 2 back|Note (2):]]</cite> In Derby, H2, LucidDB, and CUBRID, users code '''functions''' and '''procedures''' in Java.
* <cite id="other_3">[[#other 3 back|Note (3):]]</cite> ENUM datatype exists. CHECK clause is parsed, but not enforced in runtime.
* <cite id="
==Partitioning==
Line 5,093 ⟶ 4,951:
| {{dunno}}
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
Line 5,109 ⟶ 4,967:
| {{dunno}}
|-
! style="text-align:left" | [[IBM
| {{yes}}
| {{yes}}
Line 5,258 ⟶ 5,116:
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
Line 5,293 ⟶ 5,143:
| {{dunno}}
|-
! style="text-align:left" | [[
| {{no}}
| {{no}}
Line 5,315 ⟶ 5,165:
| {{yes}}
| {{yes}}
| {{dunno}}
|-
Line 5,389 ⟶ 5,223:
! Round Robin
|}
==Access control==
Information about access control functionalities
{{sort-under}}
{| style="text-align: center; font-size: 80%" class="wikitable sortable sort-under"
|-
!
! Native network encryption<sup>[[#ac 1|1]]</sup>
! [[Brute-force attack|Brute-force protection]]
Line 5,409 ⟶ 5,237:
! Run unprivileged<sup>[[#ac 4|4]]</sup>
! Audit
! {{verth|va=middle|Resource limit}}
! {{verth|va=middle|Separation of duties
! {{verth|va=middle|Security Certification}}
! {{verth|va=middle|[[Attribute-based access control
|-
! style="text-align:left" | [[4th Dimension (software)|4D]]
Line 5,459 ⟶ 5,287:
| {{dunno}}
|-
! style="text-align:left" | [[
| {{yes}} (with SSL)
| {{dunno}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[IBM Db2]]
| {{yes}}
| {{dunno}}
Line 5,487 ⟶ 5,328:
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{no}}
| {{
| {{yes}} (LDAP)
| {{
| {{yes}}
| {{yes}}
Line 5,662 ⟶ 5,503:
| {{dunno}}<sup id="ac_8_back">[[#ac 8|8]]</sup>
| {{yes}}
| {{dunno}}
|-
Line 5,700 ⟶ 5,528:
| {{yes}}
| {{yes}}
| {{yes}} (
| {{dunno}}
|-
! style="text-align:left" | [[
| {{yes}}
| {{dunno}}
Line 5,731 ⟶ 5,559:
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}
| {{yes}} (LDAP, Kerberos...<sup id="ac_9_back">[[#ac 9|9]]</sup>)
| {{yes}} (
| {{yes}}<ref>{{Citation
| url = https://www.postgresql.org/support/security.html
Line 5,745 ⟶ 5,573:
}}</ref>
| {{yes}}
| {{
| url = https://
|
|
}}</ref>
| {{yes}}
| {{yes}}
| {{yes}} (
| {{dunno}}
|-
Line 5,800 ⟶ 5,601:
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
Line 5,818 ⟶ 5,619:
| {{no}}
| {{yes}}
| {{yes}} (
| {{dunno}}
|-
Line 5,859 ⟶ 5,660:
! Run unprivileged<sup>[[#ac 4|4]]</sup>
! Audit
! {{verth|va=middle|Resource limit}}
! {{verth|va=middle|Separation of duties
! {{verth|va=middle|Security Certification}}
! {{verth|va=middle|[[Attribute-based access control
|}
* <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.
* <cite id="
* <cite id="ac_3">[[Comparison of relational database management systems#ac 3|Note (3):]]</cite> How do you get security updates? Is it free access, do you need a login or to pay? Is there easy access through a Web/FTP portal or RSS feed or only through offline access (mail CD-ROM, phone).
* <cite id="
* <cite id="ac_5">[[Comparison of relational database management systems#ac 5|Note (5):]]</cite> Is there a separate user to manage special operation like backup (only dump/restore permissions), security officer (audit), administrator (add user/create database), etc.? Is it default or optional?
* <cite id="ac_6">[[#ac 6 back|Note (6):]]</cite> Common Criteria certified product list.<ref>
{{Citation
| publisher = Common Criteria Portal
| url =
| series = Products
| title = DB
| access-date =
}}
</ref>
* <cite id="ac_7">[[#ac 7 back|Note (7):]]</cite> FirebirdSQL seems to only have SYSDBA user and DB owner. There are no separate roles for backup operator and security administrator.
* <cite id="
{{Citation
| url = http://gentoo-wiki.com/HOWTO_Backup_MySQL
Line 5,902 ⟶ 5,692:
}}
</ref>
* <cite id="ac_9">[[#ac 9 back|Note (9):]]</cite> Authentication methods.<ref>{{Citation
| url = https://www.postgresql.org/docs/8.4/interactive/auth-methods.html
| publisher = PostgreSQL community
| series = 8.1 Documents
| title = Authentication methods
| date = 24 July 2014
}}</ref>
* <cite id="ac_10">[[#ac 10 back|Note (10):]]</cite> Informix Dynamic Server supports PAM and other configurable authentication. By default uses OS authentication.
* <cite id="
| url = https://www.microsoft.com/en-us/sqlserver/common-criteria.aspx#tab6
| archive-url = https://web.archive.org/web/20140213221406/https://www.microsoft.com/en-us/sqlserver/common-criteria.aspx
Line 5,919 ⟶ 5,707:
| title = Common Criteria (CC, ISO15408)
}}</ref>
* <cite id="ac_12">[[#ac 12 back|Note (12):]]</cite> With the use of Pervasive AuditMaster.
* <cite id="
| url = http://developer.polyhedra.com/how-to-guides/auditing
| publisher = Enea AB
Line 5,931 ⟶ 5,717:
==Databases vs schemas (terminology)==
{{Original research|section|date=June 2010}}
The [[SQL]] specification defines what an "SQL schema" is; however, databases implement it differently. To compound this confusion the functionality can overlap with that of a parent database. An SQL schema is simply a [[namespace]] within a database; things within this namespace are addressed using the member [[operator (programming)|operator]] dot "
A true [[fully qualified name|fully (database, schema, and table) qualified]] query is exemplified as such:
Both a schema and a database can be used to isolate one table, "foo", from another like-named table "foo". The following is pseudo code:
* {{code|SELECT * FROM database1.foo|sql}} vs. {{code|SELECT * FROM database2.foo|sql}} (no explicit schema between database and table)
* {{code|SELECT * FROM [database1.]default.foo|sql}} vs. {{code|SELECT * FROM [database1.]alternate.foo|sql}} (no explicit database prefix)
The problem that arises is that former [[MySQL]] users will create multiple databases for one project. In this context, MySQL databases are analogous in function to PostgreSQL-schemas, insomuch as PostgreSQL deliberately lacks off-the-shelf cross-database functionality (preferring multi-tenancy) that MySQL has. Conversely, [[PostgreSQL]] has applied more of the specification implementing cross-table, cross-schema, and then left room for future cross-database functionality.
MySQL aliases ''schema'' with ''database'' behind the scenes, such that
Oracle has its own spin where creating a user is synonymous with creating a schema. Thus a database administrator can create a user called PROJECT and then create a table PROJECT.TABLE. Users can exist without schema objects, but an object is always associated with an owner (though that owner may not have privileges to connect to the database). With the 'shared-everything' [[Oracle RAC]] architecture, the same database can be opened by multiple servers concurrently. This is independent of replication, which can also be used, whereby the data is copied for use by different servers. In the Oracle implementation, a 'database' is a set of files which contains the data while the 'instance' is a set of processes (and memory) through which a database is accessed.
Informix supports multiple databases in a server instance like MySQL. It supports the
PostgreSQL and some other databases have
| url = https://www.postgresql.org/docs/current/static/sql-importforeignschema.html
| title = PostgreSQL: Documentation
| website = www.postgresql.org
| access-date = 2016-06-11
Line 5,959 ⟶ 5,744:
* [[List of relational database management systems]]
* [[Comparison of object–relational database management systems]]
* [[Comparison of database administration tools]]
* [[Object database]] – some of which have relational (SQL/ODBC) interfaces.
* [[IBM Business System 12]] – an historical [[RDBMS]] and related query language.
Line 5,969 ⟶ 5,753:
==External links==
{{wikibooks|SQL dialects reference}}
* [http://troels.arvin.dk/db/rdbms/ Comparison of different SQL implementations against SQL standards]. Includes Oracle,
* [https://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt The SQL92 standard]
* [https://www.sql-workbench.eu/dbms_comparison.html DMBS comparison by SQL Workbench]
Line 5,978 ⟶ 5,762:
[[Category:Database software comparisons|Relational databases]]
[[Category:Relational database management systems]]
[[Category:Database management systems]]
| |||