DISTRIBUTED QUERY OPTIMIZATION

Organization Name

international business machines corporation

Inventor(s)

Sudheesh S. Kairali of Kozhikode (IN)

Binoy Thomas of Kozhikode (IN)

Sarbajit K. Rakshit of Kolkata (IN)

DISTRIBUTED QUERY OPTIMIZATION

This abstract first appeared for US patent application 20250086172 titled 'DISTRIBUTED QUERY OPTIMIZATION

Original Abstract Submitted

distributed queries are analyzed to identify repeated queries. pattern of the repeated queries is learned, where the pattern provides information associated with at least availability of data sources used for responding to the repeated queries and response times of the data sources. for a data source in the data sources, a time window during which the data source has a response time that is slower than a response time criterion is determined; prior to beginning of the time window, data is prefetched from the data source and storing the data in a cache storage; responsive to receiving a distributed query that uses the data source during the time window, the data is fetched from the cache storage, where at least a part of a response to the distributed query is sourced from the cache storage; and after end of the time window, the data is removed from the cache storage.