20240012826. CORRELATION-DRIVEN QUERY OPTIMIZATION FOR CLOUD-BASED STORES simplified abstract (Teradata US, Inc)
Contents
CORRELATION-DRIVEN QUERY OPTIMIZATION FOR CLOUD-BASED STORES
Organization Name
Inventor(s)
Mohamed Ahmed Yassin Eltabakh of Worcester MA (US)
Mohammed Al-kateb of Rolling Hills Estates CA (US)
Sanjay Nair of El Segundo CA (US)
Awny Kayed Al-omari of Cedar Park TX (US)
CORRELATION-DRIVEN QUERY OPTIMIZATION FOR CLOUD-BASED STORES - A simplified explanation of the abstract
This abstract first appeared for US patent application 20240012826 titled 'CORRELATION-DRIVEN QUERY OPTIMIZATION FOR CLOUD-BASED STORES
Simplified Explanation
The patent application describes a method and apparatus for optimizing queries in a relational database management system (RDBMS) when a predicate on a data column in the query has a correlation to a partitioning attribute of a partitioning column in data retrieved from a cloud-based store. The optimization process utilizes the correlation between the data column in the query and the partitioning column in the data retrieved from the cloud-based store to eliminate unnecessary data processing.
- The correlation between the data column in the query and the partitioning column in the data retrieved from the cloud-based store is defined in a formula or lookup data structure.
- The formula or lookup data structure maps or range-maps from the data column to the partitioning column, allowing for efficient data elimination during query processing.
Potential applications of this technology:
- Improved query performance in cloud-based relational databases.
- Enhanced efficiency in processing queries with correlated predicates.
- Optimization of data retrieval and processing in cloud-based storage systems.
Problems solved by this technology:
- Inefficient query processing due to lack of correlation awareness between data columns and partitioning columns.
- Unnecessary data processing and retrieval in cloud-based storage systems.
- Performance bottlenecks in relational database management systems.
Benefits of this technology:
- Faster query processing and improved overall system performance.
- Reduced resource consumption in cloud-based storage systems.
- Enhanced scalability and efficiency in managing large datasets.
Original Abstract Submitted
a method and apparatus for optimizing a query in a relational database management system (rdbms) when a predicate on a data column in the query has a correlation to a partitioning attribute of a partitioning column in data retrieved from a cloud-based store, wherein the optimizing uses the correlation between the data column in the query to the partitioning column in the data retrieved from the cloud-based store for data elimination when processing the query. the correlation is defined in a formula or lookup data structure that maps or range-maps from the data column to the partitioning column.