Dynamic partition enhanced joining using a value-count index

Details Dynamic partition enhanced joining using a value-count index Dynamic partition enhanced joining using a value-count index

2004-06-07

2009-12-29

Pham, Khanh B (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07640244

ABSTRACT:
Methods, computer programs, and database systems for performing a database query to join two or more tables on a condition are disclosed. Each table includes one or more join columns. Each of the join columns includes zero or more join-column values. The method includes excluding join-column values that do not satisfy the condition, using one or more value-count indexes and performing the database query on non-excluded join-column values.

REFERENCES:
patent: 4956774 (1990-09-01), Shibamiya et al.
patent: 5241648 (1993-08-01), Cheng et al.
patent: 5557791 (1996-09-01), Cheng et al.
patent: 5822750 (1998-10-01), Jou et al.
patent: 5903893 (1999-05-01), Kleewein et al.
patent: 5918225 (1999-06-01), White et al.
patent: 5930785 (1999-07-01), Lohman et al.
patent: 5983215 (1999-11-01), Ross et al.
patent: 6052693 (2000-04-01), Smith et al.
patent: 6167399 (2000-12-01), Hoang
patent: 6226639 (2001-05-01), Lindsay et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6944633 (2005-09-01), Higa et al.
patent: 2001/0014888 (2001-08-01), Tsuchida et al.
patent: 2003/0074348 (2003-04-01), Sinclair et al.
patent: 2003/0217033 (2003-11-01), Sandler et al.
patent: 2004/0172400 (2004-09-01), Zarom et al.
patent: 2004/0249845 (2004-12-01), Das
patent: 2004/0260684 (2004-12-01), Agrawal et al.
patent: 2005/0149491 (2005-07-01), Bakalash et al.
patent: 2005/0160102 (2005-07-01), Abdo et al.
patent: 2005/0240615 (2005-10-01), Barsness et al.
patent: 2006/0047638 (2006-03-01), Dettinger et al.
http://www.novell.com/documentation/extendas37/docs/help/java/jdkee/cloudscape/doc/html/coredocs/sqlj18.htm Copyright © 1998 and 1999 Cloudscape, Inc. All rights reserved.
http://www.cs.brown.edu/courses/cs227/Papers/Indexing/O'NeilGraefe.pdf SIGMOD Record, vol. 24, No. 3, Sep. 1995.
http://www.oreilly.com/catalog/transqlcook/errata/transqlcook.confirmed Jul. 15, 2002.
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96533.pdf Oct. 2002.
http://www.databasejournal.com/features/mssql/article.php/1459141 Aug. 31, 2000.
Eric Miner, Sybase, “Session No. DM131 New Optimizer and Query Execution Options in Adaptive Server Enterprise 12.0.”, 1999, http://isug.com/ISUG3/docs/Techwave—Optimiser—notes.ppt.
Plew, Ron et al., “Tables in SQL Queries”, http://www.informit.com/articles/printerfriendly.asp?p=29842&rl=1 (Sample chapter provided courtesy of Sams), (Oct. 25, 2002),.

Affiliated with

Also associated with

Rating

Dynamic partition enhanced joining using a value-count index does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamic partition enhanced joining using a value-count index, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic partition enhanced joining using a value-count index will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4149303