Figure 2-1, Single-Record Case and Multi-Record Case Data Formats

This figure illustrates conversion of a single-record case (nontransactional) to multi-record case (transactional) format.

The figure shows two tables. The table on the left shows data in single-record case format. The table on the right shows the same data in multi-record case format.

The single-record case format table has columns that are named for the attributes ID, age, and income. There is one row for each record. The first record has data values ID = 1, age = 25, and income = 30K.

The multi-record case format table has three columns (multi-record case format tables always have these three columns): ID, attribute, and value. The first record of the single-record case table corresponds to the first three rows of the multi-record case table: ID = 1, attribute = age, value = 25. Row 2 has ID = 1, attribute = income, and value = 30K.

Note that in multi-record case format, all data values must be specified as the single data type NUMBER. This results from binning all values.

End of description.