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:
Dec. 31, 2013
Filed:
Feb. 09, 2010
Dongsheng Chen, Beijing, CN;
Hong Min, Poughkeepsie, NY (US);
Terence P. Purcell, Springfield, IL (US);
Yefim Shuf, Yorktown Heights, NY (US);
Xiaobo Wang, Beijing, CN;
Zhongliang Zhang, Beijing, CN;
Dongsheng Chen, Beijing, CN;
Hong Min, Poughkeepsie, NY (US);
Terence P. Purcell, Springfield, IL (US);
Yefim Shuf, Yorktown Heights, NY (US);
Xiaobo Wang, Beijing, CN;
Zhongliang Zhang, Beijing, CN;
International Business Machines Corporation, Armonk, NY (US);
Abstract
Techniques for generating a set of one or more materialized query table (MQT) candidates for a workload are provided. The techniques include receiving a workload, wherein the workload comprises a set of one or more queries, generating one or more best matching MQTs (BMQTs) based on one or more query blocks of the one or more queries by removing syntax that is not qualified for a MQT re-write, determining one or more frequently used multi-joins in the workload, using the one or more BMQTs and the one or more frequently used multi-joins to generate a set of one or more workload MQTs (WMQTs), and grouping one or more WMQTs and one or more BMQTs into one or more groups to merge into a set of a smaller number of MQTs and to cover the workload.