European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: General :: About Databases
By: leoahmad	Date: 06/09/2003 00:00:00	Points: 300	Status: Answered Quality : Excellent
Can someone explain briefly about all the databases which i have seen in this site (european experts-exchange) under databases node. I want to know their company name, owner of company, location of company, first production( version no and year it releases), latest production( version no and year it releases) type(relational or not) and remarks (their rating in the market on the basis of thier usage) It is just for the interest of mine in databases thanks.
By: VGR	Date: 07/09/2003 07:33:00		Type : Comment
All are relationnal or claim so MS Access > Merdu$oft, redmond USA,?,?,supposedly relationnal, very poor Berkeley DB > Berkeley university, USA Crystal Reports > explicit FoxPro > I forgot IBM UDB > IBM, USA, dies Interbase > Borland, USA, inexpensive, versatile Microsoft SQL> Merdu$oft, redmond USA,?,?,supposedly relationnal, poor (better than Access), crushed by MySql on stability & speed Mysql > MySql AB, Sweden(?),1998,2003_4.1, very good (very SQL compliant), inexpensive, proved as robust as Oracle up to 1000 concurrent users Oracle > explicit, supposedly good (not standard SQL compliant) but expensive and proved robust if you pay the $$$ Sybase > explicit Btrieve > explicit FileMaker > I forgot

By: arbert	Date: 07/09/2003 07:56:00		Type : Comment
VGR, some of your comments above are opinion and should have been noted. Microsoft SQL "supposedly relationnal" , "poor", crushed by MySQL??? Give me a break--MySQL isn't even ANSI standard on most operations.... Crystal Reports? This isn't a database--end user reporting package..... FoxPro--Microsoft. Database similar to access....

By: leoahmad	Date: 07/09/2003 11:47:00		Type : Comment
VGR what you mean by explicit in your comments also for your oracle comment please explain "not standard SQL compliant" and "proved robust if you pay the $$$ " Can some one post some link to origin of these databases like for oracle ==> <A HREF="http://www.oracle.com">www.oracle.com</a> LeoAhmad

By: sachiek	Date: 07/09/2003 16:55:00		Type : Assist
MS Access > URL : <A HREF="http://office.microsoft.com/home/office.aspx?assetid=FX01085791&CTT=6&Origin=ES790020011033">http://office.microsoft.com/home/office.aspx?assetid=FX01085791&CTT=6&Origin=ES790020011033</a> Latest Version : 2002. Berkeley DB > URL : <A HREF="http://www.sleepycat.com/">http://www.sleepycat.com/</a> Latest Version :Version 4.1.25 (stable) Crystal Reports > URL : <A HREF="http://www.crystaldecisions.com/">http://www.crystaldecisions.com/</a> First : Crystal report 1.0 Latest : Crystal reports 9.0 FoxPro > URL : <A HREF="http://www.foxprohistory.org/">http://www.foxprohistory.org/</a> (This gives you more details about foxpro progress). Foxpro is now Visual Foxpro. <A HREF="http://www.vfug.org/">http://www.vfug.org/</a> <A HREF="http://msdn.microsoft.com/vfoxpro/">http://msdn.microsoft.com/vfoxpro/</a> (Visual Foxpro home site) <A HREF="http://www.jjtc.com/Fox/">http://www.jjtc.com/Fox/</a> <A HREF="http://foxproadvisor.com/">http://foxproadvisor.com/</a> IBM UDB > <A HREF="http://www-3.ibm.com/software/data/db2/udb/">http://www-3.ibm.com/software/data/db2/udb/</a> <A HREF="http://www-3.ibm.com/software/data/database/">http://www-3.ibm.com/software/data/database/</a> Latest Version : 8.1 Interbase > <A HREF="http://www.borland.com/interbase/">http://www.borland.com/interbase/</a> Latest Version: 7.1 Microsoft SQL> URL : <A HREF="http://www.microsoft.com/sql/">http://www.microsoft.com/sql/</a> First V : Ms-SQL 3.0 Latest V : MS-SQL 2000 sp3 Mysql > <A HREF="http://www.mysql.com/">http://www.mysql.com/</a> Latest Version : 4.1 Oracle > Url : <A HREF="http://www.oracle.com">www.oracle.com</a> First : Oracle 1.0 Latest : Oracele 11x Sybase > Url : <A HREF="http://www.sybase.com/products/databaseservers">http://www.sybase.com/products/databaseservers</a> (Acutally Microsoft-SQL server was started by buying sybase architucture.) Now it is slowly building up. Btrieve > URL :<A HREF="http://www.pervasive.com/support/where_btrieve.asp">http://www.pervasive.com/support/where_btrieve.asp</a> Latest Version : <A HREF="http://www.pervasive.com/support/builds.asp">http://www.pervasive.com/support/builds.asp</a> More intresting site : <A HREF="http://www.databasepros.com/">http://www.databasepros.com/</a> <A HREF="http://filemakeradvisor.com/">http://filemakeradvisor.com/</a> FileMaker > Url : <A HREF="http://www.filemaker.com/">http://www.filemaker.com/</a> Latest Version : <A HREF="http://www.filemaker.com/products/index.html">http://www.filemaker.com/products/index.html</a> Thanks, Sachi

By: leoahmad	Date: 08/09/2003 19:57:00		Type : Comment
Sachi that's very helpful for me thanks but wait for the points. Leo

By: VGR	Date: 09/09/2003 17:42:00		Type : Answer
@arbert : answering "remarks (their rating in the market on the basis of thier usage)" without expressing an opinion is rather difficult :D for SQL-Server being crushed and MySql being on par with Oracle under the load : <A HREF="http://www.eweek.com/article2/0,3959,293,00.asp">http://www.eweek.com/article2/0,3959,293,00.asp</a> "We tested IBM's DB2 7.2 with FixPack 5, Microsoft Corp.'s SQL Server 2000 Enterprise Edition with Service Pack 2, MySQL AB's MySQL 4.0.1 Max, Oracle Corp.'s Oracle9i Enterprise Edition 9.0.1.1.1 and Sybase Inc.'s ASE (Adaptive Server Enterprise) 12.5.0.1. Overall, Oracle9i and MySQL had the best performance and scalability (see charts, images 1 and 2 in slideshow), with Oracle9i just very slightly ahead of MySQL for most of the run. ASE, DB2, Oracle9i and MySQL finished in a dead heat up to about 550 Web users. At this point, ASE's performance leveled off at 500 pages per second, about 100 pages per second less than Oracle9i's and MySQL's leveling-off point of about 600 pages per second. DB2's performance dropped substantially, leveling off at 200 pages per second under high loads. Due to its significant JDBC (Java Database Connectivity) driver problems, SQL Server was limited to about 200 pages per second for the entire test. " <A HREF="http://common.ziffdavisinternet.com/util_get_image/0/0,3363,sz=1&i=9898,00.jpg">http://common.ziffdavisinternet.com/util_get_image/0/0,3363,sz=1&i=9898,00.jpg</a> <A HREF="http://common.ziffdavisinternet.com/util_get_image/0/0,3363,sz=1&i=9899,00.jpg">http://common.ziffdavisinternet.com/util_get_image/0/0,3363,sz=1&i=9899,00.jpg</a>

By: arbert	Date: 09/09/2003 18:21:00		Type : Comment
Oh, is that how it is--I can post links too--SQL Server has had the highest TPC figures for quite some time--all depends on what you're looking at. I sure would judge a databases performance on JDBC tests... <A HREF="http://www.tpc.org/tpcc/results/tpcc_perf_results.asp">http://www.tpc.org/tpcc/results/tpcc_perf_results.asp</a>

By: VGR	Date: 09/09/2003 18:24:00		Type : Comment
me neither, but at least the platform was the same for all :D MySql too isn't very happy with a JDBC layer in between :D

By: arbert	Date: 09/09/2003 18:28:00		Type : Comment
lol

By: VGR	Date: 21/07/2005 20:52:14		Type : Comment
Your opinion is something you'd probably want to reconsider now ;-)) 2004 TPC results LOL

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 336.287020 milliseconds

Why Google AdSense ads ?

New Improved Search!