Session Attribute Propagation in Secure Database Tiers

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In secure database environments, session attributes are not available to the database monitor agent due to encryption, limiting intrusion detection and security analysis, while unsecured environments lack the ability to handle encrypted data transmissions.

Innovation Solution

A mechanism where an unsecure access local agent extracts a unique identifiable key from an encrypted database client request and maps it to database session information, allowing a secure access local agent to decrypt and forward the data to an external security device for analysis.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Object-affected harmful factors

If data transmission is encrypted to improve security, then data protection is improved, but session attribute availability for security analysis deteriorates

Engineering Contradiction:
Improvedata protectionVSAvoidsession attribute availability
Core Design Contradiction:
Object-affected harmful factorsVSLoss of information

Solution Approach 1:

The patent introduces a DSI mapping data structure as an intermediary mechanism that bridges the gap between encrypted data and session attributes. This mapping structure allows the secure access local agent to associate encrypted database client requests with their corresponding session attributes without decrypting the actual data, thus maintaining both security and analysis capability.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent segments the data processing into distinct functional components: the unsecure access local agent handles encrypted data reception and UIK extraction, while the secure access local agent handles decryption and session attribute mapping. This segmentation allows each component to operate optimally for its specific function while working together to solve the overall problem.

Inventive Principle:
Principle #1Segmentation

2Object-affected harmful factors

If cryptographic operations are implemented to secure data, then data security is improved, but processing complexity increases

Engineering Contradiction:
Improvedata securityVSAvoidprocessing complexity
Core Design Contradiction:
Object-affected harmful factorsVSDevice complexity

Solution Approach 1:

The DSI mapping data structure serves as an intermediary that simplifies the relationship between encrypted requests and session attributes. By pre-establishing mappings between UIKs and session attributes, the system avoids complex real-time analysis of encrypted data structures, reducing processing complexity while maintaining security.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Object-affected harmful factors

If encrypted database client requests are processed to maintain security, then data protection is improved, but session attribute propagation deteriorates

Engineering Contradiction:
Improvedata protectionVSAvoidsession attribute propagation
Core Design Contradiction:
Object-affected harmful factorsVSLoss of information

Solution Approach 1:

The patent uses the DSI mapping data structure as an intermediary that enables session attribute propagation through secure tiers. The mapping structure allows secure access local agents to retrieve and propagate session attributes associated with encrypted requests, maintaining information flow without compromising data protection.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system performs preliminary mapping of UIKs to session attributes in advance, creating the DSI mapping data structure before encrypted requests arrive. This preliminary action enables rapid association of encrypted requests with their session attributes without complex real-time processing, thus maintaining both security and attribute propagation.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS9043593B2Session attribute propagation through secure database server tiers
Publication Date: 2015.05.26 INTERNATIONAL BUSINESS MACHINE CORPORATION
  • US9043593B2 patent drawing
  • US9043593B2 patent drawing
  • US9043593B2 patent drawing

AI summary

Mechanisms are provided for handling a database client request. An encrypted database client request (DCR) is received, by an unsecure access local agent, from a client computing device as part of a session between the client computing device and a database data processing system. The unsecure access local agent retrieves a database session information (DSI) address corresponding to the session and generates a first unique identifiable key (UIK) based on a portion of the encrypted DCR. The unsecure access local agent generates a DSI mapping data structure that maps the first UIK to the DSI address. A secure access local agent of the database data processing system processes the encrypted DCR using the DSI mapping data structure.