CN114565451A - Bulk data reporting method, apparatus, electronic device and medium - Google Patents

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

Bulk data reporting method, apparatus, electronic device and medium

technical field

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

Background technique

At present, some commercial banks have begun to use robots instead of manual entry methods in order to prevent potential regulatory inspection risks such as missed filing, late filing, and wrong filing in the annual inspection and reporting operations. According to the content that needs to be supplemented in the account of the supervisory institution, the robot simulates the customer service manager to log in to the commercial bank system, and captures the account data to be submitted in a single manner, then logs in to the supervisory institution's account management system, and enters the captured account into the supervisory institution's account management system. Data, this method simply uses robots to replace manual operations, and does not form a completed submission process. It can only avoid the occurrence of risks such as missed filing, late filing, and wrong filing. However, the efficiency improvement is not significant, and there is a single process and poor flexibility. The shortcomings of the report, and the data to be submitted cannot be classified and allocated dynamically and efficiently.

SUMMARY OF THE INVENTION

The present application aims to solve at least one of the technical problems existing in the prior art.

For example, the present application provides a batch data reporting method. Through the flexible configuration of preset rules, it can be connected to various commercial bank systems to meet the personalized requirements of the second pre-reported data S; , which can capture multiple first pre-reported data N that meet the requirements at one time, greatly reducing the average time-consuming of reporting and speeding up the reporting efficiency.

In order to achieve the above-mentioned purpose, a first aspect of the present application provides a batch data reporting method, comprising the following steps:

Get batch data M;

According to a preset rule, the first pre-reported data N that conforms to the reported content is screened out from the batch data M by using the mode of streaming computing, where N belongs to M, and M is greater than or equal to N;

Formatting the first pre-reported data N to generate second pre-reported data S conforming to the reporting format;

The second pre-report data S is reported one by one using RPA.

According to the batch data reporting method of the present application, on the basis of satisfying the requirements of the regulatory agency for the supervision of commercial bank accounts and preventing business risks, the automated processing level of the data to be submitted by the commercial bank to the regulatory agency is effectively improved, and the level of automation is greatly improved. It improves the entry efficiency of data to be submitted, and reduces the cases of missed filing, late filing, and wrong filing of accounts, which not only meets the regulatory requirements of regulatory agencies, but also reduces the operating costs of commercial banks and relieves the pressure of entry personnel.

Further, before filtering out the first pre-reported data N that conforms to the reported content from the batch data M by using a stream computing mode according to a preset rule, the method further includes:

Parse each piece of data a in the batch of data M according to a preset format, where a belongs to M.

Further, according to the preset rules, the first pre-reported data N that conforms to the reported content is screened out from the batch data M by using the mode of streaming computing, including:

reading preset rules, the preset rules include at least one screening element;

Extract the field value corresponding to each filter element in each piece of data a;

According to the field value, the first pre-report data N is confirmed.

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

When the field value conforms to the preset rule, marking the field value, wherein the marking corresponding to each screening element is different;

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

Further, it also includes:

When the data a lacks at least one filter element in the preset rule, the data a is eliminated.

Further, performing formatting processing on the first pre-reporting data N to generate second pre-reporting data S conforming to the reporting format, including:

Obtain submission elements and format rules;

Extract the pre-reporting field value corresponding to each reporting element in each first pre-reporting data N;

The pre-report field value is processed according to the format rule, and the second pre-report data S is generated.

Further, using RPA to report the second pre-report data S one by one, including:

Obtain a second pre-report data i;

According to the second pre-report data i, obtain the pre-report field value;

The pre-delivery field value is entered through RPA, and the entry result is generated;

After the input result is generated, the second pre-report data i+1 is acquired, wherein both i and i+1 belong to S.

Further, it also includes:

Set the delivery time parameters;

The RPA is periodically woken up according to the reporting time parameter.

Further, it also includes:

The preset rules, reporting elements and format rules are automatically adjusted according to the input results.

Further, the batch data M includes at least one of customer information data, account information data and industrial and commercial information data, wherein there is an association relationship between the customer information data, the account information data and the industrial and commercial information data .

A second aspect of the present application provides a batch data reporting device, comprising: an acquisition module, which is used for acquiring batch data M; and a screening module, which is used for: according to preset rules, use streaming The calculation mode selects the first pre-reported data N that meets the reporting content from the batch data M, where N belongs to M, and M is greater than or equal to N; a processing module, the processing module is used for: A pre-report data N is formatted to generate second pre-report data S conforming to the reporting format; and a reporting module is configured to report the second pre-report 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 when the one or more programs are executed by the one or more programs When the processor executes, one or more processors are caused to execute the above reporting method.

A fourth aspect of the present application further provides a computer-readable storage medium on which executable instructions are stored, and when the instructions are executed by the processor, the processor executes the above-mentioned reporting method.

A fifth aspect of the present application also provides a computer program product, including a computer program, which implements the above reporting method when the computer program is executed by a processor.

Description of drawings

The above-mentioned content and other objects, features and advantages of the present application will be more apparent from the following description of the embodiments of the present application with reference to the accompanying drawings, in which:

FIG. 1 schematically shows an application scenario diagram of a reporting method, apparatus, device, medium, and program product according to an embodiment of the present application;

FIG. 2 schematically shows a structural diagram of an account annual inspection reporting system according to an embodiment of the present application;

FIG. 3 schematically shows an internal structure diagram of a batch data reporting system according to an embodiment of the present application;

FIG. 4 schematically shows a flowchart of a method for reporting batch data according to an embodiment of the present application;

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

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

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;

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

FIG. 9 schematically shows a flowchart of using RPA to report second pre-report data S according to an embodiment of the present application;

FIG. 10 schematically shows a schematic flowchart of setting a reporting time according to an embodiment of the present application;

FIG. 11 schematically shows a logical structure diagram of a batch data reporting method according to an embodiment of the present application;

FIG. 12 schematically shows a structural block diagram of a batch data reporting apparatus according to an embodiment of the present application; and

FIG. 13 schematically shows a block diagram of an electronic device suitable for implementing a method for reporting batch data according to an embodiment of the present application.

Detailed ways

Hereinafter, embodiments of the present application will be described with reference to the accompanying drawings. It should be understood, however, that these descriptions are exemplary only, and are not intended to limit the scope of the application. In the following detailed description, for convenience of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present application. It will be apparent, however, that one or more embodiments may be practiced without these specific details. Also, in the following description, descriptions of well-known structures and techniques are omitted to avoid unnecessarily obscuring the concepts of the present application.

The terminology used herein is for the purpose of describing specific embodiments only and is not intended to limit the application. The terms "comprising", "comprising" and the like as used herein indicate 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 meaning as commonly understood by one of ordinary skill in the art, unless otherwise defined. It should be noted that terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly rigid manner.

Where expressions like "at least one of A, B, and C, etc.," are used, they should generally be interpreted in accordance with the meaning of the expression as commonly understood by those skilled in the art (eg, "has A, B, and C") At least one of the "systems" shall include, but not be limited to, systems with A alone, B alone, C alone, A and B, A and C, B and C, and/or A, B, C, etc. ).

With the gradual implementation of the cancellation of the commercial bank account licensing system by the regulators, some businesses handled by commercial banks for corporate customers have changed from the approval system to the filing system, which needs to be reported in the regulator's account management system according to different customer types and account nature. for the record. Filing and filing is a relatively fixed process, which is a single, repetitive, and tedious transactional work. The largest commercial banks in China add an average of 1.2 million new accounts each year, and the number of accounts is large, which requires a lot of manpower from each branch to complete.

Due to the low efficiency of manual entry, there are potential regulatory inspection risks such as missed filing, late filing, and wrong filing. At present, some commercial banks have begun to use robots instead of manual entry methods in the annual inspection and reporting operations. However, the workflow of robots It is no different from manual work. It is also necessary to log in to the commercial bank system to find relevant data according to the reporting content that needs to be supplemented in the account of the regulatory agency, and then implement a single capture for one account, and then log in to the account management system of the regulatory agency to manage the account of the regulatory agency. The system records the captured account data. This method simply uses robots to replace manual operations, without forming a completed submission process, and the efficiency improvement is not significant. .

This application establishes an account reporting mechanism based on stream computing technology and robotic process automation technology, which can improve the processing efficiency of batch data reporting to regulatory agencies. In other words, through the flexible configuration of preset rules, the present application can be connected to various commercial banking systems to meet the individual needs of the second pre-report data S; The first pre-reporting data N that meets the requirements greatly reduces the average time-consuming of reporting and speeds up the reporting efficiency.

FIG. 1 schematically shows an application scenario diagram of using a robot to report batch data to a relevant regulatory agency 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 the robot logs in to the account of the relevant regulatory agency management system at the front end, and uses the network to interact with the server of the relevant regulatory agency management system after the batch data is processed uniformly as required. . The network 104 is a medium used to provide a communication link between the terminal devices 101 , 102 , 103 and the server 105 . The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

The robot can use the terminal devices 101, 102, 103 to interact with the server 105 through the network 104 to receive or send messages and the like.

The terminal devices 101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, and desktop computers.

The server 105 may be a server that provides various services, for example, a business management server (just an example) that supports the robot using the second pre-report data S sent by the terminal devices 101 , 102 , and 103 . The service management server may analyze and process the received second pre-reported data S, and feed back the processing result to the terminal device, for example, feedback success information when the reception is successful, and feedback failure information when the reception fails.

It should be understood that the numbers of terminal devices, networks and servers in FIG. 1 are merely illustrative. There can be any number of terminal devices, networks and servers according to implementation needs.

It should be noted that the batch data reporting method of this application is an explanation based on the interactive scenario of a financial institution, specifically, the expansion explanation of the embodiment of the batch reporting of the annual inspection data of the enterprise account of the commercial bank to the relevant regulatory agency. , but not as a limitation to the technical solution of this application.

Based on the scenario described in FIG. 1 , the following will describe in detail the account annual inspection reporting system of the embodiment of the application with reference to FIGS. 2 to 11 .

FIG. 2 schematically shows a structural diagram of an account annual inspection reporting system according to an embodiment of the present application.

As shown in Figure 2, the annual account inspection and reporting system includes five components, namely the enterprise-level customer information system, the basic business account system of the enterprise, the industrial and commercial information system, the batch data reporting system, and the account management system of the regulatory agency.

The batch data reporting system is respectively connected with the enterprise-level customer information system, the basic business system of enterprise accounts, the industrial and commercial information system and the account management system of the supervisory agency. Among them, this application only improves the process of the batch data submission system. The enterprise-level customer information system, the basic business system of enterprise accounts, and the industrial and commercial information system can provide the source of batch data M, and the account management system of the regulatory agency is the object of the robot submission. .

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. The batch data that can be provided to the batch data reporting system includes the customer name, business license number, organization code certificate number and other data.

The basic business system for corporate accounts is mainly responsible for receiving, storing, maintaining, and analyzing account information data. The batch data that can be provided to the batch data reporting system includes account media number, account opening date, account attributes, account type and other data.

The industrial and commercial information system is mainly responsible for the reception and centralized storage of industrial and commercial information data. The batch data that can be provided to the batch data reporting system includes the business scope, registered address, registered capital and other data of the enterprise.

The batch data submission system is mainly responsible for receiving the data provided by the existing business systems (such as enterprise-level customer information system, basic business system for enterprise accounts, and industrial and commercial information system), and after corresponding processing, it is connected with the account management system of the supervisory agency. Complete the batch submission of corporate account annual inspection data. The specific internal structure is shown in Figure 3.

The account management system of the supervisory institution is mainly responsible for connecting with the major commercial bank systems (for example, the batch data reporting system), receiving and storing information such as account opening, account cancellation, and capital flow of each bank, and feeding back the processing results to the connected banking system after receipt. .

The interaction of the above-mentioned systems is the existing interaction mode. After logging in to the batch data reporting system, staff or robots usually query and collect relevant information that needs to be reported from the enterprise-level customer information system, the basic business system of enterprise accounts, and the industrial and commercial information system. Data, and then log in to the account management system of the regulatory agency, submit the collected relevant data that needs to be reported into the account management system of the regulatory agency, and complete the supplementation of missing data. However, staff reporting by themselves may lead to potential regulatory inspection risks such as missed filing, late filing, and wrong filing. Therefore, replacing staff with robots and using non-intrusive docking with the supervisory agency account management system will not damage the supervisory agency account management system. The original technical framework, while saving human resources.

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

The reporting parameter maintenance unit is mainly responsible for collecting and storing preset rules, reporting elements, format rules, etc. used by other modules in the batch data reporting system and method of the present application, and storing the reporting elements, formats, reporting windows and other information parameters The data is automatically pushed to the corresponding data acquisition unit, data automatic screening unit, reporting element processing unit, and automatic reporting unit, so that the above units can process the obtained batch data according to the preset rules and parameters of the parameter sending parameter maintenance unit.

The data collection unit is mainly responsible for collecting information data on demand from various peripheral business systems (eg, enterprise-level customer information system, basic business account system for enterprise accounts, and industrial and commercial information system), and then sends information and data screening notifications to the data automatic screening unit.

The automatic data screening unit is mainly responsible for screening the information data collected by the data collection unit according to the reporting data screening rules maintained by the reporting parameter maintenance unit. After filtering out the information data that meets the reporting conditions, a processing notification of the information data that meets the reporting conditions is sent to the reporting element processing unit.

The reporting element processing unit is mainly responsible for processing the information data to be reported screened by the automatic data screening unit, and extracts the field information that needs to be entered in the account management system of the regulatory agency according to the field reporting format maintained by the reporting parameter maintenance unit. Formatting.

The automatic reporting unit is based on the reporting time window and frequency parameters maintained by the reporting parameter maintenance unit, regularly starts the robot, and logs in to the account management system of the supervisory agency in a non-invasive way, to report the information to be submitted after processing by the reporting element processing unit. Process item by item.

Based on FIG. 1 to FIG. 3 , FIG. 4 schematically shows a flowchart of a method for reporting batch data 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.

Obtain the pushed information data of each peripheral business system, receive the data through common methods such as the network, and cache it locally.

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

It can be understood that, to obtain the information data in the enterprise-level customer information system, the basic business system of the enterprise account, and the industrial and commercial information system in FIG. Collection of internal data. For example, only the account information data in the basic business system of the enterprise account may be collected, and the account information data includes the customer number, account medium number, account opening date, account attributes, and account type.

Of course, there is an association between customer information data, account information data, and industrial and commercial information data, and by acquiring one of customer information data, account information data, and industrial and commercial information data, the other two can be associated.

In one embodiment, the customer number is collected from the basic business system of the enterprise account, and the customer number can be associated with enterprise information such as enterprise certificate, legal person, and beneficiary in the enterprise-level customer information system, and then associated with the industrial and commercial information system through the enterprise certificate. Business information of enterprises in .

In operation S220, according to a preset rule, the first pre-reported data N that conforms to the reported content is screened out from the batch data M by using a streaming computing 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, and the value of the data decreases with the passage of time. Streaming computing can be used to process data streams, belongs to real-time computing, has the characteristics of low latency, can calculate dynamic data, has no boundaries, and is persistent, and is suitable for scenarios with high timeliness requirements as shown in FIG. 1 of this application.

The flow computing logic is shown in Figure 5. The first column is the original data, the second to the penultimate column is one or more computing nodes, each of which contains one or more filtering elements, and the last column is the processed data. Filtered output data.

Combined with the above stream computing logic diagram, the present application is to filter the preprocessed batch data M, the batch data M is the original data, and according to the preset rules issued by the reporting parameter maintenance unit, the preset rules are put into each In each computing node, after screening, the output data is the first pre-reported data N that conforms to the reported content.

It can be understood that the first pre-reported data N that conforms to the reported content is the first processing operation for the robot to complete the reported information, and the filtered first pre-reported data N is the relevant account of the regulatory agency missing some data information, Only the missing data can be received by the supervisory authority account management system of each local supervisory authority.

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

Since the reporting formats (for example, reporting requirements, message formats, and message fields) of local regulatory agencies are different, the first pre-reported data N needs to be formatted, and the processed second pre-reported data S conforms to the Only the reporting requirements of each local regulatory agency can be received by the regulatory agency account management system of each local regulatory agency.

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

The present application can perform dynamic and adaptive formatting processing on the first pre-reported data N to generate the second pre-reported data S conforming to the reporting format of each local regulatory agency, so the reporting method of the present application is universal.

The reporting method of the present application further includes: automatically adjusting preset rules, reporting elements and format rules according to the input results.

In one embodiment, the reporting parameters in the reporting element processing unit can be automatically updated according to the analysis results of customer data, account information, and business situation data to meet the reporting requirements of various local regulatory agencies.

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

Robotic Process Automation (RPA) for short is a software solution that uses intelligent software to simulate and enhance the interaction process between humans and computers, and to perform repeatable tasks based on certain rules.

The robot can log in to the account management system of the regulatory agency, input the missing data (second pre-reported data S) in the regulatory agency one by one, and submit it after completing the input. Combined with robots, this application can simulate the normal manual operations of staff, such as mouse click, drop-down selection, keyboard input, etc., to achieve seamless and non-intrusive docking with the account management system of the supervisory institution, and will not destroy the original account management system of the supervisory institution. technical framework.

It should be noted that non-intrusion means that no code modification is required, and it is submitted to the account management system of the regulatory agency through direct analog entry.

According to the batch data reporting method of the present application, on the basis of satisfying the requirements of the regulatory agency for the supervision of commercial bank accounts and preventing business risks, the automated processing level of the data to be submitted by the commercial bank to the regulatory agency is effectively improved, and the level of automation is greatly improved. It improves the entry efficiency of data to be submitted, and reduces the cases of missed filing, late filing, and wrong filing of accounts, which not only meets the regulatory requirements of regulatory agencies, but also reduces the operating costs of commercial banks and relieves the pressure of entry personnel.

In order to facilitate the mode selection of stream computing, before the first pre-reported data N that matches the reporting content is filtered out of the batch data M by using the stream computing mode according to preset rules, the obtained batch data M needs to be screened. preprocessing.

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

The batch data M is processed for the first time and the second time to reach the second pre-reported data S that meets the reporting requirements and can be received by the relevant regulatory agency. The following will describe operations S220 and S230 through Figures 6-8. Do for further explanation.

FIG. 6 schematically shows a flowchart of a method for screening 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, and the preset rule includes at least one filter element.

Read and parse preset rules from the reporting parameter maintenance unit as filter rules, and the filter rules contain at least one filter element. For example, the filter rule is: the account opening date is xx, the account attribute is basic account, and the account type is approved. In the above example, there are three filter elements, namely account opening date, account attribute and account type.

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

Extract the field value in each piece of data a according to the filtering elements in the preset rule, for example, extract the field value corresponding to the account opening date, the corresponding field value of the account attribute, and the corresponding field value of the account type in each piece of data a.

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

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

In one embodiment, marked when identical, and unmarked when at least one item is different. This embodiment is applicable to a scenario where multiple screening elements are distributed in different computing nodes. When the field values corresponding to all screening elements are the same as the preset rules, they will be marked with symbols, that is, the first one that is determined to meet the reporting conditions will be marked with a symbol. Pre-reported data N; and if the field value corresponding to one of the filter elements is different from the preset rule, it is not marked, that is, it is regarded as data that does not need to be reported. Therefore, when reporting the processing of the element processing unit, only the marked data a is processed.

In another embodiment, each filter element corresponds to a different tag. When the field value corresponding to the filter element is the same as the preset rule, the tag belonging to the filter element is marked, and the field value corresponding to the filter element is different from the preset rule. Also, unmarked. When reporting feature processing unit processing, only data a with flags for all filter features is processed. For example, three screening elements correspond to three types of tags, and the first pre-reported data N that meets the reporting conditions is the data a with these three tags.

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 Figure 5, the preset rule is to extract three patterns of square, diamond and circle, and filter out the colorless ones. The filter elements in the figure are shape and color, and the field values of the filter elements are square colorless, square gray, square black, diamond colorless, diamond gray, diamond black, circle colorless, circle gray, and circle black.

Each computing node is a judgment rule. According to the above preset rules, computing node 1 is set to filter out three patterns of square, diamond and circle, and computing node 2 is set to filter out square colorless, diamond colorless and Circle colorless three patterns. During the calculation process, in the calculation node 1, the shape field values in the original data will be marked with squares, diamonds and circles, and in the calculation node 2, the field values marked by the calculation node 1 with squares, diamonds and circles will be colored The field value of is colorless filtering, and finally the result that conforms to the preset rules is obtained.

In operation S410, when the field value conforms to the preset rule, the field value is marked, wherein the marking corresponding to each filter element is different.

Using different tags as the identification of different filtering elements, after each calculation, the corresponding field values will be marked with corresponding tags, and the data that conforms to the preset rules can be quickly distinguished according to the tags, and the data with corresponding tags can be further marked. Filter further.

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

Check each field value in the data a, when all the field values corresponding to the filter elements are marked, the data a is the first pre-reported data N.

In the above-mentioned embodiment, there are multiple computing nodes, and further screening is performed according to the marked data of the computing nodes in the previous link. In the embodiment where there is only one computing node to filter multiple items, the filtering can be implemented by excluding the data a when at least one screening element in the preset rule is missing in the data a.

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

As shown in FIG. 8 , in this embodiment, formatting processing may be performed on the first pre-reported data N, including operations S510 to S530.

In operation S510, the reporting elements and format rules are acquired.

The reporting elements and format rules are formulated by local regulatory agencies. When submitting information data to the regulatory agency account management system of the relevant regulatory agency, it is necessary to format the submitted information data into data that is allowed to be submitted. You need to obtain the reporting elements and format rules from the reporting parameter maintenance unit first.

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

The reporting elements are identified from each piece of first pre-reporting data N, and then the pre-reporting field values are correspondingly extracted. For example, extract the pre-report field value corresponding to the account opening date in each piece of the first pre-report data N.

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

Format the value of the pre-sent field with characters, numbers, and dates according to the format of the fields to be reported. For example, the date format is YYYY-MM-DD, and the time format is hh:mm:ss.

It should be noted that the screening element is a qualification for screening batch data M, and the reporting element is a qualification for the first pre-reported data N. The content of the screening element and the reporting element may be the same or different. For example, the first pre-report data N can be obtained by using the filter element and field value as the date xx in the batch data M, and then the reporting element and the pre-report field value can be extracted from the first pre-report data N with the account attribute as the basic account. The first pre-report data N can be obtained by using the filter elements and the field value as the date xx in the batch data M, and then the reporting elements and pre-report data N can be extracted from the first pre-report data N. The field value is also the data of date xx, and the date format of xx is processed.

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

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

In operation S610, a piece of second pre-report data i is acquired.

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

In operation S630, a pre-delivery field value is entered through RPA, and an entry result is generated.

In operation S640, after the input result is generated, the second pre-report data i+1 is acquired, wherein both i and i+1 belong to S.

The robot logs in to the supervisor account, obtains the pre-delivery field value in a second pre-report data i, enters the pre-report field value into the supervisor account management system, and completes the submission, and then the server of the supervisor account management system will feedback the entry result (For example, prompt entry success when successful, and prompt entry failure when unsuccessful). After receiving the input result, continue to acquire the next second pre-report data i+1.

In one embodiment, when the server of the supervisory machine account management system receives the pre-delivered field value, it reports to the robot that the entry is successful after the reception is successful; when the reception fails, a second reception attempt may be made, and after a certain number of attempts If it still fails, feedback to the robot that the input failed. In subsequent operations, the staff can manually enter the failed feedback information one by one.

The submission method of this application can also set the submission time, as shown in Figure 10, including:

In operation S710, a reporting time parameter is set.

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

In operation S720, the RPA is periodically woken up according to the reporting time parameter.

In the process of use, the settings of the reporting time parameters are loaded into the robot, the robot is woken up regularly according to the reporting time window, and then the robot is driven to log in to the supervisory machine account through the account and password of the supervisory machine account management system.

According to the reporting method of the present application, through the collection, screening, filtering and processing of batch data, the reported data can reach the standard, and the automatic screening of effective reporting data can be efficiently completed by using flow computing, and the cashier at the branch can be simulated by the robot process automation technology. Interacting with the account management system of the supervisory agency can effectively improve the efficiency of reporting information on newly opened corporate accounts of commercial banks and reduce the risks caused by manual omissions and misreporting.

Based on FIG. 1 to FIG. 10 , the present application provides a logical structure diagram of the batch data reporting method shown in FIG. 11 .

In operation S801, the maintenance reporting parameters are input through the reporting parameter maintenance unit, and the maintenance reporting parameters may be provided for use in operations S803, S807, and S810.

In operation S802, a plurality of account information data are obtained from the basic business system of the enterprise account, and analyzed.

In operation S803, the automatic data screening unit reads the maintenance reporting parameters, and extracts the field value corresponding to the screening element in each account information data.

In operation S804, it is determined whether the reporting conditions are met, and operation S805 or operations S806-S817 are performed.

In operation S805, in the case of non-conformity, the non-conforming account information data is eliminated, and the process ends.

In operation S806, when the data is matched, 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 pre-reporting field value corresponding to the reporting element in each first pre-reporting data N.

In operation S808, the pre-report field value is formatted to generate the second pre-report 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 regularly.

In operation S811, the robot determines whether there is a pending record in the waiting list, and executes operation S812 or operation S813-operation S817.

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

In operation S813, there is a pending record in the waiting list, and the robot logs into the account of the supervisory agency.

In operation S814, a piece of second pre-report data S is acquired and entered.

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

Operation S816, when successful, marks success, and performs operation S811.

Operation S817, upon failure, flag failure, and perform operation S811.

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

FIG. 12 schematically shows a structural block diagram of batch data according to an embodiment of the present application.

As shown in FIG. 12 , the batch data 900 in this embodiment includes an acquisition module 910 , a screening module 920 , a processing module 930 and a reporting module 940 .

The acquisition module 910 is used to acquire batch data M. In one embodiment, the obtaining module 910 may be configured to perform the operation S210 described above, which will not be repeated here.

The screening module 920 is configured to: filter out the first pre-reported data N that conforms to the reported content from the batch data M by using a streaming computing mode according to preset rules, where N belongs to M, and M is greater than or equal to N. In one embodiment, the screening module 920 may be configured to perform the operation S220 described above, which will not be repeated here.

The processing module 930 is configured to: format the first pre-reported data N to generate second pre-reported data S conforming to the reporting format. In one embodiment, the processing module 930 may be configured to perform the operation S230 described above, which will not be repeated here. as well as

The reporting module 940 is configured to report the second pre-reported data S one by one. In one embodiment, the reporting module 940 may be configured to perform the operation S240 described above, which will not be repeated here.

According to the embodiments of the present application, any plurality of modules in the acquisition module 910, the screening module 920, the processing module 930, and the reporting module 940 may be combined into one module for implementation, or any one of the modules 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 acquisition 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, such as a field programmable gate array (FPGA), a programmable logic array (PLA), system-on-chip, system-on-substrate, system-on-package, application specific integrated circuit (ASIC), or any other reasonable means of integrating or packaging circuits, etc. in hardware or firmware, or in software, It can be implemented in any one of the three implementation manners of hardware and firmware or in a suitable combination of any of them. Alternatively, at least one of the acquisition module 910, the screening module 920, the processing module 930, and the reporting module 940 may be implemented at least in part as a computer program module that, when executed, may perform corresponding functions.

FIG. 13 schematically shows a block diagram of an electronic device suitable for implementing a method for reporting batch data according to an embodiment of the present application.

As shown in FIG. 13 , an electronic device 1000 according to an embodiment of the present application includes a processor 1001 that can be loaded into a random access memory (RAM) 1003 according to a program stored in a read only memory (ROM) 1002 or from a storage part 1008 program to perform various appropriate actions and processes. The processor 1001 may include, for example, a general-purpose microprocessor (eg, a CPU), an instruction set processor and/or a related chipset, and/or a special-purpose microprocessor (eg, an application-specific integrated circuit (ASIC)), and the like. The processor 1001 may also include onboard memory for caching purposes. The processor 1001 may include a single processing unit or multiple processing units for executing different actions of the method flow according to the embodiments of the present application.

In the RAM 1003, various programs and data necessary for the operation of the electronic device 1000 are stored. The processor 1001 , the ROM 1002 , and the RAM 1003 are connected to each other through a bus 1004 . The processor 1001 performs various operations of the method flow according to the embodiment of the present application by executing the programs in the ROM 1002 and/or the RAM 1003 . Note that the program 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 flow according to the embodiments of the present application by executing the programs stored in the one or more memories.

According to an embodiment of the present application, the electronic device 1000 may further include an input/output (I/O) interface 1005 which is also connected to the bus 1004 . Electronic device 1000 may also include one or more of the following components connected to I/O interface 1005: input portion 1006 including a keyboard, mouse, etc.; including components such as a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and An output section 1007 of speakers and the like; a storage section 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, and the like. The communication section 1009 performs communication processing via a network such as the Internet. A drive 1010 is also connected to the I/O interface 1005 as needed. A removable medium 1011, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is mounted on the drive 1010 as needed so that a computer program read therefrom is installed into the storage section 1008 as needed.

The present application also provides a computer-readable storage medium, which may be included in the device/apparatus/system described in the above-mentioned embodiments; or may exist alone without being assembled into the device/device/system. device/system. The above-mentioned computer-readable storage medium carries one or more programs, and when the above-mentioned one or more programs are executed, the method according to the embodiment of the present application is implemented.

According to the embodiments of the present application, the computer-readable storage medium may be a non-volatile computer-readable storage medium, for example, it may include, but is not limited to, a portable computer disk, a hard disk, a random access memory (RAM), a read only memory (ROM) , erasable programmable read only memory (EPROM or flash memory), portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing. In this application, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. For example, according to embodiments of the present application, a computer-readable storage medium may include one or more memories other than ROM 1002 and/or RAM 1003 and/or ROM 1002 and RAM 1003 described above.

Embodiments of the present application also include a computer program product, which includes a computer program, and the computer program includes program code for executing the method shown in the flowchart. When the computer program product runs in the computer system, the program code is used to enable the computer system to implement the method for recommending items provided in the embodiments of the present application.

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

In one embodiment, the computer program may rely 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, distributed in the form of a signal over a network medium, and downloaded and installed through the communication section 1009, and/or installed from a removable medium 1011. The program code embodied by the computer program 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 the network via the communication portion 1009, and/or installed from the removable medium 1011. When the computer program is executed by the processor 1001, the above-mentioned functions defined in the system of the embodiment of the present application are executed. According to the embodiments of the present application, the systems, devices, apparatuses, modules, units, etc. described above can be implemented by computer program modules.

According to the embodiments of the present application, program codes for executing the computer programs provided in the embodiments of the present application may be written in any combination of one or more programming languages, and specifically, high-level procedures and/or object-oriented programming may be used. programming language, and/or assembly/machine language to implement these computational programs. Programming languages include, but are not limited to, languages such as Java, C++, python, "C" or similar programming languages. 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 (eg, using an Internet service provider business via an Internet connection).

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 that contains one or more logical functions for implementing the specified functions executable instructions. It should also be noted that, in some alternative implementations, the functions noted in the blocks 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 is also noted that each block of the block diagrams or flowchart illustrations, and combinations of blocks in the block diagrams or flowchart illustrations, can be implemented in special purpose hardware-based systems that perform the specified functions or operations, or can be implemented using A combination of dedicated hardware and computer instructions is implemented.

Those skilled in the art will understand that various combinations or/or combinations of features recited in the various embodiments and/or claims of the present application may be performed, 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 of the present application and/or the claims may be made without departing from the spirit and teachings of the present application. All such combinations and/or combinations fall within the scope of this application.

In the description of this specification, description with reference to the terms "one embodiment," "some embodiments," "instance," "specific example," or "some examples," etc., mean specific features described in connection with the embodiment or example , structure, material or feature is included in at least one embodiment or example of the present application. In this specification, schematic representations of the above terms 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 various embodiments are described above separately, this does not mean that the measures in the various embodiments cannot be used in combination to advantage. The scope of the application is defined by the appended claims and their equivalents. Without departing from the scope of the present application, those skilled in the art can make various substitutions and modifications, and these substitutions and modifications should all fall within the scope of the present application.

Claims (14)

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

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.

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:

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

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:

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.

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

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.

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

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

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;

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.

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;

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

inputting the forecast sending field value through the RPA, 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.

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

setting a reporting time parameter;

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

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

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

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.

Images