Patents by Inventor Andrew P. Osborn

Andrew P. Osborn 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).

  • Summary table management in a computer system
    Patent number: 6249791
    Abstract: A self monitoring system that identifies optimum summary table(s) for use by a database management system, and that automatically creates or deletes summary tables based on selected summary table recommendations.
    Type: Grant
    Filed: May 18, 1999
    Date of Patent: June 19, 2001
    Assignee: Oracle Corporation
    Inventors: Andrew P. Osborn, Robert L. Lavender, Stephen D. Cave
  • Systems and methods for estimating query response times in a computer system
    Patent number: 6026391
    Abstract: A query performance prediction ("QPP") module is provided as part of an applications layer residing on respective user stations operating in conjunction with a centralized host computer system. The QPP module correlates estimated system cost information for a database query provided from a database management system associated with the computer system with statistics compiled from previous queries in order to estimate the system response time. In particular, an estimated CPU time for executing the present query is derived by extrapolating actual CPU times recorded for past queries having the closest estimated costs for accessing the same, or similar, tables and items in the database, using a form of a "nearest neighbor" algorithm to match the present query to either identical or statistically closest past queries.
    Type: Grant
    Filed: October 31, 1997
    Date of Patent: February 15, 2000
    Assignee: Oracle Corporation
    Inventors: Andrew P. Osborn, Paolo Fragapane
  • Summary table query routing
    Patent number: 6023696
    Abstract: Methods and apparatus for effective and efficient usage of summary tables in a computer system including a database. In a computer system it is common for a database to include one or more summary tables which have pre-generated aggregations of data from one or more original, detailed database tables. In order to achieve the benefits of summary tables, they must be accessed when appropriate. Thus, information regarding the available summary database tables, including summary bitmaps for all the summary tables, is maintained in the metadata of a computer system. This information is updated whenever a summary table is created. The summary bitmaps are a main key for determining if any summary table is responsive to a user query to the computer system. The summary bitmaps map to corresponding SQL statements, which are generated to access the respective summary tables in the database.
    Type: Grant
    Filed: October 31, 1997
    Date of Patent: February 8, 2000
    Assignee: Oracle Corporation
    Inventors: Andrew P. Osborn, Robert L. Lavender, Stephen D. Cave, Paolo Fragapane
  • Summary table management in a computer system
    Patent number: 6023695
    Abstract: A self monitoring system that identifies optimum summary table(s) for use by a database management system, and that automatically creates or deletes summary tables based on selected summary table recommendations.
    Type: Grant
    Filed: October 31, 1997
    Date of Patent: February 8, 2000
    Assignee: Oracle Corporation
    Inventors: Andrew P. Osborn, Robert L. Lavender, Stephen D. Cave