• Journal of the Korea Society of Computer and Information
• /
• v.14 no.4
• /
• pp.101-109
• /
• 2009

An encryption module is equipped basically at 8i version ideal of Oracle DBMS, encryption module, but a performance decrease is caused, and users are restrictive. We analyze problem of DB security by technology by circles at this paper whether or not there is an index search, object management disorder, a serious DB performance decrease by encryption, real-time data encryption beauty whether or not there is data approach control beauty circular-based IP. And presentation does the comprehensive security Frame Work which utilized the DB Masking technique that is an alternative means technical encryption in order to improve availability of DB security. We use a virtual account, and set up a DB Masking basis by security grades as alternatives, we check advance user authentication and SQL inquiry approvals and integrity after the fact through virtual accounts, utilize to method as collect by an auditing log that an officer was able to do safely DB.

• Journal of Korean Academy of Nursing
• /
• v.44 no.1
• /
• pp.64-74
• /
• 2014

Purpose: This study was done to develop and implement the Nursing KMS (knowledge management system) in order to improve knowledge sharing and creation among clinical nurses in outpatient departments. Methods: This study was a methodological research using the 'System Development Life Cycle': consisting of planning, analyzing, design, implementation, and evaluation. Quality Function Deployment (QFD) was applied to establish nurse requirements and to identify important design requirements. Participants were 32 nurses and for evaluation data were collected pre and post intervention at K Hospital in Seoul, a tertiary hospital with over 1,000 beds. Results: The Nursing KMS was built using a Linux-based operating system, Oracle DBMS, and Java 1.6 web programming tools. The system was implemented as a sub-system of the hospital information system. There was statistically significant differences in the sharing of knowledge but creating of knowledge was no statistically meaningful difference observed. In terms of satisfaction with the system, system efficiency ranked first followed by system convenience, information suitability and information usefulness. Conclusion: The results indicate that the use of Nursing KMS increases nurses' knowledge sharing and can contribute to increased quality of nursing knowledge and provide more opportunities for nurses to gain expertise from knowledge shared among nurses.

• Journal of Korean Academy of Nursing Administration
• /
• v.12 no.1
• /
• pp.14-22
• /
• 2006

Purpose: The purpose of this study is developing the nursing information system which contains the core elements of nursing practice, the Nursing Minimum Data Set (NMDS) that should be collected and documented all the settings in which nursing care is provided. Method: The program was developed under the hospital information system by TCP/IP protocol and used NANDA, Nursing Interventions Classification (NIC), and Nursing Outcomes Classification (NOC) to fill out the elements of NMDS. The Oracle was used as DBMS under the Windows 98 environment and Power Builder 5.0 was used as a program language. Results: This study developed linkage among the NANDA-NOC-NIC to facilitate choosing correct nursing diagnosis, interventions, and outcomes and stimulate nurses' critical thinking. Also the system developed includes nursing care sensitive patient outcomes, so nurses can actively involve in nursing effectiveness research by analyzing the data stored in the database or by making relational databases with other health care related databases. Conclusion: The program developed in this study ultimately can be used for the nursing research, policy development, reimbursement of nursing care, and calculating staffing and nursing skill mix by providing tool to describe and organize nursing practice and measure the nursing care effectiveness.

• Magazine of the Korean Society of Agricultural Engineers
• /
• v.35 no.2
• /
• pp.65-72
• /
• 1993

When a drought occurs in an area irrigated by multi-reservoirs, onerating a single reservoir separately to control the reservoir' storage is not a desirable solution. In order to reduce damages effectively for the areal drought, the storage of the reservoirs within the areal boundary should be managed as a group. Storage management procedures are as follows : 1. Collecting and checking the present storages of all reservoirs 2. Computing the drought frequency and depth; and finally, establishing a suitable storage saving strategy based on the estimated drought depth. For the purpose of this storage management, the RESTOMS(Reservoirs Storage Management System) was developed and the system was composed of the PRIME computer and the ORACLE as a distributed database management system, which was the host computer of Rural Development Corporation and would be on-lined with the regional offices throughout the country. Reservoirs operated by Farm Land Improvment Association were comprised in the DB system. Using the RESTOMS, the drought frequencies and drought depths were calculated with respect to the reservoir storage records(1967 to 1992). It was obvious that the results were closely corresponding to the real drought records.

• Spatial Information Research
• /
• v.19 no.6
• /
• pp.19-28
• /
• 2011

Recently, the interests of marine mineral resources has been increasing from the depletion of land resources around the world and many countries are involving in marine exploration work. South Korea is also currently performing exploration work to estimate the marine mineral resources around the Korean Peninsula. However, massive amounts of marine exploration data accumulated from the long-term exploration work have not been systematically managed. The data have been managed by the file based system instead of commercial database. The aim of this study is to construct GIS-based Marine Mineral Resource Information System using a spatial database for the core sediments of the marine exploration data. For constructing such DB system, GIS-based data items were classified, and a database was designed using relational database model. The database was constructed using commercial DBMS(Database Management System), Oracle. Also, necessary functions of the system were defined for the effective use of database based on users' requirement analysis. The GIS-based Marine Mineral Resource Information System has enabled to support the systematic management of the marine exploration data. Furthermore, it is expected that this spatial database will be useful in estimating the reserves of the mineral resources and provide valuable information for economic evaluation. In the future, the application of advanced techniques of spatial analysis and 3-dimensional display function will be required.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.4 no.3
• /
• pp.41-50
• /
• 2001

Recently our nature of environment has destroyed by a large scaled forest fire. In order to manage these forest fires, forecasting of it is considered as the most important thing. In this paper the database related to forest fire was first built and the efficient forest fire information management system was implemented by using GIS. The main goal of this system is that forest fire managers have GUI(graphic user interface) to analyze data of forest fire effectively and update and retrieve information in database. For the efficient GUI, this system is built in Visual Basic 6.0 and Map Object 2.0. Map Object 2.0 is combined to have various and powerful functionality of GIS analysis as component ware. The Oracle 8.0 is used as DBMS in this study to manage all the spatial and attributed information in database effectively. In the future, this system will play a critical role as making a decision supporting system for scientific forest fire protection and help real time forest fire hazard information offers service for public welfare administration business management.

• The Journal of Society for e-Business Studies
• /
• v.15 no.4
• /
• pp.1-19
• /
• 2010

Recently, it is necessary to process real time sensor data, which is generated from ubiquitous environments. Data, which are written by XML, are small, but, large volumes of data. Therefore, weneed to use an efficient method for processing a large amount of it. An XQuery has two types for sensor data: one is to get sensor identification and value from sensor data; the other is restructuring for user's convenience. Existing XQuery engines don't have efficient method for batch processing of sensor data. This paper proposed the twig query processing over reverse path summary, and we developed and applied restructuring batch processing method for real time processing of a large amount of sensor data. Finally, we do performance evaluation using XMark and RFID EPC data, and comparison analysis with MonetDB/XQuery and Berkeley DB XML.

• Proceedings of the Korean Information Science Society Conference
• /
• 2007.06a
• /
• pp.17-18
• /
• 2007

데이터베이스 튜닝은 일반적으로 데이터베이스 어플리케이션을 "좀 더 빠르게" 실행하게 하는 일련의 활동을 뜻한다[1]. 데이터베이스 관리자가 튜닝에 필요한 주먹구구식 룰(Rule of thumb)들을 모두 파악 하고 상황에 맞추어 적용하는 것은 비싼 비용과 오랜 시간을 요구한다. 그렇게 때문에 서로 다른 어플 리케이션들이 맞물려 있는 복잡한 서비스는 필수적으로 자동화된 데이터베이스 성능 관리와 튜닝을 필 요로 한다. 본 논문에서는 이를 해결하기 위하여 지식 도매인(Knowledge Domain)을 기초로 한 자동화 된 데이터베이스 튜닝 원칙(Tuning Principle)을 제시하는 시스템을 제안한다. 각각의 데이터베이스 튜닝 이론들은 지식 도매인의 지식으로 활용되며, 성능에 영향을 미치는 요소들을 개체(Object)와 콘셉트 (Concept)로 구성하고 추론 시스템을 통해 튜닝 원칙을 추론하여 쉽고 빠르게 현재 상황에 맞는 튜닝 방법론을 적용시킬 수 있다. 자동화된 데이터베이스 튜닝에 대해 여러 분야에 걸쳐 학문적인 연구가 이루어지고 있다. 그 예로써 Microsoft의 AutoAdmin Project[2], Oracle의 SQL 튜닝 아키텍처[3], COLT[4], DBA Companion[5], SQUASH[6] 등을 들 수 있다. 이러한 최적화 기법들을 각각의 기능적인 방법론에 따라 다시 분류하면 크게 Design Tuning, Logical Structure Tuning, Sentence Tuning, SQL Tuning, Server Tuning, System/Network Tuning으로 나누어 볼 수 있다. 이 중 SQL Tuning 등은 수치적으로 결정되어 이미 존재하는 정보를 이용하기 때문에 구조화된 모델로 표현하기 쉽고 사용자의 다양한 요구에 의해 변화하는 조건들을 수용하기 쉽기 때문에 이에 중점을 두고 성능 문제를 해결하는 데 초점을 맞추었다. 데이터베이스 시스템의 일련의 처리 과정에 따라 DBMS를 구성하는 개체들과 속성, 그리고 연관 관계들이 모델링된다. 데이터베이스 시스템은 Application / Query / DBMS Level의 3개 레벨에 따라 구조화되며, 본 논문에서는 개체, 속성, 연관 관계 및 데이터베이스 튜닝에 사용되는 Rule of thumb들을 분석하여 튜닝 원칙을 포함한 지식의 형태로 변환하였다. 튜닝 원칙은 데이터베이스 시스템에서 발생하는 문제를 해결할 수 있게 하는 일종의 황금률로써 지식 도매인의 바탕이 되는 사실(Fact)과 룰(Rule) 로써 표현된다. Fact는 모델링된 시스템을 지식 도매인의 하나의 지식 개체로 표현하는 방식이고, Rule 은 Fact에 기반을 두어 튜닝 원칙을 지식의 형태로 표현한 것이다. Rule은 다시 시스템 모델링을 통해 사전에 정의되는 Rule와 튜닝 원칙을 추론하기 위해 사용되는 Rule의 두 가지 타업으로 나뉘며, 대부분의 Rule은 입력되는 값에 따라 다른 솔루션을 취하게 하는 분기의 역할을 수행한다. 사용자는 제한적으로 자동 생성된 Fact와 Rule을 통해 튜닝 원칙을 추론하여 데이터베이스 시스템에 적용할 수 있으며, 요구나 필요에 따라 GUI를 통해 상황에 맞는 Fact와 Rule을 수동으로 추가할 수도 었다. 지식 도매인에서 튜닝 원칙을 추론하기 위해 JAVA 기반의 추론 엔진인 JESS가 사용된다. JESS는 스크립트 언어를 사용하는 전문가 시스템[7]으로 선언적 룰(Declarative Rule)을 이용하여 지식을 표현 하고 추론을 수행하는 추론 엔진의 한 종류이다. JESS의 지식 표현 방식은 튜닝 원칙을 쉽게 표현하고 수용할 수 있는 구조를 가지고 있으며 작은 크기와 빠른 추론 성능을 가지기 때문에 실시간으로 처리 되는 어플리케이션 튜닝에 적합하다. 지식 기반 모률의 가장 큰 역할은 주어진 데이터베이스 시스템의 모델을 통하여 필요한 새로운 지식을 생성하고 저장하는 것이다. 이를 위하여 Fact와 Rule은 지식 표현 의 기본 단위인 트리플(Triple)의 형태로 표현된다, 트리플은 Subject, Property, Object의 3가지 요소로 구성되며, 대부분의 Fact와 Rule들은 트리플의 기본 형태 또는 트리플의 조합으로 이루어진 C Condition과 Action의 두 부분의 결합으로 구성된다. 이와 같이 데이터베이스 시스템 모델의 개체들과 속성, 그리고 연관 관계들을 표현함으로써 지식들이 추론 엔진의 Fact와 Rule로 기능할 수 있다. 본 시스템에서는 이를 구현 및 실험하기 위하여 웹 기반 서버-클라이언트 시스템을 가정하였다. 서버는 Process Controller, Parser, Rule Database, JESS Reasoning Engine으로 구성 되 어 있으며, 클라이 언트는 Rule Manager Interface와 Result Viewer로 구성되어 었다. 실험을 통해 얻어지는 튜닝 원칙 적용 전후의 실행 시간 측정 등 데이터베이스 시스템 성능 척도를 비교함으로써 시스템의 효용을 판단하였으며, 실험 결과 적용 전에 비하여 튜닝 원칙을 적용한 경우 최대 1초 미만의 전처리에 따른 부하 시간 추가와 최소 약 1.5배에서 최대 약 3배까지의 처리 시간 개선을 확인하였다. 본 논문에서 제안하는 시스템은 튜닝 원칙을 자동으로 생성하고 지식 형태로 변형시킴으로써 새로운 튜닝 원칙을 파생하여 제공하고, 성능에 영향을 미치는 요소와 함께 직접 Fact과 Rule을 추가함으로써 커스터마이정된 튜닝을 수행할 수 있게 하는 장점을 가진다. 추후 쿼리 자체의 튜닝 및 인텍스 최적화 등의 프로세스 자동화와 Rule을 효율적으로 정의하고 추가하는 방법 그리고 시스템 모델링을 효과적으로 구성하는 방법에 대한 연구를 통해 본 연구를 더욱 개선시킬 수 있을 것이다.