Distributed database and management method for data operation of same

A management method and database technology, which are applied in electrical digital data processing, special data processing applications, database distribution/replication, etc. The effect of resource balancing

Inactive Publication Date: 2016-12-21
TIANJIN NANKAI UNIV GENERAL DATA TECH
View PDF10 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a distributed database and its data operation management method to solve the technical problem of unbalanced resource consumption of distributed database operation 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
  • Distributed database and management method for data operation of same
  • Distributed database and management method for data operation of same
  • Distributed database and management method for data operation of same

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 2

[0025] figure 2 It is a schematic flow chart of the management method for the data operation of the distributed database provided by Embodiment 2 of the present invention. This embodiment is applicable when the computing cluster in the distributed database system is divided into a basic computing layer cluster and a summary result computing layer cluster. In the case of managing distributed database data operations, the method can be executed by a management device for distributed database data operations. The device can be implemented by software / hardware and can be integrated into a distributed database system.

[0026] see figure 2 , the management method of the data operation of the distributed database, comprising:

[0027] S210, when the user's instruction includes a hash distribution column, the management cluster directly sends the received user's instruction to the basic computing layer cluster.

[0028] Exemplarily, the user's instruction is a sql operation. Thr...

Embodiment 3

[0033] image 3 It is a schematic flowchart of the management method for data calculation of the distributed database provided by Embodiment 3 of the present invention. This embodiment is applicable when the computing cluster in the distributed database system is divided into a basic computing layer cluster and a summary result computing layer cluster. In the case of managing distributed database data operations, the method can be executed by a management device for distributed database data operations. The device can be implemented by software / hardware and can be integrated into a distributed database system.

[0034] see image 3 , the management method of the data operation of the distributed database, comprising:

[0035] S310. When the user's instruction does not include a hash distribution column, the management cluster sends the received user's instruction to the basic computing layer cluster.

[0036]Exemplarily, the user's instruction is a sql operation. Through an...

Embodiment 4

[0043] Figure 4 It is a schematic flowchart of the management method for data calculation of the distributed database provided by Embodiment 4 of the present invention. This embodiment is applicable when the computing cluster in the distributed database system is divided into a basic computing layer cluster and a summary result computing layer cluster. In the case of managing distributed database data operations, the method can be executed by a management device for distributed database data operations. The device can be implemented by software / hardware and can be integrated into a distributed database system.

[0044] see Figure 4 , the management method of the data operation of the distributed database, comprising:

[0045] S410, when the user's instruction does not include a hash distribution column, the management cluster sends the received user's instruction to the basic computing layer cluster.

[0046] Exemplarily, the user's instruction is a sql operation. Through...

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 distributed database and a management method for data operation of the same. The distributed database comprises a management cluster used for receiving an instruction of a user, analyzing and optimizing the instruction and generating executive plan and schedule, a basic operation layer cluster used for receiving the executive plan from the management cluster and performing operation based on business tables distributed on nodes, and a summarized result operation layer cluster used for receiving data distributed by the basic operation layer cluster to perform operation. When the data does not have locality, data summarization and interaction can be realized, the use of network resources between the nodes can be reduced, and operation node resources of the distributed database can be more balanced.

Description

technical field [0001] The invention belongs to the technical field of distributed databases, and in particular relates to a distributed database and its data operation management method. Background technique [0002] Distributed database refers to the use of high-speed computer network to connect multiple physically dispersed data storage units to form a logically unified database. The basic idea of ​​a distributed database is to disperse and store the data in the original centralized database to multiple data storage nodes connected through the network to obtain larger storage capacity and higher concurrent access. In recent years, with the rapid growth of data volume, distributed database technology has also developed rapidly. Traditional relational databases have begun to develop from centralized models to distributed architectures. Relational-based distributed databases retain traditional databases. Under the data model and basic characteristics, from centralized stora...

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): G06F17/30
CPCG06F16/27
Inventor 崔维力武新张绍勇
Owner TIANJIN NANKAI UNIV GENERAL DATA TECH
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