DATABASE MANAGEMENT SYSTEM, COMPUTER, AND DATABASE MANAGEMENT METHOD

摘要

A database management system (DBMS) generates a query execution plan including information representing one or more database (DB) operations necessary for executing a query and executes the query based on the query execution plan. In the execution of the query, the DBMS dynamically generates a task for executing a DB operation and executes the dynamically generated task. The DBMS executes a task in a plurality of threads executed by a processor core.

主权项

1. A database management system for being realized by a computer including a processor core and for managing a database, comprising:
a query reception unit being configured to receive a query to the database; a query execution plan generation unit being configured to generate a query execution plan including information representing a processing step necessary for executing the received query and an execution procedure of the processing step; and a query execution unit being configured to execute the received query based on the generated query execution plan, in an execution of the accepted query, dynamically generate a task for executing a processing step and execute the dynamically generated task, the query execution unit being configured to
execute a task in a plurality of threads executed by a processor core in an execution of the received query,execute a plurality of tasks in one thread executed by the processor core, andwhen newly generating a task, generate a context and execute the generated task based on the generated context, and the context being information including first information showing a processing step for starting an execution in the newly generated task is which of one or more processing steps represented by the query execution plan, second information relating to an access destination for data required in a processing step shown by the first information, and third information relating to data necessary for generating a result by the newly generated task.