A database-based digital textbook course data consistency checking method

Abstract

The application relates to the technical field of digital teaching material data processing, and discloses a digital teaching material course data consistency checking method based on a database. The records of courses, units, sections, pages, content blocks, resources, exercises, teaching targets and knowledge points in the digital teaching material are uniformly included in a checking process, checking results of single course units and courses are formed through record classification, parent record checking, structure coordinate generation, target anchor point analysis, mounting relationship judgment, boundary comparison, offset analysis and abnormality classification, problems that traditional checking cannot reflect the real structure position of course units, inconsistency between target pointing and content mounting, missing judgment basis for wrong and multiple mounting and cross-border mounting are solved, and abnormality categories and recommended positioning nodes are provided, so that checking and repairing are facilitated.

Description

Technical Field

[0001] This invention relates to the field of digital textbook data processing technology, specifically a database-based method for verifying the consistency of digital textbook course data. Background Technology

[0002] With the widespread application of digital textbooks in basic education, higher education, and vocational education, textbook content has gradually expanded from single text pages to structured course databases containing various data objects such as courses, units, sections, pages, content blocks, exercises, learning objectives, and knowledge points. Digital textbook course data is typically stored in relational databases, document databases, or hybrid course resource management systems. Various data objects form a complete course structure through parent-child hierarchical relationships, attachment relationships, target association relationships, and resource reference relationships.

[0003] In existing technologies, consistency verification of digital textbook course data typically employs methods such as field integrity checks, foreign key constraint checks, manual review, tree structure traversal, and resource link validity checks. Field integrity checks primarily determine if necessary fields are empty; foreign key constraint checks primarily determine if associated numbers exist; tree structure traversal primarily determines if the hierarchical relationships between courses, units, sections, and pages are broken; and resource link validity checks primarily determine if resource file paths or network addresses are accessible. These methods can detect some explicit errors, such as missing records, non-existent parent nodes, invalid resource links, and non-compliant field formats. However, digital textbook course data faces more complex structural consistency issues during actual maintenance. For example, the same lesson element may be mounted to multiple pages simultaneously; content blocks may be incorrectly mounted to pages that do not belong to their course's parent domain; resource records may have valid parent records but their actual display location deviates from the corresponding chapter in the teaching objectives; and exercises may be related to knowledge points but the database mounting node is in the wrong section. Such problems may all present valid values ​​at the field level and corresponding records may all be found at the foreign key level, making them difficult to identify with existing field and foreign key checks.

[0004] Therefore, this case aims to propose a database-based method for verifying the consistency of digital textbook course data. First, the course structure records, target class records, and course element records stored in the database are uniformly transformed into comparable, traceable, and measurable hierarchical coordinate objects. Then, through multi-dimensional information such as parent record validity, root path structure, target anchor point, mounting relationship, effective parent domain boundary, coordinate offset, and anomaly type label, the method automatically verifies whether the content blocks, resources, and exercises in the digital textbook are in reasonable course positions. Summary of the Invention

[0005] This invention provides a database-based method for verifying the consistency of digital textbook course data, thereby helping to solve the problems mentioned in the background section.

[0006] This invention provides the following technical solution: a database-based method for verifying the consistency of digital textbook course data, comprising:

[0007] The system reads course, unit, section, page, content block, resource, exercise, teaching objective, and knowledge point records from the digital textbook course database. It establishes record numbers, record type numbers, and coordinate axis affiliations, and divides the records into subject element records to be verified and target class records. A virtual calculation root record number and a four-dimensional subject element coordinate system are established. Parent records are verified, and a parent record validity flag and valid parent record number are generated. A set of first-order records at the same level is generated based on the sorting field and unique number field, and then the parent-axis order is statistically analyzed. The root path and subdomains are extracted along the valid parent record number, and the four-dimensional subject element structure coordinates are generated based on the end-bearing node number of each coordinate axis in the root path. The system reads the target anchor point association table and the subject element-target association table, filters the candidate record number set for target anchor points, generates target anchor point record numbers, and generates the target anchor point record number through coordinate component averaging and coordinate component synthesis. The system retrieves the core coordinates and the required coordinates of each lesson element; it reads the lesson element mounting association table and performs target filtering, quantity statistics, legality comparison, coordinate mapping, and subdomain boundary construction to generate mounting availability flags, actual mounting coordinates, effective lower bound of the parent domain, and effective upper bound of the parent domain; it compares the actual mounting coordinates with the effective lower bound and effective upper bound of the parent domain, calculates the coordinate difference, and performs grid conversion to generate effective parent domain boundary consistency value, coordinate axis offset, total lesson element offset, and parent domain grid tolerance; based on the parent record legality flag, effective parent domain boundary consistency value, total lesson element offset, and parent domain grid tolerance, it generates consistency anomaly flags, anomaly type labels, recommended positioning node numbers, and single lesson element verification results; it collects all single lesson element verification results to form a course-level verification result set, filters to form an anomaly result set, and counts and outputs the number of passed verifications and the number of anomalies.

[0008] Optionally, the step of reading course, unit, section, page, content block, resource, exercise, teaching objective, and knowledge point records from the digital textbook course database, establishing record numbers, record type numbers, and coordinate axis assignment values, and dividing the records of the course elements to be verified into target class records, specifically includes:

[0009] The system reads nine categories of records from a single-course digital textbook database: course, unit, section, page, content block, resource, exercise, learning objective, and knowledge point. A record number is created for each read record. A set of record numbers is constructed based on all database records participating in the verification, and the total number of records is counted. For each database record, the record type number is read, and course records, unit records, section records, page records, content block records, resource records, exercise records, learning objective records, and knowledge point records are mapped to their corresponding record type numbers, forming a set of record type numbers. For each database record, based on the record type... The model number mapping generates coordinate axis assignment values; course records, teaching objective records, and knowledge point records generate coordinate axis assignment values ​​that do not participate in the four-dimensional lesson element coordinate axis occupancy; unit records generate coordinate axis assignment values ​​that occupy the unit axis; section records generate coordinate axis assignment values ​​that occupy the section axis; page records generate coordinate axis assignment values ​​that occupy the page axis; content block records, resource records, and exercise records generate coordinate axis assignment values ​​that occupy the lesson element slot axis; the sets are classified according to record type, and content block records, resource records, and exercise records are classified into a set of lesson element records to be verified, and teaching objective records and knowledge point records are classified into a set of target class records.

[0010] Optionally, the steps of establishing a virtual calculation root record number and a four-dimensional element coordinate system, verifying the declared parent record, generating a parent record validity flag and a valid parent record number, generating a set of first-order records at the same level according to the sorting field and the unique number field, and then statistically forming a co-axial positional order of the same parent, specifically include:

[0011] A virtual computing root record number of zero is established. This virtual computing root record number is then merged with the record numbers of the database records participating in the verification, forming an extended record number set. Extended type values ​​and extended coordinate axis attribution values ​​are established for each extended record number. For extended record numbers belonging to database records, extended type values ​​and extended coordinate axis attribution values ​​are generated by mapping the corresponding database record's record type number and coordinate axis attribution value. The virtual computing root record number generates extended type values ​​and extended coordinate axis attribution values ​​with a value of zero. For each database record, the parent record number is declared. When the declared parent record number belongs to the record number set, is different from the current database record's record number, or corresponds to an extended record, the parent record number is declared. When the type value corresponds to a course record, unit record, section record, or page record type, and the extended coordinate axis attribute value of the parent record number is declared to be less than the coordinate axis attribute value of the current database record, the generated parent record valid flag is a valid flag. When the parent record number is declared not to belong to the record number set, the generated parent record valid flag is an invalid flag. When the parent record number is declared to belong to the record number set, and satisfies the following conditions: the parent record number is the same as the record number of the current database record; the extended type value of the parent record number does not correspond to a course record, unit record, section record, or page record type; and the extended coordinate axis attribute value of the parent record number is not less than the coordinate axis attribute value of the current database record. Under any condition, the parent record validity flag is invalid; a valid parent record number mapping is performed based on the parent record validity flag; when the parent record validity flag is valid, a valid parent record number is generated by mapping the declared parent record number; when the parent record validity flag is invalid, a valid parent record number is generated by mapping the virtual computation root record number; the four-dimensional lesson element structure coordinates corresponding to the virtual computation root record number are set as the origin of the four-dimensional lesson element coordinate system, and a four-dimensional lesson element coordinate system composed of unit axis, section axis, page axis, and lesson element slot axis is established; the unit axis, section axis, and page axis are respectively positive in the increasing direction of the corresponding sorting field, and the lesson element slot axis is sorted according to the sorting word of the content block, resource, and exercise with the same valid parent record number. The increasing direction of the segments is positive, and all four coordinate axes use dimensionless normalized positional values. For any two database records, the sorting field and unique number field are read. One of the two database records is taken as the current database record, and the other is taken as the comparison record. A peer-to-peer comparison is performed based on the sorting field and unique number field. When the sorting field of the comparison record is less than the sorting field of the current database record, or when the sorting fields are the same and the unique number field of the comparison record is less than the unique number field of the current database record, a peer-to-peer judgment result of the comparison record relative to the current database record is generated, and the comparison record that satisfies the peer-to-peer judgment result is included in the peer-to-peer record set of the current database record.For each extended record number and each coordinate axis, the database records involved in the verification are treated as child records. The number of child records whose valid parent record number equals the currently enumerated extended record number and whose coordinate axis affiliation corresponds to the currently enumerated coordinate axis is counted, forming the number of records with the same parent and coordinate axis affiliation for the currently enumerated extended record number and the currently enumerated coordinate axis. For each database record, the number of records with the same valid parent record number and the same coordinate axis affiliation as the current database record, and belonging to the same-level predecessor record set of the current database record, is counted, and this count is incremented by one to form the parent and coordinate axis affiliation order of the current database record.

[0012] Optionally, the step of extracting the root path and subdomains along the valid parent record number, and generating four-dimensional element structure coordinates based on the end-bearing node numbers of each coordinate axis in the root path, specifically includes:

[0013] For each database record, starting from the record number of the current database record, trace back level by level along the valid parent record number to the virtual computing root record number. Then, arrange the path node numbers in the direction from the virtual computing root record number to the record number of the current database record to form the root path of the current database record. Set any extended record number as the subdomain root record number. Based on the root path inclusion relationship, gather all database records that contain the current subdomain root record number to construct the subdomain of the current subdomain root record number. When the current subdomain root record number is the virtual computing root record number, the subdomain contains all database records. For the root path of each database record, filter the end-bearing node numbers based on the extended coordinate axis attribution value corresponding to the path node number, and take the path node number being checked as the target path node number. When the extended coordinate axis attribution value corresponding to the target path node number corresponds to the current enumerated coordinate axis, and there is no path node number in the root path that is after the target path node number and whose extended coordinate axis attribution value corresponds to the current enumerated coordinate axis, generate the end-bearing node number of the current enumerated coordinate axis. For each database record and each For each coordinate axis, when the root path contains the end-carrying node number of the currently enumerated coordinate axis, a normalized positional conversion is performed based on the parent-child coaxial positional order of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis formed in the previous order, and the number of parent-child coaxial records when the effective parent record number of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis is used as the extended record number of the current enumeration, and the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis. The parent-child coaxial positional order of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis is then divided by the previously formed normalized positional order. The structural coordinate components of the current enumerated coordinate axis are calculated by taking the valid parent record number of the record corresponding to the end bearing node number of the current enumerated coordinate axis as the current enumerated extended record number, and the number of records with the same parent and coaxiality when the coordinate axis belonging value of the child record corresponds to the current enumerated coordinate axis plus one. When there is no end bearing node number of the current enumerated coordinate axis in the root path, the structural coordinate components of the current enumerated coordinate axis are set to zero. The structural coordinate components are combined in the order of unit axis, section axis, page axis and lesson element slot axis to generate the four-dimensional lesson element structural coordinates of the current database record.

[0014] Optionally, the step of reading the target anchor point association table and the lesson element-target association table, filtering the candidate record number set of target anchor points, generating target anchor point record numbers, and generating the target anchor point center coordinates and the lesson element's corresponding coordinates through coordinate component averaging and coordinate component synthesis specifically includes:

[0015] For each target class record, read the target anchor point association table. Based on the target anchor point association table, perform association filtering and coordinate axis attribution filtering. Among the database records that have an association relationship with the current target class record, filter the database records whose coordinate axis attribution values ​​correspond to the unit axis, section axis, page axis, or lesson element slot axis, forming a set of candidate target anchor point record numbers for the current target class record. For each target class record, read the declared parent record number. When the declared parent record number belongs to the record number set and the extended coordinate axis attribution value of the record corresponding to the declared parent record number corresponds to the unit axis, section axis, page axis, or lesson element... When generating a slot axis, the target parent anchor point of the current target class record is marked as available; when the parent record number is declared not to belong to the record number set, the target parent anchor point of the current target class record is marked as unavailable; when the parent record number is declared to belong to the record number set and the extended coordinate axis belonging value of the record corresponding to the parent record number does not correspond to the unit axis, section axis, page axis, or lesson slot axis, the target parent anchor point of the current target class record is marked as unavailable; when the target anchor point candidate record number set of the current target class record is not empty, the record in the target anchor point candidate record number set of the current target class record is used. The record numbers are compared to their minimum values, and the record number with the smallest value is used as the target anchor record number for the current target class record. If the set of candidate target anchor record numbers for the current target class record is empty and the target parent anchor point availability flag for the current target class record is set to available, the target anchor record number for the current target class record is generated based on the declared parent record number. If the set of candidate target anchor record numbers for the current target class record is empty and the target parent anchor point availability flag for the current target class record is set to unavailable, the target anchor record number for the current target class record is generated based on the virtual computation root record number. For each lesson element record to be verified, the lesson element and target association table is read. Based on the lesson element and target association table, the record numbers of teaching target records and knowledge point records that are related to the record number of the current lesson element record to be verified are filtered to form a set of lesson element associated target record numbers of the current lesson element record to be verified, and the number of lesson element associated target record numbers of the current lesson element record to be verified is counted. When the number of lesson element associated target record numbers of the current lesson element record to be verified is zero, the four-dimensional lesson element structure coordinates corresponding to the effective parent record number of the current lesson element record to be verified are inherited as the target anchor point center coordinates of the current lesson element record to be verified.When the number of associated target record numbers of the current subject element record to be verified is greater than zero, based on the four-dimensional subject element structure coordinates corresponding to the target anchor point record numbers of the target class records corresponding to the target element associated target record numbers in the previously generated set of associated target record numbers of the current subject element record to be verified, the structural coordinate components of each coordinate axis are summed, and then the summation value of each coordinate axis is divided by the number of associated target record numbers of the current subject element record to be verified to generate the target anchor point center coordinates of the current subject element record to be verified; for each subject element record to be verified, the four-dimensional subject element structure coordinates corresponding to the effective parent record number of the current subject element record to be verified and the target anchor point center coordinates of the current subject element record to be verified are equally divided according to the coordinate axis components and combined. The components of the two coordinates on each coordinate axis are added together and then half is taken to generate the subject element position coordinates of the current subject element record to be verified.

[0016] Optionally, the step of reading the course element mounting association table and performing mounting target filtering, quantity statistics, legality comparison, coordinate mapping, and subdomain boundary construction to generate mounting availability flags, actual mounting coordinates, effective parent domain lower bound, and effective parent domain upper bound specifically includes:

[0017] For each course element record to be verified, the course element mounting association table is read. Based on all mounting target numbers in the course element mounting association table that have a row relationship with the record number of the current course element record to be verified, as well as the row-level membership relationships, a multiset of original mounting target numbers for the current course element record to be verified is constructed. From the multiset of original mounting target numbers for the current course element record to be verified, mounting target numbers that belong to the record number set, are different from the record number of the current course element record to be verified, and whose coordinate axis assignment value corresponds to the page axis or course element slot axis are selected to form a set of non-self actual mounted record numbers for the current course element record to be verified. The non-self actual mounted record numbers for the current course element record are counted. The system checks the number of record numbers. Based on the course element mounting association table, it performs an existence check on row-level associations where both the course element record number and the mounting target number are the record numbers of the current course element record to be verified. When a row-level association record exists in the course element mounting association table where both the course element record number and the mounting target number are the record numbers of the current course element record to be verified, an existence flag is generated for the current course element record to be verified, and the count value of the self-mounting flag of the current course element record to be verified is set to one. When a row-level association record does not exist in the course element mounting association table where both the course element record number and the mounting target number are the record numbers of the current course element record to be verified, an existence flag is generated for the current course element record to be verified, and the count value of the self-mounting flag of the current course element record to be verified is set to one. The count value of the self-mounting flag is set to zero; the number of elements in the multiset of the original mounted target number of the current subject element record to be verified is compared with the sum of the number of non-self actual mounted record numbers of the current subject element record to be verified and the count value of the self-mounting flag of the current subject element record; if the number of elements in the multiset of the original mounted target number of the current subject element record to be verified is greater than the sum of the count value of the non-self actual mounted record numbers of the current subject element record to be verified and the count value of the self-mounting flag of the current subject element record to be verified, an illegal mounting flag is generated for the current subject element record to be verified as an illegal identifier; if the number of elements in the multiset of the original mounted target number of the current subject element record to be verified is not greater than the number of non-self actual mounted record numbers of the current subject element record to be verified. When the sum of the count values ​​of the current subject element record's own mounting flag and the current subject element record's own mounting flag is reached, an illegal mounting flag for the current subject element record is generated as a valid flag. When the illegal mounting flag for the current subject element record is a valid flag, the current subject element record's own mounting flag is a non-existent flag, and the number of non-self-mounted actual record numbers for the current subject element record is one, an available mounting flag for the current subject element record is generated as an available flag. When the illegal mounting flag for the current subject element record is an illegal flag, or the current subject element record's own mounting flag is an existing flag, or the number of non-self-mounted actual record numbers for the current subject element record is not one, an unavailable mounting flag for the current subject element record is generated.When the number of non-self-attached record numbers of the current subject element record to be verified is greater than zero, the minimum value of the record numbers in the set of non-self-attached record numbers of the current subject element record to be verified is compared, and the record number with the smallest record number is generated as the actual mounting base point number of the current subject element record to be verified; when the number of non-self-attached record numbers of the current subject element record to be verified is zero, the actual mounting base point number of the current subject element record to be verified is generated based on the virtual calculation root record number; the actual mounting coordinate mapping is performed based on the mounting availability flag of the current subject element record to be verified; when the mounting availability flag of the current subject element record to be verified is an available flag, the four-dimensional subject element structure coordinates of the record corresponding to the actual mounting base point number of the current subject element record to be verified are mapped to the actual mounting coordinates of the current subject element record to be verified; when the mounting availability flag of the current subject element record to be verified is an unavailable flag, the valid... The four-dimensional structural coordinates corresponding to the parent record number are mapped to the actual mounting coordinates of the current subject element record to be verified. Based on the subdomain formed by using the effective parent record number of the current subject element record as the root record number of the subdomain, an effective parent domain for the current subject element record to be verified is constructed. Boundary construction is performed based on the structural coordinate components of each database record within the effective parent domain of the current subject element record on each coordinate axis. For each coordinate axis, the coordinate axis currently undergoing boundary construction is used as the current enumerated coordinate axis. The minimum value among the structural coordinate components of each database record within the effective parent domain of the current subject element record on the current enumerated coordinate axis is taken as the lower bound of the effective parent domain of the current subject element record on the current enumerated coordinate axis, and the maximum value among the structural coordinate components of each database record within the effective parent domain of the current subject element record on the current enumerated coordinate axis is taken as the upper bound of the effective parent domain of the current subject element record on the current enumerated coordinate axis.

[0018] Optionally, the step of comparing the actual mounted coordinates with the lower and upper bounds of the effective parent domain, calculating the coordinate difference, and converting the grid distance to generate the effective parent domain boundary consistency value, coordinate axis offset, total element offset, and parent domain grid distance tolerance specifically includes:

[0019] Based on the mounting availability flag of the current course element record to be verified, the actual mounting coordinates of the current course element record to be verified, and the lower and upper bounds of the effective parent domain of the current course element record to be verified on each coordinate axis, a boundary consistency comparison is performed. If the mounting availability flag of the current course element record to be verified is "available," and the components of the actual mounting coordinates of the current course element record to be verified on each coordinate axis are all located between the lower and upper bounds of the effective parent domain of the current course element record to be verified on the same coordinate axis, a consistency value for the effective parent domain boundary of the current course element record to be verified is generated; otherwise, an inconsistency value for the effective parent domain boundary consistency of the current course element record to be verified is generated. For each course element record to be verified... For each coordinate axis, when the mounting availability flag of the current subject element record to be verified is "available," the component of the actual mounting coordinate of the current subject element record on the current enumerated coordinate axis is subtracted from the component of the subject element's proper location coordinate on the current enumerated coordinate axis to calculate the coordinate axis offset of the current subject element record on the current enumerated coordinate axis. When the mounting availability flag of the current subject element record to be verified is "unavailable," the coordinate axis offset of the current subject element record on the current enumerated coordinate axis is set to one. For each subject element record to be verified, the coordinate axis offsets of the current subject element record on the unit axis, section axis, page axis, and subject element slot axis are added together, divided by four, and averaged to form the total subject element offset of the current subject element record. Offset; For each lesson element record to be verified and each coordinate axis, compare the upper bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis with the lower bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis; when the upper bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis is greater than the lower bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis, generate an active indicator of the parent domain of the current lesson element record to be verified on the current enumerated coordinate axis as an active flag; when the upper bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis is not greater than the lower bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis, generate an inactive indicator of the parent domain of the current lesson element record to be verified on the current enumerated coordinate axis; For each lesson element record to be verified and each coordinate axis, the grid spacing is converted based on the number of records with the same parent and axis when the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis, which is formed by the previous statistics. When the activity indicator of the parent domain of the current lesson element record to be verified is an activity identifier, the number of records with the same parent and axis when the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis is increased by one to form the denominator of the grid spacing conversion. Then, two is divided by the denominator of the grid spacing conversion to convert and form the single-axis grid spacing allowance of the current lesson element record to be verified on the current enumerated coordinate axis.When the activity indicator of the parent domain of the current subject element record to be verified on the current enumerated coordinate axis is an inactive flag, the single-axis grid tolerance of the current subject element record on the current enumerated coordinate axis is set to zero; the single-axis grid tolerances of the current subject element record on the four coordinate axes are added together, divided by four, and averaged to form the parent domain grid tolerance of the current subject element record.

[0020] Optionally, the step of generating a consistency anomaly flag, anomaly type label, recommended location node number, and single-subject-element verification result based on the parent record's legality flag, valid parent domain boundary consistency value, total subject offset, and parent domain grid spacing tolerance specifically includes:

[0021] For each lesson element record to be verified, anomaly combination judgment is performed based on the parent record validity flag, the valid parent domain boundary consistency value, the total lesson element offset, and the parent domain grid spacing tolerance of the current lesson element record. If the parent record validity flag is valid, the valid parent domain boundary consistency value is consistent, and the total lesson element offset is not greater than the parent domain grid spacing tolerance, a consistency anomaly flag of the current lesson element record is generated as a pass flag; otherwise, an consistency anomaly flag of the current lesson element record is generated as an anomaly flag. When the consistency anomaly flag of the current subject element record to be verified is "passed," the anomaly type label for the current subject element record to be verified is "no anomaly." When the consistency anomaly flag of the current subject element record to be verified is "anomaly flag" and the parent record's valid flag is "illegal flag," the anomaly type label for the current subject element record to be verified is "declaring parent record illegal anomaly." When the consistency anomaly flag of the current subject element record to be verified is "anomaly flag," the parent record's valid flag is "valid flag," and the mount availability flag of the current subject element record to be verified is "unavailable flag," the anomaly type label for the current subject element record to be verified is "mount relationship anomaly." When the following conditions are met: the current subject element record is marked as an anomaly, the parent record of the subject element record is marked as valid, the mounting availability of the subject element record is marked as available, the consistency value of the valid parent domain boundary of the subject element record is marked as inconsistent, and the total offset of the subject element record is not greater than the allowable range of the parent domain spacing, the anomaly type label for the subject element record is generated as "Valid Parent Domain Out of Boundary Anomaly". When the consistency anomaly flag of the subject element record is marked as an anomaly, the parent record of the subject element record is marked as valid, the mounting availability of the subject element record is marked as available, and the consistency value of the valid parent domain boundary of the subject element record is not greater than the allowable range of the parent domain spacing, the anomaly type label for the subject element record is generated as "Valid Parent Domain Out of Boundary Anomaly". When the total offset of the current subject element record to be verified is greater than the allowable grid spacing of the parent domain of the current subject element record to be verified, the anomaly type label of the current subject element record to be verified is coordinate offset anomaly; when the consistency anomaly flag of the current subject element record to be verified is an anomaly flag, the parent record legal flag of the current subject element record to be verified is a legal flag, the mounting availability flag of the current subject element record to be verified is an availability flag, the valid parent domain boundary consistency value of the current subject element record to be verified is an inconsistent flag, and the total offset of the current subject element record to be verified is greater than the allowable grid spacing of the parent domain of the current subject element record to be verified, the anomaly type label of the current subject element record to be verified is a combined anomaly of valid parent domain out of bounds and coordinate offset.Within a subdomain formed using the valid parent record number of the current subject element record to be verified as the root record number, candidate records are filtered. Candidate records whose record numbers differ from the current subject element record's record number and whose coordinate axis values ​​correspond to either the page axis or the subject element slot axis are used to form a recommended location candidate record set for the current subject element record. When the recommended location candidate record set is not empty, for each candidate record in the set, the absolute values ​​of the differences between the four-dimensional subject element structure coordinates of the candidate record and the subject element's corresponding coordinates on each coordinate axis are summed to form the candidate record's coordinate distance. The minimum coordinate distances of the candidate records are then compared, and the record number of the candidate record with the smallest coordinate distance is used as the recommended location node number for the current subject element record. When multiple candidate records with the smallest coordinate distance exist, their record numbers are compared to form the candidate record with the smallest record number. The record number is used as the recommended location node number for the current subject element record to be verified. When the set of recommended location candidate records for the current subject element record to be verified is empty, the recommended location node number for the current subject element record to be verified is generated based on the valid parent record number. The record number, declared parent record number, valid parent record number, actual mounting base point number, parent record validity flag, mounting availability flag, valid parent domain boundary consistency value, consistency anomaly flag, anomaly type label, total subject element offset, parent domain grid spacing tolerance, and recommended location node number are assembled to form the single subject element verification result for the current subject element record.

[0022] Optionally, the step of collecting all single-lesson element verification results to form a course-level verification result set, filtering to form an abnormal result set, and statistically calculating and outputting the number of passed and abnormal results specifically includes:

[0023] Based on the set of course element records to be verified, the verification results of each course element record are collected to form a course-level verification result set. From the course-level verification result set, the course element verification results with consistency anomaly flags are selected to form an anomaly result set. From the course-level verification result set, the number of course element verification results with consistency anomaly flags as passable is counted to form the pass verification count. From the course-level verification result set, the number of course element verification results with consistency anomaly flags as passable is counted to form the anomaly count. The pass verification count and the anomaly count are then output.

[0024] The present invention has the following beneficial effects:

[0025] 1. By incorporating courses, units, sections, pages, content blocks, resources, exercises, teaching objectives, and knowledge points into a single verification object system, it clarifies which records participate in lesson element location verification and which records participate in target anchor point calculation as target objects. This establishes a comparable, mappable, and traceable foundation for different types of data within the same logical framework. This avoids issues such as unclear object boundaries, mixed record types, and the mixing of target and lesson element data during subsequent verification processes, improving the stability and applicability of verification rules.

[0026] 2. First, the validity of the declared parent record is verified. In case of invalid parent nodes, a virtual root record number is introduced as a unified destination to avoid interruption of subsequent path tracing due to invalid parent nodes. Simultaneously, a set of prior records at the same level is formed using sorting and unique number fields, and then a coaxial positional order is established based on the same parent, ensuring that the record order under the same parent is stable, unique, and reproducible. This solves two key issues in the course structure: the validity of the parent and the clarity of the position at the same level, providing a reliable foundation for the subsequent four-dimensional course element structure coordinates.

[0027] 3. By extracting the root path, the hierarchical information of the recorded course, unit, section, page, and course element slot is linked together. Then, the nearest structural node that actually plays a role on each coordinate axis is identified using the end-bearing node number, thus converting the complex tree-like course structure into comparable structural coordinates. It can merge hierarchical position, same-level order, and parent-bearing relationship into a unified coordinate expression, allowing for direct comparison of the target's intended position, actual mounting position, and effective parent domain range.

[0028] 4. Anchor points are extracted from target class records using the target anchor point association table and declared parent records. When a target has multiple anchor points, the target anchor point record number is generated by filtering by number. When a lesson element is associated with multiple teaching objectives or knowledge points, the center coordinates of the target anchor points are generated by the structural coordinates of each target anchor point. These coordinates are then combined with the effective parent structure coordinates of the lesson element to generate the appropriate coordinates for the lesson element. This elevates the shallow validation of whether the teaching objective association exists to a deeper validation of whether the position of the lesson element content aligns with the structural orientation of the teaching objective.

[0029] 5. First, read the subject element attachment association table to distinguish between valid and invalid attachment targets. Then, through quantity comparison and self-attachment judgment, form an attachment availability flag to avoid erroneous attachment relationships directly entering coordinate verification and causing result distortion. When the attachment relationship is available, the scheme maps the four-dimensional subject element structure coordinates corresponding to the actual attachment base point number to the actual attachment coordinates; when the attachment relationship is unavailable, it falls back to the structure coordinates corresponding to the valid parent record number to ensure that the subsequent verification process is not interrupted. It can both identify anomalies in the attachment data itself and generate actual positions for boundary verification.

[0030] 6. First, determine whether the actual mounted coordinates are between the lower and upper bounds of the effective parent domain, forming a consistency value for the effective parent domain boundary. Then, perform difference processing on the components of the actual mounted coordinates and the coordinates where the subject element should be located on each coordinate axis to form the coordinate axis offset. Subsequently, average the offset results on multiple coordinate axes to form the total offset of the subject element. Finally, calculate the parent domain grid spacing tolerance based on the activity status of each coordinate axis within the effective parent domain and the number of records on the same parent and coaxial axis. The parent domain grid spacing tolerance provides a dynamic tolerance range for structural position determination, avoiding false alarms caused by normal sorting differences or local editing, while also being able to identify structural offsets that exceed the reasonable tolerance range.

[0031] 7. Anomalies are categorized into illegal parent record declarations, mounting relationship anomalies, valid parent domain out-of-bounds anomalies, coordinate offset anomalies, and composite anomalies, enabling maintenance or editing personnel to directly understand the source of the anomaly. Simultaneously, candidate records are filtered within the subdomains corresponding to the valid parent record number, and recommended location node numbers are generated based on the distance between the structural coordinates of the candidate record and the coordinates where the subject element should be located. The verification results no longer stop at simply identifying problems but further provide specific location clues for the repair process.

[0032] 8. Based on retaining detailed verification results for each course element record to be verified, further a set of abnormal results and quantity statistics are generated. This allows the system to display specific abnormal objects, abnormal types, and recommended location nodes, as well as reflect the overall consistency and health status of course data. Suitable for embedding in digital textbook editing platforms, resource management platforms, pre-release quality inspection processes for textbooks, and version migration acceptance processes. Attached Figure Description

[0033] Figure 1 This is a schematic diagram of the process of the present invention.

[0034] Figure 2 This is a schematic diagram illustrating the establishment of the four-dimensional element coordinate system and the determination of the order of elements in the same layer in this invention.

[0035] Figure 3 This is a schematic diagram of the course structure path extraction and structure coordinate generation of the present invention.

[0036] Figure 4 This is a schematic diagram illustrating the actual mounting coordinate extraction and effective parent domain tolerance range generation of the present invention. Detailed Implementation

[0037] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and 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.

[0038] Example, refer to Figure 1 A database-based method for verifying the consistency of digital textbook course data includes:

[0039] The system reads course, unit, section, page, content block, resource, exercise, teaching objective, and knowledge point records from the digital textbook course database. It establishes record numbers, record type numbers, and coordinate axis affiliations, and divides the records into subject element records to be verified and target class records. A virtual calculation root record number and a four-dimensional subject element coordinate system are established. Parent records are verified, and a parent record validity flag and valid parent record number are generated. A set of first-order records at the same level is generated based on the sorting field and unique number field, and then the parent-axis order is statistically analyzed. The root path and subdomains are extracted along the valid parent record number, and the four-dimensional subject element structure coordinates are generated based on the end-bearing node number of each coordinate axis in the root path. The system reads the target anchor point association table and the subject element-target association table, filters the candidate record number set for target anchor points, generates target anchor point record numbers, and generates the target anchor point record number through coordinate component averaging and coordinate component synthesis. The system retrieves the core coordinates and the required coordinates of each lesson element; it reads the lesson element mounting association table and performs target filtering, quantity statistics, legality comparison, coordinate mapping, and subdomain boundary construction to generate mounting availability flags, actual mounting coordinates, effective lower bound of the parent domain, and effective upper bound of the parent domain; it compares the actual mounting coordinates with the effective lower bound and effective upper bound of the parent domain, calculates the coordinate difference, and performs grid conversion to generate effective parent domain boundary consistency value, coordinate axis offset, total lesson element offset, and parent domain grid tolerance; based on the parent record legality flag, effective parent domain boundary consistency value, total lesson element offset, and parent domain grid tolerance, it generates consistency anomaly flags, anomaly type labels, recommended positioning node numbers, and single lesson element verification results; it collects all single lesson element verification results to form a course-level verification result set, filters to form an anomaly result set, and counts and outputs the number of passed verifications and the number of anomalies.

[0040] The digital textbook integrates various database records, including courses, units, sections, pages, content blocks, resources, exercises, teaching objectives, and knowledge points, into a unified verification process. This process sequentially completes record classification, parent record validity verification, structural coordinate generation, target anchor point analysis, mounting relationship judgment, boundary comparison, offset analysis, anomaly classification, and result output. By first establishing record numbers, record type numbers, and coordinate axis affiliation values, and then generating four-dimensional lesson element structural coordinates, it solves the problem that traditional verification methods can only check the existence of fields and whether parent nodes are empty, but cannot accurately reflect the actual position of lesson elements within the course structure. By reading the target anchor point association table and the lesson element-target association table, it links teaching objectives and knowledge points with the position of lesson elements, solving the problem of inconsistencies between content mounting positions and the areas pointed to by teaching objectives that are difficult to detect. By reading the lesson element mounting association table and generating mounting availability flags, actual mounting coordinates, and valid parent domain boundaries, it solves the problem of lacking system judgment criteria when lesson elements are incorrectly, multiplely, or over-boundary mounted. By generating anomaly type labels and recommended location node numbers, it is possible not only to determine whether an anomaly exists, but also to provide the anomaly category and repair reference location. Compared with the existing technology that only outputs error status or error list, this method is more conducive to editors in locating, verifying and repairing the anomaly, and improves the integrity and operability of digital textbook course data consistency verification as a whole.

[0041] The process involves retrieving records of courses, units, sections, pages, content blocks, resources, exercises, teaching objectives, and knowledge points from the digital textbook course database; establishing record numbers, record type numbers, and coordinate axis values; and dividing the records into subject-specific records and target-type records. Specifically, this includes:

[0042] The system reads nine categories of records from a single-course digital textbook database: course, unit, section, page, content block, resource, exercise, learning objective, and knowledge point. A record number is created for each read record. A set of record numbers is constructed based on all database records participating in the verification, and the total number of records is counted. For each database record, the record type number is read, and course records, unit records, section records, page records, content block records, resource records, exercise records, learning objective records, and knowledge point records are mapped to their corresponding record type numbers, forming a set of record type numbers. For each database record, based on the record type... The model number mapping generates coordinate axis assignment values; course records, teaching objective records, and knowledge point records generate coordinate axis assignment values ​​that do not participate in the four-dimensional lesson element coordinate axis occupancy; unit records generate coordinate axis assignment values ​​that occupy the unit axis; section records generate coordinate axis assignment values ​​that occupy the section axis; page records generate coordinate axis assignment values ​​that occupy the page axis; content block records, resource records, and exercise records generate coordinate axis assignment values ​​that occupy the lesson element slot axis; the sets are classified according to record type, and content block records, resource records, and exercise records are classified into a set of lesson element records to be verified, and teaching objective records and knowledge point records are classified into a set of target class records.

[0043] Retrieves nine categories of records from the digital textbook course database: course, unit, section, page, content block, resource, exercise, learning objective, and knowledge point. A set of record numbers is then created as follows: ;in, This is the set of database record numbers that participate in the verification. The total number of database records participating in the verification;

[0044] For each record Read type number The type set is established as follows:

[0045] ;in, Index the database records; For the first The type number of each database record. For course recording, For cell records, For the section record, Record for the page. Record for content blocks, For resource recording, For recording exercises, Record for teaching objectives. Record the knowledge points; A set of record type numbers;

[0046] Records Establish coordinate axis assignment values Specifically:

[0047] ;in, For the first The coordinate axis attribution value of each database record. For the first This record does not participate in the four-dimensional lesson element coordinate axis placeholder. For the first Each record occupies a cell axis. For the first Each record occupies a section axis. For the first Each record occupies a page axis. For the first Each record occupies a slot axis;

[0048] Content blocks, resources, and exercises are used as the objects for course data consistency verification. The set of course element records to be verified and the set of target class records are established as follows:

[0049] , ;in, This is the set of course element records to be verified. For the target class record set.

[0050] Reference Figure 2 The process of establishing a virtual computational root record number and a four-dimensional coordinate system, verifying the declared parent record, generating a parent record validity flag and a valid parent record number, generating a set of first-order records at the same level according to the sorting field and the unique number field, and then statistically forming a co-axial positional order with the same parent, specifically includes:

[0051] A virtual computing root record number of zero is established. This virtual computing root record number is then merged with the record numbers of the database records participating in the verification, forming an extended record number set. Extended type values ​​and extended coordinate axis attribution values ​​are established for each extended record number. For extended record numbers belonging to database records, extended type values ​​and extended coordinate axis attribution values ​​are generated by mapping the corresponding database record's record type number and coordinate axis attribution value. The virtual computing root record number generates extended type values ​​and extended coordinate axis attribution values ​​with a value of zero. For each database record, the parent record number is declared. When the declared parent record number belongs to the record number set, is different from the current database record's record number, or corresponds to an extended record, the parent record number is declared. When the type value corresponds to a course record, unit record, section record, or page record type, and the extended coordinate axis attribute value of the parent record number is declared to be less than the coordinate axis attribute value of the current database record, the generated parent record valid flag is a valid flag. When the parent record number is declared not to belong to the record number set, the generated parent record valid flag is an invalid flag. When the parent record number is declared to belong to the record number set, and satisfies the following conditions: the parent record number is the same as the record number of the current database record; the extended type value of the parent record number does not correspond to a course record, unit record, section record, or page record type; and the extended coordinate axis attribute value of the parent record number is not less than the coordinate axis attribute value of the current database record. Under any condition, the parent record validity flag is invalid; a valid parent record number mapping is performed based on the parent record validity flag; when the parent record validity flag is valid, a valid parent record number is generated by mapping the declared parent record number; when the parent record validity flag is invalid, a valid parent record number is generated by mapping the virtual computation root record number; the four-dimensional lesson element structure coordinates corresponding to the virtual computation root record number are set as the origin of the four-dimensional lesson element coordinate system, and a four-dimensional lesson element coordinate system composed of unit axis, section axis, page axis, and lesson element slot axis is established; the unit axis, section axis, and page axis are respectively positive in the increasing direction of the corresponding sorting field, and the lesson element slot axis is sorted according to the sorting word of the content block, resource, and exercise with the same valid parent record number. The increasing direction of the segments is positive, and all four coordinate axes use dimensionless normalized positional values. For any two database records, the sorting field and unique number field are read. One of the two database records is taken as the current database record, and the other is taken as the comparison record. A peer-to-peer comparison is performed based on the sorting field and unique number field. When the sorting field of the comparison record is less than the sorting field of the current database record, or when the sorting fields are the same and the unique number field of the comparison record is less than the unique number field of the current database record, a peer-to-peer judgment result of the comparison record relative to the current database record is generated, and the comparison record that satisfies the peer-to-peer judgment result is included in the peer-to-peer record set of the current database record.For each extended record number and each coordinate axis, the database records involved in the verification are treated as child records. The number of child records whose valid parent record number equals the currently enumerated extended record number and whose coordinate axis affiliation corresponds to the currently enumerated coordinate axis is counted, forming the number of records with the same parent and coordinate axis affiliation for the currently enumerated extended record number and the currently enumerated coordinate axis. For each database record, the number of records with the same valid parent record number and the same coordinate axis affiliation as the current database record, and belonging to the same-level predecessor record set of the current database record, is counted, and this count is incremented by one to form the parent and coordinate axis affiliation order of the current database record.

[0052] Create a virtual computation root record number 0, and create an extended record number set as follows:

[0053] ;in, To expand the set of record numbers; Union operator; This is a set containing only the virtual computed root record number 0;

[0054] For any integer Establish extended type values ​​and extended coordinate axis attribution values, specifically as follows:

[0055] , ;in, To extend the record number; To extend record numbering Extended type values; To extend record numbering Extended coordinate axis attribution value; for any record The legality of establishing a parent record is indicated by:

[0056] ;in, For the first The parent record number of the database record; For the first The parent record of a database record is a valid identifier; To declare the parent record number The corresponding extended type value; To declare the parent record number The corresponding extended coordinate axis attribution value; This is an indicator function that takes the value 1 when the condition inside the parentheses is true and 0 when the condition inside the parentheses is false.

[0057] For any record Establish a valid parent record number, specifically as follows:

[0058] ;in, For the first The valid parent record number of the database record. Indicates the first Each database record uses a virtual root record as its structural coordinate to calculate the parent node;

[0059] A four-dimensional coordinate system is established with the virtual computation root record 0 as the origin, specifically as follows:

[0060] First coordinate axis: cell axis, the positive direction is the increasing direction of the cell sorting field;

[0061] Second coordinate axis: Section axis, the positive direction is the increasing direction of the section sorting field;

[0062] Third axis: Page axis, with the positive direction being the increasing direction of the page sorting field;

[0063] The fourth axis: the course element slot axis, with the positive direction being the increasing direction of the sorting field for content blocks, resources, and exercises within the same parent node;

[0064] All four coordinate axes use dimensionless normalized positional values, and the origin of the coordinate system is denoted as:

[0065] ;in, The coordinates of the four-dimensional lesson element structure for the virtual calculation root record;

[0066] For any two records Read the sorting field , and unique number field , Then, construct the same-layer precedence indicator as follows:

[0067] ;in, For record Database record indexes used for sequential comparisons within the same level; For record Relative Records Priority indication of the same layer; , The first Record number The sort field value of each record; , The first Record number The unique ID field value of each record;

[0068] For any extended parent record and coordinate axes The number of records with the same parent and coaxial axis is calculated as follows: ;in, For axis index; To extend the parent record Subordinate to coordinate axis The number of child records; For the first The valid parent record number of this record; For the first The coordinate axis assignment value of each record;

[0069] For any record To calculate the positional order of siblings on the same axis, the specific steps are as follows:

[0070] ;in, For the first The position of a record within a parent record on the same axis.

[0071] Reference Figure 3 The step of extracting the root path and subdomains along the effective parent record number, and generating four-dimensional element structure coordinates based on the end-bearing node numbers of each coordinate axis in the root path, specifically includes:

[0072] For each database record, starting from the record number of the current database record, trace back level by level along the valid parent record number to the virtual computing root record number. Then, arrange the path node numbers in the direction from the virtual computing root record number to the record number of the current database record to form the root path of the current database record. Set any extended record number as the subdomain root record number. Based on the root path inclusion relationship, gather all database records that contain the current subdomain root record number to construct the subdomain of the current subdomain root record number. When the current subdomain root record number is the virtual computing root record number, the subdomain contains all database records. For the root path of each database record, filter the end-bearing node numbers based on the extended coordinate axis attribution value corresponding to the path node number, and take the path node number being checked as the target path node number. When the extended coordinate axis attribution value corresponding to the target path node number corresponds to the current enumerated coordinate axis, and there is no path node number in the root path that is after the target path node number and whose extended coordinate axis attribution value corresponds to the current enumerated coordinate axis, generate the end-bearing node number of the current enumerated coordinate axis. For each database record and each For each coordinate axis, when the root path contains the end-carrying node number of the currently enumerated coordinate axis, a normalized positional conversion is performed based on the parent-child coaxial positional order of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis formed in the previous order, and the number of parent-child coaxial records when the effective parent record number of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis is used as the extended record number of the current enumeration, and the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis. The parent-child coaxial positional order of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis is then divided by the previously formed normalized positional order. The structural coordinate components of the current enumerated coordinate axis are calculated by taking the valid parent record number of the record corresponding to the end bearing node number of the current enumerated coordinate axis as the current enumerated extended record number, and the number of records with the same parent and coaxiality when the coordinate axis belonging value of the child record corresponds to the current enumerated coordinate axis plus one. When there is no end bearing node number of the current enumerated coordinate axis in the root path, the structural coordinate components of the current enumerated coordinate axis are set to zero. The structural coordinate components are combined in the order of unit axis, section axis, page axis and lesson element slot axis to generate the four-dimensional lesson element structural coordinates of the current database record.

[0073] For any record Number along the effective parent record Tracing back to the virtual computing root record to form the root path, specifically:

[0074] , , , ;in, For the first Each record represents the root path from the virtual computed root record to itself; For the first The 0th path node in the root path is recorded; For the first The last path node in the root path is recorded; For the first The number of path levels for each record; For location path index; For the first The first record in the root path One path node; Path node The valid parent record number;

[0075] For any extended record Establish to record The subfield of the root is specifically:

[0076] ;in, To extend the record The subfield of the root; For the first The 0th path node in the root path is recorded; For the first The last path node in the root path is recorded; For the first The number of path levels for each record;

[0077] when hour, Includes all database records;

[0078] To avoid multiple content-level records within the same path repeatedly occupying the course element slot axis, the path position is... and coordinate axes The calculation of the end load indication is as follows:

[0079] ;in, For the first The first record in the root path The path node is the first The end bearing indicator of each coordinate axis; Path node The coordinate axis assignment values; For indexing subsequent positions in the path; For the first The first record in the root path One path node; Path node The coordinate axis assignment values;

[0080] For any database record and coordinate axes The structural coordinate components are calculated as follows:

[0081] ;in, For the first The first database record Structural coordinate components on each coordinate axis; Path node The same parent and coaxial positional order; Path node The valid parent record number; For a valid parent record The following belongs to the first The number of sub-records for each coordinate axis; further forming records. The coordinates of the lesson element structure are as follows: ;in, For the first The coordinates of the four-dimensional lesson element structure of each database record.

[0082] The process of reading the target anchor point association table and the lesson element-target association table, filtering the candidate record number set for target anchor points, generating target anchor point record numbers, and generating the target anchor point center coordinates and the lesson element's corresponding coordinates through coordinate component averaging and coordinate component synthesis, specifically includes:

[0083] For each target class record, read the target anchor point association table. Based on the target anchor point association table, perform association filtering and coordinate axis attribution filtering. Among the database records that have an association relationship with the current target class record, filter the database records whose coordinate axis attribution values ​​correspond to the unit axis, section axis, page axis, or lesson element slot axis, forming a set of candidate target anchor point record numbers for the current target class record. For each target class record, read the declared parent record number. When the declared parent record number belongs to the record number set and the extended coordinate axis attribution value of the record corresponding to the declared parent record number corresponds to the unit axis, section axis, page axis, or lesson element... When generating a slot axis, the target parent anchor point of the current target class record is marked as available; when the parent record number is declared not to belong to the record number set, the target parent anchor point of the current target class record is marked as unavailable; when the parent record number is declared to belong to the record number set and the extended coordinate axis belonging value of the record corresponding to the parent record number does not correspond to the unit axis, section axis, page axis, or lesson slot axis, the target parent anchor point of the current target class record is marked as unavailable; when the target anchor point candidate record number set of the current target class record is not empty, the record in the target anchor point candidate record number set of the current target class record is used. The record numbers are compared to their minimum values, and the record number with the smallest value is used as the target anchor record number for the current target class record. If the set of candidate target anchor record numbers for the current target class record is empty and the target parent anchor point availability flag for the current target class record is set to available, the target anchor record number for the current target class record is generated based on the declared parent record number. If the set of candidate target anchor record numbers for the current target class record is empty and the target parent anchor point availability flag for the current target class record is set to unavailable, the target anchor record number for the current target class record is generated based on the virtual computation root record number. For each lesson element record to be verified, the lesson element and target association table is read. Based on the lesson element and target association table, the record numbers of teaching target records and knowledge point records that are related to the record number of the current lesson element record to be verified are filtered to form a set of lesson element associated target record numbers of the current lesson element record to be verified, and the number of lesson element associated target record numbers of the current lesson element record to be verified is counted. When the number of lesson element associated target record numbers of the current lesson element record to be verified is zero, the four-dimensional lesson element structure coordinates corresponding to the effective parent record number of the current lesson element record to be verified are inherited as the target anchor point center coordinates of the current lesson element record to be verified.When the number of associated target record numbers of the current subject element record to be verified is greater than zero, based on the four-dimensional subject element structure coordinates corresponding to the target anchor point record numbers of the target class records corresponding to the target element associated target record numbers in the previously generated set of associated target record numbers of the current subject element record to be verified, the structural coordinate components of each coordinate axis are summed, and then the summation value of each coordinate axis is divided by the number of associated target record numbers of the current subject element record to be verified to generate the target anchor point center coordinates of the current subject element record to be verified; for each subject element record to be verified, the four-dimensional subject element structure coordinates corresponding to the effective parent record number of the current subject element record to be verified and the target anchor point center coordinates of the current subject element record to be verified are equally divided according to the coordinate axis components and combined. The components of the two coordinates on each coordinate axis are added together and then half is taken to generate the subject element position coordinates of the current subject element record to be verified.

[0084] For any target class record Read the target anchor point association table The candidate set of target anchor points is established as follows: ;in, Index the target class record; Record for target class The candidate set of target anchor points;

[0085] The flags that can be used to establish a target parent anchor point are:

[0086] ;in, Record for target class The target parent anchor point can be marked; Record for target class The parent record number of the declaration The corresponding extended coordinate axis attribution value;

[0087] The target anchor point is recorded as follows: ;in, Record for target class Target anchor point record number, Represents the target class record The target anchor point is the virtual computation root record; This is a base function for a set; the input is a set, and the output is the number of elements in the set.

[0088] For any subject record to be verified Read the association table between lesson elements and objectives. The target set is established as follows: ;in, Index of the course element record to be verified; For course element record The associated collection of target class records;

[0089] And calculate the target quantity as follows: ;in, For course element record The number of associated target class records, Represents the course element record Not related to teaching objectives and knowledge points Represents the course element record At least one teaching objective record or knowledge point record has been associated; the lesson element record to be verified The coordinates of the center of the generated target anchor point are:

[0090] ;in, For course element record The center coordinates of the target anchor point; For course element record Valid parent record Four-dimensional structural coordinates; Record for target class Target anchor point record Four-dimensional structural coordinates;

[0091] To be verified course record By combining the effective parent record coordinates with the target anchor point center coordinates into equal parts, the coordinates of the lesson element should be obtained as follows: ;in, For course element record The coordinates of the location.

[0092] Reference Figure 4 The process of reading the course element mounting association table and performing mounting target filtering, quantity statistics, legality comparison, coordinate mapping, and subdomain boundary construction to generate mounting availability flags, actual mounting coordinates, effective parent domain lower bound, and effective parent domain upper bound specifically includes:

[0093] For each course element record to be verified, the course element mounting association table is read. Based on all mounting target numbers in the course element mounting association table that have a row relationship with the record number of the current course element record to be verified, as well as the row-level membership relationships, a multiset of original mounting target numbers for the current course element record to be verified is constructed. From the multiset of original mounting target numbers for the current course element record to be verified, mounting target numbers that belong to the record number set, are different from the record number of the current course element record to be verified, and whose coordinate axis assignment value corresponds to the page axis or course element slot axis are selected to form a set of non-self actual mounted record numbers for the current course element record to be verified. The non-self actual mounted record numbers for the current course element record are counted. The system checks the number of record numbers. Based on the course element mounting association table, it performs an existence check on row-level associations where both the course element record number and the mounting target number are the record numbers of the current course element record to be verified. When a row-level association record exists in the course element mounting association table where both the course element record number and the mounting target number are the record numbers of the current course element record to be verified, an existence flag is generated for the current course element record to be verified, and the count value of the self-mounting flag of the current course element record to be verified is set to one. When a row-level association record does not exist in the course element mounting association table where both the course element record number and the mounting target number are the record numbers of the current course element record to be verified, an existence flag is generated for the current course element record to be verified, and the count value of the self-mounting flag of the current course element record to be verified is set to one. The count value of the self-mounting flag is set to zero; the number of elements in the multiset of the original mounted target number of the current subject element record to be verified is compared with the sum of the number of non-self actual mounted record numbers of the current subject element record to be verified and the count value of the self-mounting flag of the current subject element record; if the number of elements in the multiset of the original mounted target number of the current subject element record to be verified is greater than the sum of the count value of the non-self actual mounted record numbers of the current subject element record to be verified and the count value of the self-mounting flag of the current subject element record to be verified, an illegal mounting flag is generated for the current subject element record to be verified as an illegal identifier; if the number of elements in the multiset of the original mounted target number of the current subject element record to be verified is not greater than the number of non-self actual mounted record numbers of the current subject element record to be verified. When the sum of the count values ​​of the current subject element record's own mounting flag and the current subject element record's own mounting flag is reached, an illegal mounting flag for the current subject element record is generated as a valid flag. When the illegal mounting flag for the current subject element record is a valid flag, the current subject element record's own mounting flag is a non-existent flag, and the number of non-self-mounted actual record numbers for the current subject element record is one, an available mounting flag for the current subject element record is generated as an available flag. When the illegal mounting flag for the current subject element record is an illegal flag, or the current subject element record's own mounting flag is an existing flag, or the number of non-self-mounted actual record numbers for the current subject element record is not one, an unavailable mounting flag for the current subject element record is generated.When the number of non-self-attached record numbers of the current subject element record to be verified is greater than zero, the minimum value of the record numbers in the set of non-self-attached record numbers of the current subject element record to be verified is compared, and the record number with the smallest record number is generated as the actual mounting base point number of the current subject element record to be verified; when the number of non-self-attached record numbers of the current subject element record to be verified is zero, the actual mounting base point number of the current subject element record to be verified is generated based on the virtual calculation root record number; the actual mounting coordinate mapping is performed based on the mounting availability flag of the current subject element record to be verified; when the mounting availability flag of the current subject element record to be verified is an available flag, the four-dimensional subject element structure coordinates of the record corresponding to the actual mounting base point number of the current subject element record to be verified are mapped to the actual mounting coordinates of the current subject element record to be verified; when the mounting availability flag of the current subject element record to be verified is an unavailable flag, the valid... The four-dimensional structural coordinates corresponding to the parent record number are mapped to the actual mounting coordinates of the current subject element record to be verified. Based on the subdomain formed by using the effective parent record number of the current subject element record as the root record number of the subdomain, an effective parent domain for the current subject element record to be verified is constructed. Boundary construction is performed based on the structural coordinate components of each database record within the effective parent domain of the current subject element record on each coordinate axis. For each coordinate axis, the coordinate axis currently undergoing boundary construction is used as the current enumerated coordinate axis. The minimum value among the structural coordinate components of each database record within the effective parent domain of the current subject element record on the current enumerated coordinate axis is taken as the lower bound of the effective parent domain of the current subject element record on the current enumerated coordinate axis, and the maximum value among the structural coordinate components of each database record within the effective parent domain of the current subject element record on the current enumerated coordinate axis is taken as the upper bound of the effective parent domain of the current subject element record on the current enumerated coordinate axis.

[0094] To be verified course record Read the class element mounting association table The original mount target multiset is generated as follows: ;in, The mounting target number is in the mounting association table of the course element; It is a set of integers; This is a row-level membership relationship; Represents the course element record With the target number There is one associated record in the course element mounting association table; For course element record The original mount target multiple set;

[0095] The generated non-self actual mounted set is as follows:

[0096] ;in, For course element record The set that is not actually mounted to itself; Represents the course element record With the target number There is one associated record in the course element mounting association table;

[0097] And calculate the number of non-self mounts: ;in, For course element record The number of units not actually mounted by itself;

[0098] The self-mount flag is constructed as follows: ;in, For course element record Its own mounting mark; For course element record With oneself There is one associated record in the course element mounting association table;

[0099] The illegal mounting flag is constructed as follows: ;in, For course element record Illegal display of signs;

[0100] The available flags for building mounts are: ;in, For course element record Mountable flags are available;

[0101] To be verified course record Generate the actual mount point, specifically:

[0102] ;in, For course element record The actual mounting point number, This indicates that the actual mounting base point uses a virtual calculated root record number;

[0103] To be verified course record The generated actual mount coordinates are: ;in, For course element record The actual mount coordinates; The actual mounting point Four-dimensional structural coordinates;

[0104] To be verified course record With effective parent record subdomain To determine the acceptable range, calculate the lower and upper bounds of each coordinate axis, specifically as follows:

[0105] , ;in, For course element record In the Effective lower bounds of parent domains on each coordinate axis; For course element record In the The effective upper bound of the parent domain on each coordinate axis; To record by lesson element Valid parent record The subfield of the root.

[0106] The process of comparing the actual mounted coordinates with the lower and upper bounds of the effective parent domain, calculating coordinate differences, and converting grid spacing to generate the effective parent domain boundary consistency value, coordinate axis offset, total element offset, and parent domain grid spacing tolerance specifically includes:

[0107] Based on the mounting availability flag of the current course element record to be verified, the actual mounting coordinates of the current course element record to be verified, and the lower and upper bounds of the effective parent domain of the current course element record to be verified on each coordinate axis, a boundary consistency comparison is performed. If the mounting availability flag of the current course element record to be verified is "available," and the components of the actual mounting coordinates of the current course element record to be verified on each coordinate axis are all located between the lower and upper bounds of the effective parent domain of the current course element record to be verified on the same coordinate axis, a consistency value for the effective parent domain boundary of the current course element record to be verified is generated; otherwise, an inconsistency value for the effective parent domain boundary consistency of the current course element record to be verified is generated. For each course element record to be verified... For each coordinate axis, when the mounting availability flag of the current subject element record to be verified is "available," the component of the actual mounting coordinate of the current subject element record on the current enumerated coordinate axis is subtracted from the component of the subject element's proper location coordinate on the current enumerated coordinate axis to calculate the coordinate axis offset of the current subject element record on the current enumerated coordinate axis. When the mounting availability flag of the current subject element record to be verified is "unavailable," the coordinate axis offset of the current subject element record on the current enumerated coordinate axis is set to one. For each subject element record to be verified, the coordinate axis offsets of the current subject element record on the unit axis, section axis, page axis, and subject element slot axis are added together, divided by four, and averaged to form the total subject element offset of the current subject element record. Offset; For each lesson element record to be verified and each coordinate axis, compare the upper bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis with the lower bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis; when the upper bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis is greater than the lower bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis, generate an active indicator of the parent domain of the current lesson element record to be verified on the current enumerated coordinate axis as an active flag; when the upper bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis is not greater than the lower bound of the effective parent domain of the current lesson element record to be verified on the current enumerated coordinate axis, generate an inactive indicator of the parent domain of the current lesson element record to be verified on the current enumerated coordinate axis; For each lesson element record to be verified and each coordinate axis, the grid spacing is converted based on the number of records with the same parent and axis when the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis, which is formed by the previous statistics. When the activity indicator of the parent domain of the current lesson element record to be verified is an activity identifier, the number of records with the same parent and axis when the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis is increased by one to form the denominator of the grid spacing conversion. Then, two is divided by the denominator of the grid spacing conversion to convert and form the single-axis grid spacing allowance of the current lesson element record to be verified on the current enumerated coordinate axis.When the activity indicator of the parent domain of the current subject element record to be verified on the current enumerated coordinate axis is an inactive flag, the single-axis grid tolerance of the current subject element record on the current enumerated coordinate axis is set to zero; the single-axis grid tolerances of the current subject element record on the four coordinate axes are added together, divided by four, and averaged to form the parent domain grid tolerance of the current subject element record.

[0108] To be verified course record The calculation of whether the actual mount coordinates fall within the valid parent domain is as follows: ;in, For course element record The effective parent domain boundary consistency value; For course element record The actual mount coordinates are at the 1st Components on each coordinate axis;

[0109] To be verified course record and coordinate axes The coordinate axis offset is calculated as follows:

[0110] ;in, For course element record In the Offset on each coordinate axis; For course element record The coordinates of the position should be in the first position. Components on each coordinate axis; records of the subject to be verified The average offset of the four coordinate axes is calculated as follows:

[0111] ;in, For course element record Total offset;

[0112] To be verified course record The parent domain activity indicator is constructed based on the effective parent domain coordinate range, specifically as follows: ;in, For course element record In the Parent domain activity indicators on each coordinate axis;

[0113] Based on the valid parent record The number of records on the same parent axis across the four coordinate axes is used to calculate the parent domain grid spacing tolerance, specifically: ;in, For course element record Parent domain grid spacing allowance; For a valid parent record The following belongs to the first The number of sub-records for each coordinate axis.

[0114] The process generates consistency anomaly flags, anomaly type labels, recommended location node numbers, and single-element verification results based on the parent record's legality flag, valid parent domain boundary consistency value, total lesson element offset, and parent domain grid spacing tolerance. Specifically, this includes:

[0115] For each lesson element record to be verified, anomaly combination judgment is performed based on the parent record validity flag, the valid parent domain boundary consistency value, the total lesson element offset, and the parent domain grid spacing tolerance of the current lesson element record. If the parent record validity flag is valid, the valid parent domain boundary consistency value is consistent, and the total lesson element offset is not greater than the parent domain grid spacing tolerance, a consistency anomaly flag of the current lesson element record is generated as a pass flag; otherwise, an consistency anomaly flag of the current lesson element record is generated as an anomaly flag. When the consistency anomaly flag of the current subject element record to be verified is "passed," the anomaly type label for the current subject element record to be verified is "no anomaly." When the consistency anomaly flag of the current subject element record to be verified is "anomaly flag" and the parent record's valid flag is "illegal flag," the anomaly type label for the current subject element record to be verified is "declaring parent record illegal anomaly." When the consistency anomaly flag of the current subject element record to be verified is "anomaly flag," the parent record's valid flag is "valid flag," and the mount availability flag of the current subject element record to be verified is "unavailable flag," the anomaly type label for the current subject element record to be verified is "mount relationship anomaly." When the following conditions are met: the current subject element record is marked as an anomaly, the parent record of the subject element record is marked as valid, the mounting availability of the subject element record is marked as available, the consistency value of the valid parent domain boundary of the subject element record is marked as inconsistent, and the total offset of the subject element record is not greater than the allowable range of the parent domain spacing, the anomaly type label for the subject element record is generated as "Valid Parent Domain Out of Boundary Anomaly". When the consistency anomaly flag of the subject element record is marked as an anomaly, the parent record of the subject element record is marked as valid, the mounting availability of the subject element record is marked as available, and the consistency value of the valid parent domain boundary of the subject element record is not greater than the allowable range of the parent domain spacing, the anomaly type label for the subject element record is generated as "Valid Parent Domain Out of Boundary Anomaly". When the total offset of the current subject element record to be verified is greater than the allowable grid spacing of the parent domain of the current subject element record to be verified, the anomaly type label of the current subject element record to be verified is coordinate offset anomaly; when the consistency anomaly flag of the current subject element record to be verified is an anomaly flag, the parent record legal flag of the current subject element record to be verified is a legal flag, the mounting availability flag of the current subject element record to be verified is an availability flag, the valid parent domain boundary consistency value of the current subject element record to be verified is an inconsistent flag, and the total offset of the current subject element record to be verified is greater than the allowable grid spacing of the parent domain of the current subject element record to be verified, the anomaly type label of the current subject element record to be verified is a combined anomaly of valid parent domain out of bounds and coordinate offset.Within a subdomain formed using the valid parent record number of the current subject element record to be verified as the root record number, candidate records are filtered. Candidate records whose record numbers differ from the current subject element record's record number and whose coordinate axis values ​​correspond to either the page axis or the subject element slot axis are used to form a recommended location candidate record set for the current subject element record. When the recommended location candidate record set is not empty, for each candidate record in the set, the absolute values ​​of the differences between the four-dimensional subject element structure coordinates of the candidate record and the subject element's corresponding coordinates on each coordinate axis are summed to form the candidate record's coordinate distance. The minimum coordinate distances of the candidate records are then compared, and the record number of the candidate record with the smallest coordinate distance is used as the recommended location node number for the current subject element record. When multiple candidate records with the smallest coordinate distance exist, their record numbers are compared to form the candidate record with the smallest record number. The record number is used as the recommended location node number for the current subject element record to be verified. When the set of recommended location candidate records for the current subject element record to be verified is empty, the recommended location node number for the current subject element record to be verified is generated based on the valid parent record number. The record number, declared parent record number, valid parent record number, actual mounting base point number, parent record validity flag, mounting availability flag, valid parent domain boundary consistency value, consistency anomaly flag, anomaly type label, total subject element offset, parent domain grid spacing tolerance, and recommended location node number are assembled to form the single subject element verification result for the current subject element record.

[0116] To be verified course record Anomaly flags are generated based on the parent record's validity flag, the valid parent domain boundary consistency value, and the total offset of the class element. Specifically:

[0117] ;in, For course element record Consistency anomaly marker, Representing records Through consistency verification Representing records There are inconsistencies in the course data;

[0118] To be verified course record Generate exception type labels, specifically:

[0119] when season ;in, For course element record Exception type labels, This indicates no abnormalities. This indicates that the parent record is illegal and abnormal. This indicates an abnormal mount relationship. This indicates an out-of-bounds exception for the valid parent domain. This indicates an abnormal coordinate offset. This indicates a combined anomaly of valid parent domain out-of-bounds and coordinate offset.

[0120] when season ;

[0121] when season ;

[0122] when season:

[0123] ;

[0124] In the effective parent record Within the subdomain, the recommended location candidate set is generated as follows:

[0125] ;in, For course element record Recommended location candidate set;

[0126] The record closest to the desired coordinates in the recommended location candidate set is selected as the recommended location node, specifically:

[0127] ;in, For course element record Recommended location node number;

[0128] To be verified course record The single-lesson element verification result is as follows:

[0129] ;in, For course element record The single-lesson unit verification results.

[0130] The process involves collecting all individual lesson verification results to form a course-level verification result set, filtering to form an abnormal result set, and statistically analyzing and outputting the number of passed and abnormal results. Specifically, this includes:

[0131] Based on the set of course element records to be verified, the verification results of each course element record are collected to form a course-level verification result set. From the course-level verification result set, the course element verification results with consistency anomaly flags are selected to form an anomaly result set. From the course-level verification result set, the number of course element verification results with consistency anomaly flags as passable is counted to form the pass verification count. From the course-level verification result set, the number of course element verification results with consistency anomaly flags as passable is counted to form the anomaly count. The pass verification count and the anomaly count are then output.

[0132] For all subject records to be verified The generated course-level verification result set is as follows:

[0133] ;in, This is a set of course-level verification results.

[0134] Based on the set of subject records to be verified and the anomaly flags, the following set of anomaly results is generated:

[0135] ;in, A collection of abnormal results;

[0136] Count the records with an anomaly flag of 0 to obtain the number of records that passed the verification:

[0137] ;in, The number of items that passed the verification;

[0138] The number of records with an anomaly flag of 1 is counted, resulting in the following anomaly count:

[0139] ;in, This is an abnormal number;

[0140] Output the number of validation passes and number of anomalies .

[0141] It should be noted that, in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, 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 process, method, article, or apparatus.

[0142] The above description is only a preferred embodiment of the present invention. It should be noted that for those skilled in the art, several improvements and modifications can be made without departing from the technical principles of the present invention, and these improvements and modifications should also be considered within the scope of protection of the present invention.

Claims

1. A database-based method for verifying the consistency of digital textbook course data, characterized in that, include: Retrieves course, unit, section, page, content block, resource, exercise, teaching objective and knowledge point records from the digital textbook course database, establishes record number, record type number and coordinate axis value, and divides the course element records to be verified into target class records; Establish a virtual calculation root record number and a four-dimensional lesson element coordinate system, verify the declared parent record, generate a parent record legal flag and a valid parent record number, generate a set of first-order records at the same level according to the sorting field and the unique number field, and then statistically form the same parent and coaxial position order; Extract the root path and subdomains along the valid parent record number, and generate the four-dimensional element structure coordinates based on the end node number of each coordinate axis in the root path; Read the target anchor point association table and the lesson element and target association table, filter the target anchor point candidate record number set, generate the target anchor point record number, and generate the target anchor point center coordinates and the lesson element location coordinates through coordinate component averaging and coordinate component synthesis; Read the course element mounting association table and perform mounting target filtering, quantity statistics, legality comparison, coordinate mapping and subdomain boundary construction to generate mounting availability flags, actual mounting coordinates, effective parent domain lower bound and effective parent domain upper bound; The actual mounted coordinates are compared with the lower and upper boundaries of the effective parent domain, the coordinate difference is calculated, and the grid distance is converted to generate the effective parent domain boundary consistency value, coordinate axis offset, total element offset, and parent domain grid distance allowance. Based on the parent record's legality flag, the valid parent domain boundary consistency value, the total offset of the lesson element, and the parent domain grid spacing tolerance, generate a consistency anomaly flag, anomaly type label, recommended location node number, and single lesson element verification result; Collect all single-lesson element verification results to form a course-level verification result set, filter to form an abnormal result set, and count the number of passed verifications and the number of abnormal verifications and output them.

2. The database-based digital textbook course data consistency verification method according to claim 1, characterized in that, The process involves retrieving records of courses, units, sections, pages, content blocks, resources, exercises, teaching objectives, and knowledge points from the digital textbook course database; establishing record numbers, record type numbers, and coordinate axis values; and dividing the records into subject-specific records and target-type records. Specifically, this includes: The system reads nine categories of records from the single-course digital textbook database: course, unit, section, page, content block, resource, exercise, teaching objective, and knowledge point. It creates a record number for each read record, constructs a set of record numbers based on all database records participating in the verification, and counts the total number of records. For each database record, read the record type number and map course records, unit records, section records, page records, content block records, resource records, exercise records, teaching objective records, and knowledge point records to their corresponding record type numbers, forming a set of record type numbers; For each database record, coordinate axis assignment values ​​are generated based on the record type number. Course records, teaching objective records, and knowledge point records generate coordinate axis assignment values ​​that do not participate in the four-dimensional lesson element coordinate axis placement. Unit records generate coordinate axis assignment values ​​that occupy the unit axis. Section records generate coordinate axis assignment values ​​that occupy the section axis. Page records generate coordinate axis assignment values ​​that occupy the page axis. Content block records, resource records, and exercise records generate coordinate axis assignment values ​​that occupy the lesson element slot axis. The records are categorized by type: content block records, resource records, and exercise records are categorized into a set of lesson element records to be verified, and teaching objective records and knowledge point records are categorized into a set of objective type records.

3. The database-based digital textbook course data consistency verification method according to claim 2, characterized in that, The process of establishing a virtual computational root record number and a four-dimensional element coordinate system, verifying the declared parent record, generating a parent record validity flag and a valid parent record number, generating a set of first-order records at the same level according to the sorting field and the unique number field, and then statistically forming a co-axial positional order with the same parent, specifically includes: Establish a virtual computing root record with a number of zero, and merge the virtual computing root record number with the record number of the database record participating in the verification to form an extended record number set; For extended record numbers, establish extended type values ​​and extended coordinate axis attribution values; for extended record numbers belonging to database records, generate extended type values ​​and extended coordinate axis attribution values ​​by mapping the record type number and coordinate axis attribution value of the corresponding database record; virtually calculate the root record number to generate extended type values ​​and extended coordinate axis attribution values ​​with a value of zero; For each database record, read the declared parent record number. A valid parent record flag is generated when: the declared parent record number belongs to the record number set; the declared parent record number is different from the record number of the current database record; the extended type value of the record corresponding to the declared parent record number corresponds to a course record, unit record, section record, or page record type; and the extended coordinate axis value of the record corresponding to the declared parent record number is less than the coordinate axis value of the current database record. An invalid parent record flag is generated when: the declared parent record number does not belong to the record number set. An invalid parent record flag is generated when: the declared parent record number belongs to the record number set and satisfies any of the following conditions: the declared parent record number is the same as the record number of the current database record; the extended type value of the record corresponding to the declared parent record number does not correspond to a course record, unit record, section record, or page record type; or the extended coordinate axis value of the record corresponding to the declared parent record number is not less than the coordinate axis value of the current database record. Valid parent record number mapping is performed based on the parent record's valid identifier; when the parent record's valid identifier is a valid identifier, a valid parent record number is generated by declaring the parent record number mapping; when the parent record's valid identifier is an invalid identifier, a valid parent record number is generated by virtually calculating the root record number mapping. Set the four-dimensional lesson element structure coordinates corresponding to the virtual calculation root record number as the origin of the four-dimensional lesson element coordinate system, and establish a four-dimensional lesson element coordinate system composed of unit axis, section axis, page axis and lesson element slot axis; the unit axis, section axis and page axis are positively oriented according to the increasing direction of the corresponding sorting field, and the lesson element slot axis is positively oriented according to the increasing direction of the sorting field of content blocks, resources and exercises with the same valid parent record number. All four coordinate axes use dimensionless normalized positional values. Read the sorting field and unique number field of any two database records. Take one of the two database records as the current database record and the other as the comparison record. Perform a same-level priori comparison based on the sorting field and unique number field. When the sorting field of the comparison record is less than the sorting field of the current database record, or when the sorting fields are the same and the unique number field of the comparison record is less than the unique number field of the current database record, generate the same-level priori judgment result of the comparison record relative to the current database record, and add the comparison record that satisfies the same-level priori judgment result to the same-level priori record set of the current database record. For each extended record number and each coordinate axis, the database records involved in the verification are treated as child records. The number of child records whose effective parent record number is equal to the current enumerated extended record number and whose coordinate axis belonging value corresponds to the current enumerated coordinate axis is counted, thus forming the number of records with the same parent and the same axis corresponding to the current enumerated extended record number and the current enumerated coordinate axis. For each database record, count the number of records that have the same valid parent record number and the same coordinate axis affiliation value as the current database record and belong to the same level of the current database record's predecessor record set, and add one to the count to form the same parent and same axis position of the current database record.

4. The database-based digital textbook course data consistency verification method according to claim 3, characterized in that, The extraction of the root path and subdomains along the effective parent record number, and the generation of four-dimensional element structure coordinates based on the end-bearing node numbers of each coordinate axis in the root path, specifically includes: For each database record, starting from the record number of the current database record, trace back level by level along the valid parent record number to the virtual computing root record number, and then arrange the path node numbers in the direction from the virtual computing root record number to the record number of the current database record to form the root path of the current database record; Set any extended record number as the subdomain root record number, and gather all database records containing the current subdomain root record number based on the root path inclusion relationship to construct the subdomain with the current subdomain root record number; when the current subdomain root record number is a virtual computed root record number, the subdomain contains all database records; For the root path of each database record, the end-bearing node number is filtered based on the extended coordinate axis belonging value corresponding to the path node number, and the path node number being checked is taken as the target path node number; when the extended coordinate axis belonging value corresponding to the target path node number corresponds to the current enumerated coordinate axis, and there is no path node number in the root path that is located after the target path node number and whose extended coordinate axis belonging value corresponds to the current enumerated coordinate axis, the end-bearing node number of the current enumerated coordinate axis is generated. For each database record and each coordinate axis, when the root path contains the end-carrying node number of the currently enumerated coordinate axis, a normalized positional conversion is performed based on the parent-coaxial positional order of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis formed in the previous order, and the number of parent-coaxial records when the effective parent record number of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis is used as the current enumerated extended record number and the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis. The parent-coaxial positional order of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis is divided by the result of the number of parent-coaxial records when the effective parent record number of the record corresponding to the end-carrying node number of the currently enumerated coordinate axis is used as the current enumerated extended record number and the coordinate axis affiliation value of the child record corresponds to the current enumerated coordinate axis plus one, and the structural coordinate component of the current enumerated coordinate axis is formed. When the root path does not contain the end-carrying node number of the currently enumerated coordinate axis, the structural coordinate component of the current enumerated coordinate axis is set to zero. By combining the structural coordinate components in the order of unit axis, section axis, page axis, and lesson element slot axis, the four-dimensional lesson element structural coordinates of the current database record are generated.

5. The database-based digital textbook course data consistency verification method according to claim 4, characterized in that, The process of reading the target anchor point association table and the lesson element-target association table, filtering the candidate record number set for target anchor points, generating target anchor point record numbers, and generating the target anchor point center coordinates and the lesson element's corresponding coordinates through coordinate component averaging and coordinate component synthesis, specifically includes: For each target class record, read the target anchor point association table, and perform association relationship filtering and coordinate axis affiliation filtering based on the target anchor point association table. In the database records that have an association relationship with the current target class record, filter the database records whose coordinate axis affiliation value corresponds to the unit axis, section axis, page axis, or lesson slot axis, and form a set of target anchor point candidate record numbers for the current target class record. For each target class record, read the declared parent record number. When the declared parent record number belongs to the record number set and the extended coordinate axis of the record corresponding to the declared parent record number corresponds to the unit axis, section axis, page axis, or lesson slot axis, the target parent anchor point of the current target class record is marked as available. When the declared parent record number does not belong to the record number set, the target parent anchor point of the current target class record is marked as unavailable. When the declared parent record number belongs to the record number set and the extended coordinate axis of the record corresponding to the declared parent record number does not correspond to the unit axis, section axis, page axis, or lesson slot axis, the target parent anchor point of the current target class record is marked as unavailable. When the set of candidate target anchor records for the current target class record is not empty, the minimum value of the record numbers in the set of candidate target anchor records for the current target class record is compared, and the record number with the smallest record number is generated as the target anchor record number for the current target class record; when the set of candidate target anchor records for the current target class record is empty and the target parent anchor of the current target class record is available, the target anchor record number for the current target class record is generated based on the declared parent record number of the current target class record; when the set of candidate target anchor records for the current target class record is empty and the target parent anchor of the current target class record is unavailable, the target anchor record number for the current target class record is generated based on the virtual computed root record number. For each lesson element record to be verified, read the lesson element and target association table, and based on the lesson element and target association table, filter the record numbers of teaching target records and knowledge point records that are related to the record number of the current lesson element record to be verified, form a set of lesson element associated target record numbers of the current lesson element record to be verified, and count the number of lesson element associated target record numbers of the current lesson element record to be verified. When the number of target record numbers associated with the current subject element record is zero, the four-dimensional subject element structure coordinates corresponding to the effective parent record number of the current subject element record are inherited as the target anchor point center coordinates of the current subject element record. When the number of target record numbers associated with the current subject element record is greater than zero, based on the four-dimensional subject element structure coordinates corresponding to the target anchor point record numbers of the target class records corresponding to the target record numbers of the subject element associated with the target record numbers of the subject element record generated in the previous generation, the structure coordinate components of each coordinate axis are summed, and then the summation value of each coordinate axis is divided by the number of target record numbers associated with the current subject element record to generate the target anchor point center coordinates of the current subject element record. For each lesson element record to be verified, the four-dimensional lesson element structure coordinates corresponding to the effective parent record number of the current lesson element record to be verified and the target anchor point center coordinates of the current lesson element record to be verified are combined equally according to the coordinate axis components. The components of the two coordinates on each coordinate axis are added together and then half is taken to generate the corresponding coordinates of the lesson element of the current lesson element record to be verified.

6. The database-based digital textbook course data consistency verification method according to claim 5, characterized in that, The process of reading the course element mounting association table and performing mounting target filtering, quantity statistics, legality comparison, coordinate mapping, and subdomain boundary construction to generate mounting availability flags, actual mounting coordinates, effective parent domain lower bound, and effective parent domain upper bound specifically includes: For each subject element record to be verified, read the subject element mounting association table. Based on all mounting target numbers in the subject element mounting association table that have the same row association relationship with the record number of the current subject element record to be verified, as well as the row-level membership relationship, construct a multi-set of the original mounting target numbers of the current subject element record to be verified. In the multiple set of original mounting target numbers of the current subject element record to be verified, the mounting target numbers that belong to the record number set, are different from the record number of the current subject element record to be verified, and whose coordinate axis belonging value corresponds to the page axis or subject element slot axis are selected to form the non-actual mounting record number set of the current subject element record to be verified, and the number of non-actual mounting record numbers of the current subject element record to be verified is counted. Based on the course element mounting association table, an existence check is performed on row-level associations where both the course element record number and the mounting target number are the record number of the current course element record to be verified. When a row-level association record exists in the course element mounting association table where both the course element record number and the mounting target number are the record number of the current course element record to be verified, an existence flag is generated for the current course element record to be verified, and the count value of the self-mounting flag of the current course element record to be verified is set to one. When a row-level association record does not exist in the course element mounting association table where both the course element record number and the mounting target number are the record number of the current course element record to be verified, a non-existence flag is generated for the current course element record to be verified, and the count value of the self-mounting flag of the current course element record to be verified is set to zero. Compare the number of elements in the multiset of original mounted target numbers of the current subject element record to the sum of the number of non-self actual mounted record numbers of the current subject element record and the count of the self-mounting flag of the current subject element record. If the number of elements in the multiset of original mounted target numbers of the current subject element record is greater than the sum of the count of non-self actual mounted record numbers of the current subject element record and the count of the self-mounting flag of the current subject element record, an illegal mounting flag is generated for the current subject element record. If the number of elements in the multiset of original mounted target numbers of the current subject element record is not greater than the sum of the count of non-self actual mounted record numbers of the current subject element record and the count of the self-mounting flag of the current subject element record, an illegal mounting flag is generated for the current subject element record. When the illegal mounting flag of the current subject element record to be verified is a legal flag, the self-mounting flag of the current subject element record to be verified is a non-existent flag, and the number of non-self actual mounted record numbers of the current subject element record to be verified is one, the mounting usable flag of the current subject element record to be verified is generated as an usable flag; when the illegal mounting flag of the current subject element record to be verified is an illegal flag, or the self-mounting flag of the current subject element record to be verified is an existing flag, or the number of non-self actual mounted record numbers of the current subject element record to be verified is not one, the mounting usable flag of the current subject element record to be verified is generated as an unusable flag. When the number of non-self-attached record numbers of the current subject element record to be verified is greater than zero, the record numbers in the set of non-self-attached record numbers of the current subject element record to be verified are compared with the minimum value, and the record number with the smallest record number is generated as the actual mounting base point number of the current subject element record to be verified; when the number of non-self-attached record numbers of the current subject element record to be verified is zero, the actual mounting base point number of the current subject element record to be verified is generated based on the virtual calculation root record number. Based on the mounting availability flag of the current subject element record to be verified, the actual mounting coordinates are mapped; when the mounting availability flag of the current subject element record to be verified is an available flag, the four-dimensional subject element structure coordinates of the record corresponding to the actual mounting base point number of the current subject element record to be verified are mapped to the actual mounting coordinates of the current subject element record; when the mounting availability flag of the current subject element record to be verified is an unavailable flag, the four-dimensional subject element structure coordinates corresponding to the valid parent record number of the current subject element record to be verified are mapped to the actual mounting coordinates of the current subject element record. The effective parent domain of the current course element record to be verified is constructed based on the subdomain formed by using the effective parent record number of the current course element record to be verified as the root record number of the subdomain. Boundary construction is performed based on the structural coordinate components of each database record in the effective parent domain of the current course element record to be verified on each coordinate axis. For each coordinate axis, the coordinate axis in which boundary construction is being performed is taken as the current enumerated coordinate axis. The minimum value of the structural coordinate components of each database record in the effective parent domain of the current course element record to be verified on the current enumerated coordinate axis is taken as the lower bound of the effective parent domain of the current course element record to be verified on the current enumerated coordinate axis, and the maximum value of the structural coordinate components of each database record in the effective parent domain of the current course element record to be verified on the current enumerated coordinate axis is taken as the upper bound of the effective parent domain of the current course element record to be verified on the current enumerated coordinate axis.

7. The database-based digital textbook course data consistency verification method according to claim 6, characterized in that, The process of comparing the actual mounted coordinates with the lower and upper bounds of the effective parent domain, calculating coordinate differences, and converting grid spacing to generate the effective parent domain boundary consistency value, coordinate axis offset, total element offset, and parent domain grid spacing tolerance specifically includes: Based on the mounting availability flag of the current subject element record to be verified, the actual mounting coordinates of the current subject element record to be verified, and the lower and upper bounds of the effective parent domains of the current subject element record to be verified on each coordinate axis, a boundary consistency value is generated for the effective parent domain of the current subject element record to be verified. If the mounting availability flag of the current subject element record to be verified is available, and the components of the actual mounting coordinates of the current subject element record to be verified on each coordinate axis are all located between the lower and upper bounds of the effective parent domains of the current subject element record to be verified on the same coordinate axis, a consistency value is generated for the effective parent domain boundary of the current subject element record to be verified. Otherwise, an inconsistency value is generated for the effective parent domain boundary consistency of the current subject element record to be verified. For each subject element record to be verified and each coordinate axis, when the mounting availability flag of the current subject element record to be verified is available, the component of the actual mounting coordinate of the current subject element record to be verified on the current enumerated coordinate axis is subtracted from the component of the subject element's proper location coordinate on the current enumerated coordinate axis to calculate the coordinate axis offset of the current subject element record to be verified on the current enumerated coordinate axis; when the mounting availability flag of the current subject element record to be verified is unavailable, the coordinate axis offset of the current subject element record to be verified on the current enumerated coordinate axis is set to one. For each lesson element record to be verified, the coordinate axis offsets of the current lesson element record to be verified on the unit axis, section axis, page axis and lesson element slot axis are added together and divided by four. The average is then used to form the total lesson element offset of the current lesson element record to be verified. For each lesson element record to be verified and each coordinate axis, compare the upper bound of the effective parent domain of the current lesson element record to be verified with the lower bound of the effective parent domain of the current enumerated coordinate axis. When the upper bound of the effective parent domain of the current lesson element record to be verified is greater than the lower bound of the effective parent domain of the current enumerated coordinate axis, generate an activity indicator for the parent domain of the current lesson element record to be verified as an activity flag. When the upper bound of the effective parent domain of the current lesson element record to be verified is not greater than the lower bound of the effective parent domain of the current enumerated coordinate axis, generate an inactive indicator for the parent domain of the current lesson element record to be verified as an inactive flag. For each lesson element record to be verified and each coordinate axis, the number of records with the same parent and axis as the current enumerated extended record number, based on the previous statistics, is converted using the effective parent record number of the current lesson element record to be verified as the current enumerated extended record number, and the coordinate axis affiliation value of the child record corresponding to the current enumerated coordinate axis. When the activity indicator of the parent domain of the current lesson element record to be verified is an activity identifier, the number of records with the same parent and axis as the current enumerated coordinate axis, based on the previous statistics, is converted using the effective parent record number of the current lesson element record to be verified as the current enumerated extended record number, and the coordinate axis affiliation value of the child record corresponding to the current enumerated coordinate axis. The number of records on the same parent axis during axis calibration is increased by one to form the denominator for the grid spacing conversion. Then, two is divided by the grid spacing conversion denominator to convert and form the single-axis grid spacing tolerance of the current subject element record to be verified on the current enumerated coordinate axis. When the parent domain activity indicator of the current subject element record to be verified on the current enumerated coordinate axis is an inactive indicator, the single-axis grid spacing tolerance of the current subject element record to be verified on the current enumerated coordinate axis is set to zero. The single-axis grid spacing tolerances of the current subject element record to be verified on the four coordinate axes are added together and divided by four. After averaging, the parent domain grid spacing tolerance of the current subject element record to be verified is formed.

8. The database-based digital textbook course data consistency verification method according to claim 7, characterized in that, The process generates consistency anomaly flags, anomaly type labels, recommended location node numbers, and single-element verification results based on the parent record's legality flag, valid parent domain boundary consistency value, total lesson element offset, and parent domain grid spacing tolerance. Specifically, this includes: For each lesson element record to be verified, anomaly combination judgment is performed based on the parent record validity flag, the valid parent domain boundary consistency value, the total lesson element offset, and the parent domain grid spacing tolerance of the current lesson element record. If the parent record validity flag is valid, the valid parent domain boundary consistency value is consistent, and the total lesson element offset is not greater than the parent domain grid spacing tolerance, a consistency anomaly flag of the current lesson element record is generated as a pass flag; otherwise, an consistency anomaly flag of the current lesson element record is generated as an anomaly flag. When the consistency anomaly flag of the current subject element record to be verified is "pass", the anomaly type label of the current subject element record to be verified is "no anomaly". When the consistency exception flag of the current subject element record to be verified is an exception identifier and the parent record validity flag of the current subject element record to be verified is an illegal identifier, the exception type label of the current subject element record to be verified is generated as declaring the parent record as an illegal exception. When the consistency anomaly flag of the current subject element record to be verified is an anomaly flag, the parent record validity flag of the current subject element record to be verified is a validity flag, and the mounting availability flag of the current subject element record to be verified is an unavailable flag, the anomaly type label of the current subject element record to be verified is generated as mounting relationship anomaly. When the consistency anomaly flag of the current subject element record to be verified is an anomaly flag, the parent record of the current subject element record to be verified is a valid flag, the mounting availability flag of the current subject element record to be verified is an available flag, the valid parent domain boundary consistency value of the current subject element record to be verified is an inconsistent flag, and the total offset of the subject element of the current subject element record to be verified is not greater than the parent domain grid spacing allowable amount of the current subject element record to be verified, the anomaly type label of the current subject element record to be verified is valid parent domain out of bounds anomaly. When the consistency anomaly flag of the current subject element record to be verified is an anomaly flag, the parent record of the current subject element record to be verified is a valid flag, the mounting availability flag of the current subject element record to be verified is an available flag, the valid parent domain boundary consistency value of the current subject element record to be verified is a consistency flag, and the total offset of the subject element of the current subject element record to be verified is greater than the parent domain grid spacing allowable amount, the anomaly type label of the current subject element record to be verified is generated as coordinate offset anomaly. When the consistency anomaly flag of the current subject element record to be verified is an anomaly flag, the parent record of the current subject element record to be verified is a valid flag, the mounting availability flag of the current subject element record to be verified is an available flag, the valid parent domain boundary consistency value of the current subject element record to be verified is an inconsistent flag, and the total offset of the subject element of the current subject element record to be verified is greater than the parent domain grid spacing allowable amount, the anomaly type label of the current subject element record to be verified is generated as a composite anomaly of valid parent domain out of bounds and coordinate offset. Within a subdomain formed by using the valid parent record number of the current subject element record to be verified as the root record number of the subdomain, candidate records are filtered. The record number of the candidate record is different from the record number of the current subject element record to be verified, and the coordinate axis of the candidate record corresponds to the page axis or the subject element slot axis, thus forming a set of recommended positioning candidate records for the current subject element record to be verified. When the set of recommended candidate records for the current subject element to be verified is not empty, for each candidate record in the set, the absolute values ​​of the differences between the four-dimensional subject element structure coordinates of the candidate record and the subject element location coordinates of the current subject element to be verified on each coordinate axis are summed to form the coordinate distance of the candidate record. The coordinate distances of the candidate records are then compared to find the minimum value, and the record number of the candidate record with the smallest coordinate distance is used as the recommended positioning node number of the current subject element to be verified. When there are multiple candidate records with the smallest coordinate distance, the record numbers of the multiple candidate records with the smallest coordinate distance are compared to find the minimum value, and the record number of the candidate record with the smallest record number is used as the recommended positioning node number of the current subject element to be verified. When the set of recommended candidate records for the current subject element to be verified is empty, the recommended positioning node number of the current subject element to be verified is generated based on the effective parent record number of the current subject element to be verified. The single-element verification result of the current subject element record is formed by assembling the record number, the declared parent record number, the valid parent record number, the actual mounting base point number, the parent record validity flag, the mounting availability flag, the valid parent domain boundary consistency value, the consistency anomaly flag, the anomaly type label, the total subject element offset, the parent domain grid spacing tolerance, and the recommended positioning node number.

9. A database-based digital textbook course data consistency verification method according to claim 8, characterized in that, The process involves collecting all individual lesson verification results to form a course-level verification result set, filtering to form an abnormal result set, and statistically analyzing and outputting the number of passed and abnormal results. Specifically, this includes: Based on the set of course element records to be verified, the single course element verification results corresponding to each course element record to be verified are collected to form a course-level verification result set. In the course-level verification result set, filter out the single-course element verification results whose consistency anomaly flag is an anomaly identifier in the single-course element verification results to form an anomaly result set; In the course-level verification result set, count the number of single-course element verification results with consistency anomaly flags marked as passed in the single-course element verification results, and form the number of passed verifications; In the course-level verification result set, count the number of single-course unit verification results with consistency anomaly flags in the single-course unit verification results to form the anomaly count; The output includes the number of validations and the number of exceptions.

Images