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

A data import method and device

A data import and metadata technology, applied in the computer field, can solve the problems of lack of guiding logical relationship processing and integration testing, cumbersome manual configuration, cumbersome failure handling, etc., to maximize the efficiency of error checking, improve accuracy, The effect of restoring cost minimization

Active Publication Date: 2016-08-24
SHENZHEN TENCENT COMP SYST CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] In an environment where Internet companies have a lot of business and changes rapidly, manual configuration is so cumbersome that it is almost an impossible task; operations are fragmented and difficult to manage, and multiple logins to complex environment configurations are required in multiple data sources and heterogeneous environments; Instructive front-back logical relationship processing and integration testing, the incompatibility of front-back configuration can only be postponed to the implementation stage to find out; the failure handling of configuration errors is cumbersome, and the correct part cannot be skipped and directly recovered from the error scene

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 import method and device
  • A data import method and device
  • A data import method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] Aiming at the problems of cumbersome manual configuration, scattered processing steps and scattered places in the prior art, in the technical solution provided by the present invention, metadata generation, database table creation, adding partitions and empowering are realized in the process of data access in the form of workflow , as well as functions such as adapting various businesses, the background automatically generates and deploys running programs, which can support multiple data sources and data terminals such as multiple databases and distributed systems. In the environment of complex enterprise-level data warehouse business, complex metadata, and various programs and plug-ins that are cumbersome and error-prone, a new solution for frequent access to large amounts of data without manual intervention is given.

[0046]In the technical solution provided by the present invention, the minimum subset that is variable for the business is extracted and provided in the...

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 data import method, which includes the following steps: obtaining business files from a business system, generating static metadata according to the business files and accessing a target database corresponding to the business system; using the static metadata to The business data in the target database is format-converted, and the format-converted data is imported into the target data storage area. By using the invention, the accuracy, ease of use and efficiency of data import are improved. The invention also discloses a device for applying the above method.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data import method and device. Background technique [0002] In the process of enterprise information construction, due to the phased, technical, and other economic and human factors in the construction of various business systems and the implementation of data management systems, the enterprise has accumulated a large amount of business data in different storage methods during the development process. , and the data management systems used for business data are also very different, from simple file databases to complex network databases, which constitute the heterogeneous data sources of enterprises. [0003] Heterogeneous data sources refer to data between different database management systems. The heterogeneity of enterprise data sources is mainly manifested in: [0004] 1. System heterogeneity, that is, the difference between the business application system, database man...

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 Patents(China)
IPC IPC(8): G06F17/30G06Q10/00
Inventor 蒲刚周小平杨晓青
Owner SHENZHEN TENCENT COMP SYST CO LTD
Features
  • Generate Ideas
  • 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