Method and system for migrating data to not only structured query language (nosql) database

摘要

Embodiments of the present disclosure disclose method for migrating data from relational database to Not Only Structured Query Language (NoSQL) database. The method comprises retrieving 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 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. FIGURE 4