Caching Condensed Security Rules for Enterprise Systems

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing business application systems require users to navigate between screens to activate security rules, leading to inefficiency, and perform numerous database queries when events occur, which is resource-intensive, especially in enterprise-wide applications.

Innovation Solution

Implementing caching of condensed security rules in cache memory, allowing immediate activation of newly-created rules without navigating to another screen and reducing database queries by checking the cache for applicable rules before querying the database.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If rules are stored in database and queried for every event, then rule reliability is maintained, but computing resource usage increases and system speed decreases

Engineering Contradiction:
Improverule reliabilityVSAvoidsystem speed
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The patent loads and caches condensed versions of rules from the database into memory before events occur. This preliminary action stores frequently accessed rule data in a faster-access medium, so when events trigger rule evaluations, the system can quickly check the cache instead of querying the database each time, thus improving system speed while maintaining rule reliability through periodic database synchronization.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent introduces a cache memory as an intermediary layer between the database and the rules engine. This intermediary stores condensed rule representations and provides fast access for event evaluation, reducing the frequency of database queries. The cache acts as a buffer that maintains data consistency with the database while enabling high-speed rule processing.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Measurement precision

If database queries are performed for every event, then accurate rule evaluation is ensured, but computing resource usage increases

Engineering Contradiction:
Improverule evaluation accuracyVSAvoidcomputing resource usage
Core Design Contradiction:
Measurement precisionVSUse of energy by moving object

Solution Approach 1:

The patent creates condensed copies of rules from the full database records and stores these copies in cache memory. These copies contain the essential rule logic and action information needed for evaluation. By using these lightweight copies instead of querying full database records for every event, the system maintains rule evaluation accuracy while significantly reducing computing resource usage.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The patent loads condensed versions of rules that include only the necessary information for event evaluation and action execution, rather than loading or querying complete rule sets with all associated metadata. This partial action approach provides sufficient information for accurate rule evaluation without the overhead of processing complete database records, thus reducing computing resource consumption.

Inventive Principle:
Principle #16Partial or excessive action

3Reliability

If users navigate to control screen to activate rules, then rule activation is reliable, but ease of operation deteriorates

Engineering Contradiction:
Improverule activation reliabilityVSAvoiduser operation convenience
Core Design Contradiction:
ReliabilityVSEase of operation

Solution Approach 1:

The patent implements automatic rule activation where rules are activated immediately upon creation through the rules creator interface. The system automatically detects when a rule is created and activates it without requiring user navigation to a separate control screen. This self-service approach maintains reliable rule activation while dramatically improving ease of operation by eliminating unnecessary user actions.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent merges the rule creation function and rule activation function into a single integrated process. When users create a rule in the rules creator, the activation step is combined with the creation step, so both actions occur simultaneously in one interface. This merging eliminates the need for separate navigation to control screens while ensuring reliable activation through the same validated process.

Inventive Principle:
Principle #5Merging (Combining)

4Productivity

If condensed rules are cached in memory, then system speed improves, but device complexity increases

Engineering Contradiction:
Improvesystem speedVSAvoidsystem architecture complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The system performs preliminary loading of condensed rule data into cache memory during system initialization or when rules are created/modified. This preliminary action prepares the data in advance in a optimized format for fast access, enabling high-speed rule evaluation during event processing without requiring complex real-time data transformation or querying mechanisms.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS8473508B2Dynamic rule creation and caching
Publication Date: 2013.06.25 ORACLE INT CORP
  • US8473508B2 patent drawing
  • US8473508B2 patent drawing
  • US8473508B2 patent drawing

AI summary

A condensed version of a plurality of rules for one or more forms being used by a user is loaded from a database. The condensed version of the plurality of rules is stored in cache memory of a computing device. When an event occurs, a rules engine determines if a condensed version of the rule is stored in cache memory. If a rule is not applicable, the rules engine does not query the database. If a rule is applicable, the rules engine determines if an action should be taken for the event. If no action is to be taken, the database is not queried for the rule. If an action is to be taken, the database may be queried for information for the rule to allow performing of the action or if the action is included in the condensed version, the action is performed without querying the database.