CN115034917A - Screening method and device for social security fund release data risk information - Google Patents
Screening method and device for social security fund release data risk information Download PDFInfo
- Publication number
- CN115034917A CN115034917A CN202210788899.2A CN202210788899A CN115034917A CN 115034917 A CN115034917 A CN 115034917A CN 202210788899 A CN202210788899 A CN 202210788899A CN 115034917 A CN115034917 A CN 115034917A
- Authority
- CN
- China
- Prior art keywords
- social security
- data
- database
- risk
- screening
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Abstract
The invention provides a screening method and a screening device for social security fund release data risk information, which can be used in the financial field or other technical fields, wherein the method comprises the following steps: constructing a second social security fund issuing database which is a non-relational database; and searching in the second social security fund issuing database according to the risk screening condition to obtain a document record conforming to the risk screening condition. The device is used for executing the method. According to the screening method and device for the risk information of the social security fund issuing data, the social security fund issuing data stored in the relational database are transferred to the non-relational database, and when the risk information of the social security fund issuing data is screened, the social security fund issuing data is retrieved in the non-relational database according to the risk screening condition, so that the aggregation operation on the data is reduced, and the risk screening efficiency is improved.
Description
Technical Field
The invention relates to the technical field of data screening, in particular to a screening method and a screening device for risk information of social security fund release data.
Background
The social security fund issuing data is increasing day by day, and the risk information records are also increasing gradually, so that the social security fund issuing record data needs to be counted regularly and the risk information in the social security fund issuing record data needs to be screened timely in order to check various risks in the social security fund issuing process.
At present, because the social security fund issuing data is a strong relational data type, in order to ensure the safety of the data and the accuracy of data record, the social security fund issuing data is generally stored in a relational database, when risk screening is needed and then the social security fund issuing data is retrieved, time is consumed due to the aggregation operation of mass data, when the magnitude of the social security fund issuing data reaches hundreds of millions, the aggregation operation of the data even influences the stability of the service of the relational database for storing the social security fund issuing data, and the risk cannot be screened.
Disclosure of Invention
To solve the problems in the prior art, embodiments of the present invention provide a method and an apparatus for screening risk information of social security fund release data, which can at least partially solve the problems in the prior art.
In one aspect, the present invention provides a method for screening risk information of social security fund release data, including:
constructing a second social security fund issuing database which is a non-relational database;
the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database;
retrieving in the second social security fund issuing database according to a risk screening condition to obtain a document record conforming to the risk screening condition;
wherein the risk screening condition is preset.
Further, the first social security funds release database is established by the following steps:
obtaining social security issuing data, wherein the social security issuing data comprises a service detail serial number and service data;
splitting the service data according to service meaning to obtain the data field;
and establishing a table structure by using the data field and the service detail serial number as a first index value, and establishing the first social security fund issuing database.
Further, retrieving in the second social security fund issuing database according to a risk screening condition to obtain a document record meeting the risk screening condition, including:
retrieving in the second social security fund issuing database by using the risk screening condition to obtain a risk data result set corresponding to the risk screening condition;
and converting the risk data result set into a list object and writing the list object into an Excel table to obtain the document record meeting the risk screening condition.
Furthermore, the social security issuing data comprises historical social security issuing data and newly added social security issuing data in real time.
Further, the second social security funds release database is obtained based on the data field migration in the first social security funds release database, and the method comprises the following steps:
building a non-relational database cluster environment;
creating a second index value in the non-relational database cluster environment that is the same as the traffic detail flow number in the data field as the first index value;
establishing documents in the non-relational database cluster environment by taking each second index value as an ID, wherein the documents correspond to the second index values one to one;
and taking out the data field in the first social security fund issuing database, writing the data field into the document according to the mapping relation between the first index value and the second index value, and establishing the second social security fund issuing database.
Further, the mapping relationship is that 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 service detail serial number.
Further, the second social security funds release database is an ElasticSearch non-relational database.
In another aspect, the present invention provides a screening device for risk information of social security fund release data, including:
the non-relational database module is used for constructing a second social security fund issuing database, and the second social security fund issuing database is a non-relational database;
the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database;
the risk screening module is used for retrieving in the second social security fund issuing database according to risk screening conditions to obtain document records meeting the risk screening conditions;
wherein the risk screening condition is preset.
In another aspect, the present invention provides an electronic device, which includes a storage, a processor, and a computer program stored on the storage and executable on the processor, and the processor executes the computer program to implement the steps of the method for screening social security funds release data risk information according to any of the embodiments.
In still another aspect, the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the method for screening risk information of social security fund release data according to any one of the above embodiments.
According to the screening method and device for the risk information of the social security fund issuing data, the social security fund issuing data stored in the relational database are transferred to the non-relational database, and when the risk information of the social security fund issuing data is screened, the social security fund issuing data is retrieved in the non-relational database according to the risk screening condition, so that the aggregation operation on the data is reduced, and the risk screening efficiency is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
fig. 1 is a flowchart illustrating a method for screening risk information of social security fund release data according to an embodiment of the present invention.
Fig. 2 is a flowchart illustrating a method for screening risk information of social security fund release data according to an embodiment of the present invention.
Fig. 3 is a flowchart illustrating a method for screening risk information of social security fund release data according to an embodiment of the present invention.
Fig. 4 is a flowchart illustrating a method for screening risk information of social security fund release data according to an embodiment of the present invention.
Fig. 5 is a schematic structural diagram of a screening apparatus for risk information of social security fund release data according to an embodiment of the present invention.
Fig. 6 is a schematic structural diagram of a screening apparatus for risk information of social security fund release data according to an embodiment of the present invention.
Fig. 7 is a schematic structural diagram of a screening apparatus for risk information of social security fund release data according to an embodiment of the present invention.
Fig. 8 is a schematic structural diagram of a screening apparatus for risk information of social security funds release data according to an embodiment of the present invention.
Fig. 9 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The execution subject of the screening method for the risk information of the social security fund release data provided by the embodiment of the invention includes but is not limited to a computer and a server.
Fig. 1 is a schematic flow chart of a screening method for risk information of social security fund issuance data according to an embodiment of the present invention, and as shown in fig. 1, the screening method for risk information of social security fund issuance data according to the embodiment of the present invention includes:
s101: constructing a second social security fund issuing database which is a non-relational database; the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database;
in this step, the data stored in the first social security funds release database is migrated and a second social security funds release database is constructed.
In particular, the social security funds release data is strongly relational data that is stored in a relational database, for example, in the form of a table of rows and columns, for accurate recording of such information.
The social security fund issuing data comprises a service detail serial number and service data; the service data comprises service type description, service transaction time, a type of issuing dangerous types, a type of issuing main bodies, a number of issuing main bodies, a name of issuing main bodies, a number of issuing units, a name of issuing unit, a type of drawing persons and certificates, a number of drawing persons and certificates, an issuing amount, an actual drawing persons bank account number, an actual drawing persons account number, an agent bank name, bank account information, a transaction channel, a transaction place, a payment mode and the like, and each service detail serial number corresponds to a corresponding service data group one to one.
The social security issuing data comprises historical social security issuing data and real-time newly added social security issuing data.
And cleaning and processing the social security fund issuing data, calculating, converting and supplementing default data according to field definition and data type constraint of a relational database, writing the default data into the relational database, and establishing the first social security fund issuing database in the following steps, which are not described in detail herein.
And taking out the social security fund issuance data in the first social security fund issuance database, and writing the social security fund issuance data into the second social security fund issuance database. The second social security fund issuing database is a non-relational database, and a method for obtaining the second social security fund issuing database based on data field migration in the first social security fund issuing database is described in detail below, and is not described herein in detail.
S102: retrieving in the second social security fund issuing database according to a risk screening condition to obtain a document record conforming to the risk screening condition; wherein the risk screening condition is preset.
In this step, a document record conforming to the risk screening condition is retrieved in the second social security funds release database using a preset risk screening condition.
Specifically, the risk screening condition is set according to the correspondence between the social security fund issuing risks, for example, when the social security fund issuing risks are that the acquirer certificate number is inconsistent with the actual treatment acquirer number, the risk screening condition is written according to the meaning of the database field corresponding to the social security fund issuing risks, and the risk screening condition at this time is that the acquirer certificate number is not equal to the actual acquirer certificate number.
And retrieving in the second social security fund issuing database according to the preset risk screening condition to obtain a document meeting the risk screening condition.
According to the screening method and device for the risk information of the social security fund issuing data, the social security fund issuing data stored in the relational database are transferred to the non-relational database, and when the risk information of the social security fund issuing data is screened, the social security fund issuing data is retrieved in the non-relational database according to the risk screening condition, so that the aggregation operation on the data is reduced, and the risk screening efficiency is improved.
Fig. 2 is a flowchart illustrating a method for screening risk information of social security funds release data according to an embodiment of the present invention, and as shown in fig. 2, the first social security funds release database is established by the following steps:
s201: obtaining social security issuing data, wherein the social security issuing data comprises a service detail serial number and service data;
in this step, social security issuance data is acquired and stored.
Specifically, the social security issuing data comprises a service detail serial number and service data; the service data comprises service type description, service transaction time, a type of issuing dangerous types, a type of issuing main bodies, a number of issuing main bodies, a name of issuing main bodies, a number of issuing units, a name of issuing unit, a type of drawing persons and certificates, a number of drawing persons and certificates, an issuing amount, an actual drawing persons bank account number, an actual drawing persons account number, an agent bank name, bank account information, a transaction channel, a transaction place, a payment mode and the like, and each service detail serial number corresponds to corresponding service data one to one.
The social security issuing data comprises historical social security issuing data and real-time newly added social security issuing data.
S202: splitting the service data according to service meaning to obtain the data field;
in this step, the service data is preprocessed to obtain a corresponding data field.
Specifically, each data entry in the service data is split according to the actual service meaning, and a corresponding data field is obtained.
S203: and establishing a table structure by using the data field and the service detail serial number as a first index value, and establishing the first social security fund issuing database.
In the step, a first social security fund issuing database is established based on the data fields and the corresponding business detail serial numbers.
Specifically, a table structure is established by using the data fields and the corresponding service detail serial numbers, so that a relational database environment is constructed.
And writing each service detail serial number and the corresponding data field thereof into the relational database as a row or a column of a table structure, and taking the service detail serial number in the row/column as a unique index of the row/column data field, namely a first index value, to obtain the first social security fund issuing database.
Fig. 3 is a flowchart illustrating a screening method for risk information of social security fund release data according to an embodiment of the present invention, and as shown in fig. 3, the obtaining of the second social security fund release database based on the data field migration in the first social security fund release database includes:
s301: building a non-relational database cluster environment;
in this step, a non-relational database cluster environment is set up.
Specifically, a necessary operating environment for installing the non-relational database.
S302: creating a second index value in the non-relational database cluster environment that is the same as the traffic detail flow number in the data field as the first index value;
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 established in S301.
Specifically, in order to accurately transfer the social security issuance data in the first social security funds issuance database to the second social security funds issuance database, an index needs to be established in the second social security funds issuance database for a data field corresponding to each service detail serial number.
In order to ensure the universality of the data in the transferred database, when an index is established for the data field corresponding to each service detail serial number in the second social security fund issuing database, the service detail serial number corresponding to the data field is still used as the index and is used as the second index value corresponding to the data field in the second social security fund issuing database.
S303: establishing documents in the non-relational database cluster environment by taking each second index value as an ID, wherein the documents correspond to the second index values one to one;
in this step, each second index value is used as an ID to establish a corresponding document in the non-relational database cluster environment.
Specifically, the non-relational database is a document database, wherein the data model is a versioned document, and the versioned document is stored in the database in a specific format.
And establishing documents in a non-relational database cluster environment by taking each second index value established in the step S302 as an ID of the document, wherein each document is used for storing the corresponding data field of the second index value, namely the service detail serial number, so that the data field corresponding to the service data under each service detail serial number is stored in the second social security fund issuing database.
S304: and taking out the data field in the first social security fund issuing database, writing the data field into the document according to the mapping relation between the first index value and the second index value, and establishing the second social security fund issuing database.
In this step, data fields under each service serial number in the first social security fund issuing database are correspondingly written into the document established in the step S303 according to the mapping relationship, so that a second social security fund issuing database is constructed.
Specifically, the first social security fund issuing database is of a table structure, each service detail serial number and the corresponding data field thereof are written into the relational database as a row or a column of the table structure, and the service detail serial number in the row/column is used as a unique index of the row/column data field.
And according to the service detail serial number, namely a first index value, extracting data fields stored in corresponding rows/columns in a table structure, and according to the corresponding relation between the first index value and the second index value, writing the data fields corresponding to the first index value into a corresponding document with the second index value as an ID (identity), thereby constructing the second social security fund issuing database.
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 service detail serial number.
Specifically, in order to ensure the universality of 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 issuance database, the data field is written into the document with the second index value as the ID, which is 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.
Fig. 4 is a flowchart illustrating a method for screening social security fund release data risk information according to an embodiment of the present invention, where as shown in fig. 4, the method searches through the second social security fund release database according to a risk screening condition to obtain a document record meeting the risk screening condition, and includes:
s401: retrieving in the second social security fund issuing database by using the risk screening condition to obtain a risk data result set corresponding to the risk screening condition;
in the step, the data in the second social security fund issuing database is retrieved to obtain a result set of the social security fund issuing data which accords with the risk screening condition.
Specifically, retrieval is performed in a second social security fund issuing database according to a preset risk screening condition, the retrieval is performed on data fields in each document in the second social security fund issuing database, and if the data fields in the documents are judged to accord with the risk screening condition, risk data results corresponding to the risk screening condition are added into the documents and are concentrated. Compared with the prior art in which the risk screening condition is used for searching the fields in the relational database, when the search is performed in the embodiment, because the data fields in the non-relational database do not have strong association, the aggregate computation amount generated during the search is small, and the risk screening speed is higher when the risk screening is performed on the mass social insurance fund issuing data.
S402: and converting the risk data result set into a list object and writing the list object into an Excel table to obtain the document record meeting the risk screening condition.
In the step, data fields in the risk data result set are converted into a form, and a document record of the risk screening condition convenient to view is obtained.
Specifically, the risk data result set obtained in S401 is a set of data fields of documents meeting the risk screening condition in the second social security issuing database.
The data fields in each document are extracted and written into the Excel table to serve as one row or one column in the Excel table, so that document records corresponding to the risk screening conditions are obtained, and when data meeting the risk screening conditions need to be checked, the Excel form is more convenient to query or retrieve.
Based on the above embodiments, further, the second social security funds release database is an ElasticSearch non-relational database.
Taking the second social security fund issuing database as an example, the second social security fund issuing database is an elastic search non-relational database, and the screening method of the risk information of the social security fund issuing data comprises the following steps:
the method comprises the following steps: and constructing a relational database.
S1: the social security issuing data (the social security issuing data comprise the business detail serial number and the business data) are divided into database fields according to the actual obligation meaning, a table structure is created in a relational database, and the 'business detail serial number' fields are used as first index values of the data and are written into the relational database one by one according to the entries.
Step two: and constructing an ElasticSearch cluster of the non-relational database.
S2: and constructing an ElasticSearch non-relational database cluster environment.
S3: creating a second index value in the database cluster environment that is synonymous with the first index value in the relational database.
S4: and sequentially taking out data fields of the relational database through a Java program, correspondingly writing the data fields of the relational database into an ElasticSearch non-relational database through a High Level REST Client provided by an ElasticSearch official by taking each second index value as an ID, wherein the data field corresponding to each business detail flow number corresponds to a document of the ElasticSearch database, and the field name and the field value correspond to the field name and the field value in the relational database one by one.
Step three: writing a risk screening condition (DSL) of the ElasticSearch carries out risk information retrieval and analysis on documents in the ElasticSearch.
S5: screening conditions according to the risk information, such as inconsistency between the number of the retriever certificate and the number of the actual retriever to be encountered; repeatedly acquiring Specific risk types with the sum of more than 5000 yuan and the like, writing risk screening conditions (DSL) corresponding to the meanings of the document fields in the ElasticSearch database, realizing calculation operations such as Boolean filtration, field aggregation and the like on the document records in the ElasticSearch, and then retrieving a risk document result set meeting the screening conditions.
Step four: and acquiring a result set and generating a report.
S6: and writing the result set into an Excel table by utilizing an Apache POI component in Java to generate a risk information document record.
Fig. 5 is a schematic structural diagram of a screening apparatus for risk information of social security fund issuance data according to an embodiment of the present invention, and as shown in fig. 5, the screening apparatus for risk information of social security fund issuance data according to an embodiment of the present invention includes a non-relational database module 501 configured to construct a second social security fund issuance database, where the second social security fund issuance database is a non-relational database; the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database; a risk screening module 502, configured to retrieve, according to a risk screening condition, in the second social security fund issuing database to obtain a document record meeting the risk screening condition; wherein the risk screening condition is preset. Wherein:
and the non-relational database module 501 is used for migrating the data stored in the first social security funds release database and constructing a second social security funds release database.
A risk screening module 502, configured to retrieve, in the second social security funds release database, a document record meeting a preset risk screening condition.
According to the screening method and device for risk information of the social security fund issuing data, the social security fund issuing data stored in the relational database are transferred to the non-relational database, and when the risk information of the social security fund issuing data is screened, the social security fund issuing data is retrieved in the non-relational database according to the risk screening condition, so that the aggregation operation of the data is reduced, and the risk screening efficiency is improved.
Fig. 6 is a schematic structural diagram of a screening apparatus for risk information of social security funds release data according to an embodiment of the present invention, and as shown in fig. 6, the screening apparatus for risk information of social security funds release data according to an embodiment of the present invention further includes: the obtaining module 503 is configured to obtain social security issuing data, where the social security issuing data includes a service detail serial number and service data; a preprocessing module 504, configured to split the service data according to a service meaning to obtain the data field; and the relational database module 505 is used for creating a table structure by using the data field and the service detail serial number as a first index value, and establishing the first social security fund issuing database. Wherein:
the obtaining module 503 is configured to obtain social security issuance data and store the social security issuance data.
A preprocessing module 504, configured to preprocess the service data to obtain a corresponding data field.
And the relational database module 505 is used for establishing a first social security fund issuing database based on the data fields and the corresponding business detail serial numbers.
Fig. 7 is a schematic structural diagram of a screening apparatus for risk information of social security fund issuance data according to an embodiment of the present invention, and as shown in fig. 7, the non-relational database module 501 includes: the environment generation unit 5011 is configured to build a non-relational database cluster environment; an indexing unit 5012 configured to create a second index value in the non-relational database cluster environment, the second index value being the same as the traffic detail flow number in the data field as the first index value; a document generating unit 5013, configured to respectively establish documents in the non-relational database cluster environment with each second index value as an ID, where the documents correspond to the second index values one to one; the generating unit 5014 is configured to take out the data field in the first social security funds release 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 funds release database. Wherein:
the environment generation unit 5011 is configured to build a non-relational database cluster environment.
The indexing unit 5012 is configured to create a second index value identical to the first index value in the non-relational database cluster environment built in the environment generating unit 5011.
The document generating unit 5013 is configured to establish a corresponding document in the non-relational database cluster environment by using each of the second index values as an ID.
The generating unit 5014 is configured to correspondingly write the data fields under each service serial number in the first social security funds release database into the document established by the document generating unit 5013 according to the mapping relationship, so as to construct the second social security funds release database.
Fig. 8 is a schematic structural diagram of a screening apparatus for risk information of social security funds release data according to an embodiment of the present invention, and as shown in fig. 8, a risk screening module 502 includes: the screening unit 5021 is used for retrieving in the second social security fund issuing database by using the risk screening condition to obtain a risk data result set corresponding to the risk screening condition; and the document generating unit 5022 is used for converting the risk data result set into a list object and writing the list object into an Excel table to obtain the document record meeting the risk screening condition. Wherein:
the screening unit 5021 is used for retrieving data in the second social security fund issuing database to obtain a result set of the social security fund issuing data meeting the risk screening condition.
And the document generating unit 5022 is used for converting the data fields in the risk data result set into a form to obtain a document record of the risk screening condition which is convenient to view.
The embodiment of the server provided in the embodiment of the present invention may be specifically configured to execute the processing flows of the above method embodiments, and the functions of the embodiment are not described herein again, and refer to the detailed description of the above method embodiments.
It should be noted that the screening method and apparatus for risk information of social security fund issuance data provided by the embodiment of the present invention may be used in the financial field, and may also be used in any technical field other than the financial field.
Fig. 9 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 9, the electronic device may include: a processor (processor)901, a communication Interface (Communications Interface)902, a memory (memory)903 and a communication bus 904, wherein the processor 901, the communication Interface 902 and the memory 903 are communicated with each other through the communication bus 904. The processor 901 may call logic instructions in the memory 903 to perform the following method: constructing a second social security fund issuing database which is a non-relational database; the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database; retrieving in the second social security fund issuing database according to a risk screening condition to obtain a document record conforming to the risk screening condition; wherein the risk screening condition is preset.
In addition, the logic instructions in the memory 903 may be implemented in a software functional unit and stored in a computer readable storage medium when the logic instructions are sold or used as a separate product. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, and various media capable of storing program codes.
The present embodiment discloses a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the method provided by the above-mentioned method embodiments, for example, comprising: constructing a second social security fund issuing database which is a non-relational database; the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database; retrieving in the second social security fund issuing database according to a risk screening condition to obtain a document record conforming to the risk screening condition; wherein the risk screening condition is preset.
The present embodiment provides a computer-readable storage medium, which stores a computer program, where the computer program causes the computer to execute the method provided by the above method embodiments, for example, the method includes: constructing a second social security fund issuing database which is a non-relational database; the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database; retrieving in the second social insurance fund issuing database according to a risk screening condition to obtain a document record meeting the risk screening condition; wherein the risk screening condition is preset.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In the description herein, reference to the description of the terms "one embodiment," "a particular embodiment," "some embodiments," "for example," "an example," "a particular example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
1. A screening method for risk information of social security fund release data is characterized by comprising the following steps:
constructing a second social security fund issuing database which is a non-relational database;
the second social security fund issuing database is obtained by transferring based on data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database;
retrieving in the second social security fund issuing database according to a risk screening condition to obtain a document record conforming to the risk screening condition;
wherein the risk screening condition is preset.
2. The method for screening social security funds release data risk information of claim 1, wherein the first social security funds release database is established by:
obtaining social security issuing data, wherein the social security issuing data comprises a service detail serial number and service data;
splitting the service data according to service meaning to obtain the data field;
and establishing a table structure by using the data field and the service detail serial number as a first index value, and establishing the first social security fund issuing database.
3. The method for screening risk information of social security fund release data according to claim 2, wherein the social security release data comprises historical social security release data and real-time newly added social security release data.
4. The method for screening social security funds release data risk information according to claim 2, wherein migrating the second social security funds release database based on the data fields in the first social security funds release database comprises:
building a non-relational database cluster environment;
creating a second index value in the non-relational database cluster environment that is the same as the traffic detail flow number in the data field as the first index value;
establishing documents in the non-relational database cluster environment by taking each second index value as an ID, wherein the documents correspond to the second index values one to one;
and taking out the data field in the first social security fund issuing database, writing the data field into the document according to the mapping relation between the first index value and the second index value, and establishing the second social security fund issuing database.
5. The method as claimed in claim 4, wherein 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 serial number of the service detail.
6. The method for screening the risk information of the social security funds release data as claimed in claim 1, wherein the step of retrieving the second social security funds release database according to the risk screening condition to obtain the document record meeting the risk screening condition comprises:
retrieving in the second social security fund issuing database by using the risk screening condition to obtain a risk data result set corresponding to the risk screening condition;
and converting the risk data result set into a list object and writing the list object into an Excel table to obtain the document record meeting the risk screening condition.
7. The method for screening social security funds release data risk information according to any one of claims 1-6, wherein the second social security funds release database is an ElasticSearch non-relational database.
8. A screening apparatus for risk information of social security funds release data, comprising:
the non-relational database module is used for constructing a second social security fund issuing database, and the second social security fund issuing database is a non-relational database;
the second social security fund issuing database is obtained by transferring data fields in a first social security fund issuing database, and the first social security fund issuing database is a relational database;
the risk screening module is used for retrieving in the second social security fund issuing database according to risk screening conditions to obtain document records meeting the risk screening conditions;
wherein the risk screening condition is preset.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210788899.2A CN115034917A (en) | 2022-07-06 | 2022-07-06 | Screening method and device for social security fund release data risk information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210788899.2A CN115034917A (en) | 2022-07-06 | 2022-07-06 | Screening method and device for social security fund release data risk information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115034917A true CN115034917A (en) | 2022-09-09 |
Family
ID=83128571
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210788899.2A Pending CN115034917A (en) | 2022-07-06 | 2022-07-06 | Screening method and device for social security fund release data risk information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115034917A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115439033A (en) * | 2022-11-09 | 2022-12-06 | 浙江浙大网新软件产业集团有限公司 | Risk user screening method and device based on social security data and computing equipment |
-
2022
- 2022-07-06 CN CN202210788899.2A patent/CN115034917A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115439033A (en) * | 2022-11-09 | 2022-12-06 | 浙江浙大网新软件产业集团有限公司 | Risk user screening method and device based on social security data and computing equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103620601B (en) | Joining tables in a mapreduce procedure | |
| CN108388604A (en) | User right data administrator, method and computer readable storage medium | |
| CN111339427A (en) | Book information recommendation method, device and system and storage medium | |
| CN103699441A (en) | MapReduce report task execution method based on task granularity | |
| CN103793493A (en) | Method and system for processing car-mounted terminal mass data | |
| CN111951101A (en) | Data checking method and device | |
| CN107798120B (en) | Data conversion method and device | |
| CN115034917A (en) | Screening method and device for social security fund release data risk information | |
| CN110737727B (en) | Data processing method and system | |
| CN108415990B (en) | Data quality monitoring method and device, computer equipment and storage medium | |
| CN115329011A (en) | Data model construction method, data query method, data model construction device and data query device, and storage medium | |
| CN112148713A (en) | Data migration method and device between heterogeneous databases | |
| CN111967521A (en) | Cross-border active user identification method and device | |
| CN111242779A (en) | Financial data characteristic selection and prediction method, device, equipment and storage medium | |
| CN115809228A (en) | Data comparison method and device, storage medium and electronic equipment | |
| CN110941952A (en) | Method and device for perfecting audit analysis model | |
| CN111723129B (en) | Report generation method, report generation device and electronic equipment | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result | |
| CN114722045A (en) | Time series data storage method and device | |
| CN111125045B (en) | Lightweight ETL processing platform | |
| CN113010489A (en) | Data migration method and system | |
| CN113159926A (en) | Loan transaction repayment date determination method and device | |
| CN106250243B (en) | The processing method and processing device of banking system application based on poll tupe | |
| CN111967671A (en) | Cross-border active user identification method and device based on support vector data field description | |
| CN111008078A (en) | Batch processing method, device and equipment of data and computer storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |