Using temporary performance objects for enhanced query performance

Patent metadata

Field	Value
Publication number	US-8996499-B2
Application number	US-201213720201-A
Country	US
Kind code	B2
Filing date	Dec 19, 2012
Priority date	Dec 19, 2012
Publication date	Mar 31, 2015
Grant date	Mar 31, 2015

Abstract

Methods and apparatus, including computer program products, implementing and using techniques for optimizing query performance in a relational database management system. A query is received at the relational database management system. It is determined whether the query is expected to be a long-running query. In response to determining that the query is expected to be a long-running query, a full table scan is started in order to fetch records needed to satisfy the query from the relational database management system. In parallel with conducting the full table scan, a performance object is built, which is capable of satisfying the query in the relational database management system. In response to completing the construction of the performance object prior to completing the full table scan, the full table scan is stopped and the newly built performance object is used instead to satisfy the query.

First claim

The invention claimed is:

1. A computer program product for optimizing query performance in a relational database management system, the computer program product comprising a non-transitory computer readable storage medium having program code embodied therewith, the program code executable by a processor to:
receive, by the processor, a query at the relational database management system;
determine, by the processor, whether the query is expected to be a long-running query;
in…

Assignees

• IBM

Inventors

• Kaminsky David L
• Prasad Ramya H
• Sundaram Girish

Classifications

• G06F16/2453 Primary

  Physics · mapped topic

• G06F17/30442 Primary

  Physics · mapped topic