Batch data reporting method, device, electronic device and medium

Abstract

The present application provides a method for batch data submission, which can be applied to the field of artificial intelligence technology. The submission method includes the following steps: obtaining batch data M; screening out the first pre-submission data N that meets the submission content from the batch data M according to preset rules by using the streaming computing mode; performing formatting processing on the first pre-submission data N to generate the second pre-submission data S that meets the submission format; and using RPA to submit the second pre-submission data S item by item. According to the batch data submission method of the present application, on the basis of meeting the supervision requirements of regulatory agencies for commercial bank accounts and preventing business risks, the automated processing level of the data to be submitted by commercial banks to regulatory agencies is effectively improved, the input efficiency of the data to be submitted is greatly increased, and the situations of missed, late, and incorrect record-filing of accounts are reduced. It not only meets the supervision requirements of regulatory agencies, but also reduces the operating costs of commercial banks and relieves the pressure on input personnel.

Description

Technical Field

[0001] This application relates to the field of artificial intelligence technology, and particularly to a method, device, electronic device and medium for batch data submission. Background Art

[0002] At present, in the annual inspection submission operations of some commercial banks, in order to prevent potential regulatory inspection risks such as missing filings, late filings, and incorrect filings, robots have begun to be used to replace manual entry methods. According to the content that needs to be supplemented in the regulatory agency's account, the robot simulates a customer service manager to log in to the commercial bank system, single-grab the account data to be submitted, then log in to the regulatory agency's account management system, and enter the grabbed account data into the regulatory agency's account management system. This method only simply uses robots to replace manual operations, does not form a complete submission process, can only avoid the occurrence of risks such as missing filings, late filings, and incorrect filings, but the efficiency improvement is not significant, and it has the disadvantages of a single process and poor flexibility, and fails to dynamically and efficiently classify and allocate the data to be submitted. Summary of the Invention

[0003] This application aims to solve at least one of the technical problems existing in the prior art.

[0004] For example, this application provides a method for batch data submission. Through the flexible configuration of preset rules, it can be docked with various commercial bank systems to meet the personalized needs of the second pre-reported data S; while through the screening mode of streaming computing, multiple first pre-reported data N that meet the requirements can be grabbed at one time, greatly reducing the average submission time and accelerating the submission efficiency.

[0005] To achieve the above object, the first aspect of this application provides a method for batch data submission, including the following steps:

[0006] Obtain batch data M;

[0007] According to preset rules, use the streaming computing mode to screen out the first pre-reported data N that meets the submission content from the batch data M, where N belongs to M, and M is greater than or equal to N;

[0008] Format the first pre-reported data N to generate the second pre-reported data S that meets the submission format;

[0009] Use RPA to submit the second pre-reported data S item by item.

[0010] According to the batch data reporting method of the present application, on the basis of meeting the regulatory authorities' supervision of commercial bank accounts and preventing business risks, the level of automated processing of data to be reported by commercial banks to regulatory authorities is effectively improved, the efficiency of data entry to be reported is greatly improved, and the cases of missed, late, and incorrect registration of accounts are reduced. It not only meets the regulatory requirements of regulatory authorities, but also reduces the operating costs of commercial banks and relieves the pressure on data entry personnel.

[0011] Furthermore, before selecting the first pre-reported data N that meets the reporting content from the batch data M using a streaming computing mode according to a preset rule, the method further includes:

[0012] Each data a in the batch data M is parsed according to a preset format, wherein a belongs to M.

[0013] Furthermore, according to a preset rule, the first pre-reported data N that meets the reporting content is screened out from the batch data M using a streaming computing mode, including:

[0014] Reading a preset rule, wherein the preset rule includes at least one screening element;

[0015] Extract the field value corresponding to each screening element in each piece of data a;

[0016] The first pre-reported data N is confirmed according to the field value.

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

[0018] When the field value meets the preset rule, mark the field value, wherein the mark corresponding to each screening element is different;

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

[0020] Furthermore, it also includes:

[0021] When at least one screening element in the preset rule is missing from the data a, the data a is discarded.

[0022] Further, formatting the first pre-reported data N to generate second pre-reported data S conforming to a reporting format includes:

[0023] Obtain submission elements and format rules;

[0024] Extracting the pre-reporting field value corresponding to each reporting element in each first pre-reporting data N;

[0025] Process the pre-reported field values according to the format rules, and generate the second pre-reported data S.

[0026] Further, use RPA to report the second pre-reported data S item by item, including:

[0027] Obtain a piece of the second pre-reported data i;

[0028] According to the second pre-reported data i, obtain the pre-reported field value;

[0029] Enter the pre-reported field value through RPA and generate an entry result;

[0030] After generating the entry result, obtain the second pre-reported data i + 1, where both i and i + 1 belong to S.

[0031] Further, it also includes:

[0032] Set the reporting time parameter;

[0033] Wake up RPA regularly according to the reporting time parameter.

[0034] Further, it also includes:

[0035] Automatically adjust the preset rules, reporting elements, and format rules according to the entry result.

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

[0037] The second aspect of the present application provides a batch data reporting device, including: an acquisition module, the acquisition module is used to acquire batch data M; a screening module, the screening module is used to: according to preset rules, use the streaming computing mode to screen out 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 to: perform formatting processing on the first pre-reported data N to generate the second pre-reported data S that meets the reporting format; and a reporting module, the reporting module is used to report the second pre-reported data S item by item.

[0038] The third aspect of the present application provides an electronic device, including: one or more processors; a memory for storing one or more programs, where when the one or more programs are executed by the one or more processors, the one or more processors execute the above reporting method.

[0039] The fourth aspect of the present application further provides a computer-readable storage medium, on which executable instructions are stored. When the instructions are executed by a processor, the processor is caused to execute the above-mentioned reporting method.

[0040] The fifth aspect of the present application further provides a computer program product, including a computer program, which when executed by a processor implements the above-mentioned reporting method. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Through the following description of the embodiments of the present application with reference to the drawings, the above content and other objects, features and advantages of the present application will become clearer. In the drawings:

[0042] Figure 1 Schematically shows an application scenario diagram of the reporting method, device, equipment, medium and program product according to the embodiments of the present application;

[0043] Figure 2 Schematically shows the structural diagram of the account annual inspection reporting system according to the embodiments of the present application;

[0044] Figure 3 Schematically shows the internal structural diagram of the batch data reporting system according to the embodiments of the present application;

[0045] Figure 4 Schematically shows the flowchart of the batch data reporting method according to the embodiments of the present application;

[0046] Figure 5 Schematically shows the schematic diagram of the streaming computing mode according to the embodiments of the present application;

[0047] Figure 6 Schematically shows the flowchart of the screening method of the first pre-reported data N according to the embodiments of the present application;

[0048] Figure 7 Schematically shows the flowchart of the confirmation method of the first pre-reported data N according to the embodiments of the present application;

[0049] Figure 8 Schematically shows the flowchart of the generation method of the second pre-reported data S according to the embodiments of the present application;

[0050] Figure 9 Schematically shows the flowchart of reporting the second pre-reported data S using RPA according to the embodiments of the present application;

[0051] Figure 10 Schematically shows the schematic diagram of setting the reporting time according to the embodiments of the present application;

[0052] Figure 11 Schematically shows the logical structural diagram of the batch data reporting method according to the embodiments of the present application;

[0053] Figure 12 Schematically shows a structural block diagram of a batch data reporting device according to an embodiment of the present application; and

[0054] Figure 13 Schematically shows a block diagram of an electronic device suitable for implementing a batch data reporting method according to an embodiment of the present application. Detailed implementation manners

[0055] Hereinafter, embodiments of the present application will be described with reference to the accompanying drawings. However, it should be understood that these descriptions are merely exemplary and are not intended to limit the scope of the present application. In the following detailed description, for the sake of explanation, many specific details are set forth to provide a comprehensive understanding of the embodiments of the present application. However, obviously, one or more embodiments can also be implemented without these specific details. In addition, in the following description, descriptions of well-known structures and technologies are omitted to avoid unnecessarily confusing the concepts of the present application.

[0056] The terms used herein are merely for describing specific embodiments and are not intended to limit the present application. The terms "including", "comprising", etc. used herein indicate the presence of the described features, steps, operations, and / or components, but do not exclude the presence or addition of one or more other features, steps, operations, or components.

[0057] All terms used herein (including technical and scientific terms) have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein should be interpreted as having a meaning consistent with the context of this specification and should not be interpreted in an idealized or overly rigid manner.

[0058] In the case of using expressions such as "at least one of A, B, and C, etc.", generally, it should be interpreted according to the meaning commonly understood by those skilled in the art (for example, "a system having at least one of A, B, and C" should include, but not be limited to, a system having only A, only B, only C, having A and B, having A and C, having B and C, and / or having A, B, and C, etc.).

[0059] With the gradual implementation of the regulatory authority's cancellation of the commercial bank account licensing system, some of the services provided by commercial banks for corporate customers have changed from an approval system to a filing system, and it is necessary to report and file in the regulatory authority's account management system according to different customer types and account natures. Reporting and filing is a relatively fixed process and belongs to single, repetitive, and cumbersome transactional work. The largest commercial bank in China adds an average of 1.2 million new customers per year, and the number of accounts is large, requiring a large amount of manpower input from each branch to complete.

[0060] Based on the low efficiency of manual entry methods, there are also potential regulatory inspection risks such as missed filing, late filing, and incorrect filing. Currently, some commercial banks have started to use robots to replace manual entry methods in the annual inspection submission process. However, the working process of the robots is no different from that of humans. They also need to log in to the commercial bank system to search for relevant data according to the filing content that needs to be supplemented in the regulatory agency's account, and then perform single capture for one account. Then, by logging in to the regulatory agency's account management system, the captured account data is entered into the regulatory agency's account management system. This method simply uses robots to replace manual operations, does not form a complete submission process, the efficiency improvement is not significant, and it has the disadvantages of a single process and poor flexibility. Moreover, it fails to classify and allocate the data to be submitted dynamically and efficiently.

[0061] This application establishes an account submission mechanism based on stream computing technology and robotic process automation technology, which can improve the processing efficiency of batch data submission to regulatory agencies. In other words, through the flexible configuration of preset rules, this application can connect to various commercial bank systems to meet the personalized needs of the second pre-reported data S; and through the screening mode of stream computing, multiple first pre-reported data N that meet the requirements can be captured at one time, greatly reducing the average time-consuming of submission and accelerating the submission efficiency.

[0062] Figure 1 An application scenario diagram showing the use of robots to batch data submit to relevant regulatory agencies according to an embodiment of the present application is schematically shown.

[0063] As Figure 1 shown, the application scenario 100 according to this embodiment may include the process of the robot logging in to the account of the relevant regulatory agency management system at the front end and interacting with the server of the relevant regulatory agency management system through the network after uniformly processing batch data as required. The network 104 is a medium for providing 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, etc.

[0064] 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, etc.

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

[0066] Server 105 may be a server that provides various services. For example, it may be a business management server (only for example) that supports the second pre-report data S sent by the terminal devices 101, 102, and 103 for the robot. The business management server may analyze and process the received second pre-report data S and feedback the processing result to the terminal device. For example, it may feedback a success message when the reception is successful and a failure message when the reception fails.

[0067] It should be understood that Figure 1 the numbers of terminal devices, networks, and servers in

[0068] Note that the batch data reporting method of this application is explained based on the interaction scenario of financial institutions. Specifically, it is an expansion explanation for the embodiment of batch reporting of enterprise account annual inspection data of commercial banks to relevant regulatory agencies, but it cannot be used as a limitation to the technical solution of this application.

[0069] The following will be based on Figure 1 the described scenario and will describe in detail the account annual inspection reporting system of the application embodiment through Figures 2 to 11

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

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

[0072] The batch data reporting system is respectively connected to the enterprise-level customer information system, the enterprise account basic business system, the industrial and commercial information system, and the regulatory agency account management system. Among them, this application only improves the process of the batch data reporting system. The enterprise-level customer information system, the enterprise account basic business system, and the industrial and commercial information system can provide the source of the batch data M, and the regulatory agency account management system is the object reported by the robot.

[0073] The specific functions of each system are as follows:

[0074] 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 data such as customer name, business license number, and organization code certificate number.

[0075] The enterprise account basic business system 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 data such as account medium numbers, account opening dates, account attributes, and account types.

[0076] The industrial and commercial information system is mainly responsible for receiving and centrally storing industrial and commercial information data. The batch data that can be provided to the batch data reporting system includes data such as enterprise business scopes, registered addresses, and registered capitals.

[0077] The batch data reporting system is mainly responsible for receiving data provided by existing business systems (such as enterprise-level customer information systems, enterprise account basic business systems, and industrial and commercial information systems). After corresponding processing, it is connected to the regulatory agency account management system to complete the batch reporting of enterprise account annual inspection data. The specific internal structure is as Figure 3 shown.

[0078] The regulatory agency account management system is mainly responsible for connecting to major commercial bank systems (such as the batch data reporting system), receiving and storing information such as account opening, account closing, and fund transfers of each bank, and feeding back the processing results to the connected bank systems after receiving them.

[0079] The interaction of the above-mentioned systems is the existing interaction method. Usually, after staff or robots log in to the batch data reporting system, they query and collect relevant data to be reported from enterprise-level customer information systems, enterprise account basic business systems, and industrial and commercial information systems, and then log in to the regulatory agency account management system to submit and enter the relevant data to be reported into the regulatory agency account management system to complete the supplement of missing data. However, self-reporting by staff may pose potential regulatory inspection risks such as missed filings, late filings, and incorrect filings. Therefore, replacing staff with robots and using a non-intrusive connection to the regulatory agency account management system will not damage the original technical framework of the regulatory agency account management system and save human resources at the same time.

[0080] The internal structure of the batch data reporting system is as Figure 3 shown, mainly including a reporting parameter maintenance unit, a data collection unit, a data automatic screening unit, a reporting element processing unit, and an automatic reporting unit. The connection relationships of each unit are as Figure 3 shown, and the specific functions are as follows:

[0081] 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 this application, and parameterizing and pushing information parameters such as reporting elements, formats, and reporting windows to the corresponding data collection 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 reporting parameter maintenance unit.

[0082] The data acquisition unit is mainly responsible for collecting information data from each peripheral business system (such as the enterprise-level customer information system, the enterprise account basic business system, and the industrial and commercial information system) as needed, and then sending an information data screening notice to the data automatic screening unit.

[0083] The data automatic screening unit is mainly responsible for screening the information data collected by the data acquisition unit according to the data screening rules maintained by the submission parameter maintenance unit. After screening out the information data that meets the filing conditions, it sends a processing notice of the information data that meets the filing conditions to the submission element processing unit.

[0084] The submission element processing unit is mainly responsible for processing the information data to be submitted screened by the data automatic screening unit, and extracting the field information to be entered in the regulatory agency account management system according to the field submission format maintained by the submission parameter maintenance unit for formatting processing.

[0085] The automatic submission unit is based on the submission time window and frequency parameters maintained by the submission parameter maintenance unit, regularly activates the robot and logs in to the regulatory agency account management system in a non-intrusive manner, and processes each piece of the information to be submitted processed by the submission element processing unit one by one.

[0086] Based on Figures 1 - 3 , Figure 4 Schematically shows a flowchart of a batch data submission method according to an embodiment of the present application.

[0087] As Figure 4 shown, this embodiment includes operations S210 to S240.

[0088] In operation S210, batch data M is obtained.

[0089] Obtain the information data pushed by each peripheral business system, receive the data through a general method such as the network and cache it locally.

[0090] The batch data M includes at least one of customer information data, account information data, and industrial and commercial information data, where there is an association relationship between the customer information data, the account information data, and the industrial and commercial information data.

[0091] It can be understood that obtaining Figure 2 the information data in the enterprise-level customer information system, the enterprise account basic business system, and the industrial and commercial information system, the obtained information data can be the information data in one of the above systems, or the collection of information data in multiple systems. For example, it is possible to only collect the account information data in the enterprise account basic business system, and the account information data includes customer number, account medium number, account opening date, account attribute, and account type.

[0092] Of course, there is a correlation among customer information data, account information data, and industrial and commercial information data. By obtaining one of the customer information data, account information data, and industrial and commercial information data, the other two can be associated.

[0093] In one embodiment, a customer number is collected from the enterprise account basic business system. Through the customer number, enterprise information such as enterprise certificates, legal persons, and beneficiaries in the enterprise-level customer information system can be associated, and then through the enterprise certificates, the enterprise industrial and commercial operation information in the industrial and commercial information system can be associated.

[0094] In operation S220, according to a preset rule, the first pre-report data N that meets the reporting content is screened out from the batch data M in the mode of streaming computing, where N belongs to M, and M is greater than or equal to N.

[0095] A data stream refers to a series of dynamic data aggregates that are infinite in terms of time distribution and quantity, and the value of the data decreases over time. Streaming computing can be used to process data streams, which belongs to real-time computing, and has the characteristics of low latency, computable dynamic data, no boundary, and persistence, and is applicable to the scenarios with high timeliness requirements in this application. Figure 1 in the scenarios with relatively high timeliness requirements in this application.

[0096] The streaming computing logic is as Figure 5 shown. The first column is the original data, the second column to the penultimate column are one or more computing nodes, where each computing node contains one or more screening elements, and the last column is the output data after screening.

[0097] Combined with the above streaming computing logic diagram, this application screens the preprocessed batch data M. The batch data M is the original data. According to the preset rule issued by the reporting parameter maintenance unit, the preset rule is placed in each computing node. After screening, the output data is the first pre-report data N that meets the reporting content.

[0098] It can be understood that the first pre-report data N that meets the reporting content is the first processing operation for the robot to complete the reported information. The first pre-report data N after screening is the relevant account with some data information missing for the regulatory agency, and only by reporting the missing data can it be received by the regulatory agency account management system of each local regulatory agency.

[0099] In operation S230, the first pre-report data N is formatted to generate the second pre-report data S that meets the reporting format.

[0100] Since the reporting formats of local regulatory agencies (e.g., reporting requirements, message formats, message fields) are different, it is necessary to format the first pre-reported data N. Only when the processed second pre-reported data S meets the reporting requirements of local regulatory agencies can it be received by the regulatory agency account management systems of local regulatory agencies.

[0101] It can be understood that formatting the first pre-reported data N is the second processing operation on the reported data, and the processed second pre-reported data S is in a format acceptable to relevant regulatory agencies.

[0102] This application can perform dynamic and adaptive formatting on the first pre-reported data N to generate the second pre-reported data S that conforms to the reporting formats of local regulatory agencies. Therefore, the reporting method of this application is universal.

[0103] The reporting method of this application also includes automatically adjusting preset rules, reporting elements, and format rules according to the input results.

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

[0105] In operation S240, the second pre-reported data S is reported item by item using RPA.

[0106] Robotic Process Automation, abbreviated as RPA (Robotic Process Automation), is a software solution that uses intelligent software to simulate and enhance the interaction process between humans and computers and execute repeatable tasks based on certain rules.

[0107] The robot can log in to the regulatory agency account management system, input item by item the missing data (the second pre-reported data S) in the regulatory agency, and submit it after completion. This application combines with the robot to simulate the normal manual operations of staff, such as mouse clicks, dropdown selections, keyboard inputs, etc., to achieve seamless and non-intrusive docking with the regulatory agency account management system without damaging the original technical framework of the regulatory agency account management system.

[0108] It should be noted that non-intrusive means that no code modification is required, and the data is submitted to the regulatory agency account management system by directly simulating the input method.

[0109] According to the batch data reporting method of the present application, on the basis of meeting the supervision requirements of regulatory agencies for commercial bank accounts and preventing business risks, it effectively improves the automated processing level of data to be reported by commercial banks to regulatory agencies, greatly improves the input efficiency of data to be reported, and reduces the situations of missed, late, and incorrect record-filing of accounts. It not only meets the supervision requirements of regulatory agencies, but also reduces the operating costs of commercial banks and relieves the pressure on input personnel.

[0110] In order to facilitate screening using the streaming computing mode, before screening the first pre-reported data N that meets the reporting content from the batch data M using the streaming computing mode according to the preset rules, it is necessary to preprocess the obtained batch data M.

[0111] Specifically, each piece of data a in the batch data M is parsed according to the 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.

[0112] The batch data M undergoes the first processing and the second processing to reach the second pre-reported data S that meets the reporting requirements and can be received by relevant regulatory agencies. The following will be further explained through the attached Figure 6 - Attachment Figure 8 Operation S220 and operation S230 will be further explained.

[0113] Figure 6 The flowchart of the screening method for the first pre-reported data N according to the embodiment of the present application is schematically shown.

[0114] As Figure 6 shown, this embodiment includes operation S310 to operation S330.

[0115] In operation S310, the preset rules are read, and at least one screening element is included in the preset rules.

[0116] The preset rules are read and parsed from the reporting parameter maintenance unit as the screening rules, and at least one screening element is included in the screening rules. For example, the screening rule is: the opening date is xx, the account attribute is the basic account, and the account type is the approved type. In the above example, there are three screening elements, namely the opening date, the account attribute, and the account type.

[0117] In operation S320, the field values corresponding to each screening element in each piece of data a are extracted.

[0118] Extract the field values in each piece of data a according to the screening elements within the preset rules. For example, extract the corresponding field values of the account opening date, account attribute, and account type in each piece of data a.

[0119] In operation S330, confirm the first preliminary reporting data N according to the field values.

[0120] Compare the field values in each piece of data a extracted with the preset rules, and it can be marked to indicate whether it is the first preliminary reporting data N that meets the reporting conditions.

[0121] In one embodiment, it is marked when it is exactly the same, and not marked when at least one item is different. This embodiment is applicable to the scenario where there are multiple screening elements and they are distributed on different computing nodes. When the field values corresponding to all screening elements are the same as the preset rules, it is marked with a symbol, that is, it is recognized as the first preliminary reporting data N that meets the reporting conditions; when the field value corresponding to one of the screening elements is different from the preset rules, it is not marked, that is, it is recognized as data that does not need to be reported. Therefore, when processing in the reporting element processing unit, only the data a with marks is processed.

[0122] In another embodiment, each screening element corresponds to a different mark. When the field value corresponding to the screening element is the same as the preset rule, mark the mark belonging to this screening element, and when the field value corresponding to the screening element is different from the preset rule, it is not marked. When processing in the reporting element processing unit, only the data a with the marks of all screening elements is processed. For example, for three screening elements, there are three corresponding marks, and the first preliminary reporting data N that meets the reporting conditions is the data a with these three marks.

[0123] Furthermore, Figure 7 Schematically shows a flowchart of a method for confirming the first preliminary reporting data N according to an embodiment of the present application.

[0124] As Figure 7 shown, this embodiment includes operation S410 to operation S420.

[0125] Combined with Figure 5 , the preset rule is to extract three patterns of squares, diamonds, and circles, and filter out the colorless ones. The screening elements in the figure are shape and color, and the field values of the screening elements are colorless squares, gray squares, black squares, colorless diamonds, gray diamonds, black diamonds, colorless circles, gray circles, and black circles.

[0126] Each computing node is a judgment rule. According to the above preset rules, computing node 1 is set to screen out three patterns: square, diamond, and circle, and computing node 2 is set to screen out three patterns: colorless square, colorless diamond, and colorless circle. During the calculation process, at computing node 1, the field values of the shapes in the original data that are square, diamond, and circle will be marked. At computing node 2, the field values with square, diamond, and circle marked by computing node 1 are screened by the field value of colorless, and finally the results that meet the preset rules are obtained.

[0127] In operation S410, when the field value meets the preset rules, the field value is marked, where each mark corresponding to each screening element is different.

[0128] By using different marks as the identifiers of different screening elements, after each calculation, the corresponding field values will be marked with the corresponding marks, and the data that meets the preset rules can be quickly distinguished according to the marks, and the data marked with the corresponding marks can be further screened.

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

[0130] Check each field value in data a. When all the field values corresponding to the screening elements are marked, data a is the first pre-report data N.

[0131] In the above embodiments, there are multiple computing nodes, and further screening is performed on the data marked by the computing node in the previous link. In the embodiment with only one computing node screening multiple items, the screening can be achieved by eliminating data a when at least one screening element in the preset rules is missing in data a.

[0132] Figure 8 Schematically shows a flowchart of a method for generating the second pre-report data S according to an embodiment of the present application.

[0133] As Figure 8 shown, this embodiment can format the first pre-report data N, including operation S510 to operation S530.

[0134] In operation S510, obtain the reporting elements and format rules.

[0135] The reporting elements and format rules are formulated by the regulatory agencies in each place. When reporting information data to the regulatory agency account management system of the relevant regulatory agency, the reported information data needs to be formatted into data allowed to be reported, and the reporting elements and format rules need to be obtained from the reporting parameter maintenance unit before reporting.

[0136] In operation S520, extract the pre-reported field values corresponding to each reporting element in each piece of first pre-reported data N.

[0137] Identify the reporting elements from each piece of first pre-reported data N, and then extract the pre-reported field values correspondingly. For example, extract the pre-reported field values corresponding to the reporting element of account opening date in each piece of first pre-reported data N.

[0138] In operation S530, process the pre-reported field values according to the format rules and generate second pre-reported data S.

[0139] Perform formatting processing on the pre-reported field values such as characters, numbers, dates, etc. according to the format of the reporting fields. For example, the date format is YYYY-MM-DD, and the time format is hh:mm:ss.

[0140] It should be noted that the screening elements are the limiting conditions for screening the batch data M, while the reporting elements are the limiting conditions for the first pre-reported data N. The contents of the screening elements and the reporting elements can be the same or different. For example, the first pre-reported data N can be obtained by using the screening elements and field values as the date xx in the batch data M, and then the reporting elements and pre-reported field values with the account attribute being the basic account are extracted from the first pre-reported data N, and the format of the basic account is processed; the first pre-reported data N can be obtained by using the screening elements and field values as the date xx in the batch data M, and then the reporting elements and pre-reported field values that are also the date xx are extracted from the first pre-reported data N, and the date format of xx is processed.

[0141] Figure 9 Schematically shows a flowchart of using RPA to report the second pre-reported data S according to an embodiment of the present application.

[0142] As Figure 9 shown, this embodiment includes operation S610 to operation S640.

[0143] In operation S610, obtain a piece of second pre-reported data i.

[0144] In operation S620, obtain the pre-reported field values according to the second pre-reported data i.

[0145] In operation S630, enter the pre-reported field values through RPA and generate an entry result.

[0146] In operation S640, after generating the entry result, obtain the second pre-reported data i + 1, where both i and i + 1 belong to S.

[0147] The robot logs in to the supervisor account, obtains the value of the pre-reporting field in a second pre-reported data i, enters the value of the pre-reporting field into the supervisor account management system, and completes the submission. After that, the server of the supervisor account management system will feedback the input result (for example, prompt successful input when successful and prompt failed input when failed). After receiving the input result, continue to obtain the next second pre-reported data i+1.

[0148] In one embodiment, when the server of the supervisor account management system receives the value of the pre-reporting field, it feedbacks successful input to the robot after successful reception; when the reception fails, it can make a second reception attempt. If it still fails after a certain number of attempts, it feedbacks failed input to the robot. In subsequent operations, the staff can manually enter each failed feedback information one by one.

[0149] The reporting method of the present application can also set the reporting time, such as Figure 10 shown, including:

[0150] In operation S710, set the reporting time parameter.

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

[0152] In operation S720, wake up the RPA regularly according to the reporting time parameter.

[0153] During use, load the setting of the reporting time parameter into the robot. The robot is regularly woken up according to the reporting time window, and then drives the robot to log in to the supervisor account through the account and password of the supervisor account management system.

[0154] According to the reporting method of the present application, through the collection, screening and filtering, and processing of batch data, the reported data meets the standards. The automatic screening of effective reported data can be efficiently completed by using stream computing. By simulating the interaction between the network teller and the supervisor agency account management system through robotic process automation technology, the information reporting efficiency of newly opened enterprise accounts in commercial banks is effectively improved, and the risks caused by manual omissions and misreports are reduced.

[0155] Based on Figures 1 - 10 , the present application provides a logical structure diagram of the batch data reporting method as shown in Figure 11 .

[0156] Operation S801, input and maintain the reporting parameters through the reporting parameter maintenance unit. The maintained reporting parameters can be provided for use in operation S803, operation S807, and operation S810.

[0157] Operation S802, obtain multiple account information data from the enterprise account basic business system and parse them.

[0158] Operation S803: The data automatic screening unit reads the maintenance reporting parameters and extracts the field values corresponding to the screening elements in each account information data.

[0159] Operation S804: Determine whether the reporting conditions are met, and execute Operation S805 or Operations S806 - S817.

[0160] Operation S805: When not met, eliminate the account information data that does not meet the conditions and end the process.

[0161] Operation S806: When met, the account information data that meets the conditions is the first pre-reporting data N, which is transmitted to the reporting element processing unit.

[0162] Operation S807: The reporting element processing unit reads the maintenance reporting parameters and extracts the pre-reporting field values corresponding to the reporting elements in each first pre-reporting data N.

[0163] Operation S808: Perform formatting processing on the pre-reporting field values to generate the second pre-reporting data S.

[0164] Operation S809: Put all the second pre-reporting data S into the waiting list.

[0165] Operation S810: The automatic reporting unit reads the maintenance reporting parameters and wakes up the robot regularly.

[0166] Operation S811: The robot determines whether there are records to be processed in the waiting list, and executes Operation S812 or Operations S813 - S817.

[0167] Operation S812: When there are no records to be processed in the waiting list, the process ends.

[0168] Operation S813: When there are records to be processed in the waiting list, the robot logs in to the regulatory agency account.

[0169] Operation S814: Obtain a piece of the second pre-reporting data S and enter it.

[0170] Operation S815: Determine whether the entry is successful, and execute Operation S816 or Operation S817.

[0171] Operation S816: When successful, mark it as successful and execute Operation S811.

[0172] Operation S817: When failed, mark it as failed and execute Operation S811.

[0173] Based on the above batch data reporting method, the present application also provides a batch data reporting device. The following will be combined with Figure 12 to describe the device in detail.

[0174] Figure 12 A structural block diagram of batch data according to an embodiment of the present application is schematically shown.

[0175] As Figure 12 shown, the batch data 900 of this embodiment includes an acquisition module 910, a screening module 920, a processing module 930, and a reporting module 940.

[0176] The acquisition module 910 is used to acquire batch data M. In one embodiment, the acquisition module 910 can be used to perform the operation S210 described above, which will not be elaborated here.

[0177] The screening module 920 is used to: according to a preset rule, use the streaming computing mode to screen out the first pre-reporting 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. In one embodiment, the screening module 920 can be used to perform the operation S220 described above, which will not be elaborated here.

[0178] The processing module 930 is used to: perform formatting processing on the first pre-reporting data N to generate the second pre-reporting data S that meets the reporting format. In one embodiment, the processing module 930 can be used to perform the operation S230 described above, which will not be elaborated here. And

[0179] The reporting module 940 is used to report the second pre-reporting data S item by item. In one embodiment, the reporting module 940 can be used to perform the operation S240 described above, which will not be elaborated here.

[0180] According to an embodiment of the present application, any multiple of the acquisition module 910, the screening module 920, the processing module 930, and the reporting module 940 can be combined and implemented in one module, or any one of them can be split into multiple modules. Or, at least part of the functions of one or more of these modules can be combined with at least part of the functions 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 can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on chip, a system on a substrate, a system in a package, an application specific integrated circuit (ASIC), or can be implemented by any other reasonable means such as hardware or firmware for integrating or packaging circuits, or can be implemented in any one of the three implementation manners of software, hardware, and firmware or in any appropriate combination of several of them. Or, at least one of the acquisition module 910, the screening module 920, the processing module 930, and the reporting module 940 can be at least partially implemented as a computer program module, and when the computer program module is run, it can execute the corresponding functions.

[0181] Figure 13 A block diagram of an electronic device suitable for implementing a batch data reporting method according to an embodiment of the present application is schematically shown.

[0182] As Figure 13 shown, the electronic device 1000 according to an embodiment of the present application includes a processor 1001, which 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. The processor 1001 can include, for example, a general microprocessor (e.g., CPU), an instruction set processor, and / or a related chipset, and / or a dedicated microprocessor (e.g., an application specific integrated circuit (ASIC)), etc. The processor 1001 can also include on-board memory for caching purposes. The processor 1001 can include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present application.

[0183] In the RAM 1003, various programs and data required 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 via a bus 1004. The processor 1001 performs various operations of the method flow according to an embodiment of the present application by executing the program in the ROM 1002 and / or the RAM 1003. It should be noted that the program can also be stored in one or more memories other than the ROM 1002 and the RAM 1003. The processor 1001 can also perform various operations of the method flow according to an embodiment of the present application by executing the program stored in the one or more memories.

[0184] According to an embodiment of the present application, the electronic device 1000 can further include an input / output (I / O) interface 1005, and the input / output (I / O) interface 1005 is also connected to the bus 1004. The electronic device 1000 can further include one or more of the following components connected to the I / O interface 1005: an input section 1006 including a keyboard, a mouse, etc.; an output section 1007 including, for example, a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 1008 including a hard disk, etc.; and a communication section 1009 including a network interface card such as a LAN card, a modem, etc. 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 installed on the drive 1010 as needed so that a computer program read from it can be installed into the storage section 1008 as needed.

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

[0186] 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: portable computer disks, hard disks, random access memory (RAM), 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 above. In the present application, the computer-readable storage medium may be any tangible medium that contains or stores a program, and this program can be used by or in combination with an instruction execution system, apparatus, or device. For example, according to the embodiments of the present application, the computer-readable storage medium may include the above-described ROM 1002 and / or RAM 1003 and / or one or more memories other than ROM 1002 and RAM 1003.

[0187] The embodiments of the present application also include a computer program product, which includes a computer program, and the computer program contains program codes for executing the method shown in the flowchart. When the computer program product runs in a computer system, the program codes are used to enable the computer system to implement the item recommendation method provided in the embodiments of the present application.

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

[0189] In one embodiment, the computer program may rely on tangible storage media such as optical storage devices and magnetic storage devices. In another embodiment, the computer program may also be transmitted and distributed in the form of a signal on a network medium, and be downloaded and installed through the communication part 1009, and / or be installed from the removable medium 1011. The program codes included in the computer program may be transmitted by any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the above.

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

[0191] According to the embodiments of the present application, the program code for executing the computer program provided in the embodiments of the present application can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level procedures and / or object-oriented programming languages, and / or assembly / machine languages. The programming languages include but are not limited to, such as Java, C++, Python, the "C" language, or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on a remote computing device, or entirely on a remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (for example, by connecting through the Internet using an Internet service provider).

[0192] The flowcharts and block diagrams in the accompanying drawings illustrate the possible architectures, functions, and operations 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 diagram may represent a module, a program segment, or a part of code, and the above module, program segment, or part of code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the blocks may occur in a different order than marked in the accompanying drawings. For example, two consecutive blocks shown may actually be executed substantially in parallel, and they may sometimes be executed in the reverse order, depending on the functions involved. It should also be noted that each block in the block diagram or flowchart, and the combination of blocks in the block diagram or flowchart, can be implemented by a dedicated hardware-based system for performing the specified functions or operations, or can be implemented by a combination of dedicated hardware and computer instructions.

[0193] Those skilled in the art can understand that the features recited in the various embodiments and / or claims of the present application can be combined or combined in various ways, even if such combinations or combinations are not explicitly recited in the present application. In particular, without departing from the spirit and teachings of the present application, the features recited in the various embodiments and / or claims of the present application can be combined and combined in various ways. All such combinations and / or combinations fall within the scope of the present application.

[0194] In the description of this specification, the descriptions referring to terms such as "one embodiment", "some embodiments", "instances", "specific examples", or "some examples", etc., mean that the specific features, structures, materials, or characteristics described in connection with the embodiment or example are included in at least one embodiment or example of this application. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials, or characteristics described can be combined in a suitable manner in any one or more embodiments or examples.

[0195] The embodiments of this application have been described above. However, these embodiments are only for illustrative purposes and not for limiting the scope of this application. Although the embodiments have been described separately above, this does not mean that the measures in each embodiment cannot be used advantageously in combination. The scope of this application is defined by the appended claims and their equivalents. Without departing from the scope of this application, those skilled in the art can make various substitutions and modifications, and these substitutions and modifications should all fall within the scope of this application.

Claims

1. A method for batch data reporting, characterized in that, Including the following steps: Obtain batch data M; 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 among the customer information data, the account information data, and the industrial and commercial information data; According to preset rules, use the streaming computing mode to screen out the first pre-reporting 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; Perform formatting processing on the first pre-reporting data N to generate the second pre-reporting data S that meets the reporting format; Use RPA to report the second pre-reporting data S item by item; The performing formatting processing on the first pre-reporting data N to generate the second pre-reporting data S that meets the reporting format includes: Obtain reporting elements and format rules; extract the pre-reporting field values corresponding to each reporting element in each first pre-reporting data N; process the pre-reporting field values according to the format rules, and generate the second pre-reporting data S; the reporting elements are the limiting conditions of the first pre-reporting data N; The using RPA to report the second pre-reporting data S item by item includes: Obtain a second pre-reporting data i; according to the second pre-reporting data i, obtain the pre-reporting field value; enter the pre-reporting field value through RPA and generate an entry result; after generating the entry result, obtain the second pre-reporting data i + 1, where both i and i + 1 belong to S.

2. The method for batch data reporting according to claim 1, characterized in that, Before screening out the first pre-reporting data N that meets the reporting content from the batch data M according to preset rules using the streaming computing mode, the method further includes: Parse each data a in the batch data M according to a preset format, where a belongs to M.

3. The method for batch data reporting according to claim 2, characterized in that, According to preset rules, using the streaming computing mode to screen out the first pre-reporting data N that meets the reporting content from the batch data M includes: Read the preset rules, and the preset rules include at least one screening element; Extract the field values corresponding to each screening element in each data a; Confirm the first pre-reporting data N according to the field values.

4. The method for batch data reporting according to claim 3, characterized in that, Confirming the first pre-reporting data N according to the field values includes: When the field values meet the preset rules, mark the field values, where the marks corresponding to each screening element are different; When all the field values in the data a are marked, the data a is the first pre-reporting data N.

5. The method for batch data reporting according to claim 4, characterized in that, It further includes: When at least one screening element in the preset rules is missing in the data a, eliminate the data a.

6. The method for batch data reporting according to claim 1, characterized in that, It further includes: Set the reporting time parameter; Wake up RPA regularly according to the reporting time parameter.

7. The method for batch data reporting according to claim 6, characterized in that, It further includes: Automatically adjust the preset rules, reporting elements, and format rules according to the entry result.

8. A batch data reporting device, comprising: An acquisition module, the acquisition module is used to acquire batch data M; 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 among the customer information data, the account information data, and the industrial and commercial information data; A screening module, which is used to: according to a preset rule, use the streaming computing mode to screen out the first pre-reporting 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, which is used to: perform formatting processing on the first pre-reporting data N to generate the second pre-reporting data S that meets the reporting format; and A reporting module, which is used to report the second pre-reporting data S item by item; The processing module is further used to obtain reporting elements and format rules; extract the pre-reporting field values corresponding to each reporting element in each first pre-reporting data N; process the pre-reporting field values according to the format rules, and generate the second pre-reporting data S; the reporting elements are the limiting conditions of the first pre-reporting data N; The reporting module is further used to obtain a second pre-reporting data i; according to the second pre-reporting data i, obtain the pre-reporting field value; enter the pre-reporting field value through RPA, and generate an entry result; after generating the entry result, obtain the second pre-reporting data i + 1, where both i and i + 1 belong to S.

9. An electronic device, comprising: One or more processors; A storage device for storing one or more programs, wherein, when the one or more programs are executed by the one or more processors, the one or more processors are caused to execute the reporting method according to any one of claims 1 to 7.

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

11. A computer program product, comprising a computer program, which when executed by a processor implements the reporting method according to any one of claims 1 to 7.

Images