Method, device and equipment for distinguishing splitting process based on OGG technology

A process and technology technology, applied in the field of discriminating and splitting processes based on OGG technology, can solve problems such as large processing delays, inability to solve problems in time, and low efficiency, so as to reduce labor costs, improve data extraction and replication efficiency, and prevent timeliness and consistent effect

Pending Publication Date: 2020-06-30
CHINA MOBILE GROUP SICHUAN +1
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, as the business changes, the DBA will not be able to identify the data changes brought about by the business change in a timely manner, which often manifests as a large processing delay in the extract process component and the replicat process component. At this time, the DBA needs to intervene to adjust the OGG process configuration , Generally, it takes hours or even days from business change to final DBA intervention, resulting in inability to solve problems in time and inefficiency

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, device and equipment for distinguishing splitting process based on OGG technology
  • Method, device and equipment for distinguishing splitting process based on OGG technology
  • Method, device and equipment for distinguishing splitting process based on OGG technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] The characteristics and exemplary embodiments of various aspects of the application will be described in detail below. In order to make the purpose, technical solution and advantages of the application clearer, the application will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described here are only configured to explain the application, not to limit the application. It will be apparent to one skilled in the art that the present application may be practiced without some of these specific details. The following description of the embodiments is only to provide a better understanding of the present application by showing examples of the present application.

[0054] It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily ...

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 embodiment of the invention provides a method, device and equipment for distinguishing a splitting process based on an OGG technology, and the method comprises the steps: obtaining the statisticalinformation of a process, and determining the actual throughput of the process, wherein the statistical information comprises a target file; determining a pre-throughput according to the called log quantity and the conversion coefficient of the target file; judging whether the relationship between the pre-throughput and the actual throughput meets a first preset condition or not; and under the condition that a preset condition is met, splitting the process. According to the invention, the statistical information is obtained; executing and splitting processes are optimized; the process based on the OGG technology can timely respond to the data change caused by the change of the business system, the influence on the timeliness and consistency of the data due to the data synchronization delay caused by the sudden business change can be prevented, and the labor cost is reduced while the data extraction and replication efficiency of the OGG process is improved.

Description

technical field [0001] The invention belongs to the technical field of data transmission, and in particular relates to a method, a device, a device and a computer storage medium for discriminating a split process based on an OGG technology. Background technique [0002] When using Oracle GoldenGate (hereinafter referred to as OGG) as a database replication solution, as the business load increases, the extraction (extract) and replication (replicat) process components are often the first performance bottlenecks to appear. In order to adapt to the ever-increasing business load, process splitting is required to achieve parallel processing. [0003] At present, the extract process component and the replicat process component in the OGG process are independent of each other. Whether to split the process mainly depends on the long-term accumulated maintenance experience and technical level of the database administrator (database administrator, DBA). However, as the business chang...

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
IPC IPC(8): G06F9/48G06F11/34
CPCG06F9/4843G06F11/3452G06F11/3476
Inventor 谢腾
Owner CHINA MOBILE GROUP SICHUAN
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