Optimizer improved statistics collection

Details Optimizer improved statistics collection Optimizer improved statistics collection

2006-09-26

2006-09-26

Breene, John (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07113936

ABSTRACT:
Described are techniques for performing compression and decompression of statistical data. This data may be used in connection with performing optimizations. A delta value for each statistic is determined representing a difference between a current value and a previous value. Delta values are stored in a statistics table in a compressed form using a monotonic compression scheme. Small tables are used to determine decompressed values estimating the observed values. Statistical information is stored and represented in a statistics table and an events table. Statistical information is selectively fetched and loaded into memory from a storage device. Indexing techniques are used to force physical continuity of the rows of the statistics table on a storage device in accordance with a specified retrieval order.

REFERENCES:
patent: 5381539 (1995-01-01), Yanai et al.
patent: 5592432 (1997-01-01), Vishlitzky et al.
patent: 5758146 (1998-05-01), Schiefer et al.
patent: 5819310 (1998-10-01), Vishlitzky et al.
patent: 5890014 (1999-03-01), Long
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6591269 (2003-07-01), Ponnekanti
Smalley, Eric, “Frye adds history module to node monitor” (Frye Computer System Inc's Node Tracker 2.0 network management software) (Brief Article) (Product Announcement); Oct. 31, 1994; PC Week, v11, n43, p73(1).
Sanna et al., “ProQuest Information and Learning—Special Edition Using Windows NT Workstation 4.0”; Aug. 22, 1997; Que; ISBN 0-7897-1384-5, pp. 1-16.
Mellish et al., “ProQuest Information and Learning—Fibre Array Storage Technology A FAStT Introduction”; May 31, 2001; IBM; ISBN 0-7384-2167-7; pp. 1, 12-21.
“VERITAS Volume Manager 2.7 for Windows 2000—User's Guide”; Jun. 2001; VERITAS; “Performance Tuning”; pp. 145-156.
Paul Cassel; “Microsoft Windows 2000 Professional Unleashed”; Feb. 14, 2000; Sams Publishing; Chapter 28, Performance Monitor; ISBN: 0-672-31742-7.
Wyke et al.; “PHP Developer's Dictionary”; Dec. 13, 2000; Sams; ISBN: 0-672-32029-0.

Affiliated with

Also associated with

Rating

Optimizer improved statistics collection does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimizer improved statistics collection, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizer improved statistics collection will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3594318