Adaptivity in Role-Based Access Control During Stochastic Situations: A Comprehensive Study between Graph and Relational Databases
- 1 Department of Computer Science and Engineering (Data Science), Dwarkadas J. Sanghvi College of Engineering, Mumbai, India
Abstract
Role-based control is straightforward to implement in static systems where there are specific policies for role and resource mapping. The main challenge is faced in dynamic and unpredictable systems with erratic workflows. Conventional methods prove to be inadequate in dynamic environments. Over the Years methods suggested include probabilistic, machine learning, ontology, and decision tree models to improve the adaptability. However, they fail to build a bridge between operational methods and flexible approaches. Role-based control systems are based on previously defined rules and policies. A truly flexible system should run without human interference, autonomously accessing the user's request and granting the requirements based on it is genuineness. This research introduces the need for a based control methodology, using a project management case study using Neo4j. It generates the responses promptly based on the authenticity of the user We have computed the time required to process the results in in SQL as well as Neo4j. A role-based control system is built to improve coordination among the departments present in the real-life corporate world and transfer data based on authenticated data requests. Graph databases outperform relational databases by nearly an average of 8 milliseconds on an average across the queries run. This framework demonstrates better flexibility, system adaptability, and precise computational efficiency across various scenarios.
DOI: https://doi.org/10.3844/jcssp.2024.1744.1752
Copyright: © 2024 Kriti Srivastava, Dhruv Jain, Aarya Kamdar, Anuradha Yeole, Devam Shah and Sowmya Dadheech. This is an open access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.
- 190 Views
- 43 Downloads
- 0 Citations
Download
Keywords
- Graph Databases
- Neo4j
- NoSql
- Role Based Access
- RBAC
- MYSQL
- Relational Databases