Patent Document ID: 8589382
Application ID: 13340288

Base Claim:
1. A method comprising: receiving, by a query optimizer executing on one or more processors of a computing device, a multi-fact star schema query that is executable to retrieve data from two or more fact tables of a database, wherein the two or more fact tables each references a common dimension table of the database; internally transforming, by the query optimizer, the multi-fact star schema query into a group of single-fact sub-queries, wherein each sub-query of the group of single-fact sub-queries references only one of the two or more fact tables; enumerating, by the query optimizer, the group of single-fact sub-queries to determine a query execution plan; and executing, by a runtime execution engine executing on the one or more processors, the multi-fact star schema query according to the query execution plan to retrieve the data from the two or more fact tables of the database.

---

Claim 2:
2. The method of claim 1 , wherein internally transforming the multi-fact star schema query into the group of single-fact sub-queries is performed responsive to: (i) determining that the multi-fact star schema query equi-joins the common dimension table and each of the two or more fact tables on a common joining column of the common dimension table, wherein the common joining column comprises one or more data values; and (ii) determining that each of the one or more data values of the joining column of the common dimension table are unique within the joining column.