CCEA A-Level Digital Technology 2650
Systems Analysis and Development Approaches
Design, Development and Testing
Implementation and System Security
Programming
Data, Information and Data Representation
Computer Architecture and Processing Systems
System Software, Application Software and the User Interface
Web Technology and Multimedia
Networks
Databases
Artificial Intelligence, Expert Systems and Robotics
Mobile Technology, Data Mining and Cloud Computing
Individual, Social and Legal Considerations
The Development Project: Analysis and Design
The Development Project: Build, Testing and Evaluation
Mobile Technology, Data Mining and Cloud Computing
Gathering and storing data for mining
- 3 things to know
- A2 Unit 1
Overview
Five sources from which an organisation gathers data for mining, clickstream data and data warehouse.
What you need to know
Answer each one before you reveal it.
Distinguish structured from unstructured data.
Name five sources from which an organisation gathers data for mining.
Questions from this subtopic
Each one with the model answer underneath.
- 1
Name five sources from which an organisation gathers data for mining.
Model answer
Organisations gather data from till and online transactions, loyalty schemes, website clickstreams, customer service records and sensor or device readings.
- 2
What does a loyalty scheme add to the data a retailer holds?
Model answer
A loyalty scheme links every purchase to one identified customer, so a retailer can analyse an individual's buying history over several years instead of a series of unconnected baskets.
- 3
What is clickstream data, and what does it reveal?
Model answer
Clickstream data records every page a visitor viewed, the order they viewed them in and how long they stayed, which shows where customers hesitate and at what point they abandon a purchase.
- 4
Why is mining not run directly against an organisation's transaction processing system?
Model answer
A transaction processing system is designed for fast individual updates and is needed continuously for trading, so running heavy analytical queries against it would slow the operational service.
- 5
What is a data warehouse?
Model answer
A data warehouse is a large separate store holding data copied from many operational systems, organised for analysis and keeping years of history rather than only current records.
- 6
Describe the extract, transform and load process.
Model answer
Extract, transform and load pulls data out of the source systems, converts it into a single consistent format with common codes and units, and loads it into the warehouse on a regular schedule.
Other ways to work this
The same content, four other ways.
What is inside Levo
Six ways to work the same material.
Every question in Mobile Technology, Data Mining and Cloud Computing, on a schedule.
Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.
Or £46 a year, about £3.83 a month. Cancel anytime.