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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Abelló, A.: Big data design. In: Proceedings of 11th International Workshop on Data Warehousing and OLAP, DOLAP 2015, pp. 35–38. ACM (2015)
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
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)
Corbellini, A., Mateos, C., Zunino, A., Godoy, D., Schiaffino, S.: Persisting big-data: the NoSQL landscape. Inf. Syst. 63, 1–23 (2017)
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
Curé, O., Lamole, M., Duc, C.L.: Ontology Based Data Integration over Document and Column Family Oriented NOSQL, CoRR, arXiv:1307.2603 (2013)
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
Marz, N., Warren, J.: Big Data: Principles and Best Practices of Scalable Realtime Data Systems, 1st edn. Manning Publications, New York (2015)
Meijer, E., Bierman, G.M.: A co-relational model of data for large shared data banks. Commun. ACM 54(4), 49–58 (2011)
Pokorný, J.: NoSQL databases: a step to databases scalability in Web environment. Int. J. Web Inf. Syst. 9(1), 69–82 (2013)
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
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)
Sadalage, P.J., Fowler, M.: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Pearson Education Inc., London (2013)
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)
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)
Acknowledgments
This work was supported by the Charles University project Q48.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG, part of Springer Nature
About this paper
Cite this paper
Pokorný, J. (2018). Integration of Relational and NoSQL Databases. In: Nguyen, N., Hoang, D., Hong, TP., Pham, H., Trawiński, B. (eds) Intelligent Information and Database Systems. ACIIDS 2018. Lecture Notes in Computer Science(), vol 10752. Springer, Cham. https://doi.org/10.1007/978-3-319-75420-8_4
Download citation
DOI: https://doi.org/10.1007/978-3-319-75420-8_4
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-75419-2
Online ISBN: 978-3-319-75420-8
eBook Packages: Computer ScienceComputer Science (R0)