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
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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...
PUM

Abstract
Description
Claims
Application Information

- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.
© 2023 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap