Distributed Database Systems Integration

Distributed Database Systems Integration

Created by
@HearteningFairy

Questions and Answers

What is being distributed in a distributed computing system?

Processing logic, data, and control

What is a distributed database system (DDBS)?

A collection of multiple, logically interrelated databases distributed over a computer network and the software that manages it

What is not an example of a distributed database system?

A timesharing computer system

What is a distributed database (DDB)?

<p>A collection of multiple, logically interrelated databases distributed over a computer network</p> Signup and view all the answers

What is a distributed database management system (D-DBMS)?

<p>The software that manages a distributed database and provides an access mechanism that makes this distribution transparent to the users</p> Signup and view all the answers

What is a processing element in a distributed computing system?

<p>A computing device that can execute a program on its own</p> Signup and view all the answers

What is the main difference between a distributed database system and a parallel database system?

<p>A distributed database system is used for multiple databases over a computer network, while a parallel database system is used for multiple processors</p> Signup and view all the answers

What is the main characteristic of a distributed database system?

<p>It is used for multiple databases over a computer network</p> Signup and view all the answers

What is promised by Distributed DBMS?

<p>Transparent management of distributed, fragmented, and replicated data</p> Signup and view all the answers

What does transparency refer to?

<p>Immunity of user applications to changes in the definition and organization of data</p> Signup and view all the answers

What is logical data independence?

<p>Refers to the immunity of user applications to changes in the logical structure of the database</p> Signup and view all the answers

What does network transparency require?

<p>Requires that users do not have to specify where data are located</p> Signup and view all the answers

What is meant by replication transparency?

<p>The system should handle the management of copies and the user should act as if there is a single copy of the data</p> Signup and view all the answers

What is the benefit of replication transparency?

<p>Data can be placed on that user’s local machine as well as on the machine of another user with the same access requirements</p> Signup and view all the answers

What is physical data independence?

<p>Refers to the immunity of user applications to changes in the physical structure of the database</p> Signup and view all the answers

What is location transparency?

<p>Perform a task independent of both the location of the data and the system on which an operation is carried out</p> Signup and view all the answers

What is the primary characteristic of the pull-only mode?

<p>The client initiates the transfer of data.</p> Signup and view all the answers

What is the main difference between periodic delivery and conditional delivery?

<p>The trigger for data transfer.</p> Signup and view all the answers

What is the characteristic of the hybrid mode?

<p>It combines client-pull and server-push mechanisms.</p> Signup and view all the answers

What is the primary characteristic of unicast communication?

<p>One-to-one communication between a server and a client.</p> Signup and view all the answers

What is the primary characteristic of ad-hoc delivery?

<p>Data is pulled from servers to clients in an ad-hoc fashion.</p> Signup and view all the answers

What is an example of conditional delivery?

<p>An application that sends out stock prices only when they change.</p> Signup and view all the answers

What is the primary characteristic of one-to-many communication?

<p>The server sends data to multiple clients.</p> Signup and view all the answers

What is the primary difference between the push-only mode and the hybrid mode?

<p>The initiation of data transfer.</p> Signup and view all the answers

What is a main concern in distributed database design?

<p>Data distribution and replication</p> Signup and view all the answers

What is the goal of query processing in distributed DBMS?

<p>Minimize the cost of data transmission and local processing</p> Signup and view all the answers

What is a challenge in distributed DBMS concurrency control?

<p>Synchronizing concurrent accesses</p> Signup and view all the answers

What is a key aspect of distributed DBMS reliability?

<p>Atomicity and durability</p> Signup and view all the answers

What is the relationship between directory management and query processing in distributed DBMS?

<p>They are related but separate issues</p> Signup and view all the answers

What is the main goal of distributed DBMS architecture?

<p>To define the structure of the system</p> Signup and view all the answers

What is a consequence of a distributed DBMS having a general formulation that is NP-hard?

<p>Query optimization is more complex</p> Signup and view all the answers

What is a key aspect of distributed DBMS concurrency control?

<p>Consistency and isolation of transactions' effects</p> Signup and view all the answers

What is a characteristic of multidatabase systems (MDBS)?

<p>Individual DBMSs are fully autonomous and have no concept of cooperation.</p> Signup and view all the answers

What is the term for individual DBMSs in multidatabase systems?

<p>Autonomous DBMS</p> Signup and view all the answers

What is the function of the Global User Request in MDBS?

<p>To receive global user requests</p> Signup and view all the answers

What is the purpose of the Multi-DBMS Layer?

<p>To integrate local DBMSs</p> Signup and view all the answers

What is the relationship between GES and LES in MDBS?

<p>GES is a global schema, and LES is a local schema</p> Signup and view all the answers

What is the Mediator/Wrapper Architecture used for?

<p>Multidatabase Systems</p> Signup and view all the answers

What is the function of LCS in MDBS?

<p>Local Schema</p> Signup and view all the answers

What is the term for the process of breaking down global user requests into local subrequests?

<p>Request Decomposition</p> Signup and view all the answers

Study Notes

Distributed Database Systems

  • A distributed database system (DDBS) is a collection of multiple, logically interrelated databases distributed over a computer network.
  • A DDBS consists of a distributed database (DDB) and a distributed database management system (D-DBMS).

Distributed Computing

  • A distributed computing system consists of autonomous processing elements interconnected by a computer network, cooperating in performing their assigned tasks.
  • What is being distributed: processing logic (function), data, and control.

Distributed Database Management System (D-DBMS)

  • A D-DBMS is software that manages a DDB and provides an access mechanism that makes the distribution transparent to users.

What is not a DDBS?

  • A timesharing computer system, loosely or tightly coupled multiprocessor system, and parallel database systems are not DDBS.

Delivery Modes

  • Pull-only mode: data transfer from servers to clients is started by a client pull.
  • Push-only mode: data transfer from servers to clients is initiated by a server push in the absence of any specific request from clients.
  • Hybrid mode: combines client-pull and server-push mechanisms.

Frequency of Delivery

  • Periodic delivery: data are sent from servers to clients at regular intervals defined by system defaults or client profiles.
  • Conditional delivery: data are sent from servers whenever certain conditions installed by clients in their profiles are satisfied.
  • Ad-hoc delivery: data are pulled from servers to clients in an ad-hoc fashion whenever clients request it.

Communication Methods

  • Unicast: communication from a server to a client is one-to-one.
  • One-to-many: the server sends data to a number of clients.

Distributed DBMS Promises

  • Transparent management of distributed, fragmented, and replicated data.
  • Improved reliability/availability through distributed transactions.
  • Improved performance.
  • Easier and more economical system expansion.

Transparency

  • Transparency: hides implementation details from users.
  • Data independence: immunity of user applications to changes in the definition and organization of data.
  • Logical data independence: immunity of user applications to changes in the logical structure (schema) of the database.
  • Physical data independence: hiding the details of the storage structure from user applications.

Network Transparency

  • Requires that users do not have to specify where data are located.
  • Location transparency: perform tasks independent of the location of data and the system on which an operation is carried out.
  • Naming transparency: unique names are provided for each object in the database.

Replication Transparency

  • Replication transparency: the system handles the management of copies, and the user acts as if there is a single copy of the data.

Distributed DBMS Issues

  • Distributed database design: how to distribute the database.
  • Query processing: converting user transactions to data manipulation instructions.
  • Concurrency control: synchronization of concurrent accesses.
  • Reliability: making the system resilient to failures.

Architecture

  • Defines the structure of the system.
  • Components are identified, and their functions are defined.
  • Interrelationships and interactions between components are defined.

Multidatabase Systems (MDBS)

  • Represent the case where individual DBMSs are fully autonomous and have no concept of cooperation.
  • No knowledge of each other's existence or how to communicate with each other.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

More Quizzes Like This

Use Quizgecko on...
Browser
Browser