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

Distributed database management system, method and device and storage medium

A management method and management system technology, applied in the field of distributed database management systems, methods, equipment and storage media, can solve the problems of high coupling and complexity of control logic components, heavy network communication burden, etc.

Active Publication Date: 2019-11-26
SHANGHAI DAMENG DATABASE
View PDF9 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Existing distributed systems can include independent distributed database servers and distributed storage servers, in which the database server is responsible for receiving and executing the operation request of the client to modify the table data, and generating the corresponding database log. Refresh the database log at an appropriate time, and write the data pages after the disk flushing into the corresponding storage server, and the storage server records the modified data pages. At this time, the database server corresponds to the data pages on the storage server one by one. , which makes the coupling and complexity of the control logic components of the data version higher. At the same time, when the underlying storage servers use multi-copy storage, they will directly send data pages, which makes the underlying network communication burden larger.

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 management system, method and device and storage medium
  • Distributed database management system, method and device and storage medium
  • Distributed database management system, method and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0029] figure 1 It is a schematic architecture diagram of a distributed database management system provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of optimizing management of distributed databases. refer to figure 1 , the distributed database management system 10 in this embodiment may include: a database service node 11 , a log node 12 and a storage node 13 .

[0030] Optionally, at least one database server 110 is configured on the database service node 11, and the database server 110 records the logical storage address of each data in the distributed database, and at least one storage server 130 is configured on the storage node 13, and on the storage server 130 The physical storage address of each item of data in the distributed database is recorded, and at least one log server 120 is configured on the log node 12, and the log server 120 records the mapping relationship between the logical storage address and the physical ...

Embodiment 2

[0045] figure 2 It is a schematic diagram of a distributed database management system provided by Embodiment 2 of the present invention. This embodiment is optimized on the basis of the foregoing embodiments. refer to figure 2 In this embodiment, the log node 12 in the distributed database management system 10 is also configured with a directory server 121, and the directory server 121 records the storage location of each fragment and its copy in the data file.

[0046] Specifically, the directory server 121 in this embodiment is responsible for providing metadata information of each item of data in the entire distributed database. The metadata information can be information describing data attributes, such as data storage locations, data structures, or data correspondences. Wait. At this moment, because the bearing load in the directory server 121 is relatively small, a single server can be used to meet the performance requirements, so that the number of the directory ser...

Embodiment 3

[0051] image 3 It is a flowchart of a method for managing a distributed database provided by Embodiment 3 of the present invention, and this embodiment is applicable to the case of optimizing management of a distributed database. A distributed database management method provided in this embodiment can be executed by a distributed database management device provided in an embodiment of the present invention, and the device can be realized by means of software and / or hardware, and integrated in the implementation of this method Among the devices, the device executing the method in this embodiment may be a log server in a distributed database.

[0052] Specifically, refer to image 3 , the method may include the following steps:

[0053] S310. Convert the first database log corresponding to the target data generated by the database server into a second database log under the corresponding physical storage address according to the mapping relationship between the logical storag...

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 distributed database management system, method and device and a storage medium. The system comprises a database service node, a log node and a storage node. The method comprises: a database server configured on the database service node generating a corresponding first database log according to a logic storage address of target data and sending the first database log to alog server configured on the log node; the log server converting the first database log into a corresponding second database log according to the mapping relationship between the logic storage address and the physical storage address of the target data, and sending the second database log to a storage server configured on a storage node where the target data is located; and the storage server redoing the second database log to obtain an operation result of the target data. According to the technical scheme provided by the invention, the coupling and complexity between the database service andthe distributed storage are reduced through the log node, and the data of the operation does not need to be directly sent, so that the network communication burden between the underlying storage is reduced.

Description

technical field [0001] The embodiments of the present invention relate to the field of database processing, and in particular, to a distributed database management system, method, device and storage medium. Background technique [0002] With the rapid development of database technology, in order to improve the processing performance of the database, distributed databases are more and more widely used in people's daily life. [0003] Existing distributed systems can include independent distributed database servers and distributed storage servers, in which the database server is responsible for receiving and executing the operation request of the client to modify the table data, generating the corresponding database log, and then using a dedicated disk brushing thread to Refresh the database log at an appropriate time, and write the data pages after the disk flushing into the corresponding storage server, and the storage server records the modified data pages. At this time, th...

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/21G06F16/27
CPCG06F16/211G06F16/27
Inventor 王攀韩朱忠郭琰
Owner SHANGHAI DAMENG DATABASE
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