Linux Today: Linux News On Internet Time.

LinuxPlanet: A Linux DBMS Comparison, Part II

Nov 18, 1999, 21:21 (8 Talkback[s])
(Other stories by Matthias Warkus)

[ Thanks to Kevin Reichard for this link. ]

"To test and compare three database management systems, I doubtlessly needed a database to manage with them. After having read SQL for Dummies, I had some basic knowledge of how realistic databases are designed, so I picked a particularly unimaginative real-world case (an Internet bookstore, what else?) and wrote up a little database design exploiting a couple of SQLs capabilities."

"There are five tables in this database. BOOK stores the available books with bookkeeping information; CUSTOMER contains the registered customers. For every order, a row in BOOKORDER is created, referencing the respective customer. For every item ordered, a row in ORDER_POSITION references the respective order. As a kind of bonus, I've added a RATING table for book ratings."

"The following is SQL code that can be fed into a DBMS's SQL monitor and should be accepted without any problem. All the tables are dropped before creation so the script won't bail out if some of them already exist."

Complete Story

Related Stories: