CN116843437A - Data generation method and device and terminal equipment - Google Patents

Abstract

The application relates to the technical field of financial data processing, in particular to a data generation method, a data generation device and terminal equipment, wherein the method comprises the following steps: obtaining channel summary data and product detail table data; the channel summary data comprises a first key field required by a target system; the product detail table data comprises a second key field required by a target system; calculating a Cartesian product of the channel summary data and the product detail table data to obtain summary data comprising a first key field and a second key field; splitting summary table data according to the configured splitting dimension to obtain target data; the split dimension corresponds to a data value corresponding to a field in the first key field or the second key field. Therefore, the application can effectively solve the problems of more workload, low working efficiency, low data reporting accuracy and the like caused by manually adjusting the account-sending mode when reporting data to the supervision system, and improves the accuracy of financial and scientific data.

Description

Data generation method and device and terminal equipment

Technical Field

The present application relates to the field of financial data processing technologies, and in particular, to a data generating method, device and terminal equipment.

Background

The accounting data generated from the accounting point of view in the current banking transaction may have various kinds of cases, for example, the financial sales channel may combine the transactions 17 days before and 17 days before into one piece of data and then send the combined data to the core system. The synthesized data comprises the following fields: channel, settlement fund account number, total amount.

The core system stores a fund transaction list, and fields contained in the fund transaction list are channels, product registration codes and product amounts.

The core system needs to report data to the supervision system, wherein the report data contains some field information, and the specific transaction amount needs to be distinguished according to the product. Such as the key contains fields for settlement funds account number, product registration code, and product amount.

In order to meet the requirements of a supervision system, in the prior art, key fields of the supervision system are manually added into a fund transaction list in a core system by adjusting an account sending mode, but the pressure of the core system is increased, the workload is increased, the working efficiency is reduced, the manual processing accuracy is low, and the application provides a data generation method, a device and terminal equipment for meeting the supervision and report requirements.

Disclosure of Invention

In view of the above, embodiments of the present application provide a data generating method, apparatus, and terminal device, which can effectively solve the problems of large workload, low working efficiency, and low accuracy of reporting data caused by manually adjusting a billing mode when reporting data to a bank supervision system.

In a first aspect, an embodiment of the present application provides a data generating method, including:

obtaining channel summary data and product detail table data; the channel summary data comprises a first key field required by a target system; the product detail table data comprises a second key field required by the target system;

calculating a Cartesian product of the channel summary data and the product detail table data to obtain summary data comprising the first key field and the second key field;

splitting the summary table data according to the configured splitting dimension to obtain target data; the split dimension corresponds to a data value corresponding to a field in the first key field or the second key field.

In some embodiments, the splitting the summary table data according to the configured splitting dimension to obtain target data includes:

searching data corresponding to each dimension in the summary table data according to the configured split dimension, and merging the data according to the number of split dimensions;

and taking the combined data as the target data.

In some embodiments, the split dimension of the configuration is obtained in the following manner:

generating a split dimension template, wherein the split dimension template comprises all split dimension options and corresponding execution split confirmation items; receiving a split dimension selected from the split dimension template according to the requirement of a target system and a corresponding execution split confirmation item;

or generating a split dimension template, wherein the split dimension template comprises split dimensions to be split; and receiving a split dimension to be split, which is configured into the split dimension template according to the requirement of the target system.

In some embodiments, the split dimension includes at least one of a date, a channel, a product, a handler;

if the split dimension comprises a product, the split dimension further comprises a product amount, and the product amount is used for correcting the sales amount of the corresponding product.

In some embodiments, the fields in the channel summary data include a channel identifier and a total amount, and further include at least one of a settlement funds account, a settlement funds account name, a funds movement direction, an opponent account name, an opponent account opening, a currency, and a subject number;

the fields in the product list data comprise date, channel identification, product type identification, processor identification and product amount.

In some embodiments, the first key field includes at least one of a settlement funds account number, a settlement funds account name, a funds flow direction, an opponent account number, an opponent account name, an opponent account row, a currency, and a subject number;

the second key field includes a product category identification and a product amount, and further includes at least one of a date, a channel identification, and a processor identification.

In some embodiments, before splitting the summary table data, further comprising:

and checking the data in the summary table data, wherein the checked content comprises at least one of non-null check, value range check and length check.

In some embodiments, before splitting the summary table data, further comprising:

and comparing and verifying the sum of the product amounts corresponding to the products with the total amount.

In a second aspect, an embodiment of the present application provides a data generating apparatus, including: the device comprises a data acquisition module, a calculation module and a splitting module;

the data acquisition module is used for acquiring channel summary data and product detail table data; the channel summary data comprises a first key field required by a target system; the product detail table data comprises a second key field required by the target system;

the computing module is used for computing a Cartesian product of the channel summary data and the product detail table data to obtain summary data containing the first key field and the second key field;

the splitting module is used for splitting the summary table data according to the configured splitting dimension to obtain target data; the split dimension corresponds to a data value corresponding to a field in the first key field or the second key field.

In a third aspect, an embodiment of the present application provides a terminal device, where the terminal device includes a processor and a memory, where the memory stores a computer program, and the processor is configured to execute the computer program to implement a data generating method provided in the first aspect of the present application.

The embodiment of the application has the following beneficial effects:

in the application, a plurality of key fields are included in the target data of the target system, but one part of the key fields is in the channel summary data, the other part of the key fields is in the product detail table data, and the channel summary data and the product detail table data have the same fields. The present application calculates the Cartesian product of the two data to obtain summary table data. And then splitting the summary table data according to the configured splitting dimension to obtain target data, and uploading the target data to the target system. Compared with the prior art, the method does not need to manually process transaction information in the accounting financial science and technology system, the obtained target data is more accurate, the financial data reporting processing time is saved, and the accuracy rate of financial reporting and the financial business efficiency in the financial science and technology system are greatly improved. In addition, the application is based on the existing data, wherein the channel summary data is the data in the set time sent by the sales channel, the product detail table data is the system itself, and the cost is not needed to develop the target data needed by the statistical target system additionally.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 shows a flow chart of a data generation method of an embodiment of the application;

FIG. 2 shows another flow chart of a data generation method of an embodiment of the present application;

fig. 3 shows a block diagram of a data generating apparatus according to an embodiment of the present application.

Description of main reference numerals:

310-a data acquisition module; 320-a computing module; 330-split module.

Detailed Description

The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments.

The components of the embodiments of the present application generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the application, as presented in the figures, is not intended to limit the scope of the application, as claimed, but is merely representative of selected embodiments of the application. All other embodiments, which can be made by a person skilled in the art without making any inventive effort, are intended to be within the scope of the present application.

The terms "comprises," "comprising," "including," or any other variation thereof, are intended to cover a specific feature, number, step, operation, element, component, or combination of the foregoing, which may be used in various embodiments of the present application, and are not intended to first exclude the presence of or increase the likelihood of one or more other features, numbers, steps, operations, elements, components, or combinations of the foregoing. Furthermore, the terms "first," "second," "third," and the like are used merely to distinguish between descriptions and should not be construed as indicating or implying relative importance.

Unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which various embodiments of the application belong. The terms (such as those defined in commonly used dictionaries) will be interpreted as having a meaning that is the same as the context of the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein in connection with the various embodiments of the application.

Some embodiments of the present application are described in detail below with reference to the accompanying drawings. The embodiments described below and features of the embodiments may be combined with each other without conflict.

In the prior art, in order to obtain target data of a supervision system in the uploading financial science and technology, data needs to be manually extracted from channel summary data and product detail table data respectively, then manually calculated and recombined, and then written into another data table. The process is complex, the workload of financial staff is increased, the working efficiency is low, the accuracy of the obtained target data is low due to manual processing, and the accuracy of the data is ensured due to strict requirements on the data in the field of financial science and technology. Therefore, the application provides the data generation method, the device and the terminal equipment, which can effectively solve the problems of more workload, low working efficiency, low data reporting accuracy and the like caused by manually adjusting the account reporting mode when reporting data to a supervision system (also commonly called as a target system) and improve the accuracy of financial and scientific data. The one data generation method is described below in connection with some specific embodiments.

Fig. 1 shows a flowchart of a data generation method according to an embodiment of the present application. The data generating method comprises the following steps:

s10, obtaining channel summary data and product detail list data. The channel summary data comprises a first key field required by a target system; the product list data comprises a second key field required by the target system.

The channel summary data is sent by the financial sales channel, and comprises a piece of data synthesized by the same channel in the period from 17 days before to 17 days before. Such as the total amount of transactions completed by all channels a during that time period. The fields in the channel summary data include channel identification (channel for short), total amount, settlement funds account name, funds movement direction, opponent account name, opponent account opening row, currency and subject number. Naturally, the channel summary data includes data values corresponding to the above fields, as shown in table 1.

Table 1 summary of channel data

The data value of some fields in the channel summary data is information required by the supervisory system, such as data corresponding to the field of the settlement fund account number. The field required by the regulatory system and corresponding to the data value located in the channel summary data is referred to as a first key field.

Further, the first key field includes at least one of a settlement fund account number, a settlement fund account number name, a fund flow direction, an opponent account number, an opponent account opening row, a currency, and a subject number. The fields specifically included in the first key field depend on the requirements of the supervisory system.

The system stores product detail table data which is a specific transaction record of each product. The fields in the product schedule data include date, channel identification (channel for short), product category identification (preferably, product registration code is used), processor identification (processor for short), and product amount. Naturally, the product detail table data includes data values corresponding to the above fields, as shown in table 2.

TABLE 2 product detail list data

The product list data also has some data values that are required by the supervisory system, such as data corresponding to the field of the product registration code. The field required by the regulatory system and corresponding to the data value located in the product detail table data is referred to as a second key field.

Further, the second key field includes a product category identifier and a product amount, and further includes at least one of a date, a channel identifier, and a processor identifier. Similarly, the fields specifically included in the second key field depend on the requirements of the supervisory system. For example, the second key field includes a handler as required, and this field is the basis of responsibility.

S20, calculating Cartesian products of the channel summary list data and the product detail list data to obtain summary list data containing the first key fields and the second key fields.

The fields contained in the channel summary data and the product detail table data are used as channels, the Cartesian product of the channel summary data and the product detail table data is calculated, the fields in the channel summary data and the product detail table data are combined to obtain summary table data, and specifically, as shown in Table 3 (all the fields are contained, and the data value schematically comprises a part):

TABLE 3 summary of the table data

All field information required by the supervision system is contained in the summary table data, namely all fields in the first key field and the second key field are contained, and the data is not required to be manually extracted from the two data of the summary table data and the product detail table data. S30, splitting the summary table data according to the configured splitting dimension to obtain target data.

And splitting the key fields and the corresponding numerical values from the summary table data according to the splitting dimension to obtain target data. Wherein the splitting dimension is a range of data values to be split. That is, the split dimension corresponds to a data value corresponding to a field in the first key field or the second key field. In particular, the split dimension includes a date, a channel, a product, a processor, and a product amount. Since some data requires some amount data to be manually corrected, the product amount is used to correct the sales amount of the corresponding product. For example, products include product C1, product C2, product C3, and the like, and the treating person includes treating person R1, treating person R2, and the like. If the transaction amount of a certain product is to be split according to the product type, or if the transaction amount of a certain product is to be split according to the processor, the splitting dimension including the product C1, the product C2, the product C3, the processor R1 and the processor R2 can be set for selection configuration according to specific requirements before splitting.

Specifically, step S30 includes searching data corresponding to each dimension in the summary table data according to the configured split dimension, and merging the data according to the number of split dimensions; and storing the combined data into the target data. For example, two splitting dimensions of the product C1 and the product C1 of the 5 month 12 day are selected, transaction records of all the product C1 of the 5 month 12 day are searched in summary table data, and data of corresponding key fields in each record of the product C1 of the 5 month 12 day are split according to key fields (a part of the first key fields and the second key fields) set by a target system according to requirements, and finally are combined into target data to form data meeting the requirements of a supervision system.

In one embodiment, the split dimension of the configuration is obtained in the following manner:

the first way is: generating a split dimension template, wherein the split dimension template comprises all split dimension options and corresponding execution split confirmation items; and receiving a split dimension selected from the split dimension template according to the requirement of the target system and a corresponding execution split confirmation item.

For example, the configuration is performed by using a visual editing interface, and all split dimensions, such as date, product number, product amount, handler, and the like, and a corresponding list of checkpoints are included on the visual editing interface.

For another example, by adopting an excel file mode, all split dimensions are written into the excel file, and if the product amount needs to be modified, the corresponding amount also needs to be configured. As shown in table 4 below, the split dimension includes a date: 20230401 channel a, product registration code: c1, product amount: 2000. treating people: fengkai, whether split: y.

Table 4 split dimension template in excel file form

The second way is: generating a resolution dimension template, wherein the resolution dimension template comprises resolution dimensions to be resolved; and receiving a split dimension to be split, which is configured into the split dimension template according to the requirement of the target system. For example, an excel file is adopted, a split dimension selected according to the requirement of a supervisory system is written into the excel file, and if the product amount needs to be modified, the corresponding amount also needs to be configured. As shown in table 5 below, the selected split dimension includes a date: 20230401 channel a, product registration code: c1, product amount: 2000. treating people: fengkai.

Table 5 split dimension template in excel file form

Date of day	Channel	Product registration code	Product amount	Human treatment
					20230401	A	C1	2000	fengkai

In one embodiment, before splitting the summary table data, in order to improve accuracy of the data, the method further includes:

and checking the data in the summary table data, wherein the checked contents comprise non-null check, value range check and length check. The non-null check and the value range check and the length check are realized by adopting a regular expression mode. And comparing and verifying the sum of the product amounts corresponding to the products with the total amount, and ensuring that the split target data is free of errors.

The following describes the data generation method according to a specific application scenario, as shown in fig. 2, including the following steps:

s210, obtaining channel summary data and product detail list data.

The summary channel data for 2023, 04, and 01 days in this application scenario are shown in table 6 below (including part of the fields):

table 6 channel summary data example (partial field)

Channel	Settlement of funds account	Total amount of money
			A	J1	10000

Product detail table data are shown in table 7 below:

table 7 product detail table data example

Date of day	Channel	Product registration code	Product amount	Human treatment
					20230401	A	C1	2000	fengkai
20230401	A	C2	6000	fengkai
					20230401	A	C3	1000	fengkai
20230401	A	C4	1000	fengkai
					20230401	B	C5	1000	wangyi

S220, calculating the Cartesian product of the channel summary data and the product detail table data to obtain a summarized data table, as shown in Table 8.

Table 8 summary table data examples

S230, configuring a split dimension.

A channel is checked as A, a product registration code is C1, artificial fengkai is processed, and whether the channel is split into yes or not is checked on a visual editing interface; the channel selection is A, the product registration codes are C3 and C4, the artificial fengkai is processed, and whether the product is split or not is judged.

S240, determining key fields according to the requirements of the target system.

For example, the key fields of the target system in this embodiment include date, channel, processor, settlement funds account, product amount, and product registration code.

S250, splitting the summary table data according to the configured splitting dimension to obtain target data.

The data of the artificial fengkai with channel a, product registration code C1, and process was split from table 7, corresponding to the first line data in table 8 below. Then, the data of the artificial fengkai are processed with channel A, product registration codes C3 and C4, corresponding to the second row data in the following Table 9.

TABLE 9 target data

The application fully utilizes the existing channel summary data and product detail table data, can obtain the data containing all key fields required by a target system through simple Cartesian product calculation, does not need to manually extract and integrate from each table, has high efficiency and high accuracy, meets the data requirements in the financial and technological field, and ensures the accuracy of the financial data. Then, by configuring the split dimension template, the data in the dimension required by the target system is quickly selected. And finally, splitting the target data according to the splitting dimension template. Compared with the mode of manually processing accounting in the prior art, the application greatly improves the accuracy and the business efficiency of financial reporting in the field of financial science and technology and saves the reporting processing time.

Fig. 3 shows a schematic structural diagram of a data generating apparatus according to an embodiment of the present application. The data generating apparatus illustratively includes: a data acquisition module 310, a calculation module 320, and a splitting module 330;

the data acquisition module 310 is configured to acquire channel summary data and product detail table data; the channel summary data comprises a first key field required by a target system; the product detail table data comprises a second key field required by the target system;

the calculating module 320 is configured to calculate a cartesian product of the channel summary data and the product detail table data to obtain summary data including the first key field and the second key field;

the splitting module 330 is configured to split the summary table data according to the configured splitting dimension to obtain target data; the split dimension corresponds to a data value corresponding to a field in the first key field or the second key field. It will be appreciated that the apparatus of the present embodiment corresponds to the data generating method of the above embodiment, and the options in the above embodiment are equally applicable to the present embodiment, so the description is not repeated here.

The present application also provides a terminal device, which exemplarily includes a processor and a memory, where the memory stores a computer program, and the processor executes the computer program, so that the terminal device performs the above-mentioned data generating method or the functions of each module in the above-mentioned data generating apparatus.

The processor may be an integrated circuit chip with signal processing capabilities. The processor may be a general purpose processor including at least one of a central processing unit (Central Processing Unit, CPU), a graphics processor (Graphics Processing Unit, GPU) and a network processor (Network Processor, NP), a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like that may implement or perform the methods, steps, and logic blocks disclosed in embodiments of the present application.

The Memory may be, but is not limited to, random access Memory (Random Access Memory, RAM), read Only Memory (ROM), programmable Read Only Memory (Programmable Read-Only Memory, PROM), erasable Read Only Memory (Erasable Programmable Read-Only Memory, EPROM), electrically erasable Read Only Memory (Electric Erasable Programmable Read-Only Memory, EEPROM), etc. The memory is used for storing a computer program, and the processor can correspondingly execute the computer program after receiving the execution instruction.

The present application also provides a readable storage medium storing the computer program for use in the above terminal device.

In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. The apparatus embodiments described above are merely illustrative, for example, of the flow diagrams and block diagrams in the figures, which illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

In addition, functional modules or units in various embodiments of the application may be integrated together to form a single part, or the modules may exist alone, or two or more modules may be integrated to form a single part.

The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a smart phone, a personal computer, a server, 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.

Claims (10)

1. A data generation method, comprising:

obtaining channel summary data and product detail table data; the channel summary data comprises a first key field required by a target system; the product detail table data comprises a second key field required by the target system;

calculating a Cartesian product of the channel summary data and the product detail table data to obtain summary data comprising the first key field and the second key field;

splitting the summary table data according to the configured splitting dimension to obtain target data; the split dimension corresponds to a data value corresponding to a field in the first key field or the second key field.

2. The method of claim 1, wherein splitting the summary table data according to the configured splitting dimension to obtain target data comprises:

searching data corresponding to each dimension in the summary table data according to the configured split dimension, and merging the data according to the number of split dimensions;

and taking the combined data as the target data.

3. The data generation method according to claim 1, wherein the split dimension of the configuration is obtained by:

generating a split dimension template, wherein the split dimension template comprises all split dimension options and corresponding execution split confirmation items; receiving a split dimension selected from the split dimension template according to the requirement of a target system and a corresponding execution split confirmation item;

or generating a split dimension template, wherein the split dimension template comprises split dimensions to be split; and receiving a split dimension to be split, which is configured into the split dimension template according to the requirement of the target system.

4. A data generation method according to claim 3, wherein the split dimension comprises at least one of date, channel, product, handler;

if the split dimension comprises a product, the split dimension further comprises a product amount, and the product amount is used for correcting the sales amount of the corresponding product.

5. The method of claim 1, wherein the fields in the channel summary data include channel identification and total amount, and further include at least one of settlement funds account, settlement funds account name, funds flow direction, opponent account name, opponent account opening, currency, and subject number;

the fields in the product list data comprise date, channel identification, product type identification, processor identification and product amount.

6. The method of claim 5, wherein the first key field comprises at least one of a settlement fund account number, a settlement fund account name, a fund flow direction, an opponent account number, an opponent account name, an opponent account opening row, a currency, and a subject number;

the second key field includes a product category identification and a product amount, and further includes at least one of a date, a channel identification, and a processor identification.

7. The data generation method according to any one of claims 1 to 6, characterized by further comprising, before splitting the summary table data:

and checking the data in the summary table data, wherein the checked content comprises at least one of non-null check, value range check and length check.

8. The data generation method according to claim 5 or 6, characterized by further comprising, before splitting the summary table data:

and comparing and verifying the sum of the product amounts corresponding to the products with the total amount.

9. A data generating apparatus, comprising: the device comprises a data acquisition module, a calculation module and a splitting module;

the data acquisition module is used for acquiring channel summary data and product detail table data; the channel summary data comprises a first key field required by a target system; the product detail table data comprises a second key field required by the target system;

the computing module is used for computing a Cartesian product of the channel summary data and the product detail table data to obtain summary data containing the first key field and the second key field;

the splitting module is used for splitting the summary table data according to the configured splitting dimension to obtain target data; the split dimension corresponds to a data value corresponding to a field in the first key field or the second key field.

10. A terminal device, characterized in that it comprises a processor and a memory, the memory storing a computer program, the processor being adapted to execute the computer program to implement the data generation method of any of claims 1-8.