What is a Distributed Database? - Architecture, Principles & Advantages

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: Models of Database Management Systems (DBMS)

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:06 Databases in Organizations
  • 2:38 Distributed Databases
  • 5:12 Lesson Summary
Save Save Save

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed Speed

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Paul Zandbergen

Paul has a PhD from the University of British Columbia and has taught Geographic Information Systems, statistics and computer programming for 15 years.

As databases get larger, it often becomes more efficient to keep them in more than one location. Learn about the use of distributed databases by multiple users at different computer network sites.

Databases in Organizations

Organizations use large amounts of data. The most common data types are text and numbers, but data can also include images, photographs, sound, video and other mediums. Data is organized in a database. A database management system, or DBMS, is a software tool that makes it possible to organize data in a database.

A database consists of one or more files that need to be stored on a computer. In large organizations, databases are typically not stored on the individual computers of employees but in a central system. This central system usually consists of one or more computer servers. A server is a computer system that provides a service over a network. One of these services is data storage.

In a typical setting, the database files reside on the server, but they can be accessed from many different computers in the organization. One of the advantages of using a database management system is that multiple users can use the same database at the same time. The server is often located in a room with controlled access, so only authorized personnel can get physical access to the server.

Consider for a moment how this is different from using a regular document stored on your hard drive. If you open a word processing or spreadsheet document on your computer, you are the only user. If you want to share this document with a colleague, you could email it to them so that they can save it on their hard drive. However, this creates a copy, and now there are two versions of the same file. Both you and your colleague can work with the data, but what happens if you both start making changes? You can see how this is going to get confusing.

As the number and complexity of databases grow, we start referring to it as a data warehouse. A data warehouse is a collection of databases that work together. A data warehouse provides an architecture and tools to systematically organize and understand data from multiple databases. This can give new insights into the data.

Distributed Databases

As databases get larger, it becomes increasingly difficult to keep the entire database in a single physical location. Not only does storage capacity become an issue, there are also security and performance considerations.

Consider a company with several offices around the world. It is possible to create one large, single database at the main office and have all the other offices connect to this database. However, every single time an employee needs to work with the database, this employee needs to create a connection over thousands of miles, through numerous network nodes. As long as you are moving relatively small amounts of data around, this does not represent a major challenge. But what if the database is huge? It is not very efficient to move around large amounts of data back and forth over the network.

To unlock this lesson you must be a Study.com Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support