wk8 dq1

Replies 75-100 WORDS

A Cody 

Five advantages of distributed Databases:

· The database can be expanded data wise due to it being spread across different physical locations.

· The database can be accessed from multiple networks instead of one.

· Security is more improved than a centralized database.

· Data efficiency is improved. Due to the splitting of data which creates less time on transactions.

· Better control of recourses.

B Trevor Stoutt

Below are the advantages of a distributed database when compared to a centralized database

Load balancing- since the data is already dispersed through multiple locations, data is more efficiently accessed because the workload is split which brings about higher performance.

Increased availability- also brought about by the fact that the database itself is split into multiple locations. Bringing the time it takes for users to access data down.

Viewing- it is also easier to view data in a distributed database since all the data is not in one place or on the same server, this enables users to have a more autonomous viewing experience.

Response time- the response is less in a distributed database because more nodes are available and ready to work.

Failure- if a failure occurs in a centralized database, the data can not be accessed since the database is all in the same physical location. Whereas, in a distributed database if one of the database locations was down due to failure, the data could still be accessed elsewhere since the database is spread out across multiple locations.

C Ai La

Hello,

Scalability:

· Distributed databases can handle large amounts of data and high transaction volumes more effectively than centralized databases, as the load is distributed across multiple servers.

· They are also more flexible in terms of adding more servers to the network to accommodate growth in data or traffic, without impacting performance.

Fault-tolerance:

· Distributed databases have built-in redundancy, so if one server fails, the other servers can continue to operate, ensuring availability and preventing data loss.

· They also have better disaster recovery capabilities, as data is replicated across multiple nodes in different locations.

Performance:

· Distributed databases can process queries and transactions faster than centralized databases, as they can leverage parallel processing and data locality to reduce latency.

· They can also provide better response times for users distributed across different locations, as they can use nodes that are closer to the user to minimize network latency.

Security:

· Distributed databases can be more secure than centralized databases, as they can use encryption and access control mechanisms that are distributed across multiple nodes, making it harder for attackers to gain unauthorized access.

· They can also provide better auditing and logging capabilities, as data changes are recorded across multiple nodes, making it easier to track changes and detect suspicious activity.