Patent ID: 8321407
Filing Date: 2012-11-27
Classification: G06F

Abstract:
1. A method for calculating a combined impact analysis repository comprising: accessing at least two impact analysis repositories comprising transactions; obtaining a transaction-refinement index for each of the impact analysis repositories; associating the combined repository with information from the most transaction refined impact analysis repository according to the obtained transaction-refinement index; associating the combined repository with information from the less transaction refined impact analysis repository in the case of a request to insert or delete a table record for tables that do not contain any impacted transaction in the more transaction refined impact analysis repository; and associating the combined repository with information from the less transaction refined impact analysis repository in the case of a request to update a table record for table columns that do not contain any impacted transaction in the more transaction refined impact analysis repository; wherein the step of obtaining the transaction-refinement index comprises calculating the transaction-refinement index by comparing the average number of impacted transactions per at least one of the following: database column for requests to update table records, or database table for request to insert or delete table records.