praxis.ibLog in
A3.4 Alternative databases and data warehousesA3.4.4

Features of distributed databases

Describe the features of distributed databases

AHL≈ 60 minCommand term: DescribePremium

In this lesson

  • Describing how a distributed database stores data at several sites, using partitioning and replication
  • Describing why consistency must be maintained, and how ACID properties and an atomic (two-phase) commit are achieved across sites
  • Describing concurrency control, data security, transparency, fault tolerance, global query processing and scalability in distributed databases

This lesson is part of Premium

Every topic has one free lesson. Premium unlocks every interactive lesson, the exam-style questions at the end of each one, and the rest of Praxis IB.

Log in or sign upTry the free lesson: A3.4.1 Types of databases as approaches to storing data

What's inside

  1. LearnOne database, many sites
  2. LearnPartitioning and replication
  3. LabA hotel chain's bookings at three sites
  4. LearnKeeping the data consistent
  5. LearnACID across sites
  6. LabRun a two-phase commit
  7. LearnMore features of distributed databases
  8. CheckMatch each feature to an example
  9. CheckQuick check
  10. ExamWorked exam answer
  11. ReviewMistakes examiners see
  12. Exam practiceExam-style questions

Ends with 5 exam-style questions worth 14 marks, with a self-marking markscheme.