Database Storage, Indexing and Query Processing

Start with the maps

The mind maps offer a way to get oriented before trying a quiz. The Query Processing mind map covers parsing, translation, optimization and evaluation. It includes checks on syntax and the translation of a query into an internal form. The Query map also includes evaluation plans, join ordering, materialized evaluation and pipelining.

For a different starting point, the Database Files mind maps describe files as stores of data and include serial files and unstructured data streams. Use their headings to organize the terms you want to study.

Practice with a quiz

After looking at a map, try the Query Processing quiz. Its questions include the data cache and what a DBMS does when there is no index. The quiz on database performance tuning and query optimization also asks about timely answers and factors affecting performance. The multiple-choice quiz on the same chapter considers generating a SQL query with the correct answer while using minimal time and server resources.

Use the maps alongside the questions: check which terms you recognize, then return to the relevant map to study the connections. The quiz on query processing and the Query map provide a useful pairing for work on evaluation and optimization.

Connect the resources

This topic is a section of Database Concepts and DBMS Fundamentals in Databases and data science. The notes created from a mind map provide another way to move between ideas on the page. They cover physical data organization and query processing in relational DBMS, as well as database storage models, secondary storage organization and heap files.

Compare the notes with the Database Files maps, then return to a query processing resource. Choose a map and a quiz to use together as you study.