Database backup performance controlling method and system and server with system

A control method and technology for a control system, which are applied in the direction of redundant operation data error detection, electrical digital data processing, instruments, etc., can solve problems affecting Oracle backup performance, performance loss, etc. Performance loss, the effect of speeding up backups

Active Publication Date: 2017-01-25
EISOO SOFTWARE
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Performance loss caused by message communication between processes directly affects Oracle 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
  • Database backup performance controlling method and system and server with system
  • Database backup performance controlling method and system and server with system
  • Database backup performance controlling method and system and server with system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0035] This embodiment provides a method for controlling database backup performance. The database generates a control process for controlling the backup during the backup process, and the control process includes a generation function for performing backup to generate backup piece data, and / Or an acquisition function for acquiring the backup piece data; the method for controlling database backup performance includes the following steps:

[0036] Create a data object with the same name as the backup piece data according to the name of the backup piece data generated by the generating function;

[0037] Creating a memory block for storing backup piece data, and returning the memory address of the memory block to the obtaining function;

[0038] Calling the acquiring function, acquiring the data block in the data object from the acquiring function, and filling it to the memory address of the memory block;

[0039] Send the data block at the memory address of the memory block to a media...

Embodiment 2

[0078] This embodiment provides a database backup performance control system 1, and the media management layer process runs the database backup performance control system. See figure 2 , Shown as a schematic diagram of the principle structure of a control system for database backup performance in an embodiment. Such as figure 2 As shown, the database backup performance control system 1 includes an initialization module 11, a first creation module 12, a second creation module 13, a processing module 14, a data sending module 15, a closing module 16, a judgment module 17, and an end module 18. .

[0079] The initialization module 11 is used to initialize the MML process.

[0080] The first creation module 12 connected to the initialization module 11 is configured to create a data object with the same name as the backup piece data according to the name of the backup piece data generated by the generating function (sbtbackup). Specifically, the first creation module 12 obtains the ...

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 database backup performance controlling method and system and a server with the system. The database backup performance controlling method comprises the steps that a data object the same as a name of backup piece data is created according to the name, generated according to a generation function, of the backup piece data; a memory block used for storing the backup piece data is created, and a memory address of the memory block is returned to a get function; the get function is called, a data block in the data object is obtained from the get function, and the memory address is filled with the memory block; the data block of the memory address of the memory block is sent to a media pool. According to the database backup performance controlling method and system and the server with the system, the performance loss problem existing between an MML course and a backup course is solved, the Oracle single-channel backup performance is improved, and the Oracle large data volume backup speed is increased.

Description

Technical field [0001] The present invention belongs to the technical field of structured data protection, and relates to a control method and system, in particular to a control method and system for database backup performance, and a server with the system. Background technique [0002] Oracle provides a set of media management layer interface (Media Management Layer (MML) API), allowing third-party vendors to build their own media manager (Media Manager). The usual 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 will send the backup data to the media pool. [0003] The backup speed of Oracle server can reach hundreds of gigabit per second. In other words, the message communication between the MML process and the backup process is under great pressure, and a large amount of data is shared every second. The performance loss caused by message communication between processes directl...

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/14
CPCG06F11/1451G06F11/1456
Inventor 陈沐豪
Owner EISOO SOFTWARE
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