Dynamic Data Set Retrieval for Multi-Tenant Database Security

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional systems for displaying data in multi-tenant on-demand database systems fail to account for user privileges and preferences, leading to inefficient resource usage and inadequate data security.

Innovation Solution

A method for displaying data sets to users based on their identifiers, utilizing a graphical interface that retrieves and displays only authorized data, with on-demand refresh capabilities to conserve system resources and enhance data security.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If traditional methods update interfaces for all users according to a schedule, then data freshness is maintained, but system resources are inefficiently used

Engineering Contradiction:
Improvedata freshnessVSAvoidsystem resource efficiency
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The patent implements dynamic interface updating where the timing and content of updates are adjusted based on individual user actions, preferences, and system conditions rather than following a fixed schedule. This allows the system to maintain data freshness when needed while conserving resources during periods of low user activity or when data changes are minimal.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The system enables users to trigger interface updates on-demand based on their specific needs and preferences. Users can initiate updates when they require fresh data, and the system responds by retrieving and displaying updated information only for those users who have explicitly requested it, eliminating unnecessary scheduled updates for all users.

Inventive Principle:
Principle #25Self-service

2Adaptability or versatility

If traditional methods associate a plurality of interfaces with a single user, then user flexibility is improved, but data security and privilege management deteriorate

Engineering Contradiction:
Improveuser flexibilityVSAvoiddata security
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The patent implements local quality by applying different security rules and data filtering to different interfaces and different users individually. Each user's interface is customized to display only the data and functionality appropriate to their specific privilege level, rather than applying a uniform security model to all users. This allows multiple interfaces per user while maintaining strict security boundaries.

Inventive Principle:
Principle #3Local quality

Solution Approach 2:

The system segments user interfaces and data access rights into distinct, privilege-specific groups. Rather than treating all user interfaces uniformly, the patent divides interfaces into segments with different security clearances and data visibility levels, allowing users to access multiple interfaces while their access to each interface is controlled by their specific privilege level.

Inventive Principle:
Principle #1Segmentation

3Loss of information

If conventional systems display all available data sets to users, then data completeness is improved, but processing overhead and resource consumption increase

Engineering Contradiction:
Improvedata completenessVSAvoidprocessing overhead
Core Design Contradiction:
Loss of informationVSUse of energy by moving object

Solution Approach 1:

The patent extracts and displays only the specific data sets that are relevant to each user's role, privileges, and current tasks, rather than displaying all available data. The system identifies and retrieves only the necessary subset of data for each user, reducing processing overhead while maintaining data completeness within the context of user needs and security permissions.

Inventive Principle:
Principle #2Taking out (Extraction)

Data Source

PatentUS10528750B2Execution of bulk requests against one or more databases
Publication Date: 2020.01.07 SALESFORCE INC
  • US10528750B2 patent drawing
  • US10528750B2 patent drawing
  • US10528750B2 patent drawing

AI summary

In accordance with embodiments, there are provided mechanisms and methods for displaying one or more data sets to a user. These mechanisms and methods for displaying one or more data sets to a user can enable enhanced data security, more relevant data display, reduced processing, etc.