Patents by Inventor Lee E. Schumacher

Lee E. Schumacher 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).

  • System and method for rewriting relational database queries
    Patent number: 6629094
    Abstract: A system and method for answering a relational database query is presented. According to an embodiment of the present invention, a database query is received. It is then determined whether that query can be rewritten in such a manner as to be able to utilize a precomputed view, such that an answer to the rewritten query is equivalent to an answer to the original query. If the query can be rewritten, it is determined whether the rewritten query can more efficiently derive the answer than the original query. The query which has the most efficiently derived answer is the query which is utilized to derive that answer.
    Type: Grant
    Filed: September 1, 2000
    Date of Patent: September 30, 2003
    Assignee: International Business Machines Corporation
    Inventors: Latha S. Colby, Richard L. Cole, Edward P. Haslam, Nasi Jazayeri, Galt Johnson, William McKenna, Lee E. Schumacher, David G. Wilhite, Jr.
  • System and method for rewriting relational database queries
    Patent number: 6199063
    Abstract: A system and method for answering a relational database query is presented. According to an embodiment of the present invention, a database query is received. It is then determined whether that query can be rewritten in such a manner as to be able to utilize a precomputed view, such that an answer to the rewritten query is equivalent to an answer to the original query. If the query can be rewritten, it is determined whether the rewritten query can more efficiently derive the answer than the original query. The query which has the most efficiently derived answer is the query which is utilized to derive that answer.
    Type: Grant
    Filed: March 27, 1998
    Date of Patent: March 6, 2001
    Assignee: Red Brick Systems, Inc.
    Inventors: Latha S. Colby, Richard L. Cole, Edward P. Haslam, Nasi Jazayeri, Galt Johnson, William J. McKenna, Lee E. Schumacher, David G. Wilhite, Jr.