Patents by Inventor Binghua Zhen

Binghua Zhen 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 for executing a query having multiple distinct key columns
    Patent number: 8041726
    Abstract: A system and computer readable medium for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The system and computer readable medium includes a capture module for identifying each of the plurality of DISTINCT keys in the query and a sort module coupled to the capture module for determining if more than one sort is needed to execute the query, performing a first DISTINCT operation on a first DISTINCT key of the plurality of DISTINCT keys, storing data fetched from the first DISTINCT operation in a master workfile only if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations on the other of the plurality of DISTINCT keys.
    Type: Grant
    Filed: September 17, 2008
    Date of Patent: October 18, 2011
    Assignee: International Business Machines Corporation
    Inventors: Yao-Ching Chen, You-Chin Fuh, Allan B. Lebovitz, Li-Mey Lee, Fen-Ling Lin, Lee-Chin Hsu Liu, Yun Wang, Binghua Zhen
  • System and article of manufacture for efficient evaluation of index screening predicates
    Patent number: 7979440
    Abstract: Techniques are provided for processing a query using an index. It is determined whether a number of consecutive keys that evaluate to a false-positive when applying a screening predicate in the query exceeds a false-positive predefined value. One or more keys in the index are skipped in response to determining that the number of consecutive keys exceeds the false-positive predefined value.
    Type: Grant
    Filed: November 21, 2008
    Date of Patent: July 12, 2011
    Assignee: International Business Machines Corporation
    Inventors: You-Chin Fuh, Ping Wang, Li Xia, Binghua Zhen
  • SYSTEM AND ARTICLE OF MANUFACTURE FOR EFFICIENT EVALUATION OF INDEX SCREENING PREDICATES
    Publication number: 20090083233
    Abstract: Techniques are provided for processing a query using an index. It is determined whether a number of consecutive keys that evaluate to a false-positive when applying a screening predicate in the query exceeds a false-positive predefined value. One or more keys in the index are skipped in response to determining that the number of consecutive keys exceeds the false-positive predefined value.
    Type: Application
    Filed: November 21, 2008
    Publication date: March 26, 2009
    Applicant: International Business Machines Corporation
    Inventors: You-Chin Fuh, Ping Wang, Li Xia, Binghua Zhen
  • Method for executing a query having multiple distinct key columns
    Patent number: 7487140
    Abstract: A method for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method of the present invention includes providing a first DISTINCT operation on a first DISTINCT key, storing data fetched from the first DISTINCT operation in a master workfile if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations for the other DISTINCT keys.
    Type: Grant
    Filed: December 17, 2002
    Date of Patent: February 3, 2009
    Assignee: International Business Machines Corporation
    Inventors: Yao-Ching Chen, You-Chin Fuh, Allan B. Lebovitz, Li-Mey Lee, Fen-Ling Lin, Lee-Chin Hsu Liu, Yun Wang, Binghua Zhen
  • Method for efficient evaluation of index screening predicates
    Patent number: 7480649
    Abstract: Techniques are provided for processing a query using an index. It is determined whether a number of consecutive keys that evaluate to a false-positive when applying a screening predicate in the query exceeds a false-positive predefined value. One or more keys in the index are skipped in response to determining that the number of consecutive keys exceeds the false-positive predefined value.
    Type: Grant
    Filed: July 6, 2005
    Date of Patent: January 20, 2009
    Assignee: International Business Machines Corporation
    Inventors: You-Chin Fuh, Ping Wang, Li Xia, Binghua Zhen
  • SYSTEM FOR EXECUTING A QUERY HAVING MULTIPLE DISTINCT KEY COLUMNS
    Publication number: 20090012945
    Abstract: A system and computer readable medium for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The system and computer readable medium includes a capture module for identifying each of the plurality of DISTINCT keys in the query and a sort module coupled to the capture module for determining if more than one sort is needed to execute the query, performing a first DISTINCT operation on a first DISTINCT key of the plurality of DISTINCT keys, storing data fetched from the first DISTINCT operation in a master workfile only if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations on the other of the plurality of DISTINCT keys.
    Type: Application
    Filed: September 17, 2008
    Publication date: January 8, 2009
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Yao-Ching Chen, You-Chin Fuh, Allan B. Lebovitz, Li-Mey Lee, Fen-Ling Lin, Lee-Chin Hsu Liu, Yun Wang, Binghua Zhen
  • Efficient evaluation of index screening predicates
    Publication number: 20070011143
    Abstract: Techniques are provided for processing a query using an index. It is determined whether a number of consecutive keys that evaluate to a false-positive when applying a screening predicate in the query exceeds a false-positive predefined value. One or more keys in the index are skipped in response to determining that the number of consecutive keys exceeds the false-positive predefined value.
    Type: Application
    Filed: July 6, 2005
    Publication date: January 11, 2007
    Inventors: You-Chin Fuh, Ping Wang, Li Xia, Binghua Zhen
  • Method and system for executing a query having multiple distinct key columns
    Publication number: 20040117356
    Abstract: A method and system for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method and system of the present invention includes providing a first DISTINCT operation on a first DISTINCT key, storing data fetched from the first DISTINCT operation in a master workfile if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations for the other DISTINCT keys.
    Type: Application
    Filed: December 17, 2002
    Publication date: June 17, 2004
    Inventors: Yao-Ching Chen, You-Chin Fuh, Allan B. Lebovitz, Li-Mey Lee, Fen-Ling Lin, Lee-Chin Hsu Liu, Yun Wang, Binghua Zhen