Cluster-based database query method and system, electronic equipment and storage medium

A query method and query system technology, applied in database distribution/replication, electronic digital data processing, structured data retrieval, etc., can solve problems such as poor user experience and slow database query speed, and improve user experience and query efficiency Effect

Pending Publication Date: 2022-01-04
CTRIP COMP TECH SHANGHAI
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical problem to be solved by the present invention is to provide a cluster-based database query method and system, electronic equipment, and storage medium in order to overcome the defects of slow database query speed and poor user experience in common application environments in the prior art

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
  • Cluster-based database query method and system, electronic equipment and storage medium
  • Cluster-based database query method and system, electronic equipment and storage medium
  • Cluster-based database query method and system, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] see figure 1 , the present embodiment specifically provides a cluster-based database query method, the cluster synchronizes data according to the database; the query method includes the following steps:

[0045] S1. Parse the first query instruction to generate a second query instruction for querying the cluster;

[0046] S2. Query the cluster according to the second query instruction to obtain an intermediate query result;

[0047] S3. Generate a third query instruction according to the intermediate query result;

[0048] Wherein, the query results of the first query instruction and the third query instruction to the database are the same.

[0049] The database as query object in this embodiment includes but not limited to MSSQL, MySQL, Oracle and other databases; the cluster in this embodiment is a cluster database composed of multiple nodes that coordinate data processing, including but not limited to clusters such as Elasticsearch and Solr . The cluster is conne...

Embodiment 2

[0069] see Figure 4 , this embodiment specifically provides a cluster-based database query system, the cluster synchronizes data according to the database; the query system includes:

[0070] Parsing module 1, configured to parse the first query instruction to generate a second query instruction for querying the cluster;

[0071] The query module 2 is configured to query the cluster according to the second query instruction to obtain an intermediate query result;

[0072] A generating module 3, configured to generate a third query instruction according to an intermediate query result;

[0073] Wherein, the query results of the first query instruction and the third query instruction to the database are the same.

[0074] The database as query object in this embodiment includes but not limited to MSSQL, MySQL, Oracle and other databases; the cluster in this embodiment is a cluster database composed of multiple nodes that coordinate data processing, including but not limited t...

Embodiment 3

[0094] see Figure 5 As shown, this embodiment provides an information processing device 30, including a processor 31 and a memory 32 connected thereto. When the processor 31 executes a computer program stored on the memory 32, the cluster-based database as in Embodiment 1 is implemented. Query method. Figure 5 The electronic device 30 shown is only an example, and should not limit the functions and scope of use of the embodiments of the present invention.

[0095]Electronic device 30 may take the form of a general-purpose computing device, which may be a server device, for example. Components of the electronic device 30 may include, but are not limited to: at least one processor 31 , at least one memory 32 , and a bus 33 connecting different system components (including the memory 32 and the processor 31 ).

[0096] The bus 33 includes a data bus, an address bus and a control bus.

[0097] The memory 32 may include a volatile memory, such as a random access memory (RAM) 3...

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 discloses a cluster-based database query method and system, electronic equipment and a storage medium. The database query method comprises the following steps: analyzing a first query instruction to generate a second query instruction for querying the cluster; querying the cluster according to the second query instruction to obtain an intermediate query result; and generating a third query instruction according to the intermediate query result, wherein the query results of the first query instruction and the third query instruction on the database are the same. According to the cluster-based database query method and system, the electronic equipment and the storage medium, on the premise that client calling is not changed, query is performed by converting the query character string and utilizing a high-performance cluster service, a final query character string is obtained and then transmitted into the database for query, the overall query efficiency can be improved, the user experience is greatly improved, and the method can be applied to various scenes.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a cluster-based database query method and system, electronic equipment and storage media. Background technique [0002] A cluster, that is, a server cluster, refers to the collection of many servers to perform the same service, and it seems to the client that there is only one server. The cluster can use multiple computers for parallel computing to obtain high computing speed, and can also use multiple computers for backup, so that the entire system can still run normally if any one machine is broken. [0003] At present, many enterprises have built cluster platforms. However, due to the complex and diverse business application scenarios, it is not guaranteed that the actual client and the local database can be directly connected to the cluster. For database queries in an ordinary hardware environment, complex query fields often respond slowly, resulting in unsatisfactory user...

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/245G06F16/27
CPCG06F16/245G06F16/27
Inventor 张帆
Owner CTRIP COMP TECH SHANGHAI
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