• Journal of the Korea Society of Computer and Information
• /
• v.24 no.11
• /
• pp.127-133
• /
• 2019

SQL is the most common language in data processing. Therefore, most of the colleges offer SQL in their curriculum. In this research, an auto scoring SQL test is proposed for the efficient results of SQL education. The system was treated with algorithms instead of using expensive DBMS(Data Base Management System) for automatic scoring, and satisfactory results were produced. For this system, the test question bank was established out of 'personnel management' and 'academic management'. It provides users with different sets of test each time. Scoring was done by dividing tables into two sections. The one that does not change the table(select) and the other that actually changes the table(update, insert, delete). In the case of a search, the answer and response were executed at first and then the results were compared and processed, the user's answers are evaluated by comparing the table with the correct answer. Modification, insertion, and deletion of table actually changes the data table, so data was restored by using ROLLBACK command. This system was implemented and tested 772 times on the 88 students in Computer Information Division of our college. The results of the implementation show that the average scoring time for a test consisting of 10 questions is 0.052 seconds, and the performance of this system is distinguished considering that multiple responses cannot be processed at the same time by a human grader, we want to develop a problem system that takes into account the difficulty of the problem into account near future.

• Journal of Internet Computing and Services
• /
• v.23 no.5
• /
• pp.87-101
• /
• 2022

Cyber-attacks occur in the blink of an eye in cyberspace, and the damage is increasing all over the world. Therefore, it is necessary to develop a cyber common operational picture that can grasp the various assets belonging to the 3rd layer of cyberspace from various perspectives. By applying the method for grasping battlefield information used by the military, it is possible to achieve optimal cyberspace situational awareness. Therefore, in this study, the visualization screens necessary for the cyber common operational picture are identified and the criteria (response speed, user interface, object symbol, object size) are investigated. After that, the framework is designed by applying the identified and investigated items, and the visualization screens are implemented accordingly. Finally, among the criteria investigated by the visualization screen, an experiment is conducted on the response speed that cannot be recognized by a photograph. As a result, all the implemented visualization screens met the standard for response speed. Such research helps commanders and security officers to build a cyber common operational picture to prepare for cyber-attacks.

• Journal of the Korean Society for Library and Information Science
• /
• v.31 no.4
• /
• pp.289-318
• /
• 1997

The purpose of this study is to identify users behavioral characteristics for using the online catalog opened in May 1996 at Duksung Women's University Library. 278 student users were surveyed from October 4th to 8th in 1996. Major findings are as follows. 1. Most users$(87.4\%)$ prefer the online catalog to the card catalog and regard the online catalog easy to use$(89.6\%)$ 2. $(65.8\%)$ of users are active users who frequently use the online catalog at least 10 times or more per semester. 3. $10.4\%$ of users feel the online catalog difficult because they do not know how to use it. 4. Most users prefer the menu search mode among menu, command and fill-in-blank search modes offered by DISCOVER. The most preferred access points are the title for known-item search and subject headings for subject search. 5. User's attitude toward the online catalog is very favorable$(83.5\%)$, however, the search success rate is rather low $(77.0\%)$ compared to that of the card catalog $(87.0\%)$ 6. The title and author are regarded easy to use among access points offered by DISCOVER. Classification numbers and call numbers are the least easy access points to use. 7. Since users show lack of knowledge of how to use the online catalog, education and training programs on the online catalog use for users are needed. 8. Users showed different search patterns for pursuing different search goals. The most preferred access points are the title for known-item search and subject headings for subject search. These search behaviors are different from those in using the card for both the known-item search and subject search was the title.