Graph-Based Denormalization for Migrating Big Data from SQL Database to NoSQL Database

  • V. RathikaEmail author
Conference paper
Part of the Lecture Notes on Data Engineering and Communications Technologies book series (LNDECT, volume 33)


In this big data era, the data storing methods are vary based upon the data type and the technologies upgradation. Due to the increase of voluminous data, the traditional Relational Database Management Systems (RDBMS) are immature to handle the unstructured data. To overcome this issue, NoSQL databases are used to store and process the unstructured data. The big data migration from SQL to NoSQL database is more complex. The SQL databases are well-normalized database. Denormalization plays a major role in retrieving the data more efficiently. This work is carried on migrating the big data from SQL to NoSQL database using the Graph-based Denormalization method. The proposed method is more efficient for big data migration and post-migration process.


Big data Data migration Denormalization Map Reduce NoSQL database 


  1. 1.
    Sanders, G.L., Shin, S.K.: Denormalization effects on performance of RDBMS. In: Proceedings of the HICSS Conference, January 2001Google Scholar
  2. 2.
    Shin, S.K., Sanders, G.L.: Denormalization strategies for data retrieval from data warehouses. Decis. Support Syst. 42(1), 267–282 (2006)CrossRefGoogle Scholar
  3. 3.
    Wei, Z., Dejun, J., Pierre, G., Chi, C.-H., van Steen, M.: Service-oriented data denormalization for scalable web applications. In: Proceedings of the International World-Wide Web Conference, April 2008Google Scholar
  4. 4.
    Lombardo, S., Di Nitto, E., Ardagna, D.: Issues in handling complex data structures with NoSQL databases. In: Proceedings of the 14th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing (SYNASC), pp. 443–448, September 2012Google Scholar
  5. 5.
    Li, Y., Manoharan, S.: A performance comparison of SQL and NoSQL databases. In: Proceedings of IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM), pp. 15–19, August 2013Google Scholar
  6. 6.
    Boicea, A., Radulescu, F., Agapin, L.I.: MongoDB vs Oracle – database comparison. In: Proceedings of The 3rd International Conference on Emerging Intelligent Data and Web Technologies (EIDWT), pp. 330–335, September 2012Google Scholar
  7. 7.
    Grolinger, K., Hayes, M., Higashino, W.A., L’Heureux, A., Allison, D.S., Capretz, M.A.M.: Challenges for MapReduce in big data. In: Proceedings of IEEE World Congress on Services (SERVICES), pp. 182–189, June 2014Google Scholar
  8. 8.
    Naheman, W., Wei, J.: Review of NoSQL databases and performance testing on HBase. In: Proceedings of International Conference on Mechatronic Sciences, Electric Engineering and Computer (MEC), pp. 2304–2309, December 2013Google Scholar
  9. 9.
    Scavuzzo, M., Di Nitto, E., Ceri, S.: Interoperable data migration between NoSQL columnar databases. In: Proceedings of IEEE 18th International Enterprise Distributed Object Computing Conference Workshops and Demonstrations (EDOCW), pp. 154–162, September 2014Google Scholar
  10. 10.
    Hsu, J.-C., Hsu, C.-H., Chen, S.-C., Chung, Y.-C.: Correlation aware technique for SQL to NoSQL transformation. In: Proceedings of the 7th International Conference on Ubi-Media Computing and Workshops (UMEDIA), pp. 43–46, July 2014Google Scholar
  11. 11.
    Zhao, G., Li, L., Li, Z., Lin, Q.: Multiple nested schema of HBase for migration from SQL. In: Proceedings of 9th International Conference on P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC), pp. 338–343, November 2014Google Scholar
  12. 12.
    Zhao, G., Lin, Q., Li, L., Li, Z.: Schema conversion model of SQL database to NoSQL. In: Proceedings of 9th International Conference on P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC), pp. 355–362, November 2014Google Scholar
  13. 13.
    Sellami, R., Bhiri, S., Defude, B.: ODBAPI: a unified REST API for relational and NoSQL data stores. In: Proceedings of IEEE International Congress on Big Data (BigData Congress), pp. 653–660, June 2014Google Scholar
  14. 14.
    Li, X., Ma, Z., Chen, H.: QODM: a query-oriented data modeling approach for NoSQL databases. In: Proceedings of IEEE Workshop on Advanced Research and Technology in Industry Applications (WARTIA), pp. 338–345, September 2014Google Scholar
  15. 15.
    Gadkari, A., Nikam, V.B., Meshram, B.B.: Implementing joins over HBase on cloud platform. In: Proceedings of IEEE International Conference on Computer and Information Technology (CIT), pp. 547–554, September 2014Google Scholar
  16. 16.
    Wei, Z., Pierre, G., Chi, C.-H.: Scalable join queries in cloud data stores. In: Proceedings of the 12th IEEE/ACM International Symposium on Cluster, Cloud and Grid Computing (CCGrid), pp. 547–555 May 2012Google Scholar
  17. 17.
    Lawrence, R.: Integration and virtualization of relational SQL and NoSQL systems including MySQL and MongoDB. In: Proceedings of International Conference on Computational Science and Computational Intelligence (CSCI), pp. 285–290, March 2014Google Scholar
  18. 18.
    Van Hieu, D., Smanchat, S., Meesad, P.: MapReduce join strategies for key-value storage. In: Proceedings of the 11th International Joint Conference on Computer Science and Software Engineering (JCSSE), pp. 164–169, May 2014Google Scholar

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  1. 1.Department of Computer ScienceMother Teresa Women’s UniversityKodaikanalIndia

Personalised recommendations