| 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 -> RDBMS Comparisons
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
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 Tue Jan 25 2000 - 16:46:23 CST
 |
 |