Database-oriented request batch processing method and device, equipment and storage medium

A database and batch processing technology, applied in the direction of electrical digital data processing, special data processing applications, digital data information retrieval, etc., can solve problems such as inability to meet demand

Pending Publication Date: 2021-06-08
GUANGZHOU BAIGUOYUAN INFORMATION TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At the same time, as the volume of business requests increases, there is a significant delay in database processing requests. Simply sending multiple user requests to the database through one connection can no longer meet the demand. More and more business requests to the database urgently need to adopt a more reasonable The processing method optimizes the time consumption of database requests to reduce or eliminate the delay in request processing

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
  • Database-oriented request batch processing method and device, equipment and storage medium
  • Database-oriented request batch processing method and device, equipment and storage medium
  • Database-oriented request batch processing method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to further explain the technical means and effects of the present invention to achieve the intended purpose of the invention, the following, in conjunction with the accompanying drawings and preferred embodiments, will describe a batch processing method, device, equipment and The storage medium, its specific implementation, method, steps and effects are described in detail below.

[0024] Through the description of specific implementation modes, one can have a deeper and more specific understanding of the technical means and functional effects of the present invention to achieve the intended purpose, but the accompanying drawings are only for reference and description, and are not used to explain the present invention be restricted.

[0025] One aspect of the present invention provides a batch processing method for database-oriented requests, such as figure 1 shown, including the following steps:

[0026] Step S1: Receive one or more database-oriented request...

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 provides a database-oriented request batch processing method. The method comprises the following steps: receiving one or more database-oriented requests; setting a triggering condition of batch processing operation; and when a trigger condition is satisfied, performing merging processing on the request, wherein the merging processing being executed based on the operation type of the request. According to the database-oriented request batch processing method and device, the equipment and the storage medium provided by the invention, the requests can be merged and the database execution time can be optimized in a scene of high-concurrency multi-thread request databases, so that DB processing request delay is reduced or eliminated, and the database execution efficiency is improved. Therefore, the service throughput of the database system is effectively improved. The network consumption during multiple requests is reduced by merging the requests, multiple random operations are merged into sequential read-write as much as possible, the disk processing time is shortened, and the purpose of optimizing the throughput of the whole system by optimizing the hard disk is achieved.

Description

technical field [0001] The invention relates to the technical field of computer and communication, in particular to a database-oriented request batch processing method, device, equipment and storage medium. Background technique [0002] Structured Query Language (Structured Query Language), referred to as SQL, is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems. [0003] SQL is a high-level non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the data storage method, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. Moreover, its structured query language statements can be nested, making it ext...

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): G06F16/2453G06F16/2455
CPCG06F16/24549G06F16/2455
Inventor 段鑫
Owner GUANGZHOU BAIGUOYUAN INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products