Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data access control method and data access control device

A data access control and database technology, applied in the database field, can solve problems such as database performance decline, system pressure increase, and users' continuous retry, so as to reduce the loss of system resources and traffic, avoid performance degradation, and enhance user experience. Effect

Active Publication Date: 2015-10-14
ALIBABA GRP HLDG LTD
View PDF4 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] One purpose of this application is to provide an improved data access control scheme to solve the problem of performance degradation of the entire database due to overheating of some records
[0009] Another purpose of the present application is to provide an improved data access control scheme to solve the problems that the existing flow control mechanism causes users to retry continuously, the system pressure increases and the user experience is poor

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data access control method and data access control device
  • Data access control method and data access control device
  • Data access control method and data access control device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The inventors of the present application noticed that, as mentioned above, current general flow control solutions focus on solving overall system performance problems. For example, HSF flow control: When the application load is high, lower the HSF flow control threshold to reduce the overall flow of the system, which is a one-size-fits-all solution at the system level. Moreover, the current general flow control scheme is that when the requests at a certain moment exceed the threshold, the system will refuse to provide services for these requests. However, the sudden surge in system traffic is often only a momentary event (such as flash sales, especially Tmall Double 11 flash sales, which last for a short time). If the system directly rejects the request that exceeds the processing capacity, it may cause the user to retry continuously, which in turn increases the duration of the system's high pressure, and the user experience is also poor.

[0021] In fact, most of the ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a data access control method and a data access control device. The method comprises the following steps of: receiving an access request for a database, wherein the access request includes data object information; determining identification information of data records, which are referred by the access request, in the database on the basis of the data object information; determining an access request quantity corresponding to the identification information; and determining whether to refuse the request or not according to the access request quantity. The technical scheme according to the invention has the advantages that the access to the database can be controlled at the fine flow control granularity, i.e., the access control is performed for each record in the database, so that the problem of performance reduction of the whole database due to the overheat of partial records is avoided. The access request quantity on the database is operated and controlled by using a memory queuing mechanism and a waiting time-out mechanism; the direct-refuse and rigid-uniformity crude solving mode is avoided, so that the system resource and flow rate loss is reduced; the use by a user is convenient; and the user experience is enhanced.

Description

technical field [0001] This application relates to the field of databases, in particular to a data access control method and device. Background technique [0002] With the rapid development of Internet technology, business interaction on the Internet has become more and more common, followed by high-concurrency and large-volume access to the database. [0003] For example, during e-commerce promotions such as "Double 11" and "Double 12", the client application's access requests (read and write requests) to the server database will suddenly increase, especially for those best-selling products with high cost performance. The requests to operate related records in the database will increase instantly, which leads to row lock competition and waiting for a certain record on the database server. When the competition is very fierce, that is, when the concurrent modification of a certain database record is very high, the database performance will drop sharply, which will affect the...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F21/62
Inventor 罗军
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products