CN110019442B - Method and device for fetching number - Google Patents
Method and device for fetching number Download PDFInfo
- Publication number
- CN110019442B CN110019442B CN201710785633.1A CN201710785633A CN110019442B CN 110019442 B CN110019442 B CN 110019442B CN 201710785633 A CN201710785633 A CN 201710785633A CN 110019442 B CN110019442 B CN 110019442B
- Authority
- CN
- China
- Prior art keywords
- data
- target
- generating
- tag
- program
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D30/00—Reducing energy consumption in communication networks
- Y02D30/70—Reducing energy consumption in communication networks in wireless communication networks
Abstract
The method and the device for fetching the data provided by the embodiment of the application define fetch logic and data conversion logic through programs, and generate a tag data generating function according to the fetch logic and the data conversion logic; the program generates a dimension table according to the dimension table associated with the source table; the program defines a mapping rule between a source table and a target table, and generates a target data generating and loading function according to the mapping rule between the source table and the target table; the program calls a tag data generating function to generate tag data; the program calls the target data generating and loading function to generate target data and load the target data into the target table, so that decoupling of the access logic and the functional program is realized, a unified access function and a data loading function are provided, flexible access can be realized only by modifying interface configuration when the access requirement changes, the multiplexing degree and maintainability of codes are improved, and the labor cost is reduced.
Description
Technical Field
The present application relates to the field of database systems, and in particular, to a method and apparatus for fetching a number.
Background
The data extraction, conversion and loading processes of the industrial data warehouse system are generally realized by writing customized programs.
Under the condition that the fetch logic module and the input/output data module are coupled together, the requirement that the whole functional module can support different data models without modification or with little modification is difficult to achieve.
In the prior art, data is obtained by writing hard codes, and extraction, conversion and loading (Extract Transform and Load, ETL) programs are modified for each new data source or each new data source modification, so that data meeting the requirements is obtained through the programs.
In the field of financial systems, accounting personnel are required to withdraw cash amounts from a wide variety of financial statements in which there are various different types of cash data. If the financial statements are to be taken, cash flow splits are taken as an example, and the existing split method is as shown in FIG. 1.
FIG. 1 is a schematic diagram of a cash flow apportioning processing system framework in the prior art of finance. As shown in fig. 1, the cash flow allocation method includes a 3-time picking process and a 1-time allocation accounting process.
The operation process of the apportionment processing system is as follows: 3 times of extracting 3 parts of data sources are carried out, each time of extracting process is processed by a section of independent program extracting program, the extracted 3 groups of data are subjected to one-time program allocation accounting processing program, and finally the 3 groups of data are respectively loaded into 3 allocation result tables according to the data after the allocation accounting processing.
As can be seen from FIG. 1, in the cash flow allocation process, the program fetch logic module is dead code, each allocated data source has a section of independent program to process, the code and the data are tightly coupled together, the code reusability is low, the maintainability is poor, and the system is difficult to expand.
Disclosure of Invention
The embodiment of the application provides a method and a device for fetching numbers, which are used for solving the problems in the prior art.
In a first aspect, there is provided a fetch method comprising: program definition fetch logic and data conversion logic, and generating a tag data generating function; the program calls a tag data generating function to generate tag data; the program generates a dimension table, wherein the program generates the dimension table by defining the dimension table associated with a source table, and the program generates the dimension table for facilitating the program to fetch numbers from the tag data; the program generates a target data generating and loading function according to the mapping rule between the source table and the target table; the program calls the target data generating and loading function to map the tag data into target data.
In an implementation manner of the first aspect, after the program calls the target data generating and loading function to map the tag data into target data, the fetching method further includes: the program loads the target data into the target table.
In a second aspect, there is provided a counting device, the device comprising: the device comprises a generating module and a loading module, wherein: the generating module is used for generating a tag data generating function according to the fetch logic and the data conversion logic; the generating module is further used for generating a dimension table according to the dimension table associated with the source table; the generating module is further used for generating a target data generating and loading function according to the mapping rule between the source table and the target table; the generating module is further used for calling the tag data generating function to generate tag data; the generating module is further used for calling the target data generating and loading function and mapping the tag data into target data; and the loading module is used for loading the target data into a target table.
In a third aspect, there is provided a fetching device, the device comprising: a processor, a memory, and a transceiver; wherein:
the processor is used for generating a tag data generating function according to the fetch logic and the data conversion logic;
the processor is also used for generating a target data generation and loading function according to the mapping rule between the source table and the target table;
the processor is further configured to generate a dimension table according to a dimension table associated with the source table;
the processor is also used for calling the tag data generating function to generate tag data;
the processor is further configured to call the target data generating and loading function to map the tag data to target data.
The transceiver is used for receiving information input by a user.
In an implementation manner of the third aspect, the processor is further configured to load the target data into a target table.
In a fourth aspect, there is provided a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method of the first aspect described above.
In a fifth aspect, a computer-readable storage medium is provided. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the method according to the first aspect described above.
The method and the device for fetching the data provided by the embodiment of the application define fetch logic and data conversion logic through programs, and generate a tag data generating function according to the fetch logic and the data conversion logic; the program generates a dimension table according to the dimension table associated with the source table; the program defines a mapping rule between a source table and a target table, and generates a target data generating and loading function according to the mapping rule between the source table and the target table; the program calls a tag data generating function to generate tag data; the program calls the target data generating and loading function to generate target data and load the target data into the target table, so that decoupling of the access logic and the functional program is realized, a unified access function and a data loading function are provided, flexible access can be realized only by modifying interface configuration when the access requirement changes, the multiplexing degree and maintainability of codes are improved, and the labor cost is reduced.
Drawings
FIG. 1 is a schematic diagram of a cash flow apportionment processing system framework in the prior art of finance;
FIG. 2 is a schematic diagram of a cash flow apportionment processing system framework in the financial field provided by embodiments of the present application;
FIG. 3 is a schematic diagram of a frame and a working principle of a number taking system according to an embodiment of the present application;
FIG. 4 is a schematic flow chart of a method for fetching according to an embodiment of the present application;
FIG. 5 is a schematic diagram of a cash flow apportionment processing system data tag creation interface in the financial field provided by embodiments of the present application;
FIG. 6 is a schematic diagram of a flexible data source registration interface in the financial field provided by an embodiment of the present application;
FIG. 7 is a schematic diagram of a rule interface for loading data sources into cash flow apportionment rules in the financial field provided by embodiments of the present application;
fig. 8 is a schematic structural diagram of a first fetching device according to an embodiment of the present application;
fig. 9 is a schematic structural diagram of a second fetching device according to an embodiment of the present application.
Detailed Description
Embodiments of the present application will be described below with reference to the accompanying drawings in the embodiments of the present application.
Fig. 2 is a schematic diagram of an operating principle of a number taking system in the financial field according to an embodiment of the present application.
As shown in fig. 2, taking cash flow splitting as an example in the financial field, the system works as follows:
for the data sources of 3 different modules, a user uniformly registers the acquired 3 groups of allocation data into target data through a 1-time data acquisition process and a 1-time source data registration process, and the target data is applied to an allocation function program, so that cash allocation is realized, and the allocation data is loaded into a target table.
The apportionment processing method abstracts the access programs in different scenes to form a unified and flexible access function component, and the component has independent registration information, so that the flexible and configurable access source, the flexible and configurable access range, the flexible and configurable target table, the configurable field mapping relation between the source table and the target table and the decoupling of the access programs and the apportionment function programs are realized.
Fig. 3 is a schematic diagram of a frame of a number taking system and a working principle according to an embodiment of the present application.
The fetching system is completed on the basis of using cross-platform batch job scheduling management software Control-M. Wherein, control-M is BMC Software company product, and its working method is: in the client-server mode, an enterprise manager and a server are installed on a server, a proxy server is installed on a controlled host, and the proxy server can submit a job flow defined by Control-M on the host and return an operation result.
As shown in fig. 3, the fetch system may include 2 foreground interface configuration processes and 2 program ETL processing portions. Wherein, 2 foreground interfaces respectively create an interface and a data source registration interface for the data tag, and 2 program ETL processing parts comprise a process of generating tag data and a process of loading target data into a target table.
The data tag creation interface is used for defining the fetch logic and certain data conversion logic of the ETL. The data tag can be subjected to floor table, view or sub-query, and the functional module obtains the data to be operated by querying the corresponding floor entity.
The data source registration interface is used for defining a data structure of source data and target data, wherein the source data source is used for realizing extraction and conversion of data and supporting registration of a data tag, view or table as the source data; the target data and the mapping rule are used for realizing the loading of the target data to a final target table, and only the view or the table is supported to be registered as the target data; mapping rules of source data to target data are defined.
Generating tag data: the storage process is scheduled by Control-M or called by other storage processes, and generates data to an output table or a reconstructed tag view according to fetch logic and data conversion logic defined by a data tag, wherein the tag data is filtered and packaged source data, namely data used for operation.
Loading target data into a target table: the stored procedure is scheduled by Control-M or invoked by other stored procedures to load target data into the target table according to target data source definition and mapping rules.
The access system provided by the embodiment of the application can be widely applied to the fields of enterprise databases and business intelligence.
Taking cash flow allocation in the financial field as an example, fig. 4 is a schematic flow chart of a method for picking up data according to an embodiment of the present application. As shown in fig. 4, the fetching method includes:
s401, program definition fetch logic and data conversion logic generate a tag data generating function;
in one example, the fetch logic and data conversion logic is created from SQL Script code, some of which may be: the "SELECT a.personad_id AS PERIOD, A.COMPANY _key AS compare_key, a.control_key AS compare_key FROM dwr_cf_detail a" implements extraction of a.personad_id, a.compare_key and a.control_key FROM the table dwr_cf_detail a of the database ra_edw, and replaces column names a.personad_id, a.compare_key and a.compare_key with the respective names of PERIOD, compare_key and control_key, respectively, with the programs of PERIOD, compare_key and control_key, which constitute the tag data generating function.
S402, a user edits the name of the data tag and the view name of the data tag through a foreground interface;
in one example, FIG. 5 is a schematic diagram of a cash flow apportionment processing system data tag creation interface in the financial field provided by embodiments of the present application. As shown in fig. 5, the foreground interface includes a data tag query interface and an edit data tag interface. Searching an existing database RA_EDW and a data TAG corresponding to the database and named as MCA_CF_DETAIL_TMP_TAG by a user through a data TAG query interface; in the edit data TAG interface, "mca_cf_detail_tmp_tag" is filled in after the "TAG Code" item, "cash flow body table" is filled in after the "TAG CN NAME" item, "mca_cf_detail_tmp_tag" is filled in after the "TAG EN NAME" item, the data TAG is named in chinese and english, respectively, and the program names the data tagged as "mca_cf_detail_tmp_tag" as "cash flow body table" and "mca_cf_detail_tmp_tag", respectively; the "MCA" is selected in the "Schema Name" item, and the "View Name" item fills in the "mca_cf_detail_tmp_tag_v" and the program names the View generated from the data TAG as "mca_cf_detail_tmp_tag_v".
In one example, the foreground interface is implemented based on WEB technology, and the program functions are implemented based on SQL Script, or on VB Script.
S403, the program defines a dimension table associated with the source table and a mapping rule between the source table and the target table, and generates a target data generation and loading function;
s404, the user selects source data to be registered through a foreground data source registration interface;
in one example, FIG. 6 is a schematic diagram of a flexible data source registration interface in the financial field provided by embodiments of the present application. As shown in FIG. 6, the foreground interface includes a flexible data source registration query interface and an edit flexible data source interface. In a flexible data source registration query interface, selecting a source table MCA_CF_DETAIL_TMP_V in a database RA_EDW; filling in a 'Registration CN Name' item in the editing flexible data source interface, filling in a 'mca_cf_detail_tmp_v' item in a 'Registration EN Name' item, and selecting a 'Object' in a 'Category' item; fill in "MCA_CF_DETAIL_TMP_V" in "Registration EN Name" item; selecting "Source" in the "Family" item; the "Tag" is selected in the "Entity" item, and the "Monthly (YYYYMM)" is selected in the "Date Format" item.
In one example, the "cash flow body source table" is filled in the item "Registration CN Name", and the chinese name of the tag data to be registered as the target data is named "cash flow body source table"; selecting "Object" in the "Category" item, such that the cash flow is represented in a specific numerical form in the dimension table; at the "Family" item select "Source", the program generates a dimension table associated with the cash body Source table; the dimension table can be regarded as a star model, comprises non-variable entity data with the same attribute, such as company names, contract names and the like, and provides convenience for flexible access of programs; the item "Date Format" selects "Monthly (YYYYMM)" so that the target data is output in units of months.
In one example, "Base" may be selected in the "Category" item so that the cash flow is represented in percentage form in the source table, the "Target" item selects "Family" so that the program does not generate a dimension table associated with the cash body source table, directly loads source data from the cash body source table into the Target table, and the "Date Format" item selects "Daily (YYYYMMDD)" so that the data is output in units of Date, wherein the Target table may include non-variable data and variable data such as the number of cash.
S405, a user applies a data source to a functional program through a foreground allocation interface;
in one example, FIG. 7 is a schematic diagram of a data source loading into cash flow splitting rules interface in the financial field provided by embodiments of the present application. In fig. 7, a column "Allocation Object" is selected, a source table named "cash flow topic source table" is selected in the "Object" item, a "PTD-CURRENT" is selected in the "Object Amount Type" item, and data in the source table named "cash flow topic source table" is loaded into the cash flow allocation rule.
S406, the program calls a tag data generating function, and corresponding data is taken out from the database to generate tag data;
in one example, the program invokes a TAG data generating function and adds a unified data TAG mca_cf_detail_tmp_tag to the data, generating TAG data named mca_cf_detail_tmp_tag.
S407, the program calls a target data generating and loading function to generate target data, and loads the target data into a target table.
In one example, the splitting program internally invokes a mapping function between the dimension table and the target table, extracts the splitting data from the dimension table and loads the splitting data into the target table. Wherein, the partial structure of the target table is shown in the following table:
TABLE 1
Wherein:
"PERIOD" may comprise: month of January, month of February, month of January, month of April, month of July, month of September, month of October, month of Ten January, and month of Ten February;
"COMPANY_KEY" may include: company a, company B, and company C;
"CONTRACT_KEY" may include: contract No. 1, contract No. 2, and contract No. 3.
The "mac_command_t" in the "Reference Table" Column is the Column Name of the dimension Table associated with the "command_key" in the "Column Name" Column, the "CMC" in the "Reference Table Code" Column is the Column Name of the dimension Table associated with the "command_key" in the "Column Name" Column, and the "CMC" in the "Target Column" Column is the Column Name of the Target Table associated with the "command_key" in the "Column Name" Column. Hereinafter, the description thereof will be omitted.
The access method provided by the embodiment of the application defines access logic and data conversion logic through a program, and generates a tag data generating function according to the access logic and the data conversion logic; the program generates a dimension table according to the dimension table associated with the source table; the program defines a mapping rule between a source table and a target table, and generates a target data generating and loading function according to the mapping rule between the source table and the target table; the program calls a tag data generating function to generate tag data; the program calls the target data generating and loading function to generate target data and load the target data into the target table, so that decoupling of the access logic and the functional program is realized, a unified access function and a data loading function are provided, flexible access can be realized only by modifying interface configuration when the access requirement changes, the multiplexing degree and maintainability of codes are improved, and the labor cost is reduced.
Fig. 8 is a schematic structural diagram of a first fetching device according to an embodiment of the present application, as shown in fig. 8, the fetching device may include: the generation module 810 and the loading module 820. Wherein:
a generating module 810, configured to generate a tag data generating function according to the fetch logic and the data conversion logic;
the generating module 810 is further configured to generate a dimension table according to the dimension table associated with the source table;
the generating module 810 is further configured to generate a target data generating and loading function according to a mapping rule between the source table and the target table;
the generating module 810 is further configured to call the tag data generating function to generate tag data;
the generating module 810 is further configured to call the target data generating and loading function, and map the tag data to target data;
and the loading module 820 is used for loading the target data into a target table.
It can be understood that the functions of each functional module of the management apparatus according to the embodiments of the present application may be implemented by each step of the method embodiment shown in fig. 2 to fig. 7, and the specific implementation process may refer to the related description of the foregoing method embodiment, which is not repeated herein.
The access device provided by the embodiment of the application defines access logic and data conversion logic through a program, and generates a tag generation function according to the access logic and the data conversion logic; program defining a dimension table associated with a source table, and generating the dimension table step by step; the program defines a mapping rule between a source table and a target table, and generates a target data generating and loading function according to the mapping rule between the source table and the target table; the program calls a tag data generating function to generate tag data; the program calls the target data generating and loading function to generate target data and load the target data into the target table, so that decoupling of the access logic and the functional program is realized, a unified access function and a data loading function are provided, flexible access can be realized only by modifying interface configuration when the access requirement changes, the multiplexing degree and maintainability of codes are improved, and the labor cost is reduced.
Fig. 9 is a schematic structural diagram of a second fetching device according to an embodiment of the present application, as shown in fig. 9, the fetching device may include: a processor 910, a memory 920, and a transceiver 930. Wherein:
the processor 910 may be a central processing unit (central processing unit, CPU), or a combination of CPU and hardware chips. The hardware chip may be an application-specific integrated circuit (ASIC), a programmable logic device (programmable logic device, PLD), or a combination thereof. The PLD may be a complex programmable logic device (complex programmable logic device, CPLD), a field-programmable gate array (field-programmable gate array, FPGA), general-purpose array logic (generic array logic, GAL), or any combination thereof.
Memory 920 is used to store various applications, operating systems, and data. Memory 920 may transfer stored data to processor 910. The memory 920 may include volatile memory such as nonvolatile dynamic random access memory (nonvolatile random access memory, NVRAM), phase change RAM (PRAM), magnetoresistive RAM (MRAM), etc., and may also include nonvolatile memory such as at least one magnetic disk storage device, electrically erasable programmable read only memory (electrically erasable programmable read-only memory, EEPROM), flash memory device such as flash memory (NOR flash memory) or flash memory (NAND flash memory), semiconductor device such as Solid State Disk (SSD), etc. Memory 920 may also include combinations of the above types of memory.
It is to be appreciated that the memory 920 may be integrated within the processor 910 or may exist separately.
The working process of each device is as follows:
a processor 910 for generating a tag data generating function according to the fetch logic and the data conversion logic;
the processor is also used for generating a target data generation and loading function according to the mapping rule between the source table and the target table;
a processor 910 further configured to generate a dimension table from the dimension table associated with the source table;
the processor 910 is further configured to call the tag data generating function to generate tag data;
the processor 910 is further configured to invoke the target data generating and loading function to map the tag data into target data.
A transceiver 930 for receiving information input by a user.
Optionally, the processor 910 is further configured to load the target data into a target table.
It can be understood that the functions of each functional module of the management apparatus according to the embodiments of the present application may be implemented by each step of the method embodiment shown in fig. 2 to fig. 7, and the specific implementation process may refer to the related description of the foregoing method embodiment, which is not repeated herein.
The taking device provided by the embodiment of the application can be arranged in a Terminal (Terminal), for example, can be an LPA in the Terminal. The terminal may also be called a system, subscriber unit, subscriber station, mobile station, remote terminal, mobile device, user terminal, mobile terminal, wireless communication device, user agent, user device, or User Equipment (UE). For example, the terminal may be a cellular telephone, a cordless telephone, a session initiation protocol (Session Initiation Protocol, SIP) phone, a wireless local loop (Wireless Local Loop, WLL) station, a personal digital assistant (Personal Digital Assistant, PDA), a handheld device having wireless communication capabilities, a computing device, an in-vehicle communication module, a smart meter, a smart home device, or other processing device connected to a wireless modem.
The method and the device for fetching the data provided by the embodiment of the application define fetch logic and data conversion logic through programs, and generate a tag data generating function according to the fetch logic and the data conversion logic; the program generates a dimension table according to the dimension table associated with the source table; the program defines a mapping rule between a source table and a target table, and generates a target data generating and loading function according to the mapping rule between the source table and the target table; the program calls a tag data generating function to generate tag data; the program calls the target data generating and loading function to generate target data and load the target data into the target table, so that decoupling of the access logic and the functional program is realized, a unified access function and a data loading function are provided, flexible access can be realized only by modifying interface configuration when the access requirement changes, the multiplexing degree and maintainability of codes are improved, and the labor cost is reduced.
In embodiments of the present application, the communication bus may include a power bus, a control bus, a status signal bus, and the like in addition to the data bus. For clarity of illustration, however, the various buses are labeled as communication buses in the figures.
Those of ordinary skill in the art will appreciate that the modular units and algorithm steps described in connection with the embodiments disclosed herein may be embodied in electronic hardware, in computer software, or in a combination of the two, and in order to provide a thorough explanation of the interchangeability of hardware and software, various illustrative components and steps have been described above generally in terms of functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application is essentially or a part contributing to the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely illustrative of the present application, and the present application is not limited thereto, and any person skilled in the art will readily recognize that variations or substitutions are within the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (7)
1. A method of fetching comprising:
program definition fetch logic and data conversion logic, and generating a tag data generating function;
the program calls a tag data generating function to generate tag data;
the program generates a dimension table, wherein the program generates the dimension table by defining a dimension table associated with a source table,
the program generates a target data generating and loading function according to the mapping rule between the source table and the target table;
the program calls the target data generating and loading function to map the tag data into target data;
the source table is a table of the tag data, and when the tag data is mapped into target data, the target data is proposed from the dimension table associated with the source table.
2. The method of claim 1, wherein after the program invokes a target data generation and loading function to map the tag data to target data, the method further comprises:
the program loads the target data into the target table.
3. A pick-up device, the device comprising:
the generating module is used for generating a tag data generating function according to the fetch logic and the data conversion logic;
the generating module is further used for generating a dimension table according to the dimension table associated with the source table;
the generating module is also used for generating a target data generating and loading function according to the mapping rule between the source table and the target table;
the generating module is also used for calling the tag data generating function to generate tag data;
the generating module is further used for calling the target data generating and loading function and mapping the tag data into target data;
the loading module is used for loading the target data into a target table;
the source table is a table of the tag data, and when the tag data is mapped into target data, the target data is proposed from the dimension table associated with the source table.
4. A pick-up device, the device comprising: a processor, a memory, and a transceiver; wherein:
the processor is used for generating a tag data generating function according to the fetch logic and the data conversion logic;
the processor is also used for generating a target data generation and loading function according to the mapping rule between the source table and the target table;
the processor is further configured to generate a dimension table according to a dimension table associated with the source table;
the processor is also used for calling the tag data generating function to generate tag data;
the processor is further used for calling the target data generation and loading function and mapping the tag data into target data;
the transceiver is used for receiving information input by a user;
the source table is a table of the tag data, and when the tag data is mapped into target data, the target data is proposed from the dimension table associated with the source table.
5. The apparatus of claim 4, wherein the processor is further configured to load the target data into a target table.
6. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the method according to claim 1.
7. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the method according to claim 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710785633.1A CN110019442B (en) | 2017-09-04 | 2017-09-04 | Method and device for fetching number |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710785633.1A CN110019442B (en) | 2017-09-04 | 2017-09-04 | Method and device for fetching number |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110019442A CN110019442A (en) | 2019-07-16 |
| CN110019442B true CN110019442B (en) | 2023-10-13 |
Family
ID=67186197
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710785633.1A Active CN110019442B (en) | 2017-09-04 | 2017-09-04 | Method and device for fetching number |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019442B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111597243B (en) * | 2020-05-15 | 2023-09-15 | 中国工商银行股份有限公司 | Method and system for abstract data loading based on data warehouse |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093493A (en) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | Speech conversion method for database inquiry, converter, and database inquiry system |
| CN102004744A (en) * | 2009-09-02 | 2011-04-06 | 中国银联股份有限公司 | Data extraction system and method from one source table to table of at least one object database |
| CN102508706A (en) * | 2011-11-18 | 2012-06-20 | 北京航空航天大学 | Multi-source data integrating platform and establishing method thereof |
| CN104615637A (en) * | 2014-11-20 | 2015-05-13 | 广州杰赛互教通信息技术有限公司 | Data exchange method and data exchange intermediate device |
| CN105589968A (en) * | 2015-12-25 | 2016-05-18 | 中国银联股份有限公司 | Data summarization system and method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1934721A2 (en) * | 2005-09-23 | 2008-06-25 | Business Objects, S.A. | Apparatus and method for data profile based construction of an extraction, transform, load (etl) task |
-
2017
- 2017-09-04 CN CN201710785633.1A patent/CN110019442B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093493A (en) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | Speech conversion method for database inquiry, converter, and database inquiry system |
| CN102004744A (en) * | 2009-09-02 | 2011-04-06 | 中国银联股份有限公司 | Data extraction system and method from one source table to table of at least one object database |
| CN102508706A (en) * | 2011-11-18 | 2012-06-20 | 北京航空航天大学 | Multi-source data integrating platform and establishing method thereof |
| CN104615637A (en) * | 2014-11-20 | 2015-05-13 | 广州杰赛互教通信息技术有限公司 | Data exchange method and data exchange intermediate device |
| CN105589968A (en) * | 2015-12-25 | 2016-05-18 | 中国银联股份有限公司 | Data summarization system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110019442A (en) | 2019-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20060136810A1 (en) | Electronic form generator | |
| US7194485B2 (en) | Mapping XML schema components to qualified java components | |
| CN111708589B (en) | Information processing system, method, device and readable storage medium | |
| CN108279987A (en) | The method for edition management and device of application program | |
| CN112099972B (en) | Office file processing method, device and equipment based on RPA robot | |
| CN111859470A (en) | Business data chaining method and device | |
| CN105488125A (en) | Page access method and apparatus | |
| CN104834860A (en) | Dynamic warehousing method for security events | |
| CN111797073A (en) | Database management method, electronic device, and computer-readable storage medium | |
| CN113704307A (en) | Data query method, device, server and computer readable storage medium | |
| CN112667733A (en) | Data warehouse data importing method and system | |
| CN108345691B (en) | Data source general processing framework construction method, data source processing method and device | |
| WO2021252848A1 (en) | Techniques to facilitate a migration process to cloud storage | |
| CN112364083A (en) | Data dictionary management method, system and storage medium based on configuration file | |
| CN110019442B (en) | Method and device for fetching number | |
| WO2019043462A1 (en) | Systems and methods for creating automated interface transmission between heterogeneous systems in an enterprise ecosystem | |
| CN112926008B (en) | Method, device, electronic equipment and storage medium for generating form page | |
| CN114047989A (en) | Dynamic form configuration and rendering method, system and device | |
| CN109582476B (en) | Data processing method, device and system | |
| CN109597825B (en) | Rule engine calling method, device, equipment and computer readable storage medium | |
| CN115599787A (en) | Level sub-metering method and device, electronic equipment and storage medium | |
| CN112491943A (en) | Data request method, device, storage medium and electronic equipment | |
| CN116450134A (en) | Configurable front-end control verification controller generation method and system | |
| CN114238767A (en) | Service recommendation method and device, computer equipment and storage medium | |
| CN114860362A (en) | Interface updating method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |