Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-03-07
2006-03-07
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07010516
ABSTRACT:
The invention provides methods for optimizing a database management system process of a query. The methods are suitable for execution in a properly configured computer system. In an embodiment of the invention, a plurality of single column statistics are collected for a plurality of columns. This plurality of single column statistics provides an estimate of row counts and unique entry counts for a singe column operator. A preferred single column statistic is selected from the plurality of single column statistics according to a predetermined criteria. The preferred single column statistic is then stored. A selectivity estimate is then determined for predicates in the query using the preferred single column statistic. The selectivity estimate is used in optimizing processing of the query by the database management system.
REFERENCES:
patent: 6029163 (2000-02-01), Ziauddin
patent: 6272487 (2001-08-01), Beavin et al.
patent: 6363371 (2002-03-01), Chaudhuri et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
Corrielus Jean M.
Hewlett--Packard Development Company, L.P.
Woo Isaac M.
LandOfFree
Method and system for rowcount estimation with multi-column... 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 rowcount estimation with multi-column..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for rowcount estimation with multi-column... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3535609