A data conversion method and a terminal

A data and terminal technology, applied in the field of data processing, can solve the problems of complex data conversion and writing, low efficiency, and a large amount of manpower, and achieve the effects of lowering the writing threshold, ensuring consistency, improving efficiency and accuracy

Active Publication Date: 2019-04-16
福建凯米网络科技有限公司
View PDF3 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Data conversion realizes the function of converting data from one expression form to another, but the existing data conversion methods have the following defects: data conversion can only be performed independently one time at a time, data conversion writing is complicated and inefficient; when When the conversion conditions change, it is necessary to re-calculate all fields of the data according to the new conversion conditions, which requires a lot of manpower and low data maintenance efficiency

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
  • A data conversion method and a terminal
  • A data conversion method and a terminal
  • A data conversion method and a terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0069] Please refer to figure 1 , a method for data conversion, comprising the steps of:

[0070] S1. Receive selection conditions of source data to be converted and pre-configured data conversion instructions, the data conversion instructions include data conversion statements and a preset target table;

[0071] Among them, the selection condition refers to the condition when the source data is to be selected. Correspondingly, when designing the data source, it is necessary to ensure that there are fields that can reflect the selection condition or divide the data source into different files according to the selection condition. ;

[0072] The specific selection conditions can be set according to the actual situation. For example, the selection condition can be set to the time when the source data is generated. When designing the data source, it is necessary to ensure that there is a field that can distinguish the data generation time or divide it into different files accord...

Embodiment 2

[0086] The difference between this embodiment and Embodiment 1 is that the steps S2 and S3 include:

[0087] According to the selection condition, putting the record corresponding to the selection condition in the preset target table into the cache, and deleting the record from the preset target table, if there is no data in the target table, is empty;

[0088] For example, if the source data of a certain date is selected, the record corresponding to the date is placed in the temporary cache in the target table, and the record is deleted from the preset target table;

[0089] After putting the record corresponding to the selection condition in the preset target table into the cache, it also includes:

[0090] Add an update flag for each record, and set the update flag for each record to No;

[0091] Inserting the target data into the preset target table according to the primary key list and the target table field list includes:

[0092] S31. Traverse each record of the targ...

Embodiment 3

[0152] Please refer to figure 2 , a terminal 1 for data conversion, comprising a memory 2, a processor 3, and a computer program stored on the memory 2 and operable on the processor 3, and the processor 3 implements the embodiment when executing the computer program One step.

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 provides a data conversion method and terminal, and the method comprises the steps: receiving a selection condition of to-be-converted source data and a pre-configured data conversion instruction, and enabling the data conversion instruction to comprise a data conversion statement and a preset target table; Replacing a parameter corresponding to the selection condition in the data conversion statement with the selection condition; Executing the data conversion statement after parameter replacement, converting the selected source data to be converted into target data, and inserting the target data into the preset target table; Multiple times of rerunning of data conversion can be realized; When the conversion condition is changed, only the conversion instruction needs to be adjusted, and reupdating of data conversion can be achieved; And the data conversion instruction is compiled and agreed in advance, so that the compiling threshold of data conversion is reduced, the consistency of multiple times of re-running data is ensured, and the data conversion efficiency and the accuracy are improved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a data conversion method and terminal. Background technique [0002] Business intelligence BI is a complete set of solutions, which are used to effectively integrate the existing data in the enterprise, quickly and accurately provide reports and propose decision-making basis, and help enterprises make wise business decisions. Among them, ETL is the process of loading the data of the business system into the data warehouse after extraction, cleaning and conversion. It is an important part of BI project, and data conversion is an important step in ETL. [0003] Data conversion realizes the function of converting data from one expression form to another, but the existing data conversion methods have the following defects: data conversion can only be performed independently one time at a time, data conversion writing is complicated and inefficient; when When the conversion conditions...

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/22
CPCY02D10/00
Inventor 汤周文黄鸿强刘旺
Owner 福建凯米网络科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap