Fundamental of Database Management System

Description

by Navathe

Database Management Systems, known for its practical emphasis 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 hands on approach introduces students to current standards, including JDBC, XML and 3-tier application architectures.

Salient Features:

• A new, flexible organization allows instructors to teach either an applications oriented course or anintroductory 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.
• NEW Material on Database Applications

Table of Content:

Part – I: Foundations

• Overview of Database Systems
• Introduction to Database Design
• The Relational Model
• Relational Algebra and Calculus
• SQL: Queries, Constraints, Triggers

Part – II: Application Development

• Database Application Development
• Internet Applications

Part – III: Storage and Indexing

• Overview of Storage and Indexing
• Storing Data: Disks and Files
• Tree-Structured Indexing
• Hash-Based Indexing

Part – IV: Query Evaluation

• Overview of Query Evaluation
• External Sorting
• Evaluating Relational Operators
• A Typical Relational Query Optimizer

Part – V: Transaction Management

• Overview of Transaction Management
• Concurrency Control
• Crash Recovery

Part – VI: Database Design and Tuning

• Schema Refinement and Normal Forms
• Physical Database Design and Tuning
• Security and Authorization

Part – VII: Additional Topics

• Parallel and Distributed Databases
• Object-Database Systems
• Deductive Databases
• Data Warehousing and Decision Support
• Data Mining
• Information Retrieval and XML Data
• Spatial Data Management
• Further Reading
• The Minibase Softwar