Skip to main content
SpringerLink
Log in

Integration of Relational and NoSQL Databases

  • Conference paper
  • First Online:
Book cover Intelligent Information and Database Systems (ACIIDS 2018)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 10752))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://redis.io/.

  2. 2.

    http://cassandra.apache.org/.

  3. 3.

    https://www.mongodb.com/.

  4. 4.

    http://couchdb.apache.org/.

  5. 5.

    https://db-engines.com/en/ranking.

  6. 6.

    https://www.elastic.co/products/elasticsearch.

  7. 7.

    http://orientdb.com/orientdb/.

  8. 8.

    https://www.arangodb.com/.

  9. 9.

    http://www.marklogic.com/.

References

  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. 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. 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. Corbellini, A., Mateos, C., Zunino, A., Godoy, D., Schiaffino, S.: Persisting big-data: the NoSQL landscape. Inf. Syst. 63, 1–23 (2017)

    Article  Google Scholar 

  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

    Chapter  Google Scholar 

  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. 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

    Chapter  Google Scholar 

  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. Meijer, E., Bierman, G.M.: A co-relational model of data for large shared data banks. Commun. ACM 54(4), 49–58 (2011)

    Article  Google Scholar 

  10. Pokorný, J.: NoSQL databases: a step to databases scalability in Web environment. Int. J. Web Inf. Syst. 9(1), 69–82 (2013)

    Article  MathSciNet  Google Scholar 

  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

    Chapter  Google Scholar 

  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. 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. 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. 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 

Download references

Acknowledgments

This work was supported by the Charles University project Q48.

Author information

Authors and Affiliations

  1. Faculty of Mathematics and Physics, Charles University, Prague, Czech Republic

    Jaroslav Pokorný

Authors
  1. Jaroslav Pokorný
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Jaroslav Pokorný .

Editor information

Editors and Affiliations

  1. Wrocław University of Science and Technology, Wrocław, Poland

    Ngoc Thanh Nguyen

  2. Quang Binh University, Dong Hoi City, Vietnam

    Duong Hung Hoang

  3. National University of Kaohsiung, Kaohsiung, Taiwan

    Tzung-Pei Hong

  4. Rutgers University, Piscataway, New Jersey, USA

    Hoang Pham

  5. Wrocław University of Science and Technology, Wrocław, Poland

    Bogdan Trawiński

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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)

Publish with us

Policies and ethics

Search

Navigation