Comprehensive quality evaluation system data storage method and comprehensive quality evaluation system

Abstract

The invention discloses a comprehensive quality evaluation system data storage method and a comprehensive quality evaluation system, and belongs to the technical field of student comprehensive quality evaluation, and the method comprises the steps: taking student basic information as a table division basis, and executing table division operation; dynamically configuring a table division rule, and accurately routing the data to a target service table according to the rule by means of a dynamic router; according to the table division rule, service data tables needing table division processing are precisely screened, table division key fields are flexibly set, and meanwhile multiple table division mode selections are provided and comprise a Hash algorithm and field combinations; when a system operates a certain business data table, a preset table division configuration rule of the business table is automatically inquired, a target storage table of student business data is accurately calculated by a dynamic router according to the table division rule, and then various related business data operations are carried out. According to the method, the data storage and query speed can be remarkably improved, and a powerful guarantee is provided for efficient operation of the whole comprehensive quality evaluation system.

Description

Technical Field

[0001] The present invention relates to the technical field of student comprehensive quality evaluation, in particular to a comprehensive quality evaluation system data storage method and a comprehensive quality evaluation system. Background Art

[0002] Comprehensive quality evaluation aims to comprehensively demonstrate a student's moral, intellectual, physical, and aesthetic development. By constructing standardized comprehensive student quality profiles, we objectively and comprehensively record the student's significant achievements throughout their growth process, covering key areas such as their ideology and morality, academic level, physical and mental health, interests and specialties, and social practice. This serves as an important reference for graduation and further education.

[0003] Currently, the comprehensive quality evaluation system for students across all grades of primary, middle, and high schools in the province has a massive user base and involves a vast amount of student growth data. Against this backdrop, traditional data storage models have shown significant limitations and are unable to meet the demands for efficient storage and rapid query of massive amounts of student business data.

[0004] Current data storage designs use fixed table partitioning rules and lack flexible configuration capabilities. During the code writing phase, developers must predetermine the table partitioning rules for business tables and then strictly follow these rules to carry out coding work to achieve data partitioning. In this model, during the code implementation process, developers must not only pay close attention to the table partitioning rules applicable to specific business data, but also fully implement the table partitioning operations through code writing. However, in the actual development process, once it is discovered that the original table partitioning rules do not meet business needs, the existing coding logic must be overturned and development work must be restarted. This approach is seriously inflexible, greatly affecting development efficiency and the smooth progress of the project. Summary of the Invention

[0005] The technical task of the present invention is to address the above shortcomings and provide a comprehensive quality evaluation system data storage method and a comprehensive quality evaluation system, which can significantly improve the speed of data storage and query, and provide strong guarantees for the efficient operation of the entire comprehensive quality evaluation system.

[0006] The technical solution adopted by the present invention to solve its technical problem is:

[0007] A data storage method for a comprehensive quality evaluation system uses students' basic information as the basis for table division and performs table division operations;

[0008] Dynamically configure table partitioning rules and use dynamic routers to accurately route data to the target business table based on the rules;

[0009] The table sharding rules accurately screen business data tables that need to be sharded, flexibly set key fields for sharding (supporting multiple field combinations), and provide multiple table sharding options, including hash algorithms and field combinations;

[0010] When the system performs an operation on a business data table, it automatically queries the pre-set table configuration rules for the business table. The dynamic router accurately calculates the target storage table for student business data based on the table configuration rules, and then performs various related business data operations.

[0011] The dynamic router works closely with the business table partitioning configuration rules to dynamically and accurately route data to the designated business table, significantly improving the speed of data storage and query, and providing strong guarantees for the efficient operation of the entire comprehensive quality evaluation system.

[0012] Furthermore, when operating on a business data table, the values of the key fields of the shard table are dynamically obtained, and the shard table configuration rules of the corresponding business table are matched according to the key fields; then, the dynamic router uses its precise calculation capabilities to quickly and accurately determine the corresponding business table, thereby achieving efficient storage and convenient query of business data under the shard table architecture.

[0013] Furthermore, the table configuration rules support customized rules by time, by region, and by hash.

[0014] Furthermore, the implementation of the method includes the following steps:

[0015] Select business data tables: Estimate the business data volume and conduct in-depth analysis of the data's actual usage scenarios. Based on the analysis results, accurately select the business data tables that require sharding to ensure the pertinence and effectiveness of the sharding strategy.

[0016] Set key fields for shard tables: Select key fields for shard tables based on business needs. You can use a single field as a shard table identifier, or combine multiple fields to form a more complex and accurate shard table key identifier, providing strong support for classified storage and fast retrieval of data.

[0017] Determine the table sharding method: Select the appropriate table sharding method based on the key fields. Table sharding methods include hash algorithm-based table sharding and field combination-based table sharding.

[0018] Furthermore, the student basic information includes relatively stable fields such as year of enrollment, identity card number, and school ID.

[0019] Furthermore, the table partitioning method based on the hash algorithm determines the business table in which the data should be stored by performing hash calculation on the values of key fields, thereby achieving uniform distribution of data and improving storage efficiency.

[0020] Furthermore, the table partitioning method based on field combination combines the value of the key field with the table name when the table is not partitioned to generate a new business table as a carrier for data storage, thereby realizing classified management of data while retaining the original data structure characteristics.

[0021] The present invention also claims protection for a comprehensive quality evaluation system, including a business table sub-table configuration module and a dynamic router,

[0022] The business table sharding configuration module uses student basic information as the basis for sharding and performs sharding operations. It also configures sharding rules, accurately filters business data tables that require sharding, sets key fields for sharding (supports multiple field combinations), and provides multiple sharding methods including hash algorithms and field combinations.

[0023] The dynamic router dynamically and accurately routes data to the designated business table, accurately calculates the target storage table for student business data based on the table partitioning rules, and then performs various related business data operations;

[0024] The system specifically realizes the comprehensive quality evaluation of students through the above-mentioned method.

[0025] The present invention also claims protection for a data storage implementation device for a comprehensive quality evaluation system, comprising: at least one memory and at least one processor;

[0026] The at least one memory is configured to store a machine-readable program;

[0027] The at least one processor is configured to call the machine-readable program to implement the above method.

[0028] The present invention also claims protection for a computer-readable medium having computer instructions stored thereon, which are capable of implementing the above method when executed by a processor.

[0029] Compared with the prior art, the data storage method and comprehensive quality evaluation system of the present invention have the following beneficial effects:

[0030] This invention leverages key information fields such as the student's enrollment year, ID number, and school ID to more accurately and dynamically plan the routing of the service table. During data storage, the system can use this information to accurately determine the ownership of each piece of service data and accurately store it in the corresponding service table.

[0031] This invention successfully achieves efficient storage and convenient querying of business data in the table partitioning process. This not only improves data management efficiency, ensuring that data can be quickly located and stored within a massive database system, but also greatly optimizes the data query experience, allowing users to quickly receive responses when they need to access relevant data. This provides solid and powerful data support for the stable and efficient operation of the entire business system. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 This is a diagram illustrating the principle of a data storage method for a comprehensive quality evaluation system provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0033] This embodiment of the present invention provides a data storage method for a comprehensive quality assessment system. This method uses student basic information as the basis for table sharding and performs table sharding operations. It dynamically configures table sharding rules and, using a dynamic router, accurately routes data to target business tables based on these rules. When the system performs an operation on a business data table, it automatically queries the pre-set table sharding configuration rules for that business table. The dynamic router uses these table sharding rules to accurately calculate the target storage table for the student's business data, and then performs various related business data operations.

[0034] Combined with attachment Figure 1 As shown, this method analyzes the characteristics of students' basic information and then applies specific rules to manage and store business data in separate tables. Specifically, the table sharding operation is performed based on relatively stable fields such as the student's enrollment year, ID number, and school ID. This allows the system to accurately route student business data to the corresponding specific business table, ensuring orderly data storage.

[0035] Considering the complexity and diversity of business scenarios in actual applications, and to ensure the adaptability and flexibility of the system, the concept of dynamically configuring table partitioning rules is introduced. With the help of dynamic routers, data is accurately routed to the target business table based on these rules.

[0036] In order to better meet the differentiated needs of various business scenarios, a highly differentiated and customized table sharding rule system has been designed. Within this rule framework, it is possible to accurately screen business data tables that need to be sharded, flexibly set key fields for sharding (supporting multiple field combinations), and also provide a rich selection of sharding methods, such as hash algorithms, field combinations, etc. When the system performs an operation on a certain business table, it will automatically query the pre-set sharding configuration rules for the business table. The dynamic router will accurately calculate the target storage table for student business data based on these rules, and then smoothly carry out various related business data operations.

[0037] The dynamic router works closely with the business table partitioning configuration rules to dynamically and accurately route data to the designated business table, significantly improving the speed of data storage and query, and providing strong guarantees for the efficient operation of the entire comprehensive quality evaluation system.

[0038] The basic information of students includes key contents such as the year of enrollment, identity card number, school ID, etc., which constitute the core basis for data partitioning of this method. When operating the business data table, the system will dynamically obtain the value of the key field of the partition table, and use this as a clue to match the partition table configuration rules of the corresponding business table. Subsequently, the dynamic router exerts its precise calculation ability to quickly and accurately determine the corresponding business table, thereby realizing efficient storage and convenient query of business data under the partition table architecture. In the design of partition table rules, this method has a high degree of flexibility, and can freely set the business table, the key fields of the partition table, and the partition method, and realize the dynamic combination of the three. This design can not only meet the diverse needs of complex and large-scale data business scenarios, but also ensure that the system always maintains high performance in data storage and query.

[0039] The specific implementation steps of this method are as follows:

[0040] 1. Business Data Table Selection: First, estimate the business data volume and conduct an in-depth analysis of the data's actual usage scenarios. Based on these analysis results, accurately select the business data tables that require sharding to ensure the targeted and effective sharding strategy.

[0041] 2. Setting key fields for shard tables: Choose appropriate key fields for shard tables based on business needs. You can use a single field as a shard table identifier, or combine multiple fields to create a more complex and accurate shard table key identifier, providing strong support for classified storage and rapid retrieval of data.

[0042] 3. Determining the table partitioning method: This method provides two main table partitioning methods. The first is a hashing algorithm, which determines the business table where the data should be stored by performing a hash calculation on the values of key fields. This method can achieve uniform data distribution and improve storage efficiency. The second is a field combination method, which combines the values of key fields with the table name before partitioning to generate a new business table as the carrier for data storage. This method can achieve classified data management while retaining the original data structure characteristics.

[0043] Using fields such as the student's year of enrollment, identification number, and school ID as key criteria, we implement table sharding operations to store the student's comprehensive quality evaluation file information. By precisely selecting these representative and stable fields, we can effectively distinguish between different students' data, providing a reliable foundation for table sharding operations. With the help of a dynamic routing mechanism, we can intelligently and accurately store student comprehensive quality evaluation file information in the corresponding business tables based on these key criteria. This not only improves the accuracy and efficiency of data storage, but also allows for the rapid location of required information during subsequent data queries and calls, effectively ensuring the data processing capabilities of the entire comprehensive quality evaluation system and effectively meeting the system's needs in actual application scenarios.

[0044] Traditional data storage designs struggle to adapt to complex business data storage scenarios. Under this design, the system can only perform table sharding operations according to predefined, fixed rules, which are rigidly set in the code and lack flexibility. For systems with complex business operations, different business tables often require data storage and querying from different dimensions. If all business tables were subject to the same sharding rules, the system would not be able to fully support complex and diverse business scenarios. Furthermore, developers must constantly monitor and implement the sharding logic during the coding process, which undoubtedly increases the development burden. This approach significantly improves this situation by leveraging the dynamic routing rule configuration feature. Developers no longer need to worry about sharding logic during coding; they simply configure the corresponding settings in the configuration table. The system then uses dynamic routing, combined with the sharding rules, to automatically implement sharding and querying business data. This feature significantly improves development efficiency and effectively avoids rework. Furthermore, developers can flexibly configure differentiated business rules for precise table sharding, tailored to different business scenarios, making the system more capable of handling complex business needs.

[0045] Traditional data storage designs struggle to adapt to complex business data storage scenarios. Under this design, the system can only perform table sharding operations according to established, fixed rules, which are rigidly set in the code, lacking flexibility. For systems with complex business operations, different business tables often require data storage and querying from different dimensions. If all business tables were subject to the same sharding rules, the system would not be able to fully support complex and diverse business scenarios. Furthermore, during the development process, developers must constantly monitor the details of the sharding logic and manually implement sharding operations through code. This undoubtedly increases the complexity and workload of development, significantly increasing the burden on developers. Furthermore, if business requirements change and the existing sharding rules no longer meet the new requirements, developers may need to modify or even rewrite a large amount of code, which is not only time-consuming and labor-intensive but also prone to introducing new errors, impacting the overall progress and quality of the project. The dynamic routing rule configuration feature introduced in this method provides an effective solution to this problem. This feature eliminates the need for developers to expend significant effort on complex sharding logic during the coding process. They only need to make simple settings in the configuration table, and the system will use dynamic routers, combined with pre-set sharding rules, to automatically and accurately implement sharding storage and query operations for business data. This innovative feature not only significantly improves development efficiency, allowing developers to devote more energy to the implementation of core business logic, but also greatly reduces the rework caused by changes in sharding rules. In addition, for different business scenarios, developers can flexibly configure differentiated business rules according to actual needs to achieve precise sharding. This enables the system to respond more flexibly and efficiently when faced with complex and changing business needs, easily cope with various challenges, and ensure the stability and scalability of the system.

[0046] An embodiment of the present invention further provides a comprehensive quality evaluation system, which specifically implements student comprehensive quality evaluation through the comprehensive quality evaluation system data storage method described in the above embodiment.

[0047] The system includes a business table sub-table configuration module and a dynamic router.

[0048] The business table sharding configuration module uses student basic information as the basis for sharding and performs sharding operations. It also configures sharding rules, accurately filters business data tables that require sharding, sets key fields for sharding (supports multiple field combinations), and provides multiple sharding methods including hash algorithms and field combinations.

[0049] The dynamic router dynamically and accurately routes data to the designated business table, accurately calculates the target storage table for student business data based on the table partitioning rules, and then performs various related business data operations;

[0050] In this comprehensive quality evaluation system based on a dynamic routing mechanism, fields such as a student's enrollment year, ID number, and school ID are used as key criteria to implement table partitioning, thereby achieving the storage of student comprehensive quality evaluation file information. This is a practical and highly targeted implementation method adopted by the system in the specific execution of the data storage process.

[0051] This approach effectively distinguishes data from different students by precisely selecting these representative and stable fields, providing a reliable foundation for table partitioning. Leveraging a dynamic routing mechanism, the system can intelligently and accurately store student comprehensive quality evaluation profile information in the corresponding business tables based on these key criteria. This not only improves the accuracy and efficiency of data storage, but also allows for the rapid location of required information during subsequent data queries and calls, effectively safeguarding the data processing capabilities of the entire comprehensive quality evaluation system and effectively meeting the system's needs in practical application scenarios.

[0052] The specific steps to implement the system include:

[0053] 1. Business Data Table Selection: First, estimate the business data volume and conduct an in-depth analysis of the data's actual usage scenarios. Based on these analysis results, accurately select the business data tables that require sharding to ensure the targeted and effective sharding strategy.

[0054] 2. Setting key fields for shard tables: Choose appropriate key fields for shard tables based on business needs. You can use a single field as a shard table identifier, or combine multiple fields to create a more complex and accurate shard table key identifier, providing strong support for classified storage and rapid retrieval of data.

[0055] 3. Determining the table partitioning method: This method provides two main table partitioning methods. The first is a hashing algorithm, which determines the business table where the data should be stored by performing a hash calculation on the values of key fields. This method can achieve uniform data distribution and improve storage efficiency. The second is a field combination method, which combines the values of key fields with the table name before partitioning to generate a new business table as the carrier for data storage. This method can achieve classified data management while retaining the original data structure characteristics.

[0056] The data storage method for the comprehensive quality evaluation system, based on a dynamic routing mechanism, possesses distinct technical characteristics. Its core advantage lies in the flexible and dynamic configuration of business tables, key fields in shard tables, and sharding methods. This flexible configuration is not simply a functional setting, but an innovative design that deeply meets the needs of complex business scenarios. This feature overcomes the limitations of traditional data storage models and achieves efficient data storage and query. During data storage, it accurately places data in the corresponding storage location based on the characteristics of different business tables, the diverse combinations of key fields in shard tables, and the appropriate sharding methods, improving storage efficiency and accuracy. During data querying, it quickly locates and retrieves required data, significantly reducing query response time. This efficient data processing capability ensures the comprehensive quality evaluation system's exceptional responsiveness. Whether facing concurrent large-scale data storage requests or complex multi-condition data query scenarios, the system can respond quickly and stably, fully meeting the efficient data processing requirements of complex business scenarios and providing solid technical support for the stable operation and functional expansion of the comprehensive quality evaluation system in education business systems.

[0057] An embodiment of the present invention further provides a data storage implementation device for a comprehensive quality evaluation system, comprising: at least one memory and at least one processor;

[0058] The at least one memory is configured to store a machine-readable program;

[0059] The at least one processor is used to call the machine-readable program to implement the comprehensive quality evaluation system data storage method described in the above embodiment.

[0060] An embodiment of the present invention further provides a computer-readable medium having computer instructions stored thereon. When executed by a processor, the computer instructions cause the processor to execute the comprehensive quality evaluation system data storage method described in the above embodiments. Specifically, a system or device equipped with a storage medium can be provided. The storage medium stores software program code that implements the functions of any of the above embodiments, and causes a computer (or CPU or MPU) of the system or device to read and execute the program code stored in the storage medium.

[0061] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute part of the present invention.

[0062] Examples of storage media for providing program code include floppy disks, hard disks, magneto-optical disks, optical disks (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RAM, DVD-RW, DVD+RW), magnetic tapes, non-volatile memory cards, and ROMs. Alternatively, the program code can be downloaded from a server computer via a communication network.

[0063] In addition, it should be clear that the functions of any of the above embodiments can be achieved not only by executing the program code read by the computer, but also by enabling the operating system operating on the computer to complete part or all of the actual operations based on the instructions of the program code.

[0064] In addition, it can be understood that the program code read from the storage medium is written into the memory provided in the expansion board inserted into the computer or into the memory provided in the expansion unit connected to the computer, and then based on the instructions of the program code, the CPU installed on the expansion board or expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above embodiments.

[0065] The present invention has been shown and described in detail above through the accompanying drawings and preferred embodiments. However, the present invention is not limited to these disclosed embodiments. Based on the above multiple embodiments, those skilled in the art can know that the code review methods in the above different embodiments can be combined to obtain more embodiments of the present invention, and these embodiments are also within the scope of protection of the present invention.

Claims

1. A data storage method for a comprehensive quality evaluation system, characterized in that: Use students' basic information as the basis for table division and perform table division operations; Dynamically configure table partitioning rules and use dynamic routers to accurately route data to the target business table based on the rules; The table sharding rules accurately screen business data tables that need to be sharded, flexibly set key fields for sharding, and provide multiple table sharding options, including hash algorithms and field combinations; When the system performs an operation on a business data table, it automatically queries the pre-set table configuration rules for the business table. The dynamic router accurately calculates the target storage table for student business data based on the table configuration rules, and then performs various related business data operations.

2. A comprehensive quality evaluation system data storage method according to claim 1, characterized in that: When operating on a business data table, the values of the key fields of the shard table are dynamically obtained, and the shard table configuration rules of the corresponding business table are matched based on the key fields. Then, the dynamic router uses its precise calculation capabilities to quickly and accurately determine the corresponding business table, thereby achieving efficient storage and convenient query of business data under the shard table architecture.

3. The data storage method of a comprehensive quality evaluation system according to claim 1 is characterized in that: The table sharding configuration rules support custom rules by time, by region, and by hash.

4. A comprehensive quality evaluation system data storage method according to claim 1, 2 or 3, characterized in that: The implementation of this method includes the following steps: Select business data tables: Estimate the business data volume and conduct in-depth analysis of the data's actual usage scenarios. Based on the analysis results, accurately select the business data tables that require sharding to ensure the pertinence and effectiveness of the sharding strategy. Set key fields for sharding tables: Select key fields for sharding tables based on business needs. You can use a single field as a sharding table identifier, or combine multiple fields. Determine the table sharding method: Select the appropriate table sharding method based on the key fields. Table sharding methods include hash algorithm-based table sharding and field combination-based table sharding.

5. The data storage method of a comprehensive quality evaluation system according to claim 1 is characterized in that: The student basic information includes the year of enrollment, identity card number, and school ID fields.

6. A data storage method for a comprehensive quality evaluation system according to claim 1 or 4, characterized in that: The table partitioning method based on the hash algorithm determines the business table where the data should be stored by performing hash calculation on the values of key fields, thereby achieving uniform distribution of data.

7. A comprehensive quality evaluation system data storage method according to claim 1 or 4, characterized in that: The table partitioning method based on field combination combines the value of the key field with the table name before the table is partitioned to generate a new business table as a carrier for data storage, thereby realizing classified management of data while retaining the original data structure characteristics.

8. A comprehensive quality evaluation system, characterized in that: Including business table sub-table configuration module and dynamic router, The business table sharding configuration module uses student basic information as the basis for sharding and performs sharding operations. It also configures sharding rules, accurately screens business data tables that require sharding, sets key fields for sharding, and provides multiple sharding methods, including hash algorithms and field combinations. The dynamic router accurately calculates the target storage table of the student business data according to the table partitioning rules, and then performs various related business data operations; The system specifically implements the comprehensive quality evaluation of students through the method described in any one of claims 1 to 7.

9. A data storage implementation device for a comprehensive quality evaluation system, characterized in that: include: at least one memory and at least one processor; The at least one memory is configured to store a machine-readable program; The at least one processor is configured to call the machine-readable program to implement the method according to any one of claims 1 to 7.

10. A computer-readable medium, characterized in that The computer readable medium stores computer instructions, which, when executed by a processor, can implement the method according to any one of claims 1 to 7.

Images