| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: RDBMS Comparisons
Loki wrote:
> Hello, in choosing a DBMS, I've built a little chart. Any help in filling in
> the blanks would be much appreciated.
>
> NOTE: This chart is quite wide, and may wrap viciously on some of your
> newsreaders.
>
> DBMS Comparison Chart
Here are entries for the Informix DBMS products. There are 4 distinct servers available.
>
>
> DBMS Informix
> Company Informix
> WEB Site www.informix.com/informix/products/linux/
> Version(s) IDS 7.3x IDS.2000 (9.20) IDS/XPS 8.xx SE 7.30
Description Base Enterprise IDS w/ Object DSS/DW Engine with Simple Zero
RDBMS Extensions Shared Nothing Cluster Maintenance RDBMS
Co-Server Technology CISAM based
> OS(es) Linux/NT/Unix* Linux/NT/Unix* NT/Unix* ^ Linux/NT/Unix*
* - Most UNIX versions/platforms supported ^-Linux not yet supported by this product (rumors indicate a port is possible is demand is there)
>
> MaxDevSize 2GB 2GB 2GB 2GB(COOKED files)
> MaxNumDev 1024 1024 Unlimited (1024/co-server) (limited 1/table)
> MaxNumDB 21,000,000 21,000,000 21,000,000 1/server
> MaxDBsize 2TB 2TB Unlimited (2TB/co-server) No logical limit
> MaxDevPerDB 1024 1024 Unlimited (1024/co-server) No logical limit
> MaxIdxPerDB ~7.6million ~7.6million Unlimited (~7.6M/co-server) No logical limit
> MaxTablePerDB 477,102,080 477,102,080 Unlimited (477,102,080/co-server) 2^31-1
> MaxRowPerDB (depends on rowsize) (depends on rowsize) (depends on rowsize) (depends on rowsize)
> MaxTableSize 2TB 2TB Unlimited (2TB/co-server) 2GB
> MaxNumTables 477,102,080 477,102,080 Unlimited (477,102,080/co-server) No logical limit
> MaxIdxPerTable 77 (154 on 4K page) 77 (154 on 4K page) 77 (154 on 4K page) No logical limit
> MaxColPerTable 32767 32767 32767 32767
> MaxRowPerTable 4,277,659,295/table fragment (no imposed limit per table) 2^31-1
> MaxColPerIdx 16 16 16 8
> MaxRowSize 32KB 32KB 32KB 32,511
> MaxLogSize 2GB 2GB 2GB 2GB
> MaxLogsPerDB
> MinDiskSpace ~50MB ~50MB ~50MB ~2MB
> MinRAM 64MB 64MB 64MB 1MB + ~500KB/user
> QueryLang SQL SQL(w/ORDBMS ext) SQL SQL
> MaxInstances/host 255 255 255 No logical limit
MaxCoservers NA NA No logical limit NA
>
> Replication yes (two types) yes (two types) not available not available
>
> Mirroring yes yes yes no (OS mirror supported)
> Distribution ----------- Full distributed queries and updates with full two-phase commit and heuristic recovery -------------
> FailOver reconnect to replicant reconnect to replicant Failover server on cluster partner reconnect to duplicate server
> Security C2 C2 C2 ??
> XA support Informix CLI Informix CLI Informix CLI Informix CLI
> TPM Supports most TPMs
> JDBC yes yes yes yes
> ODBC ftp://ftp1.informix.com/dist/IDN/linux/odbc/
> PERL DBI ------------- yes (DBD/DBI open source developed, now Informix supported and still open source) ------------------
> C-API ----------------------------- Informix CLI & ESQL/C ----------------------------------------------------------------
> Perl --------------------------------------------- InfPerl -------------------------------------------------------------------
> Java/JVM ??
> R-while-W yes yes yes yes
> Pricing: ---------------------------------------------- Depends on OS and platform size. ---------------------------------------
> GUI ---------------------------------------------- D4GL --------------------------------------------------------------------
> CLI ------------------------------------------- Informix CLI ----------------------------------------------------------------
Art S. Kagel Received on Wed Jan 26 2000 - 10:19:15 CST
 |
 |