20240012826. CORRELATION-DRIVEN QUERY OPTIMIZATION FOR CLOUD-BASED STORES simplified abstract (Teradata US, Inc)

From WikiPatents
Jump to navigation Jump to search

CORRELATION-DRIVEN QUERY OPTIMIZATION FOR CLOUD-BASED STORES

Organization Name

Teradata US, Inc

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.

Retrieved from "http://wikipatents.org/index.php?title=20240012826._CORRELATION-DRIVEN_QUERY_OPTIMIZATION_FOR_CLOUD-BASED_STORES_simplified_abstract_(Teradata_US,_Inc)&oldid=27680"