Data query method and device based on database cluster, server and medium

A data query and database technology, applied in the field of data processing, can solve the problems of limited query data types and low data query efficiency, and achieve the effects of supporting scalability, increasing query speed, and improving efficiency

Active Publication Date: 2021-09-24
平安消费金融有限公司
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] At present, database clusters usually implement database fragmentation management in the form of middleware, that is, select corresponding middleware based on different business data to assign data query tasks to database clusters, for example, for web data, select web middleware to assign web data to database clusters Query tasks, for message data, select message middleware to assign message data query tasks to the database cluster, which will cause the base to be easily restricted by the type of query data during data query, thus making the efficiency of data query 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
  • Data query method and device based on database cluster, server and medium
  • Data query method and device based on database cluster, server and medium
  • Data query method and device based on database cluster, server and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0048] An embodiment of the present invention provides a data query method based on a database cluster. The subject of execution of the database cluster-based data query method includes, but is not limited to, at least one of server, terminal, and other sharding servers that can be configured to execute the method provided by the embodiment of the present invention. In other words, the data query method based on the database cluster can be executed by software or hardware installed on the terminal device or server device, and the software can be a block chain platform. The server includes, but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like.

[0049] refer to figure 1 As shown, it is a system architecture diagram of a data query method based on a database ...

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 the field of data processing, and discloses a data query method based on a database cluster, which comprises the following steps of: associating at least one proxy server for each database in the database cluster, and defining a master proxy server and a slave proxy server in the proxy servers; receiving a data query task transmitted by the client, and fragmenting the data query task to obtain a plurality of fragmented query tasks; transmitting the plurality of fragmented query tasks to the master proxy server, and receiving a distribution result of the slave proxy server of each fragmented query task returned by the master proxy server; and according to the distribution result, sending a data query instruction of the fragment query task to the slave proxy server, receiving a data query result obtained by performing data query on a database of the database cluster by the slave proxy server according to the data query instruction, and returning the data query result to the client. In addition, the invention also relates to a block chain technology, and the data query result can be stored in a block chain. According to the invention, the data query efficiency can be improved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a database cluster-based data query method, device, slice server and computer-readable storage medium. Background technique [0002] Database cluster refers to the use of at least two or more database servers to form a virtual single database logical image to provide transparent data services to clients, such as non-relational database nosql clusters and relational database mysql clusters, which can be realized through database clusters The serial processing of data is to use the database in the database cluster to solve the data query task intensively, so as to shorten the time of the data query task and improve the efficiency of the data query task. [0003] At present, database clusters usually implement database fragmentation management in the form of middleware, that is, select corresponding middleware based on different business data to assign data query tasks to database clu...

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): H04L29/08
CPCH04L67/1097H04L67/14H04L67/56Y02D10/00
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