A method and system for querying shared educational resources across multiple education systems

Abstract

This invention provides a method and system for querying shared educational resources across multiple educational systems, relating to the field of data query technology. By establishing quadrant tables for all shared educational resources and the time to be queried, and generating corresponding coordinate codes, the occupancy status of shared educational resources is determined by comparing these coordinate codes. This reduces the number of effective comparisons, improves retrieval efficiency, and shortens retrieval time.

Description

Technical Field

[0001] This invention relates to the field of data query technology, specifically to a method and system for querying shared educational resources across multiple educational systems. Background Technology

[0002] Currently, universities typically have two independent educational resource management systems: an "undergraduate teaching system" and a "graduate teaching system." However, in actual use, educational resources are shared, such as classroom resources. Therefore, in the process of managing these shared educational resources, it is often necessary to check the occupancy status of these resources.

[0003] Currently, the query method for educational resources involves comparing occupied classrooms, and the number of comparisons equals the number of occupied classrooms multiplied by the number of sessions used. This results in a large number of comparisons and affects query efficiency. Summary of the Invention

[0004] (a) Technical problems to be solved

[0005] To address the shortcomings of existing technologies, this invention provides a method and system for querying shared educational resources across multiple educational systems, solving the problem of low efficiency in existing query methods.

[0006] (II) Technical Solution

[0007] To achieve the above objectives, the present invention provides the following technical solution:

[0008] Firstly, a method for querying shared educational resources across multiple educational systems is provided, the method comprising:

[0009] Obtain information on the occupied shared educational resources of various education systems and merge them to obtain a shared educational resource database;

[0010] Based on the quadrant table construction rules, obtain the first quadrant table corresponding to each shared educational resource in the shared educational resource library for each week;

[0011] Based on the coordinate code generation rules, the first coordinate code and the second coordinate code corresponding to each of the first quadrant tables are obtained and stored.

[0012] Based on the quadrant table construction rules, a second quadrant table corresponding to the time to be queried is constructed, and based on the coordinate code generation rules, the third coordinate code corresponding to the second quadrant table corresponding to the time to be queried is obtained and stored.

[0013] The occupancy status of each shared educational resource at the time of query is obtained based on the third coordinate code of the second quadrant table and the coordinate code of the first quadrant table of each shared educational resource.

[0014] Furthermore, the shared educational resource database contains usage information for each shared educational resource in different weeks, days of the week, and periods.

[0015] Furthermore, the quadrant table construction rules include:

[0016] The column index in the quadrant table is from Monday to Sunday, and the row index is all sections.

[0017] The values ​​of the cells in the quadrant table include a first state value and a second state value;

[0018] The first status value indicates that the shared educational resource is occupied in the corresponding week, day of the week, and period;

[0019] The second status value indicates that the shared educational resource is not occupied in the corresponding week, day of the week, or period.

[0020] Furthermore, the coordinate code generation rules include:

[0021] The week number, column index value, and row index value corresponding to the cell with the first state value in the quadrant table are used as the first coordinate code;

[0022] The week number, column index value, and row index value corresponding to the cell with the second state value in the quadrant table are used as the second coordinate code.

[0023] Furthermore, the step of obtaining the occupancy status of each shared educational resource at the time of query based on the third coordinate code of the second quadrant table and the coordinate codes of each shared educational resource in the first quadrant table includes:

[0024] Determine whether the number of sessions occupied by each shared educational resource in a day exceeds half of the maximum number of sessions;

[0025] If less than half, determine whether each shared educational resource has a first coordinate code that is the same as the third coordinate code. If it does, set the shared educational resource to be occupied at the time of query; otherwise, set the shared educational resource to be unoccupied at the time of query.

[0026] If more than half are found, it is determined whether each shared educational resource has a second coordinate code that is the same as the third coordinate code. If it does, the shared educational resource is set to unoccupied status at the time of query; otherwise, the shared educational resource is set to occupied status at the time of query.

[0027] Secondly, a shared educational resource query system for multiple educational systems is provided, the system comprising:

[0028] The shared educational resource library acquisition module is used to acquire information on the occupied shared educational resources of various educational systems and merge them to obtain a shared educational resource library.

[0029] The quadrant table acquisition module is used to obtain the first quadrant table corresponding to each shared educational resource in the shared educational resource library for each week based on the quadrant table construction rules; it is also used to construct the second quadrant table corresponding to the time to be queried based on the quadrant table construction rules.

[0030] The coordinate code generation module is used to obtain and store the first coordinate code and the second coordinate code corresponding to each of the first quadrant tables based on the coordinate code generation rules; it is also used to obtain and store the third coordinate code corresponding to the second quadrant table corresponding to the time to be queried based on the coordinate code generation rules.

[0031] The shared educational resource occupancy status judgment module obtains the occupancy status of each shared educational resource at the time to be queried based on the third coordinate code of the second quadrant table and the coordinate code of each shared educational resource in the first quadrant table.

[0032] Furthermore, the shared educational resource database contains usage information for each shared educational resource in different weeks, days of the week, and periods.

[0033] Furthermore, the quadrant table construction rules include:

[0034] The column index in the quadrant table is from Monday to Sunday, and the row index is all sections.

[0035] The values ​​of the cells in the quadrant table include a first state value and a second state value;

[0036] The first status value indicates that the shared educational resource is occupied in the corresponding week, day of the week, and period;

[0037] The second status value indicates that the shared educational resource is not occupied in the corresponding week, day of the week, or period.

[0038] Furthermore, the coordinate code generation rules include:

[0039] The week number, column index value, and row index value corresponding to the cell with the first state value in the quadrant table are used as the first coordinate code;

[0040] The week number, column index value, and row index value corresponding to the cell with the second state value in the quadrant table are used as the second coordinate code.

[0041] Furthermore, the step of obtaining the occupancy status of each shared educational resource at the time of query based on the third coordinate code of the second quadrant table and the coordinate codes of each shared educational resource in the first quadrant table includes:

[0042] Determine whether the number of sessions occupied by each shared educational resource in a day exceeds half of the maximum number of sessions;

[0043] If less than half, determine whether each shared educational resource has a first coordinate code that is the same as the third coordinate code. If it does, set the shared educational resource to be occupied at the time of query; otherwise, set the shared educational resource to be unoccupied at the time of query.

[0044] If more than half are found, it is determined whether each shared educational resource has a second coordinate code that is the same as the third coordinate code. If it does, the shared educational resource is set to unoccupied status at the time of query; otherwise, the shared educational resource is set to occupied status at the time of query.

[0045] (III) Beneficial Effects

[0046] This invention provides a method and system for querying shared educational resources across multiple educational systems. Compared with existing technologies, it has the following advantages:

[0047] This invention establishes quadrant tables for all shared educational resources and the time to be queried, generates corresponding coordinate codes, and finally determines the occupancy status of shared educational resources by comparing the coordinate codes. This reduces the number of effective comparisons, improves retrieval efficiency, and shortens retrieval time. Attached Figure Description

[0048] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0049] Figure 1 This is a flowchart of the present invention. Detailed Implementation

[0050] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention are described clearly and completely. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0051] This application provides a method and system for querying shared educational resources across multiple educational systems, thus solving the problem of low efficiency in existing query methods.

[0052] To better understand the above technical solutions, the following will provide a detailed explanation of the technical solutions in conjunction with the accompanying drawings and specific implementation methods.

[0053] Example 1:

[0054] like Figure 1 As shown, this invention provides a method for querying shared educational resources across multiple educational systems. This method is executed by a computer and includes:

[0055] Obtain information on the occupied shared educational resources of various education systems and merge them to obtain a shared educational resource database;

[0056] Based on the quadrant table construction rules, obtain the first quadrant table corresponding to each shared educational resource in the shared educational resource library for each week;

[0057] Based on the coordinate code generation rules, the first coordinate code and the second coordinate code corresponding to each of the first quadrant tables are obtained and stored.

[0058] Based on the quadrant table construction rules, a second quadrant table corresponding to the time to be queried is constructed, and based on the coordinate code generation rules, the third coordinate code corresponding to the second quadrant table corresponding to the time to be queried is obtained and stored.

[0059] The occupancy status of each shared educational resource at the time of query is obtained based on the third coordinate code of the second quadrant table and the coordinate code of the first quadrant table of each shared educational resource.

[0060] The beneficial effects of this embodiment are:

[0061] This invention establishes quadrant tables for all shared educational resources and the time to be queried, generates corresponding coordinate codes, and finally determines the occupancy status of shared educational resources by comparing the coordinate codes. This reduces the number of effective comparisons, improves retrieval efficiency, and shortens retrieval time.

[0062] The implementation process of the embodiments of the present invention will be described in detail below:

[0063] Currently, a university has both an "Undergraduate Teaching System" and a "Graduate Teaching System." The university has approximately several hundred classrooms, and the academic cycle lasts 18 weeks. Due to limited teaching space resources, to improve the utilization rate of teaching space, it is necessary to share teaching space between the two systems and query classroom usage in real time. For example, we need to query which classrooms are available during the second period on Wednesday, week 5 of the first semester of the 2022-2023 academic year. Traditionally, this query requires comparing already occupied classrooms, and the number of comparisons equals the number of occupied classrooms multiplied by the number of periods used. This results in a large number of comparisons and impacts query efficiency.

[0064] The classroom records already occupied in the undergraduate and graduate systems are shown in Tables 1 and 2 (0 = unused, 1 = used):

[0065] Table 1

[0066]

[0067]

[0068] Table 2

[0069]

[0070] Regarding the above data, the specific steps of this embodiment include:

[0071] S1. Obtain information on the occupied shared educational resources of various education systems and merge them to obtain a shared educational resource library.

[0072] In practice, the merged shared educational resource library is shown in Table 3. The shared educational resource library contains the occupancy information of each shared educational resource in different weeks, different days of the week, and different periods:

[0073] Table 3

[0074]

[0075]

[0076]

[0077] S2. Based on the quadrant table construction rules, obtain the first quadrant table corresponding to each shared educational resource in the shared educational resource library for each week.

[0078] In practical implementation, the rules for constructing the quadrant table are as follows:

[0079] The column index in the quadrant table is Monday to Sunday, and the row index is the period. The value of the cell in the quadrant table includes a first status value, which indicates that the shared educational resource is occupied in the corresponding week, day of the week, and period. For example, a first status value of 1 indicates that it is occupied, and a second status value of 0 indicates that it is not occupied.

[0080] For example, Table 3 shows the first quadrant table corresponding to a certain classroom in the first week:

[0081] Table 3

[0082]

[0083] The value in the cell is the first status value (i.e., 1), indicating that the classroom is occupied during the first period on Wednesday of the first week. Following this pattern, a first quadrant table can be obtained for each shared educational resource in each week.

[0084] S3. Based on the coordinate code generation rules, obtain and store the first coordinate code and the second coordinate code corresponding to each of the first quadrant tables.

[0085] In specific implementation, the coordinate code generation rules include:

[0086] The week number, column index value, and row index value corresponding to the cell with the first state value in the quadrant table are used as the first coordinate code;

[0087] The week number, column index value, and row index value corresponding to the cell with the second state value in the quadrant table are used as the second coordinate code;

[0088] Therefore, the coordinate code can be represented as (week value + day of the week value + holiday value).

[0089] For example, the week number can be 01 to 18, the day of the week can be A to G, and the period number can be 1 to 12. If a classroom is occupied during the first period on Wednesday of the first week, the corresponding first coordinate code can be recorded as 01C1; if a classroom is not occupied during the second period on Wednesday of the first week, the corresponding second coordinate code can be recorded as 01C2; and so on for other cases.

[0090] S4. Construct a second quadrant table corresponding to the time to be queried based on the quadrant table construction rules, and obtain and store the third coordinate code corresponding to the second quadrant table corresponding to the time to be queried based on the coordinate code generation rules.

[0091] In practical implementation, for example, if it is necessary to query the classroom occupancy status for the second period on Wednesday of the fifth week, the third coordinate code corresponding to the time to be queried can be recorded as 05C2 according to the quadrant table construction rules and coordinate code generation rules mentioned above.

[0092] S5. Based on the third coordinate code of the second quadrant table and the coordinate code of the first quadrant table of each shared educational resource, obtain the occupancy status of each shared educational resource at the time to be queried.

[0093] In practical implementation, the occupancy status of each shared educational resource at the time of query can be determined solely by the first coordinate code, including:

[0094] The third coordinate code of the second quadrant table is compared with all the first coordinate codes corresponding to each shared educational resource (that is, it is determined whether each shared educational resource has the same first coordinate code as the third coordinate code). If the same coordinate code exists, it means that the shared educational resource is occupied at the time of query and is therefore unavailable. Otherwise, it means that the shared educational resource is not occupied at the time of query and can be used as a available shared educational resource.

[0095] Furthermore, to further improve query efficiency, the first and second coordinate codes can be combined to obtain the occupancy status of each shared educational resource at the time of the query, including:

[0096] Determine whether the number of sessions occupied by each shared educational resource in a day exceeds half of the maximum number of sessions;

[0097] If less than half are available, it is determined whether each shared educational resource has a first coordinate code that is the same as the third coordinate code. If it does, it means that the shared educational resource was occupied during the query period and is therefore considered an unavailable shared educational resource. Otherwise, it means that the shared educational resource was not occupied during the query period and can be considered an available shared educational resource.

[0098] If more than half of the resources are in use, it is determined whether each shared educational resource has a second coordinate code that is the same as the third coordinate code. If it does, it means that the shared educational resource was not occupied at the time of the query and is therefore considered a usable shared educational resource (i.e., a classroom that was not occupied by two systems (undergraduate teaching system and graduate teaching system) at the same time). Otherwise, it means that the shared educational resource was occupied at the time of the query and is considered an unusable shared educational resource.

[0099] Effect verification experiment:

[0100] If the school has 515 classrooms and 12 classes per day, to find the classrooms that are not occupied during the 10th period of Monday in the first week of the current academic year, the original query method takes 0.047 seconds, while the method in this embodiment takes 0.016 seconds, based on the same hardware performance.

[0101] Example 2:

[0102] A shared educational resource retrieval system for multiple educational systems, the system comprising:

[0103] The shared educational resource library acquisition module is used to acquire information on the occupied shared educational resources of various educational systems and merge them to obtain a shared educational resource library.

[0104] The quadrant table acquisition module is used to obtain the first quadrant table corresponding to each shared educational resource in the shared educational resource library for each week based on the quadrant table construction rules; it is also used to construct the second quadrant table corresponding to the time to be queried based on the quadrant table construction rules.

[0105] The coordinate code generation module is used to obtain and store the first coordinate code and the second coordinate code corresponding to each of the first quadrant tables based on the coordinate code generation rules; it is also used to obtain and store the third coordinate code corresponding to the second quadrant table corresponding to the time to be queried based on the coordinate code generation rules.

[0106] The shared educational resource occupancy status judgment module obtains the occupancy status of each shared educational resource at the time to be queried based on the third coordinate code of the second quadrant table and the coordinate code of each shared educational resource in the first quadrant table.

[0107] It is understood that the shared educational resource query system for multiple educational systems provided in this embodiment of the invention corresponds to the shared educational resource query method for multiple educational systems described above. The explanations, examples, and beneficial effects of the relevant content can be referred to the corresponding content in the shared educational resource query method for multiple educational systems, and will not be repeated here.

[0108] It should be noted that, through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms. Based on this understanding, the above technical solutions, in essence or the parts that contribute to the prior art, can be embodied in the form of software products. These computer software products can be stored in computer-readable storage media, such as ROM / RAM, magnetic disks, optical disks, etc., and include several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in various embodiments or certain portions of the embodiments. In this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. In the absence of further restrictions, an element defined by the phrase "comprising a..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

[0109] The above embodiments are only used to illustrate the technical solutions of the present invention, and are not intended to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for querying shared educational resources across multiple educational systems, characterized in that, The method includes: Obtain information on the occupied shared educational resources of various education systems and merge them to obtain a shared educational resource database; Based on the quadrant table construction rules, obtain the first quadrant table corresponding to each shared educational resource in the shared educational resource library for each week; The first coordinate code and the second coordinate code corresponding to each of the first quadrant tables are obtained and stored based on the coordinate code generation rules; wherein, the coordinate code generation rules include: using the week number, row index value and column index value corresponding to the cell in the quadrant table that is a first state value as the first coordinate code; and using the week number, row index value and column index value corresponding to the cell in the quadrant table that is a second state value as the second coordinate code; Based on the quadrant table construction rules, a second quadrant table corresponding to the time to be queried is constructed, and based on the coordinate code generation rules, the third coordinate code corresponding to the second quadrant table corresponding to the time to be queried is obtained and stored. The occupancy status of each shared educational resource at the time of query is obtained based on the third coordinate code of the second quadrant table and the coordinate code of the first quadrant table of each shared educational resource.

2. The method for querying shared educational resources across multiple educational systems as described in claim 1, characterized in that, The shared educational resource database contains usage information for each shared educational resource in different weeks, days of the week, and periods.

3. The method for querying shared educational resources across multiple educational systems as described in claim 1, characterized in that, The quadrant table construction rules include: The column index in the quadrant table is from Monday to Sunday, and the row index is all sections. The values ​​of the cells in the quadrant table include a first state value and a second state value; The first status value indicates that the shared educational resource is occupied in the corresponding week, day of the week, and period; The second status value indicates that the shared educational resource is not occupied in the corresponding week, day of the week, or period.

4. The method for querying shared educational resources across multiple educational systems as described in claim 1, characterized in that, The process of obtaining the occupancy status of each shared educational resource at the time of query based on the third coordinate code of the second quadrant table and the coordinate codes of the first quadrant table of each shared educational resource includes: Determine whether the number of sessions occupied by each shared educational resource in a day exceeds half of the maximum number of sessions; If less than half, determine whether each shared educational resource has a first coordinate code that is the same as the third coordinate code. If it does, set the shared educational resource to be occupied at the time of query; otherwise, set the shared educational resource to be unoccupied at the time of query. If more than half are found, it is determined whether each shared educational resource has a second coordinate code that is the same as the third coordinate code. If it does, the shared educational resource is set to unoccupied status at the time of query; otherwise, the shared educational resource is set to occupied status at the time of query.

5. A shared educational resource query system for multiple educational systems, characterized in that, The system includes: The shared educational resource library acquisition module is used to acquire information on the occupied shared educational resources of various educational systems and merge them to obtain a shared educational resource library. The quadrant table acquisition module is used to obtain the first quadrant table corresponding to each shared educational resource in the shared educational resource library for each week based on the quadrant table construction rules; it is also used to construct the second quadrant table corresponding to the time to be queried based on the quadrant table construction rules. The coordinate code generation module is used to obtain and store the first coordinate code and the second coordinate code corresponding to each of the first quadrant tables based on the coordinate code generation rules; it is also used to obtain and store the third coordinate code corresponding to the second quadrant table corresponding to the time to be queried based on the coordinate code generation rules; wherein, the coordinate code generation rules include: using the week number, column index value, and row index value corresponding to the cell in the quadrant table that is a first state value as the first coordinate code; and using the week number, column index value, and row index value corresponding to the cell in the quadrant table that is a second state value as the second coordinate code; The shared educational resource occupancy status judgment module obtains the occupancy status of each shared educational resource at the time to be queried based on the third coordinate code of the second quadrant table and the coordinate code of each shared educational resource in the first quadrant table.

6. A shared educational resource query system for multiple educational systems as described in claim 5, characterized in that, The shared educational resource database contains usage information for each shared educational resource in different weeks, days of the week, and periods.

7. A shared educational resource query system for multiple educational systems as described in claim 5, characterized in that, The quadrant table construction rules include: The column index in the quadrant table is from Monday to Sunday, and the row index is all sections. The values ​​of the cells in the quadrant table include a first state value and a second state value; The first status value indicates that the shared educational resource is occupied in the corresponding week, day of the week, and period; The second status value indicates that the shared educational resource is not occupied in the corresponding week, day of the week, or period.

8. A shared educational resource query system for multiple educational systems as described in claim 5, characterized in that, The process of obtaining the occupancy status of each shared educational resource at the time of query based on the third coordinate code of the second quadrant table and the coordinate codes of the first quadrant table of each shared educational resource includes: Determine whether the number of sessions occupied by each shared educational resource in a day exceeds half of the maximum number of sessions; If less than half, determine whether each shared educational resource has a first coordinate code that is the same as the third coordinate code. If it does, set the shared educational resource to be occupied at the time of query; otherwise, set the shared educational resource to be unoccupied at the time of query. If more than half are found, it is determined whether each shared educational resource has a second coordinate code that is the same as the third coordinate code. If it does, the shared educational resource is set to unoccupied status at the time of query; otherwise, the shared educational resource is set to occupied status at the time of query.

Images