Optimal Index Selection Using Optimized Deep Q-Learning Algorithm for NoSQL Database

The resource requirements for managing the data for sophisticated applications have increased as big data technology has advanced. NoSQL (MongoDB) databases are being used increasingly frequently as a result of the desire for high-performance reading and writing. However, the performance of the data...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:SN computer science Jg. 5; H. 5; S. 504
Hauptverfasser: Sumalatha, V., Pabboju, Suresh
Format: Journal Article
Sprache:Englisch
Veröffentlicht: Singapore Springer Nature Singapore 01.06.2024
Springer Nature B.V
Schlagworte:
ISSN:2661-8907, 2662-995X, 2661-8907
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The resource requirements for managing the data for sophisticated applications have increased as big data technology has advanced. NoSQL (MongoDB) databases are being used increasingly frequently as a result of the desire for high-performance reading and writing. However, the performance of the database is degraded due to the number of queries in a certain time period. Thus to enhance the database performance, an automatic index selection scheme is presented in this paper. Namely, an optimized deep Q-learning network (DQN) is presented for optimal index selection. To enhance the decision making performance of DQN, an adaptive crocodile optimization algorithm (ACOA) is used. Using this algorithm, best action sequences of DQN are obtained. In terms of YCSB mongoDB, the suggested model's performance is assessed. The article's findings show that the suggested model achieves better average cost time (ACT), average time of query execution (ATQ) and query per hour (QPHH) and throughput.
Bibliographie:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:2661-8907
2662-995X
2661-8907
DOI:10.1007/s42979-024-02863-9