Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and device for database traversal

A database and traversal technology, applied in the field of database traversal

Active Publication Date: 2021-01-01
ALIBABA (CHINA) CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] An object of this application is to provide a method and device for database traversal to solve the problem of controlling IOPS resources during the traversal process

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
  • A method and device for database traversal
  • A method and device for database traversal
  • A method and device for database traversal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The present application will be described in further detail below with reference to the accompanying drawings.

[0029] In a typical configuration of the present application, the terminal, the device serving the network, and the trusted party each include one or more processors (CPUs), input / output interfaces, network interfaces, and memory.

[0030] Memory may include non-persistent memory in computer readable media, random access memory (RAM) and / or non-volatile memory in the form of, for example, read only memory (ROM) or flash memory (flashRAM). Memory is an example of a computer-readable medium.

[0031] Computer-readable media includes both persistent and non-permanent, removable and non-removable media, and storage of information may be implemented by any method or technology. Information may be computer readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change me...

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 application aims to provide a method and devices used for database traversal. Compared with the prior art, the method and devices firstly acquire a target index corresponding to a to-be-traversed data table in a database, wherein an IOPS (Input / Output Operations Per Second) is smallest when traversal is carried out through the target index; and then carry out a block traversal operation on each data block in the data table on the basis of the target index to achieve a purpose of precisely controlling the IOPS through determining block size information of the next data block in the data table in a process of traversing the data table, and improve the user experience. In addition, the method and devices end the traversal operation of the data table when the current data block is the last block in the data table, thus avoid entering dead circulation of traversal, and improve the security.

Description

technical field [0001] The present application relates to the field of computers, and in particular, to a technology for database traversal. Background technique [0002] In the cloud database scenario, the database instances of multiple users will occupy different resources such as memory, CPU, and IOPS (Input / Output Operations Per Second, the number of read and write operations per second, indicating the frequency of accessing the disk), and sometimes it is necessary to traverse A typical example of user data is to traverse user data in the MySQL database scenario to check whether there is data inconsistency between the primary database of the user instance and its various standby databases. If users traverse their own data, of course, within the limits of the resources they purchased, there will be no additional restrictions to ensure that users can use their own resources; but if cloud computing providers want to traverse user data, they must Limit access, for example, ...

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 Patents(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/22
CPCG06F16/2228G06F16/2433G06F16/24553
Inventor 刘良友张远赵建伟彭立勋田英鹤
Owner ALIBABA (CHINA) CO LTD