IT distributed databases

?
  • Created by: NaftyC
  • Created on: 21-05-18 09:00
View mindmap
  • IT Unit 3 - Distributed Databases
    • Definition
      • A single logical database that is spread physically across computers in multiple locations that are connected by data communication links
    • Partitioning
      • Horizontal - this is where the data is partitioned based upon records
      • Vertical - this is where the data is partitioned based upon individual fields
    • Types of Distributed databases
      • Duplication - this is where each location that requires the database is given an entire copy of the database
      • Central databse with indexes - this is where the database is held centrally but indexes are distributed. This means that each location can perform processing locally and go back to the central database for specific records.
        • Definition of index - a data structure that contains references that allow data to be looked up and accessed quickly

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »