Join pattern agnostic aggregate computation in database query operations
AssigneeGoogle Inc.
InventorsLloyd Tabb, Steven Talbot
Life of this patent
Estimating the term…
Loading patent…
AssigneeGoogle Inc.
InventorsLloyd Tabb, Steven Talbot
Estimating the term…
A method of computing a join pattern agnostic aggregate function includes loading source code and parsing the source code to identify different database query operations. In response to the identification of an aggregate function in one of the different database query operations in which records in multiple tables are joined together in a table join, a multiplicity of primary keys are retrieved, each corresponding to a different one of the multiple tables and also an object of one of the tables referenced by the identified aggregate function. An existence of a fan out condition associated with the table join is then computed. On condition that an existence of the fan out condition is not computed a non-fan out sensitive implementation of the aggregate function is invoked with respect to the object. But, otherwise, a different, fan-out sensitive implementation of the aggregate function is invoked with respect to the object.
A computer-implemented method when executed on data processing hardware causes the data processing hardware to perform operations comprising:
A system comprising:
Dependencies are inferred from the claim text.