Thursday, July 6, 2017

What are the different strategies for placing the data in distributed database

What are the different strategies for placing the data in distributed database?, different data allocation metrics followed in distributed database, how data are placed in a distributed database?

Different strategies for placing data in distributed database

A distributed database implementation follows one of the following data placement strategies for ease of access. The selection is influenced by many factors like the locality, reliability, performance, storage and communication costs.

Database tables are stored in a single location/single site (server). All the other sites have to forward the request to the central site for accessing data.
Fragmented (Partitioned)
Database tables are fragmented (either vertically or horizontally or both) and different fragments are stored in different sites.
Complete replication
Database tables are replicated (duplicated) fully into two or more copies and each copy is stored in different sites.
Selective replication
Among set of tables, certain tables are made into multiple copies and stored in different sites. The tables that are most frequently accessed will be replicated.
It is the mix of all. Most of the distributed databases follow this strategy. Here, some of the tables replicated, some of the tables fragmented, etc.



No comments:

Post a Comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery