公开(公告)号：US20170075936A1

公开(公告)日：2017-03-16

申请号：US14853569

申请日：2015-09-14

Applicant: SAP SE

Inventor： Jaeyun NOH ,  Hyeong Seog KIM

IPC: G06F17/30

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.

Abstract translation: 公开了一种用于重建数据库索引的系统，计算机实现的方法和计算机程序产品实施例。 数据库初始化后，预加载程序线程会在后台重建多个索引。 同时，查询处理器从数据库的用户/客户端接收查询。 如果预处理器尚未重建查询处理器所需的索引，则将重建索引的请求发送到异步索引加载器。 异步索引加载器将请求放入队列中，根据可用的系统资源处理队列，然后重建请求的索引。 一旦重建了必要的索引，就将唤醒信号发送给查询处理器，然后查询处理器继续执行来自用户/客户端的查询。