Beijing Oceanbase Technology Co., Ltd.

Ant Financial Network Technology Co., Ltd.

Zhiyong Jiang

Zhenkun Yang

Yang Li

Yi Pan

Yingying Yao

Yi Xiao

The present specification describes an adaptive resource allocation method and apparatus. One example method includes determining a request time, an execution time, and a response time corresponding to a service statement executed by the database system during a time period, wherein the request time is a time at which the service statement was executed by the database system, the execution time is an amount of time allocated for execution of the service statement by the database system, and the response time is an amount of time that elapsed between the request time and a time at which execution of the service statement ended; identifying a time segment of the time period based on the request time; determining a service type associated with the service statement; and updating a resource quota for the time segment based on the service type, the execution time, and the response time for the service statement.

Adaptive resource allocation method and apparatus

Embodiments described herein provide a system for facilitating efficient indexing in a database. The system can maintain a data table in the database. The data table includes a first column for structured data and a second column for unstructured text. A row of the data table can include a first piece of data in the first column and a second piece of data in the second column. During operation, the system performs word segmentation on the second piece of data to generate a first set of semantically meaningful word segments. The system then generates a set of index entries that corresponds to the row. A respective index entry includes an index generated from the first piece of data and a corresponding word segment of the first set of semantically meaningful word segments.

System and method for facilitating efficient indexing in a database system

A database query optimization computer-implemented method, medium, and system are disclosed. In one computer-implemented method, a data query request sent by a client device is received and parsed. An execution plan for executing the data query request is determined based on a parsing result. If the execution plan is a nested loop anti-join, whether there is a possibility that a to-be-queried field in a to-be-queried data table indicated by the data query request contains a NULL value is determined. If there is a possibility that the to-be-queried field contains a NULL value, a filter condition is generated and the execution plan is optimized based on the filter condition.

Growing community of inventors

Hangzhou, China

Zhiyong Jiang