Distributed database preprocessing method, agent layer, system and storage medium

A preprocessing and database technology, applied in the database field, can solve the problems of low preprocessing performance and efficiency of distributed databases, and achieve the effect of saving resources, improving performance and efficiency, and saving interactive operations

Active Publication Date: 2021-01-19
金篆信科有限责任公司
View PDF11 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The distributed database preprocessing method, database proxy layer, system and storage medium provided by the embodiments of the present invention mainly solve the technical problem that the performance and efficiency of distributed database preprocessing in the prior art are relatively low

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
  • Distributed database preprocessing method, agent layer, system and storage medium
  • Distributed database preprocessing method, agent layer, system and storage medium
  • Distributed database preprocessing method, agent layer, system and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] In order to solve the problem of low performance and low efficiency of distributed database preprocessing in the prior art, in the embodiment of the present invention, the corresponding request of the prepared statement is received, and then according to the corresponding request of the prepared statement and the cache library of the prepared statement The session ID cached in the prepared statement cache library is processed, and the session corresponding to the session ID cached in the prepared statement cache library is a prepared statement session that has successfully established a connection between the client and the database; see figure 1 as shown in figure 1 It is a schematic flowchart of the basic flow of the distributed database preprocessing method provided in this embodiment.

[0027] S101: Receive a request corresponding to a prepared statement.

[0028] In this embodiment, the preprocessing statement includes but not limited to prepare, execute, and deal...

Embodiment 2

[0052] On the basis of the first embodiment, the embodiment of the present invention takes a specific distributed database preprocessing method as an example to further illustrate the embodiment of the present invention. Please refer to figure 2 Shown:

[0053] S201: the client sends a prepare request to the database proxy layer.

[0054] S202: The database proxy layer queries whether the prepare request session exists in the prepare session cached in the prepared statement cache library.

[0055] S203: Send a response message of the prepare request to the client when the query is found.

[0056] S204: Obtain the link and send a prepare request to the database when no query is found.

[0057] S205: The database sends a response message of the prepare request to the database proxy layer.

[0058] S206: The database proxy layer sends a response message to the prepare request to the client.

[0059] S207: the client sends an execute request to the database proxy layer.

[0...

Embodiment 3

[0073] In order to solve the problem in the prior art that motion vectors and prediction residuals need to be encoded simultaneously in the inter-frame prediction mode, and the encoding performance is low, a database proxy layer is provided in the embodiment of the present invention. Please refer to image 3 Shown:

[0074] The database proxy layer includes a receiving module 301 and a processing module 302, wherein:

[0075] The receiving module 301 is configured to receive a request corresponding to a prepared statement;

[0076] The processing module 302 is used for processing according to the corresponding request of the prepared statement and the session identifier cached in the prepared statement cache library. Handle statement sessions.

[0077] In this embodiment, the preprocessing statement includes but not limited to prepare, execute, and deallocate statement. In fact, as long as it belongs to the preprocessing statement, it is within the protection scope of the pr...

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 distributed database preprocessing method, a database agent layer, a system and a storage medium, and the method comprises the steps: receiving a preprocessing statement corresponding request, and carrying out the processing according to the preprocessing statement corresponding request and a session identification cached in a preprocessing statement cache library, whereinthe session corresponding to the session identifier cached in the preprocessing statement cache library is a preprocessing statement session with successfully established connection between the client and the database; the problem that in the prior art, the performance and efficiency of distributed database preprocessing are low is solved, the load of the database is reduced to a certain extent,the performance and efficiency of distributed database preprocessing are improved, and resources are saved.

Description

technical field [0001] The invention relates to the technical field of databases, and more specifically, to a distributed database preprocessing method, a database agent layer, a system and a storage medium. Background technique [0002] Prepared statement is a collective term for prepare, execute, and deallocate statements. Much like stored procedures, it is a collection of SQL statements that run in the background. Compared with the real-time SQL statement, the prepared statement divides the SQL statement into two parts, the first part is the same command and structure part as before, and the second part is the variable data part behind. When executing the SQL statement, first send the same command and structure part (the value in the SQL statement is replaced by a placeholder, which can be regarded as a template or parameterization of the SQL statement) to the database, and let the database execute it once in advance. Preprocessing (mainly lexical and semantic analysis, ...

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/2455G06F16/27
CPCG06F16/24552G06F16/27G06F16/2455H04L65/40H04L67/568H04L67/146G06F16/2443G06F16/252G06F16/24539
Inventor 张军
Owner 金篆信科有限责任公司
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap