Content deleted Content added
→Operating system support: Raspbian is Linux |
Latest Mimer SQL release is v11.0.9D. |
||
| (78 intermediate revisions by 34 users not shown) | |||
Line 5:
{| class="wikitable sortable"
|-
!
! Maintainer
! First public release date
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]]
Line 87:
| 2023-01-31
| {{free|[[Apache license|Apache License]] 2.0, BSD license for APIs and GUI tools}}
| {{Yes}}<ref>
|-
! [[CA Datacom|Datacom]]
Line 166:
| publisher = Firebird SQL
}}</ref>}}
| {{Yes}}<ref>
|-
! [[GPUdb]]
Line 182:
| 2021-10-21
| {{free|[[BSD license|BSD]]}}
| {{Yes}}<ref>
|-
! [[H2 (DBMS)|H2]]
| H2 Software
| 2005
| 2.
|
| {{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]]
| [[Actian(HCLSoftware)]]
| 1974
|
| title = Actian X & Ingres - Lifecycle Dates
| url = https://communities.actian.com/s/supportservices/lifecycle-dates/actian-x-ingres
}}</ref>
|
| {{Proprietary}}
| {{No}}
|-
! [[InterBase]]
| [[
| 1984
| XE7 v12.0.4.357
Line 225:
| 2018-02-15
| {{Proprietary}}
| {{Yes}}<ref>
|-
! [[LucidDB]]
Line 239:
| 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 252:
| 2014
| {{Proprietary}}
| {{Yes}}<ref>
|-
![[SingleStore|SingleStore (formerly MemSQL)]]
Line 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/about-us/privacy-and-legals/
| publisher = MonetDB
| title = MonetDB License MPL2.0
| date = 8 February 2022
}}</ref>}}
| {{Yes}}<ref>
|-
! [[mSQL]]
Line 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 333 ⟶ 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 372 ⟶ 376:
| [[Progress Software Corporation]]
| 1984
|
|
| {{Proprietary}}
| {{No}}
Line 383 ⟶ 387:
| 2018-08-15
| {{partial|[[GNU General Public License|GPL]] v2 or [[Proprietary software|Proprietary]]}}
| {{Yes}}<ref>
|-
! [[Oracle Database|Oracle DB]]
Line 420 ⟶ 424:
| [[Actian]]
| 1982
|
| 2024-06-30
| {{Proprietary}}
| {{No}}
Line 434 ⟶ 438:
| series = Press Release
| publisher = EECatalog
| title = Polyhedra
}}.</ref>
| {{No}}
Line 441 ⟶ 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 451 ⟶ 461:
| 10.0
| 2016-05-26
| {{Proprietary}}
| {{No}}
Line 508 ⟶ 502:
| {{wikidata|qualifier|raw|Q319417|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q319417|P348|P577}}}}
| {{free|[[Public ___domain]]}}
| {{Yes}}<ref>
|-
! [[SQream DB]]
Line 515 ⟶ 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 563 ⟶ 561:
| {{No}}
|-
! [[Actian Vector|Vector]]
| [[Actian(HCLSoftware)]]
| 2010
| 7.0<ref>{{cite web
| title = Vector - Lifecycle Dates
| url = https://communities.actian.com/s/supportservices/lifecycle-dates/actian-x-ingres
}}</ref>
| 2024-12-17
| {{Proprietary}}
| {{No}}
|-
! [[YugabyteDB]]
| Yugabyte, Inc.
Line 571 ⟶ 581:
| {{Yes}}<ref>{{Cite web|url=https://github.com/YugaByte/yugabyte-db/issues|title=Issues · yugabyte/Yugabyte-db|website=[[GitHub]]}}</ref>
|-
! [[Actian Zen (PSQL)]]
| [[Actian]]
| 1982
| v16
| 2024-06-30
| {{Proprietary}}
| {{No}}
|-
!
! Maintainer
! First public release date
Line 584 ⟶ 603:
{| class="wikitable sortable"
|-
!
! [[Microsoft Windows|Windows]]
! [[macOS]]
Line 668 ⟶ 687:
| {{no}}
|-
! [[Clustrix
| {{no}}
| {{no}}
Line 762 ⟶ 781:
| {{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 790 ⟶ 809:
! [[Informix Dynamic Server]]
| {{yes}}
| {{no}}
| {{yes}}
| {{
| {{yes}} ([[AIX (operating system)|AIX]])
| {{no}}
| {{no}}
Line 808 ⟶ 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}}
Line 936 ⟶ 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 1,055 ⟶ 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=PostgreSQL - Oss4zos |access-date=2013-08-15 |archive-url=https://web.archive.org/web/20150527204912/http://www.oss4zos.org/mediawiki/index.php?title=PostgreSQL#z.2FOS |archive-date=2015-05-27 |url-status=dead }}</ref>
| {{no}}
Line 1,067 ⟶ 1,086:
| {{no}}
| {{no}}
| {{no}}
| {{no}}
Line 1,193 ⟶ 1,188:
| {{no}}
|-
! [[Teradata]]
| {{yes}}
Line 1,200 ⟶ 1,194:
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! [[TiDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{partial}}
| {{no}}
| {{no}}
| {{no}}
Line 1,242 ⟶ 1,248:
| {{no}}
|-
!
! [[Microsoft Windows|Windows]]
! [[macOS]]
Line 1,294 ⟶ 1,300:
| {{yes}}
| {{yes}}
| {{Yes
| {{Yes
| {{yes}}
|[[API]] & [[GUI]] & [[SQL]]
Line 1,324 ⟶ 1,330:
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking) <ref>
| {{dunno}}
| {{yes}}
Line 1,330 ⟶ 1,336:
| {{Yes}}
|-
! [[Clustrix
| {{yes}}
| {{yes}}
Line 1,364 ⟶ 1,370:
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{dunno}}
| {{yes}}
Line 1,473 ⟶ 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,514 ⟶ 1,520:
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
Line 1,554 ⟶ 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,584 ⟶ 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,624 ⟶ 1,630:
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>
| {{yes}}
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
| {{No}}<ref>
|-
! [[SAP HANA]]
Line 1,674 ⟶ 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,694 ⟶ 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}}
Line 1,718 ⟶ 1,704:
| {{yes}}
| [[SQL]]
| {{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}}
|-
Line 1,750 ⟶ 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,760 ⟶ 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,803 ⟶ 1,793:
| Unlimited
| 16 [[exbibyte|EiB]]
| {{val|65530|u=B|fmt=commas}}
| 65,135 / (10+ AvgFieldNameLength)
| 4 [[gibibyte|GiB]]
Line 1,818 ⟶ 1,808:
| 1,012 (5,000 in views)
| 2,147,483,647 chars
| 254 (
| 64 bits
| 0001-01-01
Line 1,824 ⟶ 1,814:
| 128
|-
! style="text-align:left" | [[Clustrix
| Unlimited
| Unlimited
Line 1,848 ⟶ 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,862 ⟶ 1,852:
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| Unlimited
| 2<sup>63</sup>
| 2 GB
| 32,767
Line 1,877 ⟶ 1,867:
| Unlimited
| 10,000
| {{N/A}}
| 2 MB
| 128 bits
Line 1,891 ⟶ 1,881:
| 4 GB
| 10,000,000
| 1 billion characters, {{10^|-400}} to {{10^|400}},
| 0001-01-01
| 4000-12-31
Line 1,897 ⟶ 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,945 ⟶ 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>125</sup> <sup id="limit_13_back">[[#limit 13|13]]</sup>
| 01/01/0001<sup id="limit_10_back">[[#limit 10|10]]</sup>
Line 1,970 ⟶ 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,983 ⟶ 1,973:
| Unlimited
| 2<sup>30</sup> rows
| 64 KB (w/o BLOBs),<br />2GB (each BLOB value)
| 250
| 2 GB
Line 1,994 ⟶ 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,014 ⟶ 2,004:
| 16 MB
| 255
| 64 KB (memo field),<br />1 GB ("OLE Object" field)
| 255 B (text field)
| 32 bits
Line 2,034 ⟶ 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,095 ⟶ 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,107 ⟶ 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,181 ⟶ 2,169:
| 5,874,897
| 63
|-
! style="text-align:left" | [[SAP HANA]]
Line 2,230 ⟶ 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,243 ⟶ 2,207:
|-
! style="text-align:left" | [[SQLite]]
| 128 TB (2<sup>31</sup> pages
| Limited by file size
| Limited by file size
Line 2,257 ⟶ 2,221:
| Unlimited
| Unlimited
| 64000 wo/lobs<br />(64 GB w/lobs)
| 2,048
| 2 GB
Line 2,290 ⟶ 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,303 ⟶ 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,318 ⟶ 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,329 ⟶ 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,340 ⟶ 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,382 ⟶ 2,336:
| {{no}}
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
Line 2,493 ⟶ 2,447:
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SAP HANA]]
Line 2,538 ⟶ 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,547 ⟶ 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,554 ⟶ 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,581 ⟶ 2,524:
! [[Full text search|Full-text]]
! [[Spatial index|Spatial]]
!
! Duplicate index prevention
|-
Line 2,660 ⟶ 2,603:
| {{no}}
|-
! style="text-align:left" | [[Clustrix
| {{no}}
| {{yes}}
Line 2,746 ⟶ 2,689:
| {{no}}
| {{yes}}
| {{
| {{yes}}
| {{no}}
Line 2,810 ⟶ 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 =
| {{yes}}
|-
Line 2,988 ⟶ 2,930:
| title = Library
| chapter = Spatial Indexing Overview
| date = 4 October 2012
}}</ref>
| {{dunno}}
| {{no}}
Line 3,081 ⟶ 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,125 ⟶ 3,067:
}}</ref>
| {{dunno}}
| {{yes}}<ref>
|-
! style="text-align:left" | [[Oracle Rdb]]
Line 3,193 ⟶ 3,135:
| 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,271 ⟶ 3,189:
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}<ref>
| {{no}}
| {{yes}}<ref>
| {{yes}}
| {{no}}
Line 3,279 ⟶ 3,197:
| {{no}}
| {{no}}
| {{yes}}<ref>
| style="background:#ffd;"| SpatiaLite<ref>{{Citation
| url = http://www.gaia-gis.it/spatialite/
Line 3,351 ⟶ 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
Line 3,364 ⟶ 3,281:
| 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,388 ⟶ 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,398 ⟶ 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,412 ⟶ 3,328:
! style="width:16em" |
! [[Union (SQL)|Union]]
! [[Intersect (
! [[Except (SQL)|Except]]
! [[Inner join]]s
Line 3,513 ⟶ 3,429:
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
Line 3,615 ⟶ 3,531:
| {{yes}}
| {{yes}}
| {{yes}}<ref name="New Features in HyperSQL 2.2">
| {{yes}}
| {{yes}}
Line 3,632 ⟶ 3,548:
| {{no}}
| {{yes}}
| experimental<ref>
| {{yes}}<ref>
| {{dunno}}
| {{dunno}}
Line 3,649 ⟶ 3,565:
| {{yes}}
| {{yes}}
| {{yes}}<ref>
| {{dunno}}
Line 3,789 ⟶ 3,705:
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
Line 3,808 ⟶ 3,724:
| title = Library
| chapter = SQL Server Parallel Query Processing
| date = 4 October 2012
}}</ref>
| {{yes}}<ref name="system-versioning"/>
Line 3,859 ⟶ 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,980 ⟶ 3,897:
}}</ref>
| {{no}}<ref name="system-versioning"/>
|-
Line 4,062 ⟶ 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,133 ⟶ 4,020:
|}
* <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,153 ⟶ 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
Line 4,198 ⟶ 4,083:
}}{{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,246 ⟶ 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,262 ⟶ 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,290 ⟶ 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,304 ⟶ 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^
| {{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,351 ⟶ 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,366 ⟶ 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,383 ⟶ 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,424 ⟶ 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,440 ⟶ 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,471 ⟶ 4,363:
|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" | [[Actian Zen (PSQL)]]<ref name="psql-datatypes">{{Citation
Line 4,489 ⟶ 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,511 ⟶ 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,529 ⟶ 4,421:
}}</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,602 ⟶ 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,617 ⟶ 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,639 ⟶ 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,687 ⟶ 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,738 ⟶ 4,594:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Clustrix
| {{no}}
| {{yes}}
Line 4,755 ⟶ 4,611:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
Line 4,801 ⟶ 4,657:
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
Line 4,812 ⟶ 4,668:
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
Line 4,842 ⟶ 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,879 ⟶ 4,735:
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
| {{yes}}
Line 4,911 ⟶ 4,767:
|-
! style="text-align:left" | [[MySQL]]
| {{no}}
| {{yes}}
| {{yes}}
Line 4,971 ⟶ 4,819:
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
Line 5,047 ⟶ 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,123 ⟶ 4,951:
| {{dunno}}
|-
! style="text-align:left" | [[Clustrix
| {{yes}}
| {{no}}
Line 5,288 ⟶ 5,116:
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
Line 5,345 ⟶ 5,165:
| {{yes}}
| {{yes}}
| {{dunno}}
|-
Line 5,419 ⟶ 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,439 ⟶ 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,705 ⟶ 5,503:
| {{dunno}}<sup id="ac_8_back">[[#ac 8|8]]</sup>
| {{yes}}
| {{dunno}}
|-
Line 5,793 ⟶ 5,578:
| date = September 2022
}}</ref>
| {{yes}}
| {{yes}}
| {{yes}} (EAL2+<sup>[[#ac 1|1]]</sup>)
| {{dunno}}
|-
Line 5,843 ⟶ 5,601:
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
Line 5,902 ⟶ 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,927 ⟶ 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,942 ⟶ 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
Line 5,950 ⟶ 5,699:
| 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,960 ⟶ 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,972 ⟶ 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)
*
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 6,018 ⟶ 5,762:
[[Category:Database software comparisons|Relational databases]]
[[Category:Relational database management systems]]
[[Category:Database management systems]]
| |||