The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 30, 2005
Filed:
Oct. 03, 2001
Robert Douglas Driesch, Jr., Lakeville, MN (US);
Thomas J. Schreiber, Rochester, MN (US);
Robert Douglas Driesch, Jr., Lakeville, MN (US);
Thomas J. Schreiber, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Methods, systems and articles of manufacture for selectively maintaining query implementation information. A user is able to set a Predictive Query Threshold which will be honored by a database system to determine for which queries information will be collected. In one embodiment, the decision about whether to collect information for a query is made before the query starts to run (i.e., before the plan is executed) by comparing the Predictive Query Threshold to some cost factor (e.g. estimated runtime). In another embodiment, each query may be monitored but the query implementation information is only selectively logged. Specifically, the determination as to whether query implementation information for a query should be logged is made after the query implementation information is collected.