In-Database Program Execution via Service Entity Integration

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In traditional computing systems, data often needs to be moved between different systems for processing, which is inefficient and can lead to data corruption and increased processing intensity, especially in analytics where large blocks of data require computation.

Innovation Solution

A computer-program product and method that enables a computing system to receive and execute a data program instance by storing computer instructions from an external system, allowing in-database processes to retrieve and store input and output data within the system without the need for data exchange, using a service entity and data exchange entity to manage data availability and storage.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If data is moved from data platform software to a separate machine for computation, then computation can be performed on stored data, but data movement increases processing intensity and can lead to data corruption

Engineering Contradiction:
Improvecomputation capabilityVSAvoidprocessing intensity
Core Design Contradiction:
ProductivityVSLoss of energy

Solution Approach 1:

The patent combines the data storage system and computation system into a single integrated computing system. The data platform software and computation processes share the same computing resources, eliminating the need to move data between separate machines. This merging approach maintains computation capability while reducing the processing intensity associated with data transfer.

Inventive Principle:
Principle #5Merging (Combining)

2Productivity

If data is moved from data platform software to a separate machine for computation, then computation can be performed on stored data, but risk of data corruption increases

Engineering Contradiction:
Improvecomputation capabilityVSAvoiddata integrity
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

By integrating the data platform software and computation processes within the same computing system, the patent eliminates data movement between separate machines. This integration ensures data remains in its original location, maintaining data integrity and reducing the risk of corruption during transfer operations.

Inventive Principle:
Principle #5Merging (Combining)

3Productivity

If data programs are executed outside the data system, then computation can be performed, but data movement between systems is required

Engineering Contradiction:
Improvecomputation capabilityVSAvoiddata movement time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent merges the data storage environment with the computation environment, allowing data programs to execute directly within the data system. This eliminates the time required to move data between separate systems, as both data access and computation occur in the same integrated computing system.

Inventive Principle:
Principle #5Merging (Combining)

Data Source

PatentUS12155727B1Architecture for execution of computer programs inside data systems
Publication Date: 2024.11.26 SAS INSTITUTE INC
  • US12155727B1 patent drawing
  • US12155727B1 patent drawing
  • US12155727B1 patent drawing

AI summary

A computing system is configured to receive, at a service entity, from a data exchange entity, an execution command indicating to store an instance of a data program in a memory portion of the computing system by storing computer instructions based on an external data program of an external computing system. The computing system is configured to receive, at a service entity, from a data exchange entity, an indication of availability of the input data. The input data is available for use by the instance of the data program. The computing system is configured to send from the service entity an indication of availability of the output data. The output data is generated based on execution of the instance of the data program.