Centralized Database Systems, Characteristics, Advantages and Disadvantages

Let’s see Centralized Database Systems, Characteristics, Advantages, and Disadvantages.

In a centralized database, all data is stored and maintained in one place. The central location is a computer or database. All the data is stored in a single location for an example mainframe computer.

This database mostly maintains and modifies using internet connection like LAN and WAN.

The centralized database mostly used in colleges, banks, hospitals and in small companies. In a centralized database system one computer act as a server for storing whole data. In a centralized database system, client/server architecture is used it is the very simplest form of a database system in which one client sent a request to the server. The server will receive a request and will be a response. Many small organizations use a centralized database system.

Characteristics of a Centralized Database System

Presence of a global clock:

As the whole system consists of a central computer (a server/ a master) and many client computers (a computer/ a slave), all client nodes connect up with the global clock(the clock of the central node).

One single central unit:

The central server will communicate with all clients. All clients send a request to the server and the server will be the response.

Dependent failure of components:

When the server goes down all systems will be destroyed. The client is not able to access the database

Advantages of Centralized Database System

Some advantages of a Centralized Database Management System are:

  1. The integrity of data is increased as the whole database is stored at a single physical location. In this way, it is easy to manage the data is most consistent and accurate in this way.
  2. The data redundancy is controlled in a centralized database. All the data is stored in one location and it cannot distribute on different places. So, it is easier to make sure all the data stored is not duplicate. in this way redundancy easily control
  3. The centralized database is much secure. Because all data is stored in one place
  4. Data is easily portable because it is stored in the same place. Strong data security
  5. The centralized database is inexpensive than other databases .it required less expense on maintains
  6. All the information is easily accessible. it takes less time to get the required information from a centralized database

Disadvantages of Centralized Database System

Some disadvantages of a Centralized Database Management System are:

  1. If the network is slow, the accessibility of required because all data is stored in one place.Since all the data is at one location. The searching process takes much time.
  2. If centralized server failure due to some reasons all database will be a loss.
  3. All data is stored in one place when many users access data at the same time it may create many problems.
  4. When the many record same place will be accessed at the same time the collision will be accord in the result of collision may be precious data will be lost.

Frequently Asked Questions (FAQ)

A user-friendly______ is one advantage of a distributed database management system (DDBMS) .

Answer - Click Here:
Answer:interface

a(n) _____ includes the merging of data from different data systems into one centralized database.

Answer - Click Here:
Answer: Clinical data repository

The primary disadvantage of centralized database systems is ______.
a. Data security
b. Transmission delay when users are geo-dispersed
c. Availability of statistical analysis tools
d. Data quality

Answer - Click Here:
Answer: b

Which is One of the advantages of a distributed database management system (DDBMS) is less danger of a single- ___failure.

Answer - Click Here:
Answer: point

____ distributed database systems integrate only one type of centralized dbms over a network.

Answer - Click Here:
Answer: homogeneous

____ distributed database systems integrate different types of centralized dbmss over a network

Answer - Click Here:
Answer: homogeneous

Which is One of the advantages of a distributed DDBMS is processor___.

Answer - Click Here:
Answer:independence

One of the advantages of a distributed database management system (DDBMS) is _______operating cost.
Answer - Click Here:
Answer:reduced/ Lower

distributed database management system (DDBMS),_____occurs to determine the data location of local and remote fragments.

One of the advantages of a distributed database management system (DDBMS) is _______operating cost.

Answer - Click Here:
Answer: mapping

In a distributed database management system (DDBMS), query______is used to find the best access strategy.

Answer - Click Here:
Answer:optimization

In a distributed database management system (DDBMS),______control is used to manage simultaneous data access and ensure data consistency across database fragments.

Answer - Click Here:
Answer:concurrency

Prof. Fazal Rehman Shamil
Latest posts by Prof. Fazal Rehman Shamil (see all)

    Buy advertisement space on T4Tutorials

    For more details email [email protected]