Granted Patent B2

US 8,321,407 · App. 12/370,690 · Granted Nov 27, 2012

Assignee: Panaya Ltd.

Abstract

Claims (16)

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.

2. The method of claim 1 , further comprising the steps of associating the combined repository with a first predefined amount of information from the less transaction refined impact analysis repository for a request to insert or delete a table record for tables that contain less than a second predefined amount of impacted transactions in the more transaction refined impact analysis repository; and associating the combined repository with a third predefined amount of information from the less transaction refined impact analysis repository for a request to update a table record for table columns that contain less than a fourth predefined amount of impacted transactions in the more transaction refined impact analysis repository.

3. A method for obtaining a combined impact analysis repository comprising:

accessing at least two impact analysis repositories comprising transactions and externally-visible output statements impacted in each transaction;

obtaining a statement-refinement index for each of the impact analysis repositories; and

obtaining a combined impact analysis repository by associating, for each transaction impacted by a predefined change request, the externally-visible output statements with the impacted transactions from the more statement-refined impact analysis repository;

wherein the step of obtaining the statement-refinement indices for the impact analysis repositories comprises calculating the statement-refinement index for the impact analysis repositories by comparing the average number of externally-visible output statements per transaction in each of the impact analysis repositories;

wherein the predefined change request is a request to update, insert, or delete a table record and the step of obtaining the statement-refinement indices for the impact analysis repositories comprises calculating the statement-refinement index for the impact analysis repositories by comparing the average number of externally-visible output statements, per each transaction, affected by the requests to update, insert, or delete a table record, in each of the impact analysis repositories.

4. The method of claim 3 , further comprising the step of receiving user feedback about the accuracy of the combined impact analysis repository.

5. The method of claim 4 , further comprising the step of utilizing the received user feedback for improving the statement-refinement index.

Assignments (8)

Continuity (2)