Automatically creating handling strategy rules for a normalized question record

A system for automatically creating one or more handling strategy rules for a normalized question record, the system comprising:

• a computer readable medium having instructions stored there on, which, when executed by a processor, cause the system to:
• determine an expected format of an answer to a normalized question stored in the normalized question record;
• determine one or more expected features of an answer to the normalized question stored in the normalized question record;
• check a list of fields in one or more available database to determine if any fields match the expected format of the answer and the expected features of the answer;
• in response to a determination that a first field in a first database matches the expected format of the answer and the expected features of the answer:
• create a data retrieval rule identifying the first field in the first database;
• store the data retrieval rule in a handling strategy field of the normalized question record;
• determine if one or more data transformation rules should be created for the normalized question record by comparing formatting aspects of the first field in the first database and the expected format of the answer to the normalized question stored in the normalized question record;
• and
• in response to a determination that one or more data transformation rules should be created, create one or more data transformation rules to alter one or more formatting aspects of the first field in the first database to match the expected format of the answer, and store the one or more data transformation rules in the handling strategy field of the normalized question record.

A non-transitory machine-readable storage medium for automatically creating one or more handling strategy rules for a normalized question record, comprising instructions, which when implemented by one or more machines, cause the one or more machines to perform operations comprising:

• determining an expected format of an answer to a normalized question stored in the normalized question record;
• determining one or more expected features of an answer to the normalized question stored in the normalized question record;
• checking a list of fields in one or more available database to determine if any fields match the expected format of the answer and the expected features of the answer;
• in response to a determination that a first field in a first database matches the expected format of the answer and the expected features of the answer:
• creating a data retrieval rule identifying the first field in the first database;
• storing the data retrieval rule in a handling strategy field of the normalized question record;
• determining if one or more data transformation rules should be created for the normalized question record by comparing formatting aspects of the first field in the first database and the expected format of the answer to the normalized question stored in the normalized question record;
• and
• in response to a determination that one or more data transformation rules should be created, creating one or more data transformation rules to alter one or more formatting aspects of the first field in the first database to match the expected format of the answer, and storing the one or more data transformation rules in the handling strategy field of the normalized question record.