Database System Concepts 6th Edition by Abraham Silberschatz, Henry Korth, S Sudarshan ISBN 0073523321 9781260515046

Database System Concepts 6th Edition by Abraham Silberschatz, Henry Korth, S Sudarshan – Ebook PDF Instant Download/Delivery. 0073523321, 9781260515046
Full download Database System Concepts 6th Edition after payment

Product details:

ISBN 10: 0073523321 
ISBN 13: 9781260515046
Author: Abraham Silberschatz, Henry Korth, S Sudarshan

Database System Concepts by Silberschatz, Korth and Sudarshan is now in its 6th edition and is one of the cornerstone texts of database education. It presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible.

The text is designed for a first course in databases at the junior/senior undergraduate level or the first year graduate level. It also contains additional material that can be used as supplements or as introductory material for an advanced course. Because the authors present concepts as intuitive descriptions, a familiarity with basic data structures, computer organization, and a high-level programming language are the only prerequisites. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true.

Database System Concepts 6th Table of contents:

Part I: Introduction

1. Introduction to Databases
   • Database Systems and Applications
   • Data Models
   • Database Design
   • Query Languages
   • The Relational Model
   • Database Management Systems (DBMS) Overview
2. Database System Architecture
   • Components of a DBMS
   • DBMS Architecture and Data Independence
   • Centralized and Client-Server Architectures
   • Distributed Databases
   • Cloud Databases
   • Database Storage and File Structure

Part II: The Relational Model 3. The Relational Model

• Relational Model Concepts
• Relational Data Constraints
• Relational Query Languages
• The Relational Algebra
• The Relational Calculus
• SQL: A Relational Database Language

4. SQL: The Relational Query Language
   • Overview of SQL
   • Basic SQL Queries
   • Set Operations in SQL
   • Advanced SQL Queries
   • SQL for Data Definition and Integrity Constraints
   • Views, Indexes, and Transactions in SQL

Part III: Advanced Data Modeling 5. Entity-Relationship Model

• Entities and Attributes
• Relationships and Constraints
• Mapping ER Diagrams to Relational Schemas
• Enhanced Entity-Relationship (EER) Model

6. Relational Database Design
   • Informal Design Guidelines
   • Functional Dependencies and Normal Forms
   • Decomposition and Lossless Join
   • Boyce-Codd Normal Form (BCNF)
   • Multivalued Dependencies and 4NF
   • Join Dependencies and 5NF
   • Domain-Key Normal Form (DKNF)
   • Database Design and Redundancy

Part IV: Storage and Indexing 7. Storage and File Structures

• Data Storage Devices
• File Organization and Access Methods
• Indexing and Hashing
• B-Trees and B+-Trees
• Dynamic Hashing

8. Indexing and Hashing
   • Index Types and Structures
   • Multi-level Indexes
   • Bitmap Indexes
   • Hashing Techniques
   • Comparison of Indexing Methods

Part V: Query Processing and Optimization 9. Query Processing

• Query Parsing and Translation
• Query Optimization
• Join Algorithms
• Query Execution Plans
• Cost-Based Optimization
• Heuristic Query Optimization

10. Query Optimization

• Introduction to Query Optimization
• Transformation of Queries
• Estimating the Cost of Queries
• Dynamic Programming for Join Ordering
• Optimizing Select and Project Operations

Part VI: Transactions and Concurrency Control 11. Transactions

• Transaction Concept
• ACID Properties
• Transactions in DBMSs
• Transaction States
• Schedules and Serializability

12. Concurrency Control

• Locking Protocols
• Two-Phase Locking
• Timestamp Ordering
• Optimistic Concurrency Control
• Deadlock Detection and Prevention
• Multiversion Concurrency Control

13. Recovery System

• Introduction to Database Recovery
• Log-Based Recovery
• Shadow Paging
• ARIES Recovery Algorithm
• Recovery Techniques in Distributed Databases

Part VII: Advanced Topics 14. Distributed Databases

• Introduction to Distributed Databases
• Fragmentation, Replication, and Allocation
• Distributed Query Processing
• Distributed Transactions and Concurrency Control
• CAP Theorem
• NoSQL Databases

15. Data Warehousing and Data Mining

• Introduction to Data Warehousing
• Data Warehousing Architecture
• OLAP and OLTP
• Data Mining Concepts
• Association Rule Mining
• Classification and Clustering

16. Big Data and Cloud Databases

• Big Data Concepts and Technologies
• Cloud Computing and Databases
• Distributed File Systems and MapReduce
• NoSQL Databases in the Cloud
• NewSQL Databases
• Data Security and Privacy in Cloud Databases

Part VIII: Miscellaneous Topics 17. Database Security

• Security Issues in Database Systems
• Authentication and Authorization
• Encryption Techniques for Databases
• Auditing and Accountability
• Access Control Models

People also search for Database System Concepts 6th:

database system concepts
    
borrow database system concepts
    
database system concepts 7th edition github
    
database system concepts 7th edition solution to exercises
    
database system concepts answers