Deriving session level statistics for temporary tables

Details Deriving session level statistics for temporary tables Deriving session level statistics for temporary tables

2007-11-28

2010-12-28

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

File or database maintenance

Synchronization

C707S660000, C707S713000, C707S714000, C707S715000, C707S717000, C707S718000, C707S731000

Reexamination Certificate

active

07860833

ABSTRACT:
Statistics for temporary tables are used in optimizing the execution of a database request. A first temporary table is created using data from a data source as the result of performing an operation while executing the request. A subset of the demographics of the data source is saved in a session level memory as the demographics of the first temporary table. The saved demographics are used in optimizing the execution of the portion of the request involving the first temporary table.

REFERENCES:
patent: 5701461 (1997-12-01), Dalal et al.
patent: 5978789 (1999-11-01), Griffin et al.
patent: 6185556 (2001-02-01), Snodgrass et al.
patent: 6252876 (2001-06-01), Brueckheimer et al.
patent: 6275818 (2001-08-01), Subramanian et al.
patent: 6477535 (2002-11-01), Mirzadeh
patent: 6684203 (2004-01-01), Waddington et al.
patent: 6691101 (2004-02-01), MacNicol et al.
patent: 6714935 (2004-03-01), Delo
patent: 6801903 (2004-10-01), Brown et al.
patent: 7127449 (2006-10-01), Barsness et al.
patent: 7127457 (2006-10-01), Ghazal
patent: 7213012 (2007-05-01), Jakobsson
patent: 7383246 (2008-06-01), Lohman et al.
patent: 7392259 (2008-06-01), Lee et al.
patent: 7430562 (2008-09-01), Bedell et al.
patent: 2002/0184228 (2002-12-01), Ghukasyan et al.
patent: 2003/0088579 (2003-05-01), Brown et al.
patent: 2004/0225639 (2004-11-01), Jakobsson et al.
patent: 2005/0044063 (2005-02-01), Barsness et al.
patent: 2005/0097078 (2005-05-01), Lohman et al.
patent: 2005/0209988 (2005-09-01), Cunningham et al.
patent: 2006/0253422 (2006-11-01), Narasayya et al.
patent: 2007/0043697 (2007-02-01), Driesch et al.
patent: 2008/0177722 (2008-07-01), Lohman et al.
patent: 2008/0275840 (2008-11-01), Burger et al.

Affiliated with

Also associated with

Rating

Deriving session level statistics for temporary tables does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Deriving session level statistics for temporary tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Deriving session level statistics for temporary tables will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4207063