Patents by Inventor Richard Y. Gu

Richard Y. Gu 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).

  • Merge delete statement for database operations
    Patent number: 6829600
    Abstract: Conditional functionality is provided for database merge operations. A merge operation, for merging data from a source to a destination, involves performing a default operation for each source record. Default operations associated with a MERGE statement include UPDATE and INSERT operations. Which default operation is performed depends on whether any destination record corresponds to a given source record. In an embodiment, whether a specified condition is satisfied is determined. If the condition is satisfied, then the default operation that is appropriate for a given source record is performed. If the condition is not satisfied, then the given source record is processed without performing the appropriate default operation. In one aspect, the UPDATE clause of the MERGE statement is extended to include a conditional DELETE clause.
    Type: Grant
    Filed: April 3, 2003
    Date of Patent: December 7, 2004
    Assignee: Oracle International Corporation
    Inventors: Richard Y. Gu, Harmeek S. Bedi, Ashish Thusoo
  • Merge delete statement for database operations
    Publication number: 20040199519
    Abstract: Conditional functionality is provided for database merge operations. A merge operation, for merging data from a source to a destination, involves performing a default operation for each source record. Default operations associated with a MERGE statement include UPDATE and INSERT operations. Which default operation is performed depends on whether any destination record corresponds to a given source record. In an embodiment, whether a specified condition is satisfied is determined. If the condition is satisfied, then the default operation that is appropriate for a given source record is performed. If the condition is not satisfied, then the given source record is processed without performing the appropriate default operation. In one aspect, the UPDATE clause of the MERGE statement is extended to include a conditional DELETE clause.
    Type: Application
    Filed: April 3, 2003
    Publication date: October 7, 2004
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Richard Y. Gu, Harmeek S. Bedi, Ashish Thusoo