Database Processing

What an incredibly exciting time to be teaching and learning database technology. Personal databases continue rising in popularity; the Web demands more databases of greater size, complexity, and functionality; and traditional databases and applications continue to expand and grow. Meanwhile, new technologies such as XML and ADO.NET are seeing their first commercial use.

Because there is so much going on, I decided to make the ninth edition of Database Processing the biggest revision ever. In particular, the new edition includes the following:

• Two full chapters on E-R Modeling with a complete discussion of IDEF1X
• Expanded coverage of database design, including referential integrity actions
• Three full chapters on SQL
• A new chapter on database redesign
• Updated coverage of SQL Server and Oracle
• Expanded and modernized XML discussion
• Major new sections on ADO.NET and data set processing
• More than 30 pages of new exercises and problems

To keep the book (and course) from expanding unrealistically, something had to give. Consequently, I decided to reduce coverage of the semantic object model, and that topic moved to an appendix.

I think you will find the new three-chapter series on SQL to be particularly important. The first of these chapters introduces basic SQL DDL and DML statements. The second SQL chapter shows SQL in applications; and has extended coverage of SQL for views, stored procedures, and triggers. The third SQL chapter applies SQL for the redesign of databases, an activity that will likely be our students' first real database-design task.

The coverage of both Oracle and SQL Server is expanded in the new edition, and the discussion of XML was completely rewritten. The new XML material fits better with the use of XML in today's DBMS products. Finally, I have added a lengthy discussion of ADO.NET datasets. The combination of XML and datasets gives tremendous new utility to database applications, and I believe students who learn these technologies will be in very great demand in the immediate future.

In short, with all these new developments, this is a wonderful time to be teaching and learning database processing. The ninth edition is as modern and up-to-date as I know how to make it, and I hope you will find using it not only productive for students, but also enjoyable and fun for professors.

Contents

• Entity-Relationship Data Modeling: Tools and Techniques
• Entity-Relationship Data Modeling: Process and Examples

• The Relational Model and Normalization
• Database Design

• Introduction to Structured Query Language (SQL)
• Using SQL in Applications
• Database Redesign

• Managing Multi-User Databases
• Managing Databases with Oracle 9i
• Managing Databases with SQL Server 2000

• ODBC, OLE DB, ADO, and ASP
• XML and ADO.NET
• JDBC, Java Server Pages, and MySQL
• Sharing Enterprise Data

• Object-Oriented Database Processing