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

Details Data warehouse which is accessed by a user using a schema of vir Data warehouse which is accessed by a user using a schema of vir

1994-10-04

1997-10-07

Kulik, Paul V.

395601, 395602, 395604, 395611, G06F 1730

Patent

active

056757859

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.

REFERENCES:
patent: 4819160 (1989-04-01), Tanka et al.
patent: 5276870 (1994-01-01), Shan et al.
patent: 5418950 (1995-05-01), Li et al.
patent: 5418957 (1995-05-01), Narayan et al.
patent: 5428776 (1995-06-01), Rothfield
patent: 5448726 (1995-09-01), Crimsie et al.
patent: 5448727 (1995-09-01), Annevelinbk
patent: 5504885 (1996-04-01), Alashqur
patent: 5519859 (1996-05-01), Grace
patent: 5550971 (1996-08-01), Brunner et al.
"Client/Server accounting: accounting system based on client/server architectures increase productivity" by Stewark McKie, DBMS, V6, n2, p. 62(5); Feb., 1993.
"Using SQL:" by Que Corporation, 1993.

Affiliated with

Also associated with

Rating

Data warehouse which is accessed by a user using a schema of vir does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Data warehouse which is accessed by a user using a schema of vir, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data warehouse which is accessed by a user using a schema of vir will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2365406