Databases
Database Analogies
Collected by Xiaoying Tu — DeBarros, A. (2018). Practical SQL: A Beginner's Guide to Storytelling with Data. USA: No Starch Press.
Data storage and indexing
Anything else
Helps readers get a high-level idea of what indexing is and how it can help speeding up queries
| Symbol | Concept |
|---|---|
| Database table indexing | a book's index |
The advantage of indexing in speeding up queries
"In the same way that a book’s index helps you find information more quickly, you can speed up queries by adding an index to one or more columns."
Do you have feedback on this notional machine? Did you find a mistake, or do you have a request for improvement? You can create an Issue on GitHub, where the description is hosted. This way we can see your feedback and address it.
For this, you need a GitHub account. Then follow this link to see the source file of this page. In there, click the ... left of the highlighted line, then pick "Reference in a new issue".
A notional machine is a pedagogic device to assist the understanding of some aspect of programs or programming. To something along the lines of A notional machine is a pedagogical tool designed to support the understanding of programs, programming, and other aspects of computing such as databases.
