About this paper

Appears in:
Pages: 3231-3238
Publication year: 2018
ISBN: 978-84-09-02709-5
ISSN: 2340-1117
doi: 10.21125/edulearn.2018.0851

Conference name: 10th International Conference on Education and New Learning Technologies
Dates: 2-4 July, 2018
Location: Palma, Spain

ANALYSIS OF THE PERFORMANCE OF RELATIONAL AND NON-RELATIONAL DATABASES ON THE EXAMPLE OF AN APPLICATION SUPPORTING MANAGERS

M. Skublewska-Paszkowska, J. Borowicz, H. Iwanicki

Lublin University of Technology (POLAND)
Current IT systems use different databases to store and manage data. Most systems are based on relational databases that use SQL in order to manipulate data. Non-relational systems (NoSQL) have recently gained more and more popularity. An important issue for database systems is the speed of downloading and managing data. The higher it is, the better the system is evaluated by its users.

During computer science education at technical universities, the students are taught various types of databases at lectures and laboratory classes. The obtained knowledge can be further improved in academic research projects that are included into the curricula of IT programmes. In this type of classes, the students are asked to design and implement an application or a system. These projects both enhance the process of learning and improve the undergraduate experience. Moreover, the created software is very often used to perform research, especially during master’s studies, which is an essential element of this education.

The purpose of the paper is to analyse the efficiency of using a relational and non-relational system to process data of an internet application supporting the work of managers. The analysis was performed for two relational database systems: MySQL and Oracle and two non-relational systems: MongoDB and Apache Cassandra. Execution time was measured for: data collection, conditional data collection, conditional data connection for joined tables, adding data to the database and its update.

The students who are involved in this type of academic research projects gain the experience which is very useful in their professional careers. These classes ensure that the university educates the graduates who are targeted due to the requirements of the labour market.
@InProceedings{SKUBLEWSKAPASZKOWSKA2018ANA,
author = {Skublewska-Paszkowska, M. and Borowicz, J. and Iwanicki, H.},
title = {ANALYSIS OF THE PERFORMANCE OF RELATIONAL AND NON-RELATIONAL DATABASES ON THE EXAMPLE OF AN APPLICATION SUPPORTING MANAGERS},
series = {10th International Conference on Education and New Learning Technologies},
booktitle = {EDULEARN18 Proceedings},
isbn = {978-84-09-02709-5},
issn = {2340-1117},
doi = {10.21125/edulearn.2018.0851},
url = {http://dx.doi.org/10.21125/edulearn.2018.0851},
publisher = {IATED},
location = {Palma, Spain},
month = {2-4 July, 2018},
year = {2018},
pages = {3231-3238}}
TY - CONF
AU - M. Skublewska-Paszkowska AU - J. Borowicz AU - H. Iwanicki
TI - ANALYSIS OF THE PERFORMANCE OF RELATIONAL AND NON-RELATIONAL DATABASES ON THE EXAMPLE OF AN APPLICATION SUPPORTING MANAGERS
SN - 978-84-09-02709-5/2340-1117
DO - 10.21125/edulearn.2018.0851
PY - 2018
Y1 - 2-4 July, 2018
CI - Palma, Spain
JO - 10th International Conference on Education and New Learning Technologies
JA - EDULEARN18 Proceedings
SP - 3231
EP - 3238
ER -
M. Skublewska-Paszkowska, J. Borowicz, H. Iwanicki (2018) ANALYSIS OF THE PERFORMANCE OF RELATIONAL AND NON-RELATIONAL DATABASES ON THE EXAMPLE OF AN APPLICATION SUPPORTING MANAGERS, EDULEARN18 Proceedings, pp. 3231-3238.
User:
Pass: