Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Execution method and device for databases

An execution method and database technology, applied in the field of communication, can solve problems such as no solution

Active Publication Date: 2017-03-29
NANJING ZHONGXING XIN SOFTWARE CO LTD
View PDF3 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] (2) Based on the distributed design, the data is distributed to different DB nodes according to various distribution strategies. For example, A data is distributed to DB-1, DB-2 and DB-3 through the distribution key HASH, and B data is distributed through the distribution key RANGE is distributed to DB-2, DB-3, and DB-4. When querying associated data A and B, it will inevitably lead to associated data queries across database nodes.
[0009] In the existing distributed database execution scheme, there is better support for data query of the same database node in a single table, data query of a single table across database nodes, and associated data query of multiple tables in the same database node, but for multi-table cross There is no corresponding solution for the associated data query of database nodes

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
  • Execution method and device for databases
  • Execution method and device for databases
  • Execution method and device for databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0032] In this embodiment, a method for executing a database is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although the steps shown in the flow chart Although a logical order is shown, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0033] In this embodiment, a database execution method is provided, figure 1 is a flowchart of a method for executing a database according to an embodiment of the present invention, such as figure 1 As shown, the process includes the following steps:

[0034] Step S102, receiving a structured query SQL request for performing database operations on one or more databases;

[0035] Step S104, generating a corresponding syntax tree according to the received SQL request;

[0036] Step S106, traversing each node of the generated syntax ...

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 an execution method and device for databases. The method comprises following steps: receiving structured query SQL requests of database operation for one or multiple databases; generating corresponding syntax trees in accordance with the received SQL requests; searching all nodes for generation of the syntax trees and generating execution trees; and executing database operation for one or multiple databases based on generated syntax trees. By adoption of the execution method and device for databases, that technical problem in the prior art that associated data of inter-database nodes cannot be searched is solved, thereby achieving the technical effect of searching associated data for inter-database nodes.

Description

technical field [0001] The present invention relates to the communication field, in particular, to a database execution method and device. Background technique [0002] As the amount of data continues to expand, stand-alone databases are increasingly unable to meet the needs of users for large storage and high-performance databases. As a result, distributed databases are widely used. [0003] At present, mainstream distributed databases basically classify data according to data relevance, combine with appropriate data redundancy, concentrate related data on a database node, and issue database execution statements (such as database retrieval query statements, etc.) Execute on the database node where the associated data resides. [0004] For example, there are three types of data A, B, and C, where A and B are not related, A and C are related, and B and C are related. When designing and deploying databases in related technologies, A and C will be concentrated on the database...

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): G06F17/30
CPCG06F16/2471G06F16/27G06F16/00
Inventor 左庄太丁岩陈小强贾新华高洪
Owner NANJING ZHONGXING XIN SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com