Denormalization with WebFocus 7

The process of denormalization of relationships when creating table groups for data stores is of course a trade off between understandability and ease of use of the data store schemas for reporting and analysis and redundancy of data. WebFocus 7 is a product I have found to be very useful in such planning and implementation. The Metadata facilities help group all involved tables in a view to be denormalized into a single paradigm, collapsible by relation and key references which makes the process intuitive when reducing levels of keys in denormalizing relations.

Denormalilzation is never an effortless process and of course, always requires good knowledge of the elements. WebFocus 7 also provides a good programming language(Modify) to move data into the denormalized data store tables. A nifty feature in WebFocus 7 is the ability to quickly see data samples just by clicking on an Metadata construct.