Invention Grant
- Patent Title: Performing database operations using a vectorized approach or a non-vectorized approach
-
Application No.: US15684943Application Date: 2017-08-24
-
Publication No.: US10671583B2Publication Date: 2020-06-02
- Inventor: Rajkumar Sen , Sam Idicula , Nipun Agarwal
- 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
- Agent Daniel D. Ledesma
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/22 ; G06F16/2453 ; G06F9/30

Abstract:
Techniques for performing database operations using vectorized instructions are provided. In one technique, it is determined whether to perform a database operation using one or more vectorized instructions or without using any vectorized instructions. This determination may comprise estimating a first cost of performing the database operation using one or more vectorized instructions and estimating a second cost of performing the database operation without using any vectorized instructions. Multiple factors that may be used to determine which approach to follow, such as the number of data elements that may fit into a SIMD register, a number of vectorized instructions in the vectorized approach, a number of data movement instructions that involve moving data from a SIMD register to a non-SIMD register and/or vice versa, a size of a cache, and a projected size of a hash table.
Public/Granted literature
- US20170351670A1 PERFORMING DATABASE OPERATIONS USING A VECTORIZED APPROACH OR A NON-VECTORIZED APPROACH Public/Granted day:2017-12-07
Information query