Method and apparatus for hotspot data detection for database, and storage medium

An electronic device, comprising:

• at least one processor and a memory;
• wherein the memory stores computer-executable instructions;
• and
• the at least one processor executes the computer-executable instructions stored in the memory, to configure the at least one processor to:
• receive a database query instruction, and determine whether a target primary key of data to be queried exists in a real-time hotspot primary key set corresponding to a current time period;
• in response to the target primary not existing in the real-time hotspot primary key set, control, through a target cache, whether to add the target primary key to the real-time hotspot primary key set, wherein the target cache is a cache based on a least recently used algorithm;
• in response to the target primary key existing in the real-time hotspot primary key set, accumulate, in the real-time hotspot primary key set, a query frequency of the target primary key in the current time period;
• and
• determine, after the current time period ends, a hotspot primary key of the current time period based on the real-time hotspot primary key set, and output a query frequency of the hotspot primary key of the current time period in the current time period.

A non-transitory computer-readable storage medium, storing computer-executable instructions which, when executed by a processor, configure the processor to:

• receive a database query instruction, and determine whether a target primary key of data to be queried exists in a real-time hotspot primary key set corresponding to a current time period;
• in response to the target primary not existing in the real-time hotspot primary key set, control, through a target cache, whether to add the target primary key to the real-time hotspot primary key set, wherein the target cache is a cache based on a least recently used algorithm;
• in response to the target primary key existing in the real-time hotspot primary key set, accumulate, in the real-time hotspot primary key set, a query frequency of the target primary key in the current time period;
• and
• determine, after the current time period ends, a hotspot primary key of the current time period based on the real-time hotspot primary key set, and output a query frequency of the hotspot primary key of the current time period in the current time period.