Database scalability study

Hi, I need to perform a "scalability" comparison between the following databases: 1a) Sybase FMS V.11.0.3 on SUN UNIX 2.6 1b) Sybase Cluster V.11.5.1 on SUN UNIX 2.6 2) Oracle MLT V.2.2 on HP UNIX 7.3 3) MS Access MAP on Win NT 4.0 Server 4) INFORMIX BillDats V.7.30.UC2 on SUN UNIX 2.6 There are many parameters that could be considered. I've done some research on the WEB and on the various newsgroups and I've found the ones written below (but I'm totally open to suggestions). Could you help me finding some of the answers for the four alternatives? Any partial answers and/or advice would also be much appreciated. The questions with a "+" are the most important to for my study... Thanks very much. Andrej * Characteristics - Intrinsic limitations: case sensitivity max number of foreign keys (+)SQL syntax: compliance with which version of SQL, proprietary SQL, stored procedure, dynamic SQL (+)Unit of work (e.g. database or user?) length of table and variable names max number of tables in queries Y2K compliance - (+) Partitioning : distribution load sharing - (+) Security (what about an eventual WEB access?) - Complexity: learning curve (for DBAs, developers, "technical" users) and education services available * Performance - (+)Max number of users - (+)Max number of processors - (+)Max hard disk space - (+)Performance monitoring tools * Compatibility/Interoperability with other applications - Import/export from/to other database systems - (+)Interface with programming languages and APIs - (+)does it allow you to pick the best components (both hardware and software) and know that they will work well together? * Adaptability - (+)guaranty that the system will accommodate advances in technology - (+)financial situation of the DBMS vendor (for future development and support) - years of presence on the market (maturity) - (+)quality of technical support * Affordability - Takes advantage of the plummering prices in the personal computer and LAN markets. - cost scalability (increase of cost vs increase of the size of the database) Thanks again. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

asobkows@my-dejanews.com wrote: > Hi, > > I need to perform a "scalability" comparison between the following databases: > 1a) Sybase FMS V.11.0.3 on SUN UNIX 2.6 > 1b) Sybase Cluster V.11.5.1 on SUN UNIX 2.6 > 2) Oracle MLT V.2.2 on HP UNIX 7.3 > 3) MS Access MAP on Win NT 4.0 Server > 4) INFORMIX BillDats V.7.30.UC2 on SUN UNIX 2.6 Uhm, first, on Sybase, you need to look at 11.9 their latest and greatest. (RLL is in there....) Also HP-UX 7.3? Dude! I'd check your set up again. Any machine running such an old version of HP-UX must be ancient. HP-UX 9.x has been out since '94 and if moore's law holds true, a modern pentium would smoke that baby, even with EIDE drives. -Mikey

In article <3700E871.3C59F723@KING.OF.MY.DOMAIN.Segel.com>, Mike Segel <mikey@KING.OF.MY.DOMAIN.Segel.com> wrote: > > > asobkows@my-dejanews.com wrote: > > > Hi, > > > > I need to perform a "scalability" comparison between the following databases: > > 1a) Sybase FMS V.11.0.3 on SUN UNIX 2.6 > > 1b) Sybase Cluster V.11.5.1 on SUN UNIX 2.6 > > 2) Oracle MLT V.2.2 on HP UNIX 7.3 > > 3) MS Access MAP on Win NT 4.0 Server > > 4) INFORMIX BillDats V.7.30.UC2 on SUN UNIX 2.6 > [CLIP] > Also HP-UX 7.3? Dude! I'd check your set up again. [CLIP] > Hmm, there has been some misformatting... in my brain, probably..:) The right parameters are as follows: Sybase 11.0.3 and 11.5.1 on SUN UNIX 2.6 Oracle 7.3.2.2 on HP UNIX MS Access 97 on Win NT 4.0 Server INFORMIX 7.30.UC2 on SUN UNIX 2.6 Sorry everybody. Andrej -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Ok First, Its not a fair comparison. You need to keep the hardware constant and compare the RDBMS, then compare the hardware and keep the DB constant. For example, you have a PC. You then have the issue of SCSI or EIDE drives. (Yes with the appropriate controllers, SCSI sings!) Then you need to compare similar versions of the products. For example the lates is Sybase 11.9.x agains the latest Informix. (7.3?) or Oracle (8i). The other issue is that you need to tune the engines correctly. Otherwise the comparrison is shit. -HTH Mikey asobkows@my-dejanews.com wrote: > > Sybase 11.0.3 and 11.5.1 on SUN UNIX 2.6 > Oracle 7.3.2.2 on HP UNIX > MS Access 97 on Win NT 4.0 Server > INFORMIX 7.30.UC2 on SUN UNIX 2.6 >

In article <37013A0B.2EF69CB6@KING.OF.MY.DOMAIN.Segel.com>, Mike Segel <mikey@KING.OF.MY.DOMAIN.Segel.com> wrote: > Ok > First, Its not a fair comparison. > > You need to keep the hardware constant and compare the RDBMS, > then compare the hardware and keep the DB constant. [CLIP] > Then you need to compare similar versions of the products. > For example the lates is Sybase 11.9.x agains the latest Informix. (7.3?) > or Oracle (8i). [CLIP] > Otherwise the comparrison is [CENSURE:)] I agree with you, the term "comparison" is incorrect. The point is that the four databases are currently in use in the described configurations (for totally different applications). I have to check how much they can be forced and extended. Most points are just technical characteristics, others are professional considerations (the quality of training or technical support is not related to a software version nor a hardware configuration), other may simply not be "compared". Thaks for pointing this out. Andrej -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own