week 5

Data formats:

• file-based structure:

o data held within one file

o consistent set of attributes, data types and validation

o context is held within the file

o data is referenced within the file

o data stored in flat file format

• directory-based structure:

o data held across multiple files

o contains multiple attributes, data types and validation

o context held within the file and the structure

o relational data is referenced across multiple files

o datasets are extracted from system and filtered

o data can be structured in a hierarchy system

o allows multiple data owners and sources

• relational database systems:

o data organised using normalisation to reduce redundancy

o data connect by relationships

o structured query language (SQL)/data processing language

o server-client implementation

Importance for analysis:

• easier to query

• easier to keep up to date

• supports with drawing conclusions

• allows sharing of data

Last Updated
2023-03-29 12:25:37