US 2020/0089691 A1Published application

System and method for regularizing data between data source and data destination

AssigneeInnoplexus AG

InventorsAnkur Zilpelwar, Dileep Dharma, Jaimin Mehta, Prashant Patil, Abhilash Bolla, Hitesh Chavhan, Rohit Anurag

Life of this patent

Estimating the term…

Loading patent…

Abstract

A system and method of regularizing data between a data source and a data destination, wherein the given data category includes with specific data fields. The system includes a data processing arrangement that includes a data fetching module operable to fetch data from the data source. Furthermore, the data processing arrangement includes a data transformation module that is operable to receive pre-defined data formats for a specific data category, compare data formats of the fetched data with pre-defined data formats, determine a deviation therein, and thereafter transform the data format. Additionally, the data processing arrangement includes a data validation module operable that is to receive the transformed data or the fetched data, confirm if data formats of a received data are same as corresponding pre-defined data formats, identify from the received data regularized data, and transmit the regularized data to the data destination implemented as database arrangement.

Claims19

Dependent claims

A system for regularizing data between a data source and a data destination, the data corresponding to a given data category of a plurality of data categories, wherein the given data category includes specific data fields, wherein the system comprises:

a data processing arrangement comprising:
a data fetching module operable to fetch data from the data source, wherein the fetched data includes one or more data fields having values in corresponding data formats;
a data transformation module operable to receive the fetched data from the data fetching module, wherein the data transformation module is operable to:
receive pre-defined data formats for the values of data fields for a specific data category;
compare data formats of values of data fields of the fetched data with received pre-defined data formats for the values;
determine, based on the comparison, a deviation between a data format of at least one value and a corresponding pre-defined data format for the at least one value;
and
transform the data format of the at least one value to the corresponding pre-defined data format, if the deviation is determined;
a data validation module operable to:
receive from the data transformation module, the pre-defined data formats, and the transformed data if the deviation is determined, or the fetched data if the deviation is not determined;
confirm if data formats of values of all data fields of a received data are same as corresponding pre-defined data formats;
identify from the received data, based on the confirmation, regularized data having data formats of values of all data fields same as the corresponding pre-defined data formats;
transmit the regularized data to the data destination;
and
a database arrangement for implementing the data destination, the database arrangement being communicatively coupled to the data processing arrangement, wherein the database arrangement is operable to store the received regularized data.

12 more elements

A method for regularizing data between a data source and a data destination, the data corresponding to a given data category of a plurality of data categories, wherein the given data category includes with specific data fields, wherein the method comprises:

fetching from the data source, a data including one or more data fields having values in corresponding data formats;
receiving pre-defined data formats for the values of data fields for a specific data category;
comparing data formats of values of data fields of the fetched data with pre-defined data formats for the values;
determining, based on the comparison, a deviation between a data format of at least one value and a corresponding pre-defined data format for the at least one value;
transforming the data format of the at least one value to the corresponding pre-defined data format, if the deviation is determined;
confirming if data formats of values of all data fields of a received data are same as corresponding pre-defined data formats;
identifying from the received data, based on the confirmation, regularized data having data formats of values of all data fields same as the corresponding pre-defined data formats;
and
storing the regularized data at the data destination.

6 more elements

Dependencies are inferred from the claim text.