database table index as a card catalog in a library

Discipline

Databases

Form

Database Analogies

Attribution — Origin / Source

Collected by Martin Goodfellow — Hoffer, J. A., Ramesh, V., & Topi, H. (2015). Modern database management. 12 ed. Pearson.

Topic

Data storage and indexing

Domain

Anything else

Conceptual Advantage

Relates database index to real world students may be familiar with. Note: this is dated for new students

Mapping

SymbolConcept
index card catalog
file/entry in file book or other resource

Draws Attention To

what an index is used for

Details

Text

"Like a card catalog in a library, an index is a table that is used to determine in a file the loca- tion of records that satisfy some condition."

Alternate Versions

Tuple as an index card

Comments or Feedback?

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".

Create an Issue on GitHub