Analysis of Query Processing on Different Databases

Mohammed Salahat; Muhammad Ahsan Raza; Zuha Khawar; Javaid Ahmad Malik; Hammad Raza; Harish K.G. Nair; Muath Jarrah

doi:10.1109/ICBATS57792.2023.10111417

Analysis of Query Processing on Different Databases

Mohammed Salahat
, Muhammad Ahsan Raza
, Zuha Khawar
, Javaid Ahmad Malik
, Hammad Raza
, Harish K.G. Nair
, Muath Jarrah

University of Fujairah
University of Education
Bahauddin Zakariya University
NCBA&E
Applied Science Private University
Skyline University College

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

Abstract

The most trustworthy method for categorizing data into updateable and searchable collections in modern times is database management systems. However, there are different DBMS systems available, and each has its own pros and cons regarding dependability, use, performance, and its security. The performance of the main DBMS systems is compared in this paper. Oracle, MS SQL Server, MS Access, MySQL and IBM DB2 are the prominent ones. The five DBMSs under examination will be subjected to a variety of SQL queries with varying levels of complexity. After the test, this would make it possible to create a comparison analysis among them that displays the average execution time of each DBMS.

Original language	English
Title of host publication	2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023
Publisher	Institute of Electrical and Electronics Engineers Inc.
ISBN (Electronic)	9798350335644
DOIs	https://doi.org/10.1109/ICBATS57792.2023.10111417
State	Published - 2023
Event	2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023 - Dubai, United Arab Emirates Duration: 7 Mar 2023 → 8 Mar 2023

Publication series

Name	2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023

Conference

Conference	2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023
Country/Territory	United Arab Emirates
City	Dubai
Period	7/03/23 → 8/03/23

Keywords

Database Management System
Query processing
style

Access to Document

10.1109/ICBATS57792.2023.10111417

Cite this

Salahat, M., Raza, M. A., Khawar, Z., Malik, J. A., Raza, H., Nair, H. K. G., & Jarrah, M. (2023). Analysis of Query Processing on Different Databases. In 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023 (2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/ICBATS57792.2023.10111417

@inproceedings{add87845b53f4063b2069492db989b0c,

title = "Analysis of Query Processing on Different Databases",

abstract = "The most trustworthy method for categorizing data into updateable and searchable collections in modern times is database management systems. However, there are different DBMS systems available, and each has its own pros and cons regarding dependability, use, performance, and its security. The performance of the main DBMS systems is compared in this paper. Oracle, MS SQL Server, MS Access, MySQL and IBM DB2 are the prominent ones. The five DBMSs under examination will be subjected to a variety of SQL queries with varying levels of complexity. After the test, this would make it possible to create a comparison analysis among them that displays the average execution time of each DBMS.",

keywords = "Database Management System, Query processing, style",

author = "Mohammed Salahat and Raza, \{Muhammad Ahsan\} and Zuha Khawar and Malik, \{Javaid Ahmad\} and Hammad Raza and Nair, \{Harish K.G.\} and Muath Jarrah",

note = "Publisher Copyright: {\textcopyright} 2023 IEEE.; 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023 ; Conference date: 07-03-2023 Through 08-03-2023",

year = "2023",

doi = "10.1109/ICBATS57792.2023.10111417",

language = "English",

series = "2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023",

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

booktitle = "2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023",

address = "United States",

}

Salahat, M, Raza, MA, Khawar, Z, Malik, JA, Raza, H, Nair, HKG & Jarrah, M 2023, Analysis of Query Processing on Different Databases. in 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023. 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023, Institute of Electrical and Electronics Engineers Inc., 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023, Dubai, United Arab Emirates, 7/03/23. https://doi.org/10.1109/ICBATS57792.2023.10111417

Analysis of Query Processing on Different Databases. / Salahat, Mohammed; Raza, Muhammad Ahsan; Khawar, Zuha et al.
2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023. Institute of Electrical and Electronics Engineers Inc., 2023. (2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023).

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

TY - GEN

T1 - Analysis of Query Processing on Different Databases

AU - Salahat, Mohammed

AU - Raza, Muhammad Ahsan

AU - Khawar, Zuha

AU - Malik, Javaid Ahmad

AU - Raza, Hammad

AU - Nair, Harish K.G.

AU - Jarrah, Muath

PY - 2023

Y1 - 2023

N2 - The most trustworthy method for categorizing data into updateable and searchable collections in modern times is database management systems. However, there are different DBMS systems available, and each has its own pros and cons regarding dependability, use, performance, and its security. The performance of the main DBMS systems is compared in this paper. Oracle, MS SQL Server, MS Access, MySQL and IBM DB2 are the prominent ones. The five DBMSs under examination will be subjected to a variety of SQL queries with varying levels of complexity. After the test, this would make it possible to create a comparison analysis among them that displays the average execution time of each DBMS.

AB - The most trustworthy method for categorizing data into updateable and searchable collections in modern times is database management systems. However, there are different DBMS systems available, and each has its own pros and cons regarding dependability, use, performance, and its security. The performance of the main DBMS systems is compared in this paper. Oracle, MS SQL Server, MS Access, MySQL and IBM DB2 are the prominent ones. The five DBMSs under examination will be subjected to a variety of SQL queries with varying levels of complexity. After the test, this would make it possible to create a comparison analysis among them that displays the average execution time of each DBMS.

KW - Database Management System

KW - Query processing

KW - style

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

U2 - 10.1109/ICBATS57792.2023.10111417

DO - 10.1109/ICBATS57792.2023.10111417

M3 - Conference contribution

AN - SCOPUS:85160803579

T3 - 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023

BT - 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023

PB - Institute of Electrical and Electronics Engineers Inc.

T2 - 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023

Y2 - 7 March 2023 through 8 March 2023

ER -

Salahat M, Raza MA, Khawar Z, Malik JA, Raza H, Nair HKG et al. Analysis of Query Processing on Different Databases. In 2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023. Institute of Electrical and Electronics Engineers Inc. 2023. (2nd International Conference on Business Analytics for Technology and Security, ICBATS 2023). doi: 10.1109/ICBATS57792.2023.10111417

Analysis of Query Processing on Different Databases

Abstract

Publication series

Conference

Keywords

Access to Document

Other files and links

Fingerprint

Cite this