Database management method and device

A management method and database technology, applied in the field of high-availability optimization solutions, can solve problems such as database downtime, and achieve the effects of improving throughput and concurrency, and enhancing stability and scalability.

Inactive Publication Date: 2018-01-16
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] This article provides a database management method and device, which can solve the problem of database downtime in related technologies

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to make the object, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be further described in detail below in conjunction with specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other arbitrarily.

[0047] The inventor of the present application proposes that the maintenance design can be considered in several aspects such as reducing the load of a single machine, reducing the probability of downtime, and increasing the data reading speed and concurrency. That is, based on the sub-database and sub-table technology, the storage and I / O can be distributed to multiple machines in parallel for processing, so as to make full use of the various processing capabilities of multiple machines, and at the same time avoid single point of failure, improve system availability, an...

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 management method and device, and relates to mass data query techniques. The database management method comprises the steps of conducting a database division and table division operation on a database; conducting a corresponding operation on the database after the database division and table division operation according to a preset management strategy, wherein the preset management strategy includes one or more strategies including configuration of a database cluster, configuration of read-write separation of the database, configuration of load balancing regulations of the database and configuration of an availability detection mechanism of database cluster nodes.

Description

technical field [0001] The invention relates to massive data query technology, in particular to a high-availability optimization scheme for solving excessive data volume in a single table of a database. Background technique [0002] With the development of system business and the continuous increase of the number of system users, the data will inevitably increase rapidly. After the data volume of a single table reaches a certain level, the query speed will become slower and slower, even if there is an index in the database It is also difficult to achieve the expected effect, which has caused great problems to the stability and scalability of the system. When faced with massive data queries, we hope to obtain better data retrieval capabilities. Currently, sub-databases and sub-tables have become a solution. It is a popular solution for the problem of excessive table data, but it has not been well handled when faced with problems such as excessive database pressure, database d...

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
Inventor 陈显桂
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap