Database Internals PDF LECTURE SLIDES

Database Internals

Instructor:Magdalena Balazinska
Textbook : Database Systems: the Complete Handbook, by Hector Garcia-Molina, Jennifer Widom, and Jeffrey Ullman
Download slides from here

Introductionlecture 1

Review of relational model and SQL lecture 2

Intro to SimpleDB and JUnit section 1

DBMS architecture and deployments lecture 3

Data storage and buffer management lecture 4

Indexinglectures 5-6

Data storage and SQL section 2

Indexinglectures 5-6

Query execution lecture 7

Operator algorithms lectures 8-9 and example

Indexing section 3

Operator algorithms lectures 8-9 and example

Query optimization lecture 10

Query optimization lectures 11-12

Operator Algorithms section 4

Query optimization lectures 11-12 andexample (see page 8)

Database tuning lecture 13

Transactions: Concurrency controllecture 14

Query optimization section 5

Transactions: Concurrency control lecture 15

Transactions: Concurrency controllecture 16

Transactions: Recoverylecture 17

Transactions section 6 [pptx, txt]

Transactions: Recoverylecture 18

Transactions: Recovery lecture 19

Distributed query processing and optimization lecture 20

Transactions section 7

Distributed transactions lecture 21

Replication lecture 22

Replication and distribution section 8

Parallel DBMSs lectures 23 and 24

Parallel DBMSs lectures 23 and 24

Parallel processing
section 9

MapReducelectures 25

NoSQLlectures 26

Review section 10