Database Query Handling Using Pre-Calculated Association Pagination Ranking
AssigneeSap SE
InventorsRamana Kumar Rajaraman, Nagendra Manchuri
Life of this patent
Estimating the term…
Abstract
Enhanced database query handling is provided using pre-calculated association pagination ranking. Such pre-calculated rankings can be generated using various approaches including by calculating rank along with an intersection, addition, and deletion of association rows corresponding to a parent row being modified or by a stored procedure which uses the ranking operations. Related apparatus, systems, techniques and articles are also described.
Claims20
A method for enabling efficient database query handling comprising:
- loading a parent row into memory of a database;
- updating at least one attribute in the parent row;
- calculating an intersection, addition, and deletion of association rows corresponding to the parent row;
- determining a ranking for each association row based on the calculating;
- and
- updating rankings for the association rows with the determined rankings.
A system for enabling efficient database query handling comprising:
- at least one data processor;
- and
- memory comprising instructions which, when executed by the at least one data processor, result in operations comprising:
- loading a parent row in memory of a database;
- updating at least one attribute in the parent row;
- calculating an intersection, addition, and deletion of association rows corresponding to the parent row;
- determining a ranking for each association row based on the calculating;
- and
- updating rankings for the association rows with the determined rankings.
A non-transitory computer program product comprising instructions for enabling efficient database query handling, the instructions, when executed by at least one computing device, result in operations comprising:
- loading a parent row in memory of a database;
- updating at least one attribute in the parent row;
- calculating an intersection, addition, and deletion of association rows corresponding to the parent row;
- determining a ranking for each association row based on the calculating;
- and
- updating rankings for the association rows with the determined rankings.
Dependencies are inferred from the claim text.