New in the Second Edition
Based on extensive user surveys and feedback, we have re ned the book's organization.
The major change is the early introduction of the ER model, together with a discussion
of conceptual database design. As in the rst edition, we introduce SQL-92's data
de nition features together with the relational model (in Chapter 3), and whenever
appropriate, relational model concepts (e.g., de nition of a relation, updates, views, ER
to relational mapping) are illustrated and discussed in the context of SQL. Of course,
we maintain a careful separation between the concepts and their SQL realization. The
material on data storage, le organization, and indexes has been moved back, and the material on relational queries has been moved forward. Nonetheless, the two parts(storage and organization vs. queries) can still be taught in either order based on theinstructor's preferences.In order to facilitate brief coverage in a rst course, the second edition contains overviewchapters on transaction processing and query optimization. Most chapters have beenrevised extensively, and additional explanations and gures have been added in manyplaces. For example, the chapters on query languages now contain a uniform numberingof all queries to facilitate comparisons of the same query (in algebra, calculus, andSQL), and the results of several queries are shown in gures. JDBC and ODBCcoverage has been added to the SQL query chapter and SQL:1999 features are discussedboth in this chapter and the chapter on object-relational databases. A discussion ofRAID has been added to Chapter 7. We have added a new database design case study,illustrating the entire design cycle, as an appendix.
for free download:Based on extensive user surveys and feedback, we have re ned the book's organization.
The major change is the early introduction of the ER model, together with a discussion
of conceptual database design. As in the rst edition, we introduce SQL-92's data
de nition features together with the relational model (in Chapter 3), and whenever
appropriate, relational model concepts (e.g., de nition of a relation, updates, views, ER
to relational mapping) are illustrated and discussed in the context of SQL. Of course,
we maintain a careful separation between the concepts and their SQL realization. The
material on data storage, le organization, and indexes has been moved back, and the material on relational queries has been moved forward. Nonetheless, the two parts(storage and organization vs. queries) can still be taught in either order based on theinstructor's preferences.In order to facilitate brief coverage in a rst course, the second edition contains overviewchapters on transaction processing and query optimization. Most chapters have beenrevised extensively, and additional explanations and gures have been added in manyplaces. For example, the chapters on query languages now contain a uniform numberingof all queries to facilitate comparisons of the same query (in algebra, calculus, andSQL), and the results of several queries are shown in gures. JDBC and ODBCcoverage has been added to the SQL query chapter and SQL:1999 features are discussedboth in this chapter and the chapter on object-relational databases. A discussion ofRAID has been added to Chapter 7. We have added a new database design case study,illustrating the entire design cycle, as an appendix.
0 comments:
Post a Comment