Data records selection

Patent metadata

Field	Value
Publication number	US-11163670-B2
Application number	US-201916362964-A
Country	US
Kind code	B2
Filing date	Mar 25, 2019
Priority date	Feb 1, 2013
Publication date	Nov 2, 2021
Grant date	Nov 2, 2021

Abstract

A computer-implemented method includes accessing a plurality of data records, each data record having a plurality of data fields. The method further includes analyzing values for one or more of the data fields for at least some of the plurality of data records and generating a profile of the plurality of data records based on the analyzing. The method further includes formulating at least one subsetting rule based on the profile; and selecting a subset of data records from the plurality of data records based on the at least one subsetting rule.

First claim

What is claimed is:

1. A computer-implemented method for selecting data records to cause a processing rule to be triggered during testing of a data processing application, the method including:
processing in a data processing system a first set of data records using a data processing application that includes a set of processing rules, wherein whether the set of processing rules is triggered during processing of a particular data record depends directly or indirectly on a value in each of one or more data fields of the particular data record;
receiving information indicative of a number of times the set of processing rules was triggered in connection with processing of the first set of data records;
characterizing values in one or more data fields of each data record in a second set of data records;
determining an identification criterion that identifies a particular one of the data fields of the data records in the second set as a target data field, the identification criterion being based on (i) the characterization of the values in the one or more data fields of each of the data records in the second set and (ii) the information indicative of the number of times the set of processing rules was triggered in connection with processing the first set of data records;
applying the identification criterion to select one or more data records from the second set of data records based on values in the target data field; and
processing the selected one or more data records using the data processing application.

2. The method of claim 1 , wherein there are multiple distinct values in the target data field across the data records in the second set, and wherein selecting one or more data records from the second set of data records includes selecting at least one data record having each of the distinct values in the target data field.

3. The method of claim 1 , wherein the target data field is a first target data field, and including identifying a second particular one of the data fields of the data records in the second set as a second target data field.

4. The method of claim 3 , wherein selecting one or more data records from the second set of data records includes selecting the data records based on a combination of values in the first target data field and values in the second target data field.

5. The method of claim 1 , wherein characterizing values in one or more data fields includes identifying a first data field having a value that indicates a relationship among two or more data records in the second set of data records.

6. The method of claim 5 , wherein selecting one or more data records from the second set of data records includes:
selecting a first data record;
identifying one or more second data records related to the first data record based on the value in the first data field of the first data record; and
selecting the one or more second data records.

7. The method of claim 5 , including:
determining an accumulated value for the first data record based on a value in a second data field of the first data record and a value in the second data field for each of the two or more data records that are related to the first data record;
generating a new field for the first data record; populating the new field with the accumulated value; and
selecting the one or more data records from the second set of data records based on the accumulated value in the new field for each of one or more data records in the second set.

8. A system for selecting data records to cause a processing rule to be triggered during testing of a data processing application, the system including:
at least one processor coupled to a memory, the processor and memory configured to:
process in a data processing system a first set of data records using a data processing application that includes a set of processing rules, wherein whether the set of processing rules is triggered during processing of a particular data record depends directly or indirectly on a value in each of one or more data fields of the particular data record;
receive information indicative of a number of times the set of processing rules was triggered in connection with processing of the first set of data records;
characterize values in one or more data fields of each of the data records in a second set of data records;
determine an identification criterion that identifies a particular one of the data fields of the data records in the second set as a target data field, the identification criterion being based on (i) the characterization of the values in the one or more data fields of each of the data records in the second set and (ii) the information indicative of the number of times the set of processing rules was triggered in connection with processing the first set of data records;
applying the identification criterion to select one or more data records from the second set of data records based on values in the target data field; and
process the selected one or more data records using the data processing application.

9. The system of claim 8 , wherein there are multiple distinct values in the target data field across the data records in the second set, and wherein selecting one or more data records from the second set of data records includes selecting at least one data record having each of the distinct values in the target data field.

10. The system of claim 8 , wherein the target data field is a first target data field, and including identifying a second particular one of the data fields of the data records in the second set as a second target data field.

11. The system of claim 10 , wherein selecting one or more data records from the second set of data records includes selecting the data records based on a combination of values in the first target data field and values in the second target data field.

12. The system of claim 8 , wherein characterizing values in one or more data fields includes identifying a first data field having a value that indicates a relationship among two or more data records in the second set of data records.

13. The system of claim 12 , wherein selecting one or more data records from the second set of data records includes:
selecting a first data record;
identifying one or more second data records related to the first data record based on the value in the first data field of the first data record; and
selecting the one or more second data records.

14. The system of claim 12 , wherein the at least one processor and memory are configured to:
determine an accumulated value for the first data record based on a value in a second data field of the first data record and a value in the second data field for each of the two or more data records that are related to the first data record;
generate a new field for the first data record;
populate the new field with the accumulated value; and
select the one or more data records based on the accumulated value in the new field for each of one or more data records in the second set.

15. A non-transitory computer readable medium storing instructions for causing a computer system to select data records to cause a processing rule to be triggered during testing of a data processing application, the instructions causing the computer system to:
process in a data processing system a first set of data records using a data processing application that includes a set of processing rules, wherein whether the set of processing rules is triggered during processing of a particular data record depends directly or indirectly on a value in each of one or more data fields of the particular data record;
receiv

Assignees

• Ab Initio Technology Llc

Inventors

• Isman Marshall A
• Epstein Richard A
• Haug Ralf
• Roberts Andrew F
• Ralston John
• Richardson John L
• Pniower Justin

Classifications

• G06F16/217

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F11/3684 Primary

  for test design, e.g. generating new test cases · CPC title

• G06F16/9535

  Search customisation based on user profiles and personalisation · CPC title