CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL
Databases are data collections organized for easy access and management, available simultaneously to multiusers. Access to the data can be controlled through various permissions, ensuring that users have the appropriate level of access based on their roles. This structure not only enhances data...
Saved in:
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Academica Brâncuşi
2024-12-01
|
| Series: | Analele Universităţii Constantin Brâncuşi din Târgu Jiu : Seria Economie |
| Subjects: | |
| Online Access: | https://www.utgjiu.ro/revista/ec/pdf/2024-06,%20Volumul%20II/04_Babucea.pdf |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1841560761640419328 |
|---|---|
| author | BABUCEA ANA-GABRIELA |
| author_facet | BABUCEA ANA-GABRIELA |
| author_sort | BABUCEA ANA-GABRIELA |
| collection | DOAJ |
| description | Databases are data collections organized for easy access and management, available simultaneously to
multiusers. Access to the data can be controlled through various permissions, ensuring that users have the appropriate
level of access based on their roles. This structure not only enhances data security but also improves collaboration
among users, making it easier to share and analyze information efficiently. Databases are controlled through database
management systems (DBMS) that allow users to add, modify, delete, locate, and view database data using specific
languages provided in most database management software packages. The ability to query the database for particular
information is the most powerful capability of any database management system. If we mean that databases have
evolved to facilitate tasks such as searching, sorting, or reporting data and updating it based on user requirements,
these tasks may be simple in essence, but when vast volumes of data are handled that are frequently accessed by multi
users or stand-alone systems, the databases themselves become quite complex. This paper aims to compare the
different database systems (SQL, NoSQL, and NewSQL), respectively, and the database models implemented by them
from the perspective of the characteristics, similarities, and differences, as well as the advantages and disadvantages of
their use in a concrete situations. Since each database type has advantages and disadvantages based on the particular
context of use, selecting a database type is never simple and always necessitates a thorough examination of the
application requirements and long-term benefits. This paper concentrated on evaluating the three main database types,
SQL, NoSQL, and NewSQL, by comparing their essential features, assessing their benefits and limitations, and
exploring their most suitable applications across various use cases. The study's conclusions could help choose the best
database based on the business process requirements for the enterprise's tasks. |
| format | Article |
| id | doaj-art-2b296e38ccbd4bf8be2eeed451b80bba |
| institution | Kabale University |
| issn | 1844-7007 2344-3685 |
| language | English |
| publishDate | 2024-12-01 |
| publisher | Academica Brâncuşi |
| record_format | Article |
| series | Analele Universităţii Constantin Brâncuşi din Târgu Jiu : Seria Economie |
| spelling | doaj-art-2b296e38ccbd4bf8be2eeed451b80bba2025-01-03T15:23:14ZengAcademica BrâncuşiAnalele Universităţii Constantin Brâncuşi din Târgu Jiu : Seria Economie1844-70072344-36852024-12-01263540CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL BABUCEA ANA-GABRIELA 0PROF., PHD, “CONSTANTIN BRANCUSI” UNIVERSITY OF TARGU JIU, ROMANIADatabases are data collections organized for easy access and management, available simultaneously to multiusers. Access to the data can be controlled through various permissions, ensuring that users have the appropriate level of access based on their roles. This structure not only enhances data security but also improves collaboration among users, making it easier to share and analyze information efficiently. Databases are controlled through database management systems (DBMS) that allow users to add, modify, delete, locate, and view database data using specific languages provided in most database management software packages. The ability to query the database for particular information is the most powerful capability of any database management system. If we mean that databases have evolved to facilitate tasks such as searching, sorting, or reporting data and updating it based on user requirements, these tasks may be simple in essence, but when vast volumes of data are handled that are frequently accessed by multi users or stand-alone systems, the databases themselves become quite complex. This paper aims to compare the different database systems (SQL, NoSQL, and NewSQL), respectively, and the database models implemented by them from the perspective of the characteristics, similarities, and differences, as well as the advantages and disadvantages of their use in a concrete situations. Since each database type has advantages and disadvantages based on the particular context of use, selecting a database type is never simple and always necessitates a thorough examination of the application requirements and long-term benefits. This paper concentrated on evaluating the three main database types, SQL, NoSQL, and NewSQL, by comparing their essential features, assessing their benefits and limitations, and exploring their most suitable applications across various use cases. The study's conclusions could help choose the best database based on the business process requirements for the enterprise's tasks. https://www.utgjiu.ro/revista/ec/pdf/2024-06,%20Volumul%20II/04_Babucea.pdfdatabasestechnological changesqlnosqlnewsqlcomparative analysis |
| spellingShingle | BABUCEA ANA-GABRIELA CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL Analele Universităţii Constantin Brâncuşi din Târgu Jiu : Seria Economie databases technological change sql nosql newsql comparative analysis |
| title | CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL |
| title_full | CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL |
| title_fullStr | CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL |
| title_full_unstemmed | CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL |
| title_short | CHOOSING THE APPROPRIATE DATABASE TYPE: A COMPARISON OF SQL, NOSQL, AND NEWSQL |
| title_sort | choosing the appropriate database type a comparison of sql nosql and newsql |
| topic | databases technological change sql nosql newsql comparative analysis |
| url | https://www.utgjiu.ro/revista/ec/pdf/2024-06,%20Volumul%20II/04_Babucea.pdf |
| work_keys_str_mv | AT babuceaanagabriela choosingtheappropriatedatabasetypeacomparisonofsqlnosqlandnewsql |