17933212. COLUMN-BASED UNION PRUNING simplified abstract (SAP SE)
Contents
COLUMN-BASED UNION PRUNING
Organization Name
Inventor(s)
Christoph Weyerhaeuser of Leimen (DE)
Simon Spohrer of Mannheim (DE)
Mohamed Ali Chriki of Leiman (DE)
COLUMN-BASED UNION PRUNING - A simplified explanation of the abstract
This abstract first appeared for US patent application 17933212 titled 'COLUMN-BASED UNION PRUNING
Simplified Explanation
The patent application describes a method for optimizing queries across multiple data sources by identifying and pruning null values to improve query performance.
- The method involves receiving a query with a first attribute from multiple data sources.
- It identifies a query operator with inputs from different data sources, one of which has a null value for the first attribute.
- The method prunes the null value input to prevent unnecessary data retrieval.
- It then performs the query operator by selecting the necessary data from the data source without the null value.
Potential Applications
This technology could be applied in database management systems, data analytics platforms, and data integration tools to improve query performance and optimize data retrieval processes.
Problems Solved
1. Enhanced query performance by eliminating unnecessary data retrieval. 2. Improved efficiency in querying across multiple data sources.
Benefits
1. Faster query execution. 2. Reduced data transfer and processing overhead. 3. Enhanced scalability for handling large datasets.
Potential Commercial Applications
Optimized query processing technology for enterprise database systems.
Possible Prior Art
One possible prior art could be the use of query optimization techniques in relational database management systems to improve query performance.
Original Abstract Submitted
In one aspect, a method may include receiving a query associated with a plurality of data sources, wherein the query includes a first attribute; identifying that a query operator, which is associated with execution of the query and the first attribute, includes a first input from a first data source of the plurality of data sources and a second input from a second data source of the plurality of data sources; determining that the first attribute at the second data source corresponds to null; pruning, based on the determined null, the second input from the second data source to inhibit a select from the second data source; and in response to the pruning, performing the query operator by selecting, from the first data source, a column corresponding to the first attribute. Related systems, methods, and articles or manufacture are also disclosed.
