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

Method and system for controlling database back-up performance and server

A control method and technology for a control system, applied in the field of structured data protection, can solve the problems of reduced backup speed and loss of backup performance, and achieve the effects of improving the ability to send data, improving backup speed, and improving backup performance

Active Publication Date: 2017-05-31
EISOO SOFTWARE
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] In view of the above-mentioned shortcoming of prior art, the object of the present invention is to provide a kind of database backup performance control method, system and server, be used to solve the Oracle backup scheme in the prior art, need synchronous ability between MML process and backup process Complete data backup, resulting in reduced backup speed and loss of backup performance

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
  • Method and system for controlling database back-up performance and server
  • Method and system for controlling database back-up performance and server
  • Method and system for controlling database back-up performance and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] This embodiment provides a method for controlling database backup performance, which is applied in the data interaction process between the media management process and the backup process. The media management process is used to obtain the backup data from the database. The backup The process is used to share backup data from the medium management layer process and send it; the control system of the database backup performance includes the following steps:

[0045] Between the media management layer process and the backup process, create a data object pool for assisting the media management layer process and backup process data interaction; the data object pool includes at least one shared memory for caching backup data unit, the shared memory unit has backup data cached, the readable semaphore of the shared memory unit can be read, there is a data memory that can cache the backup data in the shared memory unit, and the writable semaphore of the shared memory unit ;

...

Embodiment 2

[0072] This embodiment provides a database backup performance control system, and the control system is applied in the data interaction process between a media management layer process and a backup process. During the interaction process, the media management layer process is used to obtain backup data from a specified database, and cache the obtained backup data in the created data object pool. In this embodiment, the specified database is an Oracle database. The backup data is used to obtain backup data from the created data object pool, and send the obtained backup data to a third-party media pool. see Figure 5 , is a schematic diagram showing the principle structure of a control system for database backup performance in an embodiment. Such as Figure 5 As shown, the database backup performance control system 2 includes: a creation module 21 and an operation module 22 .

[0073] The creating module 21 is used for creating a data object pool 1 between the media manageme...

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 method and system for controlling database back-up performance and a server. According to the controlling system, a data object pool used for assisting data interaction between a media management layer process and a back-up process is created, and the data object pool includes at least one shared memory unit used for caching back-up data, readable signal amount of readable shared memory units and a writeable signal amount of the shared memory units, wherein the back-up data is cached in the shared memory units and the data memory of cacheable back-up data exists in the shared memory units; the readable signal amount of readable back-up data and the writeable signal amount of writeable back-up data in the data object pool are read, and according to the obtained readable signal amount of the readable back-up data and the obtained writeable signal amount of the writeable back-up data, the media management layer process and the back-up process execute asynchronous operation on the back-up data respectively. On the whole, the Oracle single channel back-up performance is improved, and the Oracle big datavolumn back-up speed is improved.

Description

technical field [0001] The invention belongs to the technical field of structured data protection, and relates to a control method and system, in particular to a database backup performance control method, system and server. Background technique [0002] Oracle provides a set of media management layer interfaces (Media Management Layer (MML) API), allowing third-party vendors to build their own media managers (Media Manager). A common practice is to obtain backup data from Oracle through MML, and then share it with the backup process of a third-party vendor, and the backup process sends the backup data to the media pool. [0003] The backup speed of the Oracle server can reach hundreds of gigabytes per second. That is to say, the message communication between the MML process and the backup process is under great pressure, and a large amount of data needs to be shared every second. The performance loss caused by message communication between processes directly affects Oracl...

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): G06F11/14G06F17/30
CPCG06F11/1458G06F16/252
Inventor 陈沐豪
Owner EISOO SOFTWARE
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