17970626. PERMISSION-BASED INDEX FOR QUERY PROCESSING simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)
Contents
- 1 PERMISSION-BASED INDEX FOR QUERY PROCESSING
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 PERMISSION-BASED INDEX FOR QUERY PROCESSING - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Potential Applications
- 1.6 Problems Solved
- 1.7 Benefits
- 1.8 Potential Commercial Applications
- 1.9 Possible Prior Art
- 1.10 How does this technology handle dynamic changes in user roles and permissions within the database?
- 1.11 What measures are in place to prevent unauthorized users from bypassing the access control system?
- 1.12 Original Abstract Submitted
PERMISSION-BASED INDEX FOR QUERY PROCESSING
Organization Name
INTERNATIONAL BUSINESS MACHINES CORPORATION
Inventor(s)
Jia Tian Zhong of BEIJING (CN)
Peng Hui Jiang of BEIJING (CN)
Ming Lei Zhang of BEIJING (CN)
Ting Ting Zhan of BEIJING (CN)
PERMISSION-BASED INDEX FOR QUERY PROCESSING - A simplified explanation of the abstract
This abstract first appeared for US patent application 17970626 titled 'PERMISSION-BASED INDEX FOR QUERY PROCESSING
Simplified Explanation
The patent application abstract describes a method for managing role-based access privileges for users with respect to a database. The method involves storing an index of access privileges, receiving a database query associated with a user, identifying data records the user has permission to access, loading the identified data records into memory, filtering out unauthorized data records, and executing the query on the authorized data records.
- Storing index of role-based access privileges for users
- Receiving database query associated with a user
- Identifying data records user has permission to access
- Loading identified data records into memory
- Filtering out unauthorized data records
- Executing query on authorized data records
Potential Applications
This technology can be applied in various industries such as healthcare, finance, and government where sensitive data access needs to be controlled based on user roles.
Problems Solved
This technology solves the problem of unauthorized access to sensitive data within a database, ensuring that only users with the appropriate permissions can retrieve and manipulate the data.
Benefits
The benefits of this technology include enhanced data security, improved compliance with data privacy regulations, and streamlined access control management for databases.
Potential Commercial Applications
The potential commercial applications of this technology include database management systems, data security software, and access control solutions for enterprises.
Possible Prior Art
One possible prior art for this technology could be traditional access control mechanisms in databases that rely on user roles and permissions to restrict data access.
Unanswered Questions
How does this technology handle dynamic changes in user roles and permissions within the database?
The article does not provide information on how the system adapts to changes in user roles and permissions over time.
What measures are in place to prevent unauthorized users from bypassing the access control system?
The article does not address potential vulnerabilities or methods to prevent unauthorized users from circumventing the access control system.
Original Abstract Submitted
An example operation may include one or more of storing an index that comprises identifiers of role-based access privileges for a plurality of users with respect to a database, receiving a database query associated with a user from a software program, identifying data records within the database that the user has permission to access based on database accessibility rights of the user stored within the index, prior to execution of the database query, loading the identified data records into the memory and filtering out other data records from the database which the user does not have permission to access, and executing the database query on the identified data records loaded from the database and returning query results from the execution to the software program.