Visa International Service Association

Sandeep Sree Rama Garimella

Santosh Hegde

Vamsi Krishna Inaganti

Nikita Pande

Thrilok Attota

Described are a system, method, and computer program product for accelerated database queries using aggregation definitions. The method includes receiving a first set of database queries and parsing each query to produce a plurality of query parameters. The method also includes determining a plurality of frequencies based on a frequency of each query parameter occurring in the first set of database queries. The method further includes generating a plurality of aggregation definitions based on the plurality of query parameters and the plurality of frequencies. The method further includes determining a candidate set of aggregation definitions from the plurality of aggregation definitions, based on a number of queries that would be at least partially satisfied by each aggregation definition of the plurality of aggregation definitions. The method further includes generating an aggregated dataset based on the candidate set of aggregation definitions and performing a database query using the aggregated dataset.

Growing community of inventors

Hyderabad Telangana, India

Sandeep Sree Rama Garimella