Data selection

• US 9,098,630 B2
• Filed: 03/11/2013
• Issued: 08/04/2015
• Est. Priority Date: 07/10/2012
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Funke, Florian, Gerstl, Peter, Haischt, Daniel S.
• Primary Examiner(s): Dao, Thuy
• Assistant Examiner(s): Luu, Cuong V
• Application Number:
  US13/792,731
• Publication Number:
  US 20140019941A1
• Time in Patent Office: 876 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3672 Test management
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/0489 using dedicated keyboard keys or combinations thereof
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

In an exemplary embodiment of this disclosure, a data selection method may include receiving first data representative of program code having a plurality of database operations. Second data is generated and is representative of a sequence of operations encounterable in an execution of the program code, where the sequence of operations includes at least one of the database operations. A third data is selected from a database, by using the second data.

Claims

1. A computer-implemented data selection method comprising:

receiving first data representative of program code comprising a plurality of database operations to be performed on a database;

generating, by a computer processor, second data representative of a sequence of operations encounterable in an execution of the program code, the sequence of operations comprising at least one of the database operations;

determining a set of operands operated on by the sequence of operations encounterable in the execution of the program code;

selecting third data from the database, wherein the third data comprises a randomly selected subset of the set of operands operated on by the sequence of operations encounterable in the execution of the program code;

executing the sequence of operations using the selected third data as an operand for the at least one of the database operations;

establishing an entry point into said program code;

generating fourth data representative of each sequence of operations encounterable in the execution of said program code starting from said entry point;

wherein generating said second data comprises selecting said second data from said fourth data;

establishing, for a parameter used in an operation belonging to a first sequence of operations represented by said fourth data, a value of said parameter at said entry point; and

establishing, using said value, a collection of values of said parameter encounterable in an execution of at least one of said first sequence of operations represented by said fourth data to which said operation belongs;

wherein selecting said third data uses said collection of values.

2. The method of claim 1, further comprising:

receiving fifth data representative of at least one of a structure of data of said database and a relationship between data of said database;

wherein selecting said third data uses said fifth data.

3. The method of claim 1, further comprising:

executing said sequence of operations using no more data of said database as an operand for said at least one of said database operations than said selected third data.

4. A data selection system comprising:

a data receiver configured to receive first data representative of program code comprising a plurality of database operations to be performed on a database;

a data generator configured to generate, by a computer processor of the data selection system, second data representative of a sequence of operations encounterable in an execution of the program code, the sequence of operations comprising at least one of the database operations;

a data selector configured to determine a set of operands operated on by the sequence of operations encounterable in the execution of the program code, and to select third data from the database, wherein the third data comprises a randomly selected subset of the set of operands operated on by the sequence of operations encounterable in the execution of the program code;

an operation sequence executor configured to execute the sequence of operations using the selected third data as an operand for the at least one of the database operations;

an entry point establisher configured to establish an entry point into said program code;

wherein said data generator generates fourth data representative of each sequence of operations encounterable in execution of said program code starting from said entry point;

wherein said generating of second data comprises selecting said second data from said fourth data;

a value establisher configured to establish, for a parameter used in an operation belonging to a first sequence of operations represented by said fourth data, a value of said parameter at said entry point; and

a collection establisher configured to establish, using said value, a collection of values of said parameter encounterable in an execution of at least one of said first sequence of operations represented by said fourth data to which said operation belongs;

wherein said data selector uses said collection of values for said selection of third data.

5. The system of claim 4, wherein:

said data receiver receives fifth data representative of at least one of a structure of data of said database and a relationship between data of said database; and

said data selector uses said fifth data for said selection of third data.

6. The system of claim 4, further comprising:

an operation sequence executor configured to execute said sequence of operations using no more data of said database as an operand for said at least one of said database operations than said selected third data.

7. A computer program product comprising a non-transitory computer readable storage medium having computer readable program code embodied thereon, the computer readable program code executable by a processor to perform a method comprising:

receiving first data representative of program code comprising a plurality of database operations to be performed on a database;

generating second data representative of a sequence of operations encounterable in an execution of the program code, the sequence of operations comprising at least one of the database operations;

determining a set of operands operated on by the sequence of operations encounterable in the execution of the program code;

selecting third data from the database, wherein the third data comprises a randomly selected subset of the set of operands operated on by the sequence of operations encounterable in the execution of the program code;

executing the sequence of operations using the selected third data as an operand for the at least one of the database operations;

establishing an entry point into said program code;

generating fourth data representative of each sequence of operations encounterable in the execution of said program code starting from said entry point;

wherein generating said second data comprises selecting said second data from said fourth data;

establishing, for a parameter used in an operation belonging to a first sequence of operations represented by said fourth data, a value of said parameter at said entry point; and

establishing, using said value, a collection of values of said parameter encounterable in an execution of at least one of said first sequence of operations represented by said fourth data to which said operation belongs;

wherein selecting said third data uses said collection of values.

8. The computer program product of claim 7, the method further comprising:

executing said sequence of operations using no more data of said database as an operand for said at least one of said database operations than said selected third data.

9. The computer program product of claim 7, the method further comprising:

receiving fifth data representative of at least one of a structure of data of said database and a relationship between data of said database;

wherein selecting said third data uses said fifth data.