CN112699176B - Quick random extraction method, system, terminal and storage medium - Google Patents

Abstract

The invention provides a rapid random extraction method, a rapid random extraction system, a terminal and a storage medium, wherein the method comprises the steps of formulating a random extraction rule; finding out an extracted sample from an inspected sample library according to the random extraction rule, acquiring the sampling ID numbers of the extracted sample for sorting, and recording the sorting result in a temporary sample snapshot table; acquiring a random seed number, randomly taking out a sorting result from the temporary sample snapshot table, randomly extracting the sorting result based on a preset random extraction algorithm and the random seed number, and recording the random extraction result in the temporary extraction result snapshot table; writing the contents in the temporary sample snapshot table into the spot check sample table, and deleting the temporary sample snapshot; writing the contents in the temporary extraction result snapshot table into the spot check result table, and deleting the temporary extraction result snapshot table. The method solves the contradiction between random process tracking record and random result rapid forming, relieves the lasting pressure of the database and improves the efficiency.

Description

Quick random extraction method, system, terminal and storage medium

Technical Field

The invention relates to the field of spot check of government affair data, in particular to a rapid random extraction method, a system, a terminal and a storage medium.

Background

The national authorities can check the object supervised by the national authorities randomly every year, record the result and show the checking result. Unlike the normal random process, this type of random includes not only fairness in the conventional sense of the random process, but also requires that the same random effect can be generated under the same random rule. I.e. traceable for the random process requirements, traceable for the random result requirements.

For each random behavior, the data appeal points of different users are different, and the behavior and the result thereof can be tracked before and after the random behavior is generated and even in various links in the process. In the prior art, in order to ensure various user requirements, each step of the random process is marked in time, so that the database is operated frequently, and has long time consumption and low efficiency, and contradiction exists between the quick acquisition of the random extraction result expected by a client.

In order to solve the above problems, an ideal technical solution is always sought.

Disclosure of Invention

The invention aims at overcoming the defects of the prior art, and provides a rapid random extraction method, a rapid random extraction system, a terminal and a storage medium.

In order to achieve the above purpose, the technical scheme adopted by the invention is as follows: a method for fast random extraction, comprising the steps of:

and (3) preparing a random extraction rule: defining a random extraction large environment, defining an extraction sample range, and defining a random extraction proportion;

rule persistence: writing the random extraction rule into an extraction check task table in an extraction record database, and establishing a temporary sample snapshot table and a temporary extraction result snapshot table in the extraction record database;

sample snapshot: finding out an extraction object from an inspection sample library according to the random extraction rule, acquiring a sampling ID number of the extraction object as an spot check sample, sequencing the spot check samples, and writing the spot check samples into the temporary sample snapshot table;

randomly extracting: acquiring a random seed number, and writing the random seed number into the spot check task table; randomly taking out a sample sequence number from the temporary sample snapshot table, randomly extracting the sample sequence number based on a preset random extraction algorithm and the random seed number, and writing a random extraction result into the temporary extraction result snapshot table;

sample result persistence: writing the contents in the temporary sample snapshot table into a spot check sample table in the extraction record database, and deleting the temporary sample snapshot table;

randomization result persistence: writing the contents in the temporary extraction result snapshot table into the extraction result table in the extraction record database, and deleting the temporary extraction result snapshot table.

Based on the above, before each random extraction action starts, an extraction ID number is generated for the random extraction action, and the random extraction rule, the spot check sample and the spot check result in the same random extraction action process have the same extraction ID number.

Based on the above, in the random extraction rule formulation stage, the inspection sample that has been extracted in a specific time may be deleted from the sample extraction range according to the spot check result of the historical random extraction behavior.

Based on the above, after the extraction sample range is defined, the extraction sample range may be further grouped according to a preset grouping rule, and a random extraction proportion may be respectively formulated for each grouping.

Based on the above, the user formulates a random extraction rule and selects a random seed number through a human-computer operation interface; rule persistence and sample snapshot are performed in the form of a task system; sample result persistence and random result persistence are performed in the form of task system two.

The invention also provides a rapid random extraction system, which comprises an extraction rule making module, a rule persistence module, a snapshot establishing module, an extraction sample grabbing module, a random seed number obtaining module, a random extraction module, a persistence module and an extraction record database, wherein the extraction record database comprises an extraction task table, an extraction sample table and an extraction result table,

the extraction rule making module is used for defining a random extraction large environment, defining an extraction sample range and defining a random extraction proportion;

the rule persistence module writes the random extraction rule into the spot check task list and sends a snapshot establishment instruction to the snapshot establishment module;

the snapshot establishing module establishes a temporary sample snapshot table and a temporary extraction result snapshot table in the extraction record database according to the snapshot establishing instruction;

the extraction sample grabbing module finds an extraction object from an inspection sample library according to the random extraction rule, acquires a sampling ID number of the extraction object as an extraction sample, sorts the extraction sample, and writes the extraction sample into the temporary sample snapshot table;

the random seed number acquisition module is used for acquiring a random seed number and writing the random seed number into the spot check task table;

the random extraction module is used for randomly extracting a sample sequence number from the temporary sample snapshot table, randomly extracting the sample sequence number based on a preset random extraction algorithm and the random seed number, and writing a random extraction result into the temporary extraction result snapshot table;

the persistence module is used for writing the contents in the temporary sample snapshot table into the spot check sample table in the extraction record database and deleting the temporary sample snapshot table; writing the contents in the temporary extraction result snapshot table into the extraction result table in the extraction record database, and deleting the temporary extraction result snapshot table.

Based on the above, the system further comprises an extraction ID number generation module, wherein the extraction ID number generation module is used for generating an extraction ID number for each random extraction action, and the random extraction rule, the spot check sample and the spot check result in the same random extraction action process have the same extraction ID number.

The invention also provides a computer program which is characterized by being used for realizing the rapid random extraction method.

The invention also provides a quick random extraction terminal device, which comprises a processor, a memory and a computer program stored in the memory and configured to be executed by the processor, wherein the quick random extraction method is realized when the processor executes the computer program.

The invention also provides a computer readable storage medium, which comprises a stored computer program, wherein the computer program is used for controlling equipment where the computer readable storage medium is located to execute the rapid random extraction method.

The present invention has outstanding substantial features and significant advances over the prior art, and in particular,

(1) In order to ensure that only a small amount of persistence operations such as extraction rules, random seed numbers and the like are performed in the extraction process, and sample data with large data volume is not subjected to persistence, the operation that the data needs to frequently enter and exit a database due to persistence of the sample data is reduced, the time consumption is short, and the time consumption index of a random result is reduced;

(2) According to the method, a temporary sample snapshot concept and a random result snapshot concept are introduced in rule persistence, and a sampling ID number and a random sampling behavior of an extracted sample are obtained for laying out the extracted sample from an inspection sample library according to the random extraction rule; in the sample provisional stage, the provisional sample snapshot only records the sample ID number and the sample serial number, the subsequent random extraction is based on the sample snapshot, and the random sample tracing is also based on the sample snapshot; since the sample ID and the sample number are smaller than the number of samples, the reading speed is improved. In the random extraction stage, the temporary extraction result snapshot table only records sample numbers (sample numbers of sample numbers in the temporary sample snapshot), the random result shaping is based on the temporary extraction result snapshot, and the random result tracing is also based on the temporary extraction result snapshot. Since the sample ID and the sample number are smaller than the number of samples, the random extraction speed is improved.

(3) Aiming at the prior art and the matched scene thereof, the invention carries out technical decomposition based on man-machine interaction, and converts the time-consuming link decomposition of the system into a process which can be accepted by a user, tracked and perceived on the premise of not influencing the random result and the habit of the user; the rule persistence and the sample snapshot are executed in a task system mode, and the continuous operation between the establishment of a random extraction rule and the acquisition of a random seed number is carried out, so that only necessary persistence operation is carried out; sample result persistence and random result persistence are located in the post-hoc link of random extraction, and are insensitive to users, so that time-consuming persistence operations can be performed. The user experience is improved by referencing the system task concept.

(4) In view of the fact that the tracing system is distributed in each link of the random process, the tracing system is split into random middle tracing and random back tracing, wherein the random middle tracing is based on snapshot tracing, the random back tracing is based on the spot check result table and the spot check sample table, links are different, tracing modes are different, and a foundation is laid for solving time consuming contradiction between rapid forming of random results and tracing of the tracing process.

The method solves the contradiction between random process tracking record and random result rapid forming, relieves the lasting pressure of the database and improves the efficiency.

Drawings

Fig. 1 is a schematic flow chart of embodiment 1 of the present invention.

Fig. 2 is a schematic flow chart of embodiment 2 of the present invention.

Detailed Description

The technical scheme of the invention is further described in detail through the following specific embodiments.

The random spot check inspection process of the national institutes is required to be trackable, and the result is required to be traceable, so that each link in the random process is required to be subjected to persistent record, and data is inevitably required to be frequently written into a database and frequently taken out from the database; however, the number of the supervision objects increases year by year, and the data of each supervision object also increases year by year, and even if the supervision object does not exist due to logout or the like, the data of the supervision object is still stored in the supervision object library, so that the data of the supervision object is more and more huge. Thus, frequent reading and writing of a large number of samples with a large data volume results in a long time consuming random process.

Example 1

In order to solve the technical problem, the fast random extraction method of the present embodiment, as shown in fig. 1, includes the following steps:

and (3) preparing a random extraction rule: defining a random extraction large environment, defining an extraction sample range, and defining a random extraction proportion.

The random extraction macro environment comprises task time, rule making time, matching inspector time, inspection and feedback time, participating departments, inspection projects, inspection modes, inspection objects, corresponding policy files and the like.

The task time refers to total set time of the random spot check and inspection task, and the rule making time, the matching inspector time and the inspection and feedback time refer to the estimated time consumption of the random spot check and inspection task in stages; a participating department refers to a participant in the random task, such as a market supervision authority or education bureau; the inspection mode comprises common double random inspection, flight inspection and the like, wherein the flight inspection refers to on-site inspection which is carried out by an inspected department and is not notified in advance; double random inspection refers to randomly extracting inspected samples and randomly selecting inspectors; the inspection object may be data that is temporarily uploaded, or may be data that is read by the supervision object library.

Rule persistence: writing the random extraction rule into an extraction check task table in an extraction record database, and establishing a temporary sample snapshot table and a temporary extraction result snapshot table in the extraction record database.

Sample snapshot: finding out an extraction object from the inspection sample library according to the random extraction rule, acquiring a sampling ID number of the extraction object as an spot check sample, sequencing the spot check samples, and writing the spot check samples into the temporary sample snapshot table.

Randomly extracting: acquiring a random seed number, and writing the random seed number into the spot check task table; and randomly taking out a sample sequence number from the temporary sample snapshot table, randomly extracting the sample sequence number based on a preset random extraction algorithm and the random seed number, and writing a random extraction result into the temporary extraction result snapshot table.

Sample result persistence: writing the contents of the temporary sample snapshot table into the spot check sample table in the extraction record database, and deleting the temporary sample snapshot table.

Randomization result persistence: writing the contents in the temporary extraction result snapshot table into the extraction result table in the extraction record database, and deleting the temporary extraction result snapshot table.

It can be understood that, before each random extraction action starts, an extraction ID number is generated for the random extraction action, and the random extraction rule, the spot check sample and the spot check result in the same random extraction action process have the same extraction ID number.

In the implementation, after an extraction ID number is generated, an extraction record folder is established in an extraction record database by taking the ID number as a folder name, and an extraction check task table, an extraction check sample table and an extraction check result table are arranged in the extraction record folder; and in the rule persistence process, a temporary sample snapshot table and a temporary extraction result snapshot table are established in an extraction record folder corresponding to the current random extraction behavior. And when the follow-up is checked in the later period, searching a corresponding extraction record folder in the extraction record database according to the extraction ID number corresponding to the extraction behavior to be checked, and finally obtaining the contents of the spot check task table, the spot check sample table and the spot check result table in the folder.

In the specific implementation, a public spot check task table, a spot check sample table and a spot check result table can be established in the spot check record database in advance, the random spot check rule generated by each spot check action and the spot check ID number corresponding to the spot check action are written into the public spot check task table, the spot check sample generated by each spot check action and the spot check ID number corresponding to the spot check action are written into the public spot check sample table, and the spot check result generated by each spot check action and the spot check ID number corresponding to the spot check action are written into the public spot check result table. And when the follow-up checking is performed in the later period, the corresponding random extraction rule, the extraction sample and the extraction result are taken out according to the extraction ID numbers corresponding to the extraction behaviors to be checked and the extraction task table, the extraction sample table and the extraction result table which are sequentially and commonly used.

In order to ensure that only a small amount of persistence operations such as extraction rules and random seed numbers are performed in the extraction process, sample data with large data volume is not subjected to persistence, the operation that the data needs to be frequently accessed into and output from a database due to persistence of the sample data is reduced, the time consumption is short, and the time consumption of a random result is reduced exponentially.

According to the method, a temporary sample snapshot concept and a random result snapshot concept are introduced in rule persistence, and a sampling ID number and a random sampling behavior of an extracted sample are obtained for laying out the extracted sample from an inspection sample library according to the random extraction rule; in the sample provisional stage, the provisional sample snapshot only records the sample ID number and the sample serial number, the subsequent random extraction is based on the sample snapshot, and the random sample tracing is also based on the sample snapshot; since the sample ID and the sample number are smaller than the number of samples, the reading speed is improved. In the random extraction stage, the temporary extraction result snapshot table only records sample numbers (sample numbers of sample numbers in the temporary sample snapshot), the random result shaping is based on the temporary extraction result snapshot, and the random result tracing is also based on the temporary extraction result snapshot. Since the sample ID and the sample number are smaller than the number of samples, the random extraction speed is improved.

In view of the fact that the tracing demands of clients possibly occur in each link of a random process, the tracing system is split into random intermediate tracing and random post tracing, wherein the random intermediate tracing is based on snapshot tracing, the random post tracing is based on spot check result tables and spot check sample tables, links are different, tracing modes are different, and a foundation is laid for solving time consuming contradictions between rapid forming of random results and tracing of tracing processes.

Specifically, when tracing in random, if only the sample snapshot step is performed and the random extraction step is not performed, the sampling ID number of the sample to be inspected is directly obtained from the temporary sample snapshot table in the random extraction database, and finally the detailed information of the sample to be inspected is obtained from the inspection sample library according to the sampling ID number of the sample to be inspected.

When tracing the source in the random, if the random extraction step is already carried out, the sample number of the extracted sample is directly obtained from a temporary extraction result snapshot table in the random extraction database, the sampling ID number of the extracted object is obtained from the temporary sample snapshot table according to the sample number of the extracted object, and finally the detailed information of the extracted sample is obtained from the detection sample library according to the sampling ID number of the extracted object.

When random back tracing is carried out, sampling serial numbers of sampling samples are obtained from a sampling result table in the random sampling database according to sampling ID numbers corresponding to sampling behaviors to be checked, sampling ID numbers of sampling samples are obtained from the sampling sample table according to the sampling serial numbers, and finally detailed information of the sampling samples is obtained from a sampling sample library according to the sampling ID numbers of the sampling samples.

Example 2

This embodiment differs from embodiment 1 in that: as shown in fig. 2, a user formulates a random extraction rule and selects a random seed number through a human-computer operation interface; rule persistence and sample snapshot are performed in the form of a task system; sample result persistence and random result persistence are performed in the form of task system two.

Aiming at the prior art and the matched scene thereof, the invention carries out technical decomposition based on man-machine interaction, and converts the time-consuming link decomposition of the system into a process which can be accepted by a user, tracked and perceived on the premise of not influencing the random result and the habit of the user; the rule persistence and the sample snapshot are executed in a task system mode, and the continuous operation between the establishment of a random extraction rule and the acquisition of a random seed number is carried out, so that only necessary persistence operation is carried out; sample result persistence and random result persistence are located in the post-hoc link of random extraction, and are insensitive to users, so that time-consuming persistence operations can be performed. The user experience is improved by referencing the system task concept.

Example 3

This embodiment differs from embodiment 1 in that: in the random extraction rule making stage, the detection samples which have been extracted in a specific time can be deleted from the sample extraction range according to the spot check result of the historical random extraction behavior.

Preferably, the specific time can be the current year or several years above, and can be specifically set according to the requirements of the user.

Through the core idea that the detection objects which have been hit randomly at the specific time are not included in the samples of the next random behavior, the detection objects which are hit randomly at most once in different random behaviors at the specific time are ensured, so that more detection objects are ensured to be extracted, and the spot check quality is improved.

Example 4

This embodiment differs from embodiment 1 in that: after the extraction sample range is defined, the extraction sample range can be further grouped according to a preset grouping rule, and a random extraction proportion is respectively formulated for each grouping.

The preset grouping rule may be a city, and samples of the same city belong to the same group; different groups can be provided with different proportions, and random arrangement is achieved; and ensuring that each group has detection objects to be extracted, and improving the uniform distribution of random extraction results.

In the specific implementation, before sample grouping, samples in the inspection sample library are thinned according to different appeal subjects, namely random spot check action sponsors, then small grouping is carried out in a large sample group belonging to the same appeal subject according to a preset grouping rule, and the random process of respective refinement of different appeal subjects is realized under the same random rule system.

Example 5

The invention also provides a rapid random extraction system, which comprises an extraction rule making module, a rule persistence module, a snapshot establishing module, an extraction sample grabbing module, a random seed number obtaining module, a random extraction module, a persistence module and an extraction record database, wherein the extraction record database comprises an extraction task table, an extraction sample table and an extraction result table,

the extraction rule making module is used for defining a random extraction large environment, defining an extraction sample range and defining a random extraction proportion;

the rule persistence module writes the random extraction rule into the spot check task list and sends a snapshot establishment instruction to the snapshot establishment module;

the snapshot establishing module establishes a temporary sample snapshot table and a temporary extraction result snapshot table in the extraction record database according to the snapshot establishing instruction;

the extraction sample grabbing module finds an extraction object from an inspection sample library according to the random extraction rule, acquires a sampling ID number of the extraction object as an extraction sample, sorts the extraction sample, and writes the extraction sample into the temporary sample snapshot table;

the random seed number acquisition module is used for acquiring a random seed number and writing the random seed number into the spot check task table;

the random extraction module is used for randomly extracting a sample sequence number from the temporary sample snapshot table, randomly extracting the sample sequence number based on a preset random extraction algorithm and the random seed number, and writing a random extraction result into the temporary extraction result snapshot table;

the persistence module is used for writing the contents in the temporary sample snapshot table into the spot check sample table in the extraction record database and deleting the temporary sample snapshot table; writing the contents in the temporary extraction result snapshot table into the extraction result table in the extraction record database, and deleting the temporary extraction result snapshot table.

In a specific implementation, the rapid random extraction system further comprises an extraction ID number generation module, wherein the extraction ID number generation module is used for generating an extraction ID number for each random extraction action, and the random extraction rule, the spot check sample and the spot check result in the same random extraction action process have the same extraction ID number.

(1) In order to ensure that only a small amount of persistence operations such as extraction rules, random seed numbers and the like are performed in the extraction process, and sample data with large data volume is not subjected to persistence, the operation that the data needs to frequently enter and exit a database due to persistence of the sample data is reduced, the time consumption is short, and the time consumption index of a random result is reduced;

(2) Introducing a temporary sample snapshot concept, wherein the temporary sample snapshot only records a sampling ID number and a sample serial number, the subsequent random extraction is based on the sample snapshot, and the tracing of the samples in the random is also based on the sample snapshot; the concept of a temporary extraction result snapshot table is introduced, the temporary extraction result snapshot table only records sample serial numbers (sample serial numbers of sample serial numbers in the temporary sample snapshot), random result shaping is based on the snapshot, and random result tracing is also based on the snapshot.

Since the sample ID and the sample number are small compared with the number of samples, both the reading speed and the random extraction speed are improved.

(3) Aiming at the prior art and the matched scene thereof, the invention carries out technical decomposition based on man-machine interaction, and converts the time-consuming link decomposition of the system into a process which can be accepted by a user, tracked and perceived on the premise of not influencing the random result and the habit of the user; the rule persistence and the sample snapshot are executed in a task system mode, and the continuous operation between the establishment of a random extraction rule and the acquisition of a random seed number is carried out, so that only necessary persistence operation is carried out; sample result persistence and random result persistence are located in the post-hoc link of random extraction, and are insensitive to users, so that time-consuming persistence operations can be performed. The user experience is improved by referencing the system task concept.

(4) In view of the fact that the tracing system is distributed in each link of the random process, the tracing system is split into random middle tracing and random back tracing, wherein the random middle tracing is based on snapshot tracing, the random back tracing is based on the spot check result table and the spot check sample table, links are different, tracing modes are different, and a foundation is laid for solving time consuming contradiction between rapid forming of random results and tracing of the tracing process.

The method solves the contradiction between random process tracking record and random result rapid forming, relieves the lasting pressure of the database and improves the efficiency.

Example 6

The present invention also provides a computer program for implementing the fast random extraction method described in embodiment 1 or embodiment 2 or embodiment 3 or embodiment 4.

Example 7

The present invention also provides a fast random extraction terminal device, comprising a processor, a memory and a computer program stored in the memory and configured to be executed by the processor, wherein the processor implements the fast random extraction method described in embodiment 1 or embodiment 2 or embodiment 3 or embodiment 4 when executing the computer program.

Example 8

The present invention also provides a computer readable storage medium, where the computer readable storage medium includes a stored computer program, where when the computer program runs, the device where the computer readable storage medium is controlled to execute the fast random extraction method described in embodiment 1 or embodiment 2 or embodiment 3 or embodiment 4.

Finally, it should be noted that the above-mentioned embodiments are only for illustrating the technical scheme of the present invention and are not limiting; while the invention has been described in detail with reference to the preferred embodiments, those skilled in the art will appreciate that: modifications may be made to the specific embodiments of the present invention or equivalents may be substituted for part of the technical features thereof; without departing from the spirit of the invention, it is intended to cover the scope of the invention as claimed.

Claims (10)

1. A method for fast random extraction, comprising the steps of:

and (3) preparing a random extraction rule: defining a random extraction large environment, defining an extraction sample range, and defining a random extraction proportion;

rule persistence: writing the random extraction rule into an extraction check task table in an extraction record database, and establishing a temporary sample snapshot table and a temporary extraction result snapshot table in the extraction record database;

sample snapshot: finding out an extraction object from an inspection sample library according to the random extraction rule, acquiring a sampling ID number of the extraction object as an spot check sample, sequencing the spot check samples, and writing the spot check samples into the temporary sample snapshot table;

randomly extracting: acquiring a random seed number, and writing the random seed number into the spot check task table; randomly taking out a sample sequence number from the temporary sample snapshot table, randomly extracting the sample sequence number based on a preset random extraction algorithm and the random seed number, and writing a random extraction result into the temporary extraction result snapshot table;

sample result persistence: writing the contents in the temporary sample snapshot table into a spot check sample table in the extraction record database, and deleting the temporary sample snapshot table;

randomization result persistence: writing the contents in the temporary extraction result snapshot table into the extraction result table in the extraction record database, and deleting the temporary extraction result snapshot table.

2. The fast random extraction method according to claim 1, wherein: before each random extraction action starts, an extraction ID number is generated for the random extraction action, and a random extraction rule, an spot check sample and a spot check result generated by the same random extraction action have the same extraction ID number.

3. The fast random extraction method according to claim 2, wherein: in the random extraction rule making stage, the detection samples which have been extracted in a specific time can be deleted from the sample extraction range according to the spot check result of the historical random extraction behavior.

4. The fast random extraction method according to claim 1, wherein: after the extraction sample range is defined, the extraction sample range can be further grouped according to a preset grouping rule, and a random extraction proportion is respectively formulated for each grouping.

5. The fast random extraction method according to claim 1, wherein: a user formulates a random extraction rule and selects a random seed number through a human-computer operation interface; rule persistence and sample snapshot are performed in the form of a task system; sample result persistence and random result persistence are performed in the form of task system two.

6. A fast random extraction system, characterized by: comprises an extraction rule making module, a rule persistence module, a snapshot establishing module, an extraction sample grabbing module, a random seed number obtaining module, a random extraction module, a persistence module and an extraction record database, wherein the extraction record database comprises an extraction check task table, an extraction check sample table and an extraction check result table,

the extraction rule making module is used for defining a random extraction large environment, defining an extraction sample range and defining a random extraction proportion;

the rule persistence module writes the random extraction rule into the spot check task list and sends a snapshot establishment instruction to the snapshot establishment module;

the snapshot establishing module establishes a temporary sample snapshot table and a temporary extraction result snapshot table in the extraction record database according to the snapshot establishing instruction;

the extraction sample grabbing module finds an extraction object from an inspection sample library according to the random extraction rule, acquires a sampling ID number of the extraction object as an extraction sample, sorts the extraction sample, and writes the extraction sample into the temporary sample snapshot table;

the random seed number acquisition module is used for acquiring a random seed number and writing the random seed number into the spot check task table;

the random extraction module is used for randomly extracting a sample sequence number from the temporary sample snapshot table, randomly extracting the sample sequence number based on a preset random extraction algorithm and the random seed number, and writing a random extraction result into the temporary extraction result snapshot table;

the persistence module is used for writing the contents in the temporary sample snapshot table into the spot check sample table in the extraction record database and deleting the temporary sample snapshot table; writing the contents in the temporary extraction result snapshot table into the extraction result table in the extraction record database, and deleting the temporary extraction result snapshot table.

7. The fast random extraction system of claim 6, wherein: the system also comprises an extraction ID number generation module, wherein the extraction ID number generation module is used for generating an extraction ID number for each random extraction action, and random extraction rules, spot check samples and spot check results in the same random extraction action process have the same extraction ID number.

8. A computer program for implementing the fast random extraction method according to any one of claims 1 to 5.

9. A fast random extraction terminal device, characterized by comprising a processor, a memory and a computer program stored in the memory and configured to be executed by the processor, the processor implementing the fast random extraction method according to any of claims 1 to 5 when executing the computer program.

10. A computer readable storage medium, characterized in that the computer readable storage medium comprises a stored computer program, wherein the computer program, when run, controls a device in which the computer readable storage medium is located to perform the fast random extraction method according to any one of claims 1 to 5.

Images