Advanced Database Management System - Tutorials and Notes: Distributed Database Question Bank with Answers 04

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Friday, 1 May 2020

Distributed Database Question Bank with Answers 04



Question:

When and why is replication favorable in a distributed database?


Answer:
Replication will speed up data access for data that is seldom updated.
Replication is favorable when the update frequency is low since the DDBMS must otherwise use a lot of resources to keep the different copies of the database up-to-date. For example, in a replicated database this would mean that all updates to the one replicated table would have to be propagated to each distributed node. On the other hand replication is very good for read-only databases since then only local accesses would be needed.


**********************

Related Questions:

No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents