IP Library Granted Patent US 7,792,950
Granted Patent B2
US 7,792,950 · App. 10/255,484 · Granted Sep 7, 2010

Coverage analysis of program code that accesses a database

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 7,792,950
App. No.
10/255,484
Granted
Sep 7, 2010
Kind
B2
Abstract

An apparatus, program product and method collect operational statistics associated with database access by a computer program for use in performing coverage analysis on the program. In particular, coverage analysis may be performed for a computer program that accesses a database by tracking accesses to records in the database by the computer program during coverage analysis, and calculating at least one database coverage statistic based upon the tracked accesses to the records in the database.

Claims (17)

1. A method of performing coverage analysis for a computer program that accesses a database, the method comprising:

tracking accesses to records in the database by the computer program during coverage analysis, wherein tracking accesses to the records in the database includes receiving a database operation from the computer program, executing the database operation in the database, and collecting statistics associated with the database operation during execution of the database operation; and

calculating at least one database coverage statistic based upon the tracked accesses to the records in the database.

2. The method of claim 1 , wherein calculating the database coverage statistic comprises determining a percentage of records in a database file that are accessed during coverage analysis.

3. The method of claim 1 , wherein calculating the database coverage statistic comprises determining a database coverage statistic associated with a predetermined portion of the computer program.

4. The method of claim 3 , wherein determining a database coverage statistic associated with a predetermined portion of the computer program comprises determining a database coverage statistic associated with a program entity in the computer program, wherein the program entity is selected from the group consisting of a query, a statement, a method, a class, an object, and combinations thereof.

5. The method of claim 4 , further comprising receiving user input to map a selected program entity to a selected file in the database, wherein calculating the database coverage statistic includes calculating a database coverage statistic that is associated with the selected program entity and the selected file.

6. The method of claim 1 , wherein calculating the database coverage statistic comprises determining a database coverage statistic associated with a predetermined file in the database.

7. The method of claim 6 , wherein calculating the database coverage statistic comprises determining a plurality of database coverage statistics, each database coverage statistic associated with at least one of a predetermined portion of the computer program and a predetermined file in the database, wherein at least one of the plurality of database coverage statistics is associated with both a predetermined portion of the computer program and a predetermined file in the database.

8. The method of claim 1 , wherein calculating the database coverage statistic includes determining a database coverage statistic associated with at least one field of the database, wherein the database coverage statistic associated with the at least one field of the database is selected from the group consisting of a minimum field value, a maximum field value, an average field value, and combinations thereof.

9. The method of claim 1 , further comprising determining at least one attribute of the database, wherein calculating the database coverage statistic includes determining a database coverage statistic associated with the attribute of the database.

10. The method of claim 9 , wherein determining the attribute of the database includes accessing metadata associated with the database.

11. The method of claim 9 , wherein the attribute comprises a null capability of at least one field in the database, and wherein determining the database coverage statistic associated with the attribute of the database includes determining whether the null capability of the field in the database was tested during coverage analysis.

12. The method of claim 9 , wherein determining the attribute of the database includes executing a query on the database.

13. The method of claim 9 , wherein the attribute comprises a constraint on at least one a field in the database, and wherein determining the database coverage statistic associated with the attribute of the database includes determining whether the field constraint was attempted to be violated during coverage analysis.

14. The method of claim 13 , wherein the constraint is selected from the group consisting of a data type, a minimum value, a maximum value, a null capability, an enumeration, and combinations thereof.

15. The method of claim 9 , wherein the attribute comprises a referential constraint on the database, and wherein determining the database coverage statistic associated with the attribute of the database includes determining whether the referential constraint was attempted to be violated during coverage analysis.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 13, 2015
From: INTERNATIONAL BUSINESS MACHINES CORPORATION
To: LINKEDIN CORPORATION
Reel/Frame 035201/0479 →