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
   526   527   528   529   530   531   532   533   534   535   536