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

Multi-database-based automatic data unloading and supplying method cross-center multiple databases

A database and data technology, applied in the database field, can solve the problems of difficult to control the use of server resources, congestion of server resources, and congestion of data supply tasks, and achieve the effect of reducing labor development costs, facilitating centralized monitoring, and reducing impact.

Pending Publication Date: 2020-04-28
CHINA CONSTRUCTION BANK
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For a large number of supply requirements, it is necessary to develop a program for each supply demand, which not only consumes human resources, but also increases the difficulty of operation and maintenance, and it is not easy to control the use of server resources. Resource congestion, affecting system operation

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
  • Multi-database-based automatic data unloading and supplying method cross-center multiple databases
  • Multi-database-based automatic data unloading and supplying method cross-center multiple databases
  • Multi-database-based automatic data unloading and supplying method cross-center multiple databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The specific embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings, but it should be understood that the protection scope of the present invention is not limited by the specific embodiments.

[0029] Unless expressly stated otherwise, throughout the specification and claims, the term "comprise" or variations thereof such as "includes" or "includes" and the like will be understood to include the stated elements or constituents, and not Other elements or other components are not excluded.

[0030] figure 1 It is a schematic flow diagram of a method for automatically unloading and supplying data based on cross-center multi-databases according to an embodiment of the present invention, as shown in figure 1 As shown, a method for automatically unloading and supplying data based on cross-center multi-databases according to a preferred embodiment of the present invention includes: setting up a database parameter t...

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 an automatic data unloading and supplying method based on cross-center multiple databases. The method comprises the steps: setting a database parameter table, a data supplyingtask parameter table and a data supplying task log table on a batch running server of each application system; defining a semaphore, a shared memory and a maximum concurrency number of a server systemlevel for the batch running server; defining a database-level semaphore, a shared memory and a maximum concurrency number for each database; reading a database parameter table, obtaining a data supply database list needing to be executed by the server, and creating a new process for each database one by one to independently process the control of data supply tasks and process resources of each database; creating a sub-process, and inquirying a company-level center parameter table at any time. Therefore, the automatic data unloading and supplying method based on the cross-center multiple databases is flexible and trouble-saving, reduces the manpower development cost, avoids excessive centralized data unloading and supplying, and has a disaster recovery function.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for automatically unloading and supplying data based on cross-center multi-databases. Background technique [0002] With the development needs of information security, large enterprises often split their business into business departments under various business segments. Each business department has its own independent application system and database group, and the systems of business departments cannot directly access each other's databases. There is data intersection and dependence between them. For example, department A needs the basic data of department B, and department B may also need some basic data of department A. [0003] The data of the same application system will be stored in different data centers at the same time, and may also be stored in different data centers. In order to play a role in disaster recovery, when a certain data center fails, another app...

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): G06F16/21G06F11/14G06F16/25
CPCG06F16/211G06F16/258G06F16/256G06F11/1479Y02D10/00
Inventor 叶大试陈大平程明远彭李超黄冲王康椿梁志堂
Owner CHINA CONSTRUCTION BANK
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