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. 17, 2013
Filed:
Sep. 16, 2004
Matthew Dombroski, Lancaster, MA (US);
Caleb Welton, Malden, MA (US);
Ekrem Soylemez, Arlington, MA (US);
Albert A. Hopeman, Iv, Arlington, MA (US);
Matthew Dombroski, Lancaster, MA (US);
Caleb Welton, Malden, MA (US);
Ekrem Soylemez, Arlington, MA (US);
Albert A. Hopeman, IV, Arlington, MA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Predicate abduction involves identifying, from a database statement, predicates on attributes of dimensional data, and applying those predicates to corresponding measure data so that only measure values are fetched and returned for dimension values that satisfy the predicate. In contrast to processing joins of relational data, the subset of the measure data is determined without needing to join a fact table with a dimension table and, therefore, without processing every fact record to determine which measure values are associated with records that satisfy the condition. Buffer reuse involves storing in buffers the 'domains' of queries executing on multidimensional data. Responsive to detecting that execution of a database statement requires multiple iterations of extracting the same multidimensional data, the data is extracted during the first iteration and stored in a buffer so that, for each subsequent iteration, the buffer-stored data is accessed rather than re-extracting the data.