Page 531 - Computer_Science_F5
P. 531
Computer Science 5. Implement a simple key-value 1. How might the use of databases
(d) Write queries to retrieve books
Revision Exercise 8
based on author and genre.
store using Redis by performing
in academic records management
FOR ONLINE READING ONLY
the following:
(a) Install and set up Redis on your align with broader trends in digital
transformation and information
local machine or use a cloud- technology?
based Redis service. 2. What is a Structured Query
(b) Define keys for storing data Language? Briefly explain how it
related to user sessions (such is used to interact with relational
as session IDs and user data). databases.
(c) Implement operations to set, 3. How does a NoSQL database differ
get, and delete key-value pairs. from a relational database in terms
(d) Test the key-value store by of data structure and flexibility?
storing and retrieving sample
data. 4. In what scenario might a NoSQL
6. Set up a Cassandra cluster and database be a better choice
compared to a traditional relational
perform basic operations by database?
implementing the following:
(a) Install Cassandra on a local 5. What is a data warehouse, and how
machine or use a cloud-based does it differ from a traditional
Cassandra service. database in terms of its purpose
(b) Create a keyspace named and data organisation?
“library” and define a table 6. Explain the challenges of big
“books” with columns for book data associated with collecting,
ID, title, author, and genre. managing, and analysing massive
(c) Insert sample data into the datasets.
“books” table. 7. Provide an example of how big
(d) Write CQL queries to retrieve data and data warehouses could be
books based on book ID and used in a specific industry (such as,
author. healthcare, finance, education, local
governments).
8. Identify any correlation between
Chapter Summary where the user is browsing from and
the specific actions they perform on
the website.
Reflect on what you have learnt from
this chapter, summarise and keep it in 9. Analyse the content of user
your portfolio. messages left on different website
522
for Advanced Secondary Schools
Computer Science Form 5.indd 522 23/07/2024 12:35

