CN112948470A - Method for ranking and sorting in real time based on online questionnaire examination - Google Patents
Method for ranking and sorting in real time based on online questionnaire examination Download PDFInfo
- Publication number
- CN112948470A CN112948470A CN202110177469.2A CN202110177469A CN112948470A CN 112948470 A CN112948470 A CN 112948470A CN 202110177469 A CN202110177469 A CN 202110177469A CN 112948470 A CN112948470 A CN 112948470A
- Authority
- CN
- China
- Prior art keywords
- ranking
- score
- name
- real time
- list
- 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 17
- 238000012545 processing Methods 0.000 claims abstract description 9
- 238000012163 sequencing technique Methods 0.000 claims abstract description 4
- 238000013461 design Methods 0.000 description 5
- 238000012790 confirmation Methods 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000008094 contradictory effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- 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)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Educational Administration (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- Educational Technology (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Economics (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 invention belongs to the technical field of online questionnaire score ranking, and particularly relates to a method for ranking and sequencing in real time based on an online questionnaire examination, which comprises the following steps: s1, carrying out ranking list duplicate removal processing; s2: ranking and ranking; s3: carrying out timeliness treatment on the data; the invention can realize the ranking function of storing million-level user examinations in real time and meet the application scene of online examination score ranking display of the Internet.
Description
Technical Field
The invention belongs to the technical field of online questionnaire score ranking, and particularly relates to a method for ranking and sequencing in real time based on an online questionnaire examination.
Background
Examination type questionnaires on the general questionnaire question types, correct answers and question scores can be set. Therefore, the total score of the examination answer sheet can be calculated in a gathering way by judging according to the answering result of each question of the answer sheet. Therefore, on the basis, how to develop a method for real-time ranking list of the examination can generate ranking list information of examination scores in real time according to the total score of the participatory answer sheets, and the method is a problem to be solved by technical personnel in the field.
Disclosure of Invention
In order to solve the problems in the prior art, the invention provides a method for ranking and sequencing in real time based on an online questionnaire examination.
The technical scheme of the invention is realized as follows:
a method for ranking and ordering in real time based on an online questionnaire examination comprises the following steps:
s1 ranking list de-duplication process
The publisher of the questionnaire may set up to allow the examinee to answer the questionnaire one or more times, and the examination may also be answered from multiple settings, so that multiple answers may be generated for the same examination in reality. Aiming at the situation, the uniqueness confirmation and the multiple answer volumes duplicate removal processing of the identity information of the examinees are realized; for users who use different platforms to participate in the questionnaire, the information of name + dept + id can be extracted, specifically:
the WeChat provides an open interface for acquiring the OpenId and the nickname of the WeChat user, and the only one of the users can be identified through the OpenId.
Enterprise WeChat provides enterprise internal organization supply, and account Id, name and department name of enterprise employees can be obtained through an open interface.
The user system, the user system questionnaire of the questionnaire star, the user Id and the department information are configured; the uniqueness of the user can be identified through the information of the user system.
In addition, names, departments and examinee ID questions can be added into the examination questionnaire, the departments, names, UserId of the ranking list and the departments, names and ID questions pointing to the questionnaire can be set through a background entrance, and the uniqueness of the user can be identified.
The input name, the department dept and the user Id are called or input through different platforms, and the unique user identification can be determined through splicing of the character string of the name + dept + Id and recorded in a database. As in the following table:
| Name+Dept+ID | Score | Time |
| opening three hair-generating parts 001 | 100 | 10S |
| Zhang Sanjian design part 002 | 90 | 20S |
Overview of the deduplication Process
And the unique identifier of name + dept + id can correspond to multiple achievements. Each answer, the corresponding score of the mark can be inquired in real time, as shown in the following table
After deduplication, the database stores the following table:
| Name+Dept+ID | Score | Time |
| opening three hair-generating parts 001 | 100 | 10S |
| Zhang Sanjian design part 002 | 95 | 20S |
The purpose of removing the weight is achieved.
S2, ranking the ranking, wherein the ranking result user ranks by any one of the scoring or the scoring adding time; based on scores alone, the ranking results are shown in the following table, for example:
| Score | Time | Rank |
| 100 | 10S | 1 |
| 100 | 15S | 1 |
| 95 | 20S | 3 |
also according to the scores, the ranking results are shown in the following table, for example:
| Score | Time | Rank |
| 100 | 10S | 1 |
| 100 | 15S | 2 |
| 95 | 20S | 3 |
s3: carrying out timeliness treatment on the data; no new examinee score exists within three months, the ranking list data of the past scores are overdue, and the database does not store the ranking list any more.
Further, the ranking data processing flow in the step S2 includes the following steps:
input, participant's answer Score, Time, name, dept, Id
Logic processing, the program converts the participant's test response sheet input data into the above-described format, stored in the Redis orderable collection, in the manner described above.
Score + Time generates data of double type, defined as dv
dbval＝score+".0"+UNIXTimespan；
dbval＝dbval+".0"+(100000000-Time)；
When the participant submits the answer sheet, the answer sheet is searched in the orderable set, and whether the corresponding key value (Name + Dept + ID) has scores or not is judged. If there is achievement, dvExsit is defined. If dvExsit > dbval, dval ═ dvExsit. No score exists, and the score is directly inserted into the orderable collection.
Redis orderable collection data structure
The orderable ordered set has two elements, one dictionary for maintaining the relationship between Name + Dept + ID and score, and one skip list for maintaining the relationship between the linked list where the score is located
The dit stores score relation of Ztriplet >100 and Litet >90 by maintaining hash table.
And the skip list generates a skip linked list in real time according to the dv value. The efficiency of inserting and searching the linked list of the skiplist is greatly improved compared with the efficiency of inserting and searching the linked list of the conventional linked list.
Further, the step of S3: carrying out timeliness treatment on the data; if no new examinee score exists in an examination within three months, the ranking list data of the past scores are expired, and the database does not store the ranking list any more. And if the user needs to re-participate in ranking in the past answer sheet, the background provides a synchronization function, and the past ranking data is restored to the ranking list. The strategy achieves reasonable balance on the storage performance and the capacity use of the ranking list.
The scheme has the following effects:
the scheme realizes the ranking function of storing million-level user examinations in real time, and meets the application scene of online examination score ranking display of the Internet.
Drawings
Fig. 1 is a flowchart illustrating a method for ranking and sorting in real time based on an online questionnaire examination according to embodiment 1 of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be described clearly and completely with reference to the accompanying drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present invention without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that all the directional indicators (such as upper, lower, left, right, front and rear … …) in the embodiment of the present invention are only used to explain the relative position relationship between the components, the movement situation, etc. in a specific posture (as shown in the drawing), and if the specific posture is changed, the directional indicator is changed accordingly.
In addition, the descriptions related to "first", "second", etc. in the present invention are for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In addition, technical solutions between various embodiments may be combined with each other, but must be realized by a person skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
Example 1
As shown in fig. 1, a method for ranking and sorting in real time based on an online questionnaire examination includes the following steps:
s1 ranking list de-duplication process
The publisher of the questionnaire may set up to allow the examinee to answer the questionnaire one or more times, and the examination may also be answered from multiple settings, so that multiple answers may be generated for the same examination in reality. Aiming at the situation, the uniqueness confirmation and the multiple answer volumes duplicate removal processing of the identity information of the examinees are realized; for users who use different platforms to participate in the questionnaire, the information of name + dept + id can be extracted, specifically:
the WeChat provides an open interface for acquiring the OpenId and the nickname of the WeChat user, and the only one of the users can be identified through the OpenId.
Enterprise WeChat provides enterprise internal organization supply, and account Id, name and department name of enterprise employees can be obtained through an open interface.
The user system, the user system questionnaire of the questionnaire star, the user Id and the department information are configured; the uniqueness of the user can be identified through the information of the user system.
In addition, names, departments and examinee ID questions can be added into the examination questionnaire, the departments, names, UserId of the ranking list and the departments, names and ID questions pointing to the questionnaire can be set through a background entrance, and the uniqueness of the user can be identified.
The input name, the department dept and the user Id are called or input through different platforms, and the unique user identification can be determined through splicing of the character string of the name + dept + Id and recorded in a database. As in the following table:
| Name+Dept+ID | Score | Time |
| opening three hair-generating parts 001 | 100 | 10S |
| Zhang Sanjian design part 002 | 90 | 20S |
Overview of the deduplication Process
And the unique identifier of name + dept + id can correspond to multiple achievements. Each answer, the corresponding score of the mark can be inquired in real time, as shown in the following table
| Name+Dept+ID | Score | Time |
| Opening three hair-generating parts 001 | 100 | 10S |
| Opening three hair-generating parts 001 | 90 | 15S |
| Zhang Sanjian design part 002 | 95 | 20S |
After deduplication, the database stores the following table:
| Name+Dept+ID | Score | Time |
| opening three hair-generating parts 001 | 100 | 10S |
| Zhang Sanjian design part 002 | 95 | 20S |
The purpose of removing the weight is achieved.
S2, ranking the ranking, wherein the ranking result user ranks by any one of the scoring or the scoring adding time; based on scores alone, the ranking results are shown in the following table, for example:
| Score | Time | Rank |
| 100 | 10S | 1 |
| 100 | 15S | 1 |
| 95 | 20S | 3 |
also according to the scores, the ranking results are shown in the following table, for example:
| Score | Time | Rank |
| 100 | 10S | 1 |
| 100 | 15S | 2 |
| 95 | 20S | 3 |
the ranking data processing flow comprises the following steps:
input, participant's answer Score, Time, name, dept, Id
Logic processing, the program converts the participant's test response sheet input data into the above-described format, stored in the Redis orderable collection, in the manner described above.
Score + Time generates data of double type, defined as dv
dbval＝score+".0"+UNIXTimespan；
dbval＝dbval+".0"+(100000000-Time)；
When the participant submits the answer sheet, the answer sheet is searched in the orderable set, and whether the corresponding key value (Name + Dept + ID) has scores or not is judged. If there is achievement, dvExsit is defined. If dvExsit > dbval, dval ═ dvExsit. No score exists, and the score is directly inserted into the orderable collection.
Redis orderable collection data structure
The orderable ordered set has two elements, one dictionary for maintaining the relationship between Name + Dept + ID and score, and one skip list for maintaining the relationship between the linked list where the score is located
The dit stores score relation of Ztriplet >100 and Litet >90 by maintaining hash table.
And the skip list generates a skip linked list in real time according to the dv value. The efficiency of inserting and searching the linked list of the skiplist is greatly improved compared with the efficiency of inserting and searching the linked list of the conventional linked list.
And step S3: carrying out timeliness treatment on the data; if no new examinee score exists in an examination within three months, the ranking list data of the past scores are expired, and the database does not store the ranking list any more. And if the user needs to re-participate in ranking in the past answer sheet, the background provides a synchronization function, and the past ranking data is restored to the ranking list. The strategy achieves reasonable balance on the storage performance and the capacity use of the ranking list.
The scheme can realize the ranking function of storing million-level user examinations in real time, and meets the application scene of online examination score ranking display of the Internet.
Finally, the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, although the present invention has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention, and all of them should be covered in the claims of the present invention.
Claims (3)
1. A method for ranking and sequencing in real time based on an online questionnaire examination is characterized by comprising the following steps:
s1, carrying out ranking list duplicate removal processing; the uniqueness of the user identity information is determined, the unique user identification can be determined by splicing the character string of name + dept + Id through inputting the name, the department dept and the user Id, and the unique identification of the name + dept + Id and the possibly corresponding multiple scores are recorded in a database. And inquiring the score corresponding to the identification in real time every time of answering, sorting and removing the weight of different answer sheet information of the same identification, and keeping the answer sheet record with higher score.
S2: ranking the ranking by any one of scoring or scoring and time;
s3: carrying out timeliness treatment on the data; no new examinee score exists within three months, the ranking list data of the past scores are overdue, and the database does not store the ranking list any more.
2. The method for ranking and sorting in real time based on the on-line questionnaire examination according to claim 1, wherein the step S2 further comprises a stored data processing, and the input: the answer sheets Score, Time, name, depth and id of the participants are stored in a Redis orderable set, the participants submit the answer sheets and are searched in the orderable set, and whether scores exist in the corresponding key values, namely the name + depth + id; there is a score, define dvexit, if dvexit > dbval, dval ═ dvexit; the original dv value is overwritten with dval; if no score exists, directly inserting the score into the orderable set; the orderable ordered set comprises two elements, namely a dictionary used for maintaining the relationship from name + dept + id to the score, and a skip list used for maintaining the relationship of a linked list where the score is located.
3. The method for ranking and sorting in real time based on the on-line questionnaire examination according to claim 1, wherein the step S3 comprises the following steps: the examination has no new examinee score in three months, the ranking list data of the past scores is expired, and the database does not store the ranking list any more; and if the user needs to re-participate in ranking in the past answer sheet, the background provides a synchronization function, and the past ranking data is restored to the ranking list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110177469.2A CN112948470A (en) | 2021-02-09 | 2021-02-09 | Method for ranking and sorting in real time based on online questionnaire examination |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110177469.2A CN112948470A (en) | 2021-02-09 | 2021-02-09 | Method for ranking and sorting in real time based on online questionnaire examination |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112948470A true CN112948470A (en) | 2021-06-11 |
Family
ID=76244704
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110177469.2A Pending CN112948470A (en) | 2021-02-09 | 2021-02-09 | Method for ranking and sorting in real time based on online questionnaire examination |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112948470A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1437123A (en) * | 2002-02-08 | 2003-08-20 | 明日工作室股份有限公司 | On-line automatic name arranging method by means of information processing equipment |
| KR20090017348A (en) * | 2007-08-14 | 2009-02-18 | 에스케이 텔레콤주식회사 | System, server and method for evaluating school ranking by using online test |
| US20140181192A1 (en) * | 2012-12-20 | 2014-06-26 | Sriram Sankar | Ranking Test Framework for Search Results on an Online Social Network |
| CN103927910A (en) * | 2014-04-17 | 2014-07-16 | 西安夫子电子科技研究院有限公司 | Mobile teaching platform |
| CN107220276A (en) * | 2017-04-14 | 2017-09-29 | 弘成科技发展有限公司 | Taken an examination in live and replayed section arrangement method |
| CN109064231A (en) * | 2018-08-15 | 2018-12-21 | 北京博赛在线网络科技有限公司 | Information interacting method and system for online answer |
-
2021
- 2021-02-09 CN CN202110177469.2A patent/CN112948470A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1437123A (en) * | 2002-02-08 | 2003-08-20 | 明日工作室股份有限公司 | On-line automatic name arranging method by means of information processing equipment |
| KR20090017348A (en) * | 2007-08-14 | 2009-02-18 | 에스케이 텔레콤주식회사 | System, server and method for evaluating school ranking by using online test |
| US20140181192A1 (en) * | 2012-12-20 | 2014-06-26 | Sriram Sankar | Ranking Test Framework for Search Results on an Online Social Network |
| CN103927910A (en) * | 2014-04-17 | 2014-07-16 | 西安夫子电子科技研究院有限公司 | Mobile teaching platform |
| CN107220276A (en) * | 2017-04-14 | 2017-09-29 | 弘成科技发展有限公司 | Taken an examination in live and replayed section arrangement method |
| CN109064231A (en) * | 2018-08-15 | 2018-12-21 | 北京博赛在线网络科技有限公司 | Information interacting method and system for online answer |
Non-Patent Citations (1)
| Title |
|---|
| 艾忻: "《国际学生流动的影响因素及策略研究 以"双一流"建设为背景》", 31 March 2018, 天津大学出版社 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP5670294B2 (en) | Systems, methods, interfaces, and software for automatic collection and integration of entity data into online databases and professional rosters | |
| US20070220426A1 (en) | Method and System to Provide a Certified Lexicon for Document Drafting | |
| GB2362004A (en) | Data object matching using a classification index | |
| Kellar et al. | Effect of task on time spent reading as an implicit measure of interest | |
| CN108920479B (en) | Cross-information-source account recommendation method for two micro terminals | |
| JP7412012B2 (en) | Tutoring support systems, methods, and programs | |
| CN110942830A (en) | Background management system for psychological evaluation | |
| CN112612961B (en) | Information searching method, device, storage medium and computer equipment | |
| CN112948470A (en) | Method for ranking and sorting in real time based on online questionnaire examination | |
| Gallacher | Cite Unseen: How Neutral Citation and America's Law Schools Can Cure Our Strange Devotion to Bibliographical Orthodoxy and the Constriction of Open and Equal Access to the Law | |
| US20190304040A1 (en) | System and Method for Vetting Potential Jurors | |
| JP3572284B2 (en) | Appropriate job determination system and server equipment | |
| Hanish et al. | The scientific stature of counseling psychology training programs: A still picture of a shifting scene | |
| Kosseff | Private or Public? Eliminating the Gertz Defamation Test | |
| Grayson | Military history from the street: new methods for researching First World War service in the British military | |
| JP7553937B2 (en) | Evaluation system, evaluation method, and program | |
| CN107741932A (en) | User data fusion method and system | |
| CN111222842A (en) | Medical staff AI intelligence recruitment system | |
| Bade | Responsible librarianship: library policies for unreliable systems | |
| Whitehorn et al. | Inside relational databases with examples in Access | |
| US20060019230A1 (en) | Method for collecting and organizing information for use in writing a book | |
| CN117454017B (en) | Course recommendation method, device and storage medium | |
| Endres | Methodological studies: Interdisciplinarity is the key | |
| US11599572B2 (en) | Method, apparatus, and system for data collection, transformation and extraction to support image and text search of antiques and collectables | |
| JP2006084705A (en) | Answer archive system |
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: 20210611 |
|
| RJ01 | Rejection of invention patent application after publication |