Skip to main content

Comparison of Relational, Document and Graph Databases in the Context of the Web Application Development

  • Conference paper
  • First Online:

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 430))

Abstract

The paper presents the comparison study of relational, document and graph databases. A social networking web application supporting all three types of database was developed. The analysis consists in data models analysis and performance tests. Data models analysis discusses requirements meeting and difficulties of different implementation. Performance tests present results of obtained for five different tasks. Each of analyzed solutions revealed their strengths and weaknesses. The analysis showed that the graph model the most accurately models the reality. Document database queries occur to be the simplest in use. In terms of performance, PostgreSQL occurred to be the best.

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

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.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

Learn about institutional subscriptions

References

  1. Buerli, M.: The Current State of Graph Databases. San Luis Obispo (2012)

    Google Scholar 

  2. Dean, J., Ghemawat, S.: MapReduce: simplified data processing on large clusters. Google, Inc. http://research.google.com/archive/mapreduce-osdi04-slides/index.html

  3. Dziedzic, A., Mulawka, J.: Analysis and comparison of NoSQL databases with an introduction to consistent references in Big Data storage systems. In: Symposium on Photonics Applications in Astronomy, Communications, Industry and High-Energy Physics Experiments, p. 92902V. International Society for Optics and Photonics (2014)

    Google Scholar 

  4. Copeland, R.: MongoDB Applied Design Patterns. O’Reilly Media, Inc., Sebastopol (2013)

    Google Scholar 

  5. Ercan, M., Lane, M.: Evaluation of NoSQL databases for EHR systems. In: 25th Australasian Conference on Information Systems, Auckland, Nowa Zelandia (2014)

    Google Scholar 

  6. Lee, K., Tang, W., Choi, K.: Alternatives to relational database: comparison of NoSQL and XML approaches for clinical data storage. Comput. Methods Programs Biomed. 110(1), 99–109 (2013)

    Article  Google Scholar 

  7. Mohan, C.: History Repeats Itself: Sensible and NonsenSQL Aspects of the NoSQL Hoopla. EDBT/ICDT ‘13, Genoa, Włochy (2013)

    Google Scholar 

  8. Moniruzzaman, A., Hossain, S.: NoSQL database: new era of databases for big data analytics—Classification, characteristics and comparison. Int. J. Database Theory Appl. 6(4) (2013)

    Google Scholar 

  9. Nimis, J., Kammerer, M., Armbruster, M., Mattes, C., Steinbuch, K.: Application-mimes an approach for quantitative comparison of SQL- and NoSQL-databases. In: Proceedings of the 16th International Conference on Enterprise Information Systems, vol. 1, pp. 256–263 (2014)

    Google Scholar 

  10. Plugge, E., Membrey, P., Hawkins, T.: Definitive Guide to MongoDB. Apress, New York (2010)

    Google Scholar 

  11. Robinson, I., Webber, J., Eifrem, E.: Graph Databases. O’Reilly Media, Inc., Sebastopol (2013)

    Google Scholar 

  12. Sharma, V.: Meenu Dave. SQL and NoSQL databases. Int. J. Adv. Res. Comput. Sci. Software Eng. 2(8) (2012)

    Google Scholar 

  13. Upeksha, D., Wijayarathna, C., Siriwardena, M., Lasandun, L., Wimalasuriya, C., de Silva, N., Dias, G.: Comparison between performance of various database systems for implementing a language corpus. In: Beyond Databases, Architectures and Structures, pp. 82–91. Springer, Berlin (2015)

    Google Scholar 

  14. Vaish, G.: Getting Started with NoSQL. Packt Publishing, Birmingham (2013)

    Google Scholar 

  15. Knowledge Base of Relational and NoSQL Database Management Systems. http://db-engines.com/

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Małgorzata Plechawska-Wójcik .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Plechawska-Wójcik, M., Rykowski, D. (2016). Comparison of Relational, Document and Graph Databases in the Context of the Web Application Development. In: Grzech, A., Borzemski, L., Świątek, J., Wilimowska, Z. (eds) Information Systems Architecture and Technology: Proceedings of 36th International Conference on Information Systems Architecture and Technology – ISAT 2015 – Part II. Advances in Intelligent Systems and Computing, vol 430. Springer, Cham. https://doi.org/10.1007/978-3-319-28561-0_1

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-28561-0_1

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-28559-7

  • Online ISBN: 978-3-319-28561-0

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics