Difficulty: Easy
Correct Answer: a secondary access path
Explanation:
Introduction / Context:
Before relational databases became dominant, many systems used navigational access. Records were linked with pointers embedded within the data, enabling applications to traverse related records efficiently. Understanding the role of these pointers clarifies the difference between navigational and set-based access models.
Given Data / Assumptions:
Concept / Approach:
Embedded pointers act as in-record links that create an additional, alternative route to reach related records—effectively a secondary access path. They do not themselves constitute a physical record key (that is an identifier for the record) and they are not equivalent to an inverted index, which is a separate structure mapping values to record locations.
Step-by-Step Solution:
Verification / Alternative check:
Descriptions of CODASYL/network databases emphasize set membership pointers as navigation channels distinct from key-based indexing.
Why Other Options Are Wrong:
Common Pitfalls:
Assuming pointers and indexes are interchangeable; confusing record identifiers with navigation links; overusing embedded pointers leading to rigid application logic.
Final Answer:
a secondary access path
Discussion & Comments