Patents by Inventor Stephen D. Cave

Stephen D. Cave 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
  • 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