Query processing steps in DBMS Theory - Mini Project: Build & Apply

Query Processing Steps in DBMS

📖 Scenario: You are learning how a database system processes a query to get the desired data. Understanding these steps helps you know what happens behind the scenes when you ask a question to a database.

🎯 Goal: Build a simple list of the main query processing steps in order, with a helper variable to track the current step, and then create a summary string that shows the full process.

📋 What You'll Learn

Create a list called query_steps with the exact steps: 'Parsing and translation', 'Optimization', 'Evaluation', 'Execution'

Create a variable called current_step and set it to 0

Use a loop with variable step to go through query_steps and build a list called processed_steps with strings like 'Step 1: Parsing and translation'

Create a final string called summary that joins all processed_steps with commas

💡 Why This Matters

🌍 Real World

Understanding query processing helps database users and developers optimize queries and troubleshoot performance issues.

💼 Career

Database administrators and developers need to know these steps to write efficient queries and maintain database systems.

1

Create the list of query processing steps

Create a list called query_steps with these exact strings in order: 'Parsing and translation', 'Optimization', 'Evaluation', 'Execution'

DBMS Theory

# Create the list query_steps with the four exact steps
# Your code here

Need a hint?

Use square brackets [] to create a list and put the steps as strings inside quotes.

2

Add a variable to track the current step

Create a variable called current_step and set it to 0 to start counting from the first step

DBMS Theory

query_steps = ['Parsing and translation', 'Optimization', 'Evaluation', 'Execution']
# Create current_step variable and set it to 0
# Your code here

Need a hint?

Just assign the number zero to the variable current_step.

3

Build a list of processed step descriptions

Use a for loop with variable step to go through query_steps and create a new list called processed_steps. Each item should be a string like 'Step 1: Parsing and translation', increasing the step number by 1 each time.

DBMS Theory

query_steps = ['Parsing and translation', 'Optimization', 'Evaluation', 'Execution']
current_step = 0
# Create processed_steps list and fill it with step descriptions using a for loop
# Your code here

Need a hint?

Start with an empty list, then add formatted strings inside the loop, increasing current_step each time.

4

Create a summary string of all steps

Create a string variable called summary that joins all items in processed_steps into one string separated by commas.

DBMS Theory

query_steps = ['Parsing and translation', 'Optimization', 'Evaluation', 'Execution']
current_step = 0
processed_steps = []
for step in query_steps:
    current_step += 1
    processed_steps.append(f'Step {current_step}: {step}')
# Create summary string by joining processed_steps with commas
# Your code here

Need a hint?

Use the join method on a comma and space string to combine the list into one string.