Normalization on the fly

This paper describes a universal technique for data retrieval from a database file afflicted with repeating groups. The procedure relies on a generic "repeater" table which is joined to the unnormalized table. Though the physical data model may violate first normal form, the proposed technique produces a data view that overcomes that violation. The importance of this technique to the design and use of databases is demonstrated through an actual case study.