Page 496 - Computer_Science_F5

Step 2: Manipulate Data with SQL (b) Key-value stores: Efficiently link
Write SQL queries to retrieve and unique keys with values, great for
simple data retrieval such as shopping
manipulate data within the library cart items.
database. This includes querying
specific genres of books, retrieving loan (c) Wide-column stores: Handle large Chapter Eight: Databases and Database Management Systems
FOR ONLINE READING ONLY
information for individual students, datasets with variable structures, often
and identifying overdue books based for analytics workloads like sensor data
on defined criteria. and financial transactions.
(d) Graph databases represent data as
Deliverables: graphs, comprising nodes, edges, and
Write a summarized report including properties. Nodes represent entities,
a well-defined database schema for a edges depict relationships between
school library database, with tables for nodes, and properties provide additional
books, members, and loans, having information about nodes and edges.
appropriate attributes and data types These databases are optimal for
specified; An implemented database managing highly interconnected data,
created using the online database offering flexibility and performance
simulation tool, populated with sample advantages for scenarios such as social
networks and recommendation engines.
data (books, members, loans); Various
SQL queries written and executed using On the other hand, NoSQL databases
the online tool to retrieve specific are designed for handling large,
information from the database, such dynamic datasets that are unstructured
as books by genre, loans by student, or semi-structured. They excel in
environments requiring scalability and
and identification of overdue books. schema flexibility but may encounter
Document your work in a portifolio.
challenges with data consistency due
to their distributed nature and eventual

Non-relational (NoSQL) databases consistency models.
NoSQL databases, unlike relational In contrast, traditional relational
ones, offer flexible schemas and support databases efficiently manage structured,
various data formats like documents, relatively static datasets using SQL
key-value pairs, and graphs. They do queries. They prioritize data integrity
not enforce strict relationships between and consistency, making them ideal for
data points. There are different types of transactional applications like banking
NoSQL databases. and e-commerce, typically hosted on

(a) Document databases: Ideal for semi- centralized servers.
structured data like user profiles, storing Big data technologies address the
data in JSON-like documents. shortcomings of traditional databases

487
Student’s Book Form Five

Computer Science Form 5.indd 487 23/07/2024 12:35