Intelligent Data Warehouse Partitioning Using AI-Driven Query Pattern Analysis
Modern Dynamics: Mathematical Progressions · 30.08.2024 · 1 (2) · 540-547
DOI: 10.64170/mdmp.v1.i2.59 ↗Kurz gefasst
Fachartikel in der Zeitschrift Modern Dynamics: Mathematical Progressions, online erschienen am 30.08.2024. Verfasst von Sarvesh Kumar Gupta. Die Arbeit nennt 12 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0).
Abstract (Originalsprache)
Modern data warehouses designed to handle advanced queries and massive data sets are discussed in this research. Effective partitioning of such systems is considered a key tool to enhance the performance of analytical queries, minimize resource usage, and ensure scalability. Traditional approaches to data partitioning presuppose that partitioning rules based on some attribute values are established beforehand. For example, the partition may be made according to date, geographic location, or some customer identifier. While such a strategy works perfectly when the same type of query pattern persists, the lack of flexibility may become an obstacle once a query pattern changes or new demands arise. As a result, inefficient access to data, higher response time, and suboptimal resource consumption may occur. Advances in the field of artificial intelligence have enabled researchers to create efficient intelligent partitioning algorithms that use data about past and current queries to make optimal decisions regarding data arrangement in databases. AI-based query pattern analysis uses machine learning techniques to extract valuable information about most commonly used attributes, filters, and even join relationships. Intelligent partitioning helps make recommendations regarding data partitioning or adjust it depending on the current data. This paper reviews the evolution of intelligent partitioning and evaluates its effectiveness compared to traditional approaches.
Zitieren
APA
Gupta, S. K. (2024). Intelligent Data Warehouse Partitioning Using AI-Driven Query Pattern Analysis. Modern Dynamics: Mathematical Progressions, 1(2), 540-547. https://doi.org/10.64170/mdmp.v1.i2.59
Vancouver
Gupta SK. Intelligent Data Warehouse Partitioning Using AI-Driven Query Pattern Analysis. Modern Dynamics: Mathematical Progressions. 2024;1(2):540-547. doi:10.64170/mdmp.v1.i2.59
BibTeX
@article{Gupta2024,
author = {Gupta, Sarvesh Kumar},
title = {Intelligent Data Warehouse Partitioning Using AI-Driven Query Pattern Analysis},
journal = {Modern Dynamics: Mathematical Progressions},
year = {2024},
volume = {1},
number = {2},
pages = {540--547},
doi = {10.64170/mdmp.v1.i2.59}
}
EUVIMED