4f- Distributed Databases Security

Description

A level, A2 IT (Chapter 4) Mind Map on 4f- Distributed Databases Security, created by Gladys Mba on 28/04/2017.
Gladys Mba
Mind Map by Gladys Mba, updated more than 1 year ago
Gladys Mba
Created by Gladys Mba over 7 years ago
14
0

Resource summary

4f- Distributed Databases Security
  1. Interception of Data
    1. X- Fragmented and centralised databases have higher risk of interception as a lot more data is moving between sites
      1. Need high quality encryption.
      2. O- Replicate databases only need to send small part of the database to be updated. It is more difficult to intercept the entire database
      3. Physical Access to Data
        1. X- Any place where data is stored need a full security system
          1. X- Costs increased for partitioned (fragmented) and replicated databases
          2. O- In centralised databases only the central location needs high security as local sites do not store valuable information
          3. Data Consistency and Integrity
            1. Centralised
              1. O- All data is stored and updated in one place
                1. O- Only data changes at local sites is updating indexes with is straight-forward.
                2. Vertically Fragmented
                  1. O- Each non-key field is stored and updated in one place
                    1. X- Need to make sure changes in primary key field are done at all sites
                    2. Horizontally Fragmented
                      1. O- Each record is stored and updated in one place
                        1. X- Need to make sure change in primary key does match an existing primary key.
                        2. Replicated Databases
                          1. Changes made to the data are sent to each database rather than the new data it's self.
                            1. E.g. is £450 is updated to £350inone location, -£100 is sent out to all databases for that cell.
                            2. X- If Distributed Database Management System (DDMS) is not set up properly certain updates to data will be lost.
                            3. Data must be accurate and up-to-date. storing data at different locations may lead to problems with this as data changed at one site must also be changed in all the others.
                            Show full summary Hide full summary

                            Similar

                            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