Invention Grant
- Patent Title: Asynchronous index loading for database computing system startup latency managment
-
Application No.: US14853569Application Date: 2015-09-14
-
Publication No.: US10740311B2Publication Date: 2020-08-11
- Inventor: Jaeyun Noh , Hyeong Seog Kim
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/22 ; G06F16/23 ; G06F16/2455

Abstract:
A system, computer-implemented method, and computer-program product embodiments for rebuilding database indexes is disclosed. A pre-loader thread rebuilds a plurality of indexes in the background once a database is initialized. Simultaneously, a query processor receives queries from a user/client of a database. If an index that is required by the query processor has not yet been rebuilt by the pre-loader, a request to rebuild the index is sent to an asynchronous index loader. The asynchronous index loader places the request in a queue, processes the queue based on available system resources, and then rebuilds the requested indexes. Once the necessary indexes have been rebuilt, a wake-up signal is sent to the query processor which then proceeds to execute the query from a user/client.
Public/Granted literature
- US20170075936A1 ASYNCHRONOUS INDEX LOADING FOR DATABASE COMPUTING SYSTEM STARTUP LATENCY MANAGMENT Public/Granted day:2017-03-16
Information query