Comparison of relational database management systems
[ temporary import ]
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
{{short description|none}}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{| class"wikitable sortable"
|
! ! 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 | DATE = 10 JANUARY 2020, | {{Proprietary}}| {{No}} |
|
! ADABAS| Software AG| 1970| 8.1|2013-06| {{Proprietary}}| {{No}}
|
! Adaptive Server Enterprise| SAP AG| 1987| 16.0 SP03 PL07|2019-06-10| {{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| {{Proprietary}}| {{No}}
|
! Apache DerbyApache Software Foundation>Apache| 2004| 10.17.1.0WEB
, Apache Derby: Downloads , weblink, 2024-03-18 , | 2023-11-14
| Apache License}}| {{Yes}}Derby - ASF JIRA |
|
! ClustrixDBMariaDB>MariaDB Corporation| 2010| v7.0| 2015-08-19| {{Proprietary}}| {{No}} |
|
! CockroachDB| Cockroach Labs| 2015| v20.2.8| 2021-04-23BSL,CCL,MIT,BSD}}| {{Yes}}cockroachdb Issue tracker |
|
! CUBRID| CUBRID| 2008-11| 11.2.3| 2023-01-31Apache License 2.0, BSD license for APIs and GUI tools}}| {{Yes}}CUBRID / Jira Issue tracker for CUBRID |
|
! Datacom| CA, Inc.| Early 70sJOURNAL
, Stevens
, O.
, The History of Datacom/DB
, Annals of the History of Computing
, 31
, 4
, 87â91
, IEEE
, OctâDec 2009
, 10.1109/MAHC.2009.108
, 16803811
, 1058-6180
, | 14WEB
, CA Datacom - CA Technologies
,
weblink, 2014-07-06
, 2016-02-14
,
weblink" title="web.archive.org/web/20160214142439
weblink">weblink
, dead
, | 2012WEB
, Datacom Product Sheet
,
weblink, | {{Proprietary}}| {{No}}
|
! IBM Db2| IBM| 1983property | edit | P348}} | qualifier | Q431195 | P577}}; {{Time ago | qualifier | Q431195 | P577}}}}| {{Proprietary}}| {{No}} |
|
! Empress Embedded Database| Empress Software Inc| 1979| 10.20| 2010-03| {{Proprietary}}| {{No}}
|
! ExasolEXASOL>EXASOL AG| 2004| 7.1.1 | 2021-09-15}}| {{Proprietary}}| {{No}} |
|
! FileMaker| FileMaker, Inc., an Apple subsidiary| 1985-04| 19| 2020-05-20| {{Proprietary}}| {{No}}
|
! Firebird| Firebird project| 2000-07-25property | edit | P348}} | qualifier | Q261744 | P577}}; {{Time ago | qualifier | Q261744 | P577}}}} | IPL{{Citation
|
|
! GPUdb| GIS Federal| 2014| 3.2.5| 2015-01-14| {{Proprietary}}| {{No}}
|
! HSQLDB| HSQL Development Group| 2001| 2.6.1| 2021-10-21BSD}}| {{Yes}}HyperSQL Database Engine (HSQLDB) / Bugs |
|
! H2| H2 Software| 2005| 2.1.214| 2022-06-13Eclipse Public License | and modified Mozilla Public License>MPL}}| {{Yes}}h2database issues |
|
! Informix Dynamic ServerIBM / HCLTech>HCL Technologies| 1981????1980| 14.10.xC9| 2022-10-03| {{Proprietary}}| {{No}} |
|
! Ingres| Actian| 1974| 11.2WEB
, Actian X & Ingres - Lifecycle Dates
,
weblink, | 2022-05-06
[hide]GNU General Public License
| Proprietary software>Proprietary{edih}| {{No}} |
|
! InterBaseInterBase>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}}Linter Techsupport
|
! LucidDB| The Eigenbase Project| 2007-01| 0.9.4| 2012-01-05GPL v2}}| {{No}} |
|
! MariaDBMariaDB>MariaDB Community| 2010-02-01 | property | edit | P348|P548=Q2804309}} | qualifier | Q787177 | P577 | {{wikidata | raw | P348 | P548=Q2804309}}}} | GNU General Public License | v2, GNU Lesser General Public License>LGPL (for client-libraries)WEB
|
|
! MaxDB| SAP AG| 2003-05| 7.9.0.8| 2014| {{Proprietary}}| {{Yes}}MaxDB - Problem Tracking
|
!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| 1989property | edit | P348}} | qualifier | Q215819 | P577}}; {{Time ago | qualifier | Q215819 | P577}}}}| {{Proprietary}}| {{No}} |
|
! Microsoft SQL Server Compact (Embedded Database)| Microsoft| 2000| 2011 (v4.0)|| {{Proprietary}}| {{No}}
|
! Mimer SQL| Mimer Information Technology| 1978| 11.0.8B| 2023-12-27| {{Proprietary}}| {{No}}
|
! MonetDB | | Mozilla Public License, version 2.0{{Citation
| url = weblink | publisher = MonetDB B.V. | title = MonetDB License MPL2.0 | date = 8 February 2022 }}}}| {{Yes}} MonetDB Issues
|
|
! mSQL| Hughes Technologies| 1994| 4.1{{Citation
|url =
weblink |publisher = Hughes
|location = AU
|series = Products
|title = mSQL
|access-date = 2009-09-13
|archive-date = 2009-10-15
|archive-url =
weblink" title="web.archive.org/web/20091015100648
weblink">weblink
|url-status = dead
}}| 2017-06-30| {{Proprietary}}| {{No}}
|
! MySQL| Oracle Corporation| 1995-11property | edit | P348}} | qualifier | Q850 | P348 | {{wikidata | raw | P548=Q2804309 | P577}}}} | GNU General Public License | v2 or Proprietary software>Proprietary}}| {{Yes}}MySQL Bugs |
|
! NexusDB| NexusDB Pty Ltd| 2003| 4.00.14| 2015-06-25| {{Proprietary}}| {{No}}
|
! HPE NonStop SQL| Hewlett Packard Enterprise| 1987| SQL/MX 3.4|| {{Proprietary}}| {{No}}
|
! NuoDB| NuoDB| 2013| 4.1| 2020-08| {{Proprietary}}| {{No}}
|
! Omnis Studio| TigerLogic Inc| 1982-07| 6.1.3 Release 1no| 2015-12| {{Proprietary}}| {{No}}
|
! OpenEdge| Progress Software Corporation| 1984| 12.8| 2024-1| {{Proprietary}}| {{No}}
|
! OpenLink Virtuoso| OpenLink Software| 1998| 7.2.5.1| 2018-08-15GNU General Public License | v2 or Proprietary software>Proprietary}}| {{Yes}}Issues · openlink/virtuoso-opensource · GitHub |
|
! Oracle DB| Oracle Corporation| 1979-11property | edit | P348}} | qualifier | Q185524 | P577}}; {{Time ago | qualifier | Q185524 | P577}}}}| {{Proprietary}}| {{No}} |
|
! Oracle Rdb| Oracle Corporation| 1984| {{Oracle Rdb version}}releasedate}}| {{Proprietary}}| {{No}} |
|
! Paradox| Corel Corporation| 1985| 11| 2009-09-07| {{Proprietary}}| {{No}}
|
! Percona Server for MySQL| Percona| 2006| {{Percona Server for MySQL version}}releasedate}} | GPL v2}}| {{Yes}} |
|
! Actian Zen (PSQL)| Actian| 1982| v15| 2021| {{Proprietary}}| {{No}}
|
! Polyhedra DBMS| ENEA AB| 1993| 9.0| 2015-06-24| {{Proprietary}}, with Polyhedra Lite available as Freeware{{Citation
| url =
weblink | series = Press Release
| publisher = EECatalog
| title = Polyhedra Lite In-Memory Relational Database System Freeware Available Now from Enea
}}.| {{No}}
|
! PostgreSQL| PostgreSQL Global Development Group| 1989-06| 16.1| 2023-11-09WEB
,
weblink, PostgreSQL 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 Released!
, The PostgreSQL Global Development Group
, 2023-11-09
, PostgreSQL
, 2023-11-29,
Postgres License}}Postgres License| {{No}}A bug tracker for PostgreSQL?
|
|
! R:Base]]| R:BASE Technologies| 1982| 10.0| 2016-05-26| {{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-12property | edit | P348}} | qualifier | Q319417 | P577}}; {{Time ago | qualifier | Q319417 | P577}}}} | Public domain}}| {{Yes}}SQLite: Ticket Main Menu |
|
! SQream DB| SQream Technologies| 2014| 2.1{{Citation
| url =
weblink | publisher = SQream Technologies
| title = SQream DB Version 2.1 SQL Reference Guide
}}| 2018-01-15| {{Proprietary}}| {{No}}
|
! SuperbaseSuperbase database>Superbase| 1984| Classic| 2003| {{Proprietary}}| {{No}} |
|
! Superbase NGSuperbase database>Superbase NG| 2002| Superbase NG 2.10| 2017| {{Proprietary}} | |
|
! Teradata| Teradata| 1984| 15| 2014-04| {{Proprietary}}| {{No}}
|
! TiDB| PingCAP Inc.| 2016property | edit | P348}} | qualifier | Q56375088 | P577}}; {{Time ago | qualifier | Q56375088 | P577}}}} | Apache License}} | | WEBSITE = GITHUB, |
|
! UniData| Rocket Software| 1988| 8.2.1| 2017-07| {{Proprietary}}| {{No}}
|
! YugabyteDB| Yugabyte, Inc.| 2018| {{YugabyteDB version}}releasedate}} | Apache License}} | | WEBSITE=GITHUB, |
|
! ! 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.{| class="wikitable sortable"|
! ! Windows! macOS! Linux! BSD! UNIX! AmigaOS! z/OS! OpenVMS! iOS! Android
|
! 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}}| {{dunno}}| {{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}}
|
! IBM Db2| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{yes}}| {{no}}| {{yes}}| {{no}}| {{yes}}| {{no}}
|
! Empress Embedded Database| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{yes}}
|
! EXASolution| {{no}}| {{no}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}
|
! FileMaker| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{Yes}}| {{No}}
|
! Firebird| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}Maybe}}| {{no}} | |
|
! HSQLDB| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{yes}}| {{no}}| {{dunno}}| {{dunno}}
|
! H2| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{yes}}| {{no}}| {{dunno}}| {{yes}}
|
! Informix Dynamic Server| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}
|
! Ingres| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{partial}} |
|
! InterBase| {{yes}}| {{yes}}| {{yes}}| {{no}}Solaris (operating system)>Solaris)| {{no}}| {{no}}| {{no}}| {{yes}}| {{yes}} |
|
! 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}}WEB
,
weblink, AskMonty KnowledgeBase
, Building MariaDB on Mac OS X using Homebrew
, September 30, 2011
,
weblink" title="web.archive.org/web/20111020134104
weblink">weblink
, October 20, 2011
, dead
, | {{yes}}| {{yes}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{dunno}}| {{yes}
weblink MariaDB Android Version by Tautvydas Andrikys
|
! 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}} | DATE = 7 MARCH 2016, | {{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}} |
|
|
|
! MonetDB| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}
|
! MySQL| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{no}}| {{dunno}}| {{yes}weblink Run Apache, Mysql, Php â Web server on Android mobile or Tablet
|
! 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}}| {{yes}}| {{no}}| {{no}}
|
! Oracle Rdb| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{yes}}| {{no}}| {{no}}
|
! Actian Zen (PSQL)| {{yes}}| {{yes}} (OEM only)| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{yes}}| {{yes}}
|
! Polyhedra| {{yes}}| {{no}}| {{yes}}| {{no}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}
|
! PostgreSQL| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}MorphOS)HTTP://AMINET.NET/PACKAGE/DEV/GG/POSTGRESQL632-MOS-BIN, Aminet - dev/Gg/Postgresql632-mos-bin.lha, | Linux on IBM ZHTTP://WWW.OSS4ZOS.ORG/MEDIAWIKI/INDEX.PHP?TITLE=POSTGRESQL#Z.2FOS | ACCESS-DATE=2013-08-15 | ARCHIVE-DATE=2015-05-27, dead, | {{no}}| {{no}}| {{yes}} |
|
! R:Base]]| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{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}}| {{no}}| {{yes}}
|
! SQLBase| {{yes}}| {{no}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}| {{no}}
|
! SQLite| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}| {{yes}}Maybe}}| {{no}}| {{Yes}}| {{Yes}} |
|
! 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}}
|
! TiDB| {{yes}}| {{yes}}| {{yes}}| {{partial}}| {{no}}| {{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}}
Fundamental features
Information about what fundamental RDBMS features are implemented natively.{| class="wikitable sortable"|
! Database Name! ACID! Referential integrity! Transactions! Fine-grained locking! Multiversion concurrency control! Unicode! Interface! Type inference
|
! 4th Dimension| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}graphical user interface>GUI & SQL| {{Yes}} |
|
! ADABAS| {{yes}}| {{no}}| {{yes}}| {{dunno}}| {{dunno}}| {{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)| {{dunno}}#feat 4>4| API & SQL| {{Yes}} |
|
! Altibase| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)| {{dunno}}| {{yes}}| API & GUI & SQL| {{Yes}}
|
! Apache Derby| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking) Derby Developer's Guide (10.14)>Lock granularity| {{dunno}}| {{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}}| {{yes}}graphical user interface>GUI & SQL| {{Yes}} |
|
! IBM Db2| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)DB2 for Linux UNIX and Windows 9.7.0>Fundamentos de DB2>Performance tuning>Factors affecting performance>Application design>Concurrency issues>Isolation levels| {{dunno}}| {{yes}}graphical user interface>GUI & SQL| {{Yes}} |
|
! Empress Embedded Database| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}graphical user interface>API & SQL| {{Yes}} |
|
! EXASolution| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}graphical user interface>API & GUI & SQL| {{Yes}} |
|
! Firebird| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{yes}}| {{yes}}| API & SQL| {{Yes}}
|
! HSQLDB| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{yes}}| {{yes}}| SQL| {{Yes}}
|
! H2| {{yes}}| {{yes}}| {{yes}}| {{dunno}}SQL| {{Yes}} |
|
! Informix Dynamic Server| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)| {{yes}}| {{yes}}| SQL, REST, MQ, and JSON| {{Yes}}
|
! Ingres| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)| {{yes}}| {{yes}}SQL & QUEL query languages>QUEL| {{Yes}} |
|
! InterBase| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}| SQL| {{Yes}}
|
! Linter SQL RDBMS| {{yes}}| {{yes}}Data Definition Language>DDL)| {{yes}} (Row-level locking)| {{dunno}}| {{yes}}| API & GUI & SQL| {{Yes}} |
|
! LucidDB| {{yes}}| {{no}}| {{no}}| {{dunno}}| {{dunno}}| {{yes}}| SQL| {{Yes}}
|
! MariaDB#feat 2>2| {{yes}} | #feat 2>2 except for DDLTransactional DDL in PostgreSQL: A Competitive AnalysisTransactional DDL in MariaDB| {{yes}} (Row-level locking)| {{yes}}| {{yes}}| SQL| {{Yes}} |
|
! MaxDB| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}| SQL| {{Yes}}
|
! Microsoft Access (JET)| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}graphical user interface>GUI & SQL| {{Yes}} |
|
! Microsoft Visual FoxPro| {{Yes}}| {{Yes}}| {{Yes}}| {{Yes}} (Row-level locking SMB2)| {{Yes}}| {{No}}graphical user interface>GUI & SQL| {{Yes}} |
|
! Microsoft SQL Server| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)SQL Server Transaction Locking and Row Versioning Guide| {{yes}}| {{yes}}graphical user interface>GUI & SQL| {{Yes}} |
|
! Microsoft SQL Server Compact (Embedded Database)| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}graphical user interface>GUI & SQL| {{Yes}} |
|
! Mimer SQL| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Optimistic locking)| {{yes}}| {{yes}}| API & GUI & SQL| {{Yes}}
|
! MonetDB| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}| API & SQL & MAL| {{Yes}}
|
! MySQL#feat 2>2 | #feat 3>3 | #feat 2>2 except for DDL| {{yes}} (Row-level locking)MySQL :: MySQL 5.6 Reference Manual :: 8.10.1 Internal Locking Methods| {{yes}}| {{yes}} | graphical user interface>GUI 5 & SQL| {{Yes}} |
|
! OpenEdge| {{yes}}#feat 6>6| {{yes}}| {{yes}} (Row-level locking)| {{dunno}}| {{yes}} | graphical user interface>GUI & SQL| {{Yes}} |
|
! OpenLink Virtuoso| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}API & graphical user interface>GUI & SQL| {{Yes}} |
|
! Oracle| {{yes}}| {{yes}}Data Definition Language>DDL| {{yes}} (Row-level locking)Oracle Row Lock and Row Level Locking| {{yes}}| {{yes}} | API & graphical user interface>GUI & SQL| {{Yes}} |
|
! Oracle Rdb| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}| SQL| {{Yes}}
|
! Actian Zen (PSQL)| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}API & graphical user interface>GUI & SQL| {{Yes}} |
|
! Polyhedra DBMS| {{yes}}| {{yes}}| {{yes}}API & SQL| {{Yes}} |
|
! PostgreSQL| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)PostgreSQL: Documentation: Explicit Locking : Row-Level Locks| {{yes}} | {{yes}}API & graphical user interface>GUI & SQL| {{No}}BUG #5974: UNION construct type cast gives poor error message |
|
! SAP HANA| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)| {{yes}}| {{yes}}API & graphical user interface>GUI & SQL| {{Yes}} |
|
! solidDB| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Row-level locking)| {{dunno}}| {{yes}}| API & SQL| {{Yes}}
|
! SQL Anywhere| {{yes}}| {{yes}}| {{yes}}weblink > SAP SQL Anywhere Reference - Types of Lock| {{yes}} SAP SQL Anywhere Reference - Snapshot Isolation| {{yes}} | API & graphical user interface>GUI & HTTP | (REST & SOAPweblink > SAP SQL Anywhere Reference - HTTP Web Services & SQL| {{Yes}} |
|
! SQLBase| {{yes}}| {{yes}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}API & graphical user interface>GUI & SQL| {{Yes}} |
|
! SQLite| {{yes}}| {{yes}}| {{yes}}| {{no}} (Database-level locking)File Locking And Concurrency In SQLite Version 3| {{no}}SQLite Full Unicode support is optional and not installed by default in most systems (like Android (operating system)>Android, Debian...)| API & SQL| {{Yes}} |
|
! Superbase NG| {{dunno}}| {{dunno}}| {{dunno}}| {{yes}} (Record-level locking)| {{dunno}}| {{yes}}GUI & Proprietary software>Proprietary & ODBC| {{Yes}} |
|
! Teradata| {{yes}}| {{yes}}| {{yes}}| {{yes}} (Hash and Partition)| {{dunno}}| {{yes}}| SQL| {{Yes}}
|
! TiDB| {{yes}}| {{yes}}Data Definition Language>DDL| {{yes}} (Row-level locking)TiDB Features| {{yes}}| {{yes}} | graphical user interface>GUI 5 & SQL| {{Yes}} |
|
! UniData| {{yes}}| {{no}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}| Multiple| {{Yes}}
|
! UniVerse| {{yes}}| {{no}}| {{yes}}| {{dunno}}| {{dunno}}| {{yes}}| Multiple| {{Yes}}
- (Comparison of relational database management systemsfeat 1|Note (1):) Currently only supports read uncommitted transaction isolation. Version 1.9 adds serializable isolation and version 2.0 will be fully ACID compliant.
- (feat 2 back|Note (2):) MariaDB and MySQL provide ACID compliance through the default InnoDB storage engine.WEB
,
weblink, MySQL - The InnoDB Storage Engine
, WEB
,
weblink, InnoDB - Oracle Wiki
,
- (feat 3 back|Note (3):) "For other than InnoDB storage engines, MySQL Server parses and ignores the {{mono|FOREIGN KEY}} and {{mono|REFERENCES}} syntax in {{mono|CREATE TABLE}} statements. The {{mono|CHECK}} clause is parsed but ignored by all storage engines."WEB
,
weblink, MySQL 5.6 Reference Manual
,
- (Comparison of relational database management systemsfeat 4|Note (4):) Support for Unicode is new in version 10.0.
- (Comparison of relational database management systemsfeat 5|Note (5):) MySQL provides GUI interface through MySQL Workbench.
- (feat 6 back|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.{| style="text-align: center; width: 95%; font-size:80%" class="wikitable sortable"|
! style="width:12em" |! 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
|
! style="text-align:left" | 4th Dimension| Limited| {{dunno}}| {{dunno}}| 65,135gibibyte>GiB Unicode) | gibibyte>GiB Unicode)| 64 bits| {{dunno}}| {{dunno}}| {{dunno}} |
|
! style="text-align:left" | Advantage Database Server| Unlimitedexbibyte>EiB | 65530 | fmt=commas}}| 65,135 / (10+ AvgFieldNameLength) | gibibyte>GiB| {{dunno}}| 64 bits| {{dunno}}| {{dunno}}| 128 |
|
! style="text-align:left" | Apache Derby| Unlimited| Unlimited| Unlimited| 1,012 (5,000 in views)| 2,147,483,647 charsVARCHAR}}: 32,672)| 64 bits| 0001-01-01| 9999-12-31| 128 |
|
! style="text-align:left" | ClustrixDB| Unlimited| Unlimited| 64 MB on Appliance, 4 MB on AWS| {{dunno}}| 64 MB| 64 MB| 64 MB| 0001-01-01| 9999-12-31| 254
|
! style="text-align:left" | CUBRID| 2 EB| 2 EB| Unlimited| Unlimited| Unlimited| 1 GB| 64 bits| 0001-01-01| 9999-12-31| 254
|
! style="text-align:left" | IBM DB2| Unlimited2|u=ZB}} | 1048319 | fmt=commas}}| 1,012 | 2|u=GB}} | 32|u=KiB}}| 64 bits| 0001-01-01| 9999-12-31| 128 |
|
! style="text-align:left" | Empress Embedded Database| Unlimited| 263−1 bytes| 2 GB| 32,767| 2 GB| 2 GB| 64 bits| 0000-01-01| 9999-12-31| 32
|
! style="text-align:left" | EXASolution| Unlimited| Unlimited| Unlimited| 10,000| {{N/A}}| 2 MB| 128 bits| 0001-01-01| 9999-12-31| 256
|
! style="text-align:left" | FileMaker| 8 TB| 8 TB| 8 TB| 256,000,000| 4 GB| 10,000,000-400}} to {{10^|400}}, +-| 0001-01-01| 4000-12-31| 100 |
|
! style="text-align:left" | Firebird#limit 1>1| ~32 TB| 65,536 B| Depends on data types used| 32 GB| 32,767 B| 64 bits| 100| 32768| 31 |
|
! style="text-align:left" | HSQLDB| 64 TB#limit 8>8 | #limit 8>8 | #limit 8>8 | #limit 7>7 | #limit 8>8 | #limit 8>8| 0001-01-01| 9999-12-31| 128 |
|
! style="text-align:left" | H2| 64 TB#limit 8>8 | #limit 8>8 | #limit 8>8 | #limit 7>7 | #limit 8>8| 64 bits| -99999999| 99999999 | #limit 8>8 |
|
! style="width:16em" |! 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
|
! style="text-align:left" | Informix Dynamic Server#limit 12>12 | #limit 12>12| 32,765 bytes (exclusive of large objects)| 32,765| 4 TB| 32,765 | #limit 13>13 | #limit 10>10| 12/31/9999| 128 bytes |
|
! style="text-align:left" | Ingres| Unlimited| Unlimited| 256 KB| 1,024| 2 GB| 32 000 B| 64 bits| 0001| 9999| 256
|
! style="text-align:left" | InterBase#limit 1>1| ~32 TB| 65,536 B| Depends on data types used| 2 GB| 32,767 B| 64 bits| 100| 32768| 31 |
|
! style="text-align:left" | 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
|
! style="text-align:left" | MariaDB| Unlimited| MyISAM storage limits: 256 TB;Innodb storage limits: 64 TB;Aria storage limits: ???#limit 3>3 | #limit 4>4| 4 GB (longtext, longblob)| 64 KB (text)| 64 bits| 1000| 9999| 64WEB
, weblink, Identifier Names , MariaDB KnowledgeBase , 26 September 2014 ,
|
|
! style="text-align:left" | 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
|
! style="text-align:left" | Microsoft Visual Foxpro| Unlimited| 2 GB| 65,500 B| 255| 2 GB| 16 MB| 32 bits| 0001| 9999| 10
|
! style="text-align:left" | Microsoft SQL Server| 524,272 TB (32 767 files à 16 TB max file size)16ZB per instance| 524,272 TB#limit 6>6| 1,024 / 30,000(with sparse columns)| 2 GB / Unlimited (using RBS/FILESTREAM object) | #limit 6>6 | #limit 2>2| 0001| 9999| 128 |
|
! style="text-align:left" | Microsoft SQL Server Compact (Embedded Database)| 4 GB| 4 GB| 8,060 bytes| 1024| 2 GB| 4000| 154 bits| 0001| 9999| 128
|
! style="text-align:left" | Mimer SQL| Unlimited| Unlimited| 16000 (+lob data)| 252| Unlimited| 15000| 45 digits| 0001-01-01| 9999-12-31| 128
|
! style="text-align:left" | MonetDB| Unlimited| Unlimited| Unlimited| Unlimited| 2 GB| 2 GB| 128 bits| -4712-01-01| 9999-12-31| 1024
|
! style="text-align:left" | MySQL| Unlimited| MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB#limit 3>3 | #limit 4>4| 4 GB (longtext, longblob)| 64 KB (text)| 64 bits| 1000| 9999| 64 |
|
! style="text-align:left" | 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
|
! style="text-align:left" | Oracle2 | 8 | 8|u=EB}} (with max 32k block and BIGFILE option)| 4 GB Ã block size(with BIGFILE tablespace)| 8 KB| 1,000| 128 TB | #limit 11>11| 126 bits| â4712| 9999| 128 |
|
! style="width:16em" |! 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
|
! style="text-align:left" | Actian Zen (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
|
! style="text-align:left" | 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
|
! style="text-align:left" | PostgreSQLWEB
, PostgreSQL Limits
,
weblink, 2021-05-13
, | Unlimited| 32 TB| 1.6 TB| 250â1600 depending on type| 1 GB (text, bytea) stored inline or 4 TB using pg_largeobject
WEB
, Large Objects: Introduction
,
weblink, 2021-05-13
, | 1 GB| Unlimited| â4,713
WEB
, Date/Time Types
,
weblink, 2021-05-13
, | 5,874,897| 63
|
! style="text-align:left" | SAP HANA| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}
|
! style="text-align:left" | 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
|
! style="text-align:left" | SQL Anywhere]weblink | SAP SQL Anywhere - Physical limitations on size and number of databases| 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
|
! style="text-align:left" | 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#limit 9>9 | #limit 9>9| Unlimited |
|
! style="text-align:left" | 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
|
! style="text-align:left" | 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
- (limit 1 back|Note (1):) Firebird 2.x maximum database size is effectively unlimited with the largest known database size >980 GB.
{{Citation
| url =
weblink | publisher = Firebird SQL
| series = Guide
| title = Technical Specifications
| access-date = 2008-03-30
| archive-url =
weblink" title="web.archive.org/web/20100615021231
weblink">weblink
| archive-date = 2010-06-15
| url-status = dead
}}
Firebird 1.5.x maximum database size: 32 TB.
- (limit 2 back|Note (2):) Limit is 1038 using DECIMAL datatype.{{Citation
| url =
weblink | publisher = Microsoft
| series = MSDN
| title = Library
}}
- (limit 3 back|Note (3):) InnoDB is limited to 8,000 bytes (excluding VARBINARY, VARCHAR, BLOB, or TEXT columns).{{Citation
| chapter-url =
weblink | publisher = Oracle
| series = MySQL 5.1 Documentation
| title = Reference Manual
| chapter = Column count limit
}}
- (limit 4 back|Note (4):) InnoDB is limited to 1,017 columns.
- (limit 6 back|Note (6):) Using VARCHAR (MAX) in SQL 2005 and later.{{Citation
| chapter-url =
weblink | publisher = Microsoft
| series = SQL Server Documentation
| title = TechNet Library
| year = 2012
| chapter = Row-Overflow Considerations
}}
- (limit 7 back|Note (7):) When using a page size of 32 KB, and when BLOB/CLOB data is stored in the database file.
- (limit 8 back|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.
- (limit 9 back|Note (9):) Despite the lack of a date datatype, SQLite does include date and time functions,{{Citation
| chapter-url =
weblink | publisher = SQLite
| title = Language
| chapter = Date functions
}} which work for timestamps between 24 November 4714 B.C. and 1 November 5352.
- (limit 10 back|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.
- (limit 11 back|Note (11):) Since version 12c. Earlier versions support up to {{val|4000|u=B}}.
- (limit 12 back|Note (12):) The {{val|128|u=PB}} 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.
- (limit 13 back|Note (13):) Informix DECIMAL type supports up to 32 decimal digits of precision with a range of {{10^|-130}} to {{10^|125}}. Fixed and variable precision are supported.
Tables and views
Information about what tables and views (other than basic ones) are supported natively.{| style="text-align: center; width: 95%" class="wikitable sortable"|
! style="width:16em" |! Temporary table! Materialized view
|
! style="text-align:left" | 4th Dimension| {{Yes}}| {{no}}
|
! style="text-align:left" | ADABAS| {{dunno}}| {{dunno}}
|
! style="text-align:left" | Adaptive Server Enterprise#tb 1>1| {{yes}} â see precomputed result sets |
|
! style="text-align:left" | Advantage Database Server| {{yes}}| {{no}} (only common views)
|
! style="text-align:left" | Altibase| {{yes}}| {{no}} (only common views)
|
! style="text-align:left" | Apache Derby| {{yes}}| {{no}}
|
! style="text-align:left" | ClustrixDB| {{yes}}| {{no}}
|
! style="text-align:left" | CUBRID| {{yes}} (only CTE)| {{no}} (only common views)
|
! style="text-align:left" | IBM Db2| {{yes}}| {{yes}}
|
! style="text-align:left" | Empress Embedded Database| {{yes}}| {{yes}}
|
! style="text-align:left" | EXASolution| {{yes}}| {{no}}
|
! style="text-align:left" | Firebird| {{yes}}| {{no}} (only common views)
|
! style="text-align:left" | HSQLDB| {{yes}}| {{no}}
|
! style="text-align:left" | H2| {{yes}}| {{no}} (only common views)
|
! style="text-align:left" | Informix Dynamic Server| {{yes}}#tb 2>2 |
|
! style="text-align:left" | Ingres| {{yes}}| {{no}}
|
! style="text-align:left" | InterBase| {{yes}}| {{no}}
|
! style="text-align:left" | Linter SQL RDBMS| {{yes}}| {{yes}}
|
! style="text-align:left" | LucidDB| {{no}}| {{no}}
|
! style="text-align:left" | MariaDB| {{yes}}#tb 4>4 |
|
! style="text-align:left" | MaxDB| {{yes}}| {{no}}
|
! style="text-align:left" | Microsoft Access (JET)| {{no}}| {{no}}
|
! style="text-align:left" | Microsoft Visual Foxpro| {{yes}}| {{yes}}
|
! style="text-align:left" | Microsoft SQL Server| {{yes}}| {{yes}}
|
! style="text-align:left" | Microsoft SQL Server Compact (Embedded Database)| {{yes}}| {{no}}
|
! style="text-align:left" | Mimer SQL| {{no}}| {{no}}
|
! style="text-align:left" | MonetDB| {{yes}}| {{no}} (only common views)
|
! style="text-align:left" | MySQL| {{yes}}#tb 4>4 |
|
! style="text-align:left" | Oracle| {{yes}}| {{yes}}
|
! style="text-align:left" | Oracle Rdb| {{yes}}| {{yes}}
|
! style="text-align:left" | OpenLink Virtuoso| {{yes}}| {{yes}}
|
! style="text-align:left" | Actian Zen (PSQL)| {{yes}}| {{no}}
|
! style="text-align:left" | Polyhedra DBMS| {{no}}| {{no}} (only common views)
|
! style="text-align:left" | PostgreSQL| {{yes}}| {{yes}}
|
! style="text-align:left" | SAP HANA| {{yes}}| {{dunno}}
|
! style="text-align:left" | solidDB| {{yes}}| {{no}} (only common views)
|
! style="text-align:left" | SQL Anywhere| {{yes}}| {{yes}}
|
! style="text-align:left" | SQLite| {{yes}}| {{no}}
|
! style="text-align:left" | Superbase| {{yes}}| {{yes}}
|
! style="text-align:left" | Teradata| {{yes}}| {{yes}}
|
! style="text-align:left" | UniData| {{yes}}| {{no}}
|
! style="text-align:left" | UniVerse| {{yes}}| {{no}}
(#tb 1 back|Note (1):) Server provides tempdb, which can be used for public and private (for the session) temp tables.{{Citation
| url =
weblink | archive-url =
weblink" title="web.archive.org/web/20051023153932
weblink">weblink
| url-status = dead
| archive-date = 2005-10-23
| publisher = Sybase
| title = Online books
}}
(#tb 2 back|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.{{Citation
| publisher = IBM
| url =
weblink | series = Info Centre
| title = Informix Performance Guide
}}
(#tb 4 back|Note (4):) Materialized views can be emulated using stored procedures and triggers.{{Citation
| publisher = Red Noize
| series = Pure
| title = Dynamic Materialized Views in MySQL
| url =
weblink | url-status = dead
| archive-url =
weblink" title="web.archive.org/web/20060423094210
weblink">weblink
| archive-date = 2006-04-23
|year=2005
}}
Indexes
Information about what indexes (other than basic B-/B+ tree indexes) are supported natively.{| style="text-align: center; width: 95%; font-size:80%" class="wikitable sortable"|
! style="width:16em" |! R-/R+ tree! Hash! Expression! Partial! Reverse! Bitmap! GiST! GIN! Full-text! Spatial! FOT! Duplicate index prevention
|
! style="text-align:left" | 4th Dimension| {{dunno}} Cluster| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{yes}}| {{dunno}}| {{dunno}}| {{no}} |
|
! style="text-align:left" | ADABAS| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{dunno}}| {{no}}
|
! style="text-align:left" | Adaptive Server Enterprise| {{no}}| {{no}}| {{yes}}| {{no}}| {{yes}}| {{no}}| {{no}}| {{no}}| {{yes}}| {{dunno}}| {{dunno}}| {{no}}
|
! style="text-align:left" |