Invention Grant
- Patent Title: Leveraging SQL with user defined aggregation to efficiently merge inverted indexes stored as tables
-
Application No.: US15281746Application Date: 2016-09-30
-
Publication No.: US10528538B2Publication Date: 2020-01-07
- Inventor: Zhen Hua Liu , Aleksandra Czarlinska , Douglas James McMahon , Asha Makur
- Applicant: Oracle International Corporation
- 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 Becker Bingham LLP
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/23 ; G06F16/31 ; G06F16/2455
Abstract:
Techniques are described herein for using user-defined aggregate functions for updating inverted index tables. A user-defined aggregate function is registered in a database system for updating an index table based on changes stored in a staging table. A query specifying the user-defined aggregate function may be executed in parallel to parallelize the updating of the index table.
Public/Granted literature
- US20180096007A1 LEVERAGING SQL WITH USER DEFINED AGGREGATION TO EFFICIENTLY MERGE INVERTED INDEXES STORED AS TABLES Public/Granted day:2018-04-05
Information query
