CN102662990A - A management method for warehousing and storing single choice questions in electronic question bank - Google Patents
A management method for warehousing and storing single choice questions in electronic question bank Download PDFInfo
- Publication number
- CN102662990A CN102662990A CN2012100669276A CN201210066927A CN102662990A CN 102662990 A CN102662990 A CN 102662990A CN 2012100669276 A CN2012100669276 A CN 2012100669276A CN 201210066927 A CN201210066927 A CN 201210066927A CN 102662990 A CN102662990 A CN 102662990A
- Authority
- CN
- China
- Prior art keywords
- index
- content
- option
- question
- execution
- 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
Images
Landscapes
- Electrically Operated Instructional Devices (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a management method for warehousing and storing single choice questions in an electronic question bank. The Key of the invention lies in ensuring the storage uniqueness of the test questions to prevent repeated test questions storage by employing database table storage. The method creates a content table of test questions, an answer table of test questions and a mapping table in the database in order to store titles and contents of the test questions, answers of the test questions and mapping of the test questions respectively. Only the unrepeated contents and answers of the test questions are stored in the database to ensure the storage uniqueness of the test questions, thereby reducing the space occupancy of the test question bank.
Description
(1) technical field
The present invention is to provide a kind of memory management method of electronic selection exam pool.
(2) background technology
Along with the infotech fast development and the widespread use that with the computer technology are core, Web education has become the important directions of various places educational reform and development.The fast development of infotech is that the enforcement of Web education provides solid technical foundation; The test item bank system is exactly a kind of favourable instrument of the computer-aided instruction that develops rapidly in recent years; The test item bank system of an excellent in design will greatly improve the utilization factor of teaching resource and teacher's work efficiency, alleviate hard work amounts such as the teacher sets a question, gos over examination papers.
Now colleges and universities' technology that uses a computer is converted into the e-sourcing that can store on computers with a large amount of papery papers, has made things convenient for the permanent storage of paper.The back input database is collected as the electronics exam pool with all examination questions by school, and the annual examination question that from exam pool, extracts is as examination paper.But electronics examination question wide material sources; Can cause the repetition typing of examination question; The serious waste storage space; Especially for multiple-choice question, need a plurality of option contents of each examination question of storage, the repetition of different exercise question option contents, the identical waste that all can cause storage space of same title content different options content.
Find that through last surface analysis it is the main cause that causes electronics examination question space waste that the exercise question of selection examination question repeats to repeat with the option content of different exercise questions.To above problem; This method is with the item content and the option content separate storage of multiple-choice question; Use incidence relation between a mapping table storage exercise question and the option mapping; Guarantee unique storage of all multiple-choice question item contents and option content in the electronics exam pool, thereby reduced the storage space of electronic test paper.
(3) summary of the invention
The object of the present invention is to provide a kind of individual event multiple-choice question warehouse-in memory management method of electronics exam pool, alleviate the huge storage pressure that the electronic test paper storage is brought.This method uses a mapping table to accomplish the mapping of exercise question and option the item content and the option content separate storage of multiple-choice question, has guaranteed unique storage of all multiple-choice question item contents and option content.
To above-mentioned purpose; This method is created three forms and is used for the store electrons examination question in database: contents of test question table Content (c_index; C_content) be used to store the exercise question of multiple-choice question, use the unique expression contents of test question of c_index attribute, c_content deposits the selection item content; (a_index a_content), is used to store the option of multiple-choice question to script Table A nswer, uses the unique expression option of a_index attribute content, and a_content deposits the option content; Examination question mapping table C_A (c_index, a_index1, a_index2; A_index3, a_index4, r_index); Be used to store the contact between contents of test question and the script; C_index is the c_index of examination question item content in the Content table, and four option contents that a_index1/a_index2/a_index3/a_index4 is used for writing down examination question are respectively at the a_index of Answer table, and r_index is used for writing down the index of correct option option at Answer;
The employed method of this patent is mainly used in the uniqueness storage problem that solves examination question, mainly is divided into the execution of three steps: item content is looked into heavily, when new examination question is stored; At first take out new examination question item content, make it with contents of test question table Content in c_content contrast, if this item content exists; Take out the c_index of this item content; Otherwise be that new contents of test question distributes new c_index, and insert the Content table: the option content search: take out the content and the correct option of new examination question the respective option, select the a_content of the script Table A nswer of content and database in showing to contrast each respectively; If this option content exists; Taking-up has the a_index of same options record, otherwise is the new a_index of this option content allocation, and this option content is inserted the Answer table; If this option is a correct option, the a_index of this option is designated as r_index; In view of the above, obtain a_index tabulation and the correct option of four option contents index r_index respectively at Answer; Mapping table is looked into heavily: series arrangement is from small to large pressed in the a_index tabulation of four options of new examination question; Form a_index1, a_index2, a_index3, a_index4; Form a record with the c_index of examination question item content, the index r_index of the correct option, the record among the contrast form C_A is if should exist by record; Show that this examination question exists, and needn't store this examination question; Otherwise, new record is inserted form, accomplish the record input database work of together new multiple-choice question.
Its concrete grammar step is:
(1) in database, create form: contents of test question table Content (c_index, c_content), (a_index is a_content) with topic mapping table C_A (c_index for script Table A nswer; A_index1, a_index2, a_index3; A_index4; R_index), initialization m_cindex is the record strip number in the Content table, and m_aindex is the record strip number in the Anwser table;
(2) import the individual event multiple-choice question that will deposit test item bank in and put into processing tabulation P-List;
(3) from P-List, take out one examination question T, analyze and obtain examination question item content T-con, four option contents of examination question are put into array T [1], T [2], T [3], T [4] respectively, and the position r of the correct option in array T, form T{T-con, T [4], r};
(4) whether there be the c_content record identical among the question blank Content, then execution in step (5) is arranged with T-con; Otherwise execution in step (6);
(5) obtain the c_index of the c_index of identical recordings as T; Execution in step (8);
(6)m_cindex+1；
(7) m_cindex inserts the Content table as the newly assigned c_index of examination question T;
(8)i＝1；
(9) whether there be the a_content record identical among the question blank Answer, then execution in step (10) is arranged with T [i]; Otherwise execution in step (11);
(10) obtain the a_index of the a_index of identical recordings as T [i]; Execution in step (13);
(11)m_aindex+1；
(12) m_aindex is the newly assigned a_index of T [i], inserts the Answer table;
(13) if this option of i=r is the correct option, execution in step (14), otherwise execution in step (15);
(14) a_index of r_index=T [i];
(15)i+1；
(16) if i＞4 execution in step (17); Otherwise execution in step (9);
(17) with the a_index of T [1], T [2], T [3], T [4] with from small to large series arrangement, be designated as a_index1, a_index2, a_index3, a_index4 successively;
(18) whether exist among the question blank C_A record (c_index, a_index1, a_index2, a_index3, r_index), there is execution in step (19) in a_index4, otherwise execution in step (20);
(19) judge that examination question T for there being examination question, abandons the typing test item bank, execution in step (21);
(20) judge examination question T for there not being examination question, will write down and insert table C_A;
(21) judge whether P-List is empty, and non-NULL is execution in step (3) then; Otherwise program suspension.
Key of the present invention is item content and the option content separate storage with the electronic selection topic, uses a mapping table to accomplish the mapping of item content and exercise question option, and the method can guarantee the uniqueness of all memory contentss.
Its main innovate point is following:
1. with the item content and the option content separate storage of electronic selection body, guarantee the consistance of all memory contentss;
2. use mapping table to accomplish the mapping of electronic selection topic exercise question and option, all records can only the uniqueness record, guarantees the uniqueness of all multiple-choice questions.
(4) description of drawings
Fig. 1: a kind of individual event multiple-choice question warehouse-in memory management method of electronics exam pool
(5) concrete embodiment
Below in conjunction with the accompanying drawing distance the present invention is made more detailed description:
The method of the invention is characterised in that:
This method is created three forms and is used for the store electrons examination question in database: contents of test question table Content (c_index; C_content) be used to store the exercise question of multiple-choice question; Use the unique expression contents of test question of c_index attribute, c_content deposits the selection item content; (a_index a_content), is used to store the option of multiple-choice question to script Table A nswer, uses the unique expression option of a_index attribute content, and a_content deposits the option content; Examination question mapping table C_A (c_index, a_index1, a_index2; A_index3, a_index4, r_index); Be used to store the contact between contents of test question and the script; C_index is the c_index of examination question item content in the Content table, and four option contents that a_index1/a_index2/a_index3/a_index4 is used for writing down examination question are respectively at the a_index of Answer table, and r_index is used for writing down the index of correct option option at Answer;
The employed method of this patent is mainly used in the uniqueness storage problem that solves examination question, mainly is divided into the execution of three steps: item content is looked into heavily, when new examination question is stored; At first take out new examination question item content; Make it with contents of test question table Content in c_content contrast, if this item content exists, take out the c_index of this item content; Otherwise be that new contents of test question distributes new c_index, and insert the Content table; Option content search: the content and the correct option of taking out new examination question the respective option; Select the a_content in the script Table A nswer table of content and database contrast each respectively, if this option content exists, taking-up has the a_index that same options writes down; Otherwise be the new a_index of this option content allocation; And this option content inserted the Answer table, if this option is a correct option, the a_index of this option is designated as r_index; In view of the above, obtain a_index tabulation and the correct option of four option contents index r_index respectively at Answer; Mapping table is looked into heavily: series arrangement is from small to large pressed in the a_index tabulation of four options of new examination question; Form a_index1, a_index2, a_index3, a_index4; Form a record with the c_index of examination question item content, the index r_index of the correct option, the record among the contrast form C_A is if should exist by record; Show that this examination question exists, and needn't store this examination question; Otherwise, new record is inserted form, accomplish the record input database work of together new multiple-choice question.
Its concrete grammar step is:
(1) in database, create form: contents of test question table Content (c_index, c_content), (a_index is a_content) with topic mapping table C_A (c_index for script Table A nswer; A_index1, a_index2, a_index3; A_index4; R_index), initialization m_cindex is the record strip number in the Content table, and m_aindex is the record strip number in the Anwser table;
(2) import the individual event multiple-choice question that will deposit test item bank in and put into processing tabulation P-List;
(3) from P-List, take out one examination question T, analyze and obtain examination question item content T-con, four option contents of examination question are put into array T [1], T [2], T [3], T [4] respectively, and the position r of the correct option in array, T{T-con, T [4], r};
(4) whether there be the c_content record identical among the question blank Content, then execution in step (5) is arranged with T-con; Otherwise execution in step (6);
(5) obtain the c_index of the c_index of identical recordings as T; Execution in step (8);
(6)m_cindex+1；
(7) m_cindex inserts the Content table as the newly assigned c_index of examination question T;
(8)i＝1；
(9) whether there be the a_content record identical among the question blank Answer, then execution in step (10) is arranged with T [i]; Otherwise execution in step (11);
(10) obtain the a_index of the a_index of identical recordings as T [i]; Execution in step (13);
(11)m_aindex+1；
(12) m_aindex is the newly assigned a_index of T [i], inserts the Answer table;
(13) if i=r, execution in step (14), otherwise execution in step (15);
(14) a_index of r_index=T [i];
(15)i+1；
(16) if i＞4 execution in step (17); Otherwise execution in step (9);
(17) with the a_index of T [1], T [2], T [3], T [4] with from small to large series arrangement, be designated as a_index1, a_index2, a_index3, a_index4 successively;
(18) whether exist among the question blank C_A record (c_index, a_index1, a_index2, a_index3, r_index), there is execution in step (19) in a_index4, otherwise execution in step (20);
(19) judge that examination question T for there being examination question, abandons the typing test item bank, execution in step (21);
(20) judge examination question T for there not being examination question, will write down and insert table C_A;
(21) judge whether P-List is empty, and non-NULL is execution in step (3) then; Otherwise program suspension.
Its practical implementation pattern is such:
Entire method is deployed on the database; For the user provides examination question typing interface, come the examination question item content to be separated with the option content as examination question temporarily; Item content is looked into the item content table that database is inserted in heavy back; Obtain the index of this item content, the respective option of examination question is looked into the option contents table that database is inserted in heavy back, obtain the index of the respective option content.With the index of item content and option content, look into heavy back as a record and insert database, accomplish the record of one multiple-choice question.
Claims (2)
1. the memory management method of an electronic selection exam pool; It is characterized in that: this method is created three forms and is used for the store electrons examination question in database: contents of test question table Content (c_index; C_content) be used to store the exercise question of multiple-choice question; Use the unique expression contents of test question of c_index attribute, c_content deposits the selection item content; (a_index a_content), is used to store the option of multiple-choice question to script Table A nswer, uses the unique expression option of a_index attribute content, and a_content deposits the option content; Examination question mapping table C_A (c_index, a_index1, a_index2; A_index3, a_index4, r_index); Be used to store the contact between contents of test question and the script; C_index is the c_index of examination question item content in the Content table, and four option contents that a_index1/a_index2/a_index3/a_index4 is used for writing down examination question are respectively at the a_index of Answer table, and r_index is used for writing down the index of correct option option at Answer;
The employed method of this patent is mainly used in the uniqueness storage problem that solves examination question, mainly is divided into the execution of three steps: item content is looked into heavily, when new examination question is stored; At first take out new examination question item content; The c_content that makes it among the contents of test question table Content with database contrasts, if this item content exists, takes out the c_index of this item content; Otherwise be that new contents of test question distributes new c_index, and insert the Content table; Option content search: the content and the correct option of taking out new examination question the respective option; Select the a_content in the script Table A nswer table of content and database contrast each respectively, if this option content exists, taking-up has the a_index that same options writes down; Otherwise be the new a_index of this option content allocation; And this option content inserted the Answer table, if this option is a correct option, the a_index of this option is designated as r_index; In view of the above, obtain a_index tabulation and the correct option of four option contents index r_index respectively at Answer; Mapping table is looked into heavily: series arrangement is from small to large pressed in the a_index tabulation of four options of new examination question; Form a_index1, a_index2, a_index3, a_index4; Form a record with the c_index of examination question item content, the index r_index of the correct option, the record among the contrast form C_A is if should exist by record; Show that this examination question exists, and needn't store this examination question; Otherwise, new record is inserted form, accomplish the record input database work of together new multiple-choice question.
2. the exam pool uniqueness storage means based on database according to claim 1, it is characterized in that: its concrete grammar step is:
(1) in database, create form: contents of test question table Content (c_index, c_content), (a_index is a_content) with topic mapping table C_A (c_index for script Table A nswer; A_index1, a_index2, a_index3; A_index4; R_index), initialization m_cindex is the record strip number in the Content table, and m_aindex is the record strip number in the Anwser table;
(2) import the individual event multiple-choice question that will deposit test item bank in and put into processing tabulation P-List;
(3) from P-List, take out one examination question T, analyze and obtain examination question item content T-con, four option contents of examination question are put into array T [1], T [2], T [3], T [4] respectively, and the position r of the correct option in array T, form T{T-con, T [4], r};
(4) whether there be the c_content record identical among the question blank Content, then execution in step (5) is arranged with T-con; Otherwise execution in step (6);
(5) obtain the c_index of the c_index of identical recordings as T; Execution in step (8);
(6)m_cindex+1；
(7) m_cindex inserts the Content table as the newly assigned c_index of examination question T;
(8)i＝1；
(9) whether there be the a_content record identical among the question blank Answer, then execution in step (10) is arranged with T [i]; Otherwise execution in step (11);
(10) obtain the a_index of the a_index of identical recordings as T [i]; Execution in step (13);
(11)m_aindex+1；
(12) m_aindex is the newly assigned a_index of T [i], inserts the Answer table;
(13) if this option of i=r is the correct option, execution in step (14), otherwise execution in step (15);
(14) a_index of r_index=T [i];
(15)i+1；
(16) if i＞4 execution in step (17); Otherwise execution in step (9);
(17) with the a_index of T [1], T [2], T [3], T [4] with from small to large series arrangement, be designated as a_index1, a_index2, a_index3, a_index4 successively;
(18) whether exist among the question blank C_A record (c_index, a_index1, a_index2, a_index3, r_index), there is execution in step (19) in a_index4, otherwise execution in step (20);
(19) judge that examination question T for there being examination question, abandons the typing test item bank, execution in step (21);
(20) judge examination question T for there not being examination question, will write down and insert table C_A;
(21) judge whether P-List is empty, and non-NULL is execution in step (3) then; Otherwise program suspension.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100669276A CN102662990A (en) | 2012-03-14 | 2012-03-14 | A management method for warehousing and storing single choice questions in electronic question bank |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100669276A CN102662990A (en) | 2012-03-14 | 2012-03-14 | A management method for warehousing and storing single choice questions in electronic question bank |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102662990A true CN102662990A (en) | 2012-09-12 |
Family
ID=46772481
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012100669276A Pending CN102662990A (en) | 2012-03-14 | 2012-03-14 | A management method for warehousing and storing single choice questions in electronic question bank |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102662990A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1932795A (en) * | 2006-10-10 | 2007-03-21 | 青岛中科恒信信息技术有限公司 | Examination paper intelligent setting questions and organizing system |
| CN101196870A (en) * | 2007-12-19 | 2008-06-11 | 济南钢铁股份有限公司 | Item database organization and automatic volume group implementing method and system |
-
2012
- 2012-03-14 CN CN2012100669276A patent/CN102662990A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1932795A (en) * | 2006-10-10 | 2007-03-21 | 青岛中科恒信信息技术有限公司 | Examination paper intelligent setting questions and organizing system |
| CN101196870A (en) * | 2007-12-19 | 2008-06-11 | 济南钢铁股份有限公司 | Item database organization and automatic volume group implementing method and system |
Non-Patent Citations (3)
| Title |
|---|
| 刘德山 等: "题库系统存储结构研究", 《辽宁师范大学学报（自然科学版）》 * |
| 康博创作室: "《Access 2000中文版实用教程》", 31 October 1999 * |
| 许旻: "题库系统中的数据结构", 《苏州教育学院学报》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Green et al. | The skull beneath the skin: entity-relationship models of information artifacts | |
| CN102542068A (en) | Cloud-storage based electronic test question storage management method | |
| JP2011523739A (en) | System and method for collaborative interaction | |
| Burton et al. | Organization design: the evolving state-of-the-art | |
| CN106023009A (en) | Method and system for establishing test paper question bank | |
| CN107783718A (en) | A kind of online assignment hand-written based on papery/examination input method and device | |
| Shi et al. | Trends of cloud computing in education | |
| CN107193467B (en) | Method and equipment for displaying intelligent pen writing content | |
| CN107180567A (en) | Classroom random notes teaching method and system | |
| CN103839451A (en) | Informationized paperless classroom teaching system | |
| Baroutsis | Mapping the field of education research and media | |
| Zuccala et al. | Reviewing, indicating, and counting books for modern research evaluation systems | |
| CN105280030A (en) | Learning content layout design of multi-disciplinary electron learning machine | |
| CN106327924A (en) | Intelligent classroom realization method and system | |
| Botwinick | Emmanuel Lévinas and the Limits to Ethics: A Critique and a Re-appropriation | |
| CN102662990A (en) | A management method for warehousing and storing single choice questions in electronic question bank | |
| Boyd et al. | The Transformation of Great American School Districts: How Big Cities Are Reshaping Public Education. | |
| Jibia et al. | Integrating ICT in library management: Design and development of an automated library management system for Cavendish University Uganda | |
| Engel | Survey measurements: techniques, data quality and sources of error | |
| TW201301059A (en) | System for choosing examination questions from file and method thereof | |
| CN206931118U (en) | General family medicine test item bank and creation system for test paper | |
| Yu | Reform in the teaching model of english writing in the big data era | |
| Degefa | Social scientists’ understanding of academic freedom in Addis Ababa University, Ethiopia: A descriptive analysis | |
| CN203838892U (en) | English vocabulary kind analysis and determination teaching apparatus | |
| Bo et al. | An English learning method based on computer-assisted system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120912 |