![Open Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltextgreen.png)
![Restricted Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltextred.png)
Data Migration Tool to Minimize the Spatial Redundancy without Affecting the Query Performance
Objectives: The study is to minimize the spatial redundancy without affecting the query performance, i.e., time taken to execute the query. Methods/Statistical Analysis: This paper illustrates a new method of analyzing the source database system: data, relations, etc., and generation of a Graph model based upon the database and conversion of the model by creating a new algorithm compatible with NoSQL databases, keeping in mind the following parameters: (1) Less time to execute each query, (2) Maximize spatial performance with minimum space and (3) Robustness of algorithm i.e., no data loss, metadata loss, or relational data loss during two transition stages, that is from old data migration to new model and analysis of new model (comparison with relational model). Findings: The advantage of NoSQL model is the decreased time taken to execute each query and increased speed for execution of queries due to ability to deal with the unstructured data. It was found that out of the three scenarios considered in the study that is nested, non- nested and hybrid, hybrid scenario is the one that possesses the most consistent performance and hence can be stated to be the best performer. Further, the study presented a robust algorithm for the migration of data in such a way that data loss, meta data loss, or relational data loss during transition is null or minimum. Application/Improvements: The present study proposes a method to convert the relational database to NoSQL database schema conversion model. This specific model has used the concept of embedded documents to improve query speed of NoSQL database.
User
Information
- Cognizant. A path to efficient data migration in core banking; 2016. Available from: https://www.cognizant.com/ whitepapers/a-path-to-efficient-data-migration-in-core-banking-codex2287
- IBM Global Technology Services. Best practices for data migration; 2007. Available from: https://www-935.ibm.com/services/us/gts/pdf/softek-best-practices-data-migration
- Mittal N, Anupindi RS, Velumani K. Oracle data migration-A comparative study; 2017 Available from: https://www.infosys.com/industries/aerospace-defense/white-papers/Documents/oracle-data-migration-comparative-study
- Oracle. Successful Data Migration. Oracle; 2011. Available from: http://www.oracle.com/technetwork/middleware/oedq/successful-data-migration-wp-1555708
- Rintamaki L. Data migration, a practical example from the business world master of science thesis in software engineering and technology; 2010. Available from: http://publications.lib.chalmers.se/records/fulltext/126754
- Russom P. Best practices in data migration best practices in data migration table of contents. Available from: http://download.101com.com/pub/tdwi/files/tdwi_monograph_ bpindatamigration_april20062006.
- Roijackers J. Bridging SQL and NoSQL [Master thesis]. Eindhoven University of Technology. Department of Mathematics and Computer Science; 2012.
- Zhao G, Lin Q, Li L, Li Z. Schema conversion model of SQL database to NoSQL. IEEE 9th International Conference on P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC); 2014. p. 355–62.
![](https://i-scholar.in/public/site/images/abstractview.png)
Abstract Views: 236
![](https://i-scholar.in/public/site/images/pdfview.png)
PDF Views: 0