DATABASE NORMALIZING SYSTEM

A database normalizing system for transparently normalizing a record source in a database wherein the record source contains a plurality of records and each of the records contains at least one field that is common across each of the records. The database normalizing system includes evaluating data from the record source and suggesting a relational split of the record source in response to evaluating the data therein. Evaluating the data further includes generating a hierarchy of fields organized by field distinctiveness of each field in the record source, adjusting the hierarchy based on field distinctiveness, and promoting fields among levels of the hierarchy based on a data correlation among the fields in each level of the hierarchy.