A Comparative Study of Relational and Non-Relational Database Models in a Web- Based Application

Győrödi, Cornelia; Győrödi, Robert; Sotoc, Roxana

doi:10.14569/ijacsa.2015.061111

Cited by 28 publications

(20 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Mainly, NoSQL databases are designed to allow us insertion of data for which we do not have a predefined schema, as the structure of our data is not set [7].…”

Section: Presentation Of the Application Databasementioning

confidence: 99%

A Comparative Study Between the Capabilities of MySQl Vs. MongoDB as a Back-End for an Online Platform

Győrödi¹,

Győrödi²,

Andrada³

et al. 2016

ijacsa

Self Cite

View full text Add to dashboard Cite

Abstract-In this article we present a comparative study between the usage capabilities of MongoDB, a non-relational database, and MySQL's usage capabilities, a relational database, as a back-end for an online platform. We will also present the advantages of using a non-relational database, namely MongoDB, compared to a relational database, namely MySQL, integrated in an online platform, which allows users to publish different articles, books, magazines and so on, and also gives them the possibility to share online their items with other people. Nowadays, most applications have thousands of users that perform operations simultaneously thus, it takes more than one operation to be executed at a time, to really see the differences between the two databases. This paper aims to highlight the differences between MySQL and MongoDB, integrated in an online platform, when various operations were executed in parallel by many users.

show abstract

“…Mainly, NoSQL databases are designed to allow us insertion of data for which we do not have a predefined schema, as the structure of our data is not set [7].…”

Section: Presentation Of the Application Databasementioning

confidence: 99%

A Comparative Study Between the Capabilities of MySQl Vs. MongoDB as a Back-End for an Online Platform

Győrödi¹,

Győrödi²,

Andrada³

et al. 2016

ijacsa

Self Cite

View full text Add to dashboard Cite

show abstract

“…Relational Database Management Systems (RDBMS) have been the dominant model for more than 40 years. The relational model has a rigid schema with a clear structure [20]. Despite the robustness of RDBMS, it has limitations.…”

Section: Introductionmentioning

confidence: 99%

“…Despite the robustness of RDBMS, it has limitations. It cannot handle the increasing size of data or process unstructured information [20].…”

Section: Introductionmentioning

confidence: 99%

Diftong: a tool for validating big data workflows

et al. 2019

View full text Add to dashboard Cite

Data validation is about verifying the correctness of data. When organisations update and refine their data transformations to meet evolving requirements, it is imperative to ensure that the new version of a workflow still produces the correct output. We motivate the need for workflows and describe the implementation of a validation tool called Diftong. This tool compares two tabular databases resulting from different versions of a workflow to detect and prevent potential unwanted alterations. Row-based and column-based statistics are used to quantify the results of the database comparison. Diftong was shown to provide accurate results in test scenarios, bringing benefits to companies that need to validate the outputs of their workflows. By automating this process, the risk of human error is also eliminated. Compared to the more labourintensive manual alternative, it has the added benefit of improved turnaround time for the validation process. Together this allows for a more agile way of updating data transformation workflows.

show abstract

“…It is necessary to do a careful analysis and consider main factors as the amount of data, the flexibility of schema, the budget, the amount of transactions that would be made, when choosing the data model for the application [13].…”

Section: Introductionmentioning

confidence: 99%

“…Generally, for smaller and medium applications, a relational database would be advisable and for big applications, that use and manipulate large quantities of data, a nonrelational database is more appropriate [13].…”

Section: Introductionmentioning

confidence: 99%

A Comparative Study of Databases with Different Methods of Internal Data Management

Győrödi¹,

Győrödi²,

Stefan³

et al. 2016

ijacsa

View full text Add to dashboard Cite

Abstract-The purpose of this paper is to present a comparative study between a non-relational MongoDB database and a relational Microsoft SQL Server database in the case of an unstructured representation of data, in XML or JSON format. We mainly focus our presentation on exploring all the possibilities that each type of database offers us, in the case that the data, which has to be stored, cannot or is not wanted to be normalized. This is a scenario most often found in production when, for the application that is being developed we are extracting unstructured data from social networks or all kinds of different channels that the user might have. The comparative study is based on the creation of a benchmark application developed in C# using Visual Studio 2013, which accesses databases created beforehand with proper optimizations that will be described.

show abstract

A Comparative Study of Relational and Non-Relational Database Models in a Web- Based Application

Cited by 28 publications

References 1 publication

A Comparative Study Between the Capabilities of MySQl Vs. MongoDB as a Back-End for an Online Platform

A Comparative Study Between the Capabilities of MySQl Vs. MongoDB as a Back-End for an Online Platform

Diftong: a tool for validating big data workflows

A Comparative Study of Databases with Different Methods of Internal Data Management

Contact Info

Product

Resources

About