Distributed and Parallel Database

Video Lessons & Revision Notes

Distributed Database - Basic Concepts, Fragmentation and Allocation
Distributed Database - Basic Concepts, Fragmentation and Allocation
1. Distributed Database - Basic Concepts, Fragmentation and Allocation
In this 54 mins Video Lesson
Distributed Computing System, Distributed DB, Distributed Database, Advantages of DDBMS, Special Functions of DDBMS, Fragmentation, Horizontal, Vertical, Mixed/ Hybrid Fragmentation, Fragmentation Schema, Allocation, Allocation Schema, and other topics.
Distributed Database - Replication, Query Processing and Concurrency Control
Distributed Database - Replication, Query Processing and Concurrency Control
2. Distributed Database - Replication, Query Processing and Concurrency Control
In this 50 mins Video Lesson
Introduction, Data Replication, Query Processing, Semi Join, Concurrency Control, Distinguish Copy Techniques, Primary Site, Primary Site with Backup, Primary Copy Technique, Selecting a Co-ordinator , Voting Based Techniques, and other topics.
Parallel Database - Architecture Models, Interquery Parallelism and Intraquery Parallelism
Parallel Database - Architecture Models, Interquery Parallelism and Intraquery Parallelism
3. Parallel Database - Architecture Models, Interquery Parallelism and Intraquery Parallelism
In this 42 mins Video Lesson
Introduction, Parallel DB Architecture, Sahred Memory, Shared Disk, Sahred Nothing, Hierarchical, Query Evaluation, Interquery Parallelism, Range Partitioning, Intra Query Parallelism, Sorting Algorithms, Range Partition Sort, and other topics.
Parallel Database - Intraquery Parallelism (Contd.)
Parallel Database - Intraquery Parallelism (Contd.)
4. Parallel Database - Intraquery Parallelism (Contd.)
In this 39 mins Video Lesson
Parallel External Sort Merge, Execution Skew, Parallel Join Techniques, Partition Join, Fragment and Replicate Join, Parallel Nested Loop Join, Selection Operation, Duplicate Elimination, Projection, Aggregation, and other topics.

Revision Notes

Introduction to parallel databases, Parallel : Query Evaluation, Parallelizing, individual operations; sorting, joins, etc.

Distributed databases, concepts, data fragmentation, Replication and allocation techniques for distributed database design. Query Processing in distributed databases, concurrency control and recovery in distributed databases

Member's Zone