INTERNATIONAL BUSINESS MACHINES CORPORATION (20240232191). PERMISSION-BASED INDEX FOR QUERY PROCESSING simplified abstract
Contents
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 20240232191 titled 'PERMISSION-BASED INDEX FOR QUERY PROCESSING
Simplified Explanation: This patent application describes a method for managing database access privileges based on user roles, where data records are filtered and loaded into memory before executing a database query.
Key Features and Innovation:
- Storing an index of role-based access privileges for multiple users in a database.
- Filtering out data records that a user does not have permission to access.
- Loading identified data records into memory before executing a database query.
Potential Applications: This technology can be applied in various industries such as healthcare, finance, and e-commerce to ensure secure and efficient data access for different user roles.
Problems Solved: This technology addresses the challenge of managing and enforcing access privileges for multiple users in a database system.
Benefits:
- Improved data security by restricting access to authorized users.
- Enhanced performance by pre-loading data records into memory.
- Simplified management of user roles and access privileges.
Commercial Applications: Title: Role-Based Database Access Management System This technology can be commercialized as a software solution for enterprises to enhance data security and streamline database access control processes.
Prior Art: Readers can explore prior art related to database access control systems, role-based access control mechanisms, and data filtering techniques in database management systems.
Frequently Updated Research: Stay updated on advancements in database security, access control systems, and data privacy regulations to ensure compliance and optimal performance of the technology.
Questions about Role-Based Database Access Management System: 1. How does this technology improve data security in database systems? 2. What are the potential applications of role-based access control mechanisms in different industries?
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.
