Check patentability & draft patents in minutes with Patsnap Eureka AI!

ETL script generation method and device

A technology for script generation and scripting

Pending Publication Date: 2020-11-13
INDUSTRIAL AND COMMERCIAL BANK OF CHINA +1
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Especially the first method above requires strong SQL development capabilities, heavy workload, low accuracy, and long development time, which cannot adapt to the rapid development of technology

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
  • ETL script generation method and device
  • ETL script generation method and device
  • ETL script generation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0083] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0084] Those skilled in the art should understand that the embodiments of the present invention may be provided as methods, systems, or computer program products. Accordingly, the present invention can take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermor...

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 relates to the field of artificial intelligence, and provides an ETL script generation method and device. The method comprises the steps: obtaining a table structure of a target table and a table structure of a pasting source table, the table structure comprising: a field; matching the field of the target table with the field of the pasting source table; judging whether all fields inthe target table have matched fields in the source pasting table or not; and if yes, generating an ETL script according to the table structure of the target table, the table structure of the pastingsource table and a matching result of the target table and the pasting source table. By adopting the technical scheme, the ETL script can be automatically generated, the development workload is reduced, the accuracy is high, the development time is shortened, and the method can adapt to quick development of the technology.

Description

technical field [0001] The invention relates to the technical field of artificial intelligence, in particular to an ETL script generation method and device. Background technique [0002] The data warehouse is the core of the current big data system. It is mainly used for offline data analysis and multi-dimensional statistical functions. It has the characteristics of many statistical targets, large amount of data, and long computing time. In order not to affect the operation of the business system, data is generally captured from the business system on a regular basis when the business system is at a low point. In this way, the online business system and the offline data analysis system are isolated from each other and can run independently of each other. [0003] In order to improve the service quality of financial, medical and other industries and reduce risks, the relevant national regulatory agencies require each operating agency to upload detailed and statistical operati...

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/25G06F16/28G06F40/247
CPCG06F16/254G06F16/288G06F40/247Y02D10/00
Inventor 刘伟杜利仲尹宏春王晶
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com