logo

For the Inventor, By the Inventor

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.:

US 5675785 B1

PDFFull Text
Date of Patent:
Oct. 07, 1997

Filed:

Oct. 04, 1994

Data warehouse which is accessed by a user using a schema of virtual

Applicant:
Inventors:

Guy Travis Hall, Loomis, CA (US);

Mark Sturdevant, San Jose, CA (US);

Suzie Cho Yee, Cupertino, CA (US);

Yukon Fong, Union City, CA (US);

Neil Yoshida, Sunnyvale, CA (US);

Guy Randazzo, Rocklin, CA (US);

Mark Gratiot, Forest Hill, CA (US);

Marc Meyer, Granite Bay, CA (US);

Brian Fischer, Mokelumne Hill, CA (US);

Assignee:

Hewlett-Packard Company, Palo Alto, CA (US);

Attorney:
Primary Examiner:

Paul V Kulik

Assistant Examiner:

Hosain T Alam

Int. Cl.
CPC ...
G06F / ;
U.S. Cl.
CPC ...
395613 ; 395601 ; 395602 ; 395604 ; 395611 ;
Abstract

A database warehouse includes a database having data arranged in data tables, e.g., fact tables and reference tables. A warehouse database hub interface is connected to the database. The warehouse database hub interface presents to a user a schema of the data in the database warehouse. The schema consists of virtual tables. Arrangement of the data in the virtual tables is different than arrangement of data in the fact tables and the reference tables. A user generates queries based on the schema provided by the warehouse database hub interface. In response to a such a query for particular information stored in the database warehouse, the warehouse database hub interface modifies the query to take into account pre-computed values and the arrangement of the data within the database warehouse. Then the warehouse database hub interface queries the database warehouse using the modified query to obtain the particular information from the database warehouse. Finally, the warehouse database hub interface forwards the particular information obtained from the database warehouse to the user.

Find Patent Forward Citations

Quick Actions:

Hall, Guy. (1997). Data warehouse which is accessed by a user using a schema of virtual (U.S. Patent No. 5675785). U.S. Patent and Trademark Office. https://idiyas.com/patent/badge/5675785

Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile

Loading…