International Journal of Computer Information Systems and Industrial Management Applications | 2026
Authors: Benazza F.Z.; Hamdadou D.; Khennak I.
DOI: 10.70917/ijcisim-2026-0977
Journal: International Journal of Computer Information Systems and Industrial Management Applications
Year: 2026
Publisher: Cerebration Science Publishing
Document Type: Article
Open Access: All Open Access; Gold Open Access
Cited by: 0
Data Warehouses (DWs) are among the most powerful technologies for storing and managing large volumes of corporate data, which often include sensitive or confidential information. However, they remain vulnerable to inference attacks and insufficient access control mechanisms. In recent years, Artificial Intelligence (AI) techniques have become key tools for enhancing DW security, particularly for detecting and preventing unauthorized inferences. In this work, we propose a hybrid approach that combines the K-Nearest Neighbors (KNN) classification algorithm with the Ant Colony Optimization (ACO) metaheuristic to strengthen data warehouse security. The objective is to minimize inference risks by optimizing variable selection and improving the accuracy of sensitive data classification. The proposed ACO–KNN model was evaluated using a dataset of 1,000 SQL analytical queries generated by the IBM Db2 Query Manager, representing realistic decision-support workloads. Experimental results show that the hybrid model significantly outperforms traditional KNN and other metaheuristic-based methods in terms of prediction accuracy, convergence speed, and inference prevention capability. This demonstrates the model’s potential for practical integration into Business Intelligence (BI) and OLAP environments, contributing to more secure and reliable analytical decision-making. © Cerebration Science Publishing and 2026 by the authors.
Ant Colony Optimization; Data inference; Data security; Data warehouse; K-Nearest Neighbors; Machine Learning; Meta-heuristic