Advertisement

Integration of Relational and NoSQL Databases

  • Jaroslav Pokorný
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 10752)

Abstract

The analysis of relational and NoSQL databases leads to the conclusion that these data processing systems are to some extent complementary. In current Big Data applications, especially where extensive analyses are needed, it turns out that it is non-trivial to design an infrastructure involving data and software of both types. In terms of performance, it may be beneficial to use a polyglot persistence or multi-model approach or even to transform the SQL database schema into NoSQL and to perform data migration between the relational and NoSQL database. The aim of the paper is to show these possibilities and some new methods of designing such integrated database architectures.

Keywords

Relational database NoSQL database Big Data Big Analytics Database integration 

Notes

Acknowledgments

This work was supported by the Charles University project Q48.

References

  1. 1.
    Abelló, A.: Big data design. In: Proceedings of 11th International Workshop on Data Warehousing and OLAP, DOLAP 2015, pp. 35–38. ACM (2015)Google Scholar
  2. 2.
    Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R.: Database design for NoSQL systems. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds.) ER 2014. LNCS, vol. 8824, pp. 223–231. Springer, Cham (2014).  https://doi.org/10.1007/978-3-319-12206-9_18 Google Scholar
  3. 3.
    Chasseur, C., Li, Y., Patel, J.M.: Enabling JSON document stores in relational systems. In: 16th International Workshop on the Web and Databases (WebDB 2013), pp. 1–6 (2013)Google Scholar
  4. 4.
    Corbellini, A., Mateos, C., Zunino, A., Godoy, D., Schiaffino, S.: Persisting big-data: the NoSQL landscape. Inf. Syst. 63, 1–23 (2017)CrossRefGoogle Scholar
  5. 5.
    Curé, O., Hecht, R., Le Duc, C., Lamolle, M.: Data integration over NoSQL stores using access path based mappings. In: Hameurlain, A., Liddle, S.W., Schewe, K.-D., Zhou, X. (eds.) DEXA 2011. LNCS, vol. 6860, pp. 481–495. Springer, Heidelberg (2011).  https://doi.org/10.1007/978-3-642-23088-2_36 CrossRefGoogle Scholar
  6. 6.
    Curé, O., Lamole, M., Duc, C.L.: Ontology Based Data Integration over Document and Column Family Oriented NOSQL, CoRR, arXiv:1307.2603 (2013)
  7. 7.
    Herrero, V., Abelló, A., Romero, O.: NOSQL design for analytical workloads: variability matters. In: Comyn-Wattiau, I., Tanaka, K., Song, I.-Y., Yamamoto, S., Saeki, M. (eds.) ER 2016. LNCS, vol. 9974, pp. 50–64. Springer, Cham (2016).  https://doi.org/10.1007/978-3-319-46397-1_4 CrossRefGoogle Scholar
  8. 8.
    Marz, N., Warren, J.: Big Data: Principles and Best Practices of Scalable Realtime Data Systems, 1st edn. Manning Publications, New York (2015)Google Scholar
  9. 9.
    Meijer, E., Bierman, G.M.: A co-relational model of data for large shared data banks. Commun. ACM 54(4), 49–58 (2011)CrossRefGoogle Scholar
  10. 10.
    Pokorný, J.: NoSQL databases: a step to databases scalability in Web environment. Int. J. Web Inf. Syst. 9(1), 69–82 (2013)MathSciNetCrossRefGoogle Scholar
  11. 11.
    Pokorný, J.: Graph databases: their power and limitations. In: Saeed, K., Homenda, W. (eds.) CISIM 2015. LNCS, vol. 9339, pp. 58–69. Springer, Cham (2015).  https://doi.org/10.1007/978-3-319-24369-6_5 CrossRefGoogle Scholar
  12. 12.
    Pokorný, J.: Big data storage and management: challenges and opportunities. In: Proceedings of 12th IFIP WG 5.11 International Symposium on Environmental Software Systems, IFIP AICT 507. Springer, Heidelberg (2018, to appear)Google Scholar
  13. 13.
    Sadalage, P.J., Fowler, M.: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Pearson Education Inc., London (2013)Google Scholar
  14. 14.
    Stonebraker, M., Deng, D., Brodie, M.L.: Database decay and how to avoid it. In: Proceedings of 2016 IEEE International Conference on Big Data, pp. 7–16. IEEE Explore (2016)Google Scholar
  15. 15.
    Zhao, G., Lin, Q., Li, L., Li, Z.: Schema conversion model of SQL database to NoSQL. In: Proceedings of the 9th International Conference on P2P, Parallel, Grid, Cloud and Internet Computing, pp. 355–362. IEEE (2014)Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Faculty of Mathematics and PhysicsCharles UniversityPragueCzech Republic

Personalised recommendations