Sign In to Follow Application
View All Documents & Correspondence

System And Method For Data Validation

Abstract: Systems and methods for validating data in a communication network environment are described herein. In one example, the method comprises receiving, a data transformation specification from a user and analyzing the data transformation specification to determine data transformation rules, wherein the data transformation rules are indicative of a relationship between corresponding fields of the source repository and the target repository. The method further comprises generating test cases and test scripts based on the data transformation rules and executing the test cases and the test scripts on the source repository and the target repository to validate the relationship between the corresponding fields of the source repository and the target repository. Thereafter, a log file, indicative of the outcome of the execution of the test cases and the test scripts, is generated. Figure 2

Get Free WhatsApp Updates!
Notices, Deadlines & Correspondence

Patent Information

Application #
Filing Date
11 March 2014
Publication Number
12/2014
Publication Type
INA
Invention Field
COMPUTER SCIENCE
Status
Email
ipr@akshipassociates.com
Parent Application
Patent Number
Legal Status
Grant Date
2023-07-31
Renewal Date

Applicants

WIPRO LIMITED
Doddakannelli, Sarjapur Road, Bangalore 560035, Karnataka, India.

Inventors

1. DHARMENDRA JHA
C-206, Ittina Mahavir Apt, Electronic City, Bangalore 560100, Karnataka

Specification

CLIAMS:We claim:

1. A data validation system, for data validation, over a communication network, of data transformed from a source repository to a target repository, the data validation system comprising:
a processor;
a memory communicatively coupled to the processor, wherein the memory stores processor-executable instructions, which, on execution, cause the processor to:
receive a data transformation specification from a user;
analyze the data transformation specification to determine data transformation rules, wherein the data transformation rules are indicative of a relationship between corresponding fields of the source repository and the target repository;
generate test cases and test scripts based on the data transformation rules;
execute the test cases and the test scripts on the source repository and the target repository to validate the relationship between the corresponding fields of the source repository and the target repository; and
generate a log file indicative of the outcome of the execution of the test cases and the test scripts.

2. The data validation system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to:
determine the number of records on which the test cases and the test scripts are to be executed;
initiate parallel execution of the test cases and the test scripts on determining the number of records to have exceeded a critical threshold; and
initiate serial execution of the test cases and the test scripts on determining the number of records to be less than the critical threshold.

3. The data validation system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to generate, by the data validation system, a report, based on the log file, wherein the report is indicative of whether values sored in the corresponding fields of the source repository and the target repository are in accordance with the data transformation rules.

4. The data validation system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to:
determine a schema of the source repository and the target repository;
identify attributes of the corresponding fields of the source repository and the target repository; and
determine the data transformation rules based on the identified attributes.

5. The data validation system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to ascertain at least one of inconsistent standards between corresponding fields of the source repository and the target repository, discrepancies in data format between the corresponding fields of the source repository and the target repository, difference in structure of data between the corresponding fields of the source repository and the target repository, missing values between the corresponding fields of the source repository and the target repository, data fields filled with default values or nulls in the corresponding fields of the source repository and the target repository, and data anomalies.

6. The data validation system as claimed in claim 1, wherein the instructions, on execution, further cause the processor to::
receive an identifier from a user, wherein the identifier is indicative of an application whose associated data repositories are to be validated;
identify the source repository and the target repository based on the identifier;
receive configuration parameters of the source repository and the target repository, wherein the configuration parameters are indicative of at least one of data formats, structure, and schema of the source repository and the target repository;
receive connection parameters of the source repository and the target repository, wherein the connection parameters are indicative of the authentication details associated with accessing source repository and the target repository;
establish connection with the source repository and the target repository, based on the connection parameters;
identify the corresponding tables and fields of the source repository and the target repository; and
prompt the user to confirm the identified corresponding tables and fields of the source repository and the target repository.
7. A computer implemented method of data validation, over a communication network, of data transformed from a source repository to a target repository, the method comprising:
receiving, by a data validation system, a data transformation specification from a user;
analyzing, by the data validation system, the data transformation specification to determine data transformation rules, wherein the data transformation rules are indicative of a relationship between corresponding fields of the source repository and the target repository;
generating, by the data validation system, test cases and test scripts based on the data transformation rules;
executing, by the data validation system, the test cases and the test scripts on the source repository and the target repository to validate the relationship between the corresponding fields of the source repository and the target repository; and
generating, by the data validation system, a log file indicative of the outcome of the execution of the test cases and the test scripts.
8. The method as claimed in claim 7, wherein the method further comprises:
determining, by the data validation system, the number of records on which the test cases and the test scripts are to be executed;
initiating, by the data validation system, parallel execution of the test cases and the test scripts on determining the number of records to have exceeded a critical threshold; and
initiating, by the data validation system, serial execution of the test cases and the test scripts on determining the number of records to be less than the critical threshold.

9. The method as claimed in claim 7, wherein the method further comprises generating, by the data validation system, a report, based on the log file, wherein the report is indicative of whether values sored in the corresponding fields of the source repository and the target repository are in accordance with the data transformation rules.

10. The method as claimed in claim 7, wherein the analyzing the data transformation specification further comprises:
determining, by the data validation system, a schema of the source repository and the target repository;
identifying, by the data validation system, attributes of the corresponding fields of the source repository and the target repository; and
determining, by the data validation system, the data transformation rules based on the identified attributes.
11. The method as claimed in claim 7, wherein the execution of the test cases and the test scripts further comprise ascertaining, by the data validation system, at least one of inconsistent standards between corresponding fields of the source repository and the target repository, discrepancies in data format between the corresponding fields of the source repository and the target repository, difference in structure of data between the corresponding fields of the source repository and the target repository, missing values between the corresponding fields of the source repository and the target repository, data fields filled with default values or nulls in the corresponding fields of the source repository and the target repository, and data anomalies.

12. The method as claimed in claim 7, wherein the method further comprises:
receiving, by the data validation system, an identifier from a user, wherein the identifier is indicative of an application whose associated data repositories are to be validated;
identifying, by the data validation system, the source repository and the target repository based on the identifier;
receiving from the user, by the data validation system, configuration parameters of the source repository and the target repository, wherein the configuration parameters are indicative of at least one of data formats, structure, and schema of the source repository and the target repository;
receiving from the user, by the data validation system, connection parameters of the source repository and the target repository, wherein the connection parameters are indicative of the authentication details associated with accessing source repository and the target repository;
establishing, by the data validation system, connection with the source repository and the target repository, based on the connection parameters;
identifying, by the data validation system, the corresponding tables and fields of the source repository and the target repository; and
prompting, by the data validation system, the user to confirm the identified corresponding tables and fields of the source repository and the target repository.

Dated this 11th day of March, 2014
SRAVAN KUMAR GAMPA
K&S PARTNERS
AGENT FOR THE APPLICANT
,TagSPECI:TECHNICAL FIELD
The present subject matter is related, in general to data validation and, in particular, but not exclusively to a method and system for validating data in a communication network environment.

Documents

Application Documents

# Name Date
1 1267-CHE-2014 FORM-18 11-03-2014.pdf 2014-03-11
2 IP26616-spec.pdf 2014-03-12
3 IP26616-Fig.pdf 2014-03-12
4 FORM 5.pdf 2014-03-12
5 FORM 3.pdf 2014-03-12
6 1267CHE2014.pdf 2014-03-12
7 abstract1267-CHE-2014.jpg 2014-03-17
8 1267-CHE-2014 POWER OF ATTORNEY 26-08-2014.pdf 2014-08-26
9 1267-CHE-2014 FORM-1 26-08-2014.pdf 2014-08-26
10 1267-CHE-2014 CORRESPONDENCE OTHERS 26-08-2014.pdf 2014-08-26
11 POWER OF ATTORNEY.pdf 2015-05-28
12 FORM-9.pdf 2015-05-28
13 FORM-1.pdf 2015-05-28
14 1267-CHE-2014-FER.pdf 2019-07-30
15 1267-CHE-2014-FORM 3 [14-01-2020(online)].pdf 2020-01-14
16 1267-CHE-2014-OTHERS [28-01-2020(online)].pdf 2020-01-28
17 1267-CHE-2014-FER_SER_REPLY [28-01-2020(online)].pdf 2020-01-28
18 1267-CHE-2014-DRAWING [28-01-2020(online)].pdf 2020-01-28
19 1267-CHE-2014-CORRESPONDENCE [28-01-2020(online)].pdf 2020-01-28
20 1267-CHE-2014-CLAIMS [28-01-2020(online)].pdf 2020-01-28
21 1267-CHE-2014-US(14)-HearingNotice-(HearingDate-26-09-2022).pdf 2022-08-25
22 1267-CHE-2014-POA [09-09-2022(online)].pdf 2022-09-09
23 1267-CHE-2014-FORM 13 [09-09-2022(online)].pdf 2022-09-09
24 1267-CHE-2014-Correspondence to notify the Controller [09-09-2022(online)].pdf 2022-09-09
25 1267-CHE-2014-AMENDED DOCUMENTS [09-09-2022(online)].pdf 2022-09-09
26 1267-CHE-2014-Written submissions and relevant documents [11-10-2022(online)].pdf 2022-10-11
27 1267-CHE-2014-PatentCertificate31-07-2023.pdf 2023-07-31
28 1267-CHE-2014-IntimationOfGrant31-07-2023.pdf 2023-07-31
29 1267-CHE-2014-PROOF OF ALTERATION [14-12-2023(online)].pdf 2023-12-14
30 1267-CHE-2014-POWER OF AUTHORITY [14-12-2023(online)].pdf 2023-12-14
31 1267-CHE-2014-FORM-16 [14-12-2023(online)].pdf 2023-12-14
32 1267-CHE-2014-ASSIGNMENT WITH VERIFIED COPY [14-12-2023(online)].pdf 2023-12-14

Search Strategy

1 1267_CHE_2014_search_16-07-2019.pdf

ERegister / Renewals

3rd: 27 Oct 2023

From 11/03/2016 - To 11/03/2017

4th: 27 Oct 2023

From 11/03/2017 - To 11/03/2018

5th: 27 Oct 2023

From 11/03/2018 - To 11/03/2019

6th: 27 Oct 2023

From 11/03/2019 - To 11/03/2020

7th: 27 Oct 2023

From 11/03/2020 - To 11/03/2021

8th: 27 Oct 2023

From 11/03/2021 - To 11/03/2022

9th: 27 Oct 2023

From 11/03/2022 - To 11/03/2023

10th: 27 Oct 2023

From 11/03/2023 - To 11/03/2024

11th: 29 Feb 2024

From 11/03/2024 - To 11/03/2025

12th: 17 Feb 2025

From 11/03/2025 - To 11/03/2026