Patents by Inventor Stephen Cave

Stephen 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).

  • Structured query language table merging
    Patent number: 7725457
    Abstract: A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.
    Type: Grant
    Filed: December 19, 2003
    Date of Patent: May 25, 2010
    Assignee: Oracle International Corporation
    Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, Andrew Osborn
  • SQL predicate migration
    Patent number: 7370062
    Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is disclosed. The method includes determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement may then be produced that only refers to the detail table using the identifier to the rows of the detail table. Subsequently, the revised SQL statement is processed.
    Type: Grant
    Filed: September 30, 2003
    Date of Patent: May 6, 2008
    Assignee: Oracle International Corporation
    Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, James Steadman, Andrew Osborn, Kathryn Nash
  • Data processing method
    Publication number: 20070028158
    Abstract: A process definition method is disclosed. The method is typically for use with a report compiled from source data stored in a database and displayed to a user as a table having a plurality of cells. The method comprises: a) presenting the table of cells to the user; b) selecting one of the plurality of cells; and c) defining a drill out function associated with that cell.
    Type: Application
    Filed: August 1, 2005
    Publication date: February 1, 2007
    Inventors: Dragan Djorovich, Matthew Jakubiak, Suresh Kannan, Brahmesh Puttannaiah, Natascha Kearsey, Chris Evans, Stephen Cave
  • Structured query language table merging
    Publication number: 20050076007
    Abstract: A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is described. The method comprises: a) presenting the SQL statement to the database; b) identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria; and c) for each identified join, modifying the SQL statement so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.
    Type: Application
    Filed: December 19, 2003
    Publication date: April 7, 2005
    Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, Andrew Osborn
  • SQL predicate migration
    Publication number: 20040220928
    Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is described.
    Type: Application
    Filed: September 30, 2003
    Publication date: November 4, 2004
    Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, James Steadman, Andrew Osborn, Kathryn Nash
  • SQL join elimination
    Publication number: 20040220917
    Abstract: A method of preventing execution of unnecessary joins between tables in a database is described.
    Type: Application
    Filed: September 30, 2003
    Publication date: November 4, 2004
    Inventors: Christopher Evans, Paolo Fragapane, Stephen Cave, James Steadman, Andrew Osborn, Kathryn Nash