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. 04, 2012
Filed:
Mar. 01, 2011
Roger Bolsius, Round Rock, TX (US);
Raghuram Venkatasubramanian, Cupertino, CA (US);
Ling NI, Milpitas, CA (US);
Donko Donjerkovic, Redwood City, CA (US);
Saugata Chowdhury, Sunnyvale, CA (US);
Roger Bolsius, Round Rock, TX (US);
Raghuram Venkatasubramanian, Cupertino, CA (US);
Ling Ni, Milpitas, CA (US);
Donko Donjerkovic, Redwood City, CA (US);
Saugata Chowdhury, Sunnyvale, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A business intelligence (BI) server and repository are described which support a set of hierarchical relationships among the data. The BI server receives user input specifying a set of parent-child or other ancestral relationship among a set of data in a data source. The BI server generates a set of SQL queries and executes the queries to pre-populate a set of tables which specify the parent child relationships among the data in the data source. One such table is a parent-child relationship closure table that defines the inter-member relationships among the data members. Once the tables are populated, the BI server uses the closure tables to answer queries that require knowledge of the ancestral relationships among data.