18302242. RESULT STREAMING BY REORDERING PIPELINES simplified abstract (SAP SE)

From WikiPatents
Jump to navigation Jump to search

RESULT STREAMING BY REORDERING PIPELINES

Organization Name

SAP SE

Inventor(s)

Christina Teflioudi of Heidelberg (DE)

Paul Willems of Heidelberg (DE)

Till Merker of Sandhausen (DE)

RESULT STREAMING BY REORDERING PIPELINES - A simplified explanation of the abstract

This abstract first appeared for US patent application 18302242 titled 'RESULT STREAMING BY REORDERING PIPELINES

    • Simplified Explanation:**

The patent application describes a method for optimizing query plans by reordering pipelines to enable result streaming.

    • Key Features and Innovation:**
  • Method for query plan generation and optimization
  • Detection of restart and result pipelines in query plans
  • Reordering of pipelines to enable result streaming optimization
    • Potential Applications:**

This technology can be applied in database management systems, data analytics platforms, and real-time data processing systems.

    • Problems Solved:**

This technology addresses the problem of inefficient query execution in systems with restart and result pipelines.

    • Benefits:**
  • Improved query performance
  • Enhanced result streaming capabilities
  • Optimized resource utilization
    • Commercial Applications:**

Optimizing query plans can benefit companies in various industries such as e-commerce, finance, and healthcare by improving data processing efficiency and reducing latency.

    • Prior Art:**

Researchers can explore prior art related to query plan optimization, query execution, and result streaming techniques in database systems.

    • Frequently Updated Research:**

Stay updated on the latest advancements in query optimization algorithms, query plan reordering techniques, and result streaming optimizations in database systems.

    • Questions about Query Plan Optimization:**

1. What are the key challenges in optimizing query plans for efficient data processing? 2. How does reordering pipelines in query plans impact overall system performance?


Original Abstract Submitted

In some example embodiments, there is provided a method that includes receiving a query for query plan generation and query plan optimization; detecting whether the query plan includes a restart pipeline, the restart pipeline including one or more first operators that cause a query plan restart; detecting whether the query plan includes a result pipeline, the result pipeline including one or more second operators that provide result streaming; determining whether there is a dependency between execution of the restart pipeline and execution of the result pipeline; in response to determining there is no dependency, reordering the restart pipeline in the query plan such that the restart pipeline will be executed before the result pipeline in order to enable result streaming optimization; and providing the reordered query plan for execution. Related systems and computer program products are also provided.