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

Sunday, 10 May 2020

Distributed Database Question Bank with Answers 16

Distributed  and parallel database questions and answers for University exams


Question:

What is the goal of data allocation process when designing a distributed database? Discuss different criteria for “optimal” data allocation.


Answer:
  • Reliability – more copies available in case of site crashes
  • Increased performance for read-only queries
  • Optimality may be defined in two ways: minimal cost and maximized performance.
    • Minimal cost – cost of storing and querying a fragment at a site, cost of updating a fragment at all sites, cost of data communication
    • Maximized performance – minimize query response time, maximize system throughput

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

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