05675785 is referenced by 128 patents and cites 10 patents.

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.

Title
Data warehouse which is accessed by a user using a schema of virtual tables
Application Number
8/317437
Publication Number
5675785
Application Date
October 4, 1994
Publication Date
October 7, 1997
Inventor
Brian Fischer
Mokelumne Hill
CA, US
Marc Meyer
Granite Bay
CA, US
Mark Gratiot
Forest Hill
CA, US
Guy Randazzo
Rocklin
CA, US
Neil Yoshida
Sunnyvale
CA, US
Yukon Fong
Union City
CA, US
Suzie Cho Yee
Cupertino
CA, US
Mark Sturdevant
San Jose
CA, US
Guy Travis Hall
Loomis
CA, US
Assignee
Hewlett Packard Company
CA, US
IPC
G06F 17/30
View Original Source