Join index for relational databases

Details Join index for relational databases Join index for relational databases

1998-05-05

2000-12-26

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 4, 707 6, G06F 1730

Patent

active

061673994

ABSTRACT:
The retrieval of data from a computerized database is optimized through the use of a join index. A denormalized base table is converted into a plurality of normalized tables and the join index for the normalized tables is created by combining one or more commonly-used columns of the normalized tables. Outer joins are used to generate the join index, instead of inner joins, so that the join index satisfies queries with fewer join conditions than the ones used to generate the join index. Each row of the join index comprises a fixed part and a repeated part. The fixed part is stored only once in each row, but the repeated part is comprised of recursive levels within each row, so that each row may contain as many repeated parts as needed. In addition, each of the repeated parts comprises a fixed part and a repeated part.

REFERENCES:
patent: 5241648 (1993-08-01), Cheng et al.
patent: 5666525 (1997-09-01), Ross
patent: 5870747 (1999-02-01), Sundaresan
patent: 5983215 (1999-11-01), Ross et al.
patent: 5987453 (1999-11-01), Krishna et al.

Affiliated with

Also associated with

Rating

Join index for relational databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Join index for relational databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Join index for relational databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1005886