Patent
1993-09-02
1998-01-27
Black, Thomas G.
395346, 395353, 395356, 395604, 395764, 395769, G06F 1730
Patent
active
057130205
ABSTRACT:
A method and system for displaying results of multiple level aggregation queries and providing hierarchical table sets in response to multiple level aggregation queries. In a preferred embodiment, a database engine program receives multiple-level aggregation queries from a database front-end program. A multiple level aggregation query defines two or more data aggregation levels. In response to a multiple-level aggregation query, the engine creates a hierarchical table set, which contains a separate table for each level of aggregation specified by the multiple-level aggregation query. Each table in the hierarchical table set contains the aggregation information for one level of the multiple-level aggregation query. In a preferred embodiment, the front-end uses the tables in the hierarchical table set to generate a hierarchical window display that the user can view. The engine preferably also generates a crosstab table having row and column headers which are derived from the data in the source tables by converting a crosstab query into a multi-level aggregation query, executing the multi-level aggregation query, and then retrieve the data for the crosstab table using the hierarchical table set.
REFERENCES:
patent: 5191522 (1993-03-01), Bosco et al.
patent: 5255356 (1993-10-01), Michelman et al.
patent: 5293615 (1994-03-01), Amada
patent: 5317686 (1994-05-01), Salas et al.
patent: 5418950 (1995-05-01), Li et al.
patent: 5428737 (1995-06-01), Li et al.
patent: 5428776 (1995-06-01), Rothfield
Microsoft Works User's Guide, pp. 433-483, 1988.
Microsoft Corporation, "Language Reference," in Microsoft SQL Server. The Sybase Database Server for PC Networks, 1990, pp. 32 and 36.
Microsoft Corporation, "Learning TRANSACT-SQL," in Microsoft SQL Server. The SYBASE Database Server for PC Networks, 1990, pp. 90-94.
Bellew Matthew
Bosworth Adam
Brandli Stephen Albert
Hecht Stephen Charles
Reiter Allen
Alam Hosain T.
Black Thomas G.
Microsoft Corporation
LandOfFree
Method and system for generating database queries containing mul does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for generating database queries containing mul, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for generating database queries containing mul will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-350089