Method and system for multiple function database indexing

Details Method and system for multiple function database indexing Method and system for multiple function database indexing

2006-11-14

2006-11-14

Gaffin, Jeffrey (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C715S252000

Reexamination Certificate

active

07136861

ABSTRACT:
A method, computer program, and computer system are disclosed for indexing database table rows. A first set of one or more columns of the database table is chosen. A second set of one or more columns of the database table is chosen. An index record is generated for each unique result of applying a second function to a value corresponding to the second set for the database table rows. In each index record, only a single copy of each unique result of applying a first function to a value corresponding to the first set for the database table rows having the result of applying the second function to a value corresponding to the second set for that index record is included. The first set is not identical to the second set. At least two rows of the database table rows have the same result of applying the second function to a value corresponding to the second set and have the same result of applying the first function to the value corresponding to the first set.

REFERENCES:
patent: 5802357 (1998-09-01), Li et al.
patent: 5983215 (1999-11-01), Ross et al.
patent: 6421662 (2002-07-01), Karten
patent: 6618729 (2003-09-01), Bhashyam et al.
patent: 6772163 (2004-08-01), Sinclair et al.
Leslie Cranston, New Data Clustering Techniques for Performance: Multidimensional Clustering, DB2 for Linux, Unix, Windows, Session: B6, Tuesday, May 14, 2002, 1 pm, IBM Toronto Lab.

Affiliated with

Also associated with

Rating

Method and system for multiple function database indexing 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 multiple function database indexing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for multiple function database indexing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3633146