Category: 

What is a Distributed Database?

Article Details
  • Written By: Troy Holmes
  • Edited By: W. Everett
  • Last Modified Date: 20 November 2016
  • Copyright Protected:
    2003-2016
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
Helium is the only element that was discovered in space before it was found on Earth.  more...

December 10 ,  1948 :  The UN adopted the Universal Declaration on Human Rights.  more...

Database design typically includes the physical layout of hardware and software devices that manage a company's data storage. There are multiple techniques that can be applied when designing a database. A distributed database is a database that is split over multiple hardware devices but managed by a central database controller. This distributed approach typically provides better performance and reliability.

Dividing a database into separate physical units has many benefits. This approach provides better control over specific data. It also distributes the load on the computer hardware and network devices.

A distributed database is normally separated by business units, companies, or geographical regions. This approach provides for faster response times for users because the database is local to each business unit within the organization. The business unit is typically smaller then the entire organization, which reduces the overall load on the each server.

Most large companies have separate business units for specific functions. Some examples include accounting, human resources, and sales departments. A distributed database is designed to serve specific business units throughout the organization, while maintaining control from a central server. This technique enables the separation of hardware and data throughout the company, which provides for better control and overall performance.

Ad

A distributed database design provides the benefits of central access by corporate headquarters, while enabling local access for specific business units. This is a good design for companies that are disbursed throughout the world. It is also recommend for organizations that support multiple portfolios. Some examples of industries that would benefit from this design include manufacturing, hospitality, and banking.

A distributed database might also be used in an accounting operation. A global organization would typically include a distributed database designed to serve each country. This geographical distribution approach would enable the local country to query data faster. The central database would access each country's data without impacting each local accounting application.

Distributed databases provide better flexibility for a business. With the data divided between multiple servers, it can easily be replicated onto new hardware throughout the organization. This reduces the risk on unavailable data due to hardware failure.

There are some drawbacks to a distributed database design. The most prevalent is database integrity and concurrency. At times the distributed data may become unavailable to the central server. This is typically due to network issues within the computer system. While the database will remain available to the local business units, it may become outdated within the center headquarters of the organization until the network issue is repaired.

Ad

You might also Like

Recommended

Discuss this Article

Post your comments

Post Anonymously

Login

username
password
forgot password?

Register

username
password
confirm
email