International business machines corporation (20240134852). PERMISSION-BASED INDEX FOR QUERY PROCESSING simplified abstract

From WikiPatents
Jump to navigation Jump to search

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)

Le Chang of BEIJING (CN)

Zhen Liu of BEIJING (CN)

Xiao Yan Tian of BEIJING (CN)

PERMISSION-BASED INDEX FOR QUERY PROCESSING - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240134852 titled 'PERMISSION-BASED INDEX FOR QUERY PROCESSING

Simplified Explanation

The patent application abstract describes a method for managing role-based access privileges for users in a database system. Here is a simplified explanation of the abstract:

  • Storing an index of role-based access privileges for users in a database
  • Receiving a database query associated with a user
  • Identifying data records that the user has permission to access
  • Loading the identified data records into memory
  • Filtering out data records the user does not have permission to access
  • Executing the database query on the identified data records and returning results to the software program

Potential Applications

This technology can be applied in various industries and sectors where secure access to databases is crucial, such as healthcare, finance, and government agencies.

Problems Solved

This technology solves the problem of unauthorized access to sensitive data in databases, ensuring that only users with the appropriate permissions can retrieve and manipulate data.

Benefits

The benefits of this technology include enhanced data security, improved compliance with privacy regulations, and streamlined database access management processes.

Potential Commercial Applications

A potential commercial application of this technology could be in developing secure database management systems for organizations that handle sensitive information, such as hospitals, banks, and government agencies.

Possible Prior Art

One possible prior art for this technology could be existing database management systems that offer role-based access control features, but may not have the specific method outlined in the patent application.

Unanswered Questions

How does this technology handle scalability in large databases?

The article does not address how the method described in the patent application can efficiently manage role-based access privileges in databases with a large number of users and data records.

What are the potential limitations or vulnerabilities of this method?

The article does not discuss any potential weaknesses or vulnerabilities that could be exploited in the implementation of this technology, such as potential loopholes in the access control mechanisms.


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.