Patents by Inventor Harry Anthony Leslie

Harry Anthony Leslie has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Method and system for rowcount estimation with multi-column statistics and histograms
    Patent number: 7010516
    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.
    Type: Grant
    Filed: December 19, 2001
    Date of Patent: March 7, 2006
    Assignee: Hewlett-Packard Development Company, L.P.
    Inventor: Harry Anthony Leslie
  • Method and system for rowcount estimation with multi-column statistics and histograms
    Publication number: 20030135485
    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.
    Type: Application
    Filed: December 19, 2001
    Publication date: July 17, 2003
    Inventor: Harry Anthony Leslie