• Journal of KIISE:Computing Practices and Letters
• /
• v.14 no.5
• /
• pp.467-471
• /
• 2008

With active research on Web ontology, various storages and query languages have been developed to store Web Ontology. As SPARQL usage increases and most of storages are based on relational data base, the necessity of SPARQL-to-SQL translation algorithm development becomes issued. Even though several translation algorithms have been proposed, there still remain the following problems. They do not support fully SPARQL clauses and they are dependent on a specific storage model. This paper proposes a new model to use a specific translation algorithm independently on storages.

• Journal of the Korean Society for Precision Engineering
• /
• v.14 no.1
• /
• pp.69-77
• /
• 1997

본 논문은 금형의 마무리 연마 작업을 로봇을 이용하여 자동화하기 위한 오프라인 프로그래밍 시스템개발을 그 내용으로 하고있다. 3차원 자유곡면 형상을 갖는 금형을 연마하기 위한 로봇 작업 경로를 효율적으로 생성하기 위해서는 기존의 교시 방법이 아닌 CAD시스템과 연계된 시뮬레이션 방식의 자동 경로 생성 방법이 요구된다. 본 연구에서 개발된 금형 연마 작업을 위한 오프라인 프로그래밍 시스템은 연마 작업 시뮬레이션을 위한 기하학적 모델링 기능, 로봇의 작업 공간을 고려한 작업장 배치 기능, 연마 로봇의 효율적인 기구학 해, 3차원 그래픽 시뮬레이션, 3차원 물체간의 충돌 검사 기능 및 유기적인 관계형 데이타 베이스 기능 등으로 구성된다. 본 시스템의 시뮬레이션 결과를 로봇의 위치 보정 과정을 거쳐 로봇 작업 프로그램 으로 변환함으로써 최종적으로 실제 연마 작업이 가능한, 정확하고 안전한 로봇 프로그램을 생성하였다.

• Journal of Korean Academy of Nursing Administration
• /
• v.2 no.1
• /
• pp.73-96
• /
• 1996

In the complexity and diversity of modern society, there is an urgent need for an information system which can systematically collect, manage and analyze data. Especially in the discipline of nursing, a nursing informarion system is necessary to maximize nursing resources and improve nursing care in the present system which is faced with increases in client needs and multiple changes in hospital environments. This research was done to provide a basis for the development of an integrative nursing information system for the future, by designing dababases items which were extracted from an analysis of the ward nursing information system on general wards excluding the OPD, ICU, OR and CSR with functions using a different system from the wards, and the design of output screen used the database items. The ward nursing information system was analysed through analysis of nursing practice related to recordings, such as the worksheet, kardex, and other nursing practice recordings, on 25 wards. The development of the database was the part of the construction of hospital information system and used the database development life cycle which is related to the system development life cycle. The database development steps included selection of database management system and design of a physical database following the principles of the order communication system which is been developing at Y University Hospital. Conceptual database and Logical database were designed using the base of 25 data items and fields derived from analysing the worksheet, the data items and fields derived from the kardex and other nursing practice recording, from these 19 data base tables were framed through transforming the relational database. Through this process, four types of output material for nursing practice recording which nurses can carry and use during their nursing practice were produced.

• The Journal of Korean Institute of Communications and Information Sciences
• /
• v.40 no.6
• /
• pp.1102-1106
• /
• 2015

To provide social security and for cooperative smart camera context awareness processing, each camera stores and exchange context data. For a specific event, measured values with other context data is stored RDB. RDB is transformed to ontology RDF file and is used for context reasoning. Interoperability between smart cameras conforms to ONVIF and constitutes intelligent surveillance system. To guarantee the confidentiality and integrity, securiy techniques are adopted. Security overhead between agents is analyzed in the prototype system implemented.

• Journal of the Korean Society for Library and Information Science
• /
• v.32 no.3
• /
• pp.143-156
• /
• 1998

This paper reports the GEM (Gateway to Educational Materials) project whose goal is to develop an operational framework to provide the K-12 teachers in the world with 'one-stop/any-stop' access to thousands of lesson plans, curriculum units and other Internet-based educational resources. To the IS-element Dublin Core base package, the GEM project added an 8-element, domain-specific GEM package. The GEM project employed the conceptual data modeling approach to designing the GEM database, used the Sybase relational database management system (RDBMS) to construct the backend database for storing the metadata of educational resources, and also employed the active server page (ASP) technology to provide Web interfaces to that database. The consortium members catalog lesson plans and other Internet-based educational resources using a cataloging module program that produces HTML meta tags. A harvest program collects these meta tags across the Internet and outputs an ASCII file that conforms to the standard agreed by the consortium members. A parser program processes this file to enter meta tags automatically into appropriate relational tables in the Sybase database. The conceptual/logical schemas of Dublin Core and GEM profile are presented. The advantages of conceptual modeling approach to manage metadata are discussed. A prototype system that provides access to the GEM metadata is available at http://lis.skku.ac.kr/gem/.

• 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 the Korea Computer Industry Society
• /
• v.3 no.9
• /
• pp.1215-1222
• /
• 2002

This study is design and implementation of XML-based Item Bank System. This system can apply the student with effective assessment by creating, searching and providing of educational problems using XML. In order to supply standard problems to student, first, we analyzed the standard types of various problems and designed these types with XML DTD. Second, we extracted math problem in the elementary school by applying these standard types. Third, we constructed the Item Bank System using relational Data Base and XML parser. The result of system applying, proposed system could offer the student the standard problems at on-line environment. Therefore we shown to be applied educational assessment and integrated non-standard problems effectively.

• Korean Parent-Child Health Journal
• /
• v.1
• /
• pp.115-126
• /
• 1998

It is the base of the health through life, the health of children is very important. The health education is the most effective measure for disease prevention and health promotion. To educate children for the health, we must consider their concept of the health before. Therefore I attempted this study for investigation for the concept about respiratory communicable disease which is one of the most important health problems. The design of this study was descriptive investigational study. The subjects of this study are 4-6 aged 65 children who are attending district nursery school. The tools of this study constituted 3 parts as an etiological agents, environmental agents and host agents. The data were collected by an individual interview and cartoon cards. The results of this study are as followed: 1. The preschool children tend to think contamination along the physical distance, nearer things more relational. 2. The preschool children tend to have their experience centered thinking. 3. There was a highly significant correlation between the children's age and knowledge scores(r = 0.431, P= 0.0003). 4. There wasn't a significant correaltion between sex group. In conclusion, it wad founded that the preschool have a tendancy to think communicable disease along the physical distance and their daily life experiences. This results support the Piaget's cognitive developmental theory. Therefore, to develop the health education program for preschool students, above results must be referenced.

• Journal of Environmental Health Sciences
• /
• v.43 no.4
• /
• pp.307-313
• /
• 2017

Objectives: Chemicals derived from various environment media contaminates food across the food supply chain. In Korea, levels of contaminants in food have been sporadically measured by monitoring programs of different government agencies. There is difficulty with data compilation and integrated analysis across media. Therefore, the aim of this study was to propose an overall integrated database and analytical platform design for the 'ECO-FOOD NET (Environmental COntaminant reduction platform for FOOD through an interagency collaboration NETwork)', a tool to support the reduction of environmental contaminants in food. Methods: We developed a new data structure and standardized protocols for the compilation of integrated data. In addition, we conducted subject-oriented logical and physical relational database modeling and created the architecture design of the platform. Results: We established a standardized code system related to exposure media and route, analysis method and food matrix. In addition, we designed the seven software modules of 'About the System', 'Introduction to Interagency Work', 'Media-Chemicals Profiles', 'Method Bank', 'Monitoring Data Base', 'Integrated Media Analysis', and 'Risk-Benefit Analysis'. Conclusions: This study will contribute to decision-making as a tool for executing risk management, such as sustainable reduction policies of contaminants in food.

• Convergence Security Journal
• /
• v.18 no.3
• /
• pp.133-140
• /
• 2018

As the core technology of the 4th Industrial Revolution is applied to drone, the potential for growth in the field of unmanned aerial vehicles is very large, and the utilization of civilian & military fields in the domestic & foreign is increasing rapidly. Because application areas of drone in the civilian field is various, it is excellent in terms of cost effectiveness and high value in utilization when it is used for military operation support mission. Especially, in the case of the Air Force, it is expected that military usage effectiveness will be high if drone replaces various air operations support missions such as aircraft inspection, supply of military supplies, base security. We find out the missions that can utilize drones for military operations support and propose the recommendation and data management plan accordingly. We recommend the most suitable drones and equipment that perform similar missions in the private sector and propose the data modeling of relational database.