057. At what locations can data physically be stored? What are the advantages and disadvantages of each?

 

1.      Centralized Databases are databases that maintained at a single location. 

2.      Decentralized Databases are separate databases, each kept at a separate location. 

3.      Distributed Databases are logically a single database which is physicall stored in several different locations but  there is communication between the locations.

Type

Advantage

Disadvantage

Centralized

Control

Lack of flexibility

Decentralized

Flexibity

Decreased Control

Distributed

Flexibility and some control

Complicated programming and maintenance