Enhancing Query Processing on Stock Market Cloud-based Database

Authors

Hagger Essam, Helwan UnivesityFollow
Ahmed G. Elish, Helwan UniversityFollow
Essam M. shaban, Beni-Suef UniversityFollow

DOI

https://doi.org/10.54623/fue.fcij.7.2.2

Abstract

Cloud computing is rapidly expanding because it allows users to save the development and implementation time on their work. It also reduces the maintenance and operational costs of the used systems. Furthermore, it enables the elastic use of any resource rather than estimating workload, which may be inaccurate, as database systems can benefit from such a trend. In this paper, we propose an algorithm that allocates the materialized view over cloud-based replica sets to enhance the database system's performance in stock market using a Peer-to-Peer architecture. The results show that the proposed model improves the query processing time and network transfer cost by distributing the materialized views over cloud-based replica sets. Also, it has a significant effect on decision-making and achieving economic returns.

Recommended Citation

Essam, Hagger; Elish, Ahmed G.; and shaban, Essam M. (2022) "Enhancing Query Processing on Stock Market Cloud-based Database," Future Computing and Informatics Journal: Vol. 7: Iss. 2, Article 2.
DOI: https://doi.org/10.54623/fue.fcij.7.2.2
Available at: https://digitalcommons.aaru.edu.jo/fcij/vol7/iss2/2