Bitmaps (File architecture): Difference between revisions

From m204wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 17: Line 17:
</ul>
</ul>


And, for [[Table E non x'100' (File architecture)|Table E non FILEORG x'100']] files, large object available pages are tracked as well.
And, for [[Table E and non-FILEORG X'100' files (File architecture)|Table E non FILEORG X'100']] files, large object available pages are tracked as well.


==Manipulating bitmaps==
==Manipulating bitmaps==

Revision as of 00:29, 28 January 2014

A bitmap, as the name implies, is a series of "on" and "off" bits which are used to track a condition. These maps are used extensively throughout Model 204 to track sets of records or pages.

The workings of a bitmap

The page size in Model 204 of 6184 bytes contains 6144 "usable" bytes (along with its 40 byte trailer). As such, conditions of up to 49152 "things" (usually records but also pages) can be tracked on a single page.

Usages

The most common use of bitmaps in Model 204 is to track sets of records:

  • Bitmaps track records inside both indexing types (hash and B-tree).
  • The existence bitmap tracks which internal record numbers are in use.
  • During procedure execution, all found sets are held as bitmaps.

And, for Table E non FILEORG X'100' files, large object available pages are tracked as well.

Manipulating bitmaps

Once conditions are represented as bitmaps, the manipulation ("ANDing" and "ORing") of these sets is straightforward and efficient:

In code that has a Find such as:

X: In filename FD COLOR = 'BLUE' STATE = 'NY' ...

What is happening (given the implied "AND") is that the sets of records for each criteria are retrieved, and then "ANDed" (any bits "on" on both, are "on" on the resultant bitmap associated with the label X.

Example

In this example (which looks at a bitmap as used by an index), this is the beginning of the bitmap representing the ORD CHAR field value pair COLOR = BLUE for the 3rd segment of a file (which covers IRNs 98304 to 147455):

Based on this, record 98304 does not have an occurrence of COLOR = BLUE, but records 98305 and 98306 do... and so on.