Database management systems By Raghu Ramakrishnan, Johannes Gehrke [McGraw-Hill] pdf ebook free download

E-Book Details:

Title:	Database management systems
Publisher:	McGraw-Hill
Author:	Raghu Ramakrishnan, Johannes Gehrke
Edition:	3rd, illustrated
Format:	PDF
ISBN:	0072465638
EAN:	9780072465631
No.ofPages:	1065

Book Description:

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.

ABOUT THE AUTHOR:

Ramakrishnan is Professor of Computer Science at the University of Wisconsin, Madison, and a founder and CTO of QUIO. He is a Fellow of the ACM.

Minos Garofalakis is a Member of Technical Staff at the Internet Management Research Department of Bell Labs, Lucent Technologies. He received his BSc in 1992 from the Computer Engineering and Informatics Dept. of the University of Patras (UOPCEID). He also spent the following year at UOPCEID as a post-graduate fellow. In the Fall of 1993, he joined the graduate program in Computer Sciences at the University of Wisconsin-Madison, where he received his MSc (1994) and PhD (1998). He joined Bell Labs in Murray Hill, NJ, in September 1998.

Johannes Gehrke is an Assistant Professor in the Department of Computer Science at Cornell University. He joined Cornell after completing his PhD at the University of Wisconsin-Madison in 1999.

Johannes' research lies in the areas of data mining, database systems, and ubiquitous computing. The recipient of an Alfred P. Sloan Fellowship, a National Science Foundation Career Award, an IBM Faculty Award, and the Cornell College of Engineering James and Mary Tien Excellence in Teaching Award, Johannes is the author of numerous publications on data mining and database systems. Johannes isthe co-author of the textbook Database Management Systems'' (current in its third edition), published by McGrawHill in 2002, which is used at universities all over the world.

Table of Contents:
UNIT – I

Data base System Applications, data base System VS file System – View of Data – Data Abstraction –

Instances and Schemas – data Models – the ER Model – Relational Model – Other Models – Database

Languages – DDL – DML – database Access for applications Programs – data base Users and Administrator

– Transaction Management – data base System Structure – Storage Manager – the Query Processor –

History of Data base Systems.Data base design and ER diagrams – Beyond ER Design Entities, Attributes

and Entity sets – Relationships and Relationship sets – Additional features of ER Model – Concept Design with the ER Model – Conceptual Design for Large enterprises.

UNIT – II

Relational Model: Introduction to the Relational Model – Integrity Constraint Over relations – Enforcing Integrity constraints – Querying relational data – Logical data base Design – Introduction to Views – Destroying/altering Tables and Views. Relational Algebra and Calculus: Relational Algebra – Selection and projection set operations – renaming – Joins – Division – Examples of Algebra overviews – Relational calculus – Tuple relational Calculus – Domain relational calculus – Expressive Power of Algebra and calculus.

UNIT – III

Form of Basic SQL Query – Examples of Basic SQL Queries – Introduction to Nested Queries – Correlated

Nested Queries Set – Comparison Operators – Aggregative Operators – NULL values – Comparison using

Null values – Logical connectivity’s – AND, OR and NOTR – Impact on SQL Constructs – Outer Joins –

Disallowing NULL values – Complex Integrity Constraints in SQL 0 Triggers and Active Data bases.

UNIT – IV

Schema refinement – Problems Caused by redundancy – Decompositions – Problem related to decomposition– reasoning about FDS – FIRST, SECOND, THIRD Normal forms – BCNF – Lossless join Decomposition –Dependency preserving Decomposition – Schema refinement in Data base Design – Multi valued Dependencies – forth Normal Form.

UNIT – V

Overview of Transaction Management: ACID Properties – Transactions and Schedules – Concurrent

Execution of transaction – Lock Based Concurrency Control – Performance Locking – Transaction Support in

SQL – Introduction to Crash recovery.

UNIT – VI

Concurrency Control: Serializability, and recoverability – Introduction to Lock Management – Lock Conversions– Dealing with Dead Locks – Specialized Locking Techniques – Concurrency without Locking. Crash recovery: Introduction to ARIES – the Log – Other Recovery related Structures – the Write-Ahead Log Protocol– Check pointing – re3covering from a System Crash – Media recovery – Other approaches and Interaction with Concurrency control.

UNIT – VII

Overview of Storage and Indexing: Data on External Storage – File Organization and Indexing – Cluster

Indexes, Primary and Secondary Indexes – Index data Structures – Hash Based Indexing – Tree base

Indexing – Comparison of File Organizations – Indexes and Performance Tuning.

UNIT – VIII

Storing data: Disks and Files : - The Memory Hierarchy – Redundant Arrays of Independent – Disks – Disk

Space Management – Buffer Manager – Files of records – Page Formats – record formats. Tree Structured

Indexing: Intuitions for tree Indexes – Indexed Sequential Access Methods (ISAM) – B+ Trees: A Dynamic

Index Structure. Hash Based Indexing: Static Hashing – Extendable hashing – Linear Hashing – Exendble vs.

Liner hashing.

Download