Summary table query routing

Details Summary table query routing Summary table query routing

1997-10-31

2000-02-08

Kulik, Paul V.

Data processing: database and file management or data structures

Database design

Data structure types

707 4, G06F 1730

Patent

active

060236965

ABSTRACT:
Methods and apparatus for effective and efficient usage of summary tables in a computer system including a database. In a computer system it is common for a database to include one or more summary tables which have pre-generated aggregations of data from one or more original, detailed database tables. In order to achieve the benefits of summary tables, they must be accessed when appropriate. Thus, information regarding the available summary database tables, including summary bitmaps for all the summary tables, is maintained in the metadata of a computer system. This information is updated whenever a summary table is created. The summary bitmaps are a main key for determining if any summary table is responsive to a user query to the computer system. The summary bitmaps map to corresponding SQL statements, which are generated to access the respective summary tables in the database. Once an SQL statement for accessing a respective summary table is identified for a particular user query, that SQL statement is then incorporated in the executable SQL query that is thereafter executed.

REFERENCES:
patent: 5675785 (1997-10-01), Hall et al.
patent: 5710915 (1998-01-01), McElhiney
patent: 5781896 (1998-07-01), Dalal
patent: 5845276 (1998-12-01), Emerson et al.
patent: 5884307 (1999-03-01), Depledge et al.
Designer's Guide Manual for Business Objects for Window 4.0 (section entitled "Aggregate Navigation"), pp. 133-135, Sep. 1996.

Affiliated with

Also associated with

Rating

Summary table query routing does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Summary table query routing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Summary table query routing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1688508