Re: RDBMS Comparisons

Maybe post a attachment is better.

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
>
> DBMS Sybase Oracle Informix DB2 Interbase Ingres II PostgreSQL Teradata NonStop SQL/MX University Postgres University Ingres
> Sybase INC Orace INC Informix IBM Inprise / Borland CA PostGreSQL NCR COMPAQ / Tandem UBerkeley UBerkeley
> linux.sybase.com platforms.oracle.com/linux www.informix.com/informix/products/linux/ www.software.ibm.com/data/db2/linux/ www.interbase.com www.cai.com/bpp/ www.postgresql.org www3.ncr.com/product/teradata/ihttp://s2k-ftp.CS.Berkeley.EDU/ingres/xpd.htm http://epoch.cs.berkeley.edu:8000/postgres/postgres.html
> ASE 11.0.3.3 ASE 11.9.2 8i (Enterprise Edition) IDS 7.3.x IDS2000 4.0 5.1.1 BETA
> OS Linux Linux Linux L2.0.36/gc2.0.7/(RH5.2) L2.2.5/gc2.1.1 L2.0.35/gc2.0.7+/pdksh/libstdc++2.8.0+/rpm RH4.2 RH5.1 c5/6,L2.0.27+ (RH5.1) Linux SVR4/NT NonStop Kernel OS rel G40+)
> MaxDevSize 2GB 2GB 2GB 2GB
> MaxNumDev 256 256
> MaxNumDB 32767 21,000,000
> MaxDBsize 8TB 32TB 1TB+
> MaxDevPerDB 128 128
> MaxIdxPerDB 2^32
> MaxTablePerDB
> MaxRowPerDB
> MaxTableSize 64TB 32TB
> MaxNumTables 477,000,000 2^16
> MaxIdxPerTable 77 2^16
> MaxColPerTable 2767
> MaxRowPerTable 2^32
> MaxColPerIdx 16
> MaxRowSize 32kB 64kB
> MaxLogSize 2GB 4GB
> MaxLogsPerDB 128
> MinDiskSpace 64MB 200MB 120MB 10MB 10MB
> MinRAM 32MB 64MB 100MB 16MB 16MB
> QueryLang SQL SQL SQL SQL, PostQUEL SQL SQL SQL SQL SQL, QUEL SQL, PostQUEL SQL SQL PostQUEL QUEL
> TransactSQL PL/SQL isql
>
> Replication Replication Server (nonLinux) Advanced Replication yes yes no (self program) Ingres Replicator
> Mirroring built in mirroring Mirror Shadow(incl)
> Distribution Replication Server/OmniConnect(nLnx) yes, with recovery and partial commit federated / distributed with recovery (incl) Ingres Vision
> FailOver OpenSwitch/Replication Server(nLnx)
> Security C2
> XA support XA Server (11.9.2) <non Linux> Informix CLI yes yes
> TPM yes
> JDBC yes www.blackdown.org/java-linux.html yes yes
> ODBC ftp://ftp1.informix.com/dist/IDN/linux/odbc/ yes Win only yes yes
> PERL DBI yes DBD-DB2-0.71.tar.gz no DBD:pg
> C-API CT-Lib / DB-Lib Oracle OCI Informix CLI IB API Open API libpq
> C++-API Pro*C ESQL/C libpq++
> Perl SybPerl IBPerl pgsql_perl5
> Java/JVM yes (SQLJ) www.blackdown.org/java-linux.html
>
> DateRange 1/1/1582-31/12/2382
> R-while-W yes yes
>
> Pricing:
> 11.0.3.3 free EE NamedUsrMultSvr $750 per user $300 per user(10min) $1800 UnivDev $925 one time charge 4.2 free BETA is free free free free
> 11.9.2 DevelKit Lnx $1542 " 2year $263 client SDK free PersonalDev free download 5.6MediaKitLnx $50
> 11.9.2 BaseSvr&1UsrLnx $1542 " 4year $450 $39 one time charge 5.6SvrLic1usrL $200
> 11.9.2 Network Seat $302 EE NamedUsrSngSvr $600 WrkGrp $925 one time charge 5.6Simul1Lnx $150
> " 2year $210 Enterprise $??? 5.6Simul10Lnx $1200
> " 4year $360 5.6Simul20Lnx $2100
> EE PwrUnitIntel $100 5.6UnlimInetLnx $2500
> " 2year $35 5.6Precompiler $500
> " 4year $90
> EE Trial License free
>
> GUI wisql(3rdParty) DB2 Control Center (Java/Web)
> CLI iSQL SQL*Plus
Received on Wed Jan 26 2000 - 10:16:16 CST