Stored Procedure Table Parameters for Direct External Table Input

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database management systems face inefficiencies in handling external tabular data as input arguments for stored procedure calls, requiring additional operations that consume processor and memory resources, and do not support direct consumption of external tabular data using input table parameters.

Innovation Solution

Implementing a method to directly consume external tabular data using input table parameters, where the database management system decodes binary streams into internal tables and maps them to query parameter indices, enabling direct use in query execution without the need for temporary tables.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If external tabular data is processed using traditional methods with temporary tables, then data can be consumed by stored procedures, but additional processor and memory resources are consumed

Engineering Contradiction:

Improveprocessing efficiencyVSAvoidprocessor and memory resource consumption

Core Design Contradiction:

ProductivityVSUse of energy by moving object

Solution Approach 1:

The patent extracts the intermediate temporary table step from the traditional data processing workflow. External tabular data is directly decoded into internal tables and passed to stored procedures without being materialized into temporary tables, eliminating unnecessary resource consumption while maintaining data processing capability.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The patent enables the database management system to handle multiple data formats (external and internal tables) through a unified mechanism. The system can directly consume external tabular data using input table parameters, making the stored procedure interface universal and eliminating the need for separate temporary table handling paths.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Use of energy by moving object

If external tabular data is directly consumed using input table parameters, then resource consumption is reduced, but the database management system must decode binary streams and map them to query parameter indices

Engineering Contradiction:

Improveresource consumptionVSAvoiddecoding and mapping operations

Core Design Contradiction:

Use of energy by moving objectVSDevice complexity

Solution Approach 1:

The patent performs preliminary actions by pre-defining the structure and format of external tabular data before it is passed to stored procedures. The database management system prepares the decoding and mapping mechanisms in advance, allowing efficient processing without ad-hoc complexity during execution.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces an intermediary layer in the database management system that handles the decoding of binary streams and mapping to query parameter indices. This intermediary mechanism abstracts the complexity from the user interface, allowing users to simply specify external table parameters while the system manages the complex decoding and mapping operations transparently.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Ease of operation

If temporary tables are used to consume external tabular data, then data can be passed to stored procedures, but the need for temporary tables increases device complexity and resource usage

Engineering Contradiction:

Improvedata consumption capabilityVSAvoidtemporary table management

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

The patent removes the temporary table management layer from the data consumption process. External tabular data flows directly from the input source through decoding and mapping operations to the stored procedure, extracting the unnecessary intermediate storage step that previously complicated the operation.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The patent enables external tabular data to be self-sufficient for direct consumption without requiring temporary table infrastructure. The database management system provides self-service capabilities by automatically decoding binary streams and mapping data to appropriate query parameters, eliminating the need for manual temporary table creation and management.

Inventive Principle:

Principle #25Self-service

Data Source

PatentUS20260079935A1Table-valued parameter for call statement

Publication Date: 2026.03.19 SAP SE

AI summary

In some embodiments, there is provided a computer-implemented method including receiving a call to a stored procedure that includes a first table value parameter corresponding to a first external table and a second table value parameter corresponding to a second external table; and passing, to the called stored procedure, a first bit stream of parameters from the first external table passed using the first table value parameter and a second bit stream of parameters from the second external table passed using the second table value parameter. Related systems, methods, and articles of manufacture are also disclosed.