Database Systems: The Complete Book.
This work combines the two books FCDB and DBSI, with all
the updates and improvements described below.
Here are its Table of Contents and its
Home Page.
A First Course in Database Systems, 2nd Edition.
This work is identical to the first 10 chapters of DS:CB.
Its Home Page is the same as for the first
edition.
We separated object-oriented design from E/R design. Now we lead off
with E/R and cover ODL in a separate chapter. We thought the idea that
all these design notations were really small variations on a theme was
important, but it seemed to confuse too many people. We hope the new
arrangement will serve better.
We added considerable material on the object-relational model, both as
an abstraction analogous to the relational model and the new SQL-99
standard for O-R features.
The extended relational algebra from DBSI that is needed for a
discussion of query optimization has been combined with the
``classical'' relational algebra covered in the first edition of FCDB.
The result is that many more features of SQL can be explained in terms
of specific relational-algebra operations than before.
We added a discussion of SQL/PSM (persistent stored modules), which is
the procedural language of which Oracle's PL/SQL is the archetype.
We introduce the new interfaces between SQL and modern host languages:
JDBC and SQL/CLI (ODBC).
A number of other SQL features have been updated to conform to the
SQL-99 standard.
There is a new discussion of the interaction between transaction
scheduling and recovery that covers additional options.
We added material on capability-based optimization for
information-integration systems to complement and contrast with the
cost-based optimization that is usually used in a conventional DBMS.
