Year 11 - Computing
Big data
Databases and SQL
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.
Lesson Summary
You will learn to explain what big data is and describe the challenges it creates for processing and storage.
Key Notes
- Big data refers to extremely large and complex sets of data that are generated at high speed and come in many formats.
- It is often categorised using the 3 Vs: volume, variety, and velocity.
- Storing big data is difficult and often needs cloud systems.
- Processing big data takes a lot of time and computing power.
- Big data raises security and privacy concerns due to the amount of personal data.
Vocabulary To Learn
- big data: data that is too large and complex to be dealt with by traditional processing methods and systems
- volume: the total amount of data stored, processed, and transmitted, typically measured in bytes
- variety: the diverse range of data types and formats
- velocity: the speed at which data is created, processed, and analysed
Common Mistakes To Avoid
- Big data can be stored in normal data strcutures like relational databases.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
Big data refers to extremely large and complex sets of data that are generated at high speed and come in many formats. It is often categorised using the 3 Vs: volume, variety, and velocity.
2. Define this computing term and give one practical example. 'big data'
data that is too large and complex to be dealt with by traditional processing methods and systems. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Big data can be stored in normal data strcutures like relational databases. Correction: Big data is mostly unstructured, so it doesn't fit the row-and-column format of relational databases.
More Lessons In This Unit
Browse all guides in the Year 11 Computing guide library.