CN114565451A

CN114565451A - Batch data reporting method, device, electronic equipment and medium

Info

Publication number: CN114565451A
Application number: CN202210194418.5A
Authority: CN
Inventors: 林玉高; 潘忆恩; 郑友金
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2022-03-01
Filing date: 2022-03-01
Publication date: 2022-05-31

Abstract

The application provides a batch data reporting method which can be applied to the technical field of artificial intelligence, and the reporting method comprises the following steps: acquiring batch data M; screening first pre-reported data N which accord with the reported content from the batch data M by using a streaming computing mode according to a preset rule; formatting the first pre-reported data N to generate second pre-reported data S which accords with a reporting format; and reporting the second pre-reported data S one by utilizing the RPA. According to the batch data reporting method, on the basis of meeting the requirements of a supervision mechanism on the commercial bank account and preventing business risks, the automatic processing level of data to be reported to the supervision mechanism by a commercial bank is effectively improved, the recording efficiency of the data to be reported is greatly improved, the situations of missing, late and wrong records of the account are reduced, the supervision requirements of the supervision mechanism are met, the operation cost of the commercial bank is reduced, and the pressure of recording personnel is released.

Description

Batch data reporting method, device, electronic equipment and medium

Technical Field

The application relates to the technical field of artificial intelligence, in particular to a batch data reporting method, a batch data reporting device, electronic equipment and a medium.

Background

At present, in the annual inspection reporting work of part of commercial banks, in order to prevent the potential supervision and inspection risks such as missing record, late record, wrong record and the like, a robot is used to replace a manual input mode. According to the content needing to be supplemented in the account of the supervision organization, the robot simulates a customer service manager to log in a commercial bank system, account data to be reported are singly captured, then the account data log in an account management system of the supervision organization, and the captured account data are input into the account management system of the supervision organization.

Disclosure of Invention

The present application is directed to solving at least one of the problems in the prior art.

For example, the application provides a batch data reporting method, which can be connected with various commercial bank systems through flexible configuration of preset rules, so as to meet the personalized requirements of second pre-reported data S; and through the screening mode of stream-oriented computation, a plurality of first pre-reported data N meeting the requirements can be captured at one time, the average time consumption of reporting is greatly reduced, and the reporting efficiency is accelerated.

In order to achieve the above object, a first aspect of the present application provides a batch data reporting method, including the steps of:

acquiring batch data M;

according to a preset rule, screening first pre-reported data N meeting the reported content from the batch data M by using a streaming computing mode, wherein N belongs to M, and M is more than or equal to N;

formatting the first pre-reported data N to generate second pre-reported data S which accords with a reporting format;

and reporting the second pre-reported data S one by using the RPA.

According to the batch data reporting method, on the basis of meeting the requirements of a supervision mechanism on the commercial bank account and preventing business risks, the automatic processing level of data to be reported to the supervision mechanism by a commercial bank is effectively improved, the recording efficiency of the data to be reported is greatly improved, the situations of missing, late and wrong records of the account are reduced, the supervision requirements of the supervision mechanism are met, the operation cost of the commercial bank is reduced, and the pressure of recording personnel is released.

Further, before the first pre-reported data N meeting the report content is screened from the batch data M by using a streaming computation mode according to a preset rule, the method further includes:

and analyzing each piece of data a in the batch data M according to a preset format, wherein a belongs to M.

Further, according to a preset rule, screening out first pre-reported data N meeting the reporting content from the batch data M by using a streaming computation mode, including:

reading a preset rule, wherein the preset rule at least comprises a screening element;

extracting a field value corresponding to each screening element in each piece of data a;

and confirming the first pre-reported data N according to the field value.

Further, according to the field value, determining the first pre-reported data N includes:

when the field value accords with the preset rule, marking the field value, wherein the marks corresponding to each screening element are different;

when the field values in the data a are all marked, the data a is the first pre-reported data N.

Further, still include:

and rejecting the data a when at least one screening element in the preset rule is absent in the data a.

Further, formatting the first pre-reported data N to generate second pre-reported data S conforming to a delivery format, including:

acquiring a submission element and a format rule;

extracting a forecast sending field value corresponding to each reporting element in each piece of first pre-reported data N;

and processing the pre-reported field value according to the format rule and generating second pre-reported data S.

Further, the reporting of the second pre-reported data S by RPA one by one includes:

acquiring a second piece of pre-reported data i;

acquiring the forecast sending field value according to the second pre-reported data i;

inputting the field sending forecasting value through an RPA (resilient packet access), and generating an input result;

and after the logging result is generated, acquiring second pre-reported data i +1, wherein both i and i +1 belong to S.

Further, still include:

setting a reporting time parameter;

and awakening the RPA at regular time according to the reporting time parameter.

Further, the method also comprises the following steps:

and automatically adjusting a preset rule, a submission element and a format rule according to the input result.

Further, the batch data M includes at least one of customer information data, account information data, and business information data, where there is an association relationship among the customer information data, the account information data, and the business information data.

A second aspect of the present application provides a batch datagram delivery device, including: an acquisition module for acquiring batch data M; a screening module to: according to a preset rule, screening first pre-reported data N meeting the reported content from the batch data M by using a streaming computing mode, wherein N belongs to M, and M is more than or equal to N; a processing module to: formatting the first pre-reported data N to generate second pre-reported data S which accords with a reporting format; and the reporting module is used for reporting the second pre-reported data S one by one.

A third aspect of the present application provides an electronic device comprising: one or more processors; a memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of posting described above.

The fourth aspect of the present application also provides a computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the above-mentioned delivery method.

A fifth aspect of the present application also provides a computer program product comprising a computer program which, when executed by a processor, implements the method of posting described above.

Drawings

The foregoing and other objects, features and advantages of the application will be apparent from the following description of embodiments of the application with reference to the accompanying drawings in which:

FIG. 1 schematically illustrates an application scenario diagram of a posting method, apparatus, device, medium, and program product according to embodiments of the application;

FIG. 2 schematically illustrates a block diagram of an account annual review submission system, in accordance with an embodiment of the present application;

FIG. 3 schematically illustrates an internal block diagram of a batch data submission system, in accordance with an embodiment of the present application;

FIG. 4 schematically illustrates a flow chart of a bulk data reporting method according to an embodiment of the present application;

FIG. 5 schematically illustrates a schematic diagram of a streaming computing mode according to an embodiment of the application;

fig. 6 schematically shows a flowchart of a screening method for first pre-reported data N according to an embodiment of the present application;

fig. 7 schematically shows a flowchart of a method for acknowledging first pre-reported data N according to an embodiment of the present application;

fig. 8 schematically shows a flowchart of a method for generating second pre-reported data S according to an embodiment of the present application;

fig. 9 schematically shows a flowchart for reporting second pre-reported data S by using RPA according to an embodiment of the present application;

FIG. 10 is a schematic diagram illustrating a flow chart for setting a delivery time according to an embodiment of the application;

fig. 11 is a logical block diagram schematically illustrating a bulk data reporting method according to an embodiment of the present application;

FIG. 12 is a block diagram that schematically illustrates an arrangement of a batch data submission apparatus, in accordance with an embodiment of the present application; and

fig. 13 schematically shows a block diagram of an electronic device adapted to implement a bulk data delivery method according to an embodiment of the application.

Detailed Description

Hereinafter, embodiments of the present application will be described with reference to the accompanying drawings. It is to be understood that such description is merely illustrative and not intended to limit the scope of the present application. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the application. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present application.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. The terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It is noted that the terms used herein should be interpreted as having a meaning that is consistent with the context of this specification and should not be interpreted in an idealized or overly formal sense.

Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B and C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).

With the gradual implementation of canceling the account permission system of the commercial bank by the supervising agency, part of the business transacted by the commercial bank for the enterprise client is changed from approval to filing, and the business is required to be reported and filed in the supervising agency account management system according to different client types and account properties. The reporting and filing is a relatively fixed flow, belongs to single, repeated and tedious affairs work, and has the advantages that the average number of new 120 households of the largest commercial bank in China is increased every year, the number of accounts is large, and a large amount of manpower is required to be invested in each website to complete the reporting and filing.

Based on the low efficiency of the manual entry mode, potential supervision and inspection risks such as missed record, late record, wrong record and the like exist, at present, part of commercial banks start to adopt a robot to replace the manual entry mode in annual inspection reporting operation, but the working process of the robot is not different from that of manual work, and the robot also needs to log in a commercial bank system to search related data according to the required supplementary report content in a supervision institution account, then single capture is implemented for one account, and the captured account data is entered into the supervision institution account management system through logging in the supervision institution account management system. The method only simply utilizes the robot to replace manual operation, does not form a finished submission flow, has the defects of non-obvious efficiency improvement, single flow and poor flexibility, and fails to dynamically and efficiently classify and allocate the data to be submitted.

The account submitting mechanism is established based on the streaming computing technology and the robot process automation technology, and the processing efficiency of the batch data submitting supervision mechanism can be improved. In other words, the method and the system can be connected with various commercial bank systems through flexible configuration of the preset rules, and meet the personalized requirements of the second pre-reported data S; and through the screening mode of stream-oriented computation, a plurality of first pre-reported data N meeting the requirements can be captured at one time, the average time consumption of reporting is greatly reduced, and the reporting efficiency is accelerated.

Fig. 1 schematically illustrates an application scenario diagram of batch data submission to an associated regulatory authority using a robot according to an embodiment of the present application.

As shown in fig. 1, the application scenario 100 according to this embodiment may include a process in which, after uniformly processing batch data as required, the robot logs in an account of the relevant regulatory agency management system at the front end, and interacts with a server of the relevant regulatory agency management system using a network. The network 104 serves as a medium for providing communication links between the

terminal devices

101, 102, 103 and the server 105. Network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.

The robot may use the

terminal devices

101, 102, 103 to interact with a server 105 over a network 104 to receive or send messages or the like.

The

terminal devices

101, 102, 103 may be various electronic devices having display screens and supporting web browsing, including but not limited to smart phones, tablets, laptop portable computers, and desktop computers.

The server 105 may be a server providing various services, such as a business management server (for example only) providing support for the robot to utilize the second pre-reported data S sent by the

terminal devices

101, 102, 103. The service management server may analyze and process the received second pre-reported data S, and feed back a processing result to the terminal device, for example, feed back success information when the reception is successful, and feed back failure information when the reception is failed.

It should be understood that the number of terminal devices, networks, and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

It should be noted that the batch data reporting method of the present application is an explanation based on an interaction scenario of a financial institution, and particularly, an explanation is performed on an embodiment in which annual inspection data of an enterprise account of a commercial bank is reported to a relevant regulatory institution in batch, but the explanation is not intended to limit the technical solution of the present application.

The account annual review reporting system according to the embodiment of the application will be described in detail below with reference to fig. 2 to 11 based on the scenario described in fig. 1.

FIG. 2 schematically shows a block diagram of an account annual survey reporting system according to an embodiment of the application.

As shown in fig. 2, the account annual inspection reporting system includes five components, which are an enterprise-level customer information system, an enterprise account basic service system, an industrial and commercial information system, a batch data reporting system, and a regulatory agency account management system.

The batch data reporting system is respectively connected with the enterprise-level customer information system, the enterprise account basic service system, the industrial and commercial information system and the supervision institution account management system. The method only improves the flow of the batch data reporting system, the enterprise-level customer information system, the enterprise account basic service system and the industrial and commercial information system can provide a source of batch data M, and the supervision agency account management system is a report object of the robot.

The specific functions of each system are as follows:

the enterprise-level customer information system is mainly responsible for receiving, storing, maintaining and analyzing customer information data, and the batch data which can be provided to the batch data delivery system comprises data such as customer names, business license numbers, organization code certificate numbers and the like.

The enterprise account basic service system is mainly responsible for receiving, storing, maintaining and analyzing account information data, and batch data which can be provided to the batch data submission system comprises account medium number, account opening date, account attribute, account type and other data.

The industrial and commercial information system is mainly responsible for receiving and storing industrial and commercial information data, and the batch data provided by the batch data submission system comprises data such as enterprise operation range, registered address, registered fund and the like.

The batch data submission system is mainly responsible for receiving data provided by an existing business system (such as an enterprise-level customer information system, an enterprise account basic business system, and an industrial and commercial information system), and after corresponding processing, the batch data submission system is in butt joint with an account management system of a regulatory agency to complete batch submission of annual inspection data of an enterprise account, and a specific internal structure is shown in fig. 3.

The administrator account management system is mainly responsible for interfacing with each large commercial bank system (such as a batch data reporting system), receiving and storing information such as account opening, account selling, fund transfer and the like of each bank, and feeding back processing results to the interfaced bank systems after receiving the information.

The interaction of the systems is the existing interaction mode, after a worker or a robot usually logs in a batch data reporting system, related data needing to be reported is inquired and collected from an enterprise-level customer information system, an enterprise account basic service system and an industrial and commercial information system, then the related data needing to be reported logs in a supervision institution account management system, the collected related data needing to be reported is submitted and recorded into the supervision institution account management system, and the supplement of missing data is completed. However, potential supervision and inspection risks such as missing record, late record, wrong record and the like can occur when the staff report the risks by themselves, so that the staff are replaced by the robot, the non-invasive butt joint supervision mechanism account management system is adopted, the original technical framework of the supervision mechanism account management system cannot be damaged, and meanwhile, the human resources are saved.

The internal structure of the batch data submission system is shown in fig. 3, and mainly includes a submission parameter maintenance unit, a data acquisition unit, an automatic data screening unit, a submission element processing unit, and an automatic submission unit. The connection relationship of each unit is shown in fig. 3, and the specific functions are as follows:

the report parameter maintenance unit is mainly responsible for collecting and storing preset rules, report elements, format rules and the like used by other modules in the batch data report system and method, and parametrically pushing information such as report elements, formats, report windows and the like to the corresponding data collection unit, data automatic screening unit, report element processing unit and automatic report unit so that the units can process the obtained batch data according to the preset rules and parameters of the report parameter maintenance unit.

The data acquisition unit is mainly responsible for acquiring information data from peripheral business systems (such as an enterprise-level customer information system, an enterprise account basic business system and an industrial and commercial information system) as required and then sending information data screening notifications to the automatic data screening unit.

The data automatic screening unit is mainly responsible for screening the information data acquired by the data acquisition unit according to the delivery data screening rule maintained by the delivery parameter maintenance unit. After the information data satisfying the provision condition is screened out, a processing notification of the information data satisfying the provision condition is sent to the provision element processing unit.

The submission element processing unit is mainly responsible for processing the information data to be submitted, which is screened by the automatic data screening unit, and extracting the field information to be input in the account management system of the supervision institution for formatting processing according to the field submission format maintained by the submission parameter maintenance unit.

The automatic reporting unit starts the robot at regular time and logs in a supervision institution account management system in a non-invasive mode according to the reporting time window and the frequency parameter maintained by the reporting parameter maintenance unit, and processes the information to be reported after the processing of the reporting element processing unit one by one.

Based on fig. 1-3, fig. 4 schematically shows a flow chart of a batch data transmission method according to an embodiment of the present application.

As shown in fig. 4, this embodiment includes operations S210 to S240.

In operation S210, batch data M is acquired.

And acquiring pushed information data of each peripheral service system, receiving the data in a general way such as a network and caching the data to the local.

The batch data M comprises at least one of customer information data, account information data and business information data, wherein the customer information data, the account information data and the business information data have an incidence relation.

It can be understood that the information data in the enterprise-level customer information system, the enterprise account basic service system and the business information system in fig. 2 is obtained, and the information data in one of the systems may be obtained, or the information data in a plurality of systems may be obtained. For example, only the account information data in the basic business system of the enterprise account can be collected, and the account information data comprises a customer number, an account medium number, an account opening date, account attributes and an account type.

Of course, there is a correlation between the customer information data, the account information data, and the business information data, and one of the customer information data, the account information data, and the business information data may be correlated to the other two items by acquiring the other one.

In one embodiment, a customer number is collected from an enterprise account basic business system, and can be related to enterprise information such as enterprise certificates, legal persons, beneficiaries and the like in an enterprise-level customer information system through the customer number, and then is related to enterprise business operation information in an enterprise business information system through the enterprise certificates.

In operation S220, according to a preset rule, a first pre-reported data N meeting the submission content is screened from the batch data M by using a streaming computation mode, where N belongs to M, and M is greater than or equal to N.

A data stream refers to a series of dynamic data aggregates that are infinite in time distribution and quantity, with the value of the data decreasing over time. The stream computing can be used for processing data streams, belongs to real-time computing, has the characteristics of low delay, dynamic data computation, no boundary and continuity, and is suitable for scenes with higher timeliness requirements in the figure 1 of the application.

Streaming computing logic as shown in fig. 5, the first column is raw data, the second column to the second last column are one or more computing nodes, each of which contains one or more filter elements, and the last column is filtered output data.

In combination with the streaming computation logic diagram, the method screens the preprocessed batch data M, the batch data M is original data, the preset rules are put into each computation node according to the preset rules issued by the reporting parameter maintenance unit, and after the screening, the output data is the first pre-reported data N meeting the reporting content.

It can be understood that the first pre-reported data N conforming to the delivery content is the first processing operation for the robot to complete the information delivery, the screened first pre-reported data N is the related account of the part of the data information missing by the monitoring authority, and the data missing by the delivery can be received by the monitoring authority account management system of the monitoring authority of each part.

In operation S230, the first pre-reported data N is formatted to generate second pre-reported data S conforming to the delivery format.

Since the reporting formats (e.g., reporting requirements, message formats, and message fields) of the respective monitoring authorities are different, the first pre-reported data N needs to be formatted, and the processed second pre-reported data S can be received by the monitoring authority account management systems of the respective monitoring authorities only if the second pre-reported data S meets the reporting requirements of the respective monitoring authorities.

It can be understood that the formatting of the first pre-reported data N is a second processing operation performed on the reported data, and the formatted second pre-reported data S is a format acceptable by the relevant regulatory agency.

The method can be used for carrying out dynamic adaptive formatting processing on the first pre-reported data N to generate the second pre-reported data S which accord with the reporting formats of the supervision authorities of all the places, so that the reporting method has universality.

The submission method of the application further comprises the following steps: and automatically adjusting the preset rule, the submission element and the format rule according to the input result.

In one embodiment, the submission parameters in the submission element processing unit can be automatically updated according to the analysis of the customer data, the account information and the business situation data, so as to meet the submission requirements of the supervision authorities of various parties.

In operation S240, the second pre-reported data S is reported one by using the RPA.

Robot Process automation technology, rpa (robotic Process automation), is a software solution that uses intelligent software to simulate and enhance the interaction Process between a person and a computer and execute repeatable tasks based on certain rules.

The robot can log in the supervision agency account management system, input the missing data (second pre-reported data S) in the supervision agency one by one, and submit the data after completing the input. The method and the system are combined with the robot, normal manual operation of workers can be simulated, such as mouse clicking, pull-down selection, keyboard input and the like, seamless and non-invasive butt joint of the supervision agency account management system is achieved, and the original technical framework of the supervision agency account management system cannot be damaged.

It should be noted that non-intrusive refers to submission to the regulatory agency account management system by way of direct analog entry without code modification.

In order to facilitate mode screening by using streaming computation, the acquired batch data M needs to be preprocessed before the first pre-reported data N meeting the report content is screened from the batch data M by using the mode of streaming computation according to a preset rule.

Specifically, each piece of data a in the batch data M is parsed according to a preset format, wherein a belongs to M. For example, each piece of data a is parsed in a fixed format, for example, the date is parsed into a format of YYYY-MM-DD, and the time stamp is parsed into a format of YYYY-MM-DD hh MM: ss.

The batch data M is processed for the first time and the second time to obtain the second pre-reported data S meeting the reporting requirement and capable of being received by the relevant regulatory agency, and the operation S220 and the operation S230 will be further explained with reference to fig. 6 to 8.

Fig. 6 schematically shows a flowchart of a screening method for first pre-reported data N according to an embodiment of the present application.

As shown in fig. 6, this embodiment includes operations S310 to S330.

In operation S310, a preset rule is read, where the preset rule includes at least one filtering element.

Reading and analyzing a preset rule from the reporting parameter maintenance unit to serve as a screening rule, wherein the screening rule at least comprises one screening element. For example, the screening rule is: the account opening date is xx and the account attributes are basic and the account type is an approval class. In the above example, there are three filtering elements, respectively, date of opening, account attributes, and account type.

In operation S320, a field value corresponding to each filtering element in each piece of data a is extracted.

Extracting field values in each data a according to the screening elements in the preset rule, for example, extracting field values corresponding to the account date, the account attribute and the account type in each data a.

In operation S330, the first pre-reported data N is confirmed according to the field value.

The extracted field value in each piece of data a is compared with a preset rule, and whether the extracted field value is the first pre-reported data N meeting the reporting condition can be identified through marking.

In one embodiment, the entries are marked when they are identical and are unmarked when at least one entry is different. The embodiment is suitable for a plurality of screening elements and distributed in scenes of different computing nodes, and when the field values corresponding to all the screening elements are the same as the preset rule, the screening elements are marked with symbols, namely, the screening elements are identified as first pre-reported data N meeting the reporting condition; and when the field value corresponding to one of the screening elements is different from the preset rule, the data is identified as data which does not need to be reported without a mark. Therefore, only the data a with the mark is processed when the report element processing unit processes the report element.

In another embodiment, each filter element corresponds to a different tag, the tag belonging to the filter element is tagged when the field value corresponding to the filter element is the same as the preset rule, and no tag is generated when the field value corresponding to the filter element is different from the preset rule. When the report element processing unit processes, only the data a with the marks of all the filter elements is processed. For example, three screening elements correspond to three kinds of marks, and the first pre-reported data N meeting the reporting condition is data a with the three kinds of marks.

Further, fig. 7 schematically shows a flowchart of a method for confirming the first pre-reported data N according to an embodiment of the present application.

As shown in fig. 7, this embodiment includes operations S410 to S420.

With reference to fig. 5, the preset rule is to extract three patterns, i.e., squares, diamonds and circles, and to select colorless patterns. The screening elements in the figure are shapes and colors, and the field values of the screening elements are square colorless, square gray, square black, diamond colorless, diamond gray, diamond black, circle colorless, circle gray and circle black.

Each calculation node is a judgment rule, and according to the preset rule, the calculation node 1 is set to screen out three patterns of a square, a diamond and a circle, and the calculation node 2 is set to screen out three patterns of a square colorless, a diamond colorless and a circle colorless. In the calculation process, at the calculation node 1, the field values of the shapes of the squares, the diamonds and the circles in the original data are marked, and at the calculation node 2, the field values marked by the calculation node 1, which are provided with the squares, the diamonds and the circles, are screened in a way that the field values of the colors are colorless, so that the result meeting the preset rule is finally obtained.

In operation S410, when the field value meets a preset rule, the field value is labeled, wherein the label corresponding to each filtering element is different.

Different marks are used as marks of different screening elements, corresponding marks are marked on corresponding field values after each calculation, data which accord with preset rules can be rapidly distinguished according to the marks, and the data marked with the corresponding marks can be further screened.

In operation S420, when all the field values in the data a are marked, the data a is the first pre-reported data N.

And checking each field value in the data a, and when all the field values corresponding to the screening elements are marked, the data a is the first pre-reported data N.

The above embodiment has a plurality of computing nodes, and further screening is performed according to the marked data of the computing nodes in the previous link. In an embodiment where there is only one compute node to filter multiple items, the filtering may be implemented by culling data a in the absence of at least one filter element in a preset rule in data a.

Fig. 8 schematically shows a flowchart of a method for generating second pre-reported data S according to an embodiment of the present application.

As shown in fig. 8, the embodiment may perform formatting on the first pre-reported data N, including operations S510 to S530.

In operation S510, a submission element and a format rule are acquired.

The reporting element and the format rule are formulated by the regulatory authorities of all parts, when the information data is reported to the account management system of the regulatory authority of the relevant regulatory authority, the reported information data needs to be formatted into the data allowing the reporting, and the reporting element and the format rule need to be acquired in the reporting parameter maintenance unit before the reporting.

In operation S520, a forecast sending field value corresponding to each reporting element in each piece of first pre-reported data N is extracted.

And identifying a delivery element from each piece of first pre-reported data N, and correspondingly extracting a delivery field value. For example, the forecast sending field value corresponding to the account opening date is extracted as the forecast sending element in each piece of first pre-reported data N.

In operation S530, the pre-reported field value is processed according to the format rule, and second pre-reported data S is generated.

Formatting the forecast sent field value according to the format of the sent field, such as character, number, date, etc., wherein the date format is YYYY-MM-DD, and the time format is hh MM ss.

It should be noted that the filtering element is a limiting condition for filtering the batch data M, the reporting element is a limiting condition for the first pre-reported data N, and the contents of the filtering element and the reporting element may be the same or different. For example, the screening elements and the field values can be used as dates xx in the batch data M to obtain first pre-reported data N, then the reporting elements and the forecasting field values are extracted from the first pre-reported data N to be data with account attributes being basic users, and formats of the basic users are processed; the screening elements and the field values can be used as dates xx in the batch data M to obtain first pre-reported data N, then data with the reporting elements and the reporting field values being the dates xx are extracted from the first pre-reported data N, and the date formats of the dates xx are processed.

Fig. 9 schematically shows a flowchart of reporting second pre-reported data S by using RPA according to an embodiment of the present application.

As shown in fig. 9, this embodiment includes operations S610 to S640.

In operation S610, a second piece of pre-reported data i is obtained.

In operation S620, a forecast sending field value is obtained according to the second pre-reported data i.

In operation S630, a forecast sent field value is logged through the RPA, and a logging result is generated.

In operation S640, after the logging result is generated, second pre-reported data i +1 is obtained, where i and i +1 both belong to S.

The robot logs in the supervisor account, acquires a forecast sending field value in the second pre-reported data i, inputs the forecast sending field value into the supervisor account management system, completes submission, and then a server of the supervisor account management system feeds back an input result (for example, prompting input success when the input result is successful and prompting input failure when the input result is failed). And after receiving the logging result, continuously acquiring the next piece of second pre-reported data i + 1.

In one embodiment, the server of the supervisor account management system, upon receiving the reported field value, feeds back to the robot that the entry was successful after the reception was successful; when the receiving fails, a second receiving attempt can be performed, and after a certain number of attempts, the receiving still fails, and the failure of the input is fed back to the robot. In subsequent operations, the staff can manually enter the failed feedback information one by one.

The delivery method of the present application may further set a delivery time, as shown in fig. 10, including:

in operation S710, a delivery time parameter is set.

The delivery time parameter, the account of the supervisor account management system and the password can be set in the delivery parameter maintenance unit.

In operation S720, the RPA is timed to wake up according to the delivery time parameter.

In the using process, the setting of the submission time parameter is loaded to the robot, the robot is awakened regularly according to the submission time window, and then the robot is driven to log in the account of the supervisor through the account and the password of the supervisor account management system.

According to the reporting method, the reported data reach the standard through collection, screening, filtering and processing of batch data, automatic screening of effective reported data can be efficiently completed through flow type calculation, interaction between a website teller and a supervision institution account management system is simulated through a robot process automation technology, the reporting efficiency of account information of newly developed enterprises of commercial banks is effectively improved, and the risk caused by manual missing reporting and error reporting is reduced.

Based on fig. 1-10, the present application provides a logical structure diagram of the bulk data reporting method as shown in fig. 11.

In operation S801, a maintenance reporting parameter is input by the reporting parameter maintenance unit, and the maintenance reporting parameter is provided to be used in operation S803, operation S807, and operation S810.

Operation S802 is performed to acquire and analyze a plurality of account information data from the basic business system of the enterprise account.

In operation S803, the data automatic filtering unit reads the maintenance posting parameter and extracts a field value corresponding to the filtering element in each account information data.

Operation S804 determines whether the report condition is met, and executes operation S805 or operations S806-S817.

In operation S805, if the account information data does not conform to the account information data, the account information data that does not conform to the account information data is removed, and the process is ended.

In operation S806, when the account information data matches, the matched account information data is the first pre-reported data N, and is transmitted to the reporting element processing unit.

In operation S807, the reporting element processing unit reads the maintenance reporting parameters and extracts the reporting field value corresponding to the reporting element in each of the first pre-reported data N.

Operation S808, formats the forecast sent field value, and generates second pre-reported data S.

In operation S809, all the second pre-reported data S are put into the waiting list.

In operation S810, the automatic reporting unit reads the maintenance reporting parameters and wakes up the robot at regular time.

In operation S811, the robot determines whether there is a record to be processed in the waiting list, and performs operation S812 or operations S813-S817.

In operation S812, no pending record in the waiting list is waited, and the process ends.

Operation S813 is carried out, the record to be processed in the list is waited, and the robot logs in the account of the monitoring authority.

In operation S814, a second pre-reported data S is obtained and recorded.

In operation S815, it is determined whether the entry is successful, and operation S816 or operation S817 is performed.

In operation S816, when successful, a success is flagged, and operation S811 is performed.

In operation S817, when failing, the failure is marked, and operation S811 is performed.

Based on the batch data reporting method, the application also provides a batch data reporting device. The apparatus will be described in detail below with reference to fig. 12.

FIG. 12 is a block diagram that schematically illustrates the structure of batch data, in accordance with an embodiment of the present application.

As shown in fig. 12, the batch data 900 of this embodiment includes an obtaining module 910, a filtering module 920, a processing module 930, and a reporting module 940.

The obtaining module 910 is configured to obtain batch data M. In an embodiment, the obtaining module 910 may be configured to perform the operation S210 described above, which is not described herein again.

The screening module 920 is configured to: and screening first pre-reported data N meeting the reported content from the batch data M by using a streaming computing mode according to a preset rule, wherein N belongs to M, and M is more than or equal to N. In an embodiment, the screening module 920 may be configured to perform the operation S220 described above, which is not described herein again.

The processing module 930 is configured to: and formatting the first pre-reported data N to generate second pre-reported data S which accords with the reporting format. In an embodiment, the processing module 930 may be configured to perform the operation S230 described above, which is not described herein again. And

the reporting module 940 is configured to report the second pre-reported data S item by item. In an embodiment, the reporting module 940 may be configured to perform the operation S240 described above, which is not described herein again.

According to the embodiment of the present application, any multiple modules of the obtaining module 910, the screening module 920, the processing module 930, and the reporting module 940 may be combined into one module to be implemented, or any one module may be split into multiple modules. Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of other modules and implemented in one module. According to an embodiment of the present application, at least one of the obtaining module 910, the screening module 920, the processing module 930, and the reporting module 940 may be implemented at least partially as a hardware circuit, for example, a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented by hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or implemented by any one of three implementation manners of software, hardware, and firmware, or a suitable combination of any several of them. Alternatively, at least one of the obtaining module 910, the screening module 920, the processing module 930 and the reporting module 940 may be at least partially implemented as a computer program module, which may perform a corresponding function when being executed.

As shown in fig. 13, an electronic apparatus 1000 according to an embodiment of the present application includes a processor 1001 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)1002 or a program loaded from a storage section 1008 into a Random Access Memory (RAM) 1003. Processor 1001 may include, for example, a general purpose microprocessor (e.g., CPU), an instruction set processor and/or associated chipset, and/or a special purpose microprocessor (e.g., Application Specific Integrated Circuit (ASIC)), among others. The processor 1001 may also include onboard memory for caching purposes. The processor 1001 may comprise a single processing unit or a plurality of processing units for performing the different actions of the method flows according to embodiments of the present application.

In the RAM1003, various programs and data necessary for the operation of the electronic apparatus 1000 are stored. The processor 1001, ROM 1002, and RAM1003 are connected to each other by a bus 1004. The processor 1001 performs various operations of the method flow according to the embodiment of the present application by executing programs in the ROM 1002 and/or the RAM 1003. Note that the programs may also be stored in one or more memories other than the ROM 1002 and the RAM 1003. The processor 1001 may also perform various operations of the method flows according to embodiments of the present application by executing programs stored in the one or more memories.

According to an embodiment of the present application, electronic device 1000 may also include an input/output (I/O) interface 1005, input/output (I/O) interface 1005 also being connected to bus 1004. Electronic device 1000 may also include one or more of the following components connected to I/O interface 1005: an input section 1006 including a keyboard, a mouse, and the like; an output section 1007 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 1008 including a hard disk and the like; and a communication section 1009 including a network interface card such as a LAN card, a modem, or the like. The communication section 1009 performs communication processing via a network such as the internet. The driver 1010 is also connected to the I/O interface 1005 as necessary. A removable medium 1011 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 1010 as necessary, so that a computer program read out therefrom is mounted into the storage section 1008 as necessary.

The present application also provides a computer-readable storage medium, which may be embodied in the apparatus/device/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The computer-readable storage medium carries one or more programs which, when executed, implement the method according to an embodiment of the present application.

According to embodiments of the present application, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present application, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present application, a computer-readable storage medium may include the ROM 1002 and/or the RAM1003 described above and/or one or more memories other than the ROM 1002 and the RAM 1003.

Embodiments of the present application also include a computer program product comprising a computer program containing program code for performing the method illustrated in the flow chart. When the computer program product runs in a computer system, the program code is used for causing the computer system to realize the item recommendation method provided in the embodiment of the present application.

The computer program performs the above-described functions defined in the system/apparatus of the embodiment of the present application when executed by the processor 1001. According to embodiments of the present application, the above-described systems, apparatuses, modules, units, etc. may be implemented by computer program modules.

In one embodiment, the computer program may be hosted on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted in the form of a signal on a network medium, distributed, downloaded and installed via the communication part 1009, and/or installed from the removable medium 1011. The computer program containing program code may be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In such an embodiment, the computer program may be downloaded and installed from a network through the communication part 1009 and/or installed from the removable medium 1011. The computer program performs the above-described functions defined in the system of the embodiment of the present application when executed by the processor 1001. According to embodiments of the present application, the above-described systems, devices, apparatuses, modules, units, etc. may be implemented by computer program modules.

According to embodiments of the present application, program code for executing computer programs provided in embodiments of the present application may be written in any combination of one or more programming languages, and in particular, these computer programs may be implemented using high level procedural and/or object oriented programming languages, and/or assembly/machine languages. The programming language includes, but is not limited to, programming languages such as Java, C + +, python, the "C" language, or the like. The program code may execute entirely on the user computing device, partly on the user device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, 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 some 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 or flowchart illustration, and combinations of blocks in the block diagrams 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.

It will be appreciated by a person skilled in the art that various combinations and/or combinations of features described in the various embodiments and/or claims of the present application are possible, even if such combinations or combinations are not explicitly described in the present application. In particular, various combinations and/or combinations of the features recited in the various embodiments and/or claims of the present application may be made without departing from the spirit and teachings of the present application. All such combinations and/or associations are intended to fall within the scope of this application.

In the description herein, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.

The embodiments of the present application are described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present application. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the application is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present application, and such alternatives and modifications are intended to be within the scope of the present application.

Claims

1. A batch data reporting method is characterized by comprising the following steps:

acquiring batch data M;

and reporting the second pre-reported data S one by using the RPA.

2. The batch data reporting method according to claim 1, wherein before the first pre-reported data N meeting the report content is screened from the batch data M by using a streaming computation mode according to a preset rule, the method further comprises:

3. The batch data reporting method according to claim 2, wherein the step of screening out first pre-reported data N meeting the report content from the batch data M by using a streaming computation mode according to a preset rule comprises:

and confirming the first pre-reported data N according to the field value.

4. The batch data reporting method of claim 3, wherein determining the first pre-reported data N according to the field value comprises:

5. The batch data reporting method of claim 4, further comprising:

6. The batch data reporting method according to claim 1, wherein formatting the first pre-reported data N to generate second pre-reported data S conforming to a reporting format comprises:

acquiring a submission element and a format rule;

7. The batch data reporting method according to claim 6, wherein reporting the second pre-reported data S item by using RPA comprises:

acquiring a second piece of pre-reported data i;

inputting the forecast sending field value through the RPA, and generating an input result;

8. The batch data reporting method of claim 7, further comprising:

setting a reporting time parameter;

9. The batch data reporting method of claim 7, further comprising:

10. The batch data reporting method according to any one of claims 1 to 9, wherein the batch data M includes at least one of customer information data, account information data, and business information data, and wherein an association relationship exists between the customer information data, the account information data, and the business information data.

11. A batch datagram delivery device comprising:

an acquisition module for acquiring batch data M;

a screening module to: according to a preset rule, screening first pre-reported data N meeting the reported content from the batch data M by using a streaming computing mode, wherein N belongs to M, and M is more than or equal to N;

a processing module to: formatting the first pre-reported data N to generate second pre-reported data S which accords with a reporting format; and

and the reporting module is used for reporting the second pre-reported data S one by one.

12. An electronic device, comprising:

one or more processors;

a storage device for storing one or more programs,

wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of any of claims 1-10.

13. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform a rendering method according to any of claims 1-10.

14. A computer program product comprising a computer program which, when executed by a processor, implements a method of posting according to any one of claims 1-10.