COMPARISON OF SQL AND NOSQL DATABASES

Abstract

Over the past decades, the number of applications that generate big amount of data has increased significantly. But this data will be useful only if the database keeps up and maintains the necessary processing speed. The purpose of this article is to compare two types of databases. An analytical review of relational and non-relational databases was conducted. The advantages and disadvantages of SQL and NoSQL databases was analyzed. The purpose of this work is to compare two types of databases. Determine which type suits best depending on the task. Performance of SQL and NoSQL database-management system was measured. With using of the program Sysbench based on the Linux operating system, MySQL and MongoDB were tested.

Authors and Affiliations

М. Ю. Швець, Д. С. Заруба, Ю. В. Хохлов

Keywords

Related Articles

USING THE «LP-SEARCH» METHOD FOR OPTIMIZING PARAMETERS OF THE RELIEF VALVE OF THE DIRECTIONAL CONTROL VALVE FOR THE LOAD-SENSING HYDRAULIC DRIVES

The scientific article is developed to use of the «LP-search» method for optimizing the parameters of the relief valve of the directional control valve for load-sensing hydraulic drives. The task of optimization consists...

SYSTEM PARAMETERS INVESTIGATION FOR STEFAN PROBLEM SOLVING BY THE CONTINUOUS ASYNCHRONOUS CELLULAR AUTOMATA METHOD

The main object of this work is to construct a cellular automaton (CA) model of heat conductivity processes with first order phase transitions. The paper discusses main approaches and general methodology for development...

QUALIMETRIC ASSESSMENT OF QUALITY OF KEKSU WITH USE OF COLLECTIVE RAW MATERIAL

The article gives the calculation of the competitiveness of the test sample of the cupcake, which was evaluated using the modeling technique. According to the results of the calculation of the competitiveness index, it w...

PROGNOSIS OF BIOLOGICAL ACTIVITY AND DRUG-LIKE COMPLEX OF THE RANUNCULACEAE FAMILY AS A SEARCH FOR NEW EFFECTIVE ACTIVE SUBSTANCES

Despite the huge arsenal of available drugs, the problem of finding new high-performance medicines remains relevant. Therefore, nowadays increasingly the initial stage of the search for pharmacologically active substance...

ANALYSIS AND RESEARCH OF INFORMATION TECHNOLOGIES FOR SOFTWARE DEVELOPMENT

This paper analyzes the main trends of development of software development information technology and software requirements, indicators and criteria of optimization and approaches of mathematical formalization of relevan...

Download PDF file
  • EP ID EP580278
  • DOI -
  • Views 58
  • Downloads 0

How To Cite

М. Ю. Швець, Д. С. Заруба, Ю. В. Хохлов (2018). COMPARISON OF SQL AND NOSQL DATABASES. Вчені записки Таврійського національного університету імені В. І. Вернадського. Серія: Технічні науки, 29(6), 21-24. https://europub.co.uk/articles/-A-580278