Page 498 - Computer_Science_F5
P. 498
filtering options and sorting Activity 8.18:
functionalities to refine your
queries. Data warehouse - building a mini
data warehouse
FOR ONLINE READING ONLY
Deliverables: Aim: Chapter Eight: Databases and Database Management Systems
Write a brief report detailing the steps To understand the basics of
taken, the functionalities explored, and data warehousing by designing,
your observations on the differences implementing, and analyzing a simple
between NoSQL and relational data warehouse using spreadsheet
databases. In this report include a software.
created database instance with relevant
collections and sample documents. Materials:
Also, examples of inserted, updated, 1. Computers with Internet access
and deleted documents. Examples of 2. Spreadsheet software (e.g.,
queries used to filter and retrieve data, Microsoft Excel)
along with the results should also be 3. Sample datasets (found online or
included. created for the activity)
Data warehouse Instructions:
A data warehouse is a specialized system Step 1: Design the schema
for analyzing large datasets, acting as a Plan what data you want to
central repository that gathers data from store and decide how you
various sources within an organisation. will organise it for efficient
Unlike traditional databases focused on querying and reporting.
current transactions, data warehouses Step 2: Collect data
are subject-oriented, organizing data Use provided sample datasets
around business subjects like marketing or gather data from various
or sales. They integrate and cleanse data sources to populate your data
to ensure consistency and accuracy. warehouse.
Storing structured, semi-structured, and Step 3: Perform an ETL (Extract,
unstructured data, data warehouses enable Transform, Load) Processes
historical trend analysis. Optimised for
reading and analysis, they support report Use spreadsheet software to
generation and complex data mining, clean your collected data.
improving decision-making, enhancing Transform the data into a
analytics, speeding up analysis, and consistent format and then
reducing the burden on operational load them into your designed
systems. schema.
489
Student’s Book Form Five
Computer Science Form 5.indd 489 23/07/2024 12:35
