Database management system, related device, method and medium

Abstract

The invention provides a database management system, a related device, a method and a medium. The database management system comprises a search space exploration unit used for analyzing semantics and grammar of a current query statement according to a first scheduling request to generate a plurality of first candidate query plans; the metadata management unit is used for obtaining the use condition of the computing resources and first data reaching the database in the related data queried by the current query statement according to the second scheduling request at the prediction execution moment; the rule unit is used for generating a second candidate query plan based on expansion of the plurality of first candidate query plans according to the first data; and the query optimization unit is used for selecting a target query plan from the plurality of first candidate query plans and the plurality of second candidate query plans based on the execution cost under the condition that the execution time is predicted and the computing resources are sufficient, and the database is queried by executing the target query plan. The database query efficiency and the computing resource utilization rate are improved.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and more specifically, to a database management system, related devices, methods and media. Background technique [0002] The development of database technology provides more and more data storage capacity, and users can query massive data storage and obtain the required data through the network and other methods. With the increasing amount of data storage, users have more and more complex query requirements for data in the database, and it is often necessary to continuously query the query results of specific events that meet a certain range of conditions (for example, time range). In the database continuous query scenario, the client can continuously send multiple query statements to the database management server, and the database management server can generate a corresponding query plan according to each query statement, execute the query plan to query the database, access the data...

AI Technical Summary

Problems solved by technology

The query plan generated according to each query statement is usually fixed, but the relevant data queried by the query statement gradually arrives at the database over time, and the computing resource usage of the database management server also changes over time, resulting in the occurrence of database management server execution Inefficient query plans and / or insufficient computing power, which reduces the efficiency of database queries and reduces the utilization of computing resources for database queries

Images