Comparison of relational database management systems

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

General information[edit]

Maintainer First public release date Latest stable version Latest release date License Public issues list
4D (4th Dimension) 4D S.A.S. 1984 v16.0 2017-01-10[1] Proprietary No
ADABAS Software AG 1970 8.1 2013-06 Proprietary No
Adaptive Server Enterprise SAP AG 1987 16.0 2015 Proprietary No
Advantage Database Server (ADS) SAP AG 1992 12.0 2015 Proprietary No
Altibase Altibase Corp. 2000 7.1.0.1.2 2018-03-02 GNU-AGPLv3; GNU-LGPLv3(for client-libraries) No
Apache Derby Apache 2004 10.14.2.0[2] 2018-05-03 Apache License Yes[3]
ClustrixDB Clustrix 2010 v7.0 2015-08-19 Proprietary No
CUBRID NHN Corporation 2008-11 10.1.0 2017-07-14 GPL v2 or later, BSD license for APIs and GUI tools Yes[4]
Datacom CA, Inc. Early 70s[5] 14[6] 2012[7] Proprietary No
DB2 IBM 1983 11.1 2016-04-12 Proprietary No
Empress Embedded Database Empress Software Inc 1979 10.20 2010-03 Proprietary No
EXASolution EXASOL AG 2004 6.0.0 2017-03-17 Proprietary No
FileMaker FileMaker, Inc., an Apple subsidiary 1985-04 16 2017-05-09 Proprietary No
Firebird Firebird project 2000-07-25 3.0.3 2018-02-02 IPL[8] and IDPL[9] Yes[10]
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[11]
H2 H2 Software 2005 1.4.197 2018-03-18 EPL and modified MPL Yes[12]
Informix Dynamic Server IBM 1981????1980 12.10.xC10 2017-12-05 Proprietary No
Ingres Ingres Corp. 1974 10.2 2014-09-30 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.18, 6.1.15 2016-03-15 Proprietary No
LucidDB The Eigenbase Project 2007-01 0.9.4 2012-01-05 GPL v2 No
MariaDB MariaDB Community 2010-02-01 10.3.9 2018-08-15[13] GPL v2, LGPL (for client-libraries)[14] Yes[15]
MaxDB SAP AG 2003-05 7.9.0.8 2014 Proprietary Yes[16]
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 2017 (14) 2017-10-02 Proprietary No
Microsoft SQL Server Compact (Embedded Database) Microsoft 2000 2011 (v4.0) Proprietary No
Mimer SQL Mimer Information Technology 1978 v10.1.4 2018-06-07 Proprietary No
MonetDB The MonetDB Team / CWI 2004 Mar2018-SP1 2018-06-20 Mozilla Public License, version 2.0[17] Yes[18]
mSQL Hughes Technologies 1994 4.1[19] 2017-06-30 Proprietary No
MySQL Oracle Corporation 1995-11 8.0.11[20] 2018-04-19 GPL v2 or Proprietary Yes[21]
MemSQL MemSQL 2012-06 5.8.6 (2017) 2017-06-30 Proprietary No
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 3.0.1 Proprietary No
Omnis Studio TigerLogic Inc 1982-07 6.1.3 Release 1no 2015-12 Proprietary No
OpenBase SQL OpenBase International 1991 11.0.0 Proprietary No
OpenEdge Progress Software Corporation 1984 11.6.3 2016-08-19 Proprietary No
OpenLink Virtuoso OpenLink Software 1998 7.2.5 2017-04-28 GPL v2 or Proprietary Yes[22]
Oracle DB Oracle Corporation 1979-11 12.2.0.1 2017-03-01[23] Proprietary No
Oracle Rdb Oracle Corporation 1984 7.3.1.2 2014-10-08[24] Proprietary No
Paradox Corel Corporation 1985 11 2009-09-07 Proprietary No
Percona Server for MySQL Percona 2006 5.7.21-21[25] 2018-04-24 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[26] No
PostgreSQL PostgreSQL Global Development Group 1989-06 10.5 2018-08-09[27] PostgreSQL Licence (a liberal Open Source license)[28] No[29]
R:Base R:BASE Technologies 1982 10.0 2016-05-26 Proprietary No
Raima Database Manager Raima Inc. 1984 14.1 2018-03-23 Proprietary No
RDM Server Raima Inc. 1993 8.4 2012-10-31 Proprietary No
SAP HANA SAP AG 2010 2.0 SPS02 2017-07-26 Proprietary No
solidDB UNICOM Global 1992 7.0.0.10 2014-04-29 Proprietary No
SQL Anywhere Sybase 1992 17.0 2015-07-15 Proprietary No
SQLBase Unify Corp. 1982 11.5 2008-11 Proprietary No
SQLite D. Richard Hipp 2000-09-12 3.24.0 2018-06-04[30] Public domain Yes[31]
SQream DB SQream Technologies 2014 2.1[32] 2018-01-15 Proprietary No
Superbase Superbase 1984 Scientific (2004) Proprietary No
Teradata Teradata 1984 15 2014-04 Proprietary No
Tibero TmaxSoft 1992 6 2015-04 Proprietary No
UniData Rocket Software 1988 8.2.1 2017-07 Proprietary No
Maintainer First public release date Latest stable version Latest release date License Public issues list

Operating system support[edit]

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 Yes Yes 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
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 No 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 ?
InterBase Yes Yes Yes No Yes (Solaris) No No Yes Yes No
Linter SQL RDBMS Yes Yes Yes Yes Yes No Under Linux on z Systems Yes Yes Yes
LucidDB Yes Yes Yes No No No No No No No
MariaDB Yes Yes[33] Yes Yes Yes No No ? Yes[34] 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[35] 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[36] No
Omnis Studio Yes Yes Yes No No No No No No No
OpenBase SQL Yes Yes Yes Yes Yes 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)[37] Under Linux on z Systems[38] 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 z Systems 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
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
Windows macOS Linux BSD UNIX AmigaOS z/OS iOS Android OpenVMS

Fundamental features[edit]

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 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) [39] ? Yes SQL Yes
ClustrixDB Yes Yes Yes Yes Yes Yes SQL Yes
CUBRID Yes Yes Yes Yes (Row-level locking) ? Yes GUI & SQL Yes
DB2 Yes Yes Yes Yes (Row-level locking)[40] ? 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 SQL Yes
HSQLDB Yes Yes Yes ? Yes Yes SQL Yes
H2 Yes Yes Yes ? Yes[41] 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 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 Yes6 Yes2 except for DDL[42][43] 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 No Yes Yes ? ? No GUI & SQL Yes
Microsoft SQL Server Yes Yes Yes Yes (Row-level locking)[44] 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 SQL Yes
MySQL Yes2 Yes3 Yes2 except for DDL[42] Yes (Row-level locking)[45] Yes Yes GUI 5 & SQL Yes
OpenBase SQL Yes Yes Yes ? ? Yes GUI & SQL Yes
OpenEdge Yes Yes7 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[42] Yes (Row-level locking)[46] Yes Yes API & GUI & SQL Yes
Oracle Rdb Yes Yes Yes ? ? Yes SQL Yes
Pervasive PSQL Yes Yes Yes ? ? Yes6 API & GUI & SQL Yes
Polyhedra DBMS Yes Yes Yes Yes (optimistic and pessimistic cell-level locking)[47] ? Yes API & SQL Yes
PostgreSQL Yes Yes Yes Yes (Row-level locking)[48] Yes Yes API & GUI & SQL No[49]
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 SQL Yes
SQLBase Yes Yes Yes ? ? Yes API & GUI & SQL Yes
SQLite Yes Yes Yes No (Database-level locking)[50] No Optional[51] API & SQL 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): MySQL provides ACID compliance through the default InnoDB storage engine.[52][53]

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."[54]

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

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

Note (6): MariaDB's default XtraDB engine is ACID compliant.

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

Limits[edit]

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 2 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), 4 GB (BLOB) 250 4 GB 4 KB 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[55]
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 252 Unlimited 15000 45 digits 0001-01-01 9999-12-31 128
MonetDB Unlimited Unlimited Unlimited Unlimited Unlimited Unlimited 64 bits 0 9999-12-31 ?
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)[56] – stored inline or 4 TB (stored in pg_largeobject)[57] 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 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 ?
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.[58] Firebird 1.5.x maximum database size: 32 TB.

Note (2): Limit is 1038 using DECIMAL datatype.[59]

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

Note (4): InnoDB is limited to 1,000 columns.[60]

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

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 (231) 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,[62] 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[edit]

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
MySQL Yes No4
OpenBase SQL Yes Yes
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
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.[63]

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.[64]

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

Note (5): Materialized views are now standard.

Indexes[edit]

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[66] ? ? No
ClustrixDB No Yes No No No No No No No No ? No
CUBRID No No Yes[67] Yes[67] Yes No No No No No No No
DB2 Yes Yes Yes No Yes Yes No No Yes[68] ? ? 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[69] ? ? No
HSQLDB No No No No No No No No No ? ? No
H2 No Yes No No No No No No Yes[70] Yes[71] ? No
Informix Dynamic Server Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes[72] No
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[73] Yes[74] No No
LucidDB No No No No No Yes No No No ? ? No
MariaDB Aria and MyISAM tables and, since v10.2.2, InnoDB tables only[75] MEMORY,[76] InnoDB,5 tables only PERSISTENT virtual columns only[77] No No No No No Yes[78] Aria and MyISAM tables and, since v10.2.2, InnoDB tables only[75] ? No
MaxDB No No No No No No No No No ? ? No
Microsoft Access (JET) No No No No No No No No No[79] ? ? 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[80] Yes[81] ? No
Microsoft SQL Server Compact (Embedded Database) No No No No No No No No No[82] ? ? No
Mimer SQL No No No No Yes No No No Yes Yes No No
MonetDB No Yes No No No Yes No No No No No No
MySQL Spatial Indexes[83] MEMORY, Cluster (NDB), InnoDB,5 tables only No[84] No No No No No MyISAM tables[85] and, since v5.6.4, InnoDB tables[86] MyISAM tables[87] and, since v5.7.5, InnoDB tables[88] ? 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[89] Yes[90] ? Yes[91]
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[92] PostGIS[93] ? 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 No No No No No No Yes Yes ? No
SQLite Yes[94] No Yes[95] Yes No No No No Yes[96] SpatiaLite[97] ? No
SQream DB ? ? ? ? Yes ? ? ? ? ? ? No
Teradata No Yes Yes Yes No Yes No No ?[98] ? ? No
UniVerse Yes Yes Yes3 Yes3 Yes3 No No No ? Yes[99] ? 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.[100]

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

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

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[104] 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[edit]

Union Intersect Except Inner joins Outer joins Inner selects Merge joins Blobs and Clobs Common Table Expressions Windowing Functions Parallel Query
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[67] ?
DB2 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes[105]
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[106] Yes Yes No Yes[106]
H2 Yes Yes Yes Yes Yes Yes No Yes experimental[107] No[108] ?
Informix Dynamic Server Yes Yes Yes, via MINUS Yes Yes Yes Yes Yes Yes Yes Yes[109]
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
LucidDB Yes Yes Yes Yes Yes Yes Yes No ? ? ?
MariaDB Yes 10.3+[110] 10.3+[111] Yes Yes Yes No Yes Yes[112] Yes[113] No[114]
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[115] Yes[116]
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
MySQL Yes No No Yes Yes Yes No Yes 8+[117] No No[114]
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[118]
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 8.4+[119] Yes Yes[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+[121] No No
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

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

Data types[edit]

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[122] 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[123] 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[124] 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[125] Static Not Supported Not Supported NUMBER TEXT CONTAINER TIMESTAMP Not Supported
Firebird[126] ? 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)
Type system Integer Floating point Decimal String Binary Date/Time Boolean Other
HSQLDB[127] 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[128] 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, JSON, BSON, USER DEFINED TYPES
Ingres[129] 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[130] 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[131] 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)[132] 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)
MonetDB Static TINYINT, SMALLINT, INT, BIGINT FLOAT, REAL, DOUBLE NUMERIC, DECIMAL VARCHAR(n),CHAR(n),CLOB BLOB DATE, TIME, DATETIME, TIMESTAMP BIT TIME WITH TIME ZONE TIMESTAMP WITH TIME ZONE, DAY, MONTH, YEAR, INTERVAL
MySQL[123] 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[133] 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[134] 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 TIMEZONE), INTERVAL N/A SPATIAL, IMAGE, AUDIO, VIDEO, DICOM, XMLType
Pervasive PSQL[135] 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[136] 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[137] 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 TIMEZONE), TIMESTAMP (with/without TIMEZONE), 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[138] 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[139] 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[140] 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[141] 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 TIMEZONE) 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[edit]

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[142] 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[edit]

Information about what partitioning methods are supported natively.

Range Hash Composite (Range+Hash) List Expression
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
Ingres Yes Yes Yes Yes ?
InterBase No No No No ?
Linter SQL RDBMS Yes No No Yes 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 No No No No No
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 Yes1 Yes1 Yes1 Yes1 Yes1
Raima Database Manager Yes2 Yes2 Yes2 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

Note (1): Since version 8.1 PostgreSQL provides partitioning support through check constraints.[143]

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

Access control[edit]

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)[145] 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[146] Yes (Windows trusted authenification) No Yes (no security page)[147] Yes Yes[148] 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[149][150] Yes[151] 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
MySQL Yes (SSL with 4.0) No Yes (with 5.5, but only in commercial edition) No Partial (no security page)[152] 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[153] Yes Limited, with triggers[154] 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)[155] 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.[156]

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.[157]

Note (9): Authentication methods.[158]

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

Note (11): Authentication methods.[159]

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.[160]

Databases vs schemas (terminology)[edit]

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.[161] 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[edit]

References[edit]

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

External links[edit]