Method and system for updating value correlation optimizations

Details Method and system for updating value correlation optimizations Method and system for updating value correlation optimizations

2007-09-18

2007-09-18

Cottingham, John (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10762735

ABSTRACT:
A method, computer program, and database system are disclosed for executing database queries. The database includes a first table (T1) having a primary key (PK) column and a first correlated value column (CV1) and a second table (T2) having a foreign key (FK) column related to the primary key column of the first table and a second correlated value column (CV2). One implementation of the method includes preparing a database query for execution based at least in part on application of a derived constraint rule (DCR) having the form, (PK=FK)→CV2+C1≦CV1≦CV2+C2, where C1and C2are constants and “→” means “implies,” to produce an execution plan. Abort steps that are conditioned on changes in the DCR are also included in the execution plan. The plan is then executed.

REFERENCES:
patent: 5899993 (1999-05-01), Jenkins, Jr.
patent: 5956704 (1999-09-01), Gautam et al.
patent: 6272487 (2001-08-01), Beavin et al.
patent: 6460043 (2002-10-01), Tabbara et al.
patent: 6609131 (2003-08-01), Zait et al.
patent: 6662175 (2003-12-01), Ghazal et al.
patent: 6957225 (2005-10-01), Zait et al.
patent: 2002/0083049 (2002-06-01), Forster et al.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3736900