Avoiding creation of database statistics

Details Avoiding creation of database statistics Avoiding creation of database statistics

2008-03-18

2008-03-18

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07346602

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

Affiliated with

Also associated with

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

Comments { 0 }

Profile ID: LFUS-PAI-O-2797016