18475403. COLUMN HIDING MANAGEMENT SYSTEM simplified abstract (Snowflake Inc.)
Contents
COLUMN HIDING MANAGEMENT SYSTEM
Organization Name
Inventor(s)
Raja Suresh Krishna Balakrishnan of Fremont CA (US)
Khalid Zaman Bijon of Santa Cruz CA (US)
Subramanian Muralidhar of Mercer Island WA (US)
David Schultz of Piedmont CA (US)
COLUMN HIDING MANAGEMENT SYSTEM - A simplified explanation of the abstract
This abstract first appeared for US patent application 18475403 titled 'COLUMN HIDING MANAGEMENT SYSTEM
Simplified Explanation: The patent application describes systems and methods for managing column hiding in a table based on access restrictions associated with client devices. When a query is received, the systems and methods identify restricted columns and provide query results excluding data from those columns.
- Key Features and Innovation:
- Management of column hiding based on client device access restrictions - Exclusion of restricted column data from query results
- Potential Applications:
- Data security and privacy protection in database management systems - Customized data display for different user roles or permissions
- Problems Solved:
- Ensuring data security by restricting access to sensitive information - Streamlining data presentation based on user permissions
- Benefits:
- Enhanced data security and privacy protection - Improved user experience through customized data display
- Commercial Applications:
- Database management systems for industries handling sensitive information - Software applications requiring role-based data access control
- Prior Art:
- Readers can explore prior art related to data access control and column hiding in database systems.
- Frequently Updated Research:
- Stay informed about advancements in data security and access control technologies.
Questions about column hiding technology:
1. How does the system determine which columns to hide based on client device access restrictions?
- The system identifies restricted columns by matching access restrictions associated with the client device to the table columns.
2. What are the potential implications of column hiding technology in enhancing data security measures?
- Column hiding technology can significantly improve data security by restricting access to sensitive information based on user permissions.
Original Abstract Submitted
Systems and methods for managing column hiding are provided. The systems and methods receive, from a client device, a query associated with a table. The systems and methods determine an access restriction associated with the client device. The systems and methods identify a column of the table that is restricted by the access restriction associated with the client device. In response to identifying the column of the table that is restricted by the access restriction associated with the client device, the systems and methods provide a result of the query that excludes data corresponding to the column.
