کتاب مفاهیم سیستم‌های پایگاه داده نوشته سیلبرشاتز، کورت و سودارشان در ویرایش ششم خود، یکی از متون اصلی در آموزش پایگاه داده‌ها است. این کتاب مفاهیم اساسی مدیریت پایگاه داده‌ها را به‌طور شهودی ارائه می‌دهد و هدف آن این است که به دانشجویان کمک کند تا هرچه سریع‌تر بتوانند با پایگاه‌های داده کار کنند. این متن برای یک دوره ابتدایی در پایگاه داده‌ها در سطح دانشجویان سال سوم/چهارم کارشناسی یا سال اول تحصیلات تکمیلی طراحی شده است. همچنین، این کتاب شامل مطالب اضافی است که می‌توان از آن‌ها به‌عنوان مکمل‌ها یا مطالب مقدماتی برای یک دوره پیشرفته استفاده کرد. زیرا نویسندگان مفاهیم را به‌طور شهودی شرح می‌دهند، تنها پیش‌نیازهای آن آشنایی با ساختارهای داده پایه، سازمان‌دهی کامپیوتر و زبان‌های برنامه‌نویسی سطح بالا است. نتایج نظری مهم در کتاب پوشش داده شده است، اما اثبات‌های رسمی حذف شده‌اند. به جای اثبات‌ها، از شکل‌ها و مثال‌ها برای نشان دادن دلایل صحت یک نتیجه استفاده شده است.

فهرست مطالب

فصل 1 مقدمه

بخش اول: زبان‌های رابطه‌ای

فصل 2 معرفی مدل رابطه‌ای

فصل 3 معرفی SQL

فصل 4 SQL سطح میانه

فصل 5 SQL پیشرفته

بخش دوم: طراحی پایگاه داده

فصل 6 طراحی پایگاه داده با استفاده از مدل E-R

فصل 7 طراحی پایگاه داده رابطه‌ای

بخش سوم: طراحی و توسعه اپلیکیشن

فصل 8 انواع داده پیچیده

فصل 9 توسعه اپلیکیشن

بخش چهارم: تجزیه و تحلیل داده‌های بزرگ

فصل 10 داده‌های بزرگ

فصل 11 تجزیه و تحلیل داده‌ها

بخش پنجم: مدیریت ذخیره‌سازی و ایندکس‌گذاری

فصل 12 سیستم‌های ذخیره‌سازی فیزیکی

فصل 13 ساختارهای ذخیره‌سازی داده‌ها

فصل 14 ایندکس‌گذاری

بخش ششم: پردازش و بهینه‌سازی پرس‌و‌جو

فصل 15 پردازش پرس‌و‌جو

فصل 16 بهینه‌سازی پرس‌و‌جو

بخش هفتم: مدیریت تراکنش‌ها

فصل 17 تراکنش‌ها

فصل 18 کنترل همزمانی

فصل 19 سیستم بازیابی

بخش هشتم: پایگاه‌های داده موازی و توزیع‌شده

فصل 20 معماری‌های سیستم پایگاه داده

فصل 21 ذخیره‌سازی موازی و توزیع‌شده

فصل 22 پردازش پرس‌و‌جوهای موازی و توزیع‌شده

فصل 23 پردازش تراکنش‌های موازی و توزیع‌شده

بخش نهم: مباحث پیشرفته

فصل 24 تکنیک‌های پیشرفته ایندکس‌گذاری

فصل 25 توسعه اپلیکیشن پیشرفته

فصل 26 پایگاه‌های داده بلاک‌چین

بخش دهم: ضمیمه A

ضمیمه A: طرح‌واره دانشگاهی دقیق

Database System Concepts by Silberschatz, Korth and Sudarshan is now in its 7th 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.

Table of Contents

Chapter 1 Introduction

PART ONE RELATIONAL LANGUAGES

Chapter 2 Introduction to the Relational Model

Chapter 3 Introduction to SQL

Chapter 4 Intermediate SQL

Chapter 5 Advanced SQL

PART TWO DATABASE DESIGN

Chapter 6 Database Design Using the E-R Model

Chapter 7 Relational Database Design

PART THREE APPLICATION DESIGN AND DEVELOPMENT

Chapter 8 Complex Data Types

Chapter 9 Application Development

PART FOUR BIG DATA ANALYTICS

Chapter 10 Big Data

Chapter 11 Data Analytics

PART FIVE STORAGE MANAGEMENT AND INDEXING

Chapter 12 Physical Storage Systems

Chapter 13 Data Storage Structures

Chapter 14 Indexing

PART SIX QUERY PROCESSING AND OPTIMIZATION

Chapter 15 Query Processing

Chapter 16 Query Optimization

PART SEVEN TRANSACTION MANAGEMENT

Chapter 17 Transactions

Chapter 18 Concurrency Control

Chapter 19 Recovery System

PART EIGHT PARALLEL AND DISTRIBUTED DATABASES

Chapter 20 Database-System Architectures

Chapter 21 Parallel and Distributed Storage

Chapter 22 Parallel and Distributed Query Processing

Chapter 23 Parallel and Distributed Transaction Processing

Here is the extracted text from the image:

PART NINE ADVANCED TOPICS

Chapter 24 Advanced Indexing Techniques

Chapter 25 Advanced Application Development

Chapter 26 Blockchain Databases

PART TEN APPENDIX A

Appendix A Detailed University Schema

Index

About the Author

Abraham (Avi) Silberschatz is the Sidney J. Weinberg Professor of Computer Science at Yale University. Prior to coming to Yale in 2003, he was the vice president of the Information Sciences Research Center at Bell Labs. He previously held an endowed professorship at the University of Texas at Austin, where he taught until 1993. Silberschatz is a fellow of the ACM, a fellow of the IEEE, and a member of the Connecticut Academy of Science and Engineering. He received the 2002 IEEE Taylor L. Booth Education Award, the 1998 ACM Karl V. Karlstrom Outstanding Educator Award, and the 1997 ACM SIGMOD Contribution Award. Silberschatz was awarded the Bell Laboratories President’s Award three times, in 1998, 1999 and 2004. His writings have appeared in numerous journals, conferences, workshops, and book chapters. He has obtained over 48 patents and over 24 grants. He is an author of the textbook Operating System Concepts.

S. Sudarshan is currently the Subrao M. Nilekani Chair Professor at the Indian Institute of Technology, Bombay. He received his Ph.D. at the University of Wisconsin in 1992, and he was a member of the technical staff at Bell Labs before joining IIT Bombay. Sudarshan is a fellow of the ACM. His research spans several areas of database systems, with a focus on query processing and query optimization. His paper on keyword search in databases published in 2002 won the IEEE ICDEMost Influential Paper Award in 2012, and his work on main-memory databases received the Bell Laboratories President’s Award in 1999. His current research areas include testing and grading of SQL queries, optimization of database applications by rewriting of imperative code, and query optimization for parallel databases. He has published over 100 papers and obtained 15 patents.

Henry F. (Hank) Korth is a Professor of Computer Science and Engineering and co-director of the Computer Science and Business program at Lehigh University. Prior to joining Lehigh, he was director of Database Principles Research at Bell Labs, a vice president of Panasonic Technologies, an associate professor at the University of Texas at Austin, and a research staff member at IBM Research. Korth is a fellow of the ACM and of the IEEE and a winner of the 10-Year Award at the VLDB Conference. His numerous research publications span a wide range of aspects of database systems, including transaction management in parallel and distributed systems, real-time systems, query processing, and the influence on these areas from modern computing architectures. Most recently, his research has addressed issues in the application of blockchains in enterprise databases.