Database Management SystemsThis book, which gives comprehensive and up-to-date coverage of the fundamentals of database systems, has rapidly become one of the leading texts in the field owing to its coherent explanations and practical flavour. 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 emphasises database application development or one that stresses database systems issues. More applications and examples have been added throughout, including more SQL and more Oracle examples. There are also two new chapters on internet applications. The book is accompanied by an extensive website, including PowerPoints, solutions, additional Oracle exercises and minibase software. - Emphasis is on the physical aspects of databases, including a chapter entitled Physical Database Design and Tuning. - In-depth treatment of SQL. Not only does Ramakrishnan have an extensive chapter on SQL, but he also uses SQL throughout the book to demonstrate important concepts. - An overview chapter is provided at the beginning of each of the parts that cover systems. This allows the instructor the flexibili |
Contents
OVERVIEW OF DATABASE SYSTEMS | 3 |
Describing and Storing Data in a DBMS | 10 |
1 | 22 |
Copyright | |
31 other sections not shown
Other editions - View all
Common terms and phrases
abort aggregate algorithm answer application attributes B+ tree index BCNF block Boats bucket buffer pages candidate key catalog Chapter clause clustered column compute concurrency control consider contains cost create data entries data mining database design database systems Datalog DBMS decomposition defined deleted described discuss disk document Employees entity set evaluation example execution Exercise Extendible Hashing field fixpoint foreign key hash index IBM DB2 identify implementation input insert instance integer itemsets JDBC key value leaf lock log record manager multiset nested loops join node object OLAP operations partition primary key protocol query optimization relation schema relational algebra relationship set Reserves result retrieve rule S.rating S.sid Sailors scan search key Section serializable server shown in Figure sname sort-merge join sorted specified split SQL queries stored string Students transaction tuples unclustered update write