Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators

Alvaro Monjaras; Enrique Bcndezu; Carlos Raymundo

doi:10.1109/ICITM.2019.8710696

Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators

Alvaro Monjaras
, Enrique Bcndezu
, Carlos Raymundo

Faculty of Engineering

Universidad Peruana de Ciencias Aplicadas

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

1 Scopus citations

Abstract

There are currently several types of databases that have different ways of manipulating data that affects the performance of transactions when dealing with the information stored. And it is very important for companies to manage information fast, so they do not lose any operation because of a bad performance of a database, in the same way, they need to operate fast while keeping the integrity of the information. Likewise, every database category's purpose is to serve a specific or specifics use cases to perform fast to manage the information when needed, so in this paper, we study and analyze the SQL, NoSQL and In Memory databases to understand their fit uses cases and make performance tests to build a decision tree that can help to take the decision to choose what database category to use to maintain a good performance. The precision of the tests of relational databases was 96.26% in NoSQL databases was 91.83% and finally in IMDBS was 93.87%.

Original language	English
Title of host publication	Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019
Publisher	Institute of Electrical and Electronics Engineers Inc.
Pages	353-357
Number of pages	5
ISBN (Electronic)	9781728132686
DOIs	https://doi.org/10.1109/ICITM.2019.8710696
State	Published - 9 May 2019
Event	8th International Conference on Industrial Technology and Management, ICITM 2019 - Cambridge, United Kingdom Duration: 2 Mar 2019 → 4 Mar 2019

Publication series

Name	Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019

Conference

Conference	8th International Conference on Industrial Technology and Management, ICITM 2019
Country/Territory	United Kingdom
City	Cambridge
Period	2/03/19 → 4/03/19

UN SDGs

This output contributes to the following UN Sustainable Development Goals (SDGs)

SDG 9 Industry, Innovation, and Infrastructure

Keywords

component database
decision tree
in memory database
nosql
performance
SQL

Access to Document

10.1109/ICITM.2019.8710696

Cite this

Monjaras, A., Bcndezu, E., & Raymundo, C. (2019). Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators. In Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019 (pp. 353-357). Article 8710696 (Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/ICITM.2019.8710696

Monjaras, Alvaro ; Bcndezu, Enrique ; Raymundo, Carlos. / Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators. Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019. Institute of Electrical and Electronics Engineers Inc., 2019. pp. 353-357 (Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019).

@inproceedings{6d32c1b530d14b20b2bf551d19205085,

title = "Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators",

abstract = "There are currently several types of databases that have different ways of manipulating data that affects the performance of transactions when dealing with the information stored. And it is very important for companies to manage information fast, so they do not lose any operation because of a bad performance of a database, in the same way, they need to operate fast while keeping the integrity of the information. Likewise, every database category's purpose is to serve a specific or specifics use cases to perform fast to manage the information when needed, so in this paper, we study and analyze the SQL, NoSQL and In Memory databases to understand their fit uses cases and make performance tests to build a decision tree that can help to take the decision to choose what database category to use to maintain a good performance. The precision of the tests of relational databases was 96.26\% in NoSQL databases was 91.83\% and finally in IMDBS was 93.87\%.",

keywords = "component database, decision tree, in memory database, nosql, performance, SQL",

author = "Alvaro Monjaras and Enrique Bcndezu and Carlos Raymundo",

note = "Publisher Copyright: {\textcopyright} 2019 IEEE.; 8th International Conference on Industrial Technology and Management, ICITM 2019 ; Conference date: 02-03-2019 Through 04-03-2019",

year = "2019",

month = may,

day = "9",

doi = "10.1109/ICITM.2019.8710696",

language = "Ingl{\'e}s",

series = "Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019",

publisher = "Institute of Electrical and Electronics Engineers Inc.",

pages = "353--357",

booktitle = "Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019",

}

Monjaras, A, Bcndezu, E & Raymundo, C 2019, Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators. in Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019., 8710696, Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019, Institute of Electrical and Electronics Engineers Inc., pp. 353-357, 8th International Conference on Industrial Technology and Management, ICITM 2019, Cambridge, United Kingdom, 2/03/19. https://doi.org/10.1109/ICITM.2019.8710696

Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators. / Monjaras, Alvaro; Bcndezu, Enrique; Raymundo, Carlos.
Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019. Institute of Electrical and Electronics Engineers Inc., 2019. p. 353-357 8710696 (Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators

AU - Monjaras, Alvaro

AU - Bcndezu, Enrique

AU - Raymundo, Carlos

PY - 2019/5/9

Y1 - 2019/5/9

N2 - There are currently several types of databases that have different ways of manipulating data that affects the performance of transactions when dealing with the information stored. And it is very important for companies to manage information fast, so they do not lose any operation because of a bad performance of a database, in the same way, they need to operate fast while keeping the integrity of the information. Likewise, every database category's purpose is to serve a specific or specifics use cases to perform fast to manage the information when needed, so in this paper, we study and analyze the SQL, NoSQL and In Memory databases to understand their fit uses cases and make performance tests to build a decision tree that can help to take the decision to choose what database category to use to maintain a good performance. The precision of the tests of relational databases was 96.26% in NoSQL databases was 91.83% and finally in IMDBS was 93.87%.

AB - There are currently several types of databases that have different ways of manipulating data that affects the performance of transactions when dealing with the information stored. And it is very important for companies to manage information fast, so they do not lose any operation because of a bad performance of a database, in the same way, they need to operate fast while keeping the integrity of the information. Likewise, every database category's purpose is to serve a specific or specifics use cases to perform fast to manage the information when needed, so in this paper, we study and analyze the SQL, NoSQL and In Memory databases to understand their fit uses cases and make performance tests to build a decision tree that can help to take the decision to choose what database category to use to maintain a good performance. The precision of the tests of relational databases was 96.26% in NoSQL databases was 91.83% and finally in IMDBS was 93.87%.

KW - component database

KW - decision tree

KW - in memory database

KW - nosql

KW - performance

KW - SQL

UR - https://www.scopus.com/pages/publications/85066632248

U2 - 10.1109/ICITM.2019.8710696

DO - 10.1109/ICITM.2019.8710696

M3 - Contribución a la conferencia

AN - SCOPUS:85066632248

T3 - Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019

SP - 353

EP - 357

BT - Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019

PB - Institute of Electrical and Electronics Engineers Inc.

T2 - 8th International Conference on Industrial Technology and Management, ICITM 2019

Y2 - 2 March 2019 through 4 March 2019

ER -

Monjaras A, Bcndezu E, Raymundo C. Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators. In Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019. Institute of Electrical and Electronics Engineers Inc. 2019. p. 353-357. 8710696. (Proceedings of 2019 8th International Conference on Industrial Technology and Management, ICITM 2019). doi: 10.1109/ICITM.2019.8710696

Decision Tree Model to Support the Successful Selection of a Database Engine for Novice Database Administrators

Abstract

Publication series

Conference

UN SDGs

Keywords

Access to Document

Other files and links

Fingerprint

Cite this