RE: RDBMS Comparisons

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF67B8.961DD3A6 Content-Type: text/plain; charset="iso-8859-1" If you can put Delimiters b/w columns, that will be of much help. Shahid Mehmood Software Designer II Information Systems Department The Aga Khan University Karachi Official:Y > -----Original Message----- > From: Loki [SMTP:base@alpha.freya.vinland.rad.mgh.mcgill.ca] > Sent: Wednesday, January 26, 2000 03:46 > To: informix-list@iiug.org > Subject: 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.h > tm 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 ------_=_NextPart_001_01BF67B8.961DD3A6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META H

shahid.mehmood@aku.edu wrote: > If you can put Delimiters b/w columns, that will be of much help. > Shahid Mehmood > Software Designer II > Information Systems Department > The Aga Khan University > Karachi > Official:Y It has been reposted wtih semicolons limiting the columns

shahid.mehmood@aku.edu wrote: > If you can put Delimiters b/w columns, that will be of much help. > Shahid Mehmood > Software Designer II > Information Systems Department > The Aga Khan University > Karachi > Official:Y It has been reposted wtih semicolons limiting the columns