Comparativo entre sistemas gerenciadores de bancos de dados relacionais
As tabelas abaixo comparam informações gerais e técnicas para um número de sistemas gerenciadores de bancos de dados relacionais. Veja os artigos individuais de cada produto para mais informações. Este artigo não é inteiramente e/ou necessariamente sempre atualizado. A não ser que seja especificado em notas de rodapé, comparações são baseadas nas versões estáveis sem extensões, add-ons ou programas externos.
Informações Gerais
[editar | editar código-fonte]Suporte a sistemas operacionais
[editar | editar código-fonte]Os sistemas operacionais em que os SGBDs podem executar.
Funcionalidades fundamentais
[editar | editar código-fonte]Informações sobre quais funcionalidades fundamentais de um SGBD relacional estão implementadas nativamente.
Limites
[editar | editar código-fonte]Informações sobre os limites de tamanho de dados.
Tamanho máx. base | Tamanho máx. tabela | Tamanho máx. linha | Máx. colunas por linha | Tamanho máx. Blob/Clob | Tamanho máx. CHAR | Tamanho máx. NUMBER | Menor valor DATE | Maior valor DATE | Tamanho máx. nome da coluna | |
---|---|---|---|---|---|---|---|---|---|---|
4th Dimension | limited | ? | ? | 65135 | 200 GB (2 GiB Unicode) | 200 GB (2 GiB Unicode) | 64 bits | ? | ? | ? |
Advantage Database Server | Ilimitado | 16 EiB | 65530 B | 65135 / (10+ AvgFieldNameLength) | 4 GiB | ? | 64 bits | ? | ? | 128 |
Apache Derby | Ilimitado | Ilimitado | Ilimitado | 1012 (5000 in views) | 2 147 483 647 caracteres | 254 (VARCHAR : 32672)
|
64 bits | 0001-01-01 | 9999-12-31 | 128 |
CUBRID | 2 EB | 2 EB | Ilimitado | 6400 | Ilimitado | 1 GB | 64 bits | 0001-01-01 | 9999-12-31 | 254 |
Drizzle | Ilimitado | 64 TB | 8 kB | 1000 | 4 GB (longtext, longblob) | 64 kB (text) | 64 bits | 0001 | 9999 | 64 |
DB2 | 512 TiB | 512 TB | 32 677 B | 1012 | 2 GB | 32 KiB) | 64 bits | 0001 | 9999 | 128 |
Empress Embedded Database | Ilimitado | 263-1 bytes | 2 GB | 32767 | 2 GB | 2 GB | 64 bits | 0000-01-01 | 9999-12-31 | 32 |
FileMaker | 8TB | 8TB | 8TB | 256,000,000 | 4GB | 10^9 characters | 10^9 numbers w/ range 10^-400 to 10^400 | 0001-01-01 | 4000-12-31 | 100 |
Firebird | Ilimitado1 | ~32 TB | 65 536 B | Depends on data types used. | 2 GB | 32 767 B | 64 bits | 100 | 32768 | 31 |
HSQLDB | 64 TB | Ilimitado8 | Ilimitado8 | Ilimitado8 | 64 TB7 | Ilimitado8 | Ilimitado8 | 0001-01-01 | 9999-12-31 | 128 |
H2 | 64 TB | Ilimitado8 | Ilimitado8 | Ilimitado8 | 64 TB7 | Ilimitado8 | 64 bits | -99999999 | 99999999 | Ilimitado8 |
Tamanho máx. base | Tamanho máx. tabela | Tamanho máx. linha | Máx. colunas por linha | Tamanho máx. Blob/Clob | Tamanho máx. CHAR | Tamanho máx. NUMBER | Menor valor DATE | Maior valor DATE | Tamanho máx. nome da coluna | |
Informix Dynamic Server | ~128 PB | ~128 PB | 32 765 bytes (exclusive of large objects) | 32765 | 4 TB | 32765 | 1032 | 01/01/000110 | 12/31/9999 | 128 bytes |
Ingres | Ilimitado | Ilimitado | 256 kB | 1024 | 2 GB | 32 000 B | 64 bits | 0001 | 9999 | 256 |
InterBase | Ilimitado1 | ~32 TB | 65 536 B | Depends on data types used. | 2 GB | 32 767 B | 64 bits | 100 | 32768 | 31 |
Linter SQL RDBMS | Ilimitado | 230 rows | 64 kB (w/o BLOBs), 4 GB (BLOB) | 250 | 4 GB | 4 kB | 64 bits | 0001-01-01 | 2099-12-31 | 128 |
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 | Ilimitado | 2 GB | 65 500 B | 255 | 2 GB | 16 MB | 32 bits | 0001 | 9999 | ? |
Microsoft SQL Server | 524,272 TB (32 767 files * 16 TB max file size) | 524,272 TB | 8060 bytes (Ilimitado)6 | 30000 | 2 GB | 2 GB6 | 126 bits2 | 0001 | 9999 | 128 |
Microsoft SQL Server Compact (Embedded Database) | 4 GB | 4 GB | 8060 bytes | 1024 | 500 MB | 4000 | 126 bits 2 | 0001 | 9999 | 128 |
MySQL 5 | Ilimitado | MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB | 64 kB3 | 40964 | 4 GB (longtext, longblob) | 64 kB (text) | 64 bits | 1000 | 9999 | 64 |
OpenLink Virtuoso | 32 TB | DB size (or 32 TB) | 4K | 200 | 2 GB | 2 GB | 2**31 | 0 | 9999 | 100 |
Oracle | Ilimitado (4 GB * block size per tablespace) | 4 GB * block size (with BIGFILE tablespace) | 8 kB | 1000 | Ilimitado | 4000 B | 126 bits | -4712 | 9999 | 30 |
Tamanho máx. base | Tamanho máx. tabela | Tamanho máx. linha | Máx. colunas por linha | Tamanho máx. Blob/Clob | Tamanho máx. CHAR | Tamanho máx. NUMBER | Menor valor DATE | Maior valor DATE | Tamanho máx. nome da coluna | |
Polyhedra | Limited by available RAM, address space | 232 rows | Ilimitado | 65536 | 4 GB (subject to RAM) | 4 GB (subject to RAM) | 32 bits | 0001-01-01 | 8000-12-31 | 255 |
PostgreSQL | Ilimitado | 32 TB | 1.6 TB | 250-1600 depending on type | 1 GB (text, bytea) - stored inline or 2 GB (stored in pg_largeobject) | 1 GB | Ilimitado | -4713 | 5874897 | 63 |
RDM Embedded | Ilimitado | 248-1 rows | 32 KB | 1000 | 4 GB | char: 256, varchar: 4 KB | 64 bits | 0001-01-01 | 11758978-12-31 | 31 |
RDM Server | Ilimitado | 264-1 rows | 32 KB | 32768 | Ilimitado | 32 KB | 64 bits | 0001-01-01 | 11758978-12-31 | 32 |
ScimoreDB | Ilimitado | 16 EB | 8050 B | 255 | 16 TB | 8000 B | 64 bits | ? | ? | ? |
SQL Anywhere | 104 TB (13 files, each file up to 8 TB (32k pages)) | Limited by file size | Limited by file size | 45000 | 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 | 32767 | 2 GB | 2 GB | 64 bits | No DATE type9 | No DATE type9 | Ilimitado |
Teradata | Ilimitado | Ilimitado | 64 kB wo/lobs (64 GB w/lobs) | 2048 | 2 GB | 10 000 | 64 bits | ? | 9999-12-31 Select 80991231 (date); | 30 |
UniVerse | Ilimitado | Ilimitado | Ilimitado | Ilimitado | Ilimitado | Ilimitado | Ilimitado | Ilimitado | Ilimitado | Ilimitado |
Xeround Cloud Database | Ilimitado | Ilimitado | 32GB, depending on available memory | 1000 | 4GB | 64K | 64 bits | 1000 | 9999 | 64 |
Tamanho máx. base | Tamanho máx. tabela | Tamanho máx. linha | Máx. colunas por linha | Tamanho máx. Blob/Clob | Tamanho máx. CHAR | Tamanho máx. NUMBER | Menor valor DATE | Maior valor DATE | Tamanho máx. nome da coluna |
Tabelas e visões
[editar | editar código-fonte]Informações sobre quais tipos de tabelas e visões (que não as básicas) são suportadas nativamente.
Tabela temporária | Visão materializada | |
---|---|---|
4th Dimension | ![]() |
Planejada inclusão na próxima versão maior |
ADABAS | ? | ? |
Adaptive Server Enterprise | ![]() |
![]() |
Advantage Database Server | ![]() |
![]() |
Altibase | ![]() |
![]() |
Apache Derby | ![]() |
![]() |
CUBRID | ![]() |
![]() |
Drizzle | ![]() |
![]() |
DB2 | ![]() |
![]() |
Empress Embedded Database | ![]() |
![]() |
Firebird | ![]() |
![]() |
HSQLDB | ![]() |
![]() |
H2 | ![]() |
![]() |
Informix Dynamic Server | ![]() |
![]() |
Ingres | ![]() |
Planejada inclusão na próxima versão maior |
InterBase | ![]() |
![]() |
Linter SQL RDBMS | ![]() |
![]() |
LucidDB | ![]() |
![]() |
MaxDB | ![]() |
![]() |
Microsoft Access (JET) | ![]() |
![]() |
Microsoft Visual Foxpro | ![]() |
![]() |
Microsoft SQL Server | ![]() |
![]() |
Microsoft SQL Server Compact (Embedded Database) | ![]() |
![]() |
MonetDB/SQL | ![]() |
![]() |
MySQL | ![]() |
![]() |
OpenBase SQL | ![]() |
![]() |
Oracle | ![]() |
![]() |
Oracle Rdb | ![]() |
![]() |
OpenLink Virtuoso | ![]() |
![]() |
Polyhedra DBMS | ![]() |
![]() |
PostgreSQL | ![]() |
![]() |
RDM Embedded | ![]() |
![]() |
RDM Server | ![]() |
![]() |
SQL Anywhere | ![]() |
![]() |
ScimoreDB | ![]() |
![]() |
SQLite | ![]() |
![]() |
Teradata | ![]() |
![]() |
UniData | ![]() |
![]() |
UniVerse | ![]() |
![]() |
Xeround Cloud Database | ![]() |
![]() |
Índices
[editar | editar código-fonte]Informações sobre quais índices (que não os básicos B-/B+) são suportados nativamente.
Capacidades
[editar | editar código-fonte]União | Interseção | Except | Inner joins | Outer joins | Inner selects | Merge joins | Blobs e Clobs | Common table expressions | Funções de janelamento | Queries em paralelo | |
---|---|---|---|---|---|---|---|---|---|---|---|
4th Dimension | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ? |
ADABAS | ![]() |
? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
Adaptive Server Enterprise | ![]() |
? | ? | ![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ![]() |
Advantage Database Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? | ![]() |
? |
Altibase | ![]() |
![]() |
Sim, via MINUS | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Apache Derby | ![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ![]() |
![]() |
![]() |
? |
CUBRID | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
Drizzle | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
DB2 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Empress Embedded Database | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ? |
Firebird | ![]() |
? | ? | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
HSQLDB | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
H2 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
experimental[56] | ![]() |
? |
Informix Dynamic Server | ![]() |
? | Sim, via MINUS | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? | ![]() |
Ingres | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
InterBase | ![]() |
? | ? | ![]() |
![]() |
? | ? | ![]() |
? | ? | ? |
Linter SQL RDBMS | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
LucidDB | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ? |
MaxDB | ![]() |
? | ? | ![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ? |
Microsoft Access (JET) | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
Microsoft Visual Foxpro | ![]() |
? | ? | ![]() |
![]() |
![]() |
? | ![]() |
? | ? | ? |
Microsoft SQL Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Microsoft SQL Server Compact (Embedded Database) | ![]() |
![]() |
![]() |
![]() |
![]() |
? | ![]() |
![]() |
![]() |
![]() |
? |
MonetDB/SQL | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
MySQL | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
OpenBase SQL | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ? |
Oracle | ![]() |
![]() |
Sim, via MINUS | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Oracle Rdb | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ? |
OpenLink Virtuoso | ![]() |
? | ? | ![]() |
![]() |
![]() |
? | ![]() |
? | ? | ? |
Polyhedra DBMS | ![]() |
![]() |
![]() |
![]() |
![]() |
? | ? | ![]() |
? | ? | ? |
PostgreSQL | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
RDM Embedded | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
RDM Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
ScimoreDB | ![]() |
? | ? | ![]() |
Apenas LEFT | ![]() |
![]() |
![]() |
? | ? | ? |
SmallSQL | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
SQL Anywhere | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
SQLite | ![]() |
![]() |
![]() |
![]() |
Apenas LEFT | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Teradata | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
UniVerse | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
Xeround Cloud Database | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Tipos de dados
[editar | editar código-fonte]Sistema de tipos | Inteiros | Ponto flutuante | Decimal | String | Binário | Data/Hora | Booleano | Outros | |
---|---|---|---|---|---|---|---|---|---|
Altibase[64] | Estático | 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 | |
CUBRID[65] | Estático | 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 |
Drizzle[66] | Estático | INT (32-bit), BIGINT (64-bit) | DOUBLE (aka REAL) (64-bit) | DECIMAL | BINARY, VARCHAR, VARBINARY, TEXT, | BLOB | DATETIME, DATE, TIMESTAMP | ENUM, SERIAL | |
Empress Embedded Database | Estático | 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 and NLSCHARACTER CHARACTER LARGE OBJECT, TEXT, NATIONAL CHARACTER LARGE OBJECT, and NLSTEXT |
BINARY LARGE OBJECT or BLOB
BULK |
DATE,
EDATE, TIME, ETIME, EPOCH_TIME, TIMESTAMP, MICROTIMESTAMP |
BOOLEAN | SEQUENCE 32
SEQUENCE |
HSQLDB[67] | Estático | 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 Dinâmico Server[68] | Estático | 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, USER DEFINED TYPES |
Ingres[69] | Estático | 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) |
Microsoft SQL Server[70] | Estático | TINYINT, SMALLINT, INT, BIGINT | FLOAT, REAL | NUMERIC, DECIMAL, SMALLMONEY, MONEY | CHAR, VARCHAR, TEXT, NCHAR, NVARCHAR, NTEXT | BINARY, VARBINARY, IMAGE, FILESTREAM | DATE, DATETIMEOFFSET, DATETIME2, SMALLDATETIME, DATETIME, TIME | BIT | CURSOR, TIMESTAMP, HIERARCHYID, UNIQUEIDENTIFIER, SQL_VARIANT, XML, TABLE |
Microsoft SQL Server Compact (Embedded Database)[71] | Estático | TINYINT, SMALLINT, INT, BIGINT | FLOAT, REAL | NUMERIC, DECIMAL, MONEY | NCHAR, NVARCHAR, NTEXT | BINARY, VARBINARY, IMAGE | DATETIME | BIT | TIMESTAMP, ROWVERSION, UNIQUEIDENTIFIER, IDENTITY, ROWGUIDCOL |
MySQL[72] | Estático | 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 | BOOLEAN (aka BOOL) = synonym for TINYINT | ENUM, SET, GIS data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon) |
Oracle[73] | Estático + Dinâmico (usando ANYDATA) | NUMBER | BINARY_FLOAT, BINARY_DOUBLE | NUMBER | CHAR, VARCHAR2, CLOB, NCLOB, NVARCHAR2, NCHAR | BLOB, RAW, LONGRAW, BFILE | DATE, TIMESTAMP (with/without TIMEZONE), INTERVAL | N/A | SPATIAL, IMAGE, AUDIO, VIDEO, DICOM, XMLType |
Polyhedra | Estático | INTEGER8 (8-bit), INTEGER(16-bit), INTEGER (32-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[74] | Estático | 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, arrays |
RDM Embedded[75] | Estático | 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[76] | Estático | 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 |
SQLite[77] | Dinâmico | INTEGER (64-bit) | REAL (aka FLOAT, DOUBLE) (64-bit) | N/A | TEXT (aka CHAR, CLOB) | BLOB | N/A | N/A | N/A |
UniData | Dinâmico | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
UniVerse | Dinâmico | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
Xeround Cloud Database | Estático | 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 | BOOLEAN (aka BOOL) = synonym for TINYINT | ENUM, SET |
Sistema de tipos | Inteiros | Ponto flutuante | Decimal | String | Binário | Data/Hora | Booleano | Outros |
Outros objetos
[editar | editar código-fonte]Informações sobre quais outros objetos são suportados nativamente.
Domínio de Dados | Cursor | Trigger | Funções 1 | Procedure 1 | Rotinas externas 1 | |
---|---|---|---|---|---|---|
4th Dimension | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
ADABAS | ? | ![]() |
? | ![]() |
![]() |
? |
Adaptive Server Enterprise | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Advantage Database Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Altibase | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Apache Derby | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
CUBRID | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Drizzle | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Empress Embedded Database | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
DB2 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Firebird | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
HSQLDB | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
H2 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Informix Dynamic Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Ingres | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
InterBase | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Linter SQL RDBMS | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
LucidDB | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
MaxDB | ![]() |
![]() |
![]() |
![]() |
![]() |
? |
Microsoft Access (JET) | ![]() |
![]() |
![]() |
![]() |
Sim, mas somente para operações DML/DDL | ![]() |
Microsoft Visual Foxpro | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Microsoft SQL Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Microsoft SQL Server Compact (Embedded Database) | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
MonetDB | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
MySQL | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
OpenBase SQL | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Oracle | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Oracle Rdb | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
OpenLink Virtuoso | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Polyhedra DBMS | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
PostgreSQL | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
RDM Embedded | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
RDM Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
ScimoreDB | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
SQL Anywhere | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
SQLite | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Teradata | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
UniData | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
UniVerse | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Xeround Cloud Database | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Domínio de Dados | Cursor | Trigger | Funções 1 | Procedure 1 | Rotinas externas 1 |
Particionamento
[editar | editar código-fonte]Informações sobre quais métodos de particionamento são suportados nativamente.
Range | Hash | Composite (Range+Hash) | List | Expression | |
---|---|---|---|---|---|
4th Dimension | ? | ? | ? | ? | |
ADABAS | ? | ? | ? | ? | |
Adaptive Server Enterprise | ![]() |
![]() |
![]() |
![]() | |
Advantage Database Server | ![]() |
![]() |
![]() |
![]() | |
Altibase | ![]() |
![]() |
![]() |
![]() | |
Apache Derby | ![]() |
![]() |
![]() |
![]() | |
CUBRID | ![]() |
![]() |
![]() |
![]() | |
IBM DB2 | ![]() |
![]() |
![]() |
![]() | |
Empress Embedded Database | ![]() |
![]() |
![]() |
![]() | |
Firebird | ![]() |
![]() |
![]() |
![]() | |
HSQLDB | ![]() |
![]() |
![]() |
![]() | |
H2 | ![]() |
![]() |
![]() |
![]() | |
Informix Dynamic Server | ![]() |
![]() |
![]() |
![]() |
![]() |
Ingres | ![]() |
![]() |
![]() |
![]() | |
InterBase | ![]() |
![]() |
![]() |
![]() | |
Linter SQL RDBMS | ![]() |
![]() |
![]() |
![]() | |
MaxDB | ![]() |
![]() |
![]() |
![]() | |
Microsoft Access (JET) | ![]() |
![]() |
![]() |
![]() | |
Microsoft Visual Foxpro | ![]() |
![]() |
![]() |
![]() | |
Microsoft SQL Server | ![]() |
![]() |
![]() |
![]() | |
Microsoft SQL Server Compact (Embedded Database) | ![]() |
![]() |
![]() |
![]() | |
MonetDB | ![]() |
![]() |
![]() |
![]() | |
MySQL | ![]() |
![]() |
![]() |
![]() | |
OpenBase SQL | ? | ? | ? | ? | |
Oracle | ![]() |
![]() |
![]() |
![]() | |
Oracle Rdb | ![]() |
![]() |
? | ? | |
OpenLink Virtuoso | ![]() |
![]() |
![]() |
![]() | |
Polyhedra DBMS | ![]() |
![]() |
![]() |
![]() | |
PostgreSQL | ![]() |
![]() |
![]() |
![]() | |
RDM Embedded | ![]() |
![]() |
![]() |
![]() | |
RDM Server | ![]() |
![]() |
![]() |
![]() | |
ScimoreDB | ![]() |
![]() |
![]() |
![]() | |
SQL Anywhere | ![]() |
![]() |
![]() |
![]() | |
SQLite | ![]() |
![]() |
![]() |
![]() | |
Teradata | ![]() |
![]() |
![]() |
![]() | |
UniVerse | ![]() |
![]() |
![]() |
![]() | |
Xeround Cloud Database | N/A - particionamento feito transparentemente | N/A - particionamento feito transparentemente | N/A - particionamento feito transparentemente | N/A - particionamento feito transparentemente | |
Range | Hash | Composite (Range+Hash) | List | Expression |
Controle de acesso
[editar | editar código-fonte]Informações sobre funcionalidades de controle de acesso.
Encriptação nativa em rede1 | Proteção contra ataques força-bruta | Compatibilidade para Diretório Enterprise | Regras de complexidade de senha2 | Acesso Patch3 | Executar sem privilégios4 | Auditoria | Limite de recursos | Separação de papéis (RBAC)5 | Certificação de segurança | |
---|---|---|---|---|---|---|---|---|---|---|
Adaptive Server Enterprise | ![]() |
![]() |
![]() |
![]() |
Parcial (precisa registrar; depende do produto)[78] | ![]() |
![]() |
![]() |
![]() |
![]() |
Advantage Database Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
DB2 | ![]() |
? | ![]() |
![]() |
? | ![]() |
![]() |
![]() |
![]() |
![]() |
Empress Embedded Database | ? | ? | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Firebird | ![]() |
![]() |
![]() |
![]() |
Parcial (sem página de segurança)[80] | ![]() |
![]() |
![]() |
![]() |
? |
HSQLDB | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
H2 | ![]() |
![]() |
? | ![]() |
? | ![]() |
? | ![]() |
![]() |
![]() |
Informix Dynamic Server | ![]() |
? | ![]() |
?10 | ![]() |
![]() |
![]() |
![]() |
![]() |
? |
Linter SQL RDBMS | ![]() |
![]() |
![]() |
![]() |
? | ![]() |
![]() |
![]() |
![]() |
![]() |
MariaDB | ![]() |
![]() |
![]() |
![]() |
Parcial (sem página de segurança) | ![]() |
? | ? | ?8 | ![]() |
MySQL | ![]() |
![]() |
![]() |
![]() |
Parcial (sem página de segurança)[81] | ![]() |
? | ? | ?8 | ![]() |
OpenBase SQL | ![]() |
? | ![]() |
![]() |
? | ? | ? | ? | ? | ? |
Microsoft SQL Server | ![]() |
? | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Microsoft SQL Server Compact (Embedded Database) | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
? |
Oracle | ![]() |
![]() |
![]() |
![]() |
? | ![]() |
![]() |
![]() |
![]() |
![]() |
PostgreSQL | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
RDM Embedded | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
RDM Server | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
SQL Anywhere | ![]() |
? | ![]() |
![]() |
? | ![]() |
![]() |
![]() |
![]() |
![]() |
SQLite | ![]() |
![]() |
![]() |
![]() |
Parcial (sem página de segurança)[83] | ![]() |
![]() |
![]() |
![]() |
![]() |
Xeround Cloud Database | ![]() |
![]() |
![]() |
![]() |
N/A - database as a service | ![]() |
![]() |
![]() |
![]() |
![]() |
Ver também
[editar | editar código-fonte]- Lista dos sistemas gerenciadores de bancos de dados relacionais
- Comparativo entre sistemas gerenciadores de bancos de dados objeto-relacionais
- Comparativo entre ferramentas de bancos de dados
- SQLite
Referências
- ↑ Altibase.
- ↑ NHN Corp.
- ↑ Empress.
- ↑ FileMaker.
- ↑ Firebird SQL.
- ↑ IPL, Firebird SQL.
- ↑ IDPL, Firebird SQL.
- ↑ hsqldb
- ↑ Eigenbase.
- ↑ «MariaDB 5.5.23 Release Notes». AskMonty KnowledgeBase. Consultado em 18 de abril de 2012
- ↑ MonetDB Public License (1.1), CWI.
- ↑ mSQL, Products, AU: Hughes.
- ↑ Nexus DB.
- ↑ Omnis.
- ↑ OpenBase.
- ↑ OpenLink Software.
- ↑ Oracle Rdb Product Family Compatibility Matrix, Oracle Corporation.
- ↑ Corel.
- ↑ PostgreSQL development group, PostgreSQL community.
- ↑ PostgreSQL 2012-09-10, Documentation (9.2.0), PostgreSQL Community.
- ↑ License, PostgreSQL Community.
- ↑ r:Base.
- ↑ RDM Embedded, Raima Inc.
- ↑ RDM Server, Raima Inc..
- ↑ Scimore.
- ↑ SQLBase, Products, Unify.
- ↑ SQLite Release History, SQLite.
- ↑ «Building MariaDB on Mac OS X using Homebrew». AskMonty KnowledgeBase. Consultado em 30 de setembro de 2011
- ↑ SQLite Full Unicode support is optional and not installed by default in most systems (like Android, Debian…)
- ↑ «Derby», Full Text Indexing, Search, Issues, Apache.
- ↑ Full-text search with DB2 Text Search, Developer Works, IBM.
- ↑ Does Firebird support full-text search?, Firebird FAQ.
- ↑ Fulltext Search, Tutorial, H2 Database.
- ↑ Forest of Trees Index, Informix Infocenter, IBM.
- ↑ Full Text Search Functions (PDF), Documentation, RU: Linter.
- ↑ Does Microsoft Access have Full Text Search?, Questions, Stack Overflow.
- ↑ «Microsoft SQL Server Full-Text Search», Library, MSDN, Microsoft.
- ↑ «Spatial Indexing Overview», Library, Tech Net, Microsoft.
- ↑ «Microsoft SQL Server Compact Full-text search is not available», Forums, MSDN, Microsoft.
- ↑ «Feature request #4990: Functional Indexes», Bugs, MySQL, Oracle.
- ↑ «Feature request #13979: InnoDB engine doesn't support FULLTEXT», Bugs, MySQL, Oracle.
- ↑ Creating Spatial Indexes, MySQL, Oracle.
- ↑ Does Oracle support full text search?, Questions, Stack Overflow
- ↑ «Location Features for Database 11g», Spatial & Locator, Tech Network, Oracle.
- ↑ Full Text Search], Documentation (8.4), PostgreSQL community.
- ↑ «4», Manual, PostGIS, Refractions.
- ↑ Free text search queries in SQL, ScimoreDB.
- ↑ The SQLite R*Tree Module
- ↑ SQLite FTS3 Extension
- ↑ SpatiaLite (2.3.1), IT: Gaia GIS.
- ↑ Full-Text Search, Online Publications, Teradata.
- ↑ geospatial
- ↑ How does Drizzle handle parallel "things"?
- ↑ «Article», Library, Developer Works, IBM.
- ↑ a b New Features in HyperSQL 2.2
- ↑ H2 > Advanced > Recursive Queries
- ↑ H2 Roadmap
- ↑ Informix parallel data query (PDQ)
- ↑ Only very limited functions available before SQL Server 2012, Microsoft
- ↑ «SQL Server Parallel Query Processing», Library, MSDN, Microsoft.
- ↑ «Feature request #16244: SQL-99 Derived table WITH clause (CTE)», Bugs, MySQL, Oracle Parâmetro desconhecido
|http://bugs.mysql.com/bug.php?id=
ignorado (ajuda). - ↑ «Feature request #1542: Parallel query», Bugs, MySQL, Oracle Parâmetro desconhecido
|http://bugs.mysql.com/bug.php?id=
ignorado (ajuda). - ↑ PostgreSQL lacks parallel query processing, Mark Mail.
- ↑ «Data Types», General Reference, HDB, Altibase.
- ↑ «Data Types», CUBRID SQL Guide, Reference Manual, CUBRID.
- ↑ Built-in Column Types, Documents, Drizzle.
- ↑ «General: HSQLDB data types», Guide, Documents (2.0), HSQLDB.
- ↑ Publications, IBM http://www.ibm.com/shop/publications/order?CTY=US&FNC=SRX&PBL=SC23-7750-04
|url=
missing title (ajuda). - ↑ «3: Understanding SQL Data Types», SQL Reference Guide, Doucments (9.3), Ingres.
- ↑ «SQL Server Data Types», Library, MSDN, Microsoft.
- ↑ «SQL Server Compact Data Types», Library, MSDN, Microsoft.
- ↑ «10. Data Types», Reference manual, MySQL (5.0), Oracle.
- ↑ «Data Types», SQL Reference, Server documents (11.2), Oracle
- ↑ «Data Types», Manual, Documents (8.4), PostgreSQL community.
- ↑ «Defining a Database», SQL Reference (10.1), Raima
- ↑ «Defining Table Columns», SQL Reference (8.3), Raima
- ↑ Datatypes (3), SQLite.
- ↑ Support, Downloads, Sybase.
- ↑ «Release», Engine, Development (2.0), Firebird SQL.
- ↑ Files, Firebird SQL.
- ↑ «Downloads», Development, MySQL, Oracle.
- ↑ Security, Support, PostgreSQL community.
- ↑ Download, SQLite.