Conflict processing method for invalid index item mark, storage medium and computer device

By automatically adjusting the probability of attempting to mark invalid index entries for index objects, the problem of inaccurate marking caused by changes in the physical organization of index pages is solved, reducing manual costs and improving the concurrency and throughput of the database system.

CN116483846BActive Publication Date: 2026-06-16CETC JINCANG (BEIJING) TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
CETC JINCANG (BEIJING) TECH CO LTD
Filing Date
2023-04-12
Publication Date
2026-06-16

AI Technical Summary

⚠Technical Problem

In existing technologies, changes in the physical organization of index pages lead to inaccurate marking of invalid index entries, affecting the concurrency and throughput of the database system. Furthermore, manually adjusting index objects to attempt to mark invalid index entries is costly and time-consuming.

⚗Method used

By automatically adjusting the probability of attempting to mark invalid index entries for index objects based on statistical information and preset rules, manual costs are reduced and the timeliness of modifications are improved. This includes obtaining statistical information within a set time period, determining whether the top SQL queries meet preset conditions, and modifying the probability of attempting to mark invalid index entries for index objects according to preset rules.

🎯Benefits of technology

It enables automatic adjustment of the probability of attempting to mark invalid index entries in index objects without human intervention, reducing modification costs and improving the timeliness of modifications, reducing database system overhead, and improving concurrency and throughput.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116483846B_ABST
    Figure CN116483846B_ABST
Patent Text Reader

Abstract

The application provides a conflict processing method for invalid index item marking, a storage medium and a computer device, and the method comprises the following steps: acquiring statistical information in a set time period, and judging whether top sql in the statistical information meets a preset condition, wherein the preset condition at least comprises index scanning; acquiring statistical information in a set time period, and judging whether top sql in the statistical information meets a preset condition, wherein the preset condition at least comprises index scanning; if yes, modifying the probability of an index object involved in the top sql to attempt to mark an invalid index item according to a preset rule. The technical scheme of the application can improve the timeliness of modifying the probability of the index object to attempt to mark the invalid index item, and reduce the artificial cost of modification.
Need to check novelty before this filing date? Find Prior Art