Rate the Article: Data-Driven Decision Making: Advanced Database Systems for Business Intelligence, IJSR, Call for Papers, Online Journal
International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
Call for Papers | Fully Refereed | Open Access | Double Blind Peer Reviewed

ISSN: 2319-7064

Downloads: 11 | Views: 257 | Weekly Hits: ⮙1 | Monthly Hits: ⮙2

Research Paper | Computer Science & Engineering | United States of America | Volume 13 Issue 11, November 2024 | Rating: 6 / 10


Data-Driven Decision Making: Advanced Database Systems for Business Intelligence

Maria Anurag Reddy Basani, Anudeep Kandi


Abstract: Data-driven decision-making is integral to modern businesses, relying heavily on Business Intelligence (BI) systems to analyze vast and complex datasets for actionable insights. Traditional BI systems often struggle with high query latency, limited scalability, insufficient predictive capabilities, and inadequate security measures, hindering their effectiveness in dynamic data environments. This paper presents an AI augmented database system designed to address these challenges within BI applications. The proposed system integrates AI driven query optimization, real-time data processing, advanced predictive analytics, and enhanced security protocols. The methodology involves implementing machine learning models for dynamic query prediction and caching, utilizing recurrent neural networks for improved time-series forecasting, and employing isolation forests for robust anomaly detection. Security is reinforced through role-based access control and AES-256 encryption. Experimental evaluations demonstrate a significant reduction in query latency by 77% for high-frequency queries, achieving an average response time of 15 ms compared to 65 ms in traditional systems. The predictive analytics model reduces the Mean Absolute Error to 0.54, outperforming conventional ARIMA models. Anomaly detection achieves a precision of 0.89 and recall of 0.92, indicating high reliability.


Keywords: Business Intelligence, AI-driven query optimization, real-time data processing, predictive analytics, anomaly detection, role-based access control, machine learning, data security, scalability, data-driven decision-making


Edition: Volume 13 Issue 11, November 2024,


Pages: 844 - 850



Rate this Article


Select Rating (Lowest: 1, Highest: 10)

5

Your Comments (Only high quality comments will be accepted.)

Characters: 0

Your Full Name:


Your Valid Email Address:


Verification Code will appear in 2 Seconds ... Wait

Top