Comparación de sistemas de gestión de bases de datos relacionales

Wikimedia list article

Las siguientes tablas comparan información general y técnica para varios sistemas de administración de bases de datos relacionales . Consulte los artículos de los productos individuales para obtener más información. A menos que se especifique lo contrario en las notas al pie, las comparaciones se basan en las versiones estables sin complementos, extensiones o programas externos.

Información general

	Mantenedor	Primera fecha de lanzamiento público	Última versión estable	Última fecha de lanzamiento	Licencia	Lista de problemas públicos
4D (cuarta dimensión)	SAS 4D	1984	v16.0	2017-01-10 [1]	Propiedad	No
ADABAS	Software AG	1970	8.1	2013-06	Propiedad	No
Adaptive Server Enterprise	SAP AG	1987	16.0 SP03 PL07	2019-06-10	Propiedad	No
Servidor de base de datos Advantage (ADS)	SAP AG	1992	12,0	2015	Propiedad	No
Altibase	Altibase Corp.	2000	7.1.0.1.2	2018-03-02	GNU-AGPLv3; GNU-LGPLv3 (para bibliotecas cliente)	No
Apache Derby	apache	2004	10.15.1.3 [2]	2019-03-11	Licencia Apache	Sí [3]
ClustrixDB	MariaDB Corporation	2010	v7.0	2015-08-19	Propiedad	No
CucarachaDB	Laboratorios de cucarachas	2015	v20.2.8	2021-04-23	BSL, CCL, MIT, BSD	Sí [4]
CUBRID	CUBRID	2008-11	10.2.1	2020-06-01	GPL v2 o posterior, licencia BSD para API y herramientas GUI	Sí [5]
Datacom	CA, Inc.	Principios de los 70 [6]	14 [7]	2012 [8]	Propiedad	No
DB2	IBM	1983	11,5 [9]	27 de junio de 2019 ; Hace 22 meses (27 June 2019)	Propiedad	No
Base de datos integrada Empress	Empress Software Inc	1979	10,20	2010-03	Propiedad	No
EXASolución	EXASOL AG	2004	6.0.0	2017-03-17	Propiedad	No
FileMaker	FileMaker, Inc., una subsidiaria de Apple	1985-04	19	20-05-2020	Propiedad	No
Pájaro de fuego	Proyecto Firebird	2000-07-25	3.0.7 [10]	20 de octubre de 2020 ; hace 6 meses (20 October 2020)	IPL [11] e IDPL [12]	Yes[13]
GPUdb	GIS Federal	2014	3.2.5	2015-01-14	Proprietary	No
HSQLDB	HSQL Development Group	2001	2.4.1	2018-05-20	BSD	Yes[14]
H2	H2 Software	2005	1.4.200	2019-10-14	EPL and modified MPL	Yes[15]
Informix Dynamic Server	IBM	1981????1980	14.10.xC4W1	2020-06-22	Proprietary	No
Ingres	Ingres Corp.	1974	11.0	2017-03-21	GPL and Proprietary	No
InterBase	Embarcadero	1984	XE7 v12.0.4.357	2015-08-12	Proprietary	No
Linter SQL RDBMS	RELEX Group	1990	6.0.17.53	2018-02-15	Proprietary	Yes[16]
LucidDB	The Eigenbase Project	2007-01	0.9.4	2012-01-05	GPL v2	No
MariaDB	MariaDB Community	2010-02-01	10.5.10[17]	7 May 2021; 1 day ago (7 May 2021)	GPL v2, LGPL (for client-libraries)[18]	Yes[19]
MaxDB	SAP AG	2003-05	7.9.0.8	2014	Proprietary	Yes[20]
SingleStore (formerly MemSQL)	SingleStore	2012-06	7.1.11	2020-10-12	Proprietary	No
Microsoft Access (JET)	Microsoft	1992	16 (2016)	2015-09-22	Proprietary	No
Microsoft Visual Foxpro	Microsoft	1984	9 (2005)	2007-10-11	Proprietary	No
Microsoft SQL Server	Microsoft	1989	SQL Server 2019[21]	4 November 2019; 18 months ago (4 November 2019)	Proprietary	No
Microsoft SQL Server Compact (Embedded Database)	Microsoft	2000	2011 (v4.0)		Proprietary	No
Mimer SQL	Mimer Information Technology	1978	11.0.5A	2021-03-01	Proprietary	No
MonetDB	The MonetDB Team / CWI	2004	Oct2020-SP2	2021-01-25	Mozilla Public License, version 2.0[22]	Yes[23]
mSQL	Hughes Technologies	1994	4.1[24]	2017-06-30	Proprietary	No
MySQL	Oracle Corporation	1995-11	8.0.24[25]	20 April 2021; 18 days ago (20 April 2021)	GPL v2 or Proprietary	Yes[26]
NexusDB	NexusDB Pty Ltd	2003	4.00.14	2015-06-25	Proprietary	No
HP NonStop SQL	Hewlett-Packard	1987	SQL/MX 3.4		Proprietary	No
NuoDB	NuoDB	2013	4.1	August 2020	Proprietary	No
Omnis Studio	TigerLogic Inc	1982-07	6.1.3 Release 1no	2015-12	Proprietary	No
OpenEdge	Progress Software Corporation	1984	11.6.3	2016-08-19	Proprietary	No
OpenLink Virtuoso	OpenLink Software	1998	7.2.5.1	2018-08-15	GPL v2 or Proprietary	Yes[27]
Oracle DB	Oracle Corporation	1979-11	19c[28]	13 February 2019; 2 years ago (13 February 2019)	Proprietary	No
Oracle Rdb	Oracle Corporation	1984	7.4.1.0[29]	2020-08-10[±]	Proprietary	No
Paradox	Corel Corporation	1985	11	2009-09-07	Proprietary	No
Percona Server for MySQL	Percona	2006	8.0.21-12	2020-10-13[±]	GPL v2	Yes
Pervasive PSQL	Pervasive Software	1982	v12	2015	Proprietary	No
Polyhedra DBMS	ENEA AB	1993	9.0	2015-06-24	Proprietary, with Polyhedra Lite available as Freeware[30]	No
PostgreSQL	PostgreSQL Global Development Group	1989-06	13.2[31]	11 February 2021; 2 months ago (11 February 2021)	Postgres License[32]	No[33]
R:Base	R:BASE Technologies	1982	10.0	2016-05-26	Proprietary	No
Raima Database Manager	Raima Inc.	1984	14.2	2020-10-08	Proprietary	No
RDM Server	Raima Inc.	1993	8.4	2012-10-31	Proprietary	No
SAP HANA	SAP AG	2010	2.0 SPS04	2019-08-08	Proprietary	No
solidDB	UNICOM Global	1992	7.0.0.10	2014-04-29	Proprietary	No
SQL Anywhere	SAP AG	1992	17.0.0.48	2019-07-26	Proprietary	No
SQLBase	Unify Corp.	1982	11.5	2008-11	Proprietary	No
SQLite	D. Richard Hipp	2000-09-12	3.35.5[34]	19 April 2021; 19 days ago (19 April 2021)	Public domain	Yes[35]
SQream DB	SQream Technologies	2014	2.1[36]	2018-01-15	Proprietary	No
Superbase	Superbase	1984	Classic	2003	Proprietary	No
Superbase NG	Superbase NG	2002	Superbase NG 2.10	2017	Proprietary	Yes[37]
Teradata	Teradata	1984	15	2014-04	Proprietary	No
Tibero	TmaxSoft	1992	6	2015-04	Proprietary	No
TiDB	Apache	2016	5.0.0[38]	7 April 2021; 31 days ago (7 April 2021)	Apache License	Yes[39]
UniData	Rocket Software	1988	8.2.1	2017-07	Proprietary	No
YugabyteDB	Apache	2018	2.2.30[40]	2020-09-30[±]	Apache License	Yes[41]
	Maintainer	First public release date	Latest stable version	Latest release date	License	Public issues list

Operating system support

The operating systems that the RDBMSes can run on.

	Windows	macOS	Linux	BSD	UNIX	AmigaOS	z/OS	iOS	Android	OpenVMS
4th Dimension	Yes	Yes	No	No	No	No	No	No	No	No
ADABAS	Yes	No	Yes	No	Yes	No	Yes	No	No	No
Adaptive Server Enterprise	Yes	No	Yes	Yes	Yes	No	No	No	No	No
Advantage Database Server	Yes	No	Yes	No	No	No	No	No	No	No
Altibase	Yes	No	Yes	No	Yes	No	No	No	No	No
Apache Derby	Yes	Yes	Yes	Yes	Yes	No	Yes	?	No	No
ClustrixDB	No	No	Yes	No	Yes	No	No	No	No	No
CockroachDB	Yes	Yes	Yes	No	No	No	No	No	No	No
CUBRID	Yes	Partial	Yes	No	No	No	No	No	No	No
DB2	Yes	Yes (Express C)	Yes	No	Yes	No	Yes	Yes	No	No
Empress Embedded Database	Yes	Yes	Yes	Yes	Yes	No	No	No	Yes	No
EXASolution	No	No	Yes	No	No	No	No	No	No	No
FileMaker	Yes	Yes	Yes	No	No	No	No	Yes	No	No
Firebird	Yes	Yes	Yes	Yes	Yes	No	Maybe	No	Yes[42]	No
HSQLDB	Yes	Yes	Yes	Yes	Yes	No	Yes	?	?	No
H2	Yes	Yes	Yes	Yes	Yes	No	Yes	?	Yes	No
Informix Dynamic Server	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Ingres	Yes	Yes	Yes	Yes	Yes	No	Partial	No	No	Yes[43]
InterBase	Yes	Yes	Yes	No	Yes (Solaris)	No	No	Yes	Yes	No
Linter SQL RDBMS	Yes	Yes	Yes	Yes	Yes	No	Under Linux on IBM Z	Yes	Yes	Yes
LucidDB	Yes	Yes	Yes	No	No	No	No	No	No	No
MariaDB	Yes	Yes[44]	Yes	Yes	Yes	No	No	?	Yes[45]	No
MaxDB	Yes	No	Yes	No	Yes	No	Maybe	No	No	No
Microsoft Access (JET)	Yes	No	No	No	No	No	No	No	No	No
Microsoft Visual Foxpro	Yes	No	No	No	No	No	No	No	No	No
Microsoft SQL Server	Yes	No	Yes[46]	No	No	No	No	No	No	No
Microsoft SQL Server Compact (Embedded Database)	Yes	No	No	No	No	No	No	No	No	No
Mimer SQL	Yes	Yes	Yes	No	Yes	No	No	No	Yes	Yes
MonetDB	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
MySQL	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	Yes[47]	No
Omnis Studio	Yes	Yes	Yes	No	No	No	No	No	No	No
OpenEdge	Yes	No	Yes	No	Yes	No	No	No	No	No
OpenLink Virtuoso	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
Oracle	Yes	Yes	Yes	No	Yes	No	Yes	No	No	Yes
Oracle Rdb	No	No	No	No	No	No	No	No	No	Yes
Pervasive PSQL	Yes	Yes (OEM only)	Yes	No	No	No	No	No	No	No
Polyhedra	Yes	No	Yes	No	Yes	No	No	No	No	No
PostgreSQL	Yes	Yes	Yes	Yes	Yes	Yes (MorphOS)[48]	Under Linux on IBM Z[49]	No	Yes	No
R:Base	Yes	No	No	No	No	No	No	No	No	No
Raima Database Manager	Yes	Yes	Yes	Yes	Yes	No	No	Yes	Yes	No
RDM Server	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No
SAP HANA	Yes	No	Yes	No	No	No	No	No	No	No
solidDB	Yes	No	Yes	No	Yes	No	Under Linux on IBM Z	No	No	No
SQL Anywhere	Yes	Yes	Yes	No	Yes	No	No	No	Yes	No
SQLBase	Yes	No	Yes	No	No	No	No	No	No	No
SQLite	Yes	Yes	Yes	Yes	Yes	Yes	Maybe	Yes	Yes	No
SQream DB	No	No	Yes	No	No	No	No	No	No	No
Superbase	Yes	No	No	No	No	Yes	No	No	No	No
Superbase NG	Yes	No	Yes	No	No	No	No	No	No	No
Teradata	Yes	No	Yes	No	Yes	No	No	No	No	No
Tibero	Yes	No	Yes	No	Yes	No	No	No	No	No
UniData	Yes	No	Yes	No	Yes	No	No	No	No	No
UniVerse	Yes	No	Yes	No	Yes	No	No	No	No	No
YugabyteDB	Yes	Yes	Yes	No	No	No	No	No	No	No
	Windows	macOS	Linux	BSD	UNIX	AmigaOS	z/OS	iOS	Android	OpenVMS

Fundamental features

Information about what fundamental RDBMS features are implemented natively.

Database Name	ACID	Referential integrity	Transactions	Fine-grained locking	Multiversion concurrency control	Unicode	Interface	Type inference
4th Dimension	Yes	Yes	Yes	?	?	Yes	GUI & SQL	Yes
ADABAS	Yes	No	Yes	?	?	Yes	proprietary direct call & SQL (via 3rd party)	Yes
Adaptive Server Enterprise	Yes	Yes	Yes	Yes (Row-level locking)	Yes	Yes	API & GUI & SQL	Yes
Advantage Database Server	Yes	Yes	Yes	Yes (Row-level locking)	?	Yes4	API & SQL	Yes
Altibase	Yes	Yes	Yes	Yes (Row-level locking)	?	Yes	API & GUI & SQL	Yes
Apache Derby	Yes	Yes	Yes	Yes (Row-level locking) [50]	?	Yes	SQL	Yes
ClustrixDB	Yes	Yes	Yes	Yes	Yes	Yes	SQL	Yes
CockroachDB	Yes	Yes	Yes	Yes (Row-level locking)	Yes	Yes	SQL	No
CUBRID	Yes	Yes	Yes	Yes (Row-level locking)	?	Yes	GUI & SQL	Yes
DB2	Yes	Yes	Yes	Yes (Row-level locking)[51]	?	Yes	GUI & SQL	Yes
Empress Embedded Database	Yes	Yes	Yes	?	?	Yes	API & SQL	Yes
EXASolution	Yes	Yes	Yes	?	?	Yes	API & GUI & SQL	Yes
Firebird	Yes	Yes	Yes	?	Yes	Yes	API & SQL	Yes
HSQLDB	Yes	Yes	Yes	?	Yes	Yes	SQL	Yes
H2	Yes	Yes	Yes	?	Yes[52]	Yes	SQL	Yes
Informix Dynamic Server	Yes	Yes	Yes	Yes (Row-level locking)	Yes	Yes	SQL, REST, and JSON	Yes
Ingres	Yes	Yes	Yes	Yes (Row-level locking)	Yes	Yes	SQL & QUEL	Yes
InterBase	Yes	Yes	Yes	?	?	Yes	SQL	Yes
Linter SQL RDBMS	Yes	Yes	Yes (Except for DDL)	Yes (Row-level locking)	?	Yes	API & GUI & SQL	Yes
LucidDB	Yes	No	No	?	?	Yes	SQL	Yes
MariaDB	Yes2	Yes	Yes2 except for DDL[53][54]	Yes (Row-level locking)	Yes	Yes	SQL	Yes
MaxDB	Yes	Yes	Yes	?	?	Yes	SQL	Yes
Microsoft Access (JET)	Yes	Yes	Yes	?	?	Yes	GUI & SQL	Yes
Microsoft Visual FoxPro	Yes	Yes	Yes	Yes (Row-level locking SMB2)	Yes	No	GUI & SQL	Yes
Microsoft SQL Server	Yes	Yes	Yes	Yes (Row-level locking)[55]	Yes	Yes	GUI & SQL	Yes
Microsoft SQL Server Compact (Embedded Database)	Yes	Yes	Yes	?	?	Yes	GUI & SQL	Yes
Mimer SQL	Yes	Yes	Yes	Yes (Optimistic locking)	Yes	Yes	API & GUI & SQL	Yes
MonetDB	Yes	Yes	Yes	?	?	Yes	API & SQL & MAL	Yes
MySQL	Yes2	Yes3	Yes2 except for DDL[53]	Yes (Row-level locking)[56]	Yes	Yes	GUI 5 & SQL	Yes
OpenEdge	Yes	Yes6	Yes	Yes (Row-level locking)	?	Yes	GUI & SQL	Yes
OpenLink Virtuoso	Yes	Yes	Yes	?	?	Yes	API & GUI & SQL	Yes
Oracle	Yes	Yes	Yes except for DDL[53]	Yes (Row-level locking)[57]	Yes	Yes	API & GUI & SQL	Yes
Oracle Rdb	Yes	Yes	Yes	?	?	Yes	SQL	Yes
Pervasive PSQL	Yes	Yes	Yes	?	?	Yes	API & GUI & SQL	Yes
Polyhedra DBMS	Yes	Yes	Yes	Yes (optimistic and pessimistic cell-level locking)[58]	?	Yes	API & SQL	Yes
PostgreSQL	Yes	Yes	Yes	Yes (Row-level locking)[59]	Yes	Yes	API & GUI & SQL	No[60]
Raima Database Manager	Yes	Yes	Yes	?	Yes	Yes	SQL & API	Yes
RDM Server	Yes	Yes	Yes	?	?	Yes	SQL & API	Yes
SAP HANA	Yes	Yes	Yes	Yes (Row-level locking)	Yes	Yes	API & GUI & SQL	Yes
solidDB	Yes	Yes	Yes	Yes (Row-level locking)	?	Yes	API & SQL	Yes
SQL Anywhere	Yes	Yes	Yes	Yes (Row-level locking)[61]	Yes[62]	Yes	API & GUI & HTTP(S) (REST & SOAP)[63] & SQL	Yes
SQLBase	Yes	Yes	Yes	?	?	Yes	API & GUI & SQL	Yes
SQLite	Yes	Yes	Yes	No (Database-level locking)[64]	No	Optional[65]	API & SQL	Yes
Superbase NG	?	?	?	Yes (Record-level locking)	?	Yes	GUI & Propietary & ODBC	Yes
Teradata	Yes	Yes	Yes	Yes (Hash and Partition)	?	Yes	SQL	Yes
Tibero	Yes	Yes	Yes	Yes (Row-level locking)	Yes	Yes	API & GUI & SQL	Yes
UniData	Yes	No	Yes	?	?	Yes	Multiple	Yes
UniVerse	Yes	No	Yes	?	?	Yes	Multiple	Yes
Database Name	ACID	Referential integrity	Transactions	Fine-grained locking	Multiversion concurrency control	Unicode	Interface	Type inference

Note (1): Currently only supports read uncommited transaction isolation. Version 1.9 adds serializable isolation and version 2.0 will be fully ACID compliant.

Note (2): MariaDB and MySQL provide ACID compliance through the default InnoDB storage engine.^[66][67]

Note (3): "For other than InnoDB storage engines, MySQL Server parses and ignores the FOREIGN KEY and REFERENCES syntax in CREATE TABLE statements. The CHECK clause is parsed but ignored by all storage engines."^[68]

Note (4): Support for Unicode is new in version 10.0.

Note (5): MySQL provides GUI interface through MySQL Workbench.

Note (6): OpenEdge SQL database engine uses Referential Integrity, OpenEdge ABL Database engine does not and is handled via database triggers.

Limits

Information about data size limits.

	Max DB size	Max table size	Max row size	Max columns per row	Max Blob/Clob size	Max CHAR size	Max NUMBER size	Min DATE value	Max DATE value	Max column name size
4th Dimension	Limited	?	?	65,135	200 GB (2 GiB Unicode)	200 GB (2 GiB Unicode)	64 bits	?	?	?
Advantage Database Server	Unlimited	16 EiB	65,530 B	65,135 / (10+ AvgFieldNameLength)	4 GiB	?	64 bits	?	?	128
Apache Derby	Unlimited	Unlimited	Unlimited	1,012 (5,000 in views)	2,147,483,647 chars	254 (VARCHAR: 32,672)	64 bits	0001-01-01	9999-12-31	128
ClustrixDB	Unlimited	Unlimited	64 MB on Appliance, 4 MB on AWS	?	64 MB	64 MB	64 MB	0001-01-01	9999-12-31	254
CUBRID	2 EB	2 EB	Unlimited	Unlimited	Unlimited	1 GB	64 bits	0001-01-01	9999-12-31	254
DB2	Unlimited	2 ZB	1,048,319 B	1,012	2 GB	32 KiB	64 bits	0001-01-01	9999-12-31	128
Empress Embedded Database	Unlimited	263-1 bytes	2 GB	32,767	2 GB	2 GB	64 bits	0000-01-01	9999-12-31	32
EXASolution	Unlimited	Unlimited	Unlimited	10,000	N/A	2 MB	128 bits	0001-01-01	9999-12-31	256
FileMaker	8 TB	8 TB	8 TB	256,000,000	4 GB	10,000,000	1 billion characters, 10^-400 to 10^400, +-	0001-01-01	4000-12-31	100
Firebird	Unlimited1	~32 TB	65,536 B	Depends on data types used	32 GB	32,767 B	64 bits	100	32768	31
HSQLDB	64 TB	Unlimited8	Unlimited8	Unlimited8	64 TB7	Unlimited8	Unlimited8	0001-01-01	9999-12-31	128
H2	64 TB	Unlimited8	Unlimited8	Unlimited8	64 TB7	Unlimited8	64 bits	-99999999	99999999	Unlimited8
	Max DB size	Max table size	Max row size	Max columns per row	Max Blob/Clob size	Max CHAR size	Max NUMBER size	Min DATE value	Max DATE value	Max column name size
Informix Dynamic Server	~128 PB12	~128 PB12	32,765 bytes (exclusive of large objects)	32,765	4 TB	32,765	1032	01/01/000110	12/31/9999	128 bytes
Ingres	Unlimited	Unlimited	256 KB	1,024	2 GB	32 000 B	64 bits	0001	9999	256
InterBase	Unlimited1	~32 TB	65,536 B	Depends on data types used	2 GB	32,767 B	64 bits	100	32768	31
Linter SQL RDBMS	Unlimited	230 rows	64 KB (w/o BLOBs), 2GB (each BLOB value)	250	2 GB	4000 B	64 bits	0001-01-01	9999-12-31	66
MariaDB	Unlimited	MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB; Aria storage limits: ???	64 KB3	4,0964	4 GB (longtext, longblob)	64 KB (text)	64 bits	1000	9999	64[69]
Microsoft Access (JET)	2 GB	2 GB	16 MB	255	64 KB (memo field), 1 GB ("OLE Object" field)	255 B (text field)	32 bits	0100	9999	64
Microsoft Visual Foxpro	Unlimited	2 GB	65,500 B	255	2 GB	16 MB	32 bits	0001	9999	10
Microsoft SQL Server	524,272 TB (32 767 files * 16 TB max file size) 16ZB per instance	524,272 TB	8,060 bytes/2TB6	1,024/30,000(with sparse columns)	2 GB/Unlimited (using RBS/FILESTREAM object)	2 GB6	126 bits2	0001	9999	128
Microsoft SQL Server Compact (Embedded Database)	4 GB	4 GB	8,060 bytes	1024	2 GB	4000	154 bits	0001	9999	128
Mimer SQL	Unlimited	Unlimited	16000 (+lob data)	252	Unlimited	15000	45 digits	0001-01-01	9999-12-31	128
MonetDB	Unlimited	Unlimited	Unlimited	Unlimited	2 GB	2 GB	128 bits	-9999-01-01	9999-12-31	1024
MySQL	Unlimited	MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB	64 KB3	4,0964	4 GB (longtext, longblob)	64 KB (text)	64 bits	1000	9999	64
OpenLink Virtuoso	32 TB per instance (Unlimited via elastic cluster)	DB size (or 32 TB)	4 KB	200	2 GB	2 GB	231	0	9999	100
Oracle	2PB (with standard 8k block) 8PB (with max 32k block) 8EB (with max 32k block and BIGFILE option)	4 GB * block size (with BIGFILE tablespace)	8 KB	1,000	128 TB	32,767 B11	126 bits	−4712	9999	128
	Max DB size	Max table size	Max row size	Max columns per row	Max Blob/Clob size	Max CHAR size	Max NUMBER size	Min DATE value	Max DATE value	Max column name size
Pervasive PSQL	4 billion objects	256 GB	2 GB	1,536	2 GB	8,000 bytes	64 bits	01-01-0001	12-31-9999	128 bytes
Polyhedra	Limited by available RAM, address space	232 rows	Unlimited	65,536	4 GB (subject to RAM)	4 GB (subject to RAM)	64 bits	0001-01-01	8000-12-31	255
PostgreSQL	Unlimited	32 TB	1.6 TB	250–1600 depending on type	1 GB (text, bytea)[70] – stored inline or 4 TB (stored in pg_largeobject)[71]	1 GB	Unlimited	−4,713	5,874,897	63
Raima Database Manager	Unlimited	248-1 rows	32 KB	1,000	4 GB	char: 256, varchar: 4 KB	64 bits	0001-01-01	11758978-12-31	31
RDM Server	Unlimited	264-1 rows	32 KB	32,768	Unlimited	32 KB	64 bits	0001-01-01	11758978-12-31	32
SAP HANA	?	?	?	?	?	?	?	?	?	?
solidDB	256 TB	256 TB	32 KB + BLOB data	Limited by row size	4 GB	4 GB	64 bits	-32768-01-01	32767-12-31	254
SQL Anywhere[72]	104 TB (13 files, each file up to 8 TB (32 KB pages))	Limited by file size	Limited by file size	45,000	2 GB	2 GB	64 bits	0001-01-01	9999-12-31	128 bytes
SQLite	128 TB (231 pages * 64 KB max page size)	Limited by file size	Limited by file size	32,767	2 GB	2 GB	64 bits	No DATE type9	No DATE type9	Unlimited
Teradata	Unlimited	Unlimited	64000 wo/lobs (64 GB w/lobs)	2,048	2 GB	64,000	38 digits	0001-01-01	9999-12-31	128
UniVerse	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited
	Max DB size	Max table size	Max row size	Max columns per row	Max Blob/Clob size	Max CHAR size	Max NUMBER size	Min DATE value	Max DATE value	Max column name size

Note (1): Firebird 2.x maximum database size is effectively unlimited with the largest known database size >980 GB.^[73] Firebird 1.5.x maximum database size: 32 TB.

Note (2): Limit is 10³⁸ using DECIMAL datatype.^[74]

Note (3): InnoDB is limited to 8,000 bytes (excluding VARBINARY, VARCHAR, BLOB, or TEXT columns).^[75]

Note (4): InnoDB is limited to 1,017 columns.^[75]

Note (6): Using VARCHAR (MAX) in SQL 2005 and later.^[76]

Note (7): When using a page size of 32 KB, and when BLOB/CLOB data is stored in the database file.

Note (8): Java array size limit of 2,147,483,648 (2³¹) objects per array applies. This limit applies to number of characters in names, rows per table, columns per table, and characters per CHAR/VARCHAR.

Note (9): Despite the lack of a date datatype, SQLite does include date and time functions,^[77] which work for timestamps between 24 November 4714 B.C. and 1 November 5352.

Note (10): 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.

Note (11): Since version 12c. Earlier versions support up to 4000 B.

Note (12): The 128PB limit refers to the storage limit of a single Informix server instance. 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.

Tables and views

Information about what tables and views (other than basic ones) are supported natively.

	Temporary table	Materialized view
4th Dimension	Yes	No
ADABAS	?	?
Adaptive Server Enterprise	Yes1	Yes – see precomputed result sets
Advantage Database Server	Yes	No (only common views)
Altibase	Yes	No (only common views)
Apache Derby	Yes	No
ClustrixDB	Yes	No
CUBRID	No	No
DB2	Yes	Yes
Empress Embedded Database	Yes	Yes
EXASolution	Yes	No
Firebird	Yes	No (only common views)
HSQLDB	Yes	No
H2	Yes	No (only common views)
Informix Dynamic Server	Yes	No2
Ingres	Yes	No
InterBase	Yes	No
Linter SQL RDBMS	Yes	Yes
LucidDB	No	No
MariaDB	Yes	No4
MaxDB	Yes	No
Microsoft Access (JET)	No	No
Microsoft Visual Foxpro	Yes	Yes
Microsoft SQL Server	Yes	Yes
Microsoft SQL Server Compact (Embedded Database)	Yes	No
Mimer SQL	No	No
MonetDB	Yes	No (only common views)
MySQL	Yes	No4
Oracle	Yes	Yes
Oracle Rdb	Yes	Yes
OpenLink Virtuoso	Yes	Yes
Pervasive PSQL	Yes	No
Polyhedra DBMS	No	No (only common views)
PostgreSQL	Yes	Yes5
Raima Database Manager	Yes	No
RDM Server	Yes	No
SAP HANA	Yes	?
solidDB	Yes	No (only common views)
SQL Anywhere	Yes	Yes
SQLite	Yes	No
Superbase	Yes	Yes
Teradata	Yes	Yes
UniData	Yes	No
UniVerse	Yes	No
	Temporary table	Materialized view

Note (1): Server provides tempdb, which can be used for public and private (for the session) temp tables.^[78]

Note (2): 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.^[79]

Note (4): Materialized views can be emulated using stored procedures and triggers.^[80]

Note (5): Materialized views are now standard.

Indexes

Information about what indexes (other than basic B-/B+ tree indexes) are supported natively.

	R-/R+ tree	Hash	Expression	Partial	Reverse	Bitmap	GiST	GIN	Full-text	Spatial	FOT	Duplicate index prevention
4th Dimension	?	Cluster	?	?	?	?	?	?	Yes	?	?	No
ADABAS	?	?	?	?	?	?	?	?	?	?	?	No
Adaptive Server Enterprise	No	No	Yes	No	Yes	No	No	No	Yes	?	?	No
Advantage Database Server	No	No	Yes	No	Yes	Yes	No	No	Yes	?	?	No
Apache Derby	No	No	No	No	No	No	No	No	No[81]	?	?	No
ClustrixDB	No	Yes	No	No	No	No	No	No	No	No	?	No
CUBRID	No	No	Yes[82]	Yes[82]	Yes	No	No	No	No	No	No	No
DB2	Yes	Yes	Yes	No	Yes	Yes	No	No	Yes[83]	?	?	No
Empress Embedded Database	Yes	No	No	Yes	No	Yes	No	No	No	?	?	No
EXASolution	No	Yes	No	No	No	No	No	No	No	?	?	No
Firebird	No	No	Yes	No	Yes	No	No	No	No[84]	?	?	No
HSQLDB	No	No	No	No	No	No	No	No	No	?	?	No
H2	No	Yes	No	No	No	No	No	No	Yes[85]	Yes[86]	?	No
Informix Dynamic Server	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes[87]	Yes
Ingres	Yes	Yes	Ingres v10	No	No	Ingres v10	No	No	No	?	?	No
InterBase	No	No	No	No	No	No	No	No	No	?	?	No
Linter SQL RDBMS10	No	Yes temporary indexes for equality joins	Yes for some scalar functions like LOWER and UPPER	No	No	No	No	No	Yes[88]	No	No	Yes
LucidDB	No	No	No	No	No	Yes	No	No	No	?	?	No
MariaDB	Aria and MyISAM tables and, since v10.2.2, InnoDB tables only[89]	MEMORY,[90] InnoDB,5 tables only	PERSISTENT virtual columns only[91]	No	No	No	No	No	Yes[92]	Aria and MyISAM tables and, since v10.2.2, InnoDB tables only[89]	?	No
MaxDB	No	No	No	No	No	No	No	No	No	?	?	No
Microsoft Access (JET)	No	No	No	No	No	No	No	No	No[93]	?	?	No
Microsoft Visual Foxpro	No	No	Yes	Yes	Yes2	Yes	No	No	No	?	?	No
Microsoft SQL Server	Spatial Indexes	Yes4	Yes3	Yes	on Computed columns3	Bitmap filter index for Star Join Query	No	No	Yes[94]	Yes[95]	?	No
Microsoft SQL Server Compact (Embedded Database)	No	No	No	No	No	No	No	No	No[96]	?	?	No
Mimer SQL	No	No	No	No	Yes	No	No	No	Yes	Yes	No	No
MonetDB	No	Yes	No	No	No	No	No	No	No	No	No	No
MySQL	Spatial Indexes[97]	MEMORY, Cluster (NDB), InnoDB,5 tables only	No[98]	No	No	No	No	No	MyISAM tables[99] and, since v5.6.4, InnoDB tables[100]	MyISAM tables[101] and, since v5.7.5, InnoDB tables[102]	?	No
OpenLink Virtuoso	Yes	Cluster	Yes	Yes	No	Yes	No	No	Yes	Yes (Commercial only)	No	No
Oracle	Yes 11	Cluster Tables	Yes	Yes 6	Yes	Yes	No	No	Yes[103]	Yes[104]	?	Yes[105]
Oracle Rdb	No	Yes	?	No	No	?	No	No	?	?	?	No
Pervasive PSQL	No	No	No	No	No	No	No	No	No	No	No	No
Polyhedra DBMS	No	Yes	No	No	No	No	No	No	No	No	?	No
PostgreSQL	Yes	Yes	Yes	Yes	Yes7	Yes	Yes	Yes	Yes[106]	PostGIS[107]	?	No
Raima Database Manager	Yes	Yes	No	Yes	Yes	No	No	No	No	Yes	No	No
RDM Server	No	No	No	Yes	Yes	No	No	No	No	No	No	No
SAP HANA	?	?	?	?	?	?	?	?	?	?	?	No
solidDB	No	No	No	No	Yes	No	No	No	No	No	No	No
SQL Anywhere	No	No	Yes	No	No	No	No	No	Yes	Yes	?	Yes
SQLite	Yes[108]	No	Yes[109]	Yes	No	No	No	No	Yes[110]	SpatiaLite[111]	?	No
SQream DB	?	?	?	?	Yes	?	?	?	?	?	?	No
Teradata	No	Yes	Yes	Yes	No	Yes	No	No	?[112]	?	?	No
UniVerse	Yes	Yes	Yes3	Yes3	Yes3	No	No	No	?	Yes[113]	?	No
	R-/R+ tree	Hash	Expression	Partial	Reverse	Bitmap	GiST	GIN	Full-text	Spatial	FOT	Duplicate index prevention

Note (1): The users need to use a function from freeAdhocUDF library or similar.^[114]

Note (2): Can be implemented for most data types using expression-based indexes.

Note (3): Can be emulated by indexing a computed column^[115] (doesn't easily update) or by using an "Indexed View"^[116] (proper name not just any view works^[117]).

Note (4): Used for InMemory ColumnStore index, temporary hash index for hash join, Non/Cluster & fill factor.

Note (5): InnoDB automatically generates adaptive hash index^[118] entries as needed.

Note (6): 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.

Note (7): A PostgreSQL functional index can be used to reverse the order of a field.

Note (10): B+ tree and full-text only for now.

Note (11): R-Tree indexing available in base edition with Locator but some functionality requires Personal Edition or Enterprise Edition with Spatial option.

Database capabilities

	Union	Intersect	Except	Inner joins	Outer joins	Inner selects	Merge joins	Blobs and Clobs	Common Table Expressions	Windowing Functions	Parallel Query	System-versioned Tables
4th Dimension	Yes	Yes	Yes	Yes	Yes	No	No	Yes	?	?	?	?
ADABAS	Yes	?	?	?	?	?	?	?	?	?	?	?
Adaptive Server Enterprise	Yes	?	?	Yes	Yes	Yes	Yes	Yes	?	?	Yes	?
Advantage Database Server	Yes	No	No	Yes	Yes	Yes	Yes	Yes	?	No	?	?
Altibase	Yes	Yes	Yes, via MINUS	Yes	Yes	Yes	Yes	Yes	No	No	No	?
Apache Derby	Yes	Yes	Yes	Yes	Yes	Yes	?	Yes	No	No	?	?
ClustrixDB	Yes	No	No	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	?
CUBRID	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes[82]	?	?
DB2	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes[119]	Yes[120]
Empress Embedded Database	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?	?	?
EXASolution	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	?
Firebird	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?
HSQLDB	Yes	Yes	Yes	Yes	Yes	Yes	Yes[121]	Yes	Yes	No	Yes[121]	?
H2	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	experimental[122]	Yes[123]	?	?
Informix Dynamic Server	Yes	Yes	Yes, via MINUS	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes[124]	?
Ingres	Yes	No	No	Yes	Yes	Yes	Yes	Yes	No	No	?	?
InterBase	Yes	?	?	Yes	Yes	?	?	Yes	?	?	?	?
Linter SQL RDBMS	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No
LucidDB	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	?	?	?	?
MariaDB	Yes	10.3+[125]	10.3+[126]	Yes	Yes	Yes	No	Yes	Yes[127]	Yes[128]	No[129]	Yes[120]
MaxDB	Yes	?	?	Yes	Yes	Yes	No	Yes	?	?	?	?
Microsoft Access (JET)	Yes	No	No	Yes	Yes	Yes	No	Yes	No	No	?	?
Microsoft Visual Foxpro	Yes	?	?	Yes	Yes	Yes	?	Yes	?	?	?	?
Microsoft SQL Server	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes[130]	Yes[131]	Yes[120]
Microsoft SQL Server Compact (Embedded Database)	Yes	No	No	Yes	Yes	?	No	Yes	No	No	?	?
Mimer SQL	Yes	Yes	Yes	Yes	Yes	Yes	?	Yes	Yes	No	No	?
MonetDB	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
MySQL	Yes	No	No	Yes	Yes	Yes	No	Yes	8+[132]	No	No[129]	No[120]
OpenBase SQL	No	No	No	Yes	Yes	Yes	Yes	Yes	?	?	?	?
OpenLink Virtuoso	Yes	Yes	Yes	Yes	Yes	Yes	?	Yes	?	?	Yes	?
Oracle	Yes	Yes	Yes, via MINUS	Yes	Yes	Yes	Yes	Yes	Yes 1	Yes	Yes[133]	No[120]
Oracle Rdb	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?	?	?
Pervasive PSQL	Yes	No	No	Yes	Yes	?	?	Yes	No	No	No	?
Polyhedra DBMS	Yes	Yes	Yes	Yes	Yes	No	No	Yes	No	No	No	?
PostgreSQL	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes[134]	No[120]
Raima Database Manager	No	No	No	Yes	Yes	No	No	Yes	No	No	No	?
RDM Server	Yes	No	No	Yes	Yes	Yes	No	Yes	No	No	No	?
SAP HANA	?	?	?	?	?	?	?	?	?	?	?	?
solidDB	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	?
SQL Anywhere	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?
SQLite	Yes	Yes	Yes	Yes	LEFT only	Yes	No	Yes	3.8.3+[135]	3.25+[136]	No	No[120]
SQream DB	ALL only	No	No	Yes	Yes	Yes	Yes	No	Yes	Yes	No	?
Teradata	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?
UniVerse	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	?	?
	Union	Intersect	Except	Inner joins	Outer joins	Inner selects	Merge joins	Blobs and Clobs	Common Table Expressions	Windowing Functions	Parallel Query	System-versioned Tables

Note (1):Recursive CTEs introduced in 11gR2 supersedes similar construct called CONNECT BY.

Data types

	Type system	Integer	Floating point	Decimal	String	Binary	Date/Time	Boolean	Other
4th Dimension	Static	UUID (16-bit), SMALLINT (16-bit), INT (32-bit), BIGINT (64-bit), NUMERIC (64-bit)	REAL, FLOAT	REAL, FLOAT	CLOB, TEXT, VARCHAR	BIT, BIT VARYING, BLOB	DURATION, INTERVAL, TIMESTAMP	BOOLEAN	PICTURE
Altibase[137]	Static	SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	REAL (32-bit), DOUBLE (64-bit)	DECIMAL, NUMERIC, NUMBER, FLOAT	CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB	BLOB, BYTE, NIBBLE, BIT, VARBIT	DATE		GEOMETRY
ClustrixDB[138]	Static	TINYINT (8-bit), SMALLINT (16-bit), MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit)	FLOAT (32-bit), DOUBLE	DECIMAL	CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT	TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB	DATETIME, DATE, TIMESTAMP, YEAR	BIT(1), BOOLEAN	ENUM, SET,
CUBRID[139]	Static	SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	FLOAT, REAL(32-bit), DOUBLE(64-bit)	DECIMAL, NUMERIC	CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB	BLOB	DATE, DATETIME, TIME, TIMESTAMP	BIT	MONETARY, BIT VARYING, SET, MULTISET, SEQUENCE, ENUM
DB2	?	SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	DECFLOAT, REAL, DOUBLE	DECIMAL	CLOB, CHAR, VARCHAR	BINARY, VARBINARY, BLOB	DATE, TIME, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITHOUT TIME ZONE	BOOLEAN	XML, GRAPHIC, VARGRAPHIC, DBCLOB, ROWID
Empress Embedded Database	Static	TINYINT, SQL_TINYINT, or INTEGER8; SMALLINT, SQL_SMALLINT, or INTEGER16; INTEGER, INT, SQL_INTEGER, or INTEGER32; BIGINT, SQL_BIGINT, or INTEGER64	REAL, SQL_REAL, or FLOAT32; DOUBLE PRECISION, SQL_DOUBLE, or FLOAT64; FLOAT, or SQL_FLOAT; EFLOAT	DECIMAL, DEC, NUMERIC, SQL_DECIMAL, or SQL_NUMERIC; DOLLAR	CHARACTER, ECHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, NLSCHARACTER, CHARACTER LARGE OBJECT, TEXT, NATIONAL CHARACTER LARGE OBJECT, NLSTEXT	BINARY LARGE OBJECT or BLOB; BULK	DATE, EDATE, TIME, ETIME, EPOCH_TIME, TIMESTAMP, MICROTIMESTAMP	BOOLEAN	SEQUENCE 32, SEQUENCE
EXASolution	Static	TINYINT, SMALLINT, INTEGER, BIGINT,	REAL, FLOAT, DOUBLE	DECIMAL, DEC, NUMERIC, NUMBER	CHAR, NCHAR, VARCHAR, VARCHAR2, NVARCHAR, NVARCHAR2, CLOB, NCLOB	N/A	DATE, TIMESTAMP, INTERVAL	BOOLEAN, BOOL	GEOMETRY
FileMaker[140]	Static	Not Supported	Not Supported	NUMBER	TEXT	CONTAINER	TIMESTAMP	Not Supported
Firebird[141]	?	INT64, INTEGER, SMALLINT	DOUBLE, FLOAT	DECIMAL, NUMERIC, DECIMAL(18, 4), DECIMAL(10, 4)	BLOB, CHAR, CHAR(x) CHARACTER SET UNICODE_FSS, VARCHAR(x) CHARACTER SET UNICODE_FSS, VARCHAR	BLOB SUB_TYPE TEXT, BLOB	DATE, TIME, TIMESTAMP (without time zone)	BOOLEAN	TIMESTAMP, CHAR(38), User defined types (Domains)
	Type system	Integer	Floating point	Decimal	String	Binary	Date/Time	Boolean	Other
HSQLDB[142]	Static	TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	DOUBLE (64-bit)	DECIMAL, NUMERIC	CHAR, VARCHAR, LONGVARCHAR, CLOB	BINARY, VARBINARY, LONGVARBINARY, BLOB	DATE, TIME, TIMESTAMP, INTERVAL	BOOLEAN	OTHER (object), BIT, BIT VARYING, ARRAY
Informix Dynamic Server[143]	Static + UDT	SMALLINT (16-bit), INT (32-bit), INT8 (64-bit proprietary), BIGINT (64-bit)	SMALLFLOAT (32-bit), FLOAT (64-bit)	DECIMAL (32 digits float/fixed), MONEY	CHAR, VARCHAR, NCHAR, NVARCHAR, LVARCHAR, CLOB, TEXT	TEXT, BYTE, BLOB, CLOB	DATE, DATETIME, INTERVAL	BOOLEAN	SET, LIST, MULTISET, ROW, TIMESERIES, SPATIAL, GEODETIC, JSON, BSON, USER DEFINED TYPES
Ingres[144]	Static	TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	FLOAT4 (32-bit), FLOAT (64-bit)	DECIMAL	C, CHAR, VARCHAR, LONG VARCHAR, NCHAR, NVARCHAR, LONG NVARCHAR, TEXT	BYTE, VARBYTE, LONG VARBYTE (BLOB)	DATE, ANSIDATE, INGRESDATE, TIME, TIMESTAMP, INTERVAL	N/A	MONEY, OBJECT_KEY, TABLE_KEY, USER-DEFINED DATA TYPES (via OME)
Linter SQL RDBMS	Static + Dynamic (in stored procedures)	SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	REAL(32-bit), DOUBLE(64-bit)	DECIMAL, NUMERIC	CHAR, VARCHAR, NCHAR, NVARCHAR, BLOB	BYTE, VARBYTE, BLOB	DATE	BOOLEAN	GEOMETRY, EXTFILE
MariaDB[145]	Static	TINYINT (8-bit), SMALLINT (16-bit), MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit)	FLOAT (32-bit), DOUBLE (aka REAL) (64-bit)	DECIMAL	CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT	TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB	DATETIME, DATE, TIMESTAMP, YEAR	BIT(1), BOOLEAN (aka BOOL) = synonym for TINYINT	ENUM, SET, GIS data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon)
Microsoft SQL Server[146]	Static	TINYINT, SMALLINT, INT, BIGINT	FLOAT, REAL	NUMERIC, DECIMAL, SMALLMONEY, MONEY	CHAR, VARCHAR, TEXT, NCHAR, NVARCHAR, NTEXT	BINARY, VARBINARY, IMAGE, FILESTREAM, FILETABLE	DATE, DATETIMEOFFSET, DATETIME2, SMALLDATETIME, DATETIME, TIME	BIT	CURSOR, TIMESTAMP, HIERARCHYID, UNIQUEIDENTIFIER, SQL_VARIANT, XML, TABLE, Geometry, Geography, Custom .NET datatypes
Microsoft SQL Server Compact (Embedded Database)[147]	Static	TINYINT, SMALLINT, INT, BIGINT	FLOAT, REAL	NUMERIC, DECIMAL, MONEY	NCHAR, NVARCHAR, NTEXT	BINARY, VARBINARY, IMAGE	DATETIME	BIT	TIMESTAMP, ROWVERSION, UNIQUEIDENTIFIER, IDENTITY, ROWGUIDCOL
Mimer SQL	Static	SMALLINT, INT, BIGINT, INTEGER(n)	FLOAT, REAL, DOUBLE, FLOAT(n)	NUMERIC, DECIMAL	CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB, NCLOB	BINARY, VARBINARY, BLOB	DATE, TIME, TIMESTAMP, INTERVAL	BOOLEAN	DOMAINS, USER-DEFINED TYPES (including the pre-defined spatial data types location, latitude, longitude and coordinate, and UUID)
MonetDB	Static, extensible	TINYINT, SMALLINT, INT, INTEGER, BIGINT, HUGEINT, SERIAL, BIGSERIAL	FLOAT, FLOAT(n), REAL, DOUBLE, DOUBLE PRECISION	DECIMAL, NUMERIC	CHAR, CHAR(n), VARCHAR(n), CLOB, CLOB(n), TEXT, STRING	BLOB, BLOB(n)	DATE, TIME, TIME WITH TIME ZONE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, INTERVAL MONTH, INTERVAL DAY, INTERVAL SECOND	BOOLEAN	JSON, JSON(n), URL, URL(n), INET, UUID, GIS data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon), User Defined Types
MySQL[138]	Static	TINYINT (8-bit), SMALLINT (16-bit), MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit)	FLOAT (32-bit), DOUBLE (aka REAL) (64-bit)	DECIMAL	CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT	TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB	DATETIME, DATE, TIMESTAMP, YEAR	BIT(1), BOOLEAN (aka BOOL) = synonym for TINYINT	ENUM, SET, GIS data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon)
OpenLink Virtuoso[148]	Static + Dynamic	INT, INTEGER, SMALLINT	REAL, DOUBLE PRECISION, FLOAT, FLOAT'('INTNUM')'	DECIMAL, DECIMAL'('INTNUM')', DECIMAL'('INTNUM', 'INTNUM')', NUMERIC, NUMERIC'('INTNUM')', NUMERIC'('INTNUM', 'INTNUM')'	CHARACTER, CHAR'('INTNUM')', VARCHAR, VARCHAR'('INTNUM')', NVARCHAR, NVARCHAR'('INTNUM')'	BLOB	TIMESTAMP, DATETIME, TIME, DATE	n/a	ANY, REFERENCE (IRI, URI), UDT (User Defined Type), GEOMETRY (BOX, BOX2D, BOX3D, BOXM, BOXZ, BOXZM, CIRCULARSTRING, COMPOUNDCURVE, CURVEPOLYGON, EMPTY, GEOMETRYCOLLECTION, GEOMETRYCOLLECTIONM, GEOMETRYCOLLECTIONZ, GEOMETRYCOLLECTIONZM, LINESTRING, LINESTRINGM, LINESTRINGZ, LINESTRINGZM, MULTICURVE, MULTILINESTRING, MULTILINESTRINGM, MULTILINESTRINGZ, MULTILINESTRINGZM, MULTIPOINT, MULTIPOINTM, MULTIPOINTZ, MULTIPOINTZM, MULTIPOLYGON, MULTIPOLYGONM, MULTIPOLYGONZ, MULTIPOLYGONZM, POINT, POINTM, POINTZ, POINTZM, POLYGON, POLYGONM, POLYGONZ, POLYGONZM, POLYLINE, POLYLINEZ, RING, RINGM, RINGZ, RINGZM)
	Type system	Integer	Floating point	Decimal	String	Binary	Date/Time	Boolean	Other
Oracle[149]	Static + Dynamic (through ANYDATA)	NUMBER	BINARY_FLOAT, BINARY_DOUBLE	NUMBER	CHAR, VARCHAR2, CLOB, NCLOB, NVARCHAR2, NCHAR, LONG (deprecated)	BLOB, RAW, LONG RAW (deprecated), BFILE	DATE, TIMESTAMP (with/without TIME ZONE), INTERVAL	N/A	SPATIAL, IMAGE, AUDIO, VIDEO, DICOM, XMLType, UDT, JSON
Pervasive PSQL[150]	Static	BIGINT, INTEGER, SMALLINT, TINYINT, UBIGINT, UINTEGER, USMALLINT, UTINYINT	BFLOAT4, BFLOAT8, DOUBLE, FLOAT	DECIMAL, NUMERIC, NUMERICSA, NUMERICSLB, NUMERICSLS, NUMERICSTB, NUMERICSTS	CHAR, LONGVARCHAR, VARCHAR	BINARY, LONGVARBINARY, VARBINARY	DATE, DATETIME, TIME	BIT	CURRENCY, IDENTITY, SMALLIDENTITY, TIMESTAMP, UNIQUEIDENTIFIER
Polyhedra[151]	Static	INTEGER8 (8-bit), INTEGER(16-bit), INTEGER (32-bit), INTEGER64 (64-bit)	FLOAT32 (32-bit), FLOAT (aka REAL; 64-bit)	N/A	VARCHAR, LARGE VARCHAR (aka CHARACTER LARGE OBJECT)	LARGE BINARY (aka BINARY LARGE OBJECT)	DATETIME	BOOLEAN	N/A
PostgreSQL[152]	Static	SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	REAL (32-bit), DOUBLE PRECISION (64-bit)	DECIMAL, NUMERIC	CHAR, VARCHAR, TEXT	BYTEA	DATE, TIME (with/without TIME ZONE), TIMESTAMP (with/without TIME ZONE), INTERVAL	BOOLEAN	ENUM, POINT, LINE, LSEG, BOX, PATH, POLYGON, CIRCLE, CIDR, INET, MACADDR, BIT, UUID, XML, JSON, JSONB, arrays, composites, ranges, custom
Raima Database Manager[153]	Static	tinyint, smallint, integer, bigint	real, float, double	N/A	char, varchar, wchar, varwchar, long varchar, long varwchar	binary, varbinary, long varbinary	date, time, timestamp	bit	N/A
RDM Server[154]	Static	tinyint, smallint, integer, bigint	real, float, double	decimal, numeric	char, varchar, wchar, varwchar, long varchar, long varwchar	binary, varbinary, long varbinary	date, time, timestamp	bit	rowid
SAP HANA	Static	TINYINT, SMALLINT, INTEGER, BIGINT	SMALLDECIMAL, REAL, DOUBLE, FLOAT, FLOAT(n)	DECIMAL	VARCHAR, NVARCHAR, ALPHANUM, SHORTTEXT	VARBINARY, BINTEXT, BLOB	DATE, TIME, SECONDDATE, TIMESTAMP	BOOLEAN	CLOB, NCLOB, TEXT, ARRAY, ST_GEOMETRY, ST_POINT, ST_MULTIPOINT, ST_LINESTRING, ST_MULTILINESTRING, ST_POLYGON, ST_MULTIPOLYGON, ST_GEOMETRYCOLLECTION, ST_CIRCULARSTRING
solidDB	Static	TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	REAL (32-bit), DOUBLE (64-bit), FLOAT (64-bit)	DECIMAL, NUMERIC (51 digits)	CHAR, VARCHAR, LONG VARCHAR, WCHAR, WVARCHAR, LONG WVARCHAR	BINARY, VARBINARY, LONG VARBINARY	DATE, TIME, TIMESTAMP
SQLite[155]	Dynamic	INTEGER (64-bit)	REAL (aka FLOAT, DOUBLE) (64-bit)	N/A	TEXT (aka CHAR, CLOB)	BLOB	N/A	N/A	N/A
SQream DB[156]	Static	TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	REAL (32-bit), DOUBLE (aka FLOAT) (64-bit)	N/A	CHAR, VARCHAR, NVARCHAR	N/A	DATE, DATETIME (aka TIMESTAMP)	BOOL	N/A
	Type system	Integer	Floating point	Decimal	String	Binary	Date/Time	Boolean	Other
Teradata	Static	BYTEINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)	FLOAT (64-bit)	DECIMAL, NUMERIC (38 digits)	CHAR, VARCHAR, CLOB	BYTE, VARBYTE, BLOB	DATE, TIME, TIMESTAMP (w/wo TIME ZONE)		PERIOD, INTERVAL, GEOMETRY, XML, JSON, UDT (User Defined Type)
UniData	Dynamic	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A
UniVerse	Dynamic	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A
	Type system	Integer	Floating point	Decimal	String	Binary	Date/Time	Boolean	Other

Other objects

Information about what other objects are supported natively.

	Data Domain	Cursor	Trigger	Function 1	Procedure 1	External routine 1
4th Dimension	Yes	No	Yes	Yes	Yes	Yes
ADABAS	?	Yes	?	Yes?	Yes?	Yes
Adaptive Server Enterprise	Yes	Yes	Yes	Yes	Yes	Yes
Advantage Database Server	Yes	Yes	Yes	Yes	Yes	Yes
Altibase	Yes	Yes	Yes	Yes	Yes	Yes
Apache Derby	No	Yes	Yes	Yes 2	Yes 2	Yes 2
ClustrixDB	No	Yes	No	Yes	Yes	Yes
CUBRID	Yes	Yes	Yes	Yes	Yes 2	Yes
Empress Embedded Database	Yes via RANGE CHECK	Yes	Yes	Yes	Yes	Yes
EXASolution	Yes	No	No	Yes	Yes	Yes
DB2	Yes via CHECK CONSTRAINT	Yes	Yes	Yes	Yes	Yes
Firebird	Yes	Yes	Yes	Yes	Yes	Yes
HSQLDB	Yes	No	Yes	Yes	Yes	Yes
H2	Yes	No	Yes 2	Yes 2	Yes 2	Yes
Informix Dynamic Server	Yes via CHECK	Yes	Yes	Yes	Yes	Yes  5
Ingres	Yes	Yes	Yes	Yes	Yes	Yes
InterBase	Yes	Yes	Yes	Yes	Yes	Yes
Linter SQL RDBMS	No	Yes	Yes	Yes	Yes	No
LucidDB	No	Yes	No	Yes 2	Yes 2	Yes 2
MariaDB	Yes[157]	Yes	Yes	Yes	Yes	Yes
MaxDB	Yes	Yes	Yes	Yes	Yes	?
Microsoft Access (JET)	Yes	No	No	No	Yes, But single DML/DDL Operation	Yes
Microsoft Visual Foxpro	No	Yes	Yes	Yes	Yes	Yes
Microsoft SQL Server	Yes	Yes	Yes	Yes	Yes	Yes
Microsoft SQL Server Compact (Embedded Database)	No	Yes	No	No	No	No
Mimer SQL	Yes	Yes	Yes	Yes	Yes	No
MonetDB	No	No	Yes	Yes	Yes	Yes
MySQL	No  3	Yes	Yes	Yes	Yes	Yes
OpenBase SQL	Yes	Yes	Yes	Yes	Yes	Yes
Oracle	Yes	Yes	Yes	Yes	Yes	Yes
Oracle Rdb	Yes	Yes	Yes	Yes	Yes	Yes
OpenLink Virtuoso	Yes	Yes	Yes	Yes	Yes	Yes
Pervasive PSQL	Yes	Yes	Yes	Yes	Yes	No
Polyhedra DBMS	No	No	Yes	Yes	Yes	Yes
PostgreSQL	Yes	Yes	Yes	Yes	Yes	Yes
Raima Database Manager	No	Yes	No	No	Yes	Yes
RDM Server	No	Yes	Yes	No	Yes	Yes
SAP HANA	?	?	?	?	?	?
solidDB	Yes	Yes	Yes	Yes	Yes	Yes
SQL Anywhere	Yes	Yes	Yes	Yes	Yes	Yes
SQLite	No	No	Yes	No	No	Yes
Teradata	No	Yes	Yes	Yes	Yes	Yes
UniData	No	No	Yes	Yes	Yes	Yes
UniVerse	No	No	Yes	Yes	Yes	Yes
	Data Domain	Cursor	Trigger	Function 1	Procedure 1	External routine 1

Note (1): 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.

Note (2): In Derby, H2, LucidDB, and CUBRID, users code functions and procedures in Java.

Note (3): ENUM datatype exists. CHECK clause is parsed, but not enforced in runtime.

Note (5): Informix supports external functions written in Java, C, & C++.

Partitioning

Information about what partitioning methods are supported natively.

	Range	Hash	Composite (Range+Hash)	List	Expression	Round Robin
4th Dimension	?	?	?	?	?	?
ADABAS	?	?	?	?	?	?
Adaptive Server Enterprise	Yes	Yes	No	Yes	?	?
Advantage Database Server	No	No	No	No	?	?
Altibase	Yes	Yes	No	Yes	?	?
Apache Derby	No	No	No	No	?	?
ClustrixDB	Yes	No	No	No	No	?
CUBRID	Yes	Yes	No	Yes	?	?
IBM DB2	Yes	Yes	Yes	Yes	Yes	?
Empress Embedded Database	No	No	No	No	?	?
EXASolution	No	Yes	No	No	No	?
Firebird	No	No	No	No	?	?
HSQLDB	No	No	No	No	?	?
H2	No	No	No	No	?	?
Informix Dynamic Server	Yes	Yes	Yes	Yes	Yes	Yes
Ingres	Yes	Yes	Yes	Yes	?	?
InterBase	No	No	No	No	?	?
Linter SQL RDBMS	No	No	No	No	No	?
MariaDB	Yes	Yes	Yes	Yes	?	?
MaxDB	No	No	No	No	?	?
Microsoft Access (JET)	No	No	No	No	?	?
Microsoft Visual Foxpro	No	No	No	No	?	?
Microsoft SQL Server	Yes	via computed column	via computed column	Yes	via computed column	?
Microsoft SQL Server Compact (Embedded Database)	No	No	No	No	?	?
Mimer SQL	No	No	No	No	No	?
MonetDB	Yes	No	No	No	Yes	?
MySQL	Yes	Yes	Yes	Yes	?	?
OpenBase SQL	?	?	?	?	?	?
Oracle	Yes	Yes	Yes	Yes	via Virtual Columns	?
Oracle Rdb	Yes	Yes	?	?	?	?
OpenLink Virtuoso	Yes	Yes	Yes	Yes	Yes	?
Pervasive PSQL	No	No	No	No	No	?
Polyhedra DBMS	No	No	No	No	No	?
PostgreSQL	Yes	Yes	Yes	Yes	Yes	?
Raima Database Manager	Yes1	Yes1	Yes1	No	?	?
RDM Server	No	No	No	No	?	?
SAP HANA	Yes	Yes	Yes	Yes	Yes	?
solidDB	Yes	No	No	No	?	?
SQL Anywhere	No	No	No	No	?	?
SQLite	No	No	No	No	?	?
Teradata	Yes	Yes	Yes	Yes	?	?
UniVerse	Yes	Yes	Yes	Yes	?	?
	Range	Hash	Composite (Range+Hash)	List	Expression	Round Robin

Note (1): Raima Database Manager 14.0 requires the application programs to select the correct partition (using range, hash or composite techniques) when adding data, but the database union functionality allows all partitions to be read as a single database.^[158]

Access control

Information about access control functionalities (work in progress).

	Native network encryption1	Brute-force protection	Enterprise directory compatibility	Password complexity rules2	Patch access3	Run unprivileged4	Audit	Resource limit	Separation of duties (RBAC)5	Security Certification	Attribute-Based Access Control (ABAC)
4D	Yes (with SSL)	?	Yes	?	Yes	Yes	?	?	?	?	?
Adaptive Server Enterprise	Yes (optional; to pay)	Yes	Yes (optional ?)	Yes	Partial (need to register; depend on which product)[159]	Yes	Yes	Yes	Yes	Yes (EAL4+ 1)	?
Advantage Database Server	Yes	No	No	No	Yes	Yes	No	No	Yes	?	?
DB2	Yes	?	Yes (LDAP, Kerberos...)	Yes	?	Yes	Yes	Yes	Yes	Yes (EAL4+6)	?
Empress Embedded Database	?	?	No	No	Yes	Yes	Yes	No	Yes	No	?
EXASolution	No	No	Yes (LDAP)	No	Yes	Yes	Yes	Yes	Yes	No	?
Firebird	Yes	Yes[160]	Yes (Windows trusted authenification)	Yes (by custom plugin)	Yes (no security page)[161]	Yes	Yes[162]	Yes	No7	?	?
HSQLDB	Yes	No	Yes	Yes	Yes	Yes	No	No	Yes	No	?
H2	Yes	Yes	?	No	?	Yes	?	Yes	Yes	No	?
Informix Dynamic Server	Yes	?	Yes10	?10	Yes	Yes	Yes	Yes	Yes	?	Yes
Linter SQL RDBMS	Yes (with SSL)	Yes	Yes	Yes (length only)	Yes	Yes	Yes	Yes	Yes	Yes	Yes
MariaDB	Yes (SSL)	No	Yes (with 5.2, but not on Windows servers)	Yes[163][164]	Yes[165]	Yes	?	?	?8	No	?
Microsoft SQL Server	Yes	?	Yes (Microsoft Active Directory)	Yes	Yes	Yes	Yes (From 2008)	Yes	Yes	Yes (EAL4+11)	?
Microsoft SQL Server Compact (Embedded Database)	No (not relevant, only file permissions)	No (not relevant)	No (not relevant)	No (not relevant)	Yes	Yes (file access)	Yes	Yes	No	?	?
Mimer SQL	Yes	?	?	?	Yes	Yes (depending on OS)	Yes	?	Yes	?	Yes
MySQL	Yes (SSL with 4.0)	No	Yes (with 5.5, but only in commercial edition)	No	Partial (no security page)[166]	Yes	?	?	?8	Yes	?
OpenBase SQL	Yes	?	Yes (Open Directory, LDAP)	No	?	?	?	?	?	?	?
OpenLink Virtuoso	Yes	Yes	Yes	Yes (optional)	Yes (optional)	Yes	Yes (optional)	Yes (optional)	Yes	No	Yes (optional)
Oracle	Yes	Yes	Yes	Yes	?	Yes	Yes	Yes	Yes	Yes (EAL4+1)	?
Pervasive PSQL	Yes	?	No	No	Yes	Yes	Yes 12	No	No	No	?
Polyhedra DBMS	Yes (with SSL. Optional)	No	No	No	No	Yes	Yes 13	Yes	Yes 13	No	?
PostgreSQL	Yes	Yes (for 9.1)	Yes (LDAP, Kerberos...9)	Yes (as of 9.0 with passwordcheck module)	Yes[167]	Yes	Limited, with triggers[168]	Yes	Yes	Yes (EAL11)	?
Raima Database Manager	No	No	No	No	No	Yes	No	No	No	No	?
RDM Server	Yes	No	No	No	No	Yes	Yes	No	Yes	No	?
SAP HANA	?	?	?	?	?	?	?	?	?	?	?
solidDB	No	No	Yes	No	No	Yes	Yes	No	No	No	No
SQL Anywhere	Yes	?	Yes (Kerberos)	Yes	?	Yes	Yes	No	Yes	Yes (EAL3+1 as Adaptive Server Anywhere)	?
SQLite	No (not relevant, only file permissions)	No (not relevant)	No (not relevant)	No (not relevant)	Partial (no security page)[169]	Yes (file access)	Yes	Yes	No	No	?
Teradata	Yes	No	Yes (LDAP, Kerberos...)	Yes	?	Yes	Yes	Yes	Yes	Yes	Yes
	Native network encryption1	Brute-force protection	Enterprise directory compatibility	Password complexity rules2	Patch access3	Run unprivileged4	Audit	Resource limit	Separation of duties (RBAC)5	Security Certification	Attribute-Based Access Control (ABAC)

Note (1): 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.

Note (2): Options are present to set a minimum size for password, respect complexity like presence of numbers or special characters.

Note (3): 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).

Note (4): Does database process run as root/administrator or unprivileged user? What is default configuration?

Note (5): 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?

Note (6): Common Criteria certified product list.^[170]

Note (7): FirebirdSQL seems to only have SYSDBA user and DB owner. There are no separate roles for backup operator and security administrator.

Note (8): User can define a dedicated backup user but nothing particular in default install.^[171]

Note (9): Authentication methods.^[172]

Note (10): Informix Dynamic Server supports PAM and other configurable authentication. By default uses OS authentication.

Note (11): Authentication methods.^[173]

Note (12): With the use of Pervasive AuditMaster.

Note (13): User-based security is optional in Polyhedra, but when enabled can be enhanced to a role-based model with auditing.^[174]

Databases vs schemas (terminology)

This section possibly contains original research. Please improve it by verifying the claims made and adding inline citations. Statements consisting only of original research should be removed. (June 2010) (Learn how and when to remove this template message)

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 dot ".". This seems to be a universal among all of the implementations.

A true fully (database, schema, and table) qualified query is exemplified as such: SELECT * FROM database.schema.table

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:

• SELECT * FROM database1.foo vs. SELECT * FROM database2.foo (no explicit schema between database and table)
• SELECT * FROM [database1.]default.foo vs. SELECT * FROM [database1.]alternate.foo (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 lacks off-the-shelf cross-database functionality 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 CREATE SCHEMA and CREATE DATABASE are analogs. It can therefore be said that MySQL has implemented cross-database functionality, skipped schema functionality entirely, and provided similar functionality into their implementation of a database. In summary, PostgreSQL fully supports schemas but lacks some functionality MySQL has with databases, while MySQL does not even attempt to support standard schemas.

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 CREATE SCHEMA syntax as a way to group DDL statements into a single unit creating all objects created as a part of the schema as a single owner. Informix supports a database mode called ANSI mode which supports creating objects with the same name but owned by different users.

PostgreSQL and some other databases have recently added support for foreign schemas, which is the ability to import schemas from other servers as defined in 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.^[175] While support for ISO/IEC 9075-9 bridges the gap between the two competing philosophies surrounding schemas, MySQL and Informix maintain an implicit association between databases while ISO/IEC 9075-9 requires that any such linkages be explicit in nature.

See also

• Relational database management system (includes market share data)
• List of relational database management systems
• Comparison of object–relational database management systems
• Comparison of database tools
• SQL compliance
• Object database – some of which have relational (SQL/ODBC) interfaces.
• IBM Business System 12 – an historical RDBMS and related query language.

References

1. http://www.4d.com/products/lifecycle.html
2. "Apache Derby: Downloads". Retrieved 2019-03-11.
3. Derby - ASF JIRA
4. cockroachdb Issue tracker
5. CUBRID / Jira Issue tracker for CUBRID
6. Stevens, O. (Oct–Dec 2009). "The History of Datacom/DB". Annals of the History of Computing. IEEE. 31 (4): 87–91. doi:10.1109/MAHC.2009.108. ISSN 1058-6180.
7. "CA Datacom - CA Technologies".
8. "Datacom Product Sheet" (PDF).
9. "Db2 11.5". Retrieved 23 December 2020.
10. "Release 3.0.7". 20 October 2020. Retrieved 10 November 2020.
11. IPL, Firebird SQL
12. IDPL, Firebird SQL
13. Firebird RDBMS Issue Tracker
14. HyperSQL Database Engine (HSQLDB) / Bugs
15. h2database issues
16. Linter Techsupport
17. https://mariadb.org/mariadb-10-5-10-10-4-19-10-3-29-and-10-2-38-now-available/; publication date: 8 May 2021.
18. "MariaDB licenses".
19. MariaDB - JIRA
20. MaxDB - Problem Tracking
21. "Editions and supported features of SQL Server 2019 (15.x)". 4 November 2019. Retrieved 23 December 2020.
22. MonetDB License MPL2.0, MonetDB B.V.
23. MonetDB Bugzilla
24. mSQL, Products, AU: Hughes
25. "Changes in MySQL 8.0.24 (2021-04-20, General Availability)". 20 April 2021.
26. MySQL Bugs
27. Issues · openlink/virtuoso-opensource · GitHub
28. "Oracle Database 19c : Now available on Oracle Exadata". 13 February 2019. Retrieved 23 December 2020.
29. "Oracle Rdb Product Family Compatibility Matrix". oracle.com.
30. Polyhedra® Lite In-Memory Relational Database System Freeware Available Now from Enea, Press Release, EECatalog.
31. "PostgreSQL 13.2, 12.6, 11.11, 10.16, 9.6.21, and 9.5.25 Released!". Retrieved 11 February 2021.
32. Postgres License
33. A bug tracker for PostgreSQL?
34. "SQLite Release 3.35.5 On 2021-04-19". Retrieved 20 April 2021.
35. SQLite: Ticket Main Menu
36. SQream DB Version 2.1 SQL Reference Guide, SQream Technologies
37. [1]
38. "Release 5.0.0". 7 April 2021. Retrieved 20 April 2021.
39. [2]
40. "v2.2.3.0 (Released September 30, 2020)". github.com.
41. [3]
42. https://www.firebirdsql.org/en/firebird-3-0/
43. http://docs.actian.com/ingres/11.0/index.html#page/Ing_Install%2FB._Installing_Ingres_on_OpenVMS.htm%23ww245951
44. "Building MariaDB on Mac OS X using Homebrew". AskMonty KnowledgeBase. Archived from the original on October 20, 2011. Retrieved September 30, 2011.
45. https://play.google.com/store/apps/details?id=com.esminis.server.mariadb&hl=de MariaDB Android Version by Tautvydas Andrikys
46. http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux
47. 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
48. http://aminet.net/package/dev/gg/postgresql632-mos-bin
49. "Archived copy". Archived from the original on 2015-05-27. Retrieved 2013-08-15.
50. Derby Developer's Guide (10.14)>Lock granularity
51. DB2 for Linux UNIX and Windows 9.7.0>Fundamentos de DB2>Performance tuning>Factors affecting performance>Application design>Concurrency issues>Isolation levels
52. http://www.h2database.com/html/advanced.html#mvcc
53. Transactional DDL in PostgreSQL: A Competitive Analysis
54. Transactional DDL in MariaDB
55. SQL Server Transaction Locking and Row Versioning Guide
56. MySQL :: MySQL 5.6 Reference Manual :: 8.10.1 Internal Locking Methods
57. Oracle Row Lock and Row Level Locking
58. "Polyhedra 8.7 new headline feature: locking".
59. PostgreSQL: Documentation: devel: Explicit Locking
60. BUG #5974: UNION construct type cast gives poor error message
61. https://help.sap.com/viewer/e38b2f6217f24bdb90a3ff8ae57b1dd5/17.0/en-US/3bee03b56c5f1014ab68e3eff32515dd.html | SAP SQL Anywhere Reference - Types of Lock
62. SAP SQL Anywhere Reference - Snapshot Isolation
63. https://help.sap.com/viewer/98ad9ec940e2465695685d98e308dff5/17.0/en-US/3bd460b56c5f10148922c11d39abc0b3.html | SAP SQL Anywhere Reference - HTTP Web Services
64. File Locking And Concurrency In SQLite Version 3
65. SQLite Full Unicode support is optional and not installed by default in most systems (like Android, Debian…)
66. "MySQL - The InnoDB Storage Engine".
67. "InnoDB - Oracle Wiki".
68. "MySQL 5.6 Reference Manual".
69. "Identifier Names". MariaDB KnowledgeBase. Retrieved 26 September 2014.
70. http://grokbase.com/t/postgresql/pgsql-general/12bsww982c/large-insert-leads-to-invalid-memory-alloc
71. https://www.postgresql.org/docs/9.3/static/lo-intro.html
72. https://help.sap.com/viewer/61ecb3d4d8be4baaa07cc4db0ddb5d0a/17.0/en-US/813836f16ce210149e89f219dc353b7e.html | SAP SQL Anywhere - Physical limitations on size and number of databases
73. Technical Specifications, Guide, Firebird SQL, archived from the original on 2010-06-15, retrieved 2008-03-30
74. Library, MSDN, Microsoft
75. "Column count limit", Reference Manual, MySQL 5.1 Documentation, Oracle
76. "Row-Overflow Considerations", TechNet Library, SQL Server Documentation, Microsoft, 2012
77. "Date functions", Language, SQLite
78. Online books, Sybase, archived from the original on 2005-10-23
79. Informix Performance Guide, Info Centre, IBM
80. Dynamic Materialized Views in MySQL, Pure, Red Noize, 2005, archived from the original on 2006-04-23
81. "Derby", Full Text Indexing, Search, Issues, Apache
82. "CUBRID 9.0 release".
83. Full-text search with DB2 Text Search, Developer Works, IBM
84. Does Firebird support full-text search?, Firebird FAQ
85. Fulltext Search, Tutorial, H2 Database
86. Create Spatial Index, Grammar, H2 Database
87. Forest of Trees Index, Informix Infocenter, IBM
88. Full Text Search Functions (PDF), Documentation, RU: Linter, archived from the original (PDF) on 2011-08-20, retrieved 2010-06-06
89. SPATIAL INDEX, MariaDB, mariadb.com, retrieved 24 September 2017
90. "Storage Engine Index Types". mariadb.com. Retrieved 25 April 2016.
91. Virtual Columns - MariaDB Knowledge Base
92. "Fulltext Index Overview". mariadb.com. Retrieved 25 April 2016.
93. Does Microsoft Access have Full Text Search?, Questions, Stack Overflow
94. "Microsoft SQL Server Full-Text Search", Library, MSDN, Microsoft
95. "Spatial Indexing Overview", Library, Tech Net, Microsoft
96. "Microsoft SQL Server Compact Full-text search is not available", Forums, MSDN, Microsoft
97. Index Types Per Storage Engine, MySQL, Oracle, retrieved 24 September 2017
98. "Feature request #4990: Functional Indexes", Bugs, MySQL, Oracle
99. "Feature request #13979: InnoDB engine doesn't support FULLTEXT", Bugs, MySQL, Oracle
100. "MySQL v5.6.4 Release Notes", Release Notes, MySQL, Oracle
101. Creating Spatial Indexes, MySQL, Oracle
102. Changes in MySQL 5.7.5, MySQL, Oracle
103. Does Oracle support full text search?, Questions, Stack Overflow
104. "Location Features for Database 11g", Spatial & Locator, Tech Network, Oracle
105. Oracle / PLSQL: ORA-01408 Error Message
106. Full Text Search, Documentation, PostgreSQL community
107. "4", Manual, PostGIS, PostGIS PSC
108. The SQLite R*Tree Module
109. SQLite Expression Indexes
110. SQLite FTS5 Extension
111. SpatiaLite, IT: Gaia GIS 2.3.1
112. Full-Text Search, Online Publications, Teradata
113. geospatial
114. UDF, Ad Hoc Data
115. "Create DB", Library, MSDN, Microsoft
116. "SQL", Library, MSDN, Microsoft
117. Petkovic, Dusan (2005). Microsoft SQL Server 2005: A Beginner's Guide. McGraw-Hill Professional. p. 300. ISBN 978-0-07-226093-9.
118. "InnoDB adaptive Hash", Reference manual 5.0, Development documentation, Oracle
119. "Article", Library, Developer Works, IBM
120. https://modern-sql.com/blog/2018-08/whats-new-in-mariadb-10.3#3.system-versioned-tables
121. New Features in HyperSQL 2.2
122. H2 > Advanced > Recursive Queries
123. H2 Functions
124. Informix parallel data query (PDQ)
125. "INTERSECT". mariadb.com.
126. "EXCEPT". mariadb.com.
127. "CTE implemented in 10.2.2". mariadb.org. Retrieved 26 July 2017.
128. "Window Functions Overview". mariadb.com. Retrieved 25 April 2016.
129. "Feature request #1542: Parallel query", Bugs, MySQL, Oracle
130. Only very limited functions available before SQL Server 2012, Microsoft
131. "SQL Server Parallel Query Processing", Library, MSDN, Microsoft
132. "Feature request #16244: SQL-99 Derived table WITH clause (CTE)", Bugs, MySQL, Oracle
133. Parallel Query, Wiki, Ora FAQ
134. Parallel Query, PostgreSQL
135. SQLite Query Language: WITH clause
136. Window Functions
137. "Data Types", General Reference, HDB, Altibase
138. "10. Data Types", Reference manual, MySQL 5.0, Oracle
139. "Data Types", CUBRID SQL Guide, Reference Manual, CUBRID
140. "FileMaker 14 Tech Specs". FileMaker=May 12, 2015.
141. "Migration from MS-SQL to Firebird". Firebird Project. Retrieved April 12, 2015.
142. "General: HSQLDB data types", Guide, 2.0 Documents, HSQLDB
143. "IBM Informix Guide to SQL: Reference, v11.50 (SC23-7750-04)". Publications. IBM. Retrieved August 7, 2013.
144. "3: Understanding SQL Data Types", SQL 9.3 Reference Guide, Documents, Ingres
145. "Data Types". mariadb.com. Retrieved 25 April 2016.
146. "SQL Server Data Types", Library, MSDN, Microsoft
147. "SQL Server Compact Data Types", Library, MSDN, Microsoft
148. "Datatypes", SQL Reference, OpenLink Software
149. "Data Types", SQL 11.2 Reference, Server documents, Oracle
150. "Data Types", Pervasive PSQL Supported Data Types, Product documentation, Pervasive
151. Polyhedra SQL Reference Manual, Product documentation, Enea AB, archived from the original on 2013-10-04, retrieved 2013-04-23
152. "Data Types", Manual, PostgreSQL 10 Documentation, PostgreSQL community
153. "Defining a Database", SQL 14.0 Reference, Raima
154. "Defining Table Columns", SQL 8.3 Reference, Raima
155. Datatypes, SQLite 3
156. SQream SQL Reference Guide, SQream Technologies
157. "CONSTRAINT". mariadb.com.
158. "Database Unions", 14.0 User's Guide, Raima
159. Support, Downloads, Sybase, retrieved 2008-09-07^{[dead link]}
160. "Release", Engine, Development, Firebird SQL 2.0
161. Files, Firebird SQL
162. "Trace and Audit Services". Firebird Project. Retrieved April 12, 2015.
163. "cracklib_password_check". mariadb.com. Retrieved 9 December 2014.
164. "simple_password_check". mariadb.com. Retrieved 9 December 2014.
165. "Security Vulnerabilities Fixed in MariaDB". mariadb.com. Retrieved 25 April 2016.
166. "Downloads", Development, MySQL, Oracle
167. Security, Support, PostgreSQL community, archived from the original on 2011-11-01, retrieved 2018-03-05
168. Audit trigger, Support, PostgreSQL community
169. Download, SQLite
170. DB, Products, Common Criteria Portal, archived from the original on 2009-08-17, retrieved 2009-01-04
171. Backup MySQL, How to, Gentoo wiki, archived from the original on 2008-09-02, retrieved 2008-09-07
172. Authentication methods, 8.1 Documents, PostgreSQL community
173. Common Criteria (CC, ISO15408), Microsoft, archived from the original on 2014-02-13
174. Adding audit trails to a Polyhedra IMDB database, White paper, Enea AB
175. "PostgreSQL: Documentation: 9.5: IMPORT FOREIGN SCHEMA". www.postgresql.org. Retrieved 2016-06-11.

External links

Wikibooks has a book on the topic of: SQL dialects reference

• Comparison of different SQL implementations against SQL standards. Includes Oracle, DB2, Microsoft SQL Server, MySQL and PostgreSQL. (8 June 2007)
• The SQL92 standard
• DMBS comparison by SQL Workbench