Method for generating and updating database of training management system

Abstract

The invention relates to the technical field of databases, and discloses a training management system database generating and updating method. The method comprises the following steps: generating a teacher management sub-library according to a training function; generating a plurality of student storage sub-libraries according to training subjects, training processes, training tasks and student information in the teacher management sub-library, wherein one student corresponds to one student storage sub-library; before the teacher management sub-library and the student storage sub-library are used, the student storage sub-libraries of all students are self-examined by taking the teacher management sub-library as a standard; automatically creating a corresponding blank student storage sub-library under the condition that the self-examination result is that the student lacks the student storage sub-library; and under the condition that the self-examination result is that the storage format content of the student storage sub-library is missing, automatically complementing the missing storage format. Therefore, generation and interaction of the trainer management sub-library and the student storage sub-library can be realized, and universal design for different types of training tasks is realized.

Description

Technical Field

[0001] The present invention relates to the technical field of databases, and in particular, to a method for generating and updating a training management system database. Background Art

[0002] During the process of trainees' task subject training, a large amount of data is often generated. These data not only include task data directly related to training subjects and training content, but also include a large amount of data used to manage and control the entire training process. The combination of these data provides effective support for the progress of the training process. Whether it is an instructor or a trainee, when using these training data, they need to perform operations such as sorting, screening, and querying on it.

[0003] For a general training process, trainees and instructors play different roles. The establishment of a training management database is for the training management process to provide training management support for different roles during the training process. It provides functions such as data analysis and post-event review for instructors, and provides functions such as score query and training data query for trainees. This database and management system can assist trainees and instructors in completing tasks such as training process management and training data summary.

[0004] However, the databases and management systems designed for the training process in the prior art still have the following problems:

[0005] There is a lack of interaction between the training tasks of trainees and the management tasks of instructors in the training process, and the data of the two parts cannot be directly and organically integrated. When trainees and instructors use the training management database, they only simply obtain data, without analyzing and processing the usage process, lacking corresponding management. Summary of the Invention

[0006] The purpose of the present invention is to overcome the deficiencies of the prior art and provide a method for generating and updating a training management system database, which can solve the problems in the prior art.

[0007] The technical solution of the present invention: A method for generating and updating a training management system database, wherein the method includes:

[0008] Generate an instructor management sub-library according to training functions. The instructor management sub-library includes training subjects, training processes, and training tasks;

[0009] Generate multiple trainee storage sub-libraries according to the training subjects, training processes, and training tasks in the instructor management sub-library and trainee information. One trainee corresponds to one trainee storage sub-library, and the trainee storage sub-library is used to store the data generated during the trainee's training process;

[0010] Before using the instructor management sub-library and the trainee storage sub-library, take the instructor management sub-library as the standard and conduct self-checks on the trainee storage sub-libraries of all trainees;

[0011] In the case where the self-check result shows that a trainee is missing a trainee storage sub-library, automatically create a corresponding blank trainee storage sub-library;

[0012] In the case where the self-check result shows that the storage format content of the trainee storage sub-library is missing, automatically supplement the missing storage format.

[0013] Preferably, the trainee storage sub-library stores the data generated during the trainee's training process in chronological order. The trainee storage sub-library includes a self-check confirmation flag and the last write time.

[0014] Preferably, the method further includes: for the trainee storage sub-library that has completed the self-check, set the corresponding self-check confirmation flag to true.

[0015] Preferably, the method further includes: traverse all trainee storage sub-libraries, check whether their self-check confirmation flags are true, and in the case where the self-check confirmation flag is found to be false, add the trainee information of the corresponding trainee to the trainee list in the instructor management sub-library and generate and allocate a new trainee storage sub-library.

[0016] Preferably, the instructor management sub-library includes at least one instructor backup library, and the trainee storage sub-library includes at least one trainee backup library.

[0017] Preferably, the method further includes: after completing the self-check, use the instructor backup library to back up the data in the instructor management sub-library, and use the trainee backup library to back up the data in the trainee storage sub-library.

[0018] Preferably, using the instructor backup library to back up the data in the instructor management sub-library includes:

[0019] Judge whether the last write time of the instructor backup library is the same as the last write time of the instructor management sub-library;

[0020] If the last write time of the instructor backup library is the same as the last write time of the instructor management sub-library, do not perform the copy backup operation;

[0021] If the last write time of the instructor backup library is different from the last write time of the instructor management sub-library, perform the copy backup operation.

[0022] Preferably, using the trainee backup library to back up the data in the trainee storage sub-library includes:

[0023] Judge whether the last write time of the trainee backup library is the same as the last write time of the trainee storage sub-library;

[0024] If the last write time of the trainee backup library is the same as that of the trainee storage sub-library, the copy backup operation is not performed;

[0025] If they are different, the copy backup operation is performed.

[0026] Preferably, in the case of performing the copy backup operation, the data within the time period between the last write time of the instructor backup library and the last write time of the instructor management sub-library is written into the instructor backup library, and the data within the time period between the last write time of the trainee backup library and the last write time of the trainee storage sub-library is written into the trainee backup library.

[0027] Through the above technical solution, an instructor management sub-library can be generated according to the training function, and then multiple trainee storage sub-libraries can be generated based on the instructor management sub-library. Taking the instructor management sub-library as a standard, self-checking of the trainee storage sub-libraries of all trainees can be carried out. Thus, the generation and interaction of the instructor management sub-library and the trainee storage sub-library can be realized, the generalization design for different types of training tasks can be achieved, and it is convenient for instructors to process data during data query, sorting, and review, reducing the performance and time consumed in the process of re-obtaining, inputting, and calculating data. Description of the Drawings

[0028] The included drawings are used to provide a further understanding of the embodiments of the present invention. They form a part of the specification, are used to illustrate the embodiments of the present invention, and together with the text description, explain the principles of the present invention. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0029] Figure 1 It is a flowchart of a method for generating and updating a training management system database provided by an embodiment of the present invention;

[0030] Figure 2 It is a schematic diagram of a training management system database in an embodiment of the present invention;

[0031] Figure 3 It is a self-checking schematic diagram in an embodiment of the present invention;

[0032] Figure 4 It is a schematic diagram of the use of a training management database in a training system in an embodiment of the present invention;

[0033] Figure 5 It is an application schematic diagram of a training management database in different training stages in an embodiment of the present invention. Detailed Embodiments

[0034] The specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings. In the following description, for purposes of explanation and not limitation, specific details are set forth in order to provide a thorough understanding of the present invention. However, it will be apparent to those skilled in the art that the present invention may be practiced in other embodiments without these specific details.

[0035] It should be noted here that, in order to avoid obscuring the present invention with unnecessary details, only the device structures and / or processing steps closely related to the solution according to the present invention are shown in the drawings, while other details less relevant to the present invention are omitted.

[0036] Figure 1 It is a flowchart of a method for generating and updating a training management system database provided by an embodiment of the present invention.

[0037] As Figure 1 shown, an embodiment of the present invention provides a method for generating and updating a training management system database, wherein the method includes:

[0038] Generate an instructor management sub-library according to the training functions. The instructor management sub-library includes training subjects, training processes, and training tasks (including corresponding instructions);

[0039] For example, the storage structure of the instructor management sub-library can be generated by using the training management software of the training management system. Among them, the storage structure corresponds one-to-one with the training functions.

[0040] Generate multiple student storage sub-libraries according to the training subjects, training processes, training tasks in the instructor management sub-library and student information. One student corresponds to one student storage sub-library, and the student storage sub-library is used to store the data generated during the student training process;

[0041] For example, the table structure in the student storage sub-library can be generated according to the information such as training subjects, training processes, and training tasks stored in the instructor management sub-library. The generated student storage sub-library can be matched with the current training process stored in the instructor management sub-library.

[0042] Before using the instructor management sub-library and the student storage sub-library, take the instructor management sub-library as the standard to conduct self-checks on the student storage sub-libraries of all students;

[0043] In the case that the self-check result shows that a student is missing a student storage sub-library, automatically create a corresponding blank student storage sub-library;

[0044] In the case that the self-check result shows that the storage format content of the student storage sub-library is missing, automatically supplement the missing storage format.

[0045] For example, it can be determined whether there is a correspondence between the instructor management sub-library and the trainee storage sub-library. If the data table corresponding to the training process in the instructor management sub-library is missing in the trainee storage sub-library, a corresponding data table can be newly created in the trainee storage sub-library to automatically supplement the missing items (that is, to determine whether the trainee storage sub-library is complete. If there are missing parts in the storage content format of the trainee storage sub-library compared with the standard format generated by the instructor management sub-library, the missing storage format is supplemented).

[0046] In the above manner, each trainee storage sub-library is self-checked in turn to complete the self-check and update of all trainee storage sub-libraries, as Figure 3 shown.

[0047] Among them, the instructor management sub-library and the trainee storage sub-library jointly form the training management system database, as Figure 2 shown. The training management system database can be located at the terminal where the training management software is located and can be read and operated by the training management system. Both the instructor management sub-library and the trainee storage sub-library can store database files of the db type.

[0048] Through the above technical solution, the instructor management sub-library can be generated according to the training function, and then multiple trainee storage sub-libraries can be generated according to the instructor management sub-library. Taking the instructor management sub-library as the standard, the trainee storage sub-libraries of all trainees are self-checked. Thus, the generation and interaction of the instructor management sub-library and the trainee storage sub-library can be realized, the generalization design for different types of training tasks can be achieved, and it is convenient for instructors to process data during data query, sorting, and evaluation, reducing the performance and time consumed in the process of re-obtaining, inputting, and calculating data.

[0049] According to an embodiment of the present invention, trainee information can be extracted from the trainee information table in the instructor management sub-library for self-check and allocation, and the allocation order can be sorted according to the last update time (last write time) of the trainee storage library. For example, the later (newer) the last update time is, the earlier the inspection can be allocated when checking.

[0050] Thus, the database can be minimized from being updated during the initial several inspections, reducing the consumed time and saving the time for forming the standard library.

[0051] According to an embodiment of the present invention, the trainee storage sub-library stores the data generated during the trainee training process in chronological order, and the trainee storage sub-library includes a self-check confirmation flag and the last write time.

[0052] According to an embodiment of the present invention, the method further includes: for the trainee storage sub-library that has completed the self-check, setting the corresponding self-check confirmation flag to true.

[0053] That is, for each student storage sub-library that has completed self-check, set its self-check confirmation flag to true.

[0054] According to an embodiment of the present invention, the method further includes: traversing all student storage sub-libraries, checking whether the respective self-check confirmation flags are true, and in the case where the self-check confirmation flag is not true, adding the student information of the corresponding student to the student list in the instructor management sub-library, and generating and allocating a new student storage sub-library.

[0055] According to an embodiment of the present invention, the instructor management sub-library includes at least one instructor backup library, and the student storage sub-library includes at least one student backup library.

[0056] Among them, each backup library can be deployed on different terminals, synchronize the database through set update events or update frequencies. If it is detected that a certain database has data corruption, the data of the backup library can be obtained through network instructions to ensure that the data can be safely and intactly stored.

[0057] According to an embodiment of the present invention, the method further includes: after completing the self-check, backing up the data in the instructor management sub-library using the instructor backup library, and backing up the data in the student storage sub-library using the student backup library.

[0058] Thus, data consistency can be maintained and data loss can be avoided.

[0059] Among them, the student backup library can be self-checked according to the instructor management sub-library to ensure that the structure of the student backup library is consistent with that of the student storage sub-library (original library). The basic self-check process is similar to that of the student storage sub-library and will not be elaborated here.

[0060] According to an embodiment of the present invention, backing up the data in the instructor management sub-library using the instructor backup library includes:

[0061] Judging whether the last write time of the instructor backup library is consistent with the last write time of the instructor management sub-library;

[0062] If the last write time of the instructor backup library is consistent with the last write time of the instructor management sub-library, no copy backup operation is performed;

[0063] If the last write time of the instructor backup library is inconsistent with the last write time of the instructor management sub-library, a copy backup operation is performed.

[0064] According to an embodiment of the present invention, backing up the data in the student storage sub-library using the student backup library includes:

[0065] Judging whether the last write time of the student backup library is consistent with the last write time of the student storage sub-library;

[0066] If the last write time of the trainee backup library is the same as the last write time of the trainee storage sub-library, the copy backup operation is not performed;

[0067] If they are different, the copy backup operation is performed.

[0068] That is, when the last write times are the same, it is confirmed that the current is the latest library and no copy backup operation is required; when the last write times are different, the copy backup operation is performed.

[0069] According to an embodiment of the present invention, in the case of performing the copy backup operation, the data within the time period between the last write time of the instructor backup library and the last write time of the instructor management sub-library is written into the instructor backup library, and the data within the time period between the last write time of the trainee backup library and the last write time of the trainee storage sub-library is written into the trainee backup library.

[0070] That is, if data needs to be backed up, calculate the update time difference between the original library and the backup library, start from the last write time in the backup library, end with the last write time in the original library, find the data within this time period in the original library, and fill it into the backup library.

[0071] Among them, the backup can start from the trainee storage sub-library with the earliest last write time in the original library. Its update time is earlier and the probability of no change is high, which can save the previous backup speed and improve the generation speed of the trainee storage sub-library standard.

[0072] The backup operation can be automatically run each time the software starts and ends training. By continuously backing up and updating, the time consumption of a single backup process can be reduced.

[0073] Figure 4 and Figure 5 respectively show the use of the training management database in the training system and its application in different training stages. Using the training management database described in the present invention, the combination of training process management and training result evaluation is realized, which helps the instructor to directly use the training management system to complete the control and management of a whole training process, reduces the operation pressure of the instructor, and facilitates the instructor to concentrate more on the training process of the trainees.

[0074] The features described and / or illustrated above for one embodiment can be used in the same or similar manner in one or more other embodiments, and / or combined with the features in other embodiments or replace the features in other embodiments.

[0075] It should be emphasized that the term "including / comprising" when used herein refers to the presence of features, whole things, steps or components, but does not exclude the presence or addition of one or more other features, whole things, steps, components or their combinations.

[0076] The above-mentioned devices and methods of the present invention can be implemented by hardware, or by hardware in combination with software. The present invention relates to such a computer-readable program that, when executed by a logic component, can enable the logic component to implement the above-mentioned device or component, or enable the logic component to implement the above-mentioned various methods or steps. The present invention also relates to a storage medium for storing the above program, such as a hard disk, a magnetic disk, an optical disk, a DVD, a flash memory, etc.

[0077] Many features and advantages of these embodiments are clear from this detailed description, and thus the appended claims are intended to cover all such features and advantages of these embodiments that fall within their true spirit and scope. In addition, since many modifications and changes are readily conceivable by those skilled in the art, the embodiments of the present invention are not to be limited to the exact structures and operations illustrated and described, but may cover all suitable modifications and equivalents that fall within their scope.

[0078] The parts not detailed in the present invention are well-known techniques to those skilled in the art.

Claims

1. A method for generating and updating a training management system database, characterized in that, The method includes: Generating an instructor management sub-library according to the training function, where the instructor management sub-library includes training subjects, training processes, and training tasks; Generating multiple student storage sub-libraries according to the training subjects, training processes, and training tasks in the instructor management sub-library and the student information. One student corresponds to one student storage sub-library, and the student storage sub-library is used to store the data generated during the student's training process; Before using the instructor management sub-library and the student storage sub-library, taking the instructor management sub-library as the standard, conduct a self-check on the student storage sub-libraries of all students; In the case where the self-check result shows that a student is missing a student storage sub-library, automatically create a corresponding blank student storage sub-library; In the case where the self-check result shows that the storage format content of the student storage sub-library is missing, automatically supplement the missing storage format.

2. The method according to claim 1, wherein The student storage sub-library stores the data generated during the student's training process in chronological order. The student storage sub-library includes a self-check confirmation flag and the last write time.

3. The method according to claim 2, characterized in that The method further includes: for the student storage sub-library that has completed the self-check, setting the corresponding self-check confirmation flag to true.

4. The method according to claim 3, characterized in that, The method further includes: traversing all student storage sub-libraries, checking whether their self-check confirmation flags are true. In the case where a self-check confirmation flag is found to be false, adding the student information of the corresponding student to the student list in the instructor management sub-library, and generating and allocating a new student storage sub-library.

5. The method according to claim 4, characterized in that, The instructor management sub-library includes at least one instructor backup library, and the student storage sub-library includes at least one student backup library.

6. The method according to claim 5, wherein The method further includes: after completing the self-check, backing up the data in the instructor management sub-library using the instructor backup library, and backing up the data in the student storage sub-library using the student backup library.

7. The method according to claim 7, characterized in that, Backing up the data in the instructor management sub-library using the instructor backup library includes: Judging whether the last write time of the instructor backup library is the same as the last write time of the instructor management sub-library; If the last write time of the instructor backup library is the same as the last write time of the instructor management sub-library, do not perform the copy backup operation; If the last write time of the instructor backup library is different from the last write time of the instructor management sub-library, perform the copy backup operation.

8. The method according to claim 7, characterized in that, Backing up the data in the student storage sub-library using the student backup library includes: Judging whether the last write time of the student backup library is the same as the last write time of the student storage sub-library; If the last write time of the student backup library is the same as the last write time of the student storage sub-library, do not perform the copy backup operation; If they are different, perform the copy backup operation.

9. The method according to claim 8, wherein In the case of performing the copy backup operation, write the data within the time period between the last write time of the instructor backup library and the last write time of the instructor management sub-library into the instructor backup library, and write the data within the time period between the last write time of the student backup library and the last write time of the student storage sub-library into the student backup library.

Images