answersLogoWhite

0

A database is nothing but simply a collection of records. The data can be stored all at a same place or can be distributed in different systems . When data is stored in different places that is distributed it is called distributed database.

A database is normally stored in one place. That could be a physical location, like a particular office. A distributed database is one database that has different parts of it stored in different places. This is often for security and safety purposes. To a user, they still see all of the data they need on their screen, so they don't even realise that it is stored in different locations.

User Avatar

Wiki User

11y ago

What else can I help you with?

Continue Learning about Information Science

What is the difference between a distributed database and distributed processing?

A distributed database is a collection of databases stored on multiple computers and accessed through a network, allowing for data to be distributed across different locations. Distributed processing, on the other hand, refers to breaking down a task into smaller parts that are processed on multiple computers simultaneously, enabling faster computation by leveraging the collective resources of multiple machines.


What are the advantage of distributed database over centralized database?

The database can be of two types either distributed or centralized . In distributed database the data is in different systems. In centralized database the data is in a single central system.We can categorize database as either distributed or centralized . In centralized database the data is in a single centralized system. While In distributed database the data is in different systems .


What is the difference between distributed and replicated database?

Distributed and replicated databases have a topology of having roles : 'masters' and 'slaves' even though in a replicated database schema, the distinction becomes a little blurred. Distributed databases are normally those where information is updated on a master. The changes in the master are distributed out to a number of slave databases. The slave databases can be updated themselves but if they are, their information isn't distributed to any other database. Should the master have updated information that would contend with information in a slave, the master would take presidence. Replicated databases are normally those in which there is the capability to post updates to both 'master' through to 'slave' as well as 'slave' through to 'master'.


Different between distributed and decentralized on database?

Distributed database is one logical database which is spread out over multiple sites, connected by network. It behaves as it were a single database. Decentralized databases are a group of independent databases spead out over different locations. They are not connected and do not share updates between each other.


What are distributed-databases in dbms?

Distributed databases in a DBMS are databases that are stored on multiple computers across a network. They allow for data to be spread out and accessed simultaneously from different locations, which can improve performance and scalability. Distributed databases can enhance fault tolerance and reduce the risk of data loss.

Related Questions

What is the difference between a distributed database and distributed processing?

A distributed database is a collection of databases stored on multiple computers and accessed through a network, allowing for data to be distributed across different locations. Distributed processing, on the other hand, refers to breaking down a task into smaller parts that are processed on multiple computers simultaneously, enabling faster computation by leveraging the collective resources of multiple machines.


What is the difference between distributed systems and advance distributed systems?

no answer


What is Difference between real time database and simple database?

the difference is about the transactions. the normal database is not included deadline, but the real time database is.


When was Distributed Database Consulting created?

Distributed Database Consulting was created in 1997.


Explain architecture of Distributed Database systems Also explain the reasons for building distributed database systems?

1 Explain architecture of Distributed Database systems? Also, explain the reasons for building distributed database systems?


Is a dhcp database a distributed database similar to a dns database?

no


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


What are difference between cache database and sql database?

CACHE is multidimensional and postconsonantal database and its supporting scripting


What are the distributed database access primitives?

dISTRIBUTED. DATABASE. ACCESS. PRIMITIVES. In the examples of the ... usemore powerful primitives


What different between local and distributed transactions?

Normally there are two types of servers. one is local and other one is distributed.. The difference between of both these transactions is local would be on the same server or database on the same machine and distributed is when u do transfer of money from one bank to another the servers involved are different and placed at different locations...


What are the advantage of distributed database over centralized database?

The database can be of two types either distributed or centralized . In distributed database the data is in different systems. In centralized database the data is in a single central system.We can categorize database as either distributed or centralized . In centralized database the data is in a single centralized system. While In distributed database the data is in different systems .


What is centralized database?

Distributed and Centralized Databases Distributed data is defined as collection of logically distributed database which are connected with each other through a network. A distributed database management system is used for managing distributed database. Each side has its own database and operating system.A centralized database has all its data on one place. As it is totally different from distributed database which has data on different places. In centralized database as all the data reside on one place so problem of bottle-neck can occur, and data availability is not efficient as in distributed database. Let me define some advantages of distributed database, it will clear the difference between centralized and distributed database.Users can issue commands from any location to access data and it does not affect the working of database. Distributed database allows us to store one copy of data at different locations. Its advantage is that if a user wants to access data then the nearest site (location) will provide data so it takes less time.There are multiple sites (computers) in a distributed database so if one site fails then system will not be useless, because other sites can do their job because as I earlier said that same copy of data is installed on every location. You will not find this thing in centralized database.Any time new nodes (computers) can be added to the network without any difficulty.Users do not know about the physical storage of data and it is known as distribution transparency, as we know that ideally, a DBMS must not show the details of where each file is stored or we can say that a DBMS should be distribution transparent.