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

Data interaction method and device based on real-time query

A data interaction and database technology, applied in the field of computer networks, can solve the problems of delayed response, affecting the timeliness, and failing to achieve the speed of the business end, and achieve the effect of high speed and high timeliness

Active Publication Date: 2021-04-13
INST OF INFORMATION ENG CAS
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Therefore, the existing data exchange technology often reaches the design bottleneck of the system during the high concurrency period, for example, when a request with a higher priority needs to return the result as soon as possible, It may happen that the response of the request is delayed, which seriously affects the timeliness required by the request, so that the speed required by the business end cannot be achieved

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 interaction method and device based on real-time query

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0056] Example 1 Long query test

[0057] 1) The multiple post requests of the simulated user are encoded by the http protocol and sent to the data exchange system.

[0058] 2) After the request sent by the user arrives at the interface module of the data exchange system, after http decoding, the uid (user id), content (sql statement), scopeEnum (long and short query identifier), and uniq_key (unique identifier of the request) in the request are obtained, The field is encapsulated into a DataProxyRequest object, encoded through the http protocol, and sent to the service proxy module of the data exchange system.

[0059]3) After the request of the interface module arrives at the service proxy module, it is decoded by http to obtain the object encapsulated as DataProxyRequest, which includes uid (user id), sql (original sql statement), scopeEnum (long and short query identifier), uniq_key (request unique logo). Determine whether the request is a long query or a short query acc...

example 2

[0064] Example 2 short query test

[0065] 1) The multiple post requests of the simulated user are encoded by the http protocol and sent to the data exchange system.

[0066] 2) After the request sent by the user arrives at the interface module of the data exchange system, after http decoding, the uid (user id), content (sql statement), scopeEnum (long and short query identifier), and uniq_key (unique identifier of the request) in the request are obtained, The field is encapsulated into a DataProxyRequest object, encoded through the http protocol, and sent to the service proxy module of the data exchange system.

[0067] 3) After the request of the interface module arrives at the service proxy module, it is decoded by http to obtain the object encapsulated as DataProxyRequest, which includes uid (user id), sql (original sql statement), scopeEnum (long and short query identifier), uniq_key (request unique logo). Determine whether the request is a long query or a short query a...

example 3

[0070] Example 3 Mixed query test

[0071] 1) The multiple post requests of the simulated user are encoded by the http protocol and sent to the data exchange system.

[0072] 2) After the request sent by the user arrives at the interface module of the data exchange system, after http decoding, the uid (user id), content (sql statement), scopeEnum (long and short query identifier), and uniq_key (unique identifier of the request) in the request are obtained, The field is encapsulated into a DataProxyRequest object, encoded through the http protocol, and sent to the service proxy module of the data exchange system.

[0073] 3) After the request of the interface module arrives at the service proxy module, it is decoded by http to obtain the object encapsulated as DataProxyRequest, which includes uid (user id), sql (original sql statement), scopeEnum (long and short query identifier), uniq_key (request unique logo). Determine whether the request is a long query or a short query a...

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 data interaction method and device based on real-time query, and the method comprises the steps: analyzing a received client data query request, and judging whether the client data query request is long query or short query; if theclient data query request is the long query, querying the database according to the generated query record, and storing a long query result into a distributed file system; if the client data query request is the short query, querying the database through the converted system sql statement to obtain a short query result; and returning the obtained long query result or short query result to the client. According to the invention, two different request modes of short query and long query are supported, and processing at different speeds can be carried out according to the emergency degree of the service; short query can skip an intermediate system to directly access a data source and return result data so as to achieve a higher speed; and long query results are sequentially returned to the requester in a relatively small unit, so that higher timeliness is achieved.

Description

technical field [0001] The invention belongs to the field of computer networks, in particular to a data interaction method and device based on real-time query. Background technique [0002] With the increasing amount of data and the amount of information in the current information age, the information systems in enterprises and other business objects are becoming more and more complicated, and the information interaction between each other has become more cumbersome and difficult. Therefore, It is more likely to cause data delays, causing some important requests to fail to arrive at the required speed, thus affecting the timeliness and accuracy of important businesses. [0003] Commonly seen data exchange often uses a unified access method to process all received requests, that is, after receiving each request, process all requests and return all results at one time. [0004] Therefore, the existing data exchange technology often reaches the design bottleneck of the system ...

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
IPC IPC(8): G06F16/9532G06F16/242G06F16/27
CPCG06F16/9532G06F16/242G06F16/27
Inventor 朱蔚林木伟民迟磊金宗泽张云王伟平
Owner INST OF INFORMATION ENG CAS