CN113407811A - Table dividing method and device for learning platform, computer equipment and storage medium - Google Patents
Table dividing method and device for learning platform, computer equipment and storage medium Download PDFInfo
- Publication number
- CN113407811A CN113407811A CN202110761409.5A CN202110761409A CN113407811A CN 113407811 A CN113407811 A CN 113407811A CN 202110761409 A CN202110761409 A CN 202110761409A CN 113407811 A CN113407811 A CN 113407811A
- Authority
- CN
- China
- Prior art keywords
- student
- identification
- sub
- learning
- registration
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 37
- 238000003860 storage Methods 0.000 title claims abstract description 15
- 238000004590 computer program Methods 0.000 claims description 20
- 238000012423 maintenance Methods 0.000 claims description 10
- 238000000605 extraction Methods 0.000 claims description 4
- 238000003780 insertion Methods 0.000 claims description 3
- 230000037431 insertion Effects 0.000 claims description 3
- 230000006870 function Effects 0.000 abstract description 9
- 238000010586 diagram Methods 0.000 description 13
- 230000008569 process Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 239000012634 fragment Substances 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/906—Clustering; Classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
- G06Q50/205—Education administration or guidance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Educational Administration (AREA)
- Educational Technology (AREA)
- Data Mining & Analysis (AREA)
- Tourism & Hospitality (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention provides a method and a device for dividing tables of a learning platform, computer equipment and a storage medium, wherein the method comprises the following steps: acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information; performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information; the common functions of the learning platform trainees need to be classified into a library and a table, a specific table dividing strategy is made according to the service characteristics, and data are stored separately according to the specific strategy. The data volume of the single table is reduced, the performance is improved, the problem that the performance of the learning platform is poor under big data is solved, and the stability and the load capacity of the learning platform are also improved. The specific table dividing strategy is customized for the general large data volume service of the learning platform, so that all services are not influenced by the database dividing table while the learning platform introduces the Sharding-JDBC database dividing table.
Description
Technical Field
The present invention relates to the field of mechanical technology, and in particular, to a method and apparatus for separating tables on a learning platform, a computer device, and a storage medium.
Background
The training and learning of enterprises on the Internet needs to be greatly increased, the learning data volume of students of the online learning platform is also greatly increased, and the performance of the database is seriously influenced when the data of a single form is more than ten million, so that the problem of solving the performance of the database is urgently inevitable,
when the data of a table reaches tens of millions, the time taken to query once becomes long. At this time, if there is a join query, it may get stuck there and even bring the system down. When the learning data of the traditional learning platform is increased sharply, if the database and the table are not introduced, the performance bottleneck of the database can be reached if the number of the single tables is too large, and the performance of the learning platform is poor. And the sub-tables and the sub-libraries are introduced into a learning platform, so that the performance problem caused by the sudden increase of learning data is solved.
Disclosure of Invention
In view of the above problems, embodiments of the present invention are proposed to provide a table splitting method of a learning platform, a table splitting apparatus of a learning platform, a computer device and a storage medium that overcome or at least partially solve the above problems.
In order to solve the above problems, an embodiment of the present invention discloses a table division method for a learning platform, including:
acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information;
and performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information.
Preferably, the performing a spreadsheet division operation on data according to the trainee identifier, the course identifier, the trainee entry identifier, the login log information, the system operation record, and the mail information includes:
creating a student registration form sublist taking student identification as a sublist field, an index table taking course identification as a sublist field and an index table taking student registration identification as a sublist field;
when new, modified and deleted, maintaining the data in the index table;
inserting the original student registration data into the corresponding sub-tables;
creating a student learning record table with student identification as a table division field and an index table with course identification as a table division field;
when the student learning data is newly created, modified and deleted, the data is maintained in an index table;
inserting the learning data of the original learner into the corresponding branch table;
inquiring all registration records and learning records of the course according to the course identification, modifying into inquiring an index table according to the branch table of the course identification, inquiring all student identifications according to the index table, and inquiring the detailed information of the student registration/learning record table at one time according to all student identifications.
According to the student registration mark inquiry student registration and learning record inquiry index table according to student registration mark sub-table also firstly, according to the student registration mark inquiry index table, after the student mark is inquired according to index table, the student registration table sub-table/learning record table sub-table according to student mark sub-table inquiry is inquired, so that the detailed registration record and learning record can be obtained.
Preferably, the performing a spreadsheet division operation on data according to the trainee identifier, the course identifier, the trainee entry identifier, the login log information, the system operation record, and the mail information includes:
creating a student login log table sub-table with login time as a sub-table field;
and when the login time is the accurate time value, extracting the month information in the user login recording time, and distributing the login log information of the corresponding month to the student login log table sublist.
And when the login time is the range time value, comparing the login time of all the users, and extracting a maximum monthly value sublist and a minimum monthly value sublist.
Preferably, the performing a spreadsheet division operation on data according to the trainee identifier, the course identifier, the trainee entry identifier, the login log information, the system operation record, and the mail information includes:
creating a system operation log table sub-table with operation time as a sub-table field;
and when the operation time is the accurate time value, extracting the month information in the operation time, and distributing the system operation records of the corresponding month into the system operation log table.
And when the operation time is the range time value, comparing all the operation times, and extracting a maximum monthly score sublist and a minimum monthly score sublist.
Preferably, the performing a spreadsheet division operation on data according to the trainee identifier, the course identifier, the trainee entry identifier, the login log information, the system operation record, and the mail information includes:
creating a system mail list sub-list with recipient identification as a sub-list field;
and classifying the system mails into a system mail list according to the preset number.
The embodiment of the invention discloses a sub-meter device of a learning platform, which comprises:
the acquisition module is used for acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information;
and the sub-table operation module is used for performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information.
Preferably, the sub-table operation module includes:
the first creating submodule is used for creating a student entry form sublist taking student identification as a sublist field, an index form taking course identification as a sublist field and an index form taking student entry identification as a sublist field;
the first maintenance sub-module is used for maintaining the data in the index table when newly creating, modifying and deleting the entry data;
the first inserting submodule is used for inserting the original student registration data into the corresponding sub-tables;
the second creating sub-module is used for creating a student learning record table with student identification as a table dividing field and an index table with course identification as a table dividing field;
the second maintenance sub-module is used for maintaining the data in the index table when creating, modifying and deleting the student learning data;
the second insertion submodule is used for inserting the learning data of the original learner into the corresponding sub-table;
and the query submodule is used for querying all registration records and learning records of the course according to the course identification, modifying the query into a first query of an index table according to the branch table of the course identification, querying all student identifications according to the index table, and then querying detailed information of registration/learning of students in the registration/learning record table at one time according to all student identifications.
And the acquisition submodule is used for inquiring the student registration and the learning record according to the student registration identification, and also inquiring the index table according to the student registration identification sub-table, inquiring the student registration table/learning record table sub-table according to the student registration identification sub-table after the student identification is inquired according to the index table, and acquiring detailed registration record and learning record.
Preferably, the sub-table operation module includes:
the third creating submodule is used for creating a student login log table sub-table with login time as a sub-table field;
and the first allocation submodule is used for extracting the month information in the user login recording time when the login time is the accurate time value, and then allocating the login log information of the corresponding month to the student login log table.
And the first extraction submodule is used for comparing the login time of all the users when the login time is the range time value, and extracting a maximum monthly value sublist and a minimum monthly value sublist.
The embodiment of the invention discloses computer equipment, which comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps of the table dividing method of the learning platform when executing the computer program.
The embodiment of the invention discloses a computer readable storage medium, which stores a computer program, wherein the computer program realizes the steps of the table dividing method of the learning platform when being executed by a processor.
The embodiment of the invention has the following advantages:
in the embodiment of the invention, the table dividing method of the learning platform comprises the following steps: acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information; performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information; the common functions of the learning platform trainees need to be classified into a library and a table, a specific table dividing strategy is made according to the service characteristics, and data are stored separately according to the specific strategy. The data volume of the single table is reduced, the performance is improved, the problem that the performance of the learning platform is poor under big data is solved, and the stability and the load capacity of the learning platform are also improved. The learning platform is analyzed in detail, a specific table dividing strategy is customized for general large-data-volume services of the learning platform, and all services are not influenced by the database dividing table while the learning platform introduces the Sharding-JDBC database dividing table.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on the drawings without creative efforts
FIG. 1 is a flowchart illustrating steps of an embodiment of a table-splitting method for a learning platform according to an embodiment of the present invention;
FIG. 2 is a block diagram of an embodiment of a sub-table apparatus of a learning platform according to an embodiment of the present invention;
FIG. 3 is an internal block diagram of a computer device of an embodiment.
Detailed Description
In order to make the technical problems, technical solutions and advantageous effects solved by the embodiments of the present invention more clearly apparent, the embodiments of the present invention are described in further detail below with reference to the accompanying drawings and the embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, a flowchart illustrating steps of an embodiment of a table splitting method of a learning platform according to an embodiment of the present invention is shown, which may specifically include the following steps:
step 101, acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information;
the spreadsheet method in the embodiment of the present invention may be applied to a learning platform, and the learning platform may be run on various terminals, such as a Personal Computer (PC), a smart Phone, a tablet Computer, and other terminals that may be installed with an application program, for example, a smart watch, and the like.
First, various information related to login to operation from the learning platform, such as student identification, course identification, student registration identification, login log information, system operation record, and mail information, may be obtained.
And 102, performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information.
Furthermore, after the student identification, the course identification, the student registration identification, the log information, the system operation record and the mail information are obtained, the data can be sorted.
Specifically, the sub-tabulation operation is performed on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information, and the sub-steps include:
step 11, creating a student registration form sublist taking student identification as a sublist field, an index table taking course identification as a sublist field and an index table taking student registration identification as a sublist field;
step 12, when new, modified and deleted, maintaining the data in the index table;
step 13, inserting the original student registration data into the corresponding sub-tables;
step 14, creating a student learning record table with student identification as a table division field and an index table with course identification as a table division field;
step 15, when newly creating, modifying and deleting the student learning data, maintaining the data in an index table;
step 16, inserting the learning data of the original trainees into the corresponding branch tables;
and step 17, inquiring all registration records and learning records of the course according to the course identification, modifying to firstly inquire an index table according to the branch table of the course identification, inquiring all student identifications according to the index table, and then inquiring detailed information of the student registration/learning record table according to all student identifications in one step.
And step 18, inquiring the student registration and the learning record according to the student registration identification, and inquiring the index table according to the student registration identification sub-table, after inquiring the student identification according to the index table, inquiring the student registration table/learning record table sub-table according to the student identification sub-table, and obtaining the registration record and the learning record.
In the embodiment of the invention, various tables and index tables can be established first, and then corresponding data sorting is carried out to obtain entry data, learning data and the like after the tables are divided.
The method and the device are further applied to the embodiment of the invention, the sub-tables can be various sub-tables, such as student entry sub-tables, student learning record sub-tables and the like, and other types of sub-tables can be included, and the embodiment of the invention does not excessively limit the types of the sub-tables.
On the other hand, an index table corresponding to each sub-table can be established, so that the corresponding sub-table can be searched conveniently, and the convenience of the system is improved.
In a preferred embodiment of the present invention, the performing table splitting operation on data according to the trainee identifier, the course identifier, the trainee registration identifier, the login log information, the system operation record, and the mail information includes the following sub-steps:
step 21, creating a student login log table sub-table with login time as a sub-table field;
and step 22, when the login time is the accurate time value, extracting the month information in the user login recording time, and distributing the login log information of the corresponding month to the student login log table sublist.
And step 23, when the login time is the range time value, comparing the login time of all users, and extracting a maximum monthly score sublist and a minimum monthly score sublist.
Specifically, the log information can be sorted, a corresponding sorting table is created firstly, and the log logs of different months are classified according to different time points or time ranges; on the other hand, when the login time is only the range time value, namely the time range, a maximum month score sublist and a minimum month score sublist are established, and corresponding data are extracted to the maximum month score sublist and the minimum month score sublist.
Further applied to the embodiment of the present invention, the performing table splitting operation on data according to the trainee identifier, the course identifier, the trainee registration identifier, the login log information, the system operation record and the mail information includes the following sub-steps:
step 31, creating a system operation log table sub-table with operation time as a sub-table field;
and step 32, when the operation time is the accurate time value, extracting the month information in the operation time, and distributing the system operation records of the corresponding month to the system operation log table.
And step 33, when the operation time is the range time value, comparing all the operation times, and extracting a maximum monthly score sub-table and a minimum monthly score sub-table.
Meanwhile, the operation time, i.e. the system operation record, may also establish a corresponding sub-table, i.e. a system operation log table sub-table, and also with the operation time as a determination condition, when the operation time is an accurate time value, i.e. a time point, corresponding month information, e.g. 1 month, 2 months, 3 months, etc., may be extracted, and then the system operation record may be allocated to the system operation log table sub-table of the corresponding month.
And when the operation time is within a time range, comparing all the operation times, and extracting a maximum monthly score sub-table and a minimum monthly score sub-table.
Specifically, in the embodiment of the present invention, the performing table division operation on data according to the trainee identifier, the course identifier, the trainee entry identifier, the login log information, the system operation record, and the mail information includes:
step 41, creating a system mail list sub-list with the recipient identification as a sub-list field;
and 42, dividing the system mails into system mail list sub-lists according to the preset number.
In the embodiment of the invention, the mail information can be sorted, the recipient identification is firstly established as the system mail table sorting table of the sorting table field, after the corresponding sorting table is established, the sorting table of the system mail can be sorted by the preset number, if the remainder of the recipient identification pair 8 is 1, the sorting table is distributed to the first sorting table, and if the remainder of the recipient identification pair 8 is 2, the sorting table is distributed to the second sorting table, and so on.
In the embodiment of the invention, the table dividing method of the learning platform comprises the following steps: acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information; performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information; the common functions of the learning platform trainees need to be classified into a library and a table, a specific table dividing strategy is made according to the service characteristics, and data are stored separately according to the specific strategy. The data volume of the single table is reduced, the performance is improved, the problem that the performance of the learning platform is poor under big data is solved, and the stability and the load capacity of the learning platform are also improved. The learning platform is analyzed in detail, a specific table dividing strategy is customized for general large-data-volume services of the learning platform, and all services are not influenced by the database dividing table while the learning platform introduces the Sharding-JDBC database dividing table.
In order that those skilled in the art will better understand the embodiments of the present invention, the following description is given by way of a specific example:
the method comprises the steps of analyzing the services of a learning platform in detail, extracting a table with large data volume in the services, a student registration table, a student learning record table, a user login and login record table, a system operation record table and a system mail table, and performing library and table division by using a Sharding-JDBC technology. The traditional learning platform will face the database performance problem caused by data surge if the traditional learning platform does not carry out database-dividing and table-dividing operations.
A. Student registration form and student learning record form branch form: according to the service logic of the course of the learning platform, a student registration table and a student learning record table are sorted according to three common dimensions, namely student id, course id and student registration id, wherein the student id dimension sorting is carried out on an original student registration table and the student learning record table and is split into 16 tables, and the tables are distributed to corresponding sorting tables according to the rule of 16% of student id. And the course id dimension is divided by newly creating an index table, the index table only comprises index fields such as student id and course id, the maintenance complexity is reduced, the index table is also divided into 16 tables, and the 16 tables are distributed to the corresponding branch tables according to the rule of course id% 16. And the dimensionality of the last student entry id is also subjected to table splitting through a newly-built index table, the index table only comprises student id and student entry id index fields, the maintenance is convenient, the index table is also split into 16 tables, and the tables are distributed to the corresponding tables according to the rule that the student entry id is 16%. :
B. user login record table division: according to the learning platform user login service logic, a user login record table is divided into 12 tables according to the time dimension, the user login record table is divided into 12 tables according to the month of the last year, data are divided into the corresponding tables according to the current corresponding month, and meanwhile, a new month division table is automatically generated every month through a script database.
C. The system operation record table is divided into tables: according to the learning platform system operation service logic, the system operation record table is divided according to the time dimension, the system operation record table is divided into 12 tables according to the month of the last year, data are divided into the corresponding tables according to the current corresponding month, and meanwhile, a new month division table is automatically generated every month through a script database.
D. And E, sorting the system mail list: according to the mail service logic of the learning platform system, the system operation record table is divided into 8 tables according to the ID dimension of the receiver, and the mail is divided into the corresponding tables according to the ID% 8 rule of the receiver.
Specifically, Sharding-JDBC is integrated, sql passes through the Sharding-JDBC, the Sharding-JDBC rewrites the sql to a sub-library and sub-table for execution through a configuration strategy, the Sharding-JDBC sub-library and sub-table technology is introduced into a learning platform, common services with large data volume in the learning platform are subjected to sub-library and sub-table according to a specific design strategy, and the performance problem caused by data sharp increase of the learning platform is solved. The learning platform can reduce the burden of the database, improve the efficiency of the database and shorten the query time. In addition, because the modification of the sub-database and the sub-table is controllable, the bottom layer is also based on the RDBMS, and therefore the operation and maintenance system of the whole database and the related infrastructure are reusable.
1. Designing specific sub-table strategy according to business logic of most main entry learning function of learning platform
a. Creating a student entry form sublist with student id as sublist field, an index table with course id as sublist field, and an index table with student entry id as sublist field.
b. When new, modified and deleted, the data are maintained in the index table.
c. The program is written to enable the original student registration data to be inserted into the correct sub-table.
d. And creating a student learning record table with student id as a table dividing field and an index table with course id as a table dividing field.
e. When the student learning data is newly created, modified and deleted, the data is maintained in the index table.
f. The program is written to enable the original learner learning data to be inserted into the correct sub-table.
g. According to the course id, all the registration records and learning records of the course are inquired, an index table according to a branch table of the course id is inquired, all student ids are inquired according to the index table, and then the student registration/learning record table is inquired at one time according to all the student ids to find out the detailed registration/learning information.
h. The student registration and learning record inquiry is realized by inquiring the student registration and learning record according to the student registration id, namely inquiring an index table according to a student registration id sub-table, inquiring the student registration/learning record table according to the student id sub-table after the student id is inquired according to the index table, and obtaining the detailed registration record and the learning record.
i. And modifying sql of the learning platform to conform to the grammar supported by Sharding-JDBC, such as removing case and where grammar, removing sub-query statements, and the like.
j. And the algorithm logic is modified, so that the wikid in the configuration file is not required to be modified in different machines in the cluster deployment server, and the maintenance is more convenient.
2. Designing specific sub-table strategy for student login log table according to student login service logic of learning platform
a. Student login log table sub-table for creating login time as sub-table field
b. When the value of the segment field is an accurate value, the month in the user login record time is extracted through the code, and then the month is divided into corresponding segments according to the month
c. When the value of the fragment field is a range, all the user login times are compared in the code, and the maximum monthly score sublist and the minimum monthly score sublist are extracted and returned
3. Designing specific sub-table strategy for operation log of learning platform system
a. System oplog table sub-tables with operation time created as sub-table field
b. When the value of the segment field is an accurate value, the month in the system operation recording time is extracted by the code and then is divided into corresponding segment tables according to the month
c. When the value of the fragment field is a range, all the user login times are compared in the code, and the maximum monthly score sublist and the minimum monthly score sublist are extracted and returned
4. Designing specific sub-table strategy for learning platform system mail
d. System mailing list sublist for creating recipient id as sublist field
e. The system mails are classified into corresponding sub-tables according to the rule of id% 8 of the receiver
f. The recipient id% 8 is the remainder of the recipient id, for example, if the recipient id is 1 and 1% 8 is 1, then the recipient mail will be assigned to the webmessage _1 table.
It should be noted that, for simplicity of description, the method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the illustrated order of acts, as some steps may occur in other orders or concurrently in accordance with the embodiments of the present invention. Further, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred and that no particular act is required to implement the invention.
Referring to fig. 2, a block diagram of a sub-table apparatus of a learning platform according to an embodiment of the present invention is shown, and specifically includes the following modules:
an obtaining module 301, configured to obtain a student identifier, a course identifier, a student registration identifier, log information, a system operation record, and mail information;
and the sub-table operation module 302 is configured to perform sub-table operation on data according to the student identifier, the course identifier, the student registration identifier, the login log information, the system operation record, and the mail information.
Preferably, the sub-table operation module includes:
the first creating submodule is used for creating a student entry form sublist taking student identification as a sublist field, an index form taking course identification as a sublist field and an index form taking student entry identification as a sublist field;
the first maintenance sub-module is used for maintaining the data in the index table when newly creating, modifying and deleting the entry data;
the first inserting submodule is used for inserting the original student registration data into the corresponding sub-tables;
the second creating sub-module is used for creating a student learning record table with student identification as a table dividing field and an index table with course identification as a table dividing field;
the second maintenance sub-module is used for maintaining the data in the index table when creating, modifying and deleting the student learning data;
the second insertion submodule is used for inserting the learning data of the original learner into the corresponding sub-table;
and the query submodule is used for querying all registration records and learning records of the course according to the course identification, modifying the query into a first query of an index table according to the branch table of the course identification, querying all student identifications according to the index table, and then querying detailed information of registration/learning of students in the registration/learning record table at one time according to all student identifications.
And the acquisition submodule is used for inquiring the student registration and the learning record according to the student registration identification, and also inquiring the index table according to the student registration identification sub-table, inquiring the student registration table/learning record table sub-table according to the student registration identification sub-table after the student identification is inquired according to the index table, and acquiring detailed registration record and learning record.
Preferably, the sub-table operation module includes:
the third creating submodule is used for creating a student login log table sub-table with login time as a sub-table field;
and the first allocation submodule is used for extracting the month information in the user login recording time when the login time is the accurate time value, and then allocating the login log information of the corresponding month to the student login log table.
And the first extraction submodule is used for comparing the login time of all the users when the login time is the range time value, and extracting a maximum monthly value sublist and a minimum monthly value sublist.
Preferably, the sub-table operation module includes:
the fourth creating submodule is used for creating a system operation log table sub-table with operation time as a sub-table field;
and the second distribution submodule is used for extracting the month information in the operation time and distributing the system operation records of the corresponding month to the system operation log table when the operation time is the accurate time value.
And the second extraction submodule is used for comparing all the operation time when the operation time is the range time value, and extracting a maximum monthly value sublist and a minimum monthly value sublist.
Preferably, the sub-table operation module includes:
the fifth creating submodule is used for creating a system mail list sub-list with the recipient identification as a sub-list field;
and the table sub-module is used for dividing the system mails into the system mail table sub-tables according to the preset number.
All or part of each module in the sub-table device of the learning platform can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
The table dividing device of the learning platform can be used for executing the table dividing method of the learning platform provided by any embodiment, and has corresponding functions and beneficial effects.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 3. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a spreadsheet method for a learning platform. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 3 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory having a computer program stored therein and a processor implementing the steps of the embodiment of fig. 1 when executing the computer program.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor implements the steps of the embodiment of fig. 1 below.
The embodiments in the present specification are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing terminal to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing terminal to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing terminal to cause a series of operational steps to be performed on the computer or other programmable terminal to produce a computer implemented process such that the instructions which execute on the computer or other programmable terminal provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present invention have been described, additional variations and modifications of these embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the embodiments of the invention.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or terminal. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or terminal that comprises the element.
The table dividing method of the learning platform, the table dividing device of the learning platform, the computer device and the storage medium provided by the invention are described in detail, specific examples are applied in the text to explain the principle and the implementation of the invention, and the description of the above embodiments is only used to help understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (10)
1. A method for dividing a table of a learning platform is characterized by comprising the following steps:
acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information;
and performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information.
2. The method for grouping tables of a learning platform according to claim 1, wherein the grouping table operation for data according to the student identification, the course identification, the student registration identification, the log information, the system operation record and the mail information comprises:
creating a student registration form sublist taking student identification as a sublist field, an index table taking course identification as a sublist field and an index table taking student registration identification as a sublist field;
when new, modified and deleted, maintaining the data in the index table;
inserting the original student registration data into the corresponding sub-tables;
creating a student learning record table with student identification as a table division field and an index table with course identification as a table division field;
when the student learning data is newly created, modified and deleted, the data is maintained in an index table;
inserting the learning data of the original learner into the corresponding branch table;
inquiring all registration records and learning records of the course according to the course identification, modifying into inquiring an index table according to the branch table of the course identification, inquiring all student identifications according to the index table, and inquiring the detailed information of the student registration/learning record table at one time according to all student identifications.
According to the student registration mark inquiry student registration and learning record inquiry index table according to student registration mark sub-table also firstly, according to the student registration mark inquiry index table, after the student mark is inquired according to index table, the student registration table sub-table/learning record table sub-table according to student mark sub-table inquiry is inquired, so that the detailed registration record and learning record can be obtained.
3. The method for grouping tables of a learning platform according to claim 1, wherein the grouping table operation for data according to the student identification, the course identification, the student registration identification, the log information, the system operation record and the mail information comprises:
creating a student login log table sub-table with login time as a sub-table field;
and when the login time is the accurate time value, extracting the month information in the user login recording time, and distributing the login log information of the corresponding month to the student login log table sublist.
And when the login time is the range time value, comparing the login time of all the users, and extracting a maximum monthly value sublist and a minimum monthly value sublist.
4. The method for grouping tables of a learning platform according to claim 1, wherein the grouping table operation for data according to the student identification, the course identification, the student registration identification, the log information, the system operation record and the mail information comprises:
creating a system operation log table sub-table with operation time as a sub-table field;
and when the operation time is the accurate time value, extracting the month information in the operation time, and distributing the system operation records of the corresponding month into the system operation log table.
And when the operation time is the range time value, comparing all the operation times, and extracting a maximum monthly score sublist and a minimum monthly score sublist.
5. The method for grouping tables of a learning platform according to claim 1, wherein the grouping table operation for data according to the student identification, the course identification, the student registration identification, the log information, the system operation record and the mail information comprises:
creating a system mail list sub-list with recipient identification as a sub-list field;
and classifying the system mails into a system mail list according to the preset number.
6. A sub-table apparatus of a learning platform, comprising:
the acquisition module is used for acquiring student identification, course identification, student registration identification, login log information, system operation record and mail information;
and the sub-table operation module is used for performing sub-table operation on data according to the student identification, the course identification, the student registration identification, the login log information, the system operation record and the mail information.
7. The table splitting apparatus of the learning platform of claim 6, wherein the table splitting operation module comprises:
the first creating submodule is used for creating a student entry form sublist taking student identification as a sublist field, an index form taking course identification as a sublist field and an index form taking student entry identification as a sublist field;
the first maintenance sub-module is used for maintaining the data in the index table when newly creating, modifying and deleting the entry data;
the first inserting submodule is used for inserting the original student registration data into the corresponding sub-tables;
the second creating sub-module is used for creating a student learning record table with student identification as a table dividing field and an index table with course identification as a table dividing field;
the second maintenance sub-module is used for maintaining the data in the index table when creating, modifying and deleting the student learning data;
the second insertion submodule is used for inserting the learning data of the original learner into the corresponding sub-table;
and the query submodule is used for querying all registration records and learning records of the course according to the course identification, modifying the query into a first query of an index table according to the branch table of the course identification, querying all student identifications according to the index table, and then querying detailed information of registration/learning of students in the registration/learning record table at one time according to all student identifications.
And the acquisition submodule is used for inquiring the student registration and the learning record according to the student registration identification, and also inquiring the index table according to the student registration identification sub-table, inquiring the student registration table/learning record table sub-table according to the student registration identification sub-table after the student identification is inquired according to the index table, and acquiring detailed registration record and learning record.
8. The table splitting apparatus of the learning platform of claim 6, wherein the table splitting operation module comprises:
the third creating submodule is used for creating a student login log table sub-table with login time as a sub-table field;
and the first allocation submodule is used for extracting the month information in the user login recording time when the login time is the accurate time value, and then allocating the login log information of the corresponding month to the student login log table.
And the first extraction submodule is used for comparing the login time of all the users when the login time is the range time value, and extracting a maximum monthly value sublist and a minimum monthly value sublist.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the table splitting method of the learning platform of any one of claims 1 to 5.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the table splitting method of the learning platform of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110761409.5A CN113407811A (en) | 2021-07-06 | 2021-07-06 | Table dividing method and device for learning platform, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110761409.5A CN113407811A (en) | 2021-07-06 | 2021-07-06 | Table dividing method and device for learning platform, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113407811A true CN113407811A (en) | 2021-09-17 |
Family
ID=77685225
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110761409.5A Pending CN113407811A (en) | 2021-07-06 | 2021-07-06 | Table dividing method and device for learning platform, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113407811A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107818115A (en) * | 2016-09-14 | 2018-03-20 | 苏宁云商集团股份有限公司 | A kind of method and device of processing data table |
| CN108428203A (en) * | 2017-11-15 | 2018-08-21 | 平安科技（深圳）有限公司 | Training registration management method, application server and computer readable storage medium |
| CN110597852A (en) * | 2019-09-27 | 2019-12-20 | 腾讯科技（深圳）有限公司 | Data processing method, device, terminal and storage medium |
| CN111010336A (en) * | 2019-12-18 | 2020-04-14 | 写逸网络科技(上海)有限公司 | Massive mail analysis method and device |
| CN112000825A (en) * | 2020-08-25 | 2020-11-27 | 浪潮云信息技术股份公司 | Method and system for establishing electronic license storage model based on sub-warehouse and sub-table |
-
2021
- 2021-07-06 CN CN202110761409.5A patent/CN113407811A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107818115A (en) * | 2016-09-14 | 2018-03-20 | 苏宁云商集团股份有限公司 | A kind of method and device of processing data table |
| CN108428203A (en) * | 2017-11-15 | 2018-08-21 | 平安科技（深圳）有限公司 | Training registration management method, application server and computer readable storage medium |
| CN110597852A (en) * | 2019-09-27 | 2019-12-20 | 腾讯科技（深圳）有限公司 | Data processing method, device, terminal and storage medium |
| CN111010336A (en) * | 2019-12-18 | 2020-04-14 | 写逸网络科技(上海)有限公司 | Massive mail analysis method and device |
| CN112000825A (en) * | 2020-08-25 | 2020-11-27 | 浪潮云信息技术股份公司 | Method and system for establishing electronic license storage model based on sub-warehouse and sub-table |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10095780B2 (en) | Automatically mining patterns for rule based data standardization systems | |
| CN107168991B (en) | Search result display method and device | |
| US20170212945A1 (en) | Branchable graph databases | |
| CN110162516B (en) | Data management method and system based on mass data processing | |
| CN110442585B (en) | Data updating method, data updating device, computer equipment and storage medium | |
| CN103678362A (en) | Search method and search system | |
| CN112115113B (en) | Data storage system, method, device, equipment and storage medium | |
| CN105095436A (en) | Automatic modeling method for data of data sources | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| JPWO2019123703A1 (en) | Data analysis support device, data analysis support method and data analysis support program | |
| CN109214640B (en) | Method and device for determining index result and computer readable storage medium | |
| CN110879808A (en) | Information processing method and device | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN105447073A (en) | Tag adding apparatus and tag adding method | |
| CN113342921A (en) | Resource cataloging method and device | |
| US20090144318A1 (en) | System for searching research data | |
| CN108520012B (en) | Mobile internet user comment mining method based on machine learning | |
| CN113407811A (en) | Table dividing method and device for learning platform, computer equipment and storage medium | |
| CN112989011B (en) | Data query method, data query device and electronic equipment | |
| CN115757174A (en) | Database difference detection method and device | |
| CN115809228A (en) | Data comparison method and device, storage medium and electronic equipment | |
| CN110781191B (en) | Processing method of layout data and server | |
| CN113590792A (en) | User problem processing method and device and server | |
| CN113157964A (en) | Method and device for searching data set through voice and electronic equipment | |
| CN110858214B (en) | Recommendation model training and further auditing program recommendation method, device and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210917 |
|
| RJ01 | Rejection of invention patent application after publication |