Patents by Inventor Yumi Kimura Tsuji

Yumi Kimura Tsuji 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 optimizing the processing of queries involving set operators
    Patent number: 6792420
    Abstract: Provided is a method, system, and program for processing a query including a query operation on a table derived from a set operation on two result tables. The query operation is performed on each result table separately to produce two intermediate result tables. The set operator is then applied to the two intermediate result tables to produce a final result table that is a same result table that would have been produced by performing the query operation on the table derived from the set operation performed on the two result tables.
    Type: Grant
    Filed: June 29, 2001
    Date of Patent: September 14, 2004
    Assignee: International Business Machines Corporation
    Inventors: Yao Ching Stephen Chen, Yumi Kimura Tsuji, Yun Wang, Guogen Zhang
  • Method, system, and program for optimizing the processing of queries involving set operators
    Publication number: 20030055814
    Abstract: Provided is a method, system, and program for processing a query including a query operation on a table derived from a set operation on two result tables. The query operation is performed on each result table separately to produce two intermediate result tables. The set operator is then applied to the two intermediate result tables to produce a final result table that is a same result table that would have been produced by performing the query operation on the table derived from the set operation performed on the two result tables.
    Type: Application
    Filed: June 29, 2001
    Publication date: March 20, 2003
    Applicant: International Business Machines Corporation
    Inventors: Yao Ching Stephen Chen, Yumi Kimura Tsuji, Yun Wang, Guogen Zhang