Database Management Systems, Third Edition

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. Foundations -- Overview Of Database Systems -- Managing Data -- File Systems Versus A Dbms -- Queries In A Dbms -- Transaction Management -- Introduction To Database Design -- Database Design And Er Diagrams -- Entities, Attributes, And Entity Sets -- Relationships And Relationship Sets -- Relational Model -- Relational Algebra And Calculus -- Sql: Queries, Constraints And Triggers -- Application Development -- Database Application Development -- Internet Applications -- Storage And Indexing -- Storing Data: Disks And Files -- Tree-structured Indexing -- Hash-based Indexing -- Query Evaluation -- External Sorting -- Evaluating Relational Operators -- Typical Realtinal Query Optimizer -- Overview Of Transaction Management -- Concurrency Control -- Crash Recovery -- Database Design And Tuning -- Schema Refinement And Normal Forms -- Physical Database Design And Tuning -- Security And Authorization. Parallel And Distributed Databases -- Object-database Systems -- Deductive Databases -- Data Mining -- Information Retrieval And Xml Data -- Spatial Data Management -- Minibase Software. Raghu Ramakrishnan, Johannes Gehrke. Includes Bibliographical References (p. 1005-1044) And Indexes. Database Management Systems, known for its practical emphsis and comprehensive coverage, has quickly become one of the leading texts for database courses. The third edition features new material on database application development, with a focus on Internet applications. The handson approach introduces students to current standards, including JDBC, XML, and 3-tier application architectures. A new, flexible organization allows instructors to teach either an applications-oriented course or an introductory systems-oriented course. The revised "part" organization with new overview chapters makes it easy to select the chapters you need; in-depth chapters within each part can be optional.This very current new edition also features pedagogical improvements (e.g., chapter objectives, review questions) and updated and extended discussions of data mining, database tuning wizards, decision support, information retrieval, Internet security, object-oriented databases, transaction processing, and XML data management. The coverage has been revised and expanded throughout to reflect the new SQL: 1999 standard. Designed for an introductory database course, this text emphasises conceptual and physical database design and tuning. It also covers advanced topics that may be useful for further study The amount of information available to us is literally exploding, and the value of data as an organizational asset is widely recognized.