Page 488 - Computer_Science_F5
P. 488
searching for information in the Activity 8.12:
second book.
4. Compare the functionality of a book Exploring query optimization in
index with indexes in databases, database management
FOR ONLINE READING ONLY
highlighting similarities and Aim: Chapter Eight: Databases and Database Management Systems
differences. To develop efficient strategies for
optimizing database queries to retrieve
Deliverables: specific information effectively.
A comparison report detailing the
experience of searching for information Materials:
in both books, such that: Explanation of Set of physical data cards (used in
the search process in the book without previous activities), complex questions
an index; Description of the search or queries related to the dataset.
process in the book with an index; and Instructions
Discussion on how the presence of an Use the following steps to optimise
index affected the speed and ease of the dataset and answer questions that
searching information. Document all follows at the end of activity.
your work in a portifolio. Step 1: Prepare a set of complex
questions or queries using the
data cards from the previous
Another example of index in the context activity.
of a school environment in Library. Step 2: Plan different strategies,
You can imagine an index in your including approaches like
school library that lets you quickly find filtering, sorting, or utilizing
any book, that will be similar to index indexes, to accelerate finding
in database. Likewise, databases use answers.
indexes to speed up the data search. Step 3: Choose and implement
your preferred approach or
Query Optimization combination of approaches
Query optimization is the process used to answer the questions
by DBMS to find the most efficient way effectively.
to execute a query. Given a query, there Step 4: Execute and refine your
might be multiple ways to retrieve the queries based on the strategies
required data. The DBMS evaluates chosen.
these possibilities and chooses the
path that uses the least resources or the Questions
shortest time. It involves decisions like 1. Describe the strategy(s) or approach
which index to use or in what order to you selected and discuss any
join tables. challenges encountered.
479
Student’s Book Form Five
Computer Science Form 5.indd 479 23/07/2024 12:35
