A method for generating a unified database includes receiving a structured set of data, where each set is made up of records having fields, aggregating values within a first field of the records, automatically applying a set of rules to the first field values to determine correlations among the first field values, calculating a confidence level regarding a label for the first field, providing the label to the first field, storing the first field values in the first field in the unified database, and receiving more information to increase the confidence level. A system for generating a clinical database and a method for using the database are also described.