Distributed Database Concepts and Architecture Fundamentals

First Partial: Distributed Databases

1. The Database Concept

R: A database is a set of interrelated information for a common purpose.

2. Definition of Distributed Database

R: A distributed database is a collection of multiple databases located in different locations and connected via a network.

3. Goals of Distributed Databases

R: Building distributed systems, including databases, information sharing, reliability, availability, and speed in query processing.

4. Advantage of Data Distribution

R: The advantage of distributed systems is the ability to share and access information reliably and effectively.

5. Increasing Complexity Reflection

R: This reflects in gesta (management) software development, a greater likelihood of errors, and longer processing times.

6. Location Transparency

R: Location transparency allows a user to access data without needing to know or see the physical locations where the data resides.

7. Data Duplication Transparency

R: Data duplication transparency means that even if there is more than one copy of the data, the system chooses one copy to retrieve, and all copies must be updated consistently.

8. Configuration Independence

R: Configuration independence enables the organization to add or replace hardware without having to change existing software components in the DBMS (Database Management System).

9. Data Duplication

R: Data duplication occurs if the system maintains several identical copies of a relation (R), with each copy stored on a different site.

10. Necessary Study Disciplines

R: It is necessary to know the evolution and current state of database technology to be prepared for the changes that will inevitably occur in the database area.

11. Characteristics of Parallel Systems (Two)

R:

• The database resides on a single machine with multiple CPUs and multiple hard drives.
• All users access that single machine.

12. Characteristics of Client-Server Architecture (Two)

R:

• The client and the server can act as a single entity or as separate identities, performing independent activities or tasks.
• The functions of the client and server can reside on separate platforms or on the same platform.

13. The User Interface

R: The user interface is the representation of the system through which the user interacts with the application software.

14. The Underlying System

R: Everything that constitutes the structure of the database.

15. Client/Server Interaction

R: Client and server functions are integrated into one application. The client requests a service from the server application.

16. Interface Separation with Databases

R: Centralized.