Uma análise comparativa sobre o uso de bancos de dados relacional e não relacional no contexto de aplicações web

Abstract

Databases are structures intended to store information about a given context. The stored information can be classified as relational, when structured, or non-relational, when heterogeneous and semi-structured or unstructured. The amount and type of data directly depend on the storage environment’s origin. Web applications, for example, tend to generate data in large quantities and varieties. of formats. To deal with this data, it is necessary to use software that allows the creation, organization, and manipulation of them, which are the Management Systems of Database (DBMSs). Currently, there are a variety of DBMSs on the market, and for Working with the high demand for data storage and processing, it is essential to take into account the DBMS to be chosen, its specificities, and limitations. MOTIVATION: However, from the literature review carried out, it was concluded that there are no recent works in the literature that raise requirements and characteristics that help in the choice of DBMSs in the context of Web applications. OBJECTIVE: To help fill this gap, the main objective of this study is to compare the most used DBMSs in applications Web, to present the results and their main characteristics. The chosen DBMSs were: MySQL (relational database) and MongoDB (non-relational databaseoriented documents). METHODOLOGY: To obtain the results, the study was divided into two parts. In the first part, a comparison was carried out based on static aspects of databases. In the second part, the Database Management System (DBMS) were dynamically compared, where the aim was to submit them to the same queries, even hardware and using similar databases. At the end of the two stages, it was possible to raise characteristics of DBMSs and evaluate metrics, such as performance and performance. RESULTS: As a result, it was observed that MySQL and MongoDB present similar responses about static comparison, differing only in the classification of the CAP Theorem. With Regarding adaptability, MongoDB supports a greater number of programming languages programming, MySQL wins about the number of Operating Systems (OS) supported. Already in the dynamic analysis, the results showed the efficiency of MongoDB, with better performance in the consumption of Random Access Memory (RAM), Central Processing Unit (CPU), and storage space disk of stored data, in addition to lower time execution. BENEFICIARIES: The results of the screen work are useful for professionals in the field of databases and Web development, such as software engineers and developers, as well as companies that use them.