Restricted Database Views for Controlled Query Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems struggle to provide access to full datasets while protecting data owners from unauthorized data extraction and usage, as traditional approaches either limit data access or allow unrestricted access to predetermined queries.
Innovation Solution
A database system that facilitates the generation and use of restricted views, which are defined by data owners and include restrictions on data access, such as frequency, granularity, and operation limits, allowing authorized users to query while preventing unauthorized access or data extraction.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If traditional database systems provide unrestricted access to full datasets, then data accessibility and query flexibility are improved, but data security and protection from unauthorized extraction deteriorate
Solution Approach 1:
The patent introduces a restricted view as an intermediary layer between the user and the underlying database table. This virtual table provides controlled access to data through predefined queries, allowing users to query relevant information without direct access to the full dataset. The restricted view acts as a mediator that satisfies user information needs while preventing unauthorized data extraction and copying.
2Object-affected harmful factors
If traditional database systems limit data access to protect data owners, then data security is improved, but data accessibility and user ability to query relevant information deteriorates
Solution Approach 1:
The restricted view is dynamically generated based on the underlying database table structure and data. Rather than providing static, limited access, the system creates a virtual table that adapts to the user's query needs while maintaining security constraints. The restricted view can be customized for different users and scenarios, providing appropriate access levels without compromising data protection.
3Adaptability or versatility
If full datasets are made available for access, then user ability to analyze and query data is improved, but risk of data copying and unauthorized usage increases
Solution Approach 1:
The patent extracts only the necessary data elements needed for user queries from the full dataset, presenting them through a restricted view. Instead of providing access to the complete underlying table, the system extracts and presents only the specific columns and rows that match the user's query criteria. This extraction approach allows users to perform analysis on relevant data while preventing access to and copying of the full dataset.
Data Source
AI summary
A restricted view definition is received by a database system. The restricted view definition defines a view over a database table with one or more restrictions on use of the view. The view over the database table is generated based on the restricted view definition. A query directed at the view is received by the database system. The database system determines whether the query directed at the view is permitted based on the one or more restrictions on the use of the view.