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:
Nov. 19, 2013
Filed:
Dec. 29, 2011
Anjali Betawadkar-norwood, Campbell, CA (US);
Eileen Tien Lin, San Jose, CA (US);
Tam Minh Dai Tran, San Jose, CA (US);
Anjali Betawadkar-Norwood, Campbell, CA (US);
Eileen Tien Lin, San Jose, CA (US);
Tam Minh Dai Tran, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Techniques are described for optimizing a multi-fact star schema query to retrieve data from two or more fact tables of a database. The optimization techniques may include internally transforming a received multi-fact star schema query into a group of single-fact sub-queries, thereby reducing or eliminating certain constraints during query processing. The group of sub-queries may be enumerated to determine a query execution plan. The multi-fact star schema query may be executed according to the query execution plan to retrieve the data from the two or more fact tables of the database.