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
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Buerli, M.: The Current State of Graph Databases. San Luis Obispo (2012)
Dean, J., Ghemawat, S.: MapReduce: simplified data processing on large clusters. Google, Inc. http://research.google.com/archive/mapreduce-osdi04-slides/index.html
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)
Copeland, R.: MongoDB Applied Design Patterns. O’Reilly Media, Inc., Sebastopol (2013)
Ercan, M., Lane, M.: Evaluation of NoSQL databases for EHR systems. In: 25th Australasian Conference on Information Systems, Auckland, Nowa Zelandia (2014)
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)
Mohan, C.: History Repeats Itself: Sensible and NonsenSQL Aspects of the NoSQL Hoopla. EDBT/ICDT ‘13, Genoa, Włochy (2013)
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)
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)
Plugge, E., Membrey, P., Hawkins, T.: Definitive Guide to MongoDB. Apress, New York (2010)
Robinson, I., Webber, J., Eifrem, E.: Graph Databases. O’Reilly Media, Inc., Sebastopol (2013)
Sharma, V.: Meenu Dave. SQL and NoSQL databases. Int. J. Adv. Res. Comput. Sci. Software Eng. 2(8) (2012)
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)
Vaish, G.: Getting Started with NoSQL. Packt Publishing, Birmingham (2013)
Knowledge Base of Relational and NoSQL Database Management Systems. http://db-engines.com/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)