Join pattern agnostic aggregate computation in database query operations

A database query data processing system configured for join pattern agnostic aggregate function computation in database query operations, the system comprising:

• a host computing system comprising one or more computers, each with memory and at least one processor;
• a relational database management system executing in the memory of the computer and acting upon a multiplicity of different tables in one or more databases stored in fixed storage coupled to the host computing system;
• and,
• a join pattern agnostic aggregate function computation module comprising computer program instructions executing in the memory of the host computing system, the program instructions performing:
• loading a source code document into the memory;
• parsing the source code document to identify different database query operations;
• and,
• responsive to identifying an aggregate function in one of the different database query operations in which records in multiple tables are joined together in a table join, performing:
• retrieving from memory of the computer a multiplicity of primary keys, 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;
• computing an existence of a fan out condition associated with the table join;
• and,
• on condition that the fan out condition is not computed, invoking a non-fan out sensitive implementation of the aggregate function with respect to the object, but otherwise on condition that the fan out condition is computed, invoking a different, fan-out sensitive implementation of the aggregate function with respect to the object.

A computer program product for computing a join pattern agnostic aggregate function, the computer program product including a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a device to cause the device to perform a method including:

• loading a source code document into memory of a computer;
• parsing the source code document to identify different database query operations;
• and,
• responsive to identifying an aggregate function in one of the different database query operations in which records in multiple tables are joined together in a table join, performing:
• retrieving from memory of the computer a multiplicity of primary keys, 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;
• computing an existence of a fan out condition associated with the table join;
• and,
• on condition that the fan out condition is not computed, invoking a non-fan out sensitive implementation of the aggregate function with respect to the object, but otherwise on condition that the fan out condition is computed, invoking a different, fan-out sensitive implementation of the aggregate function with respect to the object.