A method and device for screening risk information of social security fund payment data

Abstract

The present invention provides a method and device for screening risk information of social security fund disbursement data, which can be used in the financial field or other technical fields. The method includes: constructing a second social security fund disbursement database, which is a non-relational database; searching the second social security fund disbursement database according to risk screening conditions to obtain document records that meet the risk screening conditions. The device is used to execute the above method. The method and device for screening risk information of social security fund disbursement data provided by an embodiment of the present invention migrate the social security fund disbursement data stored in a relational database to a non-relational database. When screening the risk information of social security fund disbursement data, searching the non-relational database according to the risk screening conditions reduces the aggregation operation of the data and improves the efficiency of risk screening.

Description

Technical Field

[0001] The present invention relates to the field of data screening technology, and in particular to a method and device for screening risk information of social security fund disbursement data. Background Art

[0002] The data on social security fund disbursement is increasing day by day, and the risk information records will also gradually increase. In order to detect various risks in the process of social security fund disbursement, it is necessary to regularly compile statistics on social security fund disbursement record data and timely screen the risk information therein.

[0003] Currently, social security fund payment data is a strongly relational data type. To ensure data security and accuracy, it is generally stored in a relational database. However, when risk screening and retrieval of social security fund payment data are required, the aggregation of massive amounts of data is very time-consuming. When the volume of social security fund payment data reaches billions, the aggregation of data may even affect the stability of the relational database service that stores the data, making it impossible to screen for risks. Summary of the Invention

[0004] In response to the problems in the prior art, an embodiment of the present invention provides a method and device for screening risk information of social security fund payment data, which can at least partially solve the problems in the prior art.

[0005] In one aspect, the present invention provides a method for screening risk information of social security fund disbursement data, comprising:

[0006] Building a second social security fund payment database, where the second social security fund payment database is a non-relational database;

[0007] The second social security fund payment database is obtained based on the migration of data fields in the first social security fund payment database, and the first social security fund payment database is a relational database;

[0008] Searching the second social security fund disbursement database according to the risk screening conditions to obtain document records that meet the risk screening conditions;

[0009] Wherein, the risk screening conditions are pre-set.

[0010] Furthermore, the first social security fund payment database is established by the following steps:

[0011] Obtaining social security payment data, including business detail serial number and business data;

[0012] Splitting the business data according to business meaning to obtain the data fields;

[0013] A table structure is created for the data field with the business detail serial number as the first index value to establish the first social security fund payment database.

[0014] Furthermore, a search is performed in the second social security fund disbursement database according to the risk screening conditions to obtain document records that meet the risk screening conditions, including:

[0015] Using the risk screening condition to search the second social security fund payment database, to obtain a risk data result set corresponding to the risk screening condition;

[0016] The risk data result set is converted into a list object and written into an Excel table to obtain the document records that meet the risk screening conditions.

[0017] Furthermore, the social security payment data includes historical social security payment data and real-time newly added social security payment data.

[0018] Furthermore, the second social security fund disbursement database is obtained based on the data field migration in the first social security fund disbursement database, including:

[0019] Build a non-relational database cluster environment;

[0020] Creating a second index value in the non-relational database cluster environment that is the same as the business detail serial number serving as the first index value in the data field;

[0021] Create a document in the non-relational database cluster environment using each second index value as an ID, wherein the document corresponds to the second index value one-to-one;

[0022] The data field in the first social security fund disbursement database is retrieved, and the data field is written into the document according to the mapping relationship between the first index value and the second index value, so as to establish the second social security fund disbursement database.

[0023] Furthermore, the mapping relationship between the first index value and the second index value is that the first index value and the second index value correspond to the same business detail serial number.

[0024] Furthermore, the second social security fund payment database is an ElasticSearch non-relational database.

[0025] In another aspect, the present invention provides a device for screening risk information of social security fund disbursement data, comprising:

[0026] A non-relational database module, used to construct a second social security fund payment database, where the second social security fund payment database is a non-relational database;

[0027] The second social security fund payment database is obtained based on the migration of data fields in the first social security fund payment database, and the first social security fund payment database is a relational database;

[0028] a risk screening module, configured to search the second social security fund disbursement database according to risk screening conditions to obtain document records that meet the risk screening conditions;

[0029] Wherein, the risk screening conditions are pre-set.

[0030] On the other hand, the present invention provides an electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the steps of the method for screening risk information of social security fund disbursement data described in any of the above embodiments are implemented.

[0031] On the other hand, the present invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the method for screening risk information of social security fund disbursement data described in any of the above embodiments.

[0032] The method and device for screening risk information of social security fund disbursement data provided in the embodiments of the present invention migrate the social security fund disbursement data stored in a relational database to a non-relational database. When screening risk information of social security fund disbursement data, retrieval is performed in the non-relational database according to the risk screening conditions, thereby reducing the aggregation operation of the data and improving the efficiency of risk screening. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative work. In the drawings:

[0034] Figure 1 It is a flowchart of a method for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0035] Figure 2 It is a flowchart of a method for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0036] Figure 3It is a flowchart of a method for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0037] Figure 4 It is a flowchart of a method for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0038] Figure 5 It is a structural diagram of a device for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0039] Figure 6 It is a structural diagram of a device for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0040] Figure 7 It is a structural diagram of a device for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0041] Figure 8 It is a structural diagram of a device for screening risk information of social security fund disbursement data provided by one embodiment of the present invention.

[0042] Figure 9 It is a schematic diagram of the physical structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0043] To make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. Here, the illustrative embodiments of the present invention and their descriptions are used to explain the present invention, but are not intended to limit the present invention. It should be noted that, unless there is a conflict, the embodiments and features in the embodiments of this application can be combined with each other in any manner.

[0044] The execution entities of the method for screening risk information of social security fund disbursement data provided by the embodiment of the present invention include but are not limited to computers and servers.

[0045] Figure 1 FIG. 1 is a flow chart of a method for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 1 As shown, the method for screening risk information of social security fund payment data provided by the embodiment of the present invention includes:

[0046] S101: Constructing a second social security fund disbursement database, where the second social security fund disbursement database is a non-relational database; wherein the second social security fund disbursement database is obtained by migrating data fields from a first social security fund disbursement database, where the first social security fund disbursement database is a relational database;

[0047] In this step, the data stored in the first social security fund payment database is migrated and a second social security fund payment database is constructed.

[0048] Specifically, the social security fund payment data is a strongly relational data. In order to accurately record the above information, the social security fund payment data is stored in a relational database. For example, the social security fund payment data is stored in a relational database in the form of a table with rows and columns.

[0049] The social security fund disbursement data includes a business detail serial number and business data; wherein, the business data includes a description of the business type, business transaction time, type of insurance issued, type of issuing entity, issuing entity number, issuing entity name, issuing unit number, issuing unit name, recipient ID type, recipient ID number, disbursement amount, actual recipient bank account number, actual recipient account name, agent bank name, bank account arrival information, transaction channel, transaction venue, payment mode, etc. Each of the business detail serial numbers corresponds one-to-one to the corresponding business data group.

[0050] The social security payment data includes historical social security payment data and real-time newly added social security payment data.

[0051] The social security fund payment data is cleaned and processed, and after calculating, converting and supplementing the default data according to the relational database field definition and data type constraints, it is written into the relational database. The steps for establishing the first social security fund payment database are detailed below and will not be repeated here.

[0052] The social security fund disbursement data in the first social security fund disbursement database is retrieved and written into the second social security fund disbursement database. The second social security fund disbursement database is a non-relational database. The method for obtaining the second social security fund disbursement database based on data field migration in the first social security fund disbursement database is described in detail below and is not further described here.

[0053] S102: Searching the second social security fund disbursement database according to the risk screening conditions to obtain document records that meet the risk screening conditions; wherein the risk screening conditions are pre-set.

[0054] In this step, the pre-set risk screening conditions are used to retrieve document records that meet the risk screening conditions in the second social security fund payment database.

[0055] Specifically, the risk screening conditions are set according to the corresponding risks of social security fund payment. For example, when the risk of social security fund payment is that the recipient's ID number is inconsistent with the actual benefit recipient's number, the risk screening conditions are written according to the meaning of the database field corresponding to the social security fund payment risk. At this time, the risk screening condition is "recipient's ID number ≠ actual recipient's ID number".

[0056] According to the pre-set risk screening conditions, a search is performed in the second social security fund payment database to obtain documents that meet the risk screening conditions.

[0057] The method and device for screening risk information of social security fund disbursement data provided in the embodiments of the present invention migrate the social security fund disbursement data stored in a relational database to a non-relational database. When screening risk information of social security fund disbursement data, retrieval is performed in the non-relational database according to the risk screening conditions, thereby reducing the aggregation operation of the data and improving the efficiency of risk screening.

[0058] Figure 2 FIG. 1 is a flow chart of a method for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 2 As shown, the first social security fund payment database is established by the following steps:

[0059] S201: Acquire social security payment data, including business detail serial number and business data;

[0060] In this step, social security payment data is obtained and stored.

[0061] Specifically, the social security payment data includes business detail serial number and business data; wherein, the business data includes business type description, business transaction time, payment type, payment subject type, payment subject number, payment subject name, payment unit number, payment unit name, recipient ID type, recipient ID number, payment amount, actual recipient bank account number, actual recipient account name, agent bank name, bank account arrival information, transaction channel, transaction venue, payment mode, etc., and each of the business detail serial number corresponds one-to-one to the corresponding business data.

[0062] The social security payment data includes historical social security payment data and real-time newly added social security payment data.

[0063] S202: Split the business data according to business meaning to obtain the data fields;

[0064] In this step, the business data is preprocessed to obtain corresponding data fields.

[0065] Specifically, each data item in the business data is split according to actual business meaning to obtain corresponding data fields.

[0066] S203: Create a table structure for the data field with the business detail serial number as the first index value, and establish the first social security fund payment database.

[0067] In this step, a first social security fund payment database is established based on the data fields and the corresponding business detail serial numbers.

[0068] Specifically, the data fields and the corresponding business detail serial numbers are used to establish a table structure to construct a relational database environment.

[0069] Each of the business detail serial numbers and its corresponding data fields are written into the relational database as a row or a column of the table structure, and the business detail serial number in the above row / column is used as the unique index of the row / column data field, that is, the first index value, to obtain the first social security fund payment database.

[0070] Figure 3 FIG. 1 is a flow chart of a method for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 3 As shown, the second social security fund payment database is obtained based on the data field migration in the first social security fund payment database, including:

[0071] S301: Build a non-relational database cluster environment;

[0072] In this step, a non-relational database cluster environment is built.

[0073] Specifically, the necessary operating environment of the non-relational database is installed.

[0074] S302: Creating a second index value in the non-relational database cluster environment that is the same as the business detail serial number serving as the first index value in the data field;

[0075] In this step, a second index value that is the same as the first index value is created in the non-relational database cluster environment constructed in S301.

[0076] Specifically, in order to accurately migrate the social security payment data in the first social security fund payment database to the second social security fund payment database, it is first necessary to create an index for the data field corresponding to each business detail serial number in the second social security fund payment database.

[0077] In order to ensure the universality of the data in the migrated database, when establishing an index for the data field corresponding to each business detail serial number in the second social security fund payment database, the business detail serial number corresponding to the data field is still used as the index as the second index value corresponding to the data field in the second social security fund payment database.

[0078] S303: Using each second index value as an ID, create a document in the non-relational database cluster environment, where the document corresponds to the second index value in a one-to-one manner;

[0079] In this step, a corresponding document is created in the non-relational database cluster environment using each second index value as an ID.

[0080] Specifically, the non-relational database is a document-based database, in which the data model is a versioned document, and the versioned document is stored in the database in a specific format.

[0081] With each second index value established in S302 as the ID of the document, a document is established in the non-relational database cluster environment, and each of the documents is used to store the second index value, that is, the business detail serial number, and the corresponding data field, so that the data field corresponding to the business data under each business detail serial number is stored in the second social security fund payment database.

[0082] S304: Retrieve the data field from the first social security fund disbursement database, write the data field into the document according to the mapping relationship between the first index value and the second index value, and establish the second social security fund disbursement database.

[0083] In this step, the data fields under each business serial number in the first social security fund payment database are written into the document established in S303 according to the mapping relationship, thereby constructing a second social security fund payment database.

[0084] Specifically, the first social security fund payment database is a table structure, and each business detail serial number and its corresponding data field are written into the relational database as a row or a column of the table structure, and the business detail serial number in the above row / column is used as the unique index of the row / column data field.

[0085] According to the business detail serial number, that is, the first index value, the data fields stored in the corresponding rows / columns in the table structure are extracted; according to the correspondence between the first index value and the second index value, the data fields corresponding to the first index value are written into the corresponding document with the second index value as the ID, thereby constructing the second social security fund payment database.

[0086] The mapping between the first index value and the second index value is that the first index value and the second index value correspond to the same business detail serial number.

[0087] Specifically, in order to ensure the universality of the data in the migrated database, when the data field corresponding to the first index value is written into the corresponding document in the second social security fund payment database, the data field is written into the document with the second index value as the ID being the same as the business detail serial number corresponding to the first index value according to the mapping relationship between the first index value and the second index value.

[0088] Figure 4 FIG. 1 is a flow chart of a method for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 4 As shown, according to the risk screening conditions, the second social security fund payment database is searched to obtain document records that meet the risk screening conditions, including:

[0089] S401: Searching the second social security fund payment database using the risk screening condition to obtain a risk data result set corresponding to the risk screening condition;

[0090] In this step, the data in the second social security fund payment database is searched to obtain a result set of social security payment data that meets the risk screening conditions.

[0091] Specifically, a search is performed in the second social security fund disbursement database based on pre-set risk screening conditions. The search is performed on the data fields in each document in the second social security fund disbursement database. If it is determined that the data fields in the document meet the risk screening conditions, the document is added to the risk data result set corresponding to the risk screening conditions. Compared to the prior art method of using the risk screening conditions to search for fields in a relational database, when searching in this embodiment, since there is no strong correlation between data fields in a non-relational database, the amount of aggregation operations performed during the search is relatively small, resulting in a higher screening speed when performing risk screening on massive amounts of social security fund disbursement data.

[0092] S402: Convert the risk data result set into a list object and write it into an Excel table to obtain the document records that meet the risk screening conditions.

[0093] In this step, the data fields in the risk data result set are converted into a table to obtain a document record of the risk screening conditions that is easy to view.

[0094] Specifically, the risk data result set obtained in S401 is a set of data fields of documents in the second social security payment database that meet the risk screening conditions.

[0095] Extract the data fields from each document and write them into an Excel table as a row or column in the Excel table to obtain the document records corresponding to the risk screening conditions. When you need to view the data that meets the risk screening conditions, the Excel table is more convenient for querying or retrieving.

[0096] On the basis of the above embodiments, further, the second social security fund payment database is an ElasticSearch non-relational database.

[0097] Taking the second social security fund payment database as an ElasticSearch non-relational database as an example, the screening method for risk information of the social security fund payment data is as follows:

[0098] Step 1: Build a relational database.

[0099] S1: Split the social security payment data (the social security payment data includes the business detail serial number and business data) into database fields according to the actual obligation meaning, and create a table structure in the relational database, using the "business detail serial number" field as the first index value of the data, and write it into the relational database one by one according to the entry.

[0100] Step 2: Build a non-relational database ElasticSearch cluster.

[0101] S2: Build an ElasticSearch non-relational database cluster environment.

[0102] S3: Create a second index value with the same name as the first index value in the relational database in the database cluster environment.

[0103] S4: Use the Java program to retrieve the data fields of the relational database one by one, use each second index value as the ID, and write the corresponding data fields of the relational database into the ElasticSearch non-relational database through the High Level REST Client officially provided by ElasticSearch. The data field corresponding to each business detail serial number corresponds to a document in the ElasticSearch database, and the field name and field value correspond one-to-one with the field name and field value in the relational database.

[0104] Step 3: Write ElasticSearch risk screening conditions (Domain Specific Language, DSL) to retrieve and analyze risk information on documents in ElasticSearch.

[0105] S5: Based on the screening conditions of risk information, such as the inconsistency between the recipient's ID number and the actual recipient's number; repeated receipt of a specific insurance type with an amount greater than 5,000 yuan, etc., corresponding to the meaning of the document fields in the ElasticSearch database, write risk screening conditions (Domain Specific Language, DSL) to implement Boolean filtering, field aggregation and other calculation operations on the document records in ElasticSearch, and then retrieve the risk document result set that meets the screening conditions.

[0106] Step 4: Get the result set and generate a report.

[0107] S6: Use the Apache POI component in Java to write the result set into an Excel spreadsheet to generate a risk information document record.

[0108] Figure 5 FIG. 1 is a schematic diagram of a device for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 5 As shown, the device for screening risk information of social security fund disbursement data provided by the embodiment of the present invention includes a non-relational database module 501 for constructing a second social security fund disbursement database, which is a non-relational database; wherein the second social security fund disbursement database is obtained based on the data field migration in the first social security fund disbursement database, which is a relational database; a risk screening module 502 for searching the second social security fund disbursement database according to risk screening conditions to obtain document records that meet the risk screening conditions; wherein the risk screening conditions are pre-set. Wherein:

[0109] The non-relational database module 501 is used to migrate the data stored in the first social security fund payment database and construct a second social security fund payment database.

[0110] The risk screening module 502 is configured to use preset risk screening conditions to retrieve document records that meet the risk screening conditions in the second social security fund payment database.

[0111] The method and device for screening risk information of social security fund disbursement data provided in the embodiments of the present invention migrate the social security fund disbursement data stored in a relational database to a non-relational database. When screening risk information of social security fund disbursement data, retrieval is performed in the non-relational database according to the risk screening conditions, thereby reducing the aggregation operation of the data and improving the efficiency of risk screening.

[0112] Figure 6 FIG. 1 is a schematic diagram of a device for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 6 As shown, the device for screening risk information of social security fund disbursement data provided by the embodiment of the present invention further includes: an acquisition module 503 for acquiring social security disbursement data, wherein the social security disbursement data includes a business detail serial number and business data; a pre-processing module 504 for splitting the business data according to business meaning to obtain the data fields; and a relational database module 505 for creating a table structure for the data fields with the business detail serial number as the first index value to establish the first social security fund disbursement database. Among them:

[0113] The acquisition module 503 is used to acquire social security payment data and store the social security payment data.

[0114] The pre-processing module 504 is used to pre-process the business data to obtain corresponding data fields.

[0115] The relational database module 505 is used to establish a first social security fund payment database based on the data fields and the corresponding business detail serial numbers.

[0116] Figure 7 FIG. 1 is a schematic diagram of a device for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 7 As shown, the non-relational database module 501 includes: an environment generation unit 5011, which is used to build a non-relational database cluster environment; an index unit 5012, which is used to create a second index value in the non-relational database cluster environment that is the same as the business detail serial number as the first index value in the data field; a document generation unit 5013, which is used to establish a document in the non-relational database cluster environment with each second index value as an ID, and the document corresponds to the second index value one-to-one; a generation unit 5014, which is used to extract the data field in the first social security fund disbursement database, write the data field into the document according to the mapping relationship between the first index value and the second index value, and establish the second social security fund disbursement database. Among them:

[0117] The environment generation unit 5011 is used to build a non-relational database cluster environment.

[0118] The index unit 5012 is used to create a second index value that is the same as the first index value in the non-relational database cluster environment built in the environment generation unit 5011.

[0119] The document generating unit 5013 is configured to create a corresponding document in the non-relational database cluster environment using each second index value as an ID.

[0120] The generating unit 5014 is used to write the data fields under each business serial number in the first social security fund disbursement database into the document created by the document generating unit 5013 according to the mapping relationship, thereby constructing a second social security fund disbursement database.

[0121] Figure 8 FIG. 1 is a schematic diagram of a device for screening risk information of social security fund disbursement data provided by an embodiment of the present invention. Figure 8 As shown, the risk screening module 502 includes: a screening unit 5021, which is used to use the risk screening conditions to search the second social security fund disbursement database to obtain a risk data result set corresponding to the risk screening conditions; a document generation unit 5022, which is used to convert the risk data result set into a list object and write it into an Excel table to obtain the document record that meets the risk screening conditions.

[0122] The screening unit 5021 is used to search the data in the second social security fund payment database to obtain a result set of social security payment data that meets the risk screening conditions.

[0123] The document generation unit 5022 is used to convert the data fields in the risk data result set into a table to obtain a document record of the risk screening conditions that is easy to view.

[0124] The server embodiment provided by the embodiment of the present invention can be specifically used to execute the processing flow of the above-mentioned method embodiments. Its functions are not described in detail here, and reference can be made to the detailed description of the above-mentioned method embodiments.

[0125] It should be noted that the method and device for screening risk information of social security fund disbursement data provided by the embodiments of the present invention can be used in the financial field, and can also be used in any technical field other than the financial field. The embodiments of the present invention do not limit the application field of the method and device for screening risk information of social security fund disbursement data.

[0126] Figure 9 A schematic diagram of the physical structure of an electronic device provided by an embodiment of the present invention is shown in FIG. Figure 9As shown, the electronic device may include: a processor 901, a communication interface 902, a memory 903, and a communication bus 904, wherein the processor 901, the communication interface 902, and the memory 903 communicate with each other via the communication bus 904. The processor 901 may call the logic instructions in the memory 903 to execute the following method: constructing a second social security fund disbursement database, which is a non-relational database; wherein the second social security fund disbursement database is obtained based on the data field migration in the first social security fund disbursement database, which is a relational database; searching the second social security fund disbursement database according to risk screening conditions to obtain document records that meet the risk screening conditions; wherein the risk screening conditions are pre-set.

[0127] In addition, the logic instructions in the above-mentioned memory 903 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0128] This embodiment discloses a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium, and the computer program includes program instructions. When the program instructions are executed by a computer, the computer can execute the methods provided by the above-mentioned method embodiments, for example, including: constructing a second social security fund disbursement database, which is a non-relational database; wherein the second social security fund disbursement database is obtained based on the data field migration in the first social security fund disbursement database, and the first social security fund disbursement database is a relational database; searching the second social security fund disbursement database according to risk screening conditions to obtain document records that meet the risk screening conditions; wherein the risk screening conditions are pre-set.

[0129] This embodiment provides a computer-readable storage medium, which stores a computer program, and the computer program enables the computer to execute the methods provided by the above-mentioned method embodiments, for example, including: constructing a second social security fund disbursement database, which is a non-relational database; wherein the second social security fund disbursement database is obtained based on the data field migration in the first social security fund disbursement database, and the first social security fund disbursement database is a relational database; searching in the second social security fund disbursement database according to risk screening conditions to obtain document records that meet the risk screening conditions; wherein the risk screening conditions are pre-set.

[0130] It will be understood by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Thus, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0131] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0132] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0133] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0134] Throughout this specification, reference to terms such as "one embodiment," "a specific embodiment," "some embodiments," "for example," "example," "specific example," or "some examples" means that the specific features, structures, materials, or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.

[0135] The specific embodiments described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific embodiment of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for screening risk information of social security fund disbursement data, characterized in that: include: Building a second social security fund payment database, where the second social security fund payment database is a non-relational database; The second social security fund payment database is obtained based on the migration of data fields in the first social security fund payment database, and the first social security fund payment database is a relational database; Searching the second social security fund disbursement database according to the risk screening conditions to obtain document records that meet the risk screening conditions; Wherein, the risk screening conditions are pre-set; The first social security fund payment database is established by the following steps: Obtaining social security payment data, including business detail serial number and business data; Splitting the business data according to business meaning to obtain the data fields; Create a table structure for the data field with the business detail serial number as the first index value, and establish the first social security fund payment database; The second social security fund payment database is obtained based on the data field migration in the first social security fund payment database, including: Build a non-relational database cluster environment; Creating a second index value in the non-relational database cluster environment that is the same as the business detail serial number serving as the first index value in the data field; Creating a document in the non-relational database cluster environment using each second index value as an ID, wherein the document corresponds one-to-one to the second index value; wherein the non-relational database is a document-based database, wherein the data model in the document-based database is a versioned document, and the versioned document is stored in the database in a specific format; The data field in the first social security fund disbursement database is retrieved, and the data field is written into the document according to the mapping relationship between the first index value and the second index value, so as to establish the second social security fund disbursement database.

2. The method for screening risk information of social security fund disbursement data according to claim 1, characterized in that: The social security payment data includes historical social security payment data and real-time newly added social security payment data.

3. The method for screening risk information of social security fund disbursement data according to claim 1, characterized in that: The mapping relationship between the first index value and the second index value is that the first index value and the second index value correspond to the same business detail serial number.

4. The method for screening risk information of social security fund disbursement data according to claim 1, characterized in that: Search the second social security fund payment database according to the risk screening conditions to obtain document records that meet the risk screening conditions, including: Using the risk screening condition to search the second social security fund payment database, to obtain a risk data result set corresponding to the risk screening condition; The risk data result set is converted into a list object and written into an Excel table to obtain the document records that meet the risk screening conditions.

5. The method for screening risk information of social security fund disbursement data according to any one of claims 1 to 4, characterized in that: The second social security fund payment database is an ElasticSearch non-relational database.

6. A device for screening risk information of social security fund disbursement data, characterized in that: include: A non-relational database module, used to construct a second social security fund payment database, where the second social security fund payment database is a non-relational database; The second social security fund payment database is obtained based on the migration of data fields in the first social security fund payment database, and the first social security fund payment database is a relational database; a risk screening module, configured to search the second social security fund disbursement database according to risk screening conditions to obtain document records that meet the risk screening conditions; Wherein, the risk screening conditions are pre-set; Among them, the screening device for risk information of social security fund payment data also includes: An acquisition module is used to obtain social security payment data, wherein the social security payment data includes a business detail serial number and business data; A pre-processing module, configured to split the business data according to business meanings to obtain the data fields; A relational database module, configured to create a table structure for the data field using the business detail serial number as a first index value, and establish the first social security fund payment database; Among them, the non-relational database module includes: Environment generation unit, used to build a non-relational database cluster environment; An indexing unit, configured to create, in the non-relational database cluster environment, a second index value identical to the business detail serial number serving as the first index value in the data field; a document generation unit, configured to create a document in the non-relational database cluster environment using each second index value as an ID, wherein the document corresponds to the second index value in a one-to-one manner; wherein the non-relational database is a document-based database, wherein the data model in the document-based database is a versioned document, and wherein the versioned document is stored in the database in a specific format; A generating unit is used to retrieve the data field in the first social security fund disbursement database, write the data field into the document according to the mapping relationship between the first index value and the second index value, and establish the second social security fund disbursement database.

7. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 5 are implemented.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.

Images