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 02/12/2015.
welhamnathan
Mind Map by welhamnathan, updated more than 1 year ago
welhamnathan
Created by welhamnathan over 10 years ago
4
1

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

                        Similar

                        XOR Gates - Computing AS
                        mirandamolloy
                        writing maintainable programs ocr computing AS
                        Ron Wabe
                        Validation and Verification
                        DonCabezas
                        Geometry Formulas
                        Selam H
                        Application of technology in learning
                        Jeff Wall
                        The SAT Test
                        philip.ellis
                        Chemistry Regents - Bonding Theories and Polar Bonds Notes
                        Ali Kane
                        PSBD TEST # 3
                        Suleman Shah
                        GCSE Maths: Algebra & Number Quiz
                        Andrea Leyden
                        An Timpeallacht (Foclóir)
                        Sarah Egan
                        1.11 Core Textiles
                        T Andrews