Storage efficiency comparison of UML models in selected database technologies


Abstract

.The study answers the question which database is the best choice for efficient data storage of UML models. Three products were considered: MongoDB, PostgreSQL and Neo4J. The effectiveness test consists of measurement the response time of queries that save and load data. This study also take into account the memory increase ratio during data insertion and the level of complexity of the implementation of the test data mappers used in database queries.


Keywords

UML; MongoDB; Neo4J; PostgreSQL

[1] The Coming Software Apocalypse. https://www.theatlantic.com/technology/archive/2017/09/saving -the-world-from-code/540393/ [05.05.2019].
[2] Jung M., Youn S., Bae J. Choi Y.: A Study on Data Input and Output Performance Comparison of MongoDB and PostgreSQL in the Big Data Environment. 8th International Conference on Database Theory and Application (DTA). IEEE, 2015.
[3] Plechawska-Wójcik M., Rykowski, D.: Comparison of relational, document and graph databases in the context of the web application development. 36th ISAT Conference, Part II, s. 3-13. Springer, Cham, 2015.
[4] Van der Veen J. S., Van der Waaij B., Meijer R. J.: Sensor Data Storage Performance: SQL or NoSQL, Physical or Virtual. Fifth International Conference on Cloud Computing, Honolulu, s. 431-438. IEEE, 2012.
[5] Oussous A., Benjelloun F. Z., Lahcen A. A., Belfkih S.: Comparison and classification of nosql databases for big data. International Journal of Database Theory and Application, 6, April, 2013.
[6] Shetty Deepika V., Chidimar S. J.: Comparative Study of SQL and NoSQL Databases to evaluate their suitability for Big Data Application. International Journal of Computer Science and Information Technology Research, June, s. 314-318. 2016.
[7] Kunda, D., Phiri, H.: A Comparative Study of NoSQL and Relational Database. Zambia ICT Journal. Tom 1, s. 1-4. 2017
[8] Bathla, G., Rani, R., Aggarwal, H.: Comparative study of NoSQL databases for big data storage. International Journal of Engineering & Technology, 2018.
[9] Mondal, A. S., Sanyal, M., Chattopadhyay, S., Mondal, K. C.: Comparative Analysis of Structured and Un-Structured Databases. International Conference on Computational Intelligence, Communications, and Business Analytics, s. 226-241. Springer, Singapore, March, 2017.
[10] Introduction - StarUML documentation. https://docs.staruml.io/[05.05.2019].
Download

Published : 2019-09-30


Filatov, A., Flis, P., & Pańczyk, B. (2019). Storage efficiency comparison of UML models in selected database technologies. Journal of Computer Sciences Institute, 12, 193-198. https://doi.org/10.35784/jcsi.437

Andrii Filatov 
Lublin University of Technology  Ukraine
Paweł Flis  stercage@gmail.com
Lublin University of Technology  Poland
Beata Pańczyk 
Lublin University of Technology  Poland