Access control method for database and related equipment

By pre-configuring query statement templates and current limiting rules with current limiting values, the database access control solves the problem of excessive database load pressure, achieves precise current limiting for specific business requests, and ensures database stability and user experience.

CN117556452AActive Publication Date: 2024-02-13ALIPAY (HANGZHOU) INFORMATION TECH CO LTD
15 Cites 3 Cited by

Patent Information

Application Number
CN202410039720.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-01-10
Publication Date
2024-02-13
Estimated Expiration
2044-01-10

AI Technical Summary

Technical Problem

During major promotions or high-frequency access, the database load pressure is too high, resulting in longer processing delays and possible machine downtime, seriously affecting the user experience. The existing current limiting mechanism rejects requests indiscriminately, affecting the normal operation of important businesses. implement.

Method used

Configure current limiting rules in advance, including query statement templates and current limiting values. The target query statement is processed through the template, and it is determined that it matches the current limiting rules and then precise current limiting processing is performed to avoid interference with other business requests.

Benefits of technology

It achieves precise current limiting for specific business requests, ensuring stable database operation and user experience, while not hindering the normal execution of other business requests.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The invention provides an access control method for a database and related equipment, at least one flow limiting rule is pre-configured for the database, and each flow limiting rule comprises a query statement template related to a preset flow limiting service and a corresponding flow limiting value. The method comprises the following steps: in response to a target access request for the database, performing template processing on a target query statement related to a target service contained in the target access request to obtain a target query statement template corresponding to the target query statement; determining whether the target query statement template is matched with a query statement template contained in at least one traffic limiting rule; and if yes, performing flow limiting processing on the target access request according to a flow limiting value corresponding to the query statement template contained in at least one flow limiting rule.
Need to check novelty before this filing date? Find Prior Art