IP Library Granted Patent US 8,700,606
Granted Patent B2
US 8,700,606 · App. 13/651,419 · Granted Apr 15, 2014

Methods for calculating a combined impact analysis repository

Inventors: Yossi Cohen (Raanana, IL); Mati Cohen (Raanana, IL); Nurit Dor (Raanana, IL); Dror Weiss (Netanya, IL); Roy Armoni (Givat Ada, IL)
Assignee: Panaya Ltd.
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,700,606
App. No.
13/651,419
Granted
Apr 15, 2014
Kind
B2
Abstract

Methods for accessing impact analysis repositories and transaction-refinement index for each of the impact analysis repositories. According to the obtained transaction-refinement index, associating the combined repository with information from the most transaction refined impact analysis repository. 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.

Claims (9)

1. A method comprising: accessing at least two impact analysis repositories comprising transactions; obtaining a transaction-refinement index for each of the impact analysis repositories; according to the obtained transaction-refinement index, associating the combined repository with information from the most 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 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.

2. The method of claim 1 , 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.

3. 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.

4. A method 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.

5. The method of claim 4 , 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.

6. The method of claim 4 , wherein the predefined change request is a request to update 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 a table record, in each of the impact analysis repositories.

7. The method of claim 4 , wherein the predefined change request is a request to 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 insert or delete a table record, in each of the impact analysis repositories.

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

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

Assignments (3)
RELEASE OF SECURITY INTEREST Recorded Apr 2, 2015
From: KREOS CAPITAL IV (EXPERT FUND) LIMITED
To: PANAYA LTD.
Reel/Frame 035324/0980 →
SECURITY INTEREST Recorded Aug 25, 2014
From: PANAYA LTD.
To: KREOS CAPITAL IV (EXPERT FUND) LIMITED
Reel/Frame 033597/0914 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 14, 2012
From: COHEN, YOSSI; COHEN, MATI; DOR, NURIT; WEISS, DROR; ARMONI, ROY
To: PANAYA LTD.
Reel/Frame 029124/0618 →
Continuity (3)
Continuation 12370690 · Feb 13, 2009
Provisional Application 61030969 · Feb 24, 2008
Related Publication 20130041886A1 · Feb 14, 2013