Mapping method applied to audio and video question bank

Abstract

The invention relates to the technical field of information processing, in particular to a mapping method applied to an audio and video question bank. Comprising the following steps: after an instruction sent when a crew selects a training question is received, extracting identity information of the crew from the instruction; based on the identity information of the sailors and a preset training question library, judging whether the sailors are allowed to select the training questions or not; when the sailors are allowed to select the training questions, whether audio and video files corresponding to the training questions exist and are accessible is judged based on a preset mapping table; when the audio and video file corresponding to the training question exists and is accessible, matching an associated file path; and playing the audio and video file based on the file path. The method has the effect of improving the training efficiency.

Description

Technical Field

[0001] The present application relates to the technical field of information processing, and in particular to a method for mapping an audio and video question bank. Background Art

[0002] In the offline environment of crew training, a common method of mapping audio and video question banks is to associate specific teaching videos with relevant exercises through preset keywords or numbers.

[0003] However, this mapping method has several disadvantages: first, it lacks flexibility because once the mapping relationship is established, it is very troublesome to change; second, it lacks personalized learning paths and cannot adjust the difficulty of questions according to the learning progress and ability of students; third, it is difficult to update resources, especially in offline environments, and the addition of new content and the update of old content require manual operations. Therefore, it needs to be improved. Summary of the invention

[0004] In order to solve the above problems, the present application provides a method for mapping an audio and video question bank.

[0005] The first object of the invention of this application is achieved through the following technical solutions:

[0006] A method for mapping an audio and video question bank, comprising:

[0007] After receiving the instruction sent by the crew member when selecting the training topic, extract the crew member's identity information from the instruction;

[0008] Based on the crew member's identity information and a preset training topic library, determining whether the crew member is allowed to select the training topic;

[0009] When the crew is allowed to select the training topic, based on the preset mapping table, it is determined whether the audio and video files corresponding to the training topic exist and are accessible;

[0010] When the audio and video files corresponding to the training topic exist and are accessible, matching the associated file path;

[0011] Play audio and video files based on the file path.

[0012] In a preferred embodiment, the step of determining whether to allow the crew member to select the training topic based on the crew member's identity information and the preset training topic library comprises the following steps:

[0013] Based on the crew member’s identity information, the corresponding authority level is matched from the preset identity database;

[0014] The identity information includes user name and password;

[0015] The authority levels include low, medium and high;

[0016] Based on the preset training topic database, obtain information on the training topic selected by the crew, including the minimum authority level required;

[0017] Compare the permission level to the minimum permission level;

[0018] When the authority level is equal to or greater than the minimum authority level, the authority is considered sufficient and the crew member is allowed to select the training topic;

[0019] When the authority level is lower than the minimum authority level, it is considered insufficient and the crew is prevented from selecting the training topic.

[0020] In a preferred embodiment, when the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on a preset mapping table, the previous step, includes the steps of:

[0021] Based on a preset audio and video file library, obtain information about the audio and video files, the information including the ID, classification, difficulty level, and key knowledge points of the audio and video files;

[0022] Based on the preset training topic database, obtain information about the training topic, including the ID, classification, difficulty level, and key knowledge points of the training topic;

[0023] Standardize the information of audio and video files and training topics and convert them into a unified format.

[0024] In a preferred embodiment, when the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on a preset mapping table, the previous step also includes the steps of:

[0025] Based on the text similarity algorithm, determine whether the similarity between the classification of the audio and video file and the classification of the training topic is greater than a first preset threshold;

[0026] When ε1>η1, ε1 is the similarity, η1 is the first preset threshold, the classification is considered to match;

[0027] Mapping the difficulty level to a difficulty value, and determining whether the difference between the difficulty value of the audio and video file and the difficulty value of the training question is within a preset error range;

[0028] Based on the preset formula Δ1=ε2-ε3, calculate the difficulty value difference Δ1, ε2 is the difficulty value of the audio and video file, ε3 is the difficulty value of the training question, when Δ1∈Δ2, Δ2 is the preset error range, then the difficulty is considered to match;

[0029] Based on keyword extraction technology, identify key knowledge points in audio and video files and training topics;

[0030] Based on the set operation, the audio and video files and the key knowledge points in the training questions are set in different sets, and it is determined whether the intersection of the sets is greater than a second preset threshold;

[0031] Based on the preset formula C=A∩B, the set intersection C is calculated, where A is the set of key knowledge points in the audio and video files, and B is the set of key knowledge points in the training questions. When C>η2, η2 is the second preset threshold, the key knowledge points are considered to match;

[0032] Based on the above three matching results, preset weights, and logical operations, determine whether a mapping relationship is established between the ID of the audio and video file and the ID of the training question;

[0033] When a mapping relationship is established, the mapping relationship is stored in a preset mapping table;

[0034] The preset mapping table includes a mapping relationship, an ID of an audio or video file, and an ID of a training topic.

[0035] In a preferred embodiment, the step of determining whether a mapping relationship is established between the ID of the audio and video file and the ID of the training topic based on the above three matching results, preset weights, and logical operations includes the following steps:

[0036] Map classification matching, difficulty matching, and key knowledge point matching into numerical values;

[0037] Set the classification matching value to δ1, the difficulty matching value to δ2, and the key knowledge point matching value to δ3;

[0038] The preset weight of classification matching is set to α1, the preset weight of difficulty matching is set to α2, and the preset weight of key knowledge point matching is set to α3;

[0039] Based on the preset weight formula Δ=α1δ1+α2δ2+α3δ3, the mapping relationship value Δ is calculated;

[0040] When Δ>η3, η3 is a preset third threshold, and a mapping relationship is established between the ID of the audio and video file and the ID of the training topic.

[0041] In a preferred embodiment, when the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on a preset mapping table comprises the following steps:

[0042] Based on the preset training topic database, matching the ID of the training topic corresponding to the training topic;

[0043] Based on the ID of the training topic, the ID of the corresponding audio and video file is matched in the preset mapping table;

[0044] Extract the audio and video files and paths corresponding to the IDs of the audio and video files from the preset audio and video file library;

[0045] Based on the API, determine whether the audio and video files exist in the path.

[0046] In a preferred embodiment, when the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on a preset mapping table further includes the steps of:

[0047] If it exists in the path, proceed to the next step to determine whether the audio and video file is accessible based on HTTP HEAD;

[0048] When the audio and video files can be read, they are accessible, and the next step is to play them;

[0049] When the audio or video file cannot be read, it is inaccessible, an error message is recorded, and the training personnel are notified that the training content cannot be played.

[0050] The above-mentioned second objective of the present application is achieved through the following technical solutions:

[0051] A system for mapping audio and video question banks, comprising:

[0052] The first receiving module: after receiving the instruction sent by the crew member when selecting the training topic, extract the crew member's identity information from the instruction;

[0053] Judgment module: based on the crew's identity information and the preset training topic library, judge whether the crew is allowed to select the training topic;

[0054] The first judgment module: when the crew is allowed to select the training topic, judging whether the audio and video files corresponding to the training topic exist and are accessible based on the preset mapping table;

[0055] The first matching module: when the audio and video files corresponding to the training topic exist and are accessible, matching the associated file paths;

[0056] The first playback module: plays audio and video files based on the file path.

[0057] The third objective of the present application is achieved through the following technical solutions:

[0058] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the above-mentioned method for audio-video question bank mapping are implemented.

[0059] The fourth objective of the present application is achieved through the following technical solutions:

[0060] A computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the above-mentioned method for audio-video question bank mapping are implemented.

[0061] In summary, the present application includes at least one of the following beneficial technical effects:

[0062] After receiving the training topic selection instruction sent by the crew through some interface (such as a computer, tablet or other device), the system will parse and extract the crew's identity information from the instruction. This information may include the crew's name, work number, position, etc., so that the system can determine the crew's identity and authority. The system will use the crew's identity information to check the preset training topic library to determine whether the crew has the authority to select the training topic they requested. This may involve permission levels, position requirements, or a history of completed training. When the system determines that the crew can select a specific training topic, the system will check whether the audio and video files associated with the training topic exist and can be accessed based on a preset mapping table. A mapping table is a table or database that associates training topics with corresponding media files. Once it is confirmed that the audio and video files exist and are accessible, the system will find and match the specific storage paths of these files so that they can be played in the next step. The system will use the file path determined in the previous step to play the corresponding audio and video files so that the crew can conduct training and learning. BRIEF DESCRIPTION OF THE DRAWINGS

[0063] Figure 1 This is a flowchart of an implementation of an audio and video question bank mapping method embodiment of the present application;

[0064] Figure 2 This is a flowchart of an implementation of step S20 in an embodiment of the audio and video question bank mapping method of the present application;

[0065] Figure 3 This is an implementation flow chart before step S30 in an embodiment of the audio and video question bank mapping method of the present application;

[0066] Figure 4 This is another implementation flow chart before step S30 in the embodiment of the audio and video question bank mapping method of the present application;

[0067] Figure 5 This is a flowchart of an implementation of step SB8 in an embodiment of the audio and video question bank mapping method of the present application;

[0068] Figure 6 This is a flowchart of an implementation of step S30 in an embodiment of the audio and video question bank mapping method of the present application;

[0069] Figure 7 This is another implementation flow chart of step S30 in an embodiment of the audio and video question bank mapping method of the present application;

[0070] Figure 8 This is a principle block diagram of a computer device of the present application. DETAILED DESCRIPTION

[0071] The following is combined with Figure 1-8 This application is described in further detail.

[0072] In one embodiment, if Figure 1 As shown, the present application discloses a method for mapping audio and video question banks, which specifically includes the following steps:

[0073] S10: after receiving the instruction sent by the crew member when selecting the training topic, extracting the crew member's identity information from the instruction;

[0074] In this embodiment, this step means that after the system receives the training topic selection instruction sent by the crew through a certain interface (such as a computer, tablet or other device), it will parse and extract the crew's identity information from the instruction. This information may include the crew's name, work number, position, etc., so that the system can determine the crew's identity and authority.

[0075] S20: Based on the crew member's identity information and a preset training topic library, determining whether the crew member is allowed to select the training topic;

[0076] In this embodiment, in this step, the system uses the crew member's identity information to check the preset training topic library to determine whether the crew member has the authority to select the training topic they requested. This may involve authority level, position requirements, or a history of completed training.

[0077] S30: When the crew is allowed to select the training topic, based on the preset mapping table, it is determined whether the audio and video file corresponding to the training topic exists and is accessible;

[0078] In this embodiment, when the system determines that the crew can select a specific training topic, the system will check whether the audio and video files associated with the training topic exist and can be accessed according to a preset mapping table. The mapping table is a table or database that associates the training topic with the corresponding media files.

[0079] S40: When the audio and video files corresponding to the training topic exist and are accessible, matching the associated file paths;

[0080] In this embodiment, once it is confirmed that the audio and video files exist and are accessible, the system will find and match the specific storage paths of these files so that these files can be played in the next step.

[0081] S50: Play the audio and video files based on the file path.

[0082] In this embodiment, the system will use the file path determined in the previous step to play the corresponding audio and video files so that the crew can conduct training and learning.

[0083] Figure 2 , step S20, comprising the steps of:

[0084] S201: Based on the crew member's identity information, matching the corresponding authority level from a preset identity database;

[0085] S202: The identity information includes a user name and a password;

[0086] S203: The authority levels include low, medium and high;

[0087] S204: Based on the preset training topic database, obtaining information on the training topic selected by the crew member, the information including the minimum authority level required;

[0088] S205: Compare the permission level with the minimum permission level;

[0089] S206: When the authority level is equal to or greater than the minimum authority level, the authority is considered sufficient and the crew member is allowed to select the training topic;

[0090] S207: When the authority level is lower than the minimum authority level, it is considered that the authority is insufficient and the crew member is prevented from selecting the training topic.

[0091] In this embodiment, steps S201 to S207 together constitute a permission verification process, which ensures that the crew's operations in the training system match their permission levels, thereby maintaining access control and security of training resources. Specifically, the working principle of this process is as follows: S201: The system uses the identity information provided by the crew, that is, the user name and password, to query in the preset identity database to determine the permission level of the crew. This step is the key to verifying the crew's identity and permissions. S202: The username and password of the identity information are the credentials for the crew to log in to the system, and they must be correct so that the system can identify and verify the identity of the crew. S203: The permission levels are divided into low, medium and high levels, and each level corresponds to different access rights. These permission levels determine which training content the crew can access. S204: When the crew selects a training topic in the system, the system retrieves relevant information about the topic according to the preset training topic library, including the minimum permission level required to access the topic. S205: Next, the system compares the crew's permission level with the minimum permission level required for the selected training topic to determine whether the crew is eligible to access the training content. S206: When the crew's authority level is equal to or higher than the minimum authority level, the system will consider the crew to have sufficient authority, thereby allowing them to select and participate in the training topic. S207: When the crew's authority level is lower than the minimum authority level, the system will consider the crew to not have the required authority, and will therefore prevent them from selecting the training topic to prevent unauthorized access.

[0092] Figure 3 , step S30, the previous step, includes the steps:

[0093] SA1: Based on a preset audio and video file library, obtain information about audio and video files, including the ID, classification, difficulty level, and key knowledge points of the audio and video files;

[0094] SA2: Based on the preset training topic database, obtain the information of the training topic, the information including the ID, classification, difficulty level, and key knowledge points of the training topic;

[0095] SA3: Standardize the information of audio and video files and training topics and convert them into a unified format.

[0096] In this embodiment, SA1: the system first extracts relevant information of the audio and video files from the preset audio and video file library, which includes but is not limited to the unique identifier (ID) of the audio and video files, classification (such as lectures, practical demonstrations, etc.), difficulty level (such as entry, intermediate, advanced) and key knowledge points covered by the files. This information helps the system to classify and screen the audio and video files to meet specific training needs. SA2: Then, the system also obtains detailed information of the training topics from the preset training topic library, which also includes the ID, classification, difficulty level and key knowledge points of the training topics. This information enables the system to match the training topics with appropriate audio and video files according to their characteristics to provide more personalized training content. SA3: Finally, the system performs standardization processing on the information obtained from the audio and video files and training topics and converts them into a unified format. This step is crucial because it ensures that data from different sources are compatible and facilitates subsequent analysis and processing. Standardization processing may include conversion of data formats, unification of classification systems, standardization of difficulty levels, etc., so that the information of audio and video files and training topics can be seamlessly connected, improving the utilization rate of system resources and training effects. In general, this embodiment provides an efficient and flexible resource management and matching mechanism for the training system through a standardized information processing process, which helps to improve user experience and training quality.

[0097] Figure 4 , step S30, the previous step, also includes the steps:

[0098] SB1: Based on the text similarity algorithm, determine whether the similarity between the classification of the audio and video file and the classification of the training topic is greater than a first preset threshold;

[0099] SB2: When ε1>η1, ε1 is the similarity, η1 is the first preset threshold, the classification is considered to be matched;

[0100] SB3: Map the difficulty level to a difficulty value, and determine whether the difference between the difficulty value of the audio and video file and the difficulty value of the training question is within a preset error range;

[0101] SB4: Based on the preset formula Δ1=ε2-ε3, calculate the difficulty value difference Δ1, ε2 is the difficulty value of the audio and video file, ε3 is the difficulty value of the training question, when Δ1∈Δ2, Δ2 is the preset error range, then the difficulty is considered to match;

[0102] SB5: Based on keyword extraction technology, identify key knowledge points in audio and video files and training questions;

[0103] SB6: Based on the set operation, the audio and video files and the key knowledge points in the training questions are set in different sets, and it is determined whether the intersection of the sets is greater than a second preset threshold;

[0104] SB7: Based on the preset formula C=A∩B, calculate the set intersection C, where A is the set of key knowledge points of the audio and video files, and B is the set of key knowledge points of the training questions. When C>η2, η2 is the second preset threshold, it is considered that the key knowledge points match;

[0105] SB8: Based on the above three matching results, preset weights, and logical operations, determine whether a mapping relationship is established between the ID of the audio and video file and the ID of the training question;

[0106] SB9: When a mapping relationship is established, the mapping relationship is stored in a preset mapping table;

[0107] SB10: The preset mapping table includes a mapping relationship, the ID of the audio and video file, and the ID of the training topic.

[0108] In this embodiment, SB1: The system uses a text similarity algorithm to compare the similarity between the classification of the audio and video files and the classification of the training questions to determine whether they are close enough. When the similarity is greater than a preset threshold, the system considers that the two classifications are matched. SB2: When the classification similarity is greater than the first preset threshold, the system will determine that the classification matches, which is the first step in associating the audio and video files with the training questions. SB3: Then, the system converts the difficulty level into a numerical value to compare whether the difficulty of the audio and video files matches that of the training questions. SB4: The difference between the difficulty values ​​of the audio and video files and the training questions is calculated by a preset formula. When this difference is within a preset error range, the difficulty is considered to match. SB5: The system uses keyword extraction technology to identify key knowledge points from the audio and video files and the training questions. SB6: Through set operations, the system puts the key knowledge points in the audio and video files and the training questions into different sets respectively, and determines whether the intersection of the two sets is greater than the second preset threshold. SB7: When the set intersection is greater than the second preset threshold, the system considers that the key knowledge points match, which is the third step in associating the audio and video files with the training questions. SB8: Based on the matching results of classification, difficulty and key knowledge points, as well as preset weights and logical operations, the system determines whether a mapping relationship should be established between the ID of the audio and video file and the ID of the training topic. SB9: When it is determined to establish a mapping relationship, the system stores this relationship in a preset mapping table, which records the audio and video file ID, the training topic ID and the mapping relationship between them. SB0: The preset mapping table is a data structure for storing mapping relationships, which enables the system to quickly retrieve and match relevant training resources, thereby improving the efficiency of the training system and user experience. In general, this embodiment realizes intelligent matching between audio and video files and training topics through a series of algorithms and logical steps, ensuring that crew members can obtain training content that matches their needs and levels.

[0109] Figure 5 , SB8 step, comprising the steps of:

[0110] SC1: Map classification matching, difficulty matching, and key knowledge point matching into numerical values;

[0111] SC2: Set the classification matching value to δ1, the difficulty matching value to δ2, and the key knowledge point matching value to δ3;

[0112] SC3: Set the preset weight of classification matching to α1, the preset weight of difficulty matching to α2, and the preset weight of key knowledge point matching to α3;

[0113] SC4: Calculate the mapping relationship value Δ based on the preset weight formula Δ=α1δ1+α2δ2+α3δ3;

[0114] SC5: When Δ>η3, η3 is a preset third threshold, and a mapping relationship is established between the ID of the audio and video file and the ID of the training topic.

[0115] In this embodiment, SC1: The system first converts the matching results of the three dimensions of classification matching, difficulty matching and key knowledge point matching into numerical values. This conversion is for subsequent quantitative analysis and calculation. SC2: Then, the system assigns a specific numerical value to each matching dimension. The classification matching numerical value is set to δ1, the difficulty matching numerical value is set to δ2, and the key knowledge point matching numerical value is set to δ3. SC3: The system sets a preset weight for each matching dimension, and these weights reflect the importance of different matching dimensions in the overall matching process. The preset weight of classification matching is set to α1, the preset weight of difficulty matching is set to α2, and the preset weight of key knowledge point matching is set to α3. SC4: Based on the preset weight formula, the system calculates a mapping relationship numerical value Δ. This calculation usually involves multiplying the numerical value of each matching dimension by its corresponding weight, and then adding the results. The calculation formula is: Δ=α1δ1+α2δ2+α3δ3. SC5: Finally, the system compares the calculated mapping relationship numerical value Δ with a preset third threshold value η3. When Δ>η3, the system considers that there is sufficient match between the ID of the audio and video file and the ID of the training question, thereby establishing a mapping relationship. In general, this embodiment achieves a quantitative evaluation of the matching degree between audio and video files and training topics by digitizing the matching results, applying weights, and comparing with thresholds, thereby ensuring the accuracy of the mapping relationship and the effective matching of training resources.

[0116] Figure 6 , step S30, comprising the steps of:

[0117] S301: Matching the ID of the training topic corresponding to the training topic based on the preset training topic database;

[0118] S302: Based on the ID of the training topic, match the ID of the corresponding audio and video file in the preset mapping table;

[0119] S303: extracting the audio and video files and paths corresponding to the IDs of the audio and video files from the preset audio and video file library;

[0120] S304: Based on the API, determine whether the audio or video file exists in the path.

[0121] In this embodiment, S301: the system first finds the corresponding training topic ID in the preset training topic library based on the content of the training topic. This step is the key to identifying and locating training resources. S302: After obtaining the training topic ID, the system next searches the preset mapping table for the audio and video file ID associated with the training topic ID. The mapping table records the correspondence between the training topic and the audio and video file. S303: the system extracts the corresponding audio and video file and its storage path from the preset audio and video file library based on the found audio and video file ID. This step is to obtain the actual location of the audio and video file. S304: using the API (application programming interface), the system checks whether the audio and video file exists on the previously extracted path. This verification step ensures the accuracy of the file location.

[0122] Figure 7 , step S30 further includes the steps of:

[0123] S305: If it exists in the path, proceed to the next step, based on HTTP HEAD,

[0124] Determine whether the audio and video files are accessible;

[0125] S306: When the audio and video file can be read, it is accessible, and the next step of playing is continued;

[0126] S307: When the audio or video file cannot be read, it is inaccessible, an error message is recorded, and the training personnel are notified that the training content cannot be played.

[0127] In this embodiment, S305: When the audio and video file exists in the specified path, the system will proceed to the next step, that is, use the HTTP HEAD request to check whether the audio and video file is accessible. The HTTP HEAD request will not download the file content, but can obtain the header information of the file to determine whether the file is readable. S306: When the audio and video file can be read, that is, the file is accessible, the system will continue to perform the playback operation so that the trainee can watch or listen to the training content. S307: When the audio and video file cannot be read, that is, the file is inaccessible, the system will record an error message and notify the trainee that the training content cannot be played. This step helps to feedback the problem in time and take corresponding measures to solve the problem. In general, this embodiment ensures that the trainee can smoothly access the audio and video resources related to the training topic through a series of inspection and verification steps, thereby improving the efficiency and quality of the training. At the same time, it also provides a mechanism to deal with possible access problems and ensure the stable operation of the training system.

[0128] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0129] In one embodiment, a system for mapping audio and video question banks is provided, and the system for mapping audio and video question banks corresponds to the method for mapping audio and video question banks in the above embodiment. The system for mapping audio and video question banks includes:

[0130] The first receiving module: after receiving the instruction sent by the crew member when selecting the training topic, extract the crew member's identity information from the instruction;

[0131] Judgment module: based on the crew's identity information and the preset training topic library, judge whether the crew is allowed to select the training topic;

[0132] The first judgment module: when the crew is allowed to select the training topic, judging whether the audio and video files corresponding to the training topic exist and are accessible based on the preset mapping table;

[0133] The first matching module: when the audio and video files corresponding to the training topic exist and are accessible, matching the associated file paths;

[0134] The first playback module: plays audio and video files based on the file path.

[0135] Optionally, also include:

[0136] The second matching module: based on the crew's identity information, matches the corresponding authority level from the preset identity database;

[0137] First information module: the identity information includes user name and password;

[0138] Permission module: the permission levels include low, medium and high;

[0139] Acquisition module: Based on the preset training topic library, obtain the information of the training topic selected by the crew, including the minimum authority level required;

[0140] The first comparison module: compares the permission level with the minimum permission level;

[0141] Second comparison module: when the authority level is equal to or greater than the minimum authority level, it is considered that the authority is sufficient and the crew member is allowed to select the training topic;

[0142] The third comparison module: When the authority level is lower than the minimum authority level, it is considered that the authority is insufficient and the crew is prevented from selecting the training topic.

[0143] Optionally, also include:

[0144] The first acquisition module: based on a preset audio and video file library, acquires information of audio and video files, the information including the ID, classification, difficulty level, and key knowledge points of the audio and video files;

[0145] The second acquisition module: based on the preset training topic database, obtains the information of the training topic, the information includes the ID, classification, difficulty level, and key knowledge points of the training topic;

[0146] The first processing module: standardizes the information of audio and video files and training topics and converts them into a unified format.

[0147] Optionally, also include:

[0148] The second judgment module: based on the text similarity algorithm, judges whether the similarity between the classification of the audio and video files and the classification of the training questions is greater than a first preset threshold;

[0149] Classification module: when ε1>η1, ε1 is the similarity, η1 is the first preset threshold, the classification is considered to match;

[0150] The third judgment module: maps the difficulty level to a difficulty value, and judges whether the difference between the difficulty value of the audio and video file and the difficulty value of the training question is within a preset error range;

[0151] Difficulty module: Based on the preset formula Δ1=ε2-ε3, the difficulty value difference Δ1 is calculated, ε2 is the difficulty value of the audio and video file, and ε3 is the difficulty value of the training question. When Δ1∈Δ2, Δ2 is the preset error range, then the difficulty is considered to match;

[0152] The first recognition module: Based on keyword extraction technology, it identifies key knowledge points in audio and video files and training topics;

[0153] The fourth judgment module: based on the set operation, sets the audio and video files and the key knowledge points in the training questions in different sets, and judges whether the intersection of the sets is greater than the second preset threshold;

[0154] Key knowledge point module: Based on the preset formula C=A∩B, the set intersection C is calculated, where A is the key knowledge point set of the audio and video files, and B is the key knowledge point set of the training questions. When C>η2, η2 is the second preset threshold, the key knowledge points are considered to match;

[0155] The fifth judgment module: based on the above three matching results, preset weights, and logical operations, judge whether a mapping relationship is established between the ID of the audio and video file and the ID of the training topic;

[0156] The first storage module: when a mapping relationship is established, the mapping relationship is stored in a preset mapping table;

[0157] Mapping table module: The preset mapping table includes mapping relationships, IDs of audio and video files, and IDs of training topics.

[0158] Optionally, also include:

[0159] The first mapping module: maps classification matching, difficulty matching, and key knowledge point matching into numerical values;

[0160] Setting module: set the category matching value to δ1, the difficulty matching value to δ2, and the key knowledge point matching value to δ3;

[0161] The first setting module: setting the preset weight of the classification matching to α1, the preset weight of the difficulty matching to α2, and the preset weight of the key knowledge point matching to α3;

[0162] The first calculation module: based on the preset weight formula Δ=α1δ1+α2δ2+α3δ3, calculates the mapping relationship value Δ;

[0163] Mapping relationship module: When Δ>η3, η3 is the preset third threshold, and a mapping relationship is established between the ID of the audio and video file and the ID of the training topic.

[0164] Optionally, also include:

[0165] Module A: Based on the preset training topic database, match the ID of the training topic corresponding to the training topic;

[0166] Module B: Based on the ID of the training topic, match the ID of the corresponding audio and video file in the preset mapping table;

[0167] Module C: extract the audio and video files and paths corresponding to the IDs of the audio and video files from the preset audio and video file library;

[0168] D module: Based on the API, determine whether the audio and video files exist in the path.

[0169] Optionally, also include:

[0170] E module: If it exists in the path, it will continue to the next step based on HTTP HEAD.

[0171] Determine whether the audio and video files are accessible;

[0172] F module: When the audio and video files can be read, they are accessible, and the next step is to play;

[0173] G module: When the audio or video file cannot be read, it is inaccessible, an error message is recorded, and the training staff is notified that the training content cannot be played.

[0174] For the specific definition of a system for mapping audio and video question banks, please refer to the definition of a method for mapping audio and video question banks mentioned above, which will not be repeated here. Each module in the above-mentioned system for mapping audio and video question banks can be implemented in whole or in part through software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0175] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 8 As shown. The computer device includes a processor, a memory, a network interface and a database connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store audio and video files. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for mapping an audio and video question bank is implemented.

[0176] In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, a method for mapping an audio and video question bank is implemented.

[0177] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, a method for mapping an audio-video question bank is provided.

[0178] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0179] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

Claims

1. A method for mapping audio and video question banks, characterized in that: include: After receiving the instruction sent by the crew member when selecting the training topic, extract the crew member's identity information from the instruction; Based on the crew member's identity information and a preset training topic library, determining whether the crew member is allowed to select the training topic; When the crew is allowed to select the training topic, based on the preset mapping table, it is determined whether the audio and video files corresponding to the training topic exist and are accessible; When the audio and video files corresponding to the training topic exist and are accessible, matching the associated file path; Play audio and video files based on the file path.

2. A method for mapping audio and video question banks according to claim 1, characterized in that: The step of judging whether to allow the crew member to select the training topic based on the crew member's identity information and the preset training topic library comprises the following steps: Based on the crew member’s identity information, the corresponding authority level is matched from the preset identity database; The identity information includes user name and password; The authority levels include low, medium and high; Based on the preset training topic database, obtain information on the training topic selected by the crew, including the minimum authority level required; Compare the permission level to the minimum permission level; When the authority level is equal to or greater than the minimum authority level, the authority is considered sufficient and the crew member is allowed to select the training topic; When the authority level is lower than the minimum authority level, it is considered insufficient and the crew is prevented from selecting the training topic.

3. The method for mapping audio and video question banks according to claim 1, characterized in that: When the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on the preset mapping table, the previous step includes the steps of: Based on a preset audio and video file library, obtain information about the audio and video files, the information including the ID, classification, difficulty level, and key knowledge points of the audio and video files; Based on the preset training topic database, obtain information about the training topic, including the ID, classification, difficulty level, and key knowledge points of the training topic; Standardize the information of audio and video files and training topics and convert them into a unified format.

4. The method for mapping audio and video question banks according to claim 1, characterized in that: When the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on the preset mapping table, the previous step also includes the step of: Based on the text similarity algorithm, determine whether the similarity between the classification of the audio and video file and the classification of the training topic is greater than a first preset threshold; When ε1>η1, ε1 is the similarity, η1 is the first preset threshold, the classification is considered to match; Mapping the difficulty level to a difficulty value, and determining whether the difference between the difficulty value of the audio and video file and the difficulty value of the training question is within a preset error range; Based on the preset formula Δ1=ε2-ε3, calculate the difficulty value difference Δ1, ε2 is the difficulty value of the audio and video file, ε3 is the difficulty value of the training question, when Δ1∈Δ2, Δ2 is the preset error range, then the difficulty is considered to match; Based on keyword extraction technology, identify key knowledge points in audio and video files and training topics; Based on the set operation, the audio and video files and the key knowledge points in the training questions are set in different sets, and it is determined whether the intersection of the sets is greater than a second preset threshold; Based on the preset formula C=A∩B, the set intersection C is calculated, where A is the set of key knowledge points in the audio and video files, and B is the set of key knowledge points in the training questions. When C>η2, η2 is the second preset threshold, the key knowledge points are considered to match; Based on the above three matching results, preset weights, and logical operations, determine whether a mapping relationship is established between the ID of the audio and video file and the ID of the training question; When a mapping relationship is established, the mapping relationship is stored in a preset mapping table; The preset mapping table includes a mapping relationship, an ID of an audio or video file, and an ID of a training topic.

5. A method for mapping audio and video question banks according to claim 4, characterized in that: The step of determining whether a mapping relationship is established between the ID of the audio and video file and the ID of the training topic based on the above three matching results, preset weights, and logical operations comprises the following steps: Map classification matching, difficulty matching, and key knowledge point matching into numerical values; Set the classification matching value to δ1, the difficulty matching value to δ2, and the key knowledge point matching value to δ3; The preset weight of classification matching is set to α1, the preset weight of difficulty matching is set to α2, and the preset weight of key knowledge point matching is set to α3; Based on the preset weight formula Δ=α1δ1+α2δ2+α3δ3, the mapping relationship value Δ is calculated; When Δ>η3, η3 is a preset third threshold, and a mapping relationship is established between the ID of the audio and video file and the ID of the training topic.

6. The method for mapping audio and video question banks according to claim 1, characterized in that: When the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on the preset mapping table comprises the following steps: Based on the preset training topic database, matching the ID of the training topic corresponding to the training topic; Based on the ID of the training topic, the ID of the corresponding audio and video file is matched in the preset mapping table; Extract the audio and video files and paths corresponding to the IDs of the audio and video files from the preset audio and video file library; Based on the API, determine whether the audio and video files exist in the path.

7. The method for mapping audio and video question banks according to claim 1, characterized in that: When the crew is allowed to select the training topic, the step of determining whether the audio and video file corresponding to the training topic exists and is accessible based on the preset mapping table further includes the steps of: If it exists at the path, it will proceed to the next step based on HTTP HEAD. Determine whether the audio and video files are accessible; When the audio and video files can be read, they are accessible, and the next step is to play them; When the audio or video file cannot be read, it is inaccessible, an error message is recorded, and the training personnel are notified that the training content cannot be played.

8. A system for mapping audio and video question banks, characterized in that: include: The first receiving module: after receiving the instruction sent by the crew member when selecting the training topic, extract the crew member's identity information from the instruction; Judgment module: based on the crew's identity information and the preset training topic library, judge whether the crew is allowed to select the training topic; The first judgment module: when the crew is allowed to select the training topic, judging whether the audio and video files corresponding to the training topic exist and are accessible based on the preset mapping table; The first matching module: when the audio and video files corresponding to the training topic exist and are accessible, matching the associated file paths; The first playback module: plays audio and video files based on the file path.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of a method for audio-video question bank mapping as described in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of a method for audio-video question bank mapping as described in any one of claims 1 to 7 are implemented.

Images