US 10,592,400 B2Granted

System and method for creating variants in a test database during various test stages

AssigneeTata Consultancy Services Limited

InventorsNikhil Girish Patwardhan, Ashim Roy, Rupali Kedar Kulkarni

Life of this patent

Estimating the term…

Abstract

System and methods for creating one or more variants of test data during various test stages are disclosed. The system and methods facilitate a user to create a primary variant for test data and to store the primary variant of the test data in a test data variant repository. Any changes performed in the test database by the user are identified by using a tracking mechanism to store one or more new variants along with a variant number with respect to the changes performed in the test database in response to the user's request. The primary variant and the new variants are accessed by the user to perform a comparative analysis and to modify the test data at any test stage.

Claims14

Dependent claims

A system for creating one or more variants of test data during various test stages, the system comprising:

a processor;
a memory coupled to the processor, the processor configured to execute a set of programmed instructions stored in the memory, the memory comprising:
a variant creation module to
create a primary variant for the test data stored in a test database comprising one or more flat files, wherein the test data comprises data corresponding to at least one test case;
and
store the primary variant of the test data in a test data variant repository in a tabular form, and wherein the primary variant created is copied into the one or more files;
and
an identification module to
execute the test data in the test database to identify one or more types of changes made to the test data;
compare a row of the test data having one variant with a corresponding row of the test data having another variant stored in the test data variant repository in the tabular form, wherein the one variant comprises one of the primary variant and a new variant, and wherein another variant comprises the new variant;
identify one or more types of changes in the test data of the test database based on the comparison, during one or more test stages, by using a tracking mechanism, wherein the tracking mechanism compares the data in rows of tabular form with the one variant to the another variant;
and
a variant update module to
store the corresponding one or more types of changes identified in the test database of the test data during the one or more test stages by creating and storing one or more new variants for the corresponding one or more types of changes in the test data variant repository in response to a request received by a user and identify corresponding one or more types of changes in the one or more flat files in the test database separately and in parallel to the corresponding types of changes in the test data;
perform a comparative analysis between two or more states of the test database by accessing the primary variant and the one or more new variants, wherein the two or more states of the test database comprise an original state and a changed state;
modify the test data in the test database by reverting to one of the primary variant and the one or more new variants during the one or more test stages, wherein if the test data is undetermined due to errors in the application then the user reverts to a variant created to store types of changes in the test database, wherein modification of the test data generates a script and displays, using the script, to the user an option to revert to any of the new variants in the test data variant repository;
and
perform one or more modifications at the one or more test stages to further modify the test data and compare any of the two variants to verify the test data for facilitating in the at least one test case verification, wherein each of the one or more modifications are tagged with one or more comments to the corresponding one or more types of changes to obtain information associated with each of the one or more new variants.

15 more elements

A computer implemented method for creating one or more variants of test data during various test stages, the method comprising:

creating a primary variant for the test data stored in a test database comprising one or more flat files, wherein the test data comprises data corresponding to at least one test case;
storing the primary variant of the test data in a test data variant repository in a tabular form, and wherein the primary variant created is copied into the one or more files;
and
executing the test data in the test database to identify one or more types of changes made to the test data;
comparing a row of the test data having one variant with a corresponding row of the test data having another variant stored in the test data variant repository in the tabular form, wherein the one variant comprises one of the primary variant and a new variant, and wherein another variant comprises the new variant;
identifying one or more types of changes in the test data of the test database based on the comparison during one or more of the test stages using a tracking mechanism, wherein the tracking mechanism compares the data in rows of tabular form with the one variant to the another variant;
and
storing the corresponding one or more types of changes identified in the test database during the one or more test stages by creating and storing one or more new variants for the corresponding one or more types of changes in the test data variant repository in response to a request received by a user and identify corresponding one or more types of changes in the one or more flat files in the test database separately and in parallel to the corresponding types of changes in the test data;
performing a comparative analysis between two or more states of the test database by accessing the primary variant and the one or more new variants, wherein the two or more test states of the test database comprise an original state and a changed state;
modifying the test data in the test database by reverting to one of the primary variant and the one or more new variants during the one or more test stages, wherein if the test data is undetermined due to errors in the application then the user reverts to a variant created to store types of changes in the test database, wherein modification of the test data generates a script and displays, using the script, to the user an option to revert to any of the new variants in the test data variant repository;
and
performing one or more modifications at the one or more test stages to further modify the test data and compare any of the two variants to verify the test data for facilitating in the at least one test case verification, wherein each of the one or more modifications are tagged with one or more comments to the corresponding one or more types of changes to obtain information associated with each of the one or more new variants.

9 more elements

A computer program product having a non-transitory computer readable storage medium having a computer program stored thereon for creating one or more variants of test data at various test stages in a test database, the computer program product comprising:

a computer readable program code for creating a primary variant for the test data stored in a test database comprising one or more flat files, wherein the test data comprises data corresponding to at least one test case;
a computer readable program code for storing the primary variant of the test data in a test data variant repository in a tabular form, and wherein the primary variant created is copied into the one or more files;
and
a computer readable program code for executing the test data in the test database to identify one or more types of changes made to the test data;
a computer readable program code for comparing a row of the test data having one variant with a corresponding row of the test data having another variant stored in the test data variant repository in the tabular form, wherein the one variant comprises one of the primary variant and a new variant, and wherein another variant comprises the new variant;
a computer readable program code for identifying one or more types of changes in the test data of the test database based on the comparison during one or more of the test stages using a tracking mechanism, wherein the tracking mechanism compares the data in rows of tabular form with the one variant to the another variant;
and
a computer readable program code for
storing the corresponding one or more types of changes identified in the test database during the one or more test stages by creating and storing one or more new variants for the corresponding one or more types of changes in the test data variant repository in response to a request received by a user and identify corresponding one or more types of changes in the one or more flat files in the test database separately and in parallel to the corresponding types of changes in the test data;
performing a comparative analysis between two or more states of the test database by accessing the primary variant and the one or more new variants, wherein the two or more test states of the test database comprise an original state and a changed state;
modifying the test data in the test database by reverting to one of the primary variant and the one or more new variants during the one or more test stages, wherein if the test data is undetermined due to errors in the application then the user reverts to a variant created to store types of changes in the test database, wherein modification of the test data generates a script and displays, using the script, to the user an option to revert to any of the new variants in the test data variant repository;
and
performing one or more modifications at the one or more test stages to further modify the test data and compare any of the two variants to verify the test data for facilitating in the at least one test case verification, wherein each of the one or more modifications are tagged with one or more comments to the corresponding one or more types of changes to obtain information associated with each of the one or more new variants.

10 more elements

Dependencies are inferred from the claim text.

patentgrep

Loading patent…

Abstract

A system for creating one or more variants of test data during various test stages, the system comprising:

a processor;
a memory coupled to the processor, the processor configured to execute a set of programmed instructions stored in the memory, the memory comprising:
a variant creation module to
create a primary variant for the test data stored in a test database comprising one or more flat files, wherein the test data comprises data corresponding to at least one test case;
and
store the primary variant of the test data in a test data variant repository in a tabular form, and wherein the primary variant created is copied into the one or more files;
and
an identification module to
execute the test data in the test database to identify one or more types of changes made to the test data;
compare a row of the test data having one variant with a corresponding row of the test data having another variant stored in the test data variant repository in the tabular form, wherein the one variant comprises one of the primary variant and a new variant, and wherein another variant comprises the new variant;
identify one or more types of changes in the test data of the test database based on the comparison, during one or more test stages, by using a tracking mechanism, wherein the tracking mechanism compares the data in rows of tabular form with the one variant to the another variant;
and
a variant update module to
store the corresponding one or more types of changes identified in the test database of the test data during the one or more test stages by creating and storing one or more new variants for the corresponding one or more types of changes in the test data variant repository in response to a request received by a user and identify corresponding one or more types of changes in the one or more flat files in the test database separately and in parallel to the corresponding types of changes in the test data;
perform a comparative analysis between two or more states of the test database by accessing the primary variant and the one or more new variants, wherein the two or more states of the test database comprise an original state and a changed state;
modify the test data in the test database by reverting to one of the primary variant and the one or more new variants during the one or more test stages, wherein if the test data is undetermined due to errors in the application then the user reverts to a variant created to store types of changes in the test database, wherein modification of the test data generates a script and displays, using the script, to the user an option to revert to any of the new variants in the test data variant repository;
and
perform one or more modifications at the one or more test stages to further modify the test data and compare any of the two variants to verify the test data for facilitating in the at least one test case verification, wherein each of the one or more modifications are tagged with one or more comments to the corresponding one or more types of changes to obtain information associated with each of the one or more new variants.

15 more elements