Enhancing Data Warehouse Queries Through Intelligent Keyword Search With Privacy & Access Control

• Author(s):

  Baalasubramani V | Shivanad N | Rohith B | Subramani V

• Keywords:

  Data Warehouse, Keyword Search, RBAC, Privacy Preservation, SQL Generation, Access Control

• Abstract:

  Traditional Data Warehouse Systems Require Users To Write Structured SQL Queries To Retrieve Information, Which Is Difficult For Non-technical Users. Moreover, Sensitive Organizational Data Stored In Warehouses Demands Controlled Access And Privacy Preservation. Existing Keyword Search Approaches Provide Basic Retrieval But Fail To Enforce Secure Role-based Data Visibility.This Paper Proposes A Privacy-Preserving Intelligent Keyword Search System Integrated With Role-Based Access Control (RBAC) For Cloud-based Data Warehouses. The System Converts Natural Language Keywords Into Structured Database Queries And Dynamically Filters Results Based On User Authorization Levels. Public Data Is Accessible To All Users While Confidential Records Remain Restricted To Administrators. The Proposed Model Improves Usability, Security, And Controlled Data Sharing In Enterprise Environments.

---

Other Details

• Paper id:

  IJSARTV12I3104738

• Published in:

  Volume: 12 Issue: 3 March 2026

• Publication Date:

  2026-03-19

Download Article