Linux Today: Linux News On Internet Time.

LinuxPlanet: Apples and Oranges: A Linux DBMS Comparison, Part I

Nov 11, 1999, 16:10 (5 Talkback[s])
(Other stories by Matthias Warkus)

[ Thanks to Kevin Reichard for this link. ]

"The database managers compared here are free or cheap to license, and they run on all levels of Linux systems, from the lowest-end hardware to high-end multiple-CPU servers. And they are widely used in production systems all over the world. For this comparison, I put myself in the situation of someone running typical Linux boxes, powering an everyday DBMS...."

"I'll begin with a discussion of the installation and configuration of these three database systems; then I'll proceed, in Part II, with the design of a small database in SQL, pointing out the difficulties and differences I encountered trying to make the DBMS swallow it. I'll also explain the coding of a program that will perform various real-life actions on the database, such as adding data and generating reports, while discussing the various differences of the databases in the process. This client will be implemented in C for all three DBMSes. To do this, I must learn not only the SQL APIs of all the systems, but SQL, too. If nothing else, this will surely be fun to watch."

"Part III will contain some actual benchmarks, as a bonus. I have had the dubious pleasure of watching endless debates about database benchmarking on Linux newsgroups, so I will only time the performance of the client doing random stuff, both when done in one run under ideal conditions and when done via several concurrent processes. At that time I'll have already covered lots of differences between the DBMSes, so you should have a good idea of their strengths and weaknesses."

Complete Story

Related Stories: