Database Management Systems, 3rd Edition
Raghu Ramakrishnan, Johannes Gehrke
Format: PDF / Kindle (mobi) / ePub
Database Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field. The third edition continues in this tradition, enhancing it with more practical material.
The new edition has been reorganized to allow more flexibility in the way the course is taught. Now, instructors can easily choose whether they would like to teach a course which emphasizes database application development or a course that emphasizes database systems issues. New overview chapters at the beginning of parts make it possible to skip other chapters in the part if you don't want the detail.
More applications and examples have been added throughout the book, including SQL and Oracle examples. The applied flavor is further enhanced by the two new database applications chapters.
system crcLShes just after making the change in the datab(Lse but before the change is recorded in the log, the DBIVIS would be unable to detect and undo this change. This property is called Write-Ahead Log, or WAL. To ensure Overview of Database By.stems 19 this property, the DBMS must be able to selectively force a page in memory to disk. The log is also used to ensure that the changes made by a successfully completed transaction are not lost due to a system crash, as explained in Chapter
13.6 1:3.5.2 Unclustered Index Review Questions 14 EVALUATING RELATIONAL OPERATORS 14.1 14.2 The' Selection Operation 428 430 430 432 4:33 433 434 436 439 441 14.1.1 No Index, Unsorted Data 441 14.1.2 No Index, Sorted Data 442 14.1.:3 B+ Tree Index 14.1.4 Hash Index, Equality Selection 442 General Selection Conditions 444 444 DATABASE ~11ANAGEMENT SYSTEMS XIV 14.2.1 CNF and Index Matching 14.2.2 Evaluating Selections without Disjunction 14.2.3 Selections with Disjunction 14.3
Students, consider the instance of Enrolled shown in Figure 3.4. Deletions of Enrolled tuples do not violate referential integrity, but insertions of Enrolled tuples could. The following insertion is illegal because there is no Students tuple with sid 51111: INSERT INTO Enrolled (cid, grade, studid) VALUES ('Hindi101', 'B', 51111) On the other hand, insertions of Students tuples do not violate referential integrity, and deletions of Students tuples could cause violations. Further, updates on
Some ancillaries, including electronic and print components, may not be available to customers outside the United States. 10 09 08 07 06 05 04 03 20 09 08 07 06 05 04 CTF BJE Library of Congress Cataloging-in-Publication Data Ramakrishnan, Raghu Database management systems / Raghu Ramakrishnan, Johannes p. Gehrke.~3rd cm. Includes index. ISBN 0-07-246563-8-ISBN 0-07-115110-9 (ISE) 1. Database management. 1. Gehrke, Johannes. II. Title. QA76.9.D3 R237 2003 005.74--Dc21 When ordering this
from-list. Because the only relation in the from-list in Query Q32 is Sailors, the result is just the instance shown in Figure 5.10. 22 29 31 32 58 64 71 74 85 95 96 Dustin Brutus Lubber Andy Rusty Horatio Zorba Horatio Art Bob Frodo Figure 5.10 7 1 8 8 10 7 10 9 3 3 3 45.0 33.0 55.5 25.5 35.0 35.0 16.0 35.0 25.5 63.5 25.5 Instance 53 of Sailors The second step is to apply the qualification in the WHERE clause, S. age >= 18. This step eliminates the row (71, zorba, 10, 16). The third