Data reporting method, device, electronic device and storage medium

Abstract

The present disclosure relates to a data reporting method, device, electronic device and storage medium, and belongs to the field of data processing technology, wherein the method comprises: obtaining a target reporting task; the target reporting task comprises: a data identifier of the data to be reported; querying at least one candidate data integration table according to the data identifier to obtain a target data integration table in the at least one candidate data integration table; at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; querying the target data integration table according to the data identifier to obtain the data to be reported; performing data reporting processing according to the data to be reported; wherein the classification and integration processing of the multiple candidate data source tables ensures that one candidate data integration table includes all data under one category, thereby avoiding the situation where selected data is omitted, improving the accuracy of data selection, and improving the efficiency of data reporting.

Description

Technical Field

[0001] The present disclosure relates to the field of data processing technology, and in particular to a data reporting method, device, electronic device and storage medium. Background Art

[0002] There are currently multiple banking products distributed in multiple components; each component has its own database table to store the data of the distributed banking products. For specific reporting tasks, it is necessary to select the data to be reported from the database table of each component, and then process it before reporting.

[0003] In the above scheme, the data of bank products distributed in one component may involve some data of other bank products. For example, the data of private deposit products may contain some data of public deposit products. Therefore, when selecting data for reporting tasks, data may be missed, which reduces the accuracy of data selection and the efficiency of data reporting. Summary of the invention

[0004] The present disclosure provides a data reporting method, device, electronic device and storage medium to at least solve the problem of data omission when selecting data from the database table of each component for reporting in the related art. The technical solution of the present disclosure is as follows:

[0005] According to a first aspect of an embodiment of the present disclosure, a data reporting method is provided, the method comprising: obtaining a target reporting task; the target reporting task comprising: a data identifier of data to be reported; querying at least one candidate data integration table according to the data identifier to obtain a target data integration table from the at least one candidate data integration table; the at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; querying the target data integration table according to the data identifier to obtain the data to be reported; and performing data reporting processing according to the data to be reported.

[0006] According to a second aspect of an embodiment of the present disclosure, a data reporting device is provided, the device comprising: a first acquisition module, used to acquire a target reporting task; the target reporting task comprises: a data identifier of the data to be reported; a second acquisition module, used to query at least one candidate data integration table according to the data identifier, and acquire a target data integration table from the at least one candidate data integration table; the at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; a third acquisition module, used to query the target data integration table according to the data identifier, and acquire the data to be reported; a reporting processing module, used to perform data reporting processing according to the data to be reported.

[0007] According to a third aspect of an embodiment of the present disclosure, there is provided an electronic device, comprising: a processor; and a memory for storing instructions executable by the processor; wherein the processor is configured to execute the instructions to implement the data reporting method as described above.

[0008] According to a fourth aspect of an embodiment of the present disclosure, a storage medium is provided. When instructions in the storage medium are executed by a processor of an electronic device, the electronic device can execute the data reporting method as described above.

[0009] According to a fifth aspect of an embodiment of the present disclosure, there is provided a computer program product, comprising a computer program, wherein when the computer program is executed by a processor of an electronic device, the electronic device is enabled to execute a data reporting method as described above.

[0010] The technical solution provided by the embodiments of the present disclosure brings at least the following beneficial effects:

[0011] By obtaining the target reporting task; the target reporting task includes: data identification of the data to be reported; querying at least one candidate data integration table according to the data identification, and obtaining the target data integration table in the at least one candidate data integration table; at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; querying the target data integration table according to the data identification, and obtaining the data to be reported; performing data reporting processing according to the data to be reported; wherein, the classification and integration processing of multiple candidate data source tables ensures that one candidate data integration table includes all data under one category, thereby avoiding the situation of missing selected data, improving the accuracy of data selection, and improving the efficiency of data reporting.

[0012] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] The drawings herein are incorporated into and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the description are used to explain the principles of the present disclosure, and do not constitute improper limitations on the present disclosure.

[0014] Figure 1 is a flow chart of a data reporting method according to the first embodiment of the present disclosure;

[0015] Figure 2 is a flow chart of another data reporting method according to the second embodiment of the present disclosure;

[0016] Figure 3 is a structural schematic diagram of a data reporting device according to a third embodiment of the present disclosure;

[0017] Figure 4 The invention is a block diagram of an electronic device for executing a data reporting method. DETAILED DESCRIPTION

[0018] In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.

[0019] It should be noted that the terms "first", "second", etc. in the specification and claims of the present disclosure and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present disclosure described herein can be implemented in an order other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present disclosure. Instead, they are merely examples of devices and methods consistent with some aspects of the present disclosure as detailed in the appended claims.

[0020] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in this application are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions.

[0021] It should be noted that in the embodiments of the present disclosure, certain software, components, models and other existing solutions in the industry may be mentioned, which should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.

[0022] Figure 1 is a flow chart of a data reporting method according to the first embodiment of the present disclosure. Figure 1 As shown, the following steps are included.

[0023] In step 101, a target reporting task is obtained; the target reporting task includes: a data identifier of the data to be reported.

[0024] It should be noted that the data reporting method of the present disclosure is executed by a data reporting device. The data reporting method of the present disclosure embodiment can be executed by the data reporting device of the present disclosure embodiment, and the data reporting device of the present disclosure embodiment can be configured in any electronic device, or in any software on any electronic device, to execute the data reporting method of the present disclosure embodiment.

[0025] In the disclosed embodiment, the target reporting task may be a reporting task in at least one technical field, wherein the technical field may be at least one of the following: finance, medical health, industry and information technology, transportation, energy and environmental protection, etc.

[0026] Among them, taking the financial field as an example, the reporting tasks include deposit data reporting tasks, loan data reporting tasks, etc. Taking the medical and health field as an example, the reporting tasks include medical data reporting tasks, health data reporting tasks, etc.

[0027] In the embodiment of the present disclosure, the data identifier of the data to be reported can be represented by a value under at least one target field. Taking the deposit data reporting task in the financial field as an example, the target fields include business type, customer type, data type, etc. Business types include deposits, loans, etc. Customer types include public and private. Data types include account data, transaction data, etc.

[0028] In step 102, at least one candidate data integration table is queried according to the data identifier to obtain a target data integration table in the at least one candidate data integration table; the at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables.

[0029] In the embodiment of the present disclosure, each candidate data integration table can be obtained by integrating at least one candidate data source table. For each candidate data source table in the at least one candidate data source table, the candidate data integration table can include part and / or all of the content in the candidate data source table.

[0030] In the embodiment of the present disclosure, the process of the electronic device executing step 102 may, for example, be to query at least one candidate data integration table according to at least one target field, obtain a first candidate data integration table including numerical values ​​under each target field; and determine the first candidate data integration table as the target data integration table.

[0031] Specifically, the electronic device may first query at least one candidate data integration table according to each target field to obtain an intermediate candidate data integration table including each target field; and then query the intermediate candidate data integration table according to the numerical values ​​under each target field, and when the intermediate candidate data integration table includes the numerical values ​​under each target field, determine the intermediate candidate data integration table as the target data integration table.

[0032] Among them, the first candidate data integration table including the numerical values ​​under each target field is used as the target data integration table, so that the electronic device can select the data to be reported from the target data integration table and avoid selecting the reported data from the non-target data integration table. This can reduce the processing volume during data selection and shorten the data selection time, thereby further improving the data reporting efficiency.

[0033] The number of target data integration tables may be one or more. For example, in the financial field, at least one candidate data integration table is classified and integrated according to the deposit type, and each category involves account data and transaction data. When the target reporting task requires obtaining account data, the account data needs to be obtained from the candidate data integration table of each category. At this time, the number of target data integration tables determined to be obtained is multiple.

[0034] In an embodiment of the present disclosure, when the product involved in the data in the candidate data source is a banking product in the financial field, the candidate data integration table may, for example, include at least one of the following: a unit deposit account information table, a unit deposit transaction table, a personal deposit account information table, and a personal deposit transaction table.

[0035] Among them, the setting of the unit deposit account information table, the unit deposit transaction table, the personal deposit account information table and the personal deposit transaction table facilitates the reporting and processing of deposit transaction data and / or deposit account data, avoids omissions when selecting deposit transaction data and / or deposit account data, and thus further improves the data reporting efficiency in the financial field.

[0036] In step 103, the target data integration table is queried according to the data identifier to obtain the data to be reported.

[0037] In the embodiment of the present disclosure, the process of the electronic device executing step 103 may be, for example, determining the data including the numerical values ​​of each target field in the target data integration table as the data to be reported.

[0038] Specifically, the electronic device can determine, for each piece of data in the target data integration table, whether the data contains each target field; if it contains each target field, determine whether the value under each target field is consistent with the value under the corresponding target field in the target data integration table; if they are consistent, determine the data as data to be reported; if there is a first target field, and the value under the first target field is inconsistent with the value under the first target field in the target data integration table, ignore the data and obtain the next piece of data for judgment and processing.

[0039] In addition, if the data does not contain all target fields, for example, only contains part of the target fields, or does not contain any target field, then the data is ignored and the next data is obtained for judgment and processing.

[0040] Among them, the data including the numerical values ​​of each target field in the target data integration table is determined as the data to be reported, which can avoid using data that does not contain the numerical values ​​of all target fields as the data to be reported, thereby further ensuring the accuracy of the selected data to be reported, thereby further improving the efficiency of data reporting.

[0041] In step 104, data reporting processing is performed according to the data to be reported.

[0042] In the embodiment of the present disclosure, at least one candidate data integration table is queried according to the data identifier to obtain the data to be reported, which can ensure that the same at least one candidate data integration table is queried and processed when multiple queries are made, thereby ensuring that multiple identical tasks to be reported can select and obtain the same data to be reported, ensuring the consistency and accuracy of the data to be reported selected by each task to be reported.

[0043] In the embodiment of the present disclosure, after step 103, or before step 104, the electronic device may further perform the following process: obtaining common fields in the data to be reported and each value of the common fields; for each value of the common fields, performing statistical processing on the data to be reported including the values ​​of the common fields to obtain statistical processing results corresponding to the values ​​of the common fields; and performing data reporting processing on the statistical processing results corresponding to the values ​​of the common fields.

[0044] Among them, common fields include, for example, deposit interest rate, account status, etc. Among them, taking the deposit interest rate as an example, for each value of the deposit interest rate, statistical processing is performed on the data to be reported including the value to obtain the number of data items processed for deposits with the deposit interest rate having the value.

[0045] Among them, statistical processing is performed on the data to be reported that includes the values ​​of common fields, which can facilitate the recipient of the data to be reported to quickly conduct data verification and supervision processing based on the statistical processing results, thereby improving the verification and supervision efficiency of the data to be reported.

[0046] In summary, by obtaining the target reporting task; the target reporting task includes: data identification of the data to be reported; querying at least one candidate data integration table according to the data identification, and obtaining the target data integration table in the at least one candidate data integration table; at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; querying the target data integration table according to the data identification, and obtaining the data to be reported; performing data reporting processing according to the data to be reported; wherein, the classification and integration processing of multiple candidate data source tables ensures that one candidate data integration table includes all data under a category, thereby avoiding the situation of missing selected data, improving the accuracy of data selection, and improving data reporting efficiency.

[0047] Before querying at least one candidate data integration table according to the data identifier, the electronic device can classify and integrate multiple candidate data source tables in advance to obtain at least one candidate data integration table, so that the electronic device can directly query at least one candidate data integration table according to the data identifier, avoiding querying the candidate data source table, thereby ensuring the comprehensiveness of the selected data to be reported, thereby further improving the efficiency of data reporting. Figure 2 As shown, Figure 2 It is a flow chart of another data reporting method according to the second embodiment of the present disclosure, and the specific implementation process is as follows:

[0048] In step 201, a plurality of candidate data source tables are obtained; the candidate data source tables store data of at least one product.

[0049] It should be noted that the data reporting method of the present disclosure is executed by a data reporting device. The data reporting method of the present disclosure embodiment can be executed by the data reporting device of the present disclosure embodiment, and the data reporting device of the present disclosure embodiment can be configured in any electronic device, or in any software on any electronic device, to execute the data reporting method of the present disclosure embodiment.

[0050] In the disclosed embodiment, the target reporting task may be a reporting task in at least one technical field, wherein the technical field may be at least one of the following: finance, medical health, industry and information technology, transportation, energy and environmental protection, etc.

[0051] Among them, taking the financial field as an example, the candidate data source table may include at least one of the following: public current deposit contract account table, public time deposit contract account table, E-payment account master table, digital letter of credit information master table, private current deposit contract account table, private time deposit contract account table, public current deposit contract account integrated flow table, public time deposit contract account integrated flow table, E-payment account transaction integrated flow table, wealth management product account balance statistics table, coin purse account master table, electronic cash account basic information table, private current deposit contract account integrated flow table, private time deposit contract account integrated flow table, Dragon Payment account transaction integrated flow table, E-payment account transaction integrated flow table, electronic cash account transaction integrated flow table.

[0052] Among them, in the financial field, the data stored in the candidate data source table comes from at least one of the following products: corporate current products, corporate fixed-term products, private current products, private fixed-term products, Dragon Payment, E Payment, structured deposit products, digital letter of credit products, etc.

[0053] Among them, the candidate data source tables for data related to corporate demand products include, for example, the corporate demand deposit contract account table, the corporate demand deposit contract account integrated flow table, etc. The candidate data source tables for data related to corporate fixed-term products include, for example, the corporate fixed-term deposit contract account table, the corporate fixed-term deposit contract account integrated flow table, etc. The candidate data source tables for data related to private demand products include, for example, the private demand deposit contract account table, the private demand deposit contract account integrated flow table, etc. The candidate data source tables for data related to private fixed-term products include, for example, the private fixed-term deposit contract account table, the private fixed-term deposit contract account integrated flow table, etc.

[0054] Among them, the candidate data source tables for data involving Long Pay include, for example, the Long Pay account transaction integration flow table, the wallet account master file table, etc. The candidate data source tables for data involving E Pay include, for example, the E Pay account master file table, the E Pay account transaction integration flow table, etc. Among them, the candidate data source tables for data involving structured deposit products include, for example, the wealth management product account balance statistics table, etc. Among them, the candidate data source tables for data involving digital letter of credit products include, for example, the electronic cash account basic information table, the electronic cash account transaction integration flow table, etc.

[0055] In step 202, a classification integration strategy for multiple candidate data source tables is determined in combination with regulatory reporting requirements.

[0056] In the disclosed embodiment, the regulatory reporting requirements can be determined based on the data that needs to be reported by multiple historical reporting tasks. For example, after analyzing multiple historical reporting tasks, it is determined that the historical reporting tasks report data according to customer types. For example, some require reporting of corporate-related data, and some require reporting of private-related data, then the regulatory reporting requirements are corporate data reporting and private data reporting. The classification and integration strategy determined in combination with the regulatory reporting requirements can be classification and integration according to customer types.

[0057] For another example, after analyzing multiple historical reporting tasks, it is determined that historical reporting tasks report data according to data types. For example, some require reporting account-related data, and some require reporting transaction-related data. The regulatory reporting requirements are reporting account-related data and transaction-related data. The classification and integration strategy determined in combination with the regulatory reporting requirements can be classification and integration according to data types.

[0058] For another example, after analyzing multiple historical reporting tasks, it is determined that historical reporting tasks report data according to business types. For example, some require reporting deposit-related data, and some require reporting loan-related data. The regulatory reporting requirements are reporting deposit-related data and loan-related data. The classification and integration strategy determined in combination with the regulatory reporting requirements can be classification and integration according to business types.

[0059] The above analysis results of multiple historical reporting tasks are only used as examples for illustration and are not limited to the above analysis results.

[0060] In step 203, multiple candidate data source tables are classified and integrated according to the classification integration strategy to obtain multiple candidate data integration tables.

[0061] In the embodiment of the present disclosure, the process of the electronic device executing step 203 may, for example, be to classify multiple candidate data source tables according to the classification rules indicated by the classification integration strategy to determine the categories of the multiple candidate data source tables; for each category, integrate the data in the candidate data source table with the category to obtain a candidate data integration table.

[0062] In the embodiment of the present disclosure, when the classification and integration strategy indicates classification and integration processing according to data type and customer type, after classifying and integrating the various candidate data source tables mentioned in step 201, the candidate data integration table that can be obtained may include at least one of the following: a unit deposit account information table, a unit deposit transaction table, a personal deposit account information table, and a personal deposit transaction table.

[0063] The unit deposit account information table can be integrated based on at least one of the following candidate data source tables: the public demand deposit contract account table, the public time deposit contract account table, the E-payment account master table, the digital letter of credit information master table, the private demand deposit contract account table, and the private time deposit contract account table. The unit deposit transaction table can be integrated based on at least one of the following candidate data source tables: the public demand deposit contract account integrated flow table, the public time deposit contract account integrated flow table, and the E-payment account transaction integrated flow table.

[0064] The personal deposit account information table can be integrated based on at least one of the following candidate data source tables: the personal demand deposit contract account table, the personal time deposit contract account table, the wealth management product account balance statistics table, the E-payment account master file, the coin purse account master file, and the electronic cash account basic information table. The personal deposit transaction table can be integrated based on at least one of the following candidate data source tables: the personal demand deposit contract account integrated flow table, the personal time deposit contract account integrated flow table, the Dragon Payment account transaction integrated flow table, the E-payment account transaction integrated flow table, and the electronic cash account transaction integrated flow table.

[0065] Among them, according to the classification rules indicated by the classification integration strategy, multiple candidate data source tables are classified and processed; and then they are integrated according to categories, which can ensure that the candidate data source tables of the same category are integrated to obtain the candidate data integration tables of the corresponding categories, thereby ensuring the comprehensiveness of the data in the candidate data integration tables, and then when selecting data from the candidate data integration tables, ensuring the comprehensiveness of the selected data, thereby further improving the efficiency of data reporting.

[0066] In the embodiment of the present disclosure, the category of the candidate data source table is one or more; when the category of the candidate data source table is multiple, the candidate data source table is used to integrate to obtain multiple candidate data integration tables.

[0067] For example, the data of private deposit products may contain some data of corporate deposit products. Therefore, when the classification and integration strategy indicates to classify and integrate according to customer type and business type, the candidate data source table for storing data of private deposit products may have multiple categories, namely private deposits and corporate deposits.

[0068] Among them, one or more categories are set for the candidate data source table, and data belonging to different categories in the candidate data source table can be integrated into different candidate data integration tables, thereby further ensuring the comprehensiveness of the data in the candidate data integration table, thereby further improving data reporting efficiency.

[0069] In step 204, a target reporting task is obtained; the target reporting task includes: a data identifier of the data to be reported.

[0070] In step 205, at least one candidate data integration table is queried according to the data identifier to obtain a target data integration table in the at least one candidate data integration table; the at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables.

[0071] In step 206, the target data integration table is queried according to the data identifier to obtain the data to be reported.

[0072] In step 207, data reporting processing is performed according to the data to be reported.

[0073] It should be noted that the description of step 204 to step 207 can be referred to Figure 1 The detailed description of steps 101 to 104 in the illustrated embodiment will not be given in detail here.

[0074] In summary, by obtaining multiple candidate data source tables; storing data of at least one product in the candidate data source table; determining the classification and integration strategy of multiple candidate data source tables in combination with regulatory reporting requirements; classifying and integrating multiple candidate data source tables according to the classification and integration strategy to obtain multiple candidate data integration tables; obtaining target reporting tasks; the target reporting tasks include: data identification of data to be reported; querying at least one candidate data integration table according to the data identification to obtain a target data integration table in at least one candidate data integration table; at least one candidate data integration table obtained after classification and integration processing of multiple candidate data source tables; querying the target data integration table according to the data identification to obtain the data to be reported; performing data reporting processing according to the data to be reported; wherein, the multiple candidate data source tables are classified and integrated in advance to obtain at least one candidate data integration table, so that the electronic device can directly query at least one candidate data integration table according to the data identification, avoiding querying the candidate data source table, thereby ensuring the comprehensiveness of the selected data to be reported, thereby further improving the data reporting efficiency.

[0075] In order to implement the above embodiment, the embodiment of the present disclosure proposes a data reporting device.

[0076] Figure 3 is a schematic diagram of the structure of a data reporting device according to the third embodiment of the present disclosure, referring to Figure 3 The data reporting device 300 may include: a first acquisition module 301, a second acquisition module 302, a third acquisition module 303 and a reporting processing module 304.

[0077] Among them, the first acquisition module 301 is used to obtain the target reporting task; the target reporting task includes: the data identification of the data to be reported; the second acquisition module 302 is used to query at least one candidate data integration table according to the data identification, and obtain the target data integration table in the at least one candidate data integration table; the at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; the third acquisition module 303 is used to query the target data integration table according to the data identification, and obtain the data to be reported; the reporting processing module 304 is used to perform data reporting processing according to the data to be reported.

[0078] As a possible implementation method of the embodiment of the present disclosure, the device also includes: a fourth acquisition module, a determination module and a classification integration module; the fourth acquisition module is used to obtain multiple candidate data source tables; the candidate data source table stores data of at least one product; the determination module is used to determine the classification integration strategy of the multiple candidate data source tables in combination with regulatory reporting requirements; the classification integration module is used to classify and integrate the multiple candidate data source tables according to the classification integration strategy to obtain multiple candidate data integration tables.

[0079] As a possible implementation method of the embodiment of the present disclosure, the classification integration strategy indicates classification rules and performs integration processing based on the classification rules; the classification integration module is specifically used to classify the multiple candidate data source tables according to the classification rules indicated by the classification integration strategy, and determine the categories of the multiple candidate data source tables; for each category, integrate the data in the candidate data source table with the category to obtain a candidate data integration table.

[0080] As a possible implementation method of the embodiment of the present disclosure, the data identifier is represented by a numerical value under at least one target field; the second acquisition module 302 is specifically used to query the at least one candidate data integration table according to the at least one target field, and obtain a first candidate data integration table including the numerical values ​​under each of the target fields; and determine the first candidate data integration table as the target data integration table.

[0081] As a possible implementation method of the embodiment of the present disclosure, the data identification is represented by a numerical value under at least one target field; the third acquisition module 303 is specifically used to determine the data including the numerical values ​​of each target field in the target data integration table as the data to be reported.

[0082] As a possible implementation method of the embodiment of the present disclosure, the device also includes: a fifth acquisition module and a statistical processing module; the fifth acquisition module is used to obtain the common fields in the data to be reported and the respective values ​​of the common fields; the statistical processing module is used to perform statistical processing on the data to be reported including the values ​​of the common fields for each value of the common fields, and obtain the statistical processing results corresponding to the values ​​of the common fields; the reporting processing module 304 is also used to perform data reporting processing on the statistical processing results corresponding to the values ​​of the common fields.

[0083] As a possible implementation manner of the embodiment of the present disclosure, the category of the candidate data source table is one or more; when the category of the candidate data source table is multiple, the candidate data source table is used to integrate to obtain multiple candidate data integration tables.

[0084] As a possible implementation method of an embodiment of the present disclosure, the product involved in the data in the candidate data source is a bank product; the candidate data integration table includes at least one of the following: a unit deposit account information table, a unit deposit transaction table, a personal deposit account information table, and a personal deposit transaction table.

[0085] In summary, by obtaining the target reporting task; the target reporting task includes: data identification of the data to be reported; querying at least one candidate data integration table according to the data identification, and obtaining the target data integration table in the at least one candidate data integration table; at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; querying the target data integration table according to the data identification, and obtaining the data to be reported; performing data reporting processing according to the data to be reported; wherein, the classification and integration processing of multiple candidate data source tables ensures that one candidate data integration table includes all data under a category, thereby avoiding the situation of missing selected data, improving the accuracy of data selection, and improving data reporting efficiency.

[0086] Figure 4 The invention is a block diagram of an electronic device for executing a data reporting method.

[0087] like Figure 4 As shown, the electronic device 1000 includes:

[0088] The memory 1010 and the processor 1020, the bus 1030 connecting different components (including the memory 1010 and the processor 1020), the memory 1010 stores a computer program, and when the processor 1020 executes the program, the data reporting method described in the embodiment of the present disclosure is implemented.

[0089] Bus 1030 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. For example, these architectures include but are not limited to Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MAC) bus, Enhanced ISA bus, Video Electronics Standards Association (VESA) local bus and Peripheral Component Interconnect (PCI) bus.

[0090] The electronic device 1000 typically includes a variety of electronic device readable media. These media can be any available media that can be accessed by the electronic device 1000, including volatile and non-volatile media, removable and non-removable media.

[0091] The memory 1010 may also include computer system readable media in the form of volatile memory, such as random access memory (RAM) 1040 and / or cache memory 1050. The electronic device 1000 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 1060 may be used to read and write non-removable, non-volatile magnetic media ( Figure 4 not shown, usually called a "hard drive"). Although Figure 4 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 1030 via one or more data medium interfaces. The memory 1010 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present disclosure.

[0092] A program / utility 1080 having a set (at least one) of program modules 1070 may be stored, for example, in the memory 1010, such program modules 1070 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 1070 generally perform the functions and / or methods of the embodiments described in the present disclosure.

[0093] The electronic device 1000 may also communicate with one or more external devices 1090 (e.g., keyboard, pointing device, display 1091, etc.), one or more devices that enable a user to interact with the electronic device 1000, and / or any device that enables the electronic device 1000 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed through an input / output (I / O) interface 1092. Furthermore, the electronic device 1000 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) through a network adapter 1093. Figure 4 As shown, the network adapter 1093 communicates with other modules of the electronic device 1000 via the bus 1030. It should be understood that although Figure 4 Not shown, other hardware and / or software modules may be used in conjunction with electronic device 1000, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0094] The processor 1020 executes various functional applications and data processing by running the programs stored in the memory 1010 .

[0095] It should be noted that the implementation process and technical principles of the electronic device of this embodiment refer to the aforementioned explanation of the data reporting method of the embodiment of the present disclosure, and will not be repeated here.

[0096] In order to implement the above embodiments, the present disclosure also proposes a storage medium.

[0097] When the instructions in the storage medium are executed by the processor of the electronic device, the electronic device can execute the data reporting method as described above.

[0098] In order to implement the above embodiments, the present disclosure further provides a computer program product, including a computer program, which, when executed by a processor of an electronic device, enables the electronic device to execute the data reporting method as described above.

[0099] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure that follow the general principles of the present disclosure and include common knowledge or customary techniques in the art that are not disclosed in the present disclosure. The description and examples are to be considered exemplary only, and the true scope and spirit of the present disclosure are indicated by the following claims.

[0100] It should be understood that the present disclosure is not limited to the exact structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A data reporting method, characterized in that: The method comprises: Obtaining a target reporting task; the target reporting task includes: a data identifier of the data to be reported; According to the data identifier, at least one candidate data integration table is queried to obtain a target data integration table in the at least one candidate data integration table; the at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; Query the target data integration table according to the data identifier to obtain the data to be reported; Data reporting processing is performed according to the data to be reported.

2. The method according to claim 1, characterized in that The method further comprises: Acquire multiple candidate data source tables; each candidate data source table stores data of at least one product; Determine the classification and integration strategy of the multiple candidate data source tables in combination with regulatory reporting requirements; The multiple candidate data source tables are classified and integrated according to the classification and integration strategy to obtain multiple candidate data integration tables.

3. The method according to claim 2, characterized in that The classification integration strategy indicates classification rules and performs integration processing based on the classification rules; the classification and integration processing of the multiple candidate data source tables according to the classification integration strategy to obtain multiple candidate data integration tables includes: According to the classification rules indicated by the classification integration strategy, the multiple candidate data source tables are classified and processed to determine the categories of the multiple candidate data source tables; For each category, the data in the candidate data source table having the category is integrated to obtain a candidate data integration table.

4. The method according to claim 1, characterized in that: The data identifier is represented by a numerical value under at least one target field; The step of querying at least one candidate data integration table according to the data identifier to obtain a target data integration table in the at least one candidate data integration table includes: Querying the at least one candidate data integration table according to the at least one target field to obtain a first candidate data integration table including values ​​under each of the target fields; The first candidate data integration table is determined as the target data integration table.

5. The method according to claim 1 or 4, characterized in that: The data identifier is represented by a numerical value under at least one target field; The step of querying the target data integration table according to the data identifier to obtain the data to be reported includes: The data including the numerical values ​​of each of the target fields in the target data integration table are determined as the data to be reported.

6. The method according to claim 1, characterized in that After querying the target data integration table according to the data identifier to obtain the data to be reported, the method further includes: Acquire common fields in the data to be reported and values ​​of the common fields; For each value of the common field, statistical processing is performed on the data to be reported including the value of the common field to obtain a statistical processing result corresponding to the value of the common field; The statistical processing results corresponding to the values ​​of the common fields are subjected to data reporting processing.

7. The method according to claim 2 or 3, characterized in that: The category of the candidate data source table is one or more; In the case that there are multiple categories of the candidate data source table, the candidate data source table is used to integrate to obtain multiple candidate data integration tables.

8. The method according to claim 1 or 2, characterized in that: The products involved in the data in the candidate data source are banking products; The candidate data integration table includes at least one of the following: a unit deposit account information table, a unit deposit transaction table, a personal deposit account information table, and a personal deposit transaction table.

9. A data reporting device, characterized in that: The device comprises: The first acquisition module is used to acquire a target reporting task; the target reporting task includes: a data identifier of the data to be reported; A second acquisition module is used to query at least one candidate data integration table according to the data identifier to obtain a target data integration table in the at least one candidate data integration table; the at least one candidate data integration table is obtained after classification and integration processing of multiple candidate data source tables; A third acquisition module is used to query the target data integration table according to the data identifier to obtain the data to be reported; The reporting processing module is used to perform data reporting processing according to the data to be reported.

10. The device according to claim 9, characterized in that The device further comprises: a fourth acquisition module, a determination module and a classification integration module; The fourth acquisition module is used to acquire a plurality of candidate data source tables; the candidate data source tables store data of at least one product; The determination module is used to determine the classification integration strategy of the multiple candidate data source tables in combination with regulatory reporting requirements; The classification and integration module is used to classify and integrate the multiple candidate data source tables according to the classification and integration strategy to obtain multiple candidate data integration tables.

11. The device according to claim 10, characterized in that The classification integration strategy indicates classification rules and performs integration processing based on the classification rules; the classification integration module is specifically used to: According to the classification rules indicated by the classification integration strategy, the multiple candidate data source tables are classified and processed to determine the categories of the multiple candidate data source tables; For each category, the data in the candidate data source table having the category is integrated to obtain a candidate data integration table.

12. The device according to claim 9, characterized in that The data identifier is represented by a numerical value under at least one target field; the second acquisition module is specifically used to: Querying the at least one candidate data integration table according to the at least one target field to obtain a first candidate data integration table including values ​​under each of the target fields; The first candidate data integration table is determined as the target data integration table.

13. The device according to claim 9 or 12, characterized in that The data identifier is represented by a numerical value under at least one target field; the third acquisition module is specifically used to: The data including the numerical values ​​of each of the target fields in the target data integration table are determined as the data to be reported.

14. The device according to claim 9, characterized in that The device further comprises: a fifth acquisition module and a statistical processing module; The fifth acquisition module is used to acquire the common fields in the data to be reported and the values ​​of the common fields; The statistical processing module is used to perform statistical processing on the data to be reported including the value of the common field for each value of the common field, so as to obtain a statistical processing result corresponding to the value of the common field; The reporting and processing module is also used to perform data reporting and processing on the statistical processing results corresponding to the numerical values ​​of the common fields.

15. The device according to claim 10 or 11, characterized in that The category of the candidate data source table is one or more; In the case that there are multiple categories of the candidate data source table, the candidate data source table is used to integrate to obtain multiple candidate data integration tables.

16. The device according to claim 9 or 10, characterized in that The products involved in the data in the candidate data source are banking products; The candidate data integration table includes at least one of the following: a unit deposit account information table, a unit deposit transaction table, a personal deposit account information table, and a personal deposit transaction table.

17. An electronic device, characterized in that: include: processor; a memory for storing instructions executable by the processor; The processor is configured to execute the instructions to implement the data reporting method according to any one of claims 1 to 8.

18. A storage medium, when instructions in the storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the data reporting method according to any one of claims 1 to 8.

19. A computer program product, characterized in that It includes a computer program, which, when executed by a processor of an electronic device, enables the electronic device to execute the data reporting method as described in any one of claims 1 to 8.

Images