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

=CORRELATION-DRIVEN QUERY OPTIMIZATION FOR CLOUD-BASED STORES=


==Organization Name==

[[:Category:Teradata US, Inc|Teradata US, Inc]]


[[Category:Teradata US, Inc]]

==Inventor(s)==

[[:Category:Mohamed Ahmed Yassin Eltabakh of Worcester MA (US)|Mohamed Ahmed Yassin Eltabakh of Worcester MA (US)]][[Category:Mohamed Ahmed Yassin Eltabakh of Worcester MA (US)]]

[[:Category:Mohammed Al-kateb of Rolling Hills Estates CA (US)|Mohammed Al-kateb of Rolling Hills Estates CA (US)]][[Category:Mohammed Al-kateb of Rolling Hills Estates CA (US)]]

[[:Category:Sanjay Nair of El Segundo CA (US)|Sanjay Nair of El Segundo CA (US)]][[Category:Sanjay Nair of El Segundo CA (US)]]

[[:Category:Awny Kayed Al-omari of Cedar Park TX (US)|Awny Kayed Al-omari of Cedar Park TX (US)]][[Category: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.



[[Category:G06F16/25]]
[[Category:G06F16/22]]
[[Category:G06F16/901]]
[[Category:G06F16/242]]
[[Category:G06F16/2455]]