Universal data extraction and conversion method

A technology of data extraction and conversion methods, which is applied in electrical digital data processing, special data processing applications, instruments, etc., and can solve problems such as high requirements for technicians and inability to respond to changes in demand in time.

Inactive Publication Date: 2013-01-30
INSPUR QILU SOFTWARE IND
View PDF4 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Technical personnel need to understand both business and technology, and have relatively high requirements for technical personnel, and cannot respond to changes in demand in a timely manner

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
  • Universal data extraction and conversion method
  • Universal data extraction and conversion method
  • Universal data extraction and conversion method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0042] 1. Data structure (data dictionary, target table structure):

[0043] 1. Definition of database information

[0044] system type System business name data path type DB instance name database username Database password (encrypted database type database connection string is it effective source type Remark 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　

[0045] 2. Table information definition

[0046] System class: 　 Table Name: 　 display name: 　 Business implications: 　 describe: 　 Whether to display: 　 it's usable or not: 　 Remark: 　

[0047] 3. Definition of field information

[0048] Field Name field business name business meaning field description primary key flag Field Type field length Decimal places Is it nullable it's usable or not serial number ...

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 universal data extraction and conversion method. Common characteristics of data extraction are summarized by analyzing various data extraction processing rules and scheduling methods; definition management, source table data dictionary definition, target table structure setting, extraction rule setting and extraction plan setting are performed respectively by utilizing data structures and extraction rules and plans, and corresponding parameters can be set flexibly for the categories; and messages of the data structures and the extraction rules and plans are recorded by using a two-dimensional relation table and used by other servers or ports serving as metadata messages, and consanguinity analysis of a whole process is provided. According to the universal data extraction and conversion method, user interfaces utilize Chinese messages with business means to be presented to users, and low coupling of businesses and technologies is utilized, so that dependence of users on professionals is reduced, and requirements of business personnel for processing complicated business logic data conforming to requirements under the circumstance of the simple understanding of business personnel are met.

Description

technical field [0001] The system relates to a computer application technical field, specifically a general data extraction and transformation method. Background technique [0002] At present, the basic data in various fields in our country have been perfected, and various business systems have accumulated a large amount of data, which contains rich information resources, and the demand for data utilization is increasing day by day. Data mining and decision support are on the rise. How to dig out valuable data from massive data and how to effectively respond to changes in data processing rules brought about by changes in business requirements are issues that software companies and customers are eager to solve. At present, there are many ways to realize data extraction and transformation, such as: directly writing scripts to process data, ETL software products, but whether it is writing scripts or ETL products, it is inevitable that professional and technical personnel are re...

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): G06F17/30
Inventor 周秀强崔永生吕亚伟曹苗苗
Owner INSPUR QILU SOFTWARE IND
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