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:
Sep. 30, 2003
Filed:
Sep. 01, 2000
Latha S. Colby, Los Altos, CA (US);
Richard L. Cole, Los Gatos, CA (US);
Edward P. Haslam, San Francisco, CA (US);
Nasi Jazayeri, Santa Clara, CA (US);
Galt Johnson, Campbell, CA (US);
William McKenna, Santa Cruz, CA (US);
Lee E. Schumacher, Los Altos, CA (US);
David G. Wilhite, Jr., Santa Clara, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A system and method for answering a relational database query is presented. According to an embodiment of the present invention, a database query is received. It is then determined whether that query can be rewritten in such a manner as to be able to utilize a precomputed view, such that an answer to the rewritten query is equivalent to an answer to the original query. If the query can be rewritten, it is determined whether the rewritten query can more efficiently derive the answer than the original query. The query which has the most efficiently derived answer is the query which is utilized to derive that answer.