Patents by Inventor Dallas L. Johnson

Dallas L. Johnson 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, system and program product for rewriting view statements in structured query language (SQL) statements
    Patent number: 7711692
    Abstract: Under the present invention, when a SQL statement having a full select portion that references a view containing a join operation (e.g., a LOJ operation) is received, the reference to the view will be moved out of the full select portion. Once moved, the view and its join operation will be resolved separately from the SQL statement. The results of this resolution will be placed in a temporary table. A reference to the temporary table is then inserted in the full select portion, and the SQL statement is thereafter performed.
    Type: Grant
    Filed: November 12, 2004
    Date of Patent: May 4, 2010
    Assignee: International Business Machines Corporation
    Inventors: Roy Froehlich, Dallas L. Johnson, Charles F. Matula