METHOD AND SYSTEM FOR MIGRATING DATA TO NOT ONLY STRUCTURED QUERY LANGUAGE (NoSOL) DATABASE

摘要

A method, non-transitory computer readable medium, and data migration computing device that retrieves database metadata information, query statements information and query scripts information of each of database tables from relational database system. Then, query patterns of each of database tables from query statements information and query workload of each of database tables from the query scripts information is identified. Next, 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 is determined Then, data model of a Not Only Structured Query Language (NoSQL) database is generated using database metadata information, the query patterns, query workload, table key information and table index information. Then, data model of NoSQL database is verified. Lastly, data from relational database is migrated to NoSQL database.