Patent ID: 7865461

Claim:
A method of cleansing a plurality of enterprise databases comprising: extracting data from a plurality enterprise databases; extracting reference data from a most-trusted database, the reference data being associated with resources in a service provider network; generating at least one of a cross-reference table and mapping information from metadata associated with the reference data extracted from the enterprise database and metadata associated with data extracted from the most-trusted database; accumulating the data extracted from the plurality of enterprise databases and the reference data extracted from the most-trusted database in an aggregate extracted database, from which discords are determined, the aggregate extracted database being independent of the plurality of enterprise databases and the most-trusted database; formatting the data extracted from the plurality of enterprise databases in a specified format; determining discords between the data extracted from the plurality of enterprise databases and the reference data extracted from the most-trusted database in accordance with a set of rules, the determining using the reference data extracted from the most-trusted database as a reference against which the data extracted from the enterprise database is verified; determining discords between the data extracted from the plurality of enterprise databases and industry standard data from an industry standard database, the data extracted from the plurality of enterprise databases being verified against the industry standard data of the industry standard database; determining whether at least one of the discords requires manual intervention or whether an automatic system correction process is configured to automatically correct the discords; modifying the data extracted from the plurality of enterprise databases automatically based on the discords and in response to a determination that the automatic system correction process is configured to automatically correct the discords; reformatting the data extracted from the enterprise database to an original format after modifying the data based on the discords; and storing the modified data in the plurality of enterprise databases.