Claims:We claim:
1. A method for conversion of a structured database (208) into an unstructured database (215), comprising:
retrieving, by a database conversion system (101), in a distributed environment, structured database (208) and a corresponding database descriptor (209), wherein the structured database (208) 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 (101), an optimized target data model (210) for storing data in the unstructured database (215), 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 (208), and a set of pre-defined conversion rules (211);
generating, by the database conversion system (101), a Blockchain (212) comprising one or more blocks corresponding to each of the one or more financial transactions of the structured database (208), 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 (101), conversion of the database object of each of the one or more blocks into one or more data fields of the unstructured database (215), based on the optimized target data model (210); and
generating, by the database conversion system (101), a notification (214) corresponding to the one or more data fields of the unstructured database (215), which are associated with one or more discrepancies (213) corresponding to the financial transaction.

2. The method as claimed in claim 1, wherein the structured database (208) is one of: a Virtual Storage Access Method (VSAM) database, hierarchical database such as Information Management System (IMS), network database such as Integrated Database Management System (IDMS), relational database such as Database 2 (DB2).

3. The method as claimed in claim 1, wherein the one or more discrepancies (213) 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 as claimed in claim 1, wherein the plurality of database objects is extracted based on parsing of the one or more data fields.

7. The method as claimed in claim 1, wherein the notification (214) comprises highlighting the one or more data fields associated with the one or more discrepancies (213) in the unstructured database (215).

8. A database conversion system (101) to conversion of a structured database (208) into an unstructured database (215), comprises:
a processor (104); and
a memory (107) communicatively coupled to the processor (104), wherein the memory (107) stores processor-executable instructions, which, on execution, cause the processor (104) to:
retrieve in a distributed environment, structured database (208) and a corresponding database descriptor (209), wherein the structured database (208) 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 (210) for storing data in the unstructured database (215), 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 (208), and a set of pre-defined conversion rules (211);
generate a Blockchain (212) comprising one or more blocks corresponding to each of the one or more financial transactions of the structured database (208), 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 (215), based on the optimized target data model (210); and
generate a notification corresponding to the one or more data fields of the unstructured database (215), which are associated with one or more discrepancies (213) corresponding to the financial transaction.

9. The database conversion system (101) as claimed in claim 8, wherein the structured database (208) is one of: a Virtual Storage Access Method (VSAM) database, hierarchical database such as Information Management System (IMS), network database such as Integrated Database Management System (IDMS), relational database such as Database 2 (DB2).

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

11. The database conversion system (101) 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 (101) as claimed in claim 8, wherein the processor (104) 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 (101) as claimed in claim 8, wherein the processor (104) is configured to extract the plurality of database objects based on parsing of the one or more data fields.

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

Dated this 11th day of August, 2017

R Ramya Rao
Of K&S Partners
Agent for the Applicant
, Description:TECHNICAL FIELD
The present subject matter is related in general to the field of modernization of databases, more particularly, but not exclusively to a system and method for conversion of a structured database into an unstructured database.