CLIAMS:We claim:
1. A method for migrating data from a relational database to a Not Only Structured Query Language (NoSQL) database, the method comprising:
retrieving, by a migration system, at least one of database metadata information, query statements information and query scripts information of each of database tables from a relational database system;
identifying, by the migration system, at least one of query patterns of each of database tables from the query statements information and query workload of each of the database tables from the query scripts information;
determining, by the migration system, at least one of table key information and table index information of each of the database tables based on correlation between the database metadata information and the query patterns of corresponding database tables;
generating, by the migration system, a data model of the NoSQL database using at least one of the database metadata information, the query patterns, the query workload, the table key information and the table index information;
verifying, by the data migration system, the data model of the NoSQL database; and
migrating, by the data migration system, data from the relational database to the NoSQL database.
2. The method as claimed in claim 1, wherein the query workload comprises at least one of type of data manipulation query and frequency of usage of each of the type of data manipulation query.

3. The method as claimed in claim 1, wherein the table key information is selected from at least one of primary key, composite key, unique key and partition key.

4. The method as claimed in claim 1, wherein the table index information is selected from a group comprising cluster index, sequence objects of the columns, column attributes which are repeatedly used, index key columns, cluster key columns, column information, and frequency of usage of cluster index columns.

5. The method as claimed in claim 1, wherein generating by the migration system, the data model of the NoSQL database comprises:
generating a logical data model comprising at least one of the database metadata information, the query patterns and the table key information; and
generating a physical data model, comprising at least one of details of data type of columns and attributes, and the table index information, using the logical data model.
6. The method as claimed in claim 5 further comprising updating by the migration system, the at least one of the logical data model and the physical data model based on update information received from a user.

7. The method as claimed in claim 5, wherein verifying by the migration system, the data model of the NoSQL database comprises verifying presence of the table key information, details of data type of columns and attributes and the table index information in the data model.

8. The method as claimed in claim 7 further comprising providing an alert, by the migration system, upon determining the verification to be unsuccessful.

9. The method as claimed in claim 1 further comprising verifying by the migration system, migration of the data from the relational database to the NoSQL database.

10. A migration system for migrating data from a relational database to a Not Only Structured Query Language (NoSQL) database, comprising:
a processor;
a memory communicatively coupled to the processor, wherein the memory stores processor-executable instructions, which, on execution, cause the processor to:
retrieve at least one of database metadata information, query statements information and query scripts information of each of database tables from a relational database system;
identify at least one of query patterns of each of database tables from the query statements information and query workload of each of the database tables from the query scripts information;
determine at least one of table key information and table index information of each of the database tables based on correlation between the database metadata information and the query patterns of corresponding database tables;
generate a data model of the NoSQL database using at least one of the database metadata information, the query patterns, the query workload, the table key information and the table index information;
verify the data model of the NoSQL database; and
migrate data from the relational database to the NoSQL database.

11. The migration system as claimed in claim 10 generates the data model of the NoSQL database by performing:
generate a logical data model comprising at least one of the database metadata information, the query patterns and the table key information; and
generate a physical data model, comprising at least one of details of data type of columns and attributes, and the table index information, using the logical data model.
12. The migration system as claimed in claim 11 is further configured to update the at least one of the logical data model and the physical data model based on update information received from a user.

13. The migration system as claimed in claim 11 verifies the data model of the NoSQL database by verifying presence of the database metadata information, the table key information, details of data type of columns and attributes and the table index information in the data model.
14. The migration system as claimed in claim 13 is further configured to provide an alert upon determining the verification to be unsuccessful.

15. The migration system as claimed in claim 10 is further configured to verify the migration of the data from the relational database to the NoSQL database.

16. A non-transitory computer readable medium including instructions stored thereon that when processed by a processor cause a migration system to perform acts of:
retrieving at least one of database metadata information, query statements information and query scripts information of each of database tables from a relational database system;
identifying at least one of query patterns of each of database tables from the query statements information and query workload of each of the database tables from the query scripts information;
determining at least one of table key information and table index information of each of the database tables based on correlation between the database metadata information and the query patterns of corresponding database tables;
generating a data model of the NoSQL database using at least one of the database metadata information, the query patterns, the query workload, the table key information and the table index information;
verifying the data model of the NoSQL database; and
migrating data from the relational database to the NoSQL database.

Dated this 29th day of December, 2014
Shwetha A Chimalgi
of K & S Partners
Agent for the Applicant
,TagSPECI:TECHNICAL FIELD
The present subject matter is related, in general to field of databases and more particularly, but not exclusively to a method and system for migrating data from relational databases to Not Only Structured Query Language (NoSQL) databases.