HIERARCHICAL CHARACTERIZATION OF FIELDS FROM MULTIPLE TABLES WITH ONE-TO-MANY RELATIONS FOR COMPREHENSIVE DATA MINING

摘要

A method, system, and article of manufacture for transforming a relational database (205) having a hierarchical parent-child structure (110) into a flat database (160) more amedable to conventional data mining techniques. Generate a hierarchical data tree based on a relational data model. Peform a bottom-up summarization starting from the children and proceding to the next higher level. Append to parent records new fields summarizing the contents of child records associated therewith. Also a computer system comprising means for performing these functions.