Invention Grant
- Patent Title: Method and apparatus for performing multi-table merge operations in a database environment
- Patent Title (中): 在数据库环境中执行多表合并操作的方法和装置
-
Application No.: US10447862Application Date: 2003-05-28
-
Publication No.: US07899784B2Publication Date: 2011-03-01
- Inventor: Richard Yu Gu , Harmeek Singh Bedi , Ashish Thusoo
- Applicant: Richard Yu Gu , Harmeek Singh Bedi , Ashish Thusoo
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong & Becker LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00
Abstract:
A method for performing multiple merge operations with a source data structure and a plurality of destination data structures, in which the source data structure is scanned one time in order to obtain source data that is then used for multiple merge operations. The source data is then used consecutively in order to merge the source data into the one or more destination data structures. Each merge is performed using the same scan of the source data structure and within the same execution of a database command.
Public/Granted literature
- US20040243550A1 Method and apparatus for performing multi-table merge operations in a database environment Public/Granted day:2004-12-02
Information query
