Method and system for querying tables stored on multiple...

Details Method and system for querying tables stored on multiple... Method and system for querying tables stored on multiple...

2011-01-25

2011-01-25

Cottingham, John R. (Department: 2167)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S718000, C707S719000

Reexamination Certificate

active

07877372

ABSTRACT:
A method, computer program, and database system are disclosed for querying tables stored on multiple processing modules. The method includes specifying module group characteristics. A plurality of modules corresponding to the module group characteristics are then identified. The identified modules are sampled for statistics concerning at least one table specified in a query. An execution plan for the query is optimized based at least in part on the sampled statistics.

REFERENCES:
patent: 5819255 (1998-10-01), Celis et al.
patent: 5870747 (1999-02-01), Sundaresan
patent: 5943666 (1999-08-01), Kleewein et al.
patent: 6092062 (2000-07-01), Lohman et al.
patent: 2004/0225639 (2004-11-01), Jakobsson et al.
patent: 2005/0102276 (2005-05-01), Dinh et al.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2711668