4d Distributed Databases

Beschreibung

A level, A2 IT (Chapter 4) Mindmap am 4d Distributed Databases, erstellt von Gladys Mba am 27/04/2017.
Gladys Mba
Mindmap von Gladys Mba, aktualisiert more than 1 year ago
Gladys Mba
Erstellt von Gladys Mba vor mehr als 7 Jahre
19
1

Zusammenfassung der Ressource

4d Distributed Databases
  1. Partitioned Database
    1. Horizontal Partitioning
      1. Data is separated based on records. e.g. all records with one specific attribute are stored in one place
        1. Each site can search from it's own records locally but have to use global search to find other records
      2. Vertical Partitioning
        1. Data is separated based on fields. e.g. ID and one certain field is stored in one place.
        2. Different parts of the data stored at different sites
          1. "Sites" can be a server or computer at a particular location
        3. Replicated Databases
          1. Entire database is copied for each site
          2. Central databases with Remote Local Indexes
            1. One central database is stored in one location.
              1. Indexes mean that when the record is searched for locally a request for the record is sent to the central data base
                1. Indexes have the primary key used to identify records locally and a foreign key, which is the primary key in the central database
              Zusammenfassung anzeigen Zusammenfassung ausblenden

              ähnlicher Inhalt

              A2 Organic Chemistry - Reactions
              yannycollins
              Ecosystems
              Jessica Phillips
              ER notation
              linneamd
              Computing Hardware - CPU and Memory
              ollietablet123
              GCSE Biology B2 (OCR)
              Usman Rauf
              Types and Components of Computer Systems
              Jess Peason
              AS Chemistry - Enthalpy Changes
              Sarah H-V
              Biology B1.1 - Genes
              raffia.khalid99
              Unit 1 flashcards
              C R
              Cell Structure
              megan.radcliffe16
              Exchange surfaces and breathing
              megan.radcliffe16