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

Distributed database catalogue management method and system, electronic equipment and readable storage medium

A management method and technology of a management system, which is applied in the field of computer data processing, can solve problems such as not supporting, can only be based on the catalog server, performance is difficult to meet the extremely high requirements of mixed online transaction load, etc., and achieves the effect of synchronous initiation and flexibility

Pending Publication Date: 2020-12-25
CHINA CITIC BANK
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The catalog server will become the bottleneck, so this method cannot meet the extremely high requirements of mixed online transactional load in terms of performance
[0004] The second management method is to store catalog data locally through files or databases on all DBProxy nodes, and store persistently on the catalog server through the database at the same time, and realize the consistency of catalog data between DBProxy nodes and catalog servers through the trigger-broadcast mechanism. In this mechanism, during the synchronization process between the catalog server and the DBProxy node, the catalog data can only be based on the catalog server, and DBProxy is not supported.

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 catalogue management method and system, electronic equipment and readable storage medium
  • Distributed database catalogue management method and system, electronic equipment and readable storage medium
  • Distributed database catalogue management method and system, electronic equipment and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] Embodiments of the present application are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present application, and should not be construed as limiting the present invention.

[0047] Those skilled in the art will understand that unless otherwise stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the word "comprising" used in the specification of the present application refers to the presence of the features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, Integers, steps, operations, elements, components, and / or groups thereof. The expressi...

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 relates to the technical field of computers, in particular to a distributed database cataloguing management method and system, electronic equipment and a readable storage medium, and themethod comprises the steps that a database agent sends updated cataloguing information to a cataloguing server, wherein the database agent is front middleware for accessing a database, and cataloguesof the database are stored in the database agent; the cataloguing server sends the received database cataloguing update to a cataloguing database; and the catalogue database receives the database catalogue update and updates the stored database catalogue. According to the technical scheme, the catalogued data of the distributed database can be maintained more flexibly, the method can be maintained on the basis of both the cataloguing server and the database proxy node, the fault-tolerant capability is higher, the timeliness and consistency of the catalogued data of the distributed database oneach node are guaranteed, and the reliability of the catalogued data of the distributed database is improved. The continuous availability of the distributed database under the hybrid online transaction type load is ensured.

Description

technical field [0001] The present application relates to the technical field of computer data processing, in particular to a distributed database catalog management method, system, electronic equipment and readable storage medium. Background technique [0002] In the distributed database architecture, in order to shield the complexity brought by sub-database and sub-table, applications usually do not directly access the distributed database, but access it through the database proxy (DBProxy). DBProxy is responsible for verifying and parsing SQL statement requests from applications, routing them to the correct database shards, assembling responses from one or more database shards, and returning them to the application. In a distributed database, in order to complete the verification, parsing, routing and assembly functions of SQL statements, the distributed database catalog (Database Catalog) is in an important position. It is used to describe the information of various obje...

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/23G06F16/27G06F16/28H04L29/08
CPCG06F16/23G06F16/275H04L67/1095G06F16/284
Inventor 王飞鹏王宁张聪陈让宽何海波
Owner CHINA CITIC BANK
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