Content deleted Content added
Latest Mimer SQL release is v11.0.9D. |
|||
| (157 intermediate revisions by 62 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
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 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 324 ⟶ 337:
| 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]]
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 499 ⟶ 502:
| {{wikidata|qualifier|raw|Q319417|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q319417|P348|P577}}}}
| {{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|reference|edit|Q56375088|P348}}
| {{wikidata|qualifier|raw|Q56375088|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q56375088|P348|P577}}}}
| {{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 583 ⟶ 603:
{| class="wikitable sortable"
|-
!
! [[Microsoft Windows|Windows]]
! [[macOS]]
Line 591 ⟶ 611:
! [[AmigaOS]]
! [[z/OS]]
! [[OpenVMS]]
! [[iOS]]
! [[Android (operating system)|Android]]
|-
! [[4th Dimension (Software)|4th Dimension]]
Line 663 ⟶ 683:
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{no}}
|-
! [[Clustrix
| {{no}}
| {{no}}
Line 703 ⟶ 723:
| {{no}}
|-
! [[IBM
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
|-
Line 724 ⟶ 744:
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
|-
! [[EXASOL|EXASolution]]
Line 743 ⟶ 763:
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
Line 749 ⟶ 770:
| {{Yes}}
| {{No}}
|-
! [[Firebird (database server)|Firebird]]
Line 760 ⟶ 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>
| {{
|-
! [[HSQLDB]]
Line 771 ⟶ 791:
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! [[H2 (DBMS)|H2]]
Line 783 ⟶ 803:
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{yes}}
|-
! [[Informix Dynamic Server]]
| {{yes}}
| {{
| {{yes}}
| {{no}}
| {{yes}} ([[AIX (operating system)|AIX]])
| {{no}}
| {{no}}
Line 807 ⟶ 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}}
|-
! [[InterBase]]
Line 817 ⟶ 837:
| {{no}}
| {{yes}} ([[Solaris (operating system)|Solaris]])
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
|-
! [[Linter SQL RDBMS]]
Line 861 ⟶ 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>
|-
! [[MaxDB]]
Line 906 ⟶ 926:
| {{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 935 ⟶ 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}}
|-
Line 960 ⟶ 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>
|-
! [[Omnis Studio]]
Line 1,007 ⟶ 1,027:
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
|-
! [[Oracle Rdb]]
Line 1,020 ⟶ 1,040:
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
|-
! [[
| {{yes}}
| {{yes}} (OEM only)
Line 1,033 ⟶ 1,053:
| {{no}}
| {{no}}
| {{
| {{
|-
! [[Polyhedra DBMS|Polyhedra]]
Line 1,054 ⟶ 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}}
|-
! [[R:Base]]
Line 1,066 ⟶ 1,086:
| {{no}}
| {{no}}
| {{no}}
| {{no}}
Line 1,129 ⟶ 1,125:
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
|-
! [[SQLBase]]
Line 1,152 ⟶ 1,148:
| {{yes}}
| {{partial|Maybe}}
| {{no}}
| {{Yes}}
| {{Yes}}
|-
! [[SQream DB]]
Line 1,192 ⟶ 1,188:
| {{no}}
|-
! [[Teradata]]
| {{yes}}
Line 1,205 ⟶ 1,200:
| {{no}}
|-
! [[
| {{yes}}
| {{yes}}
| {{yes}}
| {{partial}}
| {{no}}
| {{no}}
| {{no}}
Line 1,241 ⟶ 1,236:
| {{no}}
|-
! [[YugabyteDB]]
| {{yes}}
| {{yes}}
Line 1,253 ⟶ 1,248:
| {{no}}
|-
!
! [[Microsoft Windows|Windows]]
! [[macOS]]
Line 1,261 ⟶ 1,256:
! [[AmigaOS]]
! [[z/OS]]
! [[OpenVMS]]
! [[iOS]]
! [[Android (operating system)|Android]]
|}
Line 1,305 ⟶ 1,300:
| {{yes}}
| {{yes}}
| {{Yes
| {{Yes
| {{yes}}
|[[API]] & [[GUI]] & [[SQL]]
Line 1,335 ⟶ 1,330:
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking) <ref>
| {{dunno}}
| {{yes}}
Line 1,341 ⟶ 1,336:
| {{Yes}}
|-
! [[Clustrix
| {{yes}}
| {{yes}}
Line 1,366 ⟶ 1,361:
| {{yes}}
| {{yes}} (Row-level locking)
| {{
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
| {{Yes}}
|-
! [[IBM
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{dunno}}
| {{yes}}
Line 1,426 ⟶ 1,421:
| {{yes}}
| {{dunno}}
| {{yes}}<ref>{{Cite web|url=http://www.h2database.com/html/advanced.html#mvcc|title = Advanced}}</ref>
| {{yes}}
| [[SQL]]
Line 1,438 ⟶ 1,433:
| {{yes}}
| {{yes}}
| [[SQL]], REST, MQ, and [[JSON]]
| {{Yes}}
|-
Line 1,484 ⟶ 1,479:
| {{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,525 ⟶ 1,520:
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
Line 1,565 ⟶ 1,560:
| {{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,595 ⟶ 1,590:
| {{yes}}
| {{yes}} except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL" />
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
Line 1,611 ⟶ 1,606:
| {{Yes}}
|-
! [[
| {{yes}}
| {{yes}}
Line 1,635 ⟶ 1,630:
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
| {{No}}<ref>
|-
! [[SAP HANA]]
Line 1,685 ⟶ 1,660:
| {{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}}
|-
Line 1,705 ⟶ 1,680:
| {{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}}
|-
! [[Superbase database
| {{dunno}}
| {{dunno}}
Line 1,718 ⟶ 1,693:
| {{dunno}}
| {{yes}}
| [[GUI]] & [[
| {{Yes}}
|-
Line 1,731 ⟶ 1,706:
| {{Yes}}
|-
! [[
| {{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}}
|-
Line 1,771 ⟶ 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,781 ⟶ 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,824 ⟶ 1,793:
| Unlimited
| 16 [[exbibyte|EiB]]
| {{val|65530|u=B|fmt=commas}}
| 65,135 / (10+ AvgFieldNameLength)
| 4 [[gibibyte|GiB]]
Line 1,839 ⟶ 1,808:
| 1,012 (5,000 in views)
| 2,147,483,647 chars
| 254 (
| 64 bits
| 0001-01-01
Line 1,845 ⟶ 1,814:
| 128
|-
! style="text-align:left" | [[Clustrix
| Unlimited
| Unlimited
Line 1,869 ⟶ 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,883 ⟶ 1,852:
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| Unlimited
| 2<sup>63</sup>
| 2 GB
| 32,767
Line 1,898 ⟶ 1,867:
| Unlimited
| 10,000
| {{N/A}}
| 2 MB
| 128 bits
Line 1,912 ⟶ 1,881:
| 4 GB
| 10,000,000
| 1 billion characters, {{10^|-400}} to {{10^|400}},
| 0001-01-01
| 4000-12-31
Line 1,918 ⟶ 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,966 ⟶ 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,991 ⟶ 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 2,004 ⟶ 1,973:
| Unlimited
| 2<sup>30</sup> rows
| 64 KB (w/o BLOBs),<br />2GB (each BLOB value)
| 250
| 2 GB
Line 2,015 ⟶ 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,035 ⟶ 2,004:
| 16 MB
| 255
| 64 KB (memo field),<br />1 GB ("OLE Object" field)
| 255 B (text field)
| 32 bits
Line 2,055 ⟶ 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,099 ⟶ 2,068:
| 2 GB
| 128 bits
| -
| 9999-12-31
| 1024
Line 2,116 ⟶ 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,128 ⟶ 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,153 ⟶ 2,120:
! Max column name size
|-
! style="text-align:left" | [[
| 4 billion objects
| 256 GB
Line 2,202 ⟶ 2,169:
| 5,874,897
| 63
|-
! style="text-align:left" | [[SAP HANA]]
Line 2,251 ⟶ 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,264 ⟶ 2,207:
|-
! style="text-align:left" | [[SQLite]]
| 128 TB (2<sup>31</sup> pages
| Limited by file size
| Limited by file size
Line 2,278 ⟶ 2,221:
| Unlimited
| Unlimited
| 64000 wo/lobs<br />(64 GB w/lobs)
| 2,048
| 2 GB
Line 2,311 ⟶ 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,324 ⟶ 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,339 ⟶ 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,350 ⟶ 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,361 ⟶ 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,401 ⟶ 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,501 ⟶ 2,436:
| {{yes}}
|-
! style="text-align:left" | [[
| {{yes}}
| {{no}}
Line 2,512 ⟶ 2,447:
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SAP HANA]]
Line 2,537 ⟶ 2,464:
| {{no}}
|-
! style="text-align:left" | [[Superbase database
| {{yes}}
| {{yes}}
Line 2,557 ⟶ 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,566 ⟶ 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,573 ⟶ 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,600 ⟶ 2,524:
! [[Full text search|Full-text]]
! [[Spatial index|Spatial]]
!
! Duplicate index prevention
|-
Line 2,679 ⟶ 2,603:
| {{no}}
|-
! style="text-align:left" | [[Clustrix
| {{no}}
| {{yes}}
Line 2,698 ⟶ 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,710 ⟶ 2,638:
| {{no}}
|-
! style="text-align:left" | [[IBM
| {{Yes}}
| {{Yes}}
Line 2,723 ⟶ 2,651:
| publisher = IBM
| series = Developer Works
| title = Full-text search with
}}</ref>
| {{dunno}}
Line 2,761 ⟶ 2,689:
| {{no}}
| {{yes}}
| {{
| {{yes}}
| {{no}}
Line 2,825 ⟶ 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 3,002 ⟶ 2,930:
| title = Library
| chapter = Spatial Indexing Overview
| date = 4 October 2012
}}</ref>
| {{dunno}}
| {{no}}
Line 3,095 ⟶ 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,139 ⟶ 3,067:
}}</ref>
| {{dunno}}
| {{yes}}<ref>
|-
! style="text-align:left" | [[Oracle Rdb]]
Line 3,155 ⟶ 3,083:
| {{no}}
|-
! style="text-align:left" | [[
| {{no}}
| {{no}}
Line 3,195 ⟶ 3,123:
| url = https://www.postgresql.org/docs/current/indexes-types.html
| title = Index Types
| date = 11 November 2021
}}</ref>
| {{yes}}
Line 3,202 ⟶ 3,131:
| url = https://www.postgresql.org/docs/current/textsearch.html
| title = Full Text Search
| date = 11 November 2021
}}</ref>
| style="background:#ffd;"| PostGIS<ref>{{Citation
| publisher = The PostGIS Development Group
| series
| url
| title
| access-date = 2021-05-13
| 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,283 ⟶ 3,189:
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}<ref>
| {{no}}
| {{yes}}<ref>
| {{yes}}
| {{no}}
Line 3,291 ⟶ 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,359 ⟶ 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,392 ⟶ 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,402 ⟶ 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,416 ⟶ 3,328:
! style="width:16em" |
! [[Union (SQL)|Union]]
! [[Intersect (
! [[Except (SQL)|Except]]
! [[Inner join]]s
Line 3,422 ⟶ 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,517 ⟶ 3,429:
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
Line 3,541 ⟶ 3,453:
| {{yes}}
| {{yes}}
| {{
| {{yes}}<ref name="CUBRID 9.0 release"/>
| {{dunno}}
Line 3,547 ⟶ 3,459:
|-
! style="text-align:left" | [[IBM
| {{yes}}
| {{yes}}
Line 3,565 ⟶ 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,619 ⟶ 3,531:
| {{yes}}
| {{yes}}
| {{yes}}<ref name="New Features in HyperSQL 2.2">
| {{yes}}
| {{yes}}
Line 3,636 ⟶ 3,548:
| {{no}}
| {{yes}}
| experimental<ref>
| {{yes}}<ref>
| {{dunno}}
| {{dunno}}
Line 3,653 ⟶ 3,565:
| {{yes}}
| {{yes}}
| {{yes}}<ref>
| {{dunno}}
Line 3,666 ⟶ 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,793 ⟶ 3,705:
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
Line 3,812 ⟶ 3,724:
| title = Library
| chapter = SQL Server Parallel Query Processing
| date = 4 October 2012
}}</ref>
| {{yes}}<ref name="system-versioning"/>
Line 3,863 ⟶ 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,886 ⟶ 3,799:
| {{no}}<ref name="system-versioning"/>
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
Line 3,933 ⟶ 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,950 ⟶ 3,849:
|-
! style="text-align:left" | [[
| {{yes}}
| {{no}}
Line 3,995 ⟶ 3,894:
| publisher = PostgreSQL
| title = Parallel Query
| date = 11 August 2022
}}</ref>
| {{no}}<ref name="system-versioning"/>
|-
Line 4,079 ⟶ 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,142 ⟶ 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,170 ⟶ 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,263 ⟶ 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,279 ⟶ 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,307 ⟶ 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,321 ⟶ 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,368 ⟶ 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,383 ⟶ 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,400 ⟶ 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,441 ⟶ 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,457 ⟶ 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,478 ⟶ 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,502 ⟶ 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,524 ⟶ 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,539 ⟶ 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,610 ⟶ 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,625 ⟶ 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,647 ⟶ 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,695 ⟶ 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,746 ⟶ 4,594:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Clustrix
| {{no}}
| {{yes}}
Line 4,763 ⟶ 4,611:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
Line 4,782 ⟶ 4,630:
| {{yes}}
|-
! style="text-align:left" | [[IBM
| {{yes}} via CHECK CONSTRAINT
| {{yes}}
Line 4,809 ⟶ 4,657:
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
Line 4,820 ⟶ 4,668:
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
Line 4,850 ⟶ 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,887 ⟶ 4,735:
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
| {{yes}}
Line 4,919 ⟶ 4,767:
|-
! style="text-align:left" | [[MySQL]]
| {{no}}
| {{yes}}
| {{yes}}
Line 4,958 ⟶ 4,798:
| {{yes}}
|-
! style="text-align:left" | [[
| {{yes}}
| {{yes}}
Line 4,979 ⟶ 4,819:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
Line 5,055 ⟶ 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,131 ⟶ 4,951:
| {{dunno}}
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
Line 5,147 ⟶ 4,967:
| {{dunno}}
|-
! style="text-align:left" | [[IBM
| {{yes}}
| {{yes}}
Line 5,296 ⟶ 5,116:
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
Line 5,331 ⟶ 5,143:
| {{dunno}}
|-
! style="text-align:left" | [[
| {{no}}
| {{no}}
Line 5,353 ⟶ 5,165:
| {{yes}}
| {{yes}}
| {{dunno}}
|-
Line 5,427 ⟶ 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,447 ⟶ 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,497 ⟶ 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,525 ⟶ 5,328:
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{no}}
| {{
| {{yes}} (LDAP)
| {{
| {{yes}}
| {{yes}}
Line 5,700 ⟶ 5,503:
| {{dunno}}<sup id="ac_8_back">[[#ac 8|8]]</sup>
| {{yes}}
| {{dunno}}
|-
Line 5,741 ⟶ 5,531:
| {{dunno}}
|-
! style="text-align:left" | [[
| {{yes}}
| {{dunno}}
Line 5,786 ⟶ 5,576:
| url = https://github.com/pgaudit/pgaudit/blob/master/README.md
| title = Open Source PostgreSQL Audit Logging
| date = September 2022
}}</ref>
| {{yes}}
| {{yes}}
| {{yes}} (EAL2+<sup>[[#ac 1|1]]</sup>)
| {{dunno}}
|-
Line 5,837 ⟶ 5,601:
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
Line 5,896 ⟶ 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
Line 5,921 ⟶ 5,679:
}}
</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,936 ⟶ 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,953 ⟶ 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,965 ⟶ 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 support for foreign schemas, which is the ability to import schemas from other servers as defined in [[SQL/MED|ISO/IEC 9075-9]] (published as part of [[SQL:2008]]). This appears like any other schema in the database according to the SQL specification while accessing data stored either in a different database or a different server instance. The import can be made either as an entire foreign schema or merely certain tables belonging to that foreign schema.<ref>{{Cite web
Line 5,993 ⟶ 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 6,003 ⟶ 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 6,012 ⟶ 5,762:
[[Category:Database software comparisons|Relational databases]]
[[Category:Relational database management systems]]
[[Category:Database management systems]]
| |||