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

Database operation and maintenance management method and device

An operation and maintenance management and database technology, applied in the computer field, to achieve the effect of good scalability and flexibility, saving manpower and time costs, and reducing the risk of inaccurate information

Pending Publication Date: 2021-12-03
BEIJING WODONG TIANJUN INFORMATION TECH CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In view of this, the embodiments of the present invention provide a database operation and maintenance management method and device, which can reduce the risk of inaccurate information caused by human operation, save manpower and time costs, and help users automatically maintain logic table and logic library information, To solve the problem of data fragmentation, various relatively independent resources and business information can be associated through different dimensions, so as to revitalize the data core of the entire operation and maintenance management, and it has good scalability and flexibility

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
  • Database operation and maintenance management method and device
  • Database operation and maintenance management method and device
  • Database operation and maintenance management method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0040] In the era of big data, with the development of business, the amount of data and visits continue to increase, and the sub-database and sub-table technology has been widely used in databases to break through the I / O (input / output) capabilities of single-node database servers. Restrictions to solve the problem of database scalability. While bringing about optimizatio...

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 database operation and maintenance management method and device, and relates to the technical field of computers. A specific embodiment of the method comprises the following steps: in response to an operation and maintenance management request for a database instance set, connecting database instances in the database instance set so as to obtain information of stored databases and data tables from the database instances; and according to the obtained information of the databases and the data tables, respectively aggregating the databases and the data tables in the database instance set , and obtaining a logic library corresponding to the database instance set and a first logic table in the logic library. According to the implementation mode, the risk of inaccurate information caused by manual operation can be reduced, manpower and time costs are saved, a user is helped to automatically maintain logic table and logic library information, the problem of data fragmentation is solved, and various relatively independent resources and service information can be associated through different dimensions, therefore, the data core of the whole operation and maintenance management is checked, and the expansibility and the flexibility are good.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database operation and maintenance management method and device. Background technique [0002] In the existing solution, the operation and maintenance logic library is to build an operation and maintenance platform system. Users enter their own database information (database name, deployment status), table information (some systems do not store table structure) and other information manually or in the form of loading configuration files. The asset information (host server, cluster, etc.) corresponding to the database instance is bundled together as a logic library and logic table by manually editing or uploading configuration files to facilitate subsequent operations (such as database DDL operations, monitoring and alarming, etc.) . The above-mentioned existing solutions are passively informed of key information such as database assets, structures, and database tables. Every...

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/22G06F16/242G06F16/36
CPCG06F16/211G06F16/2282G06F16/244G06F16/367
Inventor 唐大崴
Owner BEIJING WODONG TIANJUN INFORMATION TECH 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