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 PDF

Info

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
content
index
test question
option
question
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
Application number
CN2012100669276A
Other languages
Chinese (zh)
Inventor
姚文斌
韩司
叶鹏迪
张兰英
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing University of Posts and Telecommunications
Original Assignee
Beijing University of Posts and Telecommunications
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing University of Posts and Telecommunications filed Critical Beijing University of Posts and Telecommunications
Priority to CN2012100669276A priority Critical patent/CN102662990A/en
Publication of CN102662990A publication Critical patent/CN102662990A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Electrically Operated Instructional Devices (AREA)

Abstract

本发明提供的是一种电子题库的单项选择题入库存储管理方法。本发明的关键在于使用数据库表格存储保证试题存储的唯一性,避免试题的重复存储。该方法在数据库中创建试题内容表、试题答案表和映射表分别存储试题题目内容,题目答案和试题影射,在库中仅存储不重复的试题内容和试题答案保证试题的唯一性存储,降低存储试题库的空间占有率。

Figure 201210066927

The invention provides a method for storing and managing single-choice questions in an electronic question bank. The key of the present invention is to use the database table storage to ensure the uniqueness of test question storage and avoid repeated storage of test questions. This method creates a test question content table, a test question answer table, and a mapping table in the database to store the test question content, question answer and test question allusion respectively, and only stores non-repeated test question content and test answer answers in the database to ensure unique storage of test questions and reduce storage. The space occupancy rate of the test question bank.

Figure 201210066927

Description

一种电子题库的单项选择题入库存储管理方法A single-choice question storage management method for electronic question bank

(一)技术领域 (1) Technical field

本发明提供的是一种电子选择题库的存储管理方法。The invention provides a method for storing and managing an electronic multiple-choice question bank.

(二)背景技术 (2) Background technology

随着以计算机技术为核心的信息技术迅猛发展和广泛应用,网络教育已成为各地教育改革和发展的重要方向。信息技术的快速发展为网络教育的实施提供了坚实的技术基础,试题库系统就是近年来迅速发展起来的计算机辅助教学的一种有利工具,一个设计优良的试题库系统将极大地提高教学资源的利用率和教师的工作效率,减轻教师出题、阅卷等繁重的工作量。With the rapid development and wide application of information technology with computer technology as the core, online education has become an important direction of education reform and development in various places. The rapid development of information technology provides a solid technical foundation for the implementation of online education. The test question bank system is a favorable tool for computer-aided teaching that has developed rapidly in recent years. A well-designed test question bank system will greatly improve the use of teaching resources. The utilization rate and the work efficiency of teachers can reduce the heavy workload of teachers such as setting questions and grading papers.

现在高校使用计算机技术,将大量纸质试卷转化为可存储在计算机上的电子资源,方便了试卷的永久性存储。学校将所有试题收集后录入数据库作为电子题库,每年从题库中抽取试题作为考试试卷。但是电子试题来源广泛,会造成试题的重复录入,严重浪费存储空间,尤其是对于选择题,需要存储每个试题的多个选项内容,不同题目选项内容的重复、相同题目内容不同选项内容相同都会造成存储空间的浪费。Now colleges and universities use computer technology to convert a large number of paper test papers into electronic resources that can be stored on computers, which facilitates the permanent storage of test papers. The school collects all test questions and enters them into the database as an electronic question bank, and extracts test questions from the question bank every year as examination papers. However, the wide range of electronic test questions will cause repeated entry of test questions and a serious waste of storage space, especially for multiple-choice questions, which need to store multiple option contents for each test question. cause waste of storage space.

通过上面分析发现,选择试题的题目重复和不同题目的选项内容重复是造成电子试题空间浪费的主要原因。针对以上问题,本方法将选择题的题目内容和选项内容分开存储,使用一张映射表存储题目和选项映射之间关联关系,保证了电子题库中所有选择题题目内容和选项内容的唯一存储,从而减少了电子试卷的存储空间。Through the above analysis, it is found that the duplication of the topic of the selection test and the duplication of the option content of different topics are the main reasons for the waste of electronic test space. In view of the above problems, this method stores the topic content and option content of multiple-choice questions separately, and uses a mapping table to store the relationship between the topic and option mapping, which ensures the unique storage of all multiple-choice topic content and option content in the electronic question bank. Thereby reducing the storage space of the electronic test paper.

(三)发明内容 (3) Contents of the invention

本发明的目的在于提供一种电子题库的单项选择题入库存储管理方法,减轻电子试卷存储所带来的巨大存储压力。本方法将选择题的题目内容和选项内容分开存储,使用一张映射表完成题目和选项的映射,保证了所有选择题题目内容和选项内容的唯一存储。The purpose of the present invention is to provide a method for storing and managing single-choice questions in an electronic question bank, so as to reduce the huge storage pressure caused by the storage of electronic test papers. This method stores the title content and option content of multiple-choice questions separately, uses a mapping table to complete the mapping of titles and options, and ensures the unique storage of the title content and option content of all multiple-choice questions.

针对上述目的,该方法在数据库中创建三个表格用来存储电子试题:试题内容表Content(c_index,c_content)用于存储选择题的题目,使用c_index属性唯一表示试题内容,c_content存放选择题目内容;试题答案表Answer(a_index,a_content),用于存储选择题的选项,使用a_index属性唯一表示选项内容,a_content存放选项内容;试题映射表C_A(c_index,a_index1,a_index2,a_index3,a_index4,r_index),用于存储试题内容和试题答案之间的联系,c_index为试题题目内容在Content表中的c_index,a_index1/a_index2/a_index3/a_index4用于记录试题的四个选项内容分别在Answer表中的a_index,r_index用于记录正确答案选项在Answer中的index;For the above purpose, the method creates three tables in the database to store the electronic test questions: the test question content table Content (c_index, c_content) is used to store the title of the multiple choice question, and the c_index attribute is used to uniquely represent the test question content, and c_content stores the choice question content; The question answer table Answer(a_index, a_content) is used to store the options of multiple-choice questions. The a_index attribute is used to uniquely represent the option content, and a_content stores the option content; the test question mapping table C_A(c_index, a_index1, a_index2, a_index3, a_index4, r_index) To store the link between the content of the test question and the answer to the test question, c_index is the c_index of the content of the test question in the Content table, and a_index1/a_index2/a_index3/a_index4 are used to record the contents of the four options of the test question in the a_index and r_index of the Answer table respectively To record the index of the correct answer option in Answer;

本专利所使用的方法主要用于解决试题的唯一性存储问题,主要分为三步执行:题目内容查重,当有新试题存储时,首先取出新试题题目内容,使之与试题内容表Content中的c_content作对比,如果该题目内容已经存在,取出该题目内容的c_index,否则为新试题内容分配新的c_index,并插入Content表:选项内容查询:取出新试题各个选项的内容和正确答案,分别将每个选内容与数据库的试题答案表Answer表中的a_content作对比,如果该选项内容已存在,取出具有相同选项记录的a_index,否则为该选项内容分配新的a_index,并将该选项内容插入Answer表,如果该选项为正确答案,将该选项的a_index记为r_index;据此,分别获取四个选项内容的a_index列表和正确答案在Answer的索引r_index;映射表查重:将新试题四个选项的a_index列表按从小到大的顺序排列,形成a_index1、a_index2、a_index3、a_index4,与试题题目内容的c_index、正确选项的索引r_index形成一条记录,对比表格C_A中的记录,如果该记录存在,表明此试题已经存在,不必存储该试题;否则,将新记录插入表格,完成一道新选择题的记录录入数据库工作。The method used in this patent is mainly used to solve the problem of unique storage of test questions. It is mainly divided into three steps: check the content of the question for duplication. If the content of the question already exists, take out the c_index of the content of the question, otherwise assign a new c_index to the content of the new test question and insert it into the Content table: option content query: take out the content and correct answer of each option of the new test question, Compare each option with the a_content in the Answer table of the database, if the option content already exists, take out the a_index with the same option record, otherwise assign a new a_index to the option content, and store the option content Insert the Answer table, if the option is the correct answer, record the a_index of the option as r_index; accordingly, obtain the a_index list of the four option contents and the index r_index of the correct answer in the Answer; check the mapping table: put the new test question 4 The a_index list of each option is arranged in order from small to large, forming a_index1, a_index2, a_index3, a_index4, forming a record with the c_index of the test title content and the index r_index of the correct option. Compared with the records in table C_A, if the record exists, Indicates that the test question already exists, and there is no need to store the test question; otherwise, a new record is inserted into the form, and a record of a new multiple-choice question is entered into the database.

其具体方法步骤为:Its specific method steps are:

(1)在数据库中创建表格:试题内容表Content(c_index,c_content)、试题答案表Answer(a_index,a_content)和题映射表C_A(c_index,a_index1,a_index2,a_index3,a_index4,r_index),初始化m_cindex为Content表中的记录条数,m_aindex为Anwser表中的记录条数;(1) Create tables in the database: test content table Content (c_index, c_content), test answer table Answer (a_index, a_content) and question mapping table C_A (c_index, a_index1, a_index2, a_index3, a_index4, r_index), initialize m_cindex as The number of records in the Content table, m_aindex is the number of records in the Anwser table;

(2)输入将要存入试题库的单项选择题放入处理列表P-List;(2) Input the multiple-choice questions that will be stored in the test question bank and put them into the processing list P-List;

(3)从P-List中取出一道试题T,分析获取试题题目内容T-con,试题的四个选项内容分别放入数组T[1]、T[2]、T[3]、T[4],以及正确选项在数组T中的位置r,形成T{T-con,T[4],r};(3) Take a test question T from the P-List, analyze and obtain the content T-con of the test question, and put the content of the four options of the test question into the arrays T[1], T[2], T[3], T[4 respectively ], and the position r of the correct option in the array T, forming T{T-con, T[4], r};

(4)查询表Content中是否存在与T-con相同的c_content记录,有则执行步骤(5);否则执行步骤(6);(4) Check whether there is a c_content record identical to T-con in the content table, if so, execute step (5); otherwise, execute step (6);

(5)获取相同记录的c_index作为T的c_index;执行步骤(8);(5) Obtain the c_index of the same record as the c_index of T; perform step (8);

(6)m_cindex+1;(6) m_cindex+1;

(7)m_cindex作为试题T新分配的c_index插入Content表;(7) m_cindex is inserted into the Content table as the newly allocated c_index of test question T;

(8)i=1;(8)i=1;

(9)查询表Answer中是否存在与T[i]相同的a_content记录,有则执行步骤(10);否则执行步骤(11);(9) Whether there is an a_content record identical to T[i] in the query table Answer, if so, execute step (10); otherwise execute step (11);

(10)获取相同记录的a_index作为T[i]的a_index;执行步骤(13);(10) obtain the a_index of the same record as the a_index of T[i]; perform step (13);

(11)m_aindex+1;(11) m_aindex+1;

(12)m_aindex为T[i]新分配的a_index,插入Answer表;(12) m_aindex is the newly allocated a_index of T[i], which is inserted into the Answer table;

(13)如果i=r该选项为正确选项,执行步骤(14),否则执行步骤(15);(13) If this option of i=r is correct option, execute step (14), otherwise execute step (15);

(14)r_index=T[i]的a_index;(14) r_index=a_index of T[i];

(15)i+1;(15)i+1;

(16)如果i>4执行步骤(17);否则执行步骤(9);(16) If i>4 execute step (17); otherwise execute step (9);

(17)将T[1]、T[2]、T[3]、T[4]的a_index以从小到大的顺序排列,依次记为a_index1、a_index2、a_index3、a_index4;(17) Arrange the a_indexes of T[1], T[2], T[3], and T[4] in ascending order, and record them as a_index1, a_index2, a_index3, and a_index4;

(18)查询表C_A中是否存在记录(c_index,a_index1,a_index2,a_index3,a_index4,r_index),存在执行步骤(19),否则执行步骤(20);(18) Whether there is a record (c_index, a_index1, a_index2, a_index3, a_index4, r_index) in the query table C_A, there is an execution step (19), otherwise the execution step (20);

(19)判定试题T为已存在试题,放弃录入试题库,执行步骤(21);(19) Determine that the test question T is an existing test question, give up entering the test question bank, and perform step (21);

(20)判定试题T为不存在试题,将记录插入表C_A;(20) Determine that the test question T does not exist, and insert the record into the table C_A;

(21)判断P-List是否为空,非空则执行步骤(3);否则程序中止。(21) Determine whether the P-List is empty, and if it is not empty, execute step (3); otherwise, the program is terminated.

本发明的关键在于将电子选择题的题目内容和选项内容分开存储,使用一张映射表完成题目内容与题目选项的映射,此方法可以保证所有存储内容的唯一性。The key of the present invention is to store the topic content and option content of the electronic multiple-choice question separately, and use a mapping table to complete the mapping between the topic content and the topic options. This method can ensure the uniqueness of all stored contents.

其主要创新点如下:Its main innovations are as follows:

1.将电子选择体的题目内容和选项内容分开存储,保证所有存储内容的一致性;1. Store the topic content and option content of the electronic selection body separately to ensure the consistency of all stored content;

2.使用一张映射表完成电子选择题题目和选项的映射,所有记录只能唯一性记录,保证所有选择题的唯一性。2. Use a mapping table to complete the mapping of electronic multiple-choice questions and options. All records can only be uniquely recorded to ensure the uniqueness of all multiple-choice questions.

(四)附图说明 (4) Description of drawings

图1:一种电子题库的单项选择题入库存储管理方法Figure 1: A storage management method for single-choice questions in an electronic question bank

(五)具体的实施方式(5) Specific implementation methods

下面结合附图距离对本发明作更详细的描述:Below in conjunction with accompanying drawing, the present invention is described in more detail:

本发明所述方法的特征在于:The method of the present invention is characterized in that:

该方法在数据库中创建三个表格用来存储电子试题:试题内容表Content(c_index,c_content)用于存储选择题的题目,使用c_index属性唯一表示试题内容,c_content存放选择题目内容;试题答案表Answer(a_index,a_content),用于存储选择题的选项,使用a_index属性唯一表示选项内容,a_content存放选项内容;试题映射表C_A(c_index,a_index1,a_index2,a_index3,a_index4,r_index),用于存储试题内容和试题答案之间的联系,c_index为试题题目内容在Content表中的c_index,a_index1/a_index2/a_index3/a_index4用于记录试题的四个选项内容分别在Answer表中的a_index,r_index用于记录正确答案选项在Answer中的index;This method creates three tables in the database to store electronic test questions: the test content table Content (c_index, c_content) is used to store multiple-choice questions, and the c_index attribute is used to uniquely represent the test content, and c_content stores the content of the optional questions; the test answer table Answer (a_index, a_content), used to store options for multiple-choice questions, use the a_index attribute to uniquely represent the option content, and a_content stores the option content; test question mapping table C_A (c_index, a_index1, a_index2, a_index3, a_index4, r_index), used to store test question content c_index is the c_index of the content of the test question in the Content table, a_index1/a_index2/a_index3/a_index4 are used to record the four option contents of the test question respectively in the a_index of the Answer table, and r_index is used to record the correct answer The index of the option in Answer;

本专利所使用的方法主要用于解决试题的唯一性存储问题,主要分为三步执行:题目内容查重,当有新试题存储时,首先取出新试题题目内容,使之与试题内容表Content中的c_content作对比,如果该题目内容已经存在,取出该题目内容的c_index,否则为新试题内容分配新的c_index,并插入Content表;选项内容查询:取出新试题各个选项的内容和正确答案,分别将每个选内容与数据库的试题答案表Answer表中的a_content作对比,如果该选项内容已存在,取出具有相同选项记录的a_index,否则为该选项内容分配新的a_index,并将该选项内容插入Answer表,如果该选项为正确答案,将该选项的a_index记为r_index;据此,分别获取四个选项内容的a_index列表和正确答案在Answer的索引r_index;映射表查重:将新试题四个选项的a_index列表按从小到大的顺序排列,形成a_index1、a_index2、a_index3、a_index4,与试题题目内容的c_index、正确选项的索引r_index形成一条记录,对比表格C_A中的记录,如果该记录存在,表明此试题已经存在,不必存储该试题;否则,将新记录插入表格,完成一道新选择题的记录录入数据库工作。The method used in this patent is mainly used to solve the problem of unique storage of test questions. It is mainly divided into three steps: check the content of the question for duplication. If the content of the question already exists, take out the c_index of the content of the question, otherwise assign a new c_index to the content of the new test question and insert it into the Content table; option content query: take out the content and correct answer of each option of the new test question, Compare each option with the a_content in the Answer table of the database, if the option content already exists, take out the a_index with the same option record, otherwise assign a new a_index to the option content, and store the option content Insert the Answer table, if the option is the correct answer, record the a_index of the option as r_index; accordingly, obtain the a_index list of the four option contents and the index r_index of the correct answer in the Answer; check the mapping table: put the new test question 4 The a_index list of each option is arranged in ascending order to form a_index1, a_index2, a_index3, a_index4, and a record is formed with the c_index of the test title content and the index r_index of the correct option. Compared with the record in table C_A, if the record exists, Indicates that the test question already exists, and there is no need to store the test question; otherwise, a new record is inserted into the form, and a record of a new multiple-choice question is entered into the database.

其具体方法步骤为:Its specific method steps are:

(1)在数据库中创建表格:试题内容表Content(c_index,c_content)、试题答案表Answer(a_index,a_content)和题映射表C_A(c_index,a_index1,a_index2,a_index3,a_index4,r_index),初始化m_cindex为Content表中的记录条数,m_aindex为Anwser表中的记录条数;(1) Create tables in the database: test content table Content (c_index, c_content), test answer table Answer (a_index, a_content) and question mapping table C_A (c_index, a_index1, a_index2, a_index3, a_index4, r_index), initialize m_cindex as The number of records in the Content table, m_aindex is the number of records in the Anwser table;

(2)输入将要存入试题库的单项选择题放入处理列表P-List;(2) Input the multiple-choice questions that will be stored in the test question bank and put them into the processing list P-List;

(3)从P-List中取出一道试题T,分析获取试题题目内容T-con,试题的四个选项内容分别放入数组T[1]、T[2]、T[3]、T[4],以及正确选项在数组中的位置r,T{T-con,T[4],r};(3) Take a test question T from the P-List, analyze and obtain the content T-con of the test question, and put the content of the four options of the test question into the arrays T[1], T[2], T[3], T[4 respectively ], and the position of the correct option in the array r, T{T-con, T[4], r};

(4)查询表Content中是否存在与T-con相同的c_content记录,有则执行步骤(5);否则执行步骤(6);(4) Check whether there is a c_content record identical to T-con in the content table, if so, execute step (5); otherwise, execute step (6);

(5)获取相同记录的c_index作为T的c_index;执行步骤(8);(5) Obtain the c_index of the same record as the c_index of T; perform step (8);

(6)m_cindex+1;(6) m_cindex+1;

(7)m_cindex作为试题T新分配的c_index插入Content表;(7) m_cindex is inserted into the Content table as the newly allocated c_index of test question T;

(8)i=1;(8)i=1;

(9)查询表Answer中是否存在与T[i]相同的a_content记录,有则执行步骤(10);否则执行步骤(11);(9) Whether there is an a_content record identical to T[i] in the query table Answer, if so, execute step (10); otherwise execute step (11);

(10)获取相同记录的a_index作为T[i]的a_index;执行步骤(13);(10) obtain the a_index of the same record as the a_index of T[i]; perform step (13);

(11)m_aindex+1;(11) m_aindex+1;

(12)m_aindex为T[i]新分配的a_index,插入Answer表;(12) m_aindex is the newly allocated a_index of T[i], which is inserted into the Answer table;

(13)如果i=r,执行步骤(14),否则执行步骤(15);(13) If i=r, execute step (14), otherwise execute step (15);

(14)r_index=T[i]的a_index;(14) r_index=a_index of T[i];

(15)i+1;(15)i+1;

(16)如果i>4执行步骤(17);否则执行步骤(9);(16) If i>4 execute step (17); otherwise execute step (9);

(17)将T[1]、T[2]、T[3]、T[4]的a_index以从小到大的顺序排列,依次记为a_index1、a_index2、a_index3、a_index4;(17) Arrange the a_indexes of T[1], T[2], T[3], and T[4] in ascending order, and record them as a_index1, a_index2, a_index3, and a_index4;

(18)查询表C_A中是否存在记录(c_index,a_index1,a_index2,a_index3,a_index4,r_index),存在执行步骤(19),否则执行步骤(20);(18) Whether there is a record (c_index, a_index1, a_index2, a_index3, a_index4, r_index) in the query table C_A, there is an execution step (19), otherwise the execution step (20);

(19)判定试题T为已存在试题,放弃录入试题库,执行步骤(21);(19) Determine that the test question T is an existing test question, give up entering the test question bank, and perform step (21);

(20)判定试题T为不存在试题,将记录插入表C_A;(20) Determine that the test question T does not exist, and insert the record into the table C_A;

(21)判断P-List是否为空,非空则执行步骤(3);否则程序中止。(21) Determine whether the P-List is empty, and if it is not empty, execute step (3); otherwise, the program is terminated.

其具体实施模式是这样的:Its specific implementation mode is as follows:

整个方法部署在数据库之上,为用户提供试题录入接口,当有试题来临时,将试题题目内容和选项内容分离,将题目内容查重后插入数据库的题目内容表,获取该题目内容的索引,将试题的各个选项查重后插入数据库的选项内容表,获取各个选项内容的索引。将题目内容和选项内容的索引,作为一条记录查重后插入数据库,完成一道选择题的记录。The whole method is deployed on the database to provide users with a test question entry interface. When a test question comes, the content of the test question and the option content are separated, and the content of the question is checked and inserted into the question content table of the database to obtain the index of the question content. Check each option of the test question and insert it into the option content table of the database to obtain the index of each option content. The index of the topic content and option content is inserted into the database as a record for duplicate checking, and a record of a multiple-choice question is completed.

Claims (2)

1.一种电子选择题库的存储管理方法,其特征是:该方法在数据库中创建三个表格用来存储电子试题:试题内容表Content(c_index,c_content)用于存储选择题的题目,使用c_index属性唯一表示试题内容,c_content存放选择题目内容;试题答案表Answer(a_index,a_content),用于存储选择题的选项,使用a_index属性唯一表示选项内容,a_content存放选项内容;试题映射表C_A(c_index,a_index1,a_index2,a_index3,a_index4,r_index),用于存储试题内容和试题答案之间的联系,c_index为试题题目内容在Content表中的c_index,a_index1/a_index2/a_index3/a_index4用于记录试题的四个选项内容分别在Answer表中的a_index,r_index用于记录正确答案选项在Answer中的index;1. a kind of storage management method of electronic multiple-choice question storehouse, it is characterized in that: the method creates three forms in database and is used for storing electronic test questions: test question content table Content (c_index, c_content) is used for storing the title of multiple-choice questions, uses c_index The attribute uniquely indicates the content of the test question, and c_content stores the content of the selected question; the answer table Answer(a_index, a_content) of the test question is used to store the options of the multiple-choice question, and the a_index attribute is used to uniquely represent the content of the option, and a_content stores the content of the option; a_index1, a_index2, a_index3, a_index4, r_index), used to store the connection between the test question content and the test question answer, c_index is the c_index of the test question content in the Content table, and a_index1/a_index2/a_index3/a_index4 are used to record the four test questions The content of the options is in the a_index in the Answer table, and r_index is used to record the index of the correct answer option in the Answer; 本专利所使用的方法主要用于解决试题的唯一性存储问题,主要分为三步执行:题目内容查重,当有新试题存储时,首先取出新试题题目内容,使之与数据库的试题内容表Content中的c_content作对比,如果该题目内容已经存在,取出该题目内容的c_index,否则为新试题内容分配新的c_index,并插入Content表;选项内容查询:取出新试题各个选项的内容和正确答案,分别将每个选内容与数据库的试题答案表Answer表中的a_content作对比,如果该选项内容已存在,取出具有相同选项记录的a_index,否则为该选项内容分配新的a_index,并将该选项内容插入Answer表,如果该选项为正确答案,将该选项的a_index记为r_index;据此,分别获取四个选项内容的a_index列表和正确答案在Answer的索引r_index;映射表查重:将新试题四个选项的a_index列表按从小到大的顺序排列,形成a_index1、a_index2、a_index3、a_index4,与试题题目内容的c_index、正确选项的索引r_index形成一条记录,对比表格C_A中的记录,如果该记录存在,表明此试题已经存在,不必存储该试题;否则,将新记录插入表格,完成一道新选择题的记录录入数据库工作。The method used in this patent is mainly used to solve the problem of unique storage of test questions. It is mainly divided into three steps: check the content of the question for duplication. When there is a new test question stored, first take out the content of the new test question to make it consistent with the content of the test question in the database. For comparison with c_content in the table Content, if the title content already exists, take out the c_index of the title content, otherwise assign a new c_index for the new test content and insert it into the Content table; option content query: take out the content and correctness of each option of the new test question Answer, compare each option content with the a_content in the Answer table of the test question answer table of the database, if the option content already exists, take out the a_index with the same option record, otherwise assign a new a_index for the option content, and put the The content of the option is inserted into the Answer table. If the option is the correct answer, the a_index of the option is recorded as r_index; accordingly, the a_index list of the four option content and the index r_index of the correct answer in Answer are respectively obtained; The a_index list of the four options of the test question is arranged in ascending order to form a_index1, a_index2, a_index3, a_index4, and a record is formed with the c_index of the test question content and the index r_index of the correct option. Compared with the records in table C_A, if the record Existence indicates that the test question already exists, and there is no need to store the test question; otherwise, a new record is inserted into the table, and a record of a new multiple-choice question is entered into the database. 2.根据权利要求1所述的基于数据库的题库唯一性存储方法,其特征是:其具体方法步骤为:2. the method for storing the uniqueness of the question bank based on the database according to claim 1 is characterized in that: its concrete method steps are: (1)在数据库中创建表格:试题内容表Content(c_index,c_content)、试题答案表Answer(a_index,a_content)和题映射表C_A(c_index,a_index1,a_index2,a_index3,a_index4,r_index),初始化m_cindex为Content表中的记录条数,m_aindex为Anwser表中的记录条数;(1) Create tables in the database: test content table Content (c_index, c_content), test answer table Answer (a_index, a_content) and question mapping table C_A (c_index, a_index1, a_index2, a_index3, a_index4, r_index), initialize m_cindex as The number of records in the Content table, m_aindex is the number of records in the Anwser table; (2)输入将要存入试题库的单项选择题放入处理列表P-List;(2) Input the multiple-choice questions that will be stored in the test question bank and put them into the processing list P-List; (3)从P-List中取出一道试题T,分析获取试题题目内容T-con,试题的四个选项内容分别放入数组T[1]、T[2]、T[3]、T[4],以及正确选项在数组T中的位置r,形成T{T-con,T[4],r};(3) Take a test question T from the P-List, analyze and obtain the content T-con of the test question, and put the content of the four options of the test question into the arrays T[1], T[2], T[3], T[4 respectively ], and the position r of the correct option in the array T, forming T{T-con, T[4], r}; (4)查询表Content中是否存在与T-con相同的c_content记录,有则执行步骤(5);否则执行步骤(6);(4) Check whether there is a c_content record identical to T-con in the content table, if so, execute step (5); otherwise, execute step (6); (5)获取相同记录的c_index作为T的c_index;执行步骤(8);(5) Obtain the c_index of the same record as the c_index of T; perform step (8); (6)m_cindex+1;(6) m_cindex+1; (7)m_cindex作为试题T新分配的c_index插入Content表;(7) m_cindex is inserted into the Content table as the newly allocated c_index of test question T; (8)i=1;(8)i=1; (9)查询表Answer中是否存在与T[i]相同的a_content记录,有则执行步骤(10);否则执行步骤(11);(9) Whether there is an a_content record identical to T[i] in the query table Answer, if so, execute step (10); otherwise execute step (11); (10)获取相同记录的a_index作为T[i]的a_index;执行步骤(13);(10) obtain the a_index of the same record as the a_index of T[i]; perform step (13); (11)m_aindex+1;(11) m_aindex+1; (12)m_aindex为T[i]新分配的a_index,插入Answer表;(12) m_aindex is the newly allocated a_index of T[i], which is inserted into the Answer table; (13)如果i=r该选项为正确选项,执行步骤(14),否则执行步骤(15);(13) If this option of i=r is correct option, execute step (14), otherwise execute step (15); (14)r_index=T[i]的a_index;(14) r_index=a_index of T[i]; (15)i+1;(15)i+1; (16)如果i>4执行步骤(17);否则执行步骤(9);(16) If i>4 execute step (17); otherwise execute step (9); (17)将T[1]、T[2]、T[3]、T[4]的a_index以从小到大的顺序排列,依次记为a_index1、a_index2、a_index3、a_index4;(17) Arrange the a_indexes of T[1], T[2], T[3], and T[4] in ascending order, and record them as a_index1, a_index2, a_index3, and a_index4; (18)查询表C_A中是否存在记录(c_index,a_index1,a_index2,a_index3,a_index4,r_index),存在执行步骤(19),否则执行步骤(20);(18) Whether there is a record (c_index, a_index1, a_index2, a_index3, a_index4, r_index) in the query table C_A, there is an execution step (19), otherwise the execution step (20); (19)判定试题T为已存在试题,放弃录入试题库,执行步骤(21);(19) Determine that the test question T is an existing test question, give up entering the test question bank, and perform step (21); (20)判定试题T为不存在试题,将记录插入表C_A;(20) Determine that the test question T does not exist, and insert the record into the table C_A; (21)判断P-List是否为空,非空则执行步骤(3);否则程序中止。(21) Determine whether the P-List is empty, and if it is not empty, execute step (3); otherwise, the program is terminated.
CN2012100669276A 2012-03-14 2012-03-14 A management method for warehousing and storing single choice questions in electronic question bank Pending CN102662990A (en)

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)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1932795A (en) * 2006-10-10 2007-03-21 青岛中科恒信信息技术有限公司 Examination paper intelligent proposition paper system
CN101196870A (en) * 2007-12-19 2008-06-11 济南钢铁股份有限公司 Item database organization and automatic volume group implementing method and system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1932795A (en) * 2006-10-10 2007-03-21 青岛中科恒信信息技术有限公司 Examination paper intelligent proposition paper system
CN101196870A (en) * 2007-12-19 2008-06-11 济南钢铁股份有限公司 Item database organization and automatic volume group implementing method and system

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
刘德山 等: "题库系统存储结构研究", 《辽宁师范大学学报(自然科学版)》 *
康博创作室: "《Access 2000中文版实用教程》", 31 October 1999 *
许旻: "题库系统中的数据结构", 《苏州教育学院学报》 *

Similar Documents

Publication Publication Date Title
Porras et al. Code camps and hackathons in education-literature review and lessons learned
CN102542068A (en) Cloud-storage based electronic test question storage management method
CN102542418A (en) Cloud storage-based campus resource sharing method
CN106023009A (en) Method and system for establishing test paper question bank
Shi et al. Trends of cloud computing in education
Fong English in China: Language, identity and culture
CN103955875A (en) Computer application examination system
Nielsen et al. Capturing evaluation capacity: Findings from a mapping of evaluation capacity instruments
CN103559585A (en) Method and system for achieving library comprehensive performance evaluation
CN113806566A (en) Digital teaching material resource library and construction method thereof
CN102662990A (en) A management method for warehousing and storing single choice questions in electronic question bank
KR20100006799A (en) Online assessment item management and method thereof
CN112750054A (en) Education training course resource management cloud service system
Liu et al. Pilot testing the Chinese version of the ETS® proficiency profile critical thinking test
Zhu et al. Development and validation of information literacy assessment tool for primary students
CN113327473A (en) Virtual simulation teaching training system, control method, device and storage medium
Sutton Metadata quality, utility and the semantic web: The case of learning resources and achievement standards
Nastiti et al. Knowledge Sharing Practices in Academics
Lu et al. Research and implementation of general online examination system
Fang Teacher Evaluation Based on E-Teaching Portfolio—Developing Trend of Teacher Evaluation in China
Jin et al. A Study of Clustering Analysis Based on the Classification of Higher Vocational Colleges in Hb Province
Lu et al. Study of Papers Automatically Generated Functions of Photoshop Course Based on Smart Materials
Budiarto et al. Design and Implementation of a Web-Based Library Management System
CN119166703A (en) Test question data acquisition method, equipment, medium and product
CN114611960A (en) A cloud computing teaching platform based on big data

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