Method and system for data conversion and data model optimization

Patent metadata

Field	Value
Publication number	US-10552383-B2
Application number	US-201715714681-A
Country	US
Kind code	B2
Filing date	Sep 25, 2017
Priority date	Aug 11, 2017
Publication date	Feb 4, 2020
Grant date	Feb 4, 2020

Abstract

Embodiments of present disclosure discloses system and method for conversion of structured database into unstructured database. Initially, structured database and database descriptor is retrieved in distributed environment. Structured database comprises data fields, and each of the data fields corresponds to financial transaction. Optimized target data model is generated for storing data in the unstructured database, based on at least one of database objects extracted from data fields of structured database, and pre-defined conversion rules. Further, a Blockchain comprising blocks corresponding to each financial transaction of structured database. Each of the blocks comprise at least one of extracted database object. Conversion of the database object of each of the blocks into data fields of unstructured database is performed based on optimized target data model and notification corresponding to data fields of unstructured database is generated which are associated with discrepancies corresponding to the financial transaction.

First claim

What is claimed is:

1. A method for conversion of a structured database into an unstructured database, comprising:
retrieving, by a database conversion system, in a distributed environment, structured database and a corresponding database descriptor, wherein the structured database comprises one or more data fields, and wherein each of the one or more data fields corresponds to a financial transaction from one or more financial transactions;
generating, by the database conversion system, an optimized target data model for storing data in the unstructured database, wherein the generation is based on at least one of a plurality of database objects extracted from one or more data fields of the structured database, and a set of pre-defined conversion rules;
generating, by the database conversion system, a Blockchain comprising one or more blocks corresponding to each of the one or more financial transactions of the structured database, wherein each of the one or more blocks comprise at least a database object from the plurality of database objects;
performing, by the database conversion system, conversion of the database object of each of the one or more blocks into one or more data fields of the unstructured database, based on the optimized target data model; and
generating, by the database conversion system, a notification corresponding to the one or more data fields of the unstructured database, which are associated with one or more discrepancies corresponding to the financial transaction.

2. The method as claimed in claim 1 , wherein the structured database comprises:
a Virtual Storage Access Method (VSAM) database, hierarchical database comprising an Information Management System (IMS), network database comprising an Integrated Database Management System (IDMS), or a relational database comprising Database 2 (DB2).

3. The method as claimed in claim 1 , wherein the one or more discrepancies are identified based on one or more pre-defined transaction patterns.

4. The method as claimed in claim 3 , wherein the one or more pre-defined transaction patterns are generated based on analysis of historic financial transaction data.

5. The method as claimed in claim 1 , wherein each of the one or more blocks are generated for corresponding one or more financial transactions that occur within a pre-determined time interval.

6. The method of claim 1 , wherein the plurality of database objects is extracted based on parsing of the one or more data fields.

7. The method of claim 1 , wherein the notification comprises highlighting the one or more data fields associated with the one or more discrepancies in the unstructured database.

8. A database conversion system to conversion of a structured database into an unstructured database, comprises:
a processor; and
a memory communicatively coupled to the processor, wherein the memory stores processor-executable instructions, which, on execution, cause the processor to:
retrieve in a distributed environment, structured database and a corresponding database descriptor, wherein the structured database comprises one or more data fields, and wherein each of the one or more data fields corresponds to a financial transaction from one or more financial transactions;
generate an optimized target data model for storing data in the unstructured database, wherein the generation is based on at least one of a plurality of database objects extracted from one or more data fields of the structured database, and a set of pre-defined conversion rules;
generate a Blockchain comprising one or more blocks corresponding to each of the one or more financial transactions of the structured database, wherein each of the one or more blocks comprise at least a database object from the plurality of database objects;
perform conversion of the database object of each of the one or more blocks, into one or more data fields of the unstructured database, based on the optimized target data model; and
generate a notification corresponding to the one or more data fields of the unstructured database, which are associated with one or more discrepancies corresponding to the financial transaction.

9. The database conversion system as claimed in claim 8 , wherein the structured database comprises:
a Virtual Storage Access Method (VSAM) database, hierarchical database comprising an Information Management System (IMS), network database comprising an Integrated Database Management System (IDMS), or a relational database comprising Database 2 (DB2).

10. The database conversion system as claimed in claim 8 , wherein the processor is configured to identify one or more discrepancies based on one or more pre-defined transaction patterns.

11. The database conversion system as claimed in claim 10 wherein the one or more pre-defined transaction patterns are generated based on analysis of historic financial transaction data.

12. The database conversion system as claimed in claim 8 , wherein the processor is configured to generate the one or more blocks corresponding to one or more financial transactions that occur within a pre-determined time interval.

13. The database conversion system as claimed in claim 8 , wherein the processor is configured to extract the plurality of database objects based on parsing of the one or more data fields.

14. The database conversion system as claimed in claim 8 , wherein the notification comprises highlighting the one or more data fields associated with the one or more discrepancies in the unstructured database.

15. A non-transitory computer readable medium including instructions stored thereon that when processed by at least one processor cause a device to perform operations comprising:
retrieving in a distributed environment, structured database and a corresponding database descriptor, wherein the structured database comprises one or more data fields, and wherein each of the one or more data fields corresponds to a financial transaction from one or more financial transactions;
generating an optimized target data model for storing data in the unstructured database, wherein the generation is based on at least one of a plurality of database objects extracted from one or more data fields of the structured database, and a set of pre-defined conversion rules;
generating a Blockchain comprising one or more blocks corresponding to each of the one or more financial transactions of the structured database, wherein each of the one or more blocks comprise at least a database object from the plurality of database objects;
performing conversion of the database object of each of the one or more blocks into one or more data fields of the unstructured database, based on the optimized target data model; and
generating a notification corresponding to the one or more data fields of the unstructured database, which are associated with one or more discrepancies corresponding to the financial transaction.

16. The medium as claimed in claim 15 , wherein the structured database comprises:
a Virtual Storage Access Method (VSAM) database, hierarchical database comprising an Information Management System (IMS), network database comprising an Integrated Database Management System (IDMS), or a relational database comprising Database 2 (DB2).

17. The medium as claimed in claim 15 , wherein the one or more discrepancies are identified based on one or more pre-defined transaction patterns.

18. The medium as claimed in claim 17 , wherein the one or more pre-defined transaction patterns are generated based on analysis of historic financial transaction data.

Assignees

• Wipro Ltd

Inventors

• Sharma Mayank
• Khan Buland

Classifications

• G06F16/1794 Primary

  Details of file format conversion · CPC title

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title