Christopher B. Browne's Home Page
cbbrowne@acm.org

RDBMS - Relational Database Management Systems

Christopher Browne


Table of Contents
1. Other RDBMS Web Resources for Linux
2. Database Classifications
3. SQL Databases
4. SQL Database Tools
5. xBase Databases
6. Other Linux Databases
7. The Third Manifesto
8. Other Database Stuff - Database Design

This page is devoted to information about relational database systems, primarily dealing with those database systems available under Linux.

I also have material on "nonrelational systems," which are often extremely useful when there is a need to embed a data access system within an application.

Caution

This material may prove useful to you in better understanding the nature of relational databases. If you have further questions relating to academic course work, do not contact me. I am not operating a "homework service", or even a "consulting service" in this area, not even if you are offering to pay consulting rates, which, for short term work, would tend to be on the order of $100 per hour. Note that for the price you'd need to pay to acquire a couple hours of my time, you can probably purchase some of the books mentioned below...

If you have need of additional material to help with course assignments, consider the following options before contacting me:

If you have not yet exhausted those three sources of course assistance, you should not contact me. But even if you have exhausted those sources, there are no guarantees that I will attempt to be of assistance. I will emphatically not be providing customized assignment solutions.

When you are considering which database you might wish to use, it would be worth looking at the essay Finding Technology Solutions. It represents a discussion of how to search for technology solutions, and starts with a simple premise: " Don't assume a solution until you have determined what problem you need to solve."

It is also interesting to note that SQL is not synonymous with " relational databases." Consider the following:

 

Just like ODBMS are often database construction kits or persistence libraries, SQL DBMSes are a real DBMS (they do provide transactions, recovery, concurrency control, some data integrity) + a relational construction kit. Meaning that by a skillful use of SQL one can come somewhere close to a relational database.

But the complexity is left on the user to shoulder, and it is very difficult to stretch SQL so that you are still in the realm of relational model. And guess what: most users don't and most users suffer as a consequence.

 
-- Costin Cozianu 

Some databases are little more than a light layer of syntactic frosting on top of a flat file storage system. For instance, an xBase system is a set of flat files, with a thin veneer of "database language" put on top, almost surely not deserving of the "relational" moniker, even when they get some SQL-like query language. Some databases with SQL in their names are hardly relational in nature.

1. Other RDBMS Web Resources for Linux

Other web pages with some fairly decent descriptions of Linux-based DBMSes include:

Does this duplication of effort seem unfortunate to you? It does to me...

I also have a web page that discusses text databases, one that discusses nonrelational databases, and one that discusses spreadsheets, all of which represent contrasting views and approaches to data management.

Google

If this was useful, let others know by an Affero rating

Contact me at cbbrowne@acm.org