Temporary Memory Allocator Deactivation for Faster Query Execution

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Database management systems face challenges in optimizing performance due to complex queries and varying database types, leading to increased processing and memory resource usage at the database layer, which affects response times.

Innovation Solution

Implementing an execution engine that decouples the application layer from the database layer, optimizing query plans, and using a configuration switch to deactivate temporary memory allocators, ensuring efficient memory management and reduced overhead.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If temporary memory allocators are used for query execution, then memory management flexibility is improved, but memory overhead and processing burden on database layer increase

Engineering Contradiction:

Improvememory management flexibilityVSAvoidmemory overhead

Core Design Contradiction:

Adaptability or versatilityVSQuantity of substance

Solution Approach 1:

The patent extracts the temporary memory allocation functionality from the database layer and relocates it to the application layer through the execution engine. This separation allows the database layer to focus on core query processing while the application layer handles memory management, thereby reducing memory overhead and processing burden on the database layer while maintaining memory management flexibility.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The execution engine acts as an intermediary between the application layer and database layer, managing temporary memory allocations centrally. This mediator handles the complexity of memory management at the application level while presenting a simplified interface to the database layer, reducing the processing burden on the database while maintaining adaptability.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Adaptability or versatility

If complex multidimensional analysis queries are executed, then analytical capability is improved, but query execution time and processing resources increase

Engineering Contradiction:

Improveanalytical capabilityVSAvoidquery execution time

Core Design Contradiction:

Adaptability or versatilityVSLoss of time

Solution Approach 1:

The patent segments the query execution process into distinct phases: query parsing, optimization, and execution. The execution engine separately handles temporary memory allocations during query execution, allowing complex multidimensional analysis to be performed more efficiently by isolating memory management operations from the core query processing logic.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The execution engine performs preliminary actions by pre-managing memory allocations before query execution begins. By establishing memory management infrastructure in advance through the execution engine rather than during query execution, the system reduces query execution time while maintaining the ability to handle complex analytical queries.

Inventive Principle:

Principle #10Preliminary action

3Productivity

If database layer handles all query processing, then data processing capability is improved, but system response time deteriorates

Engineering Contradiction:

Improvedata processing capabilityVSAvoidsystem response time

Core Design Contradiction:

ProductivityVSSpeed

Solution Approach 1:

The patent extracts memory management responsibilities from the database layer and places them in the application layer through the execution engine. This extraction reduces the processing burden on the database layer, allowing it to focus on core data processing operations while the application layer handles memory allocations, thereby improving system response time without sacrificing data processing capability.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The patent introduces a new dimensional layer (execution engine) between the application layer and database layer that handles memory management. This additional dimension allows the database layer to specialize in data processing while the execution engine manages memory resources, enabling both high data processing capability and fast system response time.

Inventive Principle:

Principle #17Another dimension (Dimensionality change)

Data Source

PatentUS12517759B2Disabling of memory allocators

Publication Date: 2026.01.06 SAP SE

AI summary

A method, a system, and a computer program product for executing memory allocations. One or more memory allocations for execution of one or more portions of a software application are generated. One or more configuration settings of the generated one or more memory allocations are determined. Based on the determined configuration settings, at least one memory allocation in one or more memory allocations is deactivated. One or more portions of the software application are executed based on the deactivating.