Bidirectional Data Table Association with Target User Permissions
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data processing systems lack effective mechanisms for securely managing permissions and associations between multidimensional data tables, leading to potential information leakage and security vulnerabilities.
Innovation Solution
A method and apparatus for establishing a bidirectional association relationship between data tables, where a target permission is set for a target user, allowing controlled access and synchronization of data between tables, while maintaining data security through permission settings and synchronization mechanisms.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If bidirectional association relationship is established between data tables, then data management efficiency is improved, but data security risk increases
Solution Approach 1:
The patent introduces a permission mechanism as an intermediary between the bidirectional association relationship and data access. This mediator controls and regulates the data flow between associated tables, allowing efficient data management while preventing unauthorized access and ensuring data security through permission-based access control.
2Reliability
If user access control is implemented, then data security is improved, but system complexity increases
Solution Approach 1:
The patent implements a universal permission mechanism that serves multiple functions simultaneously: it controls data security, manages user access rights, and regulates bidirectional data associations. This multi-functional approach achieves comprehensive security control without proportionally increasing system complexity, as the same permission framework handles multiple security-related tasks.
Data Source
AI summary
Embodiments of the disclosure disclose a method, apparatus and electronic device for data processing. The method includes: obtaining a first data table and a second data table; and determining an associated field in the first data table, and establishing a bidirectional association relationship between the first data table and the second data table through the associated field, wherein a target permission for using the first data table is set for a target user in the establishment of the bidirectional association relationship, the target user being a user associated with the second data table.