RESEARCH OF METHODS OF SOFTWARE IMPLEMENTATION OF THE COSMOS DB API ON THE .NET PLATFORM
DOI:
https://doi.org/10.30837/ITSSI.2023.24.118Keywords:
DATABASE; COSMOS DB API; MONGODB; .NET; NOSQLAbstract
Large number of developers use the .NET platform to create applications that work with databases today. In turn, Cosmos DB is becoming an increasingly popular choice as a NoSQL storage for such databases. Cosmos DB is a flexible and scalable system, and the correct selection of the appropriate API during software implementation can significantly affect the performance of the programs themselves. Cosmos DB provides different APIs for working with different types of databases, such as SQL databases, running MongoDB or Cassandra. In turn, each of these APIs can be used using various methods of software implementation. The subject of research is software implementations on the .NET platform for various Cosmos DB APIs. When choosing the most suitable Cosmos DB API on the .NET platform, developers can be helped not only by the documentation, but also by the results of experimental studies of these APIs, which in turn will improve the quality of the code and the performance of the systems themselves. The goal of the work is to increase the efficiency of software development on the .NET platform. That use the Cosmos DB API, by developing a recommendation for the selection of software implementation methods for these APIs based on the results of their experimental research. The task: to investigate and compare the methods of software implementation of the Cosmos DB API through an experimental study of the performance of different types of queries on these software solutions; analyze the obtained results and develop recommendations for the use of methods. Methods: multi-criteria analysis of Cosmos DB API, logical data modeling, experimental research. Results: developed software solutions based on the use of CosmosClient, Entity Framework Core for Cosmos DB API for NoSQL and based on MongoClient for Cosmos DB API for MongoDB. A series of experiments and measurements of performance metrics for each of the software solutions were conducted, the obtained results were analyzed, and recommendations were offered for using the considered methods of software implementations of the Cosmos DB API on the .NET platform. Conclusion: In general, the choice of software approach depends on the specific task, but experiments have shown that CosmosDB API for NoSQL using CosmosClient is the best choice for small projects, and using the Entity Framework Core Cosmos is suitable for more complex projects with larger volumes of data and complex queries. If MongoDB is used in the project, then the corresponding solution using MongoClient is a better option than Cosmos DB API for NoSQL.
References
Список літератури
Filatov V., Semenets V. Methods for Synthesis of Relational Data Model in Information Systems Reengineering Problems. International Scientific-Practical Conference Problems of Infocommunications. Science and Technology (PIC S&T). IEEE. 2018. URL: https://www.researchgate.net/publication/331418031_Methods_for_Synthesis_of_Relational_Data_Model_in_Information_Systems_Reengineering_Problems
Smelyakov K., Prokopenko O., Chupryna A. Object-Based Image Comparison Algorithm Development for Data Storage Management Systems. CEUR Workshop Proceedings, 2022. № 3171. Р. 1251–1266. URL: https://ceur-ws.org/Vol-3171/paper92.pdf
Mazurova, O., Naboka, A., Shirokopetleva, M. Research of ACID transaction implementation methods for distributed databases using replication technology. Innovative technologies and scientific solutions for industries, № 2 (16). 2021. P. 19–31. DOI: 10.30837/ITSSI.2021.16.019
Mazurova O., Syvolovskyi I., Syvolovska O. NOSQL database logic design methods for MONGODB and NEO4J. Innovative technologies and scientific solutions for industries, № 2 (20), 2022. P. 52–63. DOI: 10.30837/ITSSI.2022.20.052.
Sahatqija K., Ajdari J., Zenuni X., Raufi B., Ismaili F. Comparison between relational and NOSQL databases. 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO). 2018. P. 216–221. DOI: https://doi.org/10.23919/mipro.2018.8400041
Maran M., Paniavin N., Poliushkin I. Alternative Approaches to Data Storing and Processing. V International Conference on Information Technologies in Engineering Education (Inforino). 2020. Р. 1–4. DOI: https://doi.org/10.1109/inforino48376.2020.9111708
Falatiuk H., Shirokopetleva M., Dudar Z. Investigation of Architecture and Technology Stack for e-Archive System. IEEE International Scientific-Practical Conference Problems of Infocommunications, Science and Technology (PIC S&T). 2019. P. 229–235. DOI: 10.1109/PICST47496.2019.9061407
Gomes C., Borba E., Tavares E., Junior M. N. de O. Performability Model for Assessing NoSQL DBMS Consistency. IEEE International Systems Conference (SysCon). 2019. DOI: https://doi.org/10.1109/syscon.2019.8836757
Kuzochkina A., Shirokopetleva M., Dudar Z. Analyzing and Comparison of NoSQL DBMS. International Scientific-Practical Conference on Problems of Infocommunications Science and Technology (PIC S&T). 2018. Р. 560–564. DOI: 10.1109/INFOCOMMST.2018.8632133
Bai Y. SQL Server Database Programming with Visual Basic.NET: Concepts, Designs and Implementations. 2020. 688 p, URL: https://www.wiley.com/en-ie/SQL+Server+Database+Programming+with+Visual+Basic+NET:+Concepts,+Designs+and+Implementations-p-9781119608608
Renée, M. P., Teate SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis. 2021. 288 p, URL: https://www.wiley.com/en-us/SQL+for+Data+Scientists%3A+A+Beginner%27s+Guide+for+Building+Datasets+for+Analysis-p-9781119669364
Peretiatko M., Shirokopetleva M., Lesna N. Research of methods to support data migration between relational and document data storage models. Innovative technologies and scientific solutions for industries. № 2 (20). 2022. P. 64–74. DOI: 10.30837/ITSSI.2022.20.064
Palanisamy S., SuvithaVani P. A survey on RDBMS and NoSQL Databases MySQL vs MongoDB. Conference: 2020 International Conference on Computer Communication and Informatics (ICCCI). 2020. URL: https://www.researchgate.net/publication/341812161_A_survey_on_RDBMS_and_NoSQL_Databases_MySQL_vs_MongoDB
Ponniah P. Database Design and Development: An Essential Guide for IT Professionals. 2003. 768 p. URL: http://www.sbu.unicamp.br/bases-nfs/b131/lista_131_4.xlsx
Gruzdo I., Kyrychenko I., Tereshchenko G., Shanidze N. Metrics applicable for evaluating software at the design stage. 5th International Conference on Computational Linguistics and In-telligent Systems (COLINS-2021). Kharkiv, Ukraine,April 22–23, 2021. CEUR Workshop Proceedings, 2021, Volume I. Р. 916–936. URL: https://ceur-ws.org/Vol-2870/paper69.pdf
Perkins B., Panek W. Microsoft Azure Architect Technologies and Design Complete Study Guide: Exams AZ-303 and AZ-304. 2020. 768p. URL: https://www.wiley.com/en-ba/Microsoft+Azure+Architect+Technologies+and+Design+Complete+Study+Guide:+Exams+AZ+303+and+AZ+304-p-9781119559580
References
Filatov, V., Semenets, V. (2018), "Methods for Synthesis of Relational Data Model in Information Systems Reengineering Problems", International Scientific-Practical Conference Problems of Infocommunications. Science and Technology (PIC S&T), IEEE, available at: https://www.researchgate.net/publication/331418031_Methods_for_Synthesis_of_Relational_Data_Model_in_Information_Systems_Reengineering_Problems
Smelyakov, K., Prokopenko, O., Chupryna, A. (2022), "Object-Based Image Comparison Algorithm Development for Data Storage Management Systems", CEUR Workshop Proceedings, No. 3171, P. 1251–1266, available at: https://ceur-ws.org/Vol-3171/paper92.pdf
Mazurova, O., Naboka, A., Shirokopetleva, M. (2021) "Research of ACID transaction implementation methods for distributed databases using replication technology", Innovative technologies and scientific solutions for industries, No. 2 (16), Р. 19–31. DOI: 10.30837/ITSSI.2021.16.019
Mazurova, O., Syvolovskyi, I., Syvolovska, O. (2022) "NOSQL database logic design methods for MONGODB and NEO4J", Innovative technologies and scientific solutions for industries, No. 2 (20), Р. 52–63. DOI: 10.30837/ITSSI.2022.20.052
Sahatqija, K., Ajdari, J., Zenuni, X., Raufi, B., Ismaili, F., (2018), "Comparison between relational and NOSQL databases", 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO), P. 216–221. DOI: https://doi.org/10.23919/mipro.2018.8400041
Maran, M., Paniavin, N., Poliushkin, I. (2020), "Alternative Approaches to Data Storing and Processing", V International Conference on Information Technologies in Engineering Education (Inforino), Р. 1–4. DOI: https://doi.org/10.1109/inforino48376.2020.9111708
Falatiuk, H., Shirokopetleva, M., Dudar, Z. (2019), "Investigation of Architecture and Technology Stack for e-Archive System", IEEE International Scientific-Practical Conference Problems of Infocommunications, Science and Technology (PIC S&T), P. 229–235. DOI: 10.1109/PICST47496.2019.9061407
Gomes, C., Borba, E., Tavares, E., Junior, M. N. de O. (2019), "Performability Model for Assessing NoSQL DBMS Consistency", IEEE International Systems Conference (SysCon), DOI: https://doi.org/10.1109/syscon.2019.8836757
Kuzochkina, A., Shirokopetleva, M., Dudar, Z. (2018), "Analyzing and Comparison of NoSQL DBMS", International Scientific-Practical Conference on Problems of Infocommunications Science and Technology PIC S&T, P. 560–564. DOI: 10.1109/INFOCOMMST.2018.8632133
Bai, Y., (2020), "SQL Server Database Programming with Visual Basic.NET: Concepts, Designs and Implementations". 688 p, available at: https://www.wiley.com/en-ie/SQL+Server+Database+Programming+with+Visual+Basic+NET:+Concepts,+Designs+and+Implementations-p-9781119608608
Renée, M. (2021), Teate SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis. 288 p. available at: https://www.wiley.com/enus/SQL+for+Data+Scientists%3A+A+Beginner%27s+Guide+for+Building+Datasets+for+Analysis-p-9781119669364
Peretiatko, M., Shirokopetleva, M., Lesna, N. (2022) "Research of methods to support data migration between relational and document data storage models", Innovative technologies and scientific solutions for industries, No. 2 (20), Р. 64–74. DOI: 10.30837/ITSSI.2022.20.064
Palanisamy, S., SuvithaVani, P. (2020), "A survey on RDBMS and NoSQL Databases MySQL vs MongoDB", International Conference on Computer Communication and Informatics (ICCCI), available at: https://www.researchgate.net/publication/341812161_A_survey_on_RDBMS_and_NoSQL_Databases_MySQL_vs_MongoDB
Ponniah, P. (2003), Database Design and Development: An Essential Guide for IT Professionals. 768 p, available at: http://www.sbu.unicamp.br/bases-nfs/b131/lista_131_4.xlsx
Gruzdo, I., Kyrychenko, I., Tereshchenko, G., Shanidze, N. (2021), "Metrics applicable for evaluating software at the design stage", 5th International Conference on Computational Linguistics and In-telligent Systems (COLINS-2021), Kharkiv, Ukraine, April 22–23, CEUR Workshop Proceedings, 2021, Volume I, P. 916–936, available at: https://ceur-ws.org/Vol-2870/paper69.pdf
Perkins, B., Panek, W. (2020), "Microsoft Azure Architect Technologies and Design Complete Study Guide: Exams AZ-303 and AZ-304". 768p. available at: https://www.wiley.com/enba/Microsoft+Azure+Architect+Technologies+and+Design+Complete+Study+Guide:+Exams+AZ+303+and+AZ+304-p-9781119559580
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Оксана Мазурова, Микола Андрущенко, Марія Широкопетлєва
![Creative Commons License](http://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png)
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Our journal abides by the Creative Commons copyright rights and permissions for open access journals.
Authors who publish with this journal agree to the following terms:
Authors hold the copyright without restrictions and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License (CC BY-NC-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
Authors are able to enter into separate, additional contractual arrangements for the non-commercial and non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
Authors are permitted and encouraged to post their published work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.