Data loading method and system, and data loading unit

A data loading and data technology, applied in the field of data processing, can solve the problems of low efficiency and complex implementation of data loading tasks, and achieve the effect of improving efficiency and avoiding errors

Active Publication Date: 2011-03-16
CHINA CONSTRUCTION BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This way of establishing the attribution relationship is technically complex, and it is necessary to search the database to determine the attribution relationship when searching for data files, so the efficiency of generating data loading tasks is low

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
  • Data loading method and system, and data loading unit
  • Data loading method and system, and data loading unit
  • Data loading method and system, and data loading unit

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0037] figure 1 It is a flowchart of a data loading method in Embodiment 1 of the present invention. refer to figure 1 , the method includes:

[0038] Step S101, after receiving a loading signal carrying loading information, obtain a pre-configured file naming rule.

[0039] Step S102, searching for a data file of a data source to be loaded according to the loading information and the file naming rule, and generating a loading task of the data file.

[0040] In the embodiment of the present invention, the file naming rules of the data files of a certain data source can be pre-agreed according to the general characteristics and requirements of the banking industry data loading. A predetermined document naming convention may include the following fields: name, organization; name, date; or name, organization, and date. Preferably, the fields contained in th...

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 method for loading data, which comprises: acquiring preset file naming rules after receiving loading signals carrying loading information; searching for data files to be loaded of a data source according to the loading information and the file naming rules, and generating loading tasks of the data files; and loading data according to the loading tasks of the data files. The invention also discloses a system and a device for loading the data, and a device for setting the data source. The invention can improve the data loading efficiency, automatically generate batch loading tasks according to the loading information and the file naming rules, and can effectively avoid errors caused by manual operation.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a data loading method and system, a data loading device, and a data source configuration device. Background technique [0002] Information is an important resource of modern enterprises and the basis for enterprises to use scientific management and decision-making analysis. At present, major banks have spent a lot of money and time building numerous information systems to record various data related to production and operation and office automation. [0003] With the continuous expansion of data volume, banks need to adopt certain technical means to promote the flow and sharing of data in various departments and application systems. , ETL) is a major technical means. [0004] Data loading is usually the last step of the ETL process, which selects the data file to be loaded from the source database, and then loads the data file to the target database. [0005] A...

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/30G06Q40/00G06Q40/02
Inventor 于永顺金磐石杨军王卫东张冬鹏冀慎华李保仓陶晖吴松李建忠
Owner CHINA CONSTRUCTION BANK
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