Patents by Inventor Edward P. Haslam

Edward P. Haslam 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.
  • Server integrated system and methods for processing precomputed views
    Patent number: 6594653
    Abstract: Server-integrated methods and apparatus for processing precomputed views for answering user queries on a database are described. In accordance with one embodiment, a system for answering user queries on a database stored on a server includes a query processing system integrated into the server and configured to respond to user queries, and a query processing system integrated into the server and configured to process precomputed results of user queries on the database. In another aspect, a method of answering user queries on a database stored on a server includes responding to user queries received at the server, and processing, at the server, precomputed results of user queries on the database.
    Type: Grant
    Filed: March 25, 1999
    Date of Patent: July 15, 2003
    Assignee: International Business Machines Corporation
    Inventors: Latha S. Colby, Richard L. Cole, Edward P. Haslam, Nasi Jazayeri, Galt Johnson, William J. McKenna, David G. Wilhite, Jr.
  • Defining and characterizing an analysis space for precomputed views
    Patent number: 6493699
    Abstract: Methods and apparatus for processing precomputed views for answering user queries on a database are described. In accordance with one aspect, a user database query on precomputation strategy effectiveness is responded to by defining, based upon user database query history, an analysis space consisting of a subset of all possible views for the database, and by characterizing the views in the analysis space. In accordance with a second aspect, a structure is imposed on an analysis space consisting of a subset of all possible views for the database based upon the capabilities of a query rewriting facility, and the views in the analysis space are characterized. In accordance with a third aspect, an analysis space consisting of a subset of all possible views for the database is defined, and a cost formula is applied to the analysis space based upon a user-defined subset of the data contained in the database.
    Type: Grant
    Filed: March 25, 1999
    Date of Patent: December 10, 2002
    Assignee: International Business Machines Corporation
    Inventors: Latha S. Colby, Richard L. Cole, Edward P Haslam, Nasi Jazayeri, Galt Johnson, William J. McKenna, David G. Wilhite, Jr.
  • System and method for determining and generating candidate views for a database
    Patent number: 6480836
    Abstract: The invention features methods and apparatus for processing precomputed views for answering user queries on a database. In accordance with one aspect, a user query on the database is analyzed, and a candidate view based upon the user query is generated.
    Type: Grant
    Filed: March 25, 1999
    Date of Patent: November 12, 2002
    Assignee: International Business Machines Corporation
    Inventors: Latha S. Colby, Richard L. Cole, Edward P. Haslam, Nasi Jazayeri, Galt Johnson, William J. McKenna, David G. Wilhite, Jr.
  • SERVER INTEGRATED SYSTEMS AND METHODS FOR PROCESSING PRECOMPUTED VIEWS
    Publication number: 20020077997
    Abstract: Server-integrated methods and apparatus for processing precomputed views for answering user queries on a database are described. In accordance with one embodiment, a system for answering user queries on a database stored on a server includes a query processing system integrated into the server and configured to respond to user queries, and a query processing system integrated into the server and configured to process precomputed results of user queries on the database. In another aspect, a method of answering user queries on a database stored on a server includes responding to user queries received at the server, and processing, at the server, precomputed results of user queries on the database.
    Type: Application
    Filed: March 25, 1999
    Publication date: June 20, 2002
    Applicant: Informix Software, Inc., a California corporation
    Inventors: LATHA S. COLBY, RICHARD L. COLE, EDWARD P. HASLAM, NASI JAZAYERI, GALT JOHNSON, WILLIAM J. MCKENNA, DAVID G. WILHITE JR.
  • DEFINING AND CHARACTERIZING AN ANALYSIS SPACE FOR PRECOMPUTED VIEWS
    Publication number: 20010013030
    Abstract: Methods and apparatus for processing precomputed views for answering user queries on a database are described. In accordance with one aspect, a user database query on precomputation strategy effectiveness is responded to by defining, based upon user database query history, an analysis space consisting of a subset of all possible views for the database, and by characterizing the views in the analysis space. In accordance with a second aspect, a structure is imposed on an analysis space consisting of a subset of all possible views for the database based upon the capabilities of a query rewriting facility, and the views in the analysis space are characterized. In accordance with a third aspect, an analysis space consisting of a subset of all possible views for the database is defined, and a cost formula is applied to the analysis space based upon a user-defined subset of the data contained in the database.
    Type: Application
    Filed: March 25, 1999
    Publication date: August 9, 2001
    Applicant: INFORMIX SOFTWARE, INC.
    Inventors: LATHA S. COLBY, RICHARD L. COLE, EDWARD P. HASLAM, NASI JAZAYERI, GALT JOHNSON, WILLIAM J. MCKENNA, DAVID G. WILHITE
  • 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.