Looking for performance and features of databases
A poster asked for comparative references on RDBMS/OODBMS products for a real-time, performance-critical project needing data replication. Replies were opinion-based rather than pointing to any study: suggestions included InterSystems Caché, Pick/UniVerse, Empress, Sybase SQL Anywhere or Faircom on QNX, plus a warning against MS SQL Server backed only by one anonymous, unpublished benchmark (DB2 fastest, Oracle 12x slower, MS SQL 24x). Others noted vendors all claim superiority and that the products aren't comparable, urging the poster to narrow requirements by OS/hardware and needed features. No authoritative comparison or firm recommendation was agreed on.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, We need a database for our real-time critical project. The primary requirements of the database are performance and support for replication of data. Can anybody give some references to sites/documets that give a comparative analysis of different RDBMSs or OODBMs available in the market ? Regards Naveen Dowlat preethi@cyberramp.net
Naveen, Get yourself a good programmer in C. I like relational Francois In article <368FEDDA.985CD1E9@cyberramp.net>, preethi@cyberramp.net says... > >Hello, > >We need a database for our real-time critical project. The primary >requirements of the database are performance and support for replication >of data. Can anybody give some references to sites/documets that give a >comparative analysis of different RDBMSs or OODBMs available in the >market ? > >Regards > >Naveen Dowlat >preethi@cyberramp.net >
Naveen, I can't give you a reference to a site that compares different databases, but maybe you should have a look at the InterSystems Cach' database it is a post-relational oodbms that is one of the fastest I have ever seen and gives you unprecedented replication posibilities (record level, multi replication, read/write through) completely transparent to the users/developers. For further info: www.intersys.com Herman Slagman Manager R&D COD International http: www.CODgroep.nl mailto: H.Slagman@CODGroep.nl Naveen Dowlat wrote in message <368FEDDA.985CD1E9@cyberramp.net>... >Hello, > >We need a database for our real-time critical project. The primary >requirements of the database are performance and support for replication >of data. Can anybody give some references to sites/documets that give a >comparative analysis of different RDBMSs or OODBMs available in the >market ? > >Regards > >Naveen Dowlat >preethi@cyberramp.net >
On Sun, 03 Jan 1999 16:23:23 -0600, Naveen Dowlat <preethi@cyberramp.net> wrote: >We need a database for our real-time critical project. The primary >requirements of the database are performance and support for replication >of data. Can anybody give some references to sites/documets that give a >comparative analysis of different RDBMSs or OODBMs available in the >market ? Any vendor is going to say that their product is, in the round, superior to all others. As for comparisons, various RDBMS, OODBMS not to mention PRDBMS are all so different from each other that it's unlikely that you'll ever be comparing apples with apples. Maybe you need to narrow your choice down by deciding on specific functionality that you need, what OS and hardware you want to run on etc. Personally I'd go with Pick or UniVerse - the multi-dimensional data model makes a lot of sense and is very flexible.
DONT USE MS SQLSERVER Naveen Dowlat <preethi@cyberramp.net> schreef in artikel <368FEDDA.985CD1E9@cyberramp.net>... > Hello, > > We need a database for our real-time critical project. The primary > requirements of the database are performance and support for replication > of data. Can anybody give some references to sites/documets that give a > comparative analysis of different RDBMSs or OODBMs available in the > market ? > > Regards > > Naveen Dowlat > preethi@cyberramp.net > >
On 7 Jan 1999 16:42:30 GMT, "Jacco van der Pol" <qimsgoes@worldonline.nl> wrote: >DONT USE MS SQLSERVER > Care to elaborate a little more on that, Jacco? Enquiring minds and all that. DCraig.
dcraig@rain.org wrote: -On 7 Jan 1999 16:42:30 GMT, "Jacco van der Pol" -<qimsgoes@worldonline.nl> wrote: - ->DONT USE MS SQLSERVER -> - -Care to elaborate a little more on that, Jacco? - -Enquiring minds and all that. - -DCraig. Performance, pure and simple ! For competency tests of our chained logic table technology, the following results were obtained on identical platforms: RDBMS Vendor 12/98 Units of time - - - - - - - - - - - - - - - - - - IBM DB2 5.2 1 Personal ORACLE 7.2.x 12 MS SQL Server 7.0 24 That makes DB2 12-times faster than ORACLE and 24-times faster than MS; it also makes ORACLE 2-times faster than MS. So Larry Ellison's vapor-bet for $1 MM that ORACLE is 100-times faster than MS loses in our book. No object database, such as Objectivity or Versant, was tested because they use the lame Dharma SQL engine which barfs on SQL triggers because they have to be translated into some other non portable language such as C.
On Fri, 08 Jan 1999 07:42:02 GMT, anonymous@comp.databases.object wrote: Thanks. Are the test and/or results published anywhere? DCraig. >dcraig@rain.org wrote: > >-On 7 Jan 1999 16:42:30 GMT, "Jacco van der Pol" >-<qimsgoes@worldonline.nl> wrote: >- >->DONT USE MS SQLSERVER >-> >- >-Care to elaborate a little more on that, Jacco? >- >-Enquiring minds and all that. >- >-DCraig. > >Performance, pure and simple ! > >For competency tests of our chained logic table technology, >the following results were obtained on identical platforms: > >RDBMS Vendor 12/98 Units of time >- - - - - - - - - - - - - - - - - - >IBM DB2 5.2 1 >Personal ORACLE 7.2.x 12 >MS SQL Server 7.0 24 > >That makes DB2 12-times faster than ORACLE and 24-times faster >than MS; it also makes ORACLE 2-times faster than MS. > >So Larry Ellison's vapor-bet for $1 MM that ORACLE is 100-times >faster than MS loses in our book. > >No object database, such as Objectivity or Versant, was tested >because they use the lame Dharma SQL engine which barfs on SQL >triggers because they have to be translated into some other >non portable language such as C.
For a realtime DBMS you also need a realtime platform to run it on... Try Empress, Sybase SQL Anywhere (formerly Watcom SQL), or Faircom SQL Server on QNX. Any of these will work just fine. Each has their own advantages. Faircom's product has (optionally) source code available if that is a requirement. -Bill Boyle Naveen Dowlat wrote: > > Hello, > > We need a database for our real-time critical project. The primary > requirements of the database are performance and support for replication > of data. Can anybody give some references to sites/documets that give a > comparative analysis of different RDBMSs or OODBMs available in the > market ? > > Regards > > Naveen Dowlat > preethi@cyberramp.net