8.1. The DB2 Storage Model: The Big Picture
This section provides an overview of the DB2 storage model. In Figure 8.1 you can see the interaction between the different database objects as they relate to the DB2 storage model. This figure presents a combination of physical and logical views of the primary database objects.
Figure 8.1 illustrates a user retrieving some data from the table t2. From this user's perspective, the information he needs is stored in a table, and how and where it is stored on disk is irrelevant. When this user issues the SQL statement:
SELECT ProdId FROM ...Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
