20 Questions
What defines a distributed database system?
Spread over different sites
What is a characteristic of a homogeneous database?
Stores database identically at all sites
What is a challenge of a heterogeneous distributed database?
Lack of awareness among sites
How is data stored in the replication approach?
Stored redundantly at multiple sites
Why might a distributed database system be required?
To be accessed by various users globally
In a fully redundant database, what is the advantage of having copies of data maintained at different sites?
Increased availability of data at different sites and parallel processing of query requests
What is a disadvantage of maintaining copies of data at different sites in a fully redundant database?
Constant need for data updates and increased complexity of concurrency control
Which type of fragmentation ensures that each tuple is assigned to at least one fragment?
Horizontal fragmentation
What is the main advantage of a distributed database system over a centralized database system?
Higher availability, reliability, and better performance
What are the characteristics of a distributed database management system (DDBMS)?
Collection of logically related shared data, higher availability, and better performance
What makes a homogeneous database easy to manage?
All sites store database data identically
What is the primary challenge of a heterogeneous distributed database?
Different sites may use different schema and software
What is the purpose of translations in a heterogeneous distributed database?
To facilitate communication between different sites
In which type of distributed data storage approach is the entire relationship stored redundantly at 2 or more sites?
Replication
What defines a distributed database system as being located on various sites that don’t share physical components?
Heterogeneous database
In a distributed database system, what is the advantage of using fragmentation?
It distributes data and processing load to improve performance
What is a disadvantage of horizontal fragmentation in a distributed database system?
It complicates the process of reconstructing the original relation
What is the main challenge of maintaining a fully redundant database with copies of data at different sites?
Constant overhead due to data updating at all sites
What distinguishes a hybrid fragmentation from horizontal and vertical fragmentation?
It combines aspects of both horizontal and vertical fragmentation
Why does a distributed database system provide higher availability and reliability compared to a centralized database system?
It distributes data across multiple sites, allowing the system to continue functioning in case of site failure
Learn about the basics of distributed databases and how they are spread over different sites, such as a network of computers. Understand the types of distributed databases and their significance in a global user access scenario.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free