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

Table data processing method and device based on kettle

A processing method and data processing technology, which can be applied in the fields of electrical digital data processing, special data processing applications, database indexing, etc., and can solve the problems of repeated development, time-consuming and labor-intensive database maintenance methods, etc.

Pending Publication Date: 2021-03-19
CHINA PING AN LIFE INSURANCE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is that when maintaining the data in the database, since databases of different programs or different scenarios usually have a certain degree of difference, when performing database maintenance, it is usually necessary for operation and maintenance personnel to write the maintenance The SQL statement used to process the data, such a database maintenance method is time-consuming and laborious, and it is easy to lead to the problem of repeated development

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
  • Table data processing method and device based on kettle
  • Table data processing method and device based on kettle
  • Table data processing method and device based on kettle

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0075] see figure 1 , figure 1 It is a schematic flowchart of a kettle-based table data processing method disclosed in an embodiment of the present invention. Such as figure 1 As shown, the kettle-based table data processing method may include the following operations:

[0076] 101. Obtain a table data processing configuration table.

[0077] In the above step 101, the table data processing configuration table at least includes the table name corresponding to the target table, the SQL statement and parameter information, and the parameter information includes parameters configured when executing data processing corresponding to the SQL statement on the target table in the kettle. By providing a configuration interface for configuring the table data processing configuration table on the interactive interface, and then the operation and maintenance personnel fill in the content of the table data processing configuration table (namely table name, SQL statement and parameter in...

Embodiment 2

[0129] see figure 2 , figure 2 It is a schematic structural diagram of a kettle-based table data processing device disclosed in an embodiment of the present invention. Such as figure 2 As shown, the kettle-based table data processing device may include:

[0130] The obtaining module 201 is used to obtain the table data processing configuration table, the table data processing configuration table at least includes the table name corresponding to the target table, the SQL statement and parameter information, and the parameter information includes when the data processing corresponding to the SQL statement is executed on the target table in the kettle Configuration parameters;

[0131] Generation module 202, for generating the target kettle program corresponding to the target form according to the table data processing configuration table;

[0132] The running module 203 is configured to run the target kettle program, so as to implement data processing corresponding to the...

Embodiment 3

[0135] see image 3 , image 3 It is a structural schematic diagram of another kettle-based table data processing device disclosed in the embodiment of the present invention. Such as image 3 As shown, the device may include:

[0136] A memory 301 storing executable program codes;

[0137] a processor 302 coupled to the memory 301;

[0138] The processor 302 invokes the executable program code stored in the memory 301 to execute the steps in the kettle-based table data processing method disclosed in Embodiment 1 of the present invention.

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 table data processing method and device based on kettle, and the method comprises the steps: obtaining a table data processing configuration table which at least comprises atable name, an SQL statement and parameter information corresponding to a target table, wherein the parameter information comprises parameters configured when data processing corresponding to the SQLstatement is executed on the target table in the kettle; generating a target kettle program corresponding to the target table according to the table data processing configuration table; and running the target kettle program so as to implement data processing corresponding to the SQL statement on the target table. Visibly, the table data processing configuration table is obtained firstly, and thenthe corresponding data processing is executed on the target table according to the table data processing configuration table, so that the configurability of table data processing is achieved, the codequality of table data processing is improved, and later maintenance is facilitated. The invention also relates to the technical field of block chains.

Description

technical field [0001] The invention relates to the field of computer operation and maintenance testing, in particular to a kettle-based table data processing method and device. Background technique [0002] Database technology is a common technology in modern computer technology, which is usually used to store data involved in computer operation. SQL language is a common database language. Computer maintenance personnel can use SQL language to perform operations such as adding, deleting, modifying, and checking data in the database, so as to maintain the database. However, there are usually a large amount of data stored in the database and a large amount of data processing may be involved in the maintenance of the database (for example, synchronizing the data of different tables into one table, docking between different programs, database Migration data, database backup data, etc.), if you need to write corresponding SQL statements to operate every time you process table d...

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/242
CPCG06F16/2282G06F16/2433
Inventor 裴一寒
Owner CHINA PING AN LIFE INSURANCE CO LTD
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