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

Data extraction method and device, electronic equipment and storage medium

A data extraction and database technology, applied in the field of data processing

Pending Publication Date: 2022-05-13
AGRICULTURAL BANK OF CHINA
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a data extraction method, device, electronic equipment, and storage medium to achieve the effect of not affecting the stability of the business system during data extraction and protecting the extracted data from being leaked

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
  • Data extraction method and device, electronic equipment and storage medium
  • Data extraction method and device, electronic equipment and storage medium
  • Data extraction method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0029] figure 1 This is a schematic flowchart of a data extraction method provided by Embodiment 1 of the present invention. This embodiment can be applied to the case of extracting service data when the target service system is in an idle state, and the method can be executed by a data extraction device. The apparatus may be implemented in the form of software and / or hardware, and the hardware may be an electronic device, such as a mobile terminal or a PC.

[0030] like figure 1 As shown, the method includes:

[0031] S110. Receive at least one data query instruction, and send the at least one data query instruction to a message queue corresponding to the target database.

[0032] Wherein, when querying business data, corresponding data query conditions can be set according to query requirements, and a data query instruction can be understood as a corresponding query instruction generated based on at least one data query condition input in the target display interface. The...

Embodiment 2

[0049] As an optional embodiment of the above-mentioned embodiment, figure 2 This is a schematic flowchart of a data extraction method provided in Embodiment 2 of the present invention. Optionally, the running state of the target business system is detected according to a preset running state detection condition, and when it is detected that the target business system is in an idle state, Acquire corresponding data query instructions from the message queue in the target database, and acquire target data corresponding to each data query instruction.

[0050] like figure 2 As shown, the method includes:

[0051] S210. Receive at least one data query instruction, and send the at least one data query instruction to a message queue corresponding to the target database.

[0052] S220. Detect the running state of the target business system according to the preset running state detection condition, and obtain a detection result, wherein the running state of the target business sys...

Embodiment 3

[0076] In a specific example, such as image 3 As shown in the figure, when data extraction is required, the data extraction user can log in to the target display interface of the target business system, and enter the withdrawal conditions through the target display page (that is, input the data query content matching the preset field based on the preset field) , extract the data query content corresponding to the preset field according to the preset rule, and fill the extracted data query content into the SQL statement, so as to realize automatic splicing and extraction of the SQL statement (ie, generate corresponding data query instructions). After regenerating the data query commands, store each data query command and the data query identifier corresponding to each data query command in the message queue of the target business system, so that when it is detected that the target business system is in an idle state, the target business system can be sent from the target busine...

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 data extraction method and device, electronic equipment and a storage medium, and the method comprises the steps: receiving at least one data query instruction, and sending the at least one data query instruction to a message queue corresponding to a target database; when it is detected that a data query condition is met, sending each data query instruction in the message queue to the target database so as to call target data corresponding to the data query instruction from the target database; and receiving target data corresponding to each data query instruction. The problems that the operation stability of the service system is affected and data leakage exists during data extraction are solved, and the effect of extracting the data on the premise that the operation state of the target service system is not affected and the data is protected from being leaked is achieved.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data processing, and in particular, to a data extraction method, apparatus, electronic device, and storage medium. Background technique [0002] With the wide application of big data technology, a huge amount of data will be generated in the business system of commercial banks, but in these huge amounts of data, it includes data only for users or staff in a certain department, also known as medium amount level data. [0003] At present, the extraction of medium-level data is mostly performed directly from the database that is conducting online transactions, or at regular intervals, the database is queried according to the currently stored query conditions. However, such an operation will destroy the stability of the business system during the data extraction process, or repeatedly query the same query condition within a period of time, resulting in unnecessary waste of system resour...

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): G06F16/242G06F16/2455G06F16/2457G06F9/54
CPCG06F16/2428G06F16/2455G06F16/2457G06F9/546G06F2209/548
Inventor 郭子卿刘煜东王会武牛向远
Owner AGRICULTURAL BANK OF CHINA
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