System and method for imputing data into a database

A method for imputing data into a database, the method comprising:

• examining a plurality of distribution records, each distribution record associated with one of a plurality of cable pairs and each of the cable pairs associated with a serving terminal;
• determining if the distribution record associated with a desired cable pair includes missing data;
• searching the serving terminals not associated with the desired cable pair for a complete distribution record associated with the desired cable pair;
• iteratively searching a binder group for one or more complete distribution records, the binder group having a size and the binder group size increasing with each iterative search;
• and
• determining an imputed value for the missing data for the distribution record associated with the desired cable pair based on the searching of the serving terminals and the binder group.

A system for imputing missing data into a database, the system comprising:

• an inventory database including a plurality of distribution records each associated with one of a plurality of cable pairs;
• a data engine associated with the inventory database, the data engine operable to determine if a desired distribution record associated with a desired cable pair includes missing data;
• a search engine associated with the data engine, the search engine operable to iteratively search a sized binder group within the inventory database for one or more complete distribution records, the size of the binder group increasing with each iterative search;
• and
• a loop engine associated with the search engine, the loop engine operable to determine a value for the desired distribution record based on the searching and impute the value into the desired distribution record.