CG1.2 Organization and Structure of Data

Description

A-Level Computing AS Mind Map on CG1.2 Organization and Structure of Data, created by welhamnathan on 12/02/2015.
welhamnathan
Mind Map by welhamnathan, updated more than 1 year ago
welhamnathan
Created by welhamnathan over 10 years ago
4
1
1 2 3 4 5 (0)

Resource summary

CG1.2 Organization and Structure of Data
  1. Files, Records & Fields
    1. Fixed Length Fields & Records

      Annotations:

      • Fixed length fields & records contain a pre-determined amount of data. They are faster to process than variable length fields & records & it is easier to predict how large a file containing these will grow however, they do contain waste space (if a data entry is smaller than the field size then it will be padded with blank spaces until it reaches that size)
      1. Variable Length Fields & Records

        Annotations:

        • Variable Length Fields & Records are simply fields & records that can hold a changeable amount of data. Files containing these typically take longer to process than files containing fixed length  fields & records, however they also waste less space (one field ends then a character is placed to symbolize its end, then the next field begins immediately)
        1. What are Files, Records & Fields

          Annotations:

          • A file is a group of related records (such as an account database) A record is a collection of fields based on a particular thing (such as a user account) A field is a single item of data (such as a username/password)
        2. File Access
          1. Serial & Sequential File Access

            Annotations:

            • Serial File Access: Files are stored purely in order of creation (first record created first) Sequential File Access: Files are stored with a different order, such as alphabetical.
            1. Algorithm for Serial File Access

              Annotations:

              • Open File, Place record in file at end position Close file
              1. Algorithm for Sequential File Access

                Annotations:

                • Open File Read all records from file & add new record Insertion sort to place new record in correct position Possibly read all records again (to verify that it was correctly sorted) Close File
              2. Database Systems
                1. Database Management System

                  Annotations:

                  • The Underlying system that manages the database. Its purpose is to assign Access rights & database responsibilities
                  1. Benefits & Drawbacks of Using a database

                    Annotations:

                    • Using a database lowers the amount of physical space used, the amount of time to edit, sort, retrieve & create, fewer updating issues, data validation, easy to back up, fewer arithmetic errors, generally higher security. Drawbacks of this include people who have poor computer literacy will have issues with the database or that corruption of the database can spread much easier (due to viruses)
                    1. Data to information

                      Annotations:

                      • Information is data that has been sorted through a query, meaning that it contains only data that adheres to a specific criteria or is related to a specific topic
                    2. Data Validation & Verification
                      1. Validation

                        Annotations:

                        • Validation (also known as a machine check) is where data is compared against specific criteria by the program. Examples of validation include Format, Type & Length Checks.
                        1. Verification

                          Annotations:

                          • Verification (Also known as Human Checks) includes methods such as double-entry (where data is entered twice into a system & then is compared to see if the data is correct)
                        Show full summary Hide full summary

                        0 comments

                        There are no comments, be the first and leave one below:

                        Similar

                        writing maintainable programs ocr computing AS
                        Ron Wabe
                        Validation and Verification
                        DonCabezas
                        Mind Map 1
                        matt_daniells
                        Business Studies Unit 2
                        tara.springate
                        Unit 1 - Electricity
                        Callum McClintock
                        Present Simple vs. Present Continuous
                        Marek Mazur
                        Biological Psychology - Stress
                        Gurdev Manchanda
                        Biology B2.3
                        Jade Allatt
                        Romeo + Juliet (Themes)
                        alexandra_m_
                        Science Unit 1 flashcards
                        bamoscato