Patent ID: 7840562

Claim:
A method for automatic database reconciliation comprising: (a) providing a logic model; (b) providing a first database and a second database, wherein the first database and the second database are logically related based on information contained in the logic model; (c) initiating a query to retrieve data at a level of detail, wherein the level of detail is a first level of detail; (d) responsive to the query, retrieving data from at least one data field corresponding to the level of detail in the first database and data from at least one data field corresponding to the level of detail in the second database; (e) comparing the data retrieved from the first database with the data retrieved from the second database; and (f) if a discrepancy exists in the results of the comparison: (i) updating the query to retrieve data such that the level of detail is a higher level of detail than in the previous query; and (ii) repeating steps (d) through (f) until one of: exhausting the next level of detail in the first database and in the second database; and satisfying a selected condition.