I am teaching our upper-level course on databases
this fall for the first time in some years. Here's
what I'd like to include:

Representation
-Hashing
* Basic concept
* Collision
* Insert/Delete
* Security
* Record Locking
* Concurrent operations
* Network implementation
* Encryption

- B-Tree and relatives thereof
* same as the above

Verification and Validation

Field and Record Locking

Virtual Fields

And, of course, queries

Much of this I can get from Mr. Google,
but is there a common book/place/archive?

(I worked on the implementation of Magnum,
and early relational data base system. By having
some knowledge of the internals I think that
I have a better grasp of such things)

Oh, and is there a favorite, affordable off-the-shelf
database system that would help in this?

Thanks in advance
john slimick
slimick (AT) pitt (DOT) edu

In article <slrnhvr3cg.5jh.slimick (AT) cameron (DOT) upb.pitt.edu>,
John Slimick <slimick (AT) cameron (DOT) upb.pitt.edu> wrote:

I've found H2 Database Engine particularly portable in a mixed
environment: it has a convenient web interface, and the Java sources are
fairly readable.

<http://www.h2database.com/html/main.html>

--
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>

On Wed, 26 May 2010, John Slimick wrote:

PostgreSQL is probably the most capable and mature free and open-source
database. I have no idea what the readability of the code is like, though.
Firebird may also be worth a look - it's an open-sourced Interbase.

As John mentions, H2 may also be useful. It's far simpler than a 'real'
database' like either of the two i suggest, which may make it more
didactically useful - or less. And it's written in java rather than C,
which will certainly make it easier to understand.

tom

--
As Emiliano Zapata supposedly said, "Better to die on your feet than
live on your knees." And years after he died, Marlon Brando played him
in a movie. So just think, if you unionize, Marlon Brando might play
YOU in a movie. Even though he's dead. -- ChrisV82