Avoiding creation of database statistics

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000

Reexamination Certificate

active

11088711

ABSTRACT:
The invention relates to a method for providing access paths to data within a database, in particular using REBIND for DB2, wherein real time database statistics are determined using a database integrated monitor, wherein the database statistics are output substantially in real time using the database integrated status monitor, and wherein the database statistics from the integrated monitor are used to initiate generation of data set statistics, and to determine the access paths. To allow efficient generation of access paths, the following steps are proposed: determining from the database statistics a total number of rows of at least one data set of the database, comparing the determined total number of rows with a first threshold value, deciding solely based on the total number of rows to provide a database catalogue with the data set statistics in case the total number of rows reaches the threshold value, and determining the access paths to the data based on the data set statistics within the database catalogue.

REFERENCES:
patent: 2002/0087587 (2002-07-01), Vos et al.
patent: 2004/0034643 (2004-02-01), Bonner et al.
patent: 04007174.8 (2004-09-01), None

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Avoiding creation of database statistics does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

     

Profile ID: LFUS-PAI-O-3917034

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.