See also
- Comparison of object–relational database management systems
- Comparison of relational database management systems
- Comparison of database administration tools
| Types | |
|---|---|
| Concepts | |
| Objects | |
| Components | |
| Functions | |
| Related topics | |
This is a list of relational database management systems .
| Name | License |
|---|---|
| 4th Dimension | Proprietary |
| Access Database Engine (formerly known as Jet Database Engine) | Proprietary |
| Actian Zen (PSQL) (formerly known as Pervasive PSQL) | Proprietary |
| Adabas D | Proprietary |
| Airtable | Proprietary |
| Altibase | Proprietary |
| Amazon Aurora | Proprietary |
| Apache Derby | Apache License 2.0 |
| Apache Ignite | Apache License 2.0 |
| Aster Data Systems | Proprietary |
| CA Datacom | Proprietary |
| CA IDMS | Proprietary |
| Clarion | Proprietary |
| ClickHouse | Apache License 2.0 |
| Clustrix | Proprietary |
| CockroachDB | Proprietary |
| CSQL | Proprietary |
| CUBRID | Apache, BSD |
| DataEase | Proprietary |
| DataFlex | Proprietary |
| Database Management Library | Proprietary |
| Dataphor | Proprietary |
| dBase | Proprietary |
| Derby (aka Java DB) | Apache License 2.0 |
| Empress Embedded Database | Proprietary |
| EnterpriseDB | Proprietary |
| eXtremeDB | Proprietary |
| Exasol | Proprietary |
| Extensible Storage Engine | Proprietary |
| FileMaker Pro | Proprietary |
| Firebird | MPL/GPL/LGPL |
| FoundationDB | Apache License 2.0 |
| FrontBase | Proprietary |
| Greenplum | Apache License 2.0 |
| GroveSite | Proprietary |
| H2 | MPL/GPL/LGPL |
| Helix | Proprietary |
| HSQLDB | BSD |
| IBM Db2 | Proprietary |
| IBM Lotus Approach | Proprietary |
| Infobright | GPL |
| Informix | Proprietary |
| Ingres | GPL |
| InterBase | Proprietary |
| InterSystems Caché | Proprietary |
| InterSystems IRIS Data Platform | Proprietary |
| Linter SQL RDBMS | Proprietary |
| MariaDB | GPL |
| MaxDB | Proprietary |
| Microsoft SQL Server | Proprietary |
| Microsoft SQL Server Express | Proprietary |
| Microsoft Visual FoxPro | Proprietary |
| Mimer SQL | Proprietary |
| MonetDB | MPL/GPL/LGPL |
| mSQL | GPL |
| MySQL | GPL |
| Netezza | Proprietary |
| NexusDB | Proprietary |
| NonStop SQL | Proprietary |
| NuoDB | Proprietary |
| Omnis Studio | Proprietary |
| OpenLink Virtuoso (Open Source Edition) | GPL |
| OpenLink Virtuoso Universal Server | Proprietary |
| Oracle | Proprietary |
| Oracle Rdb for OpenVMS | Proprietary |
| Panorama | Proprietary |
| Paradox | Proprietary |
| Percona Server for MySQL | GPL |
| Percona XtraDB Cluster | GPL |
| Polyhedra | Proprietary |
| PostgreSQL | PostgreSQL License |
| Postgres Plus Advanced Server | Proprietary |
| Progress Software | Proprietary |
| R:Base | Proprietary |
| RethinkDB | Apache License 2.0 |
| SAND CDBMS | Proprietary |
| SAP HANA | Proprietary |
| SAP Adaptive Server Enterprise | Proprietary |
| SAP IQ (formerly known as Sybase IQ) | Proprietary |
| SingleStore | Proprietary |
| Snowflake Cloud Data Warehouse | Proprietary |
| solidDB | Proprietary |
| SurrealDB | Proprietary |
| SQL Anywhere (formerly known as Sybase Adaptive Server Anywhere and Watcom SQL) | Proprietary |
| SQL Azure (Cloud SQL Server) | Proprietary |
| SQLBase | Proprietary |
| SQLite | Public Domain |
| SQream DB | Proprietary |
| SAP Advantage Database Server (formerly known as Sybase Advantage Database Server) | Proprietary |
| Teradata | Proprietary |
| TiDB | Apache License 2.0 |
| TimesTen | Proprietary |
| Trafodion | Apache License 2.0 |
| Transbase | Proprietary |
| Unisys RDMS 2200 | Proprietary |
| UniData | Proprietary |
| UniVerse | Proprietary |
| Vectorwise | Proprietary |
| Vertica | Proprietary |
| VoltDB | Proprietary |
| YugabyteDB | Apache License 2.0 |
| Types | |
|---|---|
| Concepts | |
| Objects | |
| Components | |
| Functions | |
| Related topics | |
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a database system. Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database.
A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A database management system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems are equipped with the option of using SQL for querying and updating the database.
Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.
An object–relational database (ORD), or object–relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. Also, as with pure relational systems, it supports extension of the data model with custom data types and methods.
Business System 12, or simply BS12, was one of the first fully relational database management systems, designed and implemented by IBM's Bureau Service subsidiary at the company's international development centre in Uithoorn, Netherlands. Programming started in 1978 and the first version was delivered in 1982. It was never widely used and essentially disappeared soon after the division was shut down in 1985, possibly because IBM and other companies settled on SQL as the standard.
Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.
Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.
Firebird is an open-source SQL relational database management system that supports Linux, Microsoft Windows, macOS and other Unix platforms. The database forked from Borland's open source edition of InterBase in 2000 but the code has been largely rewritten since Firebird 1.5.
Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.
A query language, also known as data query language or database query language (DQL), is a computer language used to make queries in databases and information systems. In database systems, query languages rely on strict theory to retrieve information. A well known example is the Structured Query Language (SQL).
HSQLDB is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92, SQL:2008, SQL:2011, and SQL:2016 standards. It offers a fast, small database engine which offers both in-memory and disk-based tables. Both embedded and server modes are available.
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.
Apache Derby is a relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint.
PRTV was the world's first relational database management system that could handle significant data volumes.
H2 is a relational database management system written in Java. It can be embedded in Java applications or run in client-server mode.
A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.
In relational databases, the information schema is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as:
=> SELECT count(table_name) FROM information_schema.tables; count ------- 99 => SELECT column_name, data_type, column_default, is_nullable FROM information_schema.columns WHERE table_name='alpha'; column_name | data_type | column_default | is_nullable -------------+-----------+----------------+------------- foo | integer | | YES bar | character | | YES => SELECT * FROM information_schema.information_schema_catalog_name; catalog_name -------------- johnd
An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:
NoSQL is an approach to database design that focuses on providing a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. Instead of the typical tabular structure of a relational database, NoSQL databases house data within one data structure. Since this non-relational database design does not require a schema, it offers rapid scalability to manage large and typically unstructured data sets. NoSQL systems are also sometimes called "Not only SQL" to emphasize that they may support SQL-like query languages or sit alongside SQL databases in polyglot-persistent architectures.
The following outline is provided as an overview of and topical guide to MySQL:
