DATABASE MANAGEMENT SYSTEM AND COMPUTER SYSTEM
First Claim
1. A database management system for managing a database, comprising:
- a query reception part configured to receive a query to the database from a query issuance source;
a query execution plan creation part configured to create a query execution plan that includes information indicating one or more database operations that are required for an execution of the received query and an execution procedure of the one or more database operations based on the received query;
a first query execution part configured to execute the query by executing database operations based on the created query execution plan and to return an execution result of the query to the query issuance source;
a second query execution part configured to execute the query by executing database operations based on the created query execution plan; and
a buffer management part configured to read data of a read request from the database to store the data into the buffer and to provide the data of the read request to a query execution part of a issuance source of the read request of the first and second query execution parts if the data of the read request has not been stored in a buffer in the case where the read request of data is received from any one of the first and second query execution parts,the buffer management part being configured to read the data of the read request from the buffer and to provide the data to the first query execution part in the case where the issuance source of the read request is the first query execution part and the data of the read request has been stored in the buffer by being requested to be read from the second query execution part.
1 Assignment
0 Petitions
Accused Products
Abstract
A second query execution part is added to a database management system comprising a first query execution part configured to execute a query based on a query execution plan of a query to a database and to return a query execution result to the query issuance source and a buffer management part configured to read a data of a read request from the database to store the data into the buffer and to provide the data to an issuance source of the read request if data of a read request has not been stored in a buffer in the case where the read request of data is received and configured to read data of a read request from the buffer and to provide the data to a issuance source of the read request if data of a read request has been stored in the buffer.
22 Citations
19 Claims
-
1. A database management system for managing a database, comprising:
-
a query reception part configured to receive a query to the database from a query issuance source; a query execution plan creation part configured to create a query execution plan that includes information indicating one or more database operations that are required for an execution of the received query and an execution procedure of the one or more database operations based on the received query; a first query execution part configured to execute the query by executing database operations based on the created query execution plan and to return an execution result of the query to the query issuance source; a second query execution part configured to execute the query by executing database operations based on the created query execution plan; and a buffer management part configured to read data of a read request from the database to store the data into the buffer and to provide the data of the read request to a query execution part of a issuance source of the read request of the first and second query execution parts if the data of the read request has not been stored in a buffer in the case where the read request of data is received from any one of the first and second query execution parts, the buffer management part being configured to read the data of the read request from the buffer and to provide the data to the first query execution part in the case where the issuance source of the read request is the first query execution part and the data of the read request has been stored in the buffer by being requested to be read from the second query execution part. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer system for managing a database, comprising:
-
a processor; and a buffer, the processor being configured to; receive a query to the database from a query issuance source; create a query execution plan that includes information indicating one or more database operations that are required for an execution of the received query and an execution procedure of the one or more database operations based on the received query; execute a first query execution procedure for executing the query by executing database operations based on the created query execution plan; execute a second query execution procedure for executing the query by executing database operations based on the created query execution plan; read the required data from the database to store the data into the buffer and use the required data in the query execution procedure that requires the required data for the first and second query executions in the case where data required for any one of the first query execution and the second query execution has not been stored in a buffer; read the required data from the buffer and use the data in the first query execution procedure in the case where the query execution procedure that requires the required data is the first query execution procedure and the required data has been stored in the buffer by being required in the second query execution procedure; and return a query execution result by the first query execution procedure of the first and second query executions to the query issuance source.
-
-
18. A database management method for managing a database, comprising:
-
receiving a query to the database from a query issuance source; creating a query execution plan that includes information indicating one or more database operations that are required for an execution of the received query and an execution procedure of the one or more database operations based on the received query; executing a first query execution procedure for executing the query by executing database operations based on the created query execution plan; executing a second query execution procedure for executing the query by executing database operations based on the created query execution plan; reading the required data from the database to store the data into the buffer and use the required data in the query execution procedure that requires the required data for the first and second query executions in the case where data required for any one of the first query execution and the second query execution has not been stored in a buffer; reading the required data from the buffer and using the data in the first query execution procedure in the case where the query execution procedure that requires the required data is the first query execution procedure and the required data has been stored in the buffer by being required in the second query execution procedure; and returning a query execution result by the first query execution procedure of the first and second query executions to the query issuance source.
-
-
19. A computer program for supporting a database management system that configures:
-
a query reception part configured to receive a query to the database from a query issuance source; a query execution plan creation part configured to create a query execution plan that includes information indicating one or more database operations that are required for an execution of the received query and an execution procedure of the one or more database operations based on the received query; a first query execution part configured to execute a first query execution procedure for executing the query by executing database operations based on the created query execution plan and to return a query execution result by the first query execution procedure to the query issuance source; and a buffer management part configured to read a data of a read request from the database to store the data into the buffer and to provide the data to an issuance source of the read request if data of a read request has not been stored in the buffer in the case where the read request of data is received and configured to read data of a read request from the buffer and to provide the data to a issuance source of the read request if data of a read request has been stored in the buffer, for a computer in the case where the computer program is executed by the computer, the computer program being configured to cause the computer to; execute a second query execution procedure for executing the query by executing database operations based on the created query execution plan; and issue a read request of required data to the buffer management part in the second query execution procedure.
-
Specification