Central Data Management System
A central database (sometimes known as abbreviated CDB) is a database that is stored, located and managed at a single place. The location of the database is typically an underlying machine or database, such as an office or server CPU and a mainframe system. In the majority of cases central databases will be used by an entity (e.g. an enterprise) as well as an academic institution (e.g. a university.) The database is accessible to users via a computer network that can provide users an access point to the CPU central which maintains the database.
A central database is kept in a single place, like a mainframe computer. It is managed and updated exclusively from this location, and typically accessible through an internet connection like the LAN or the WAN. The central database is utilised by institutions like banks, universities, corporations, etc.
Advantages
A few advantages that come with Centralised Database Management System are the following:
- The data integrity is improved since the entire database is kept in the same physical site. This makes it simpler to coordinate the information and is as consistent and accurate as is possible.
- Data redundancy is low with the centralised databases. All data is kept in one place and not scattered over multiple locations. Therefore, it is simpler to ensure that there is no duplicate data.
- Because all information is stored in one location There are more security measures surrounding it. Therefore the central database is more secure.
- Data is portable since it is kept in the same location.
- Central databases are less expensive than other kinds of databases since it needs less power and requires less maintenance.
- The information contained in the central database can be accessed easily from the same database simultaneously.
Disadvantages
A few disadvantages of Centralised Database Management System are the following:
- Because all the data is stored in one location It takes longer to locate and get it. If the network isn't fast enough this process can take longer.
- There is a significant amount of data access and data transfer traffic that is destined to the central database. This could lead to an issue of bottlenecks.
- Because all data is stored in one place, if more than one user attempts to access it simultaneously, it can cause problems. This could reduce the effectiveness that the computer system can provide.
- If there aren't procedures for recovering databases in place and a system fails and the database is damaged, all data stored in the database is erased.
Characteristics of a Centralised Database System
Global clocks are a constant:The entire system consists of one central computer (a serveror master) and a number of clients computers (a computeror a slave) All client nodes connect to the global clock(the time of the central node).
One single central unit:The central server will be in communication with every client. Each client will send an inquiry to the server. The server will reply.
Failure of components that is dependent on the component:If the server goes down the entire system is destroyed. The client is unable to connect to the database.