Patents by Inventor Claire Willey McFeely

Claire Willey McFeely 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 deploying an SQL procedure
    Patent number: 7711746
    Abstract: An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.
    Type: Grant
    Filed: December 17, 2005
    Date of Patent: May 4, 2010
    Assignee: International Business Machines Corporation
    Inventors: Margaret Ann Bernal, Yao-Ching Stephen Chen, Ding-Wei Chieh, Curt Lee Cotner, Baoqiu Cui, Tammie Dang, Marion B. Farber, Georgia Carroll Fuller, Joe Cheng-yu Huang, Hui-An Lee, Claire Willey McFeely, Chunfeng Pei, James Willis Pickel, Yumi Kimura Tsuji, Jay A. Yothers, Margaret Alice Zagelow, Liyan Zhou
  • Supporting multiple versions of a routine
    Patent number: 7580958
    Abstract: Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.
    Type: Grant
    Filed: June 17, 2005
    Date of Patent: August 25, 2009
    Assignee: International Business Machines Corporation
    Inventors: Yao-Ching Stephen Chen, Curt Lee Cotner, Baoqiu Cui, Tammie Dang, Joe Cheng-yu Huang, Claire Willey McFeely, Robert Thomas Miller, Manogari Nogi Simanjuntak, Yumi Kimura Tsuji, Xiaoyu Yang, Jay A. Yothers, Margaret Alice Zagelow
  • Method, system, and program for positioning a cursor on rows of a result table
    Patent number: 7231385
    Abstract: Provided are a method, system, and program for making data available to an application program. A cursor is generated positioned with respect to a result table, wherein the cursor specifies a search criteria, and wherein the result table includes rows from a base table that satisfy the search criteria. A fetch request is received indicating to position the cursor on a plurality of rows of the result table. The cursor is positioned on the plurality of rows of the result table indicated in the fetch request that satisfy the search criteria.
    Type: Grant
    Filed: July 21, 2003
    Date of Patent: June 12, 2007
    Assignee: International Business Machines Corporation
    Inventors: Margaret Ann Bernal, Christopher John Crone, Claire Willey McFeely, Kalpana Shyam, Julie Ann Watts
  • Method and system for dynamically changing cursor attributes in an embedded SQL application
    Patent number: 7136847
    Abstract: Aspects for dynamically changing attributes in an embedded-SQL application are described. In these aspects, an option is provided within a standard SQL statement for specifying one or more attributes of at least a declared cursor. The standard SQL statement is then processed to include the specified one or more attributes in at least the declared cursor. The provision occurs with an ATTRIBUTES option and within a PREPARE SQL statement.
    Type: Grant
    Filed: August 31, 2001
    Date of Patent: November 14, 2006
    Assignee: International Business Machines Corporation
    Inventors: Tammie Dang, William Robert Bireley, Curt Lee Cotner, Claire Willey McFeely, James Willis Pickel, Koichi Yamaguchi
  • Method and system for dynamically changing cursor attributes in an embedded SQL application
    Publication number: 20030055821
    Abstract: Aspects for dynamically changing attributes in an embedded-SQL application are described. In these aspects, an option is provided within a standard SQL statement for specifying one or more attributes of at least a declared cursor. The standard SQL statement is then processed to include the specified one or more attributes in at least the declared cursor. The provision occurs with an ATTRIBUTES option and within a PREPARE SQL statement.
    Type: Application
    Filed: August 31, 2001
    Publication date: March 20, 2003
    Inventors: Tammie Dang, William Robert Bireley, Curt Lee Cotner, Claire Willey McFeely, James Willis Pickel, Koichi Yamaguchi