Supercharge Your Innovation With Domain-Expert AI Agents!

Business data processing method and device, electronic equipment and storage medium

A business data and business processing technology, applied in the field of data processing, can solve the problems of high labor consumption, missing data, low processing efficiency, etc., and achieve the effect of improving the convenience of data import and the effect of automatic technology

Pending Publication Date: 2021-11-02
深圳鼎盛电脑科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] When importing data based on users, due to the large amount of data, it requires a lot of manpower and low processing efficiency; at the same time, because it is performed manually, there will be human negligence, resulting in the problem of missing data

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
  • Business data processing method and device, electronic equipment and storage medium
  • Business data processing method and device, electronic equipment and storage medium
  • Business data processing method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 1 It is a flow chart of a business data processing method provided by Embodiment 1 of the present invention. This embodiment is applicable to situations where there is a large amount of business data to be processed in an enterprise and can be processed quickly. This method can be implemented by a business data processing device To execute, the device may be implemented in software and / or hardware. The device can be configured in a server, and the method specifically includes the following steps:

[0027] Step 110, retrieve target data to be processed from the database based on the ETL calculation task, and cache the target data to be processed in a temporary data table.

[0028] In the embodiment of the present invention, the ETL computing task can be used to describe the process of extracting, transforming and loading data from the source to the destination. The purpose is to integrate scattered, messy, and inconsistently standardized data in the enterprise. ...

Embodiment 2

[0041] figure 2 It is a flowchart of a business data processing method provided in Embodiment 2 of the present invention. On the basis of the above technical solution, the above steps 110 and 120 can be further refined. For the specific implementation method, please refer to the detailed description of this technical solution. elaborate.

[0042] see figure 2 As shown, the method in the embodiment of the present invention may include the following steps:

[0043] Step 210, when it is detected that the current time is consistent with the preset task trigger time, the ETL computing task is used to retrieve the target data to be processed from the database, and cache the target data to be processed in a temporary data table.

[0044] Wherein, the preset task triggering time can be a periodic time, for example, 10 minutes, 1 hour, a day or a week, etc., or a specific time every day, such as 9 o'clock in the morning, 12 o'clock in the morning, etc.

[0045] Specifically, when ...

Embodiment 3

[0070] image 3 It is a flow chart of a business data processing method provided by Embodiment 3 of the present invention. The embodiment of the present invention is a preferred embodiment of the above-mentioned invention embodiment. See image 3 As shown, the method in the embodiment of the present invention may include the following steps:

[0071] Step 310, automatically pull data from the large database through the ETL calculation task.

[0072] Step 320, cache the extracted data into a temporary data table in the business system.

[0073] Step 330, sending the temporary data in the temporary data table to the business module for business processing, and sending the processed data to the business data table.

[0074] Step 340, after the business module processes the temporary data, it updates the processed data in the temporary data table.

[0075] Step 350, delete the processed data in the data automatically pulled from the large database through the ETL calculation ta...

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 discloses a business data processing method and device, electronic equipment and a storage medium, and the method comprises the steps: calling target to-be-processed data from a database based on an ETL calculation task, and caching the target to-be-processed data into a temporary data table; sending each piece of to-be-processed sub-data in the temporary data table to a service processing module according to a preset data processing condition; wherein the to-be-processed sub-data is a group of data in the target to-be-processed data; and processing the to-be-processed sub-data based on the business processing module to obtain to-be-used business data stored in a business data table, and performing business analysis processing based on the to-be-used business data. According to the technical scheme, the problems that in the prior art, a user needs to manually retrieve the data from the database, complexity is high, and the period is long are solved, and the technical effect of rapidly and conveniently extracting the data from the database is achieved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of data processing, and in particular, to a business data processing method, device, electronic equipment, and storage medium. Background technique [0002] With the rapid development of Internet technology and the environment of big data, more and more business data are stored in the database. When processing a large amount of data, the existing technology is to create a CSV file and import it by the user. The data. [0003] When importing data based on users, due to the large amount of data, it requires a lot of manpower and low processing efficiency; at the same time, because it is performed manually, there will be human negligence, resulting in the problem of missing data. Contents of the invention [0004] The invention provides a business data processing method, device, electronic equipment and storage medium to realize the technical effect of automatic processing of offlin...

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/22G06F16/2455G06F16/25G06Q40/02
CPCG06F16/2282G06F16/24552G06F16/254G06Q40/03
Inventor 邓国振乔迁
Owner 深圳鼎盛电脑科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More