Reach Object Instance-Level Row Security

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing database systems lack effective row-level security mechanisms that allow for instance-level access control without requiring changes to the presentation tier or direct interaction with the data tier, leading to potential unauthorized access to sensitive data.

Innovation Solution

Implementing a link data structure in the data tier that associates users with specific objects, using a reach object to secure individual data items at the instance level, allowing authorized access without modifying the user interface or presentation tier.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If row-level security is implemented using traditional database access control, then data security is improved, but system complexity and difficulty of implementation increase

Engineering Contradiction:
Improvedata securityVSAvoidsystem complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent introduces a reach object as an intermediary component between the presentation tier and data tier. This reach object automatically manages row-level security by intercepting data access requests, determining user permissions, and filtering results before returning data to users. This mediator approach eliminates the need for complex security logic in the presentation tier while maintaining strong security controls at the data access layer.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent segments security functionality into a separate reach object component that can be independently managed and configured. By dividing the security mechanism into discrete, reusable objects that can be attached to specific data access operations, the system achieves fine-grained security control without requiring comprehensive restructuring of the entire application architecture.

Inventive Principle:
Principle #1Segmentation

2Reliability

If instance-level security control is implemented, then unauthorized access to sensitive data is prevented, but the complexity of access control mechanisms increases

Engineering Contradiction:
Improveaccess control securityVSAvoidaccess control mechanism complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The reach object implements self-service security by automatically determining user permissions and filtering data based on pre-configured security rules. When a user requests data through the reach object, the mechanism automatically evaluates the user's authorization level, applies appropriate filters, and returns only permitted data without requiring manual security checks or complex configuration at each access point.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

Security rules and user permissions are pre-configured in the reach object before runtime data access occurs. This preliminary setup of security parameters allows the system to automatically enforce instance-level security controls during data operations without requiring complex real-time decision-making or manual intervention, thereby reducing operational complexity while maintaining strong security.

Inventive Principle:
Principle #10Preliminary action

3Ease of operation

If row-level security is implemented without modifying the presentation tier, then ease of operation is improved, but the ability to implement fine-grained security decreases

Engineering Contradiction:
Improveoperation simplicityVSAvoidsecurity implementation flexibility
Core Design Contradiction:
Ease of operationVSAdaptability or versatility

Solution Approach 1:

The patent adds a new dimensional layer (the reach object layer) between the presentation tier and data tier, enabling fine-grained security control without modifying existing presentation layer code. This additional dimension allows security logic to be injected at the data access boundary while keeping the presentation tier simple and unchanged, effectively resolving the contradiction between operational simplicity and security flexibility.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

Data Source

PatentUS10621374B2Reach objects
Publication Date: 2020.04.14 JITTERBIT INC
  • US10621374B2 patent drawing
  • US10621374B2 patent drawing
  • US10621374B2 patent drawing

AI summary

Methods, systems, and apparatus, including computer programs encoded on computer storage media, for a row level security. One of the methods includes receiving, by a computer device executing at least part of a functional logic tier of an application, a request from a user for one or more objects present in the functional logic tier. The method includes determining that a type of the requested objects is associated with an object representative of instance level security. The method includes in response to determining that the type is associated with the object, determining access is authorized to at least some of the objects, determining access comprising accessing, by a computer device executing at least part of a data tier of the application, a link data structure that links the user with at least some of the objects. The method also includes providing the at least some of the objects to the user.