• 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을 효율적으로 정의하고 추가하는 방법 그리고 시스템 모델링을 효과적으로 구성하는 방법에 대한 연구를 통해 본 연구를 더욱 개선시킬 수 있을 것이다.

• Journal of the Korean Institute of Landscape Architecture
• /
• v.40 no.5
• /
• pp.73-87
• /
• 2012

Nowadays, the Korean society is full of multiculturalism as there are many foreign ethnic enclaves. Many Chinese quarters are built in various parts of Korea along with the increasing population of Chinese immigrant. Especially, the Chinese quarter has shown the sign of time and the cultural characteristic of the local residents. This research is to study the market space of Chinese ethnic enclaves in Dairimdong. This research method is the field study to use a participant observation. Below are the research results: Chinese merchants put a private object such as "tanzi" on a sidewalk and install large awning covered full of sidewalk. Sidewalk transform from an outdoor space into an internal space because of Chinese merchants. Passers-by move to use vehicle roads and transform not only the car's space but also the passers-by space. Urban planners originally classify space into three categories, which are building - sidewalk - vehicles road. However, after Chinese came to the market, Chinese classified space into new three categories which is building - space for both sidewalk and "tanzi" - space for both sidewalk and vehicles road. New classification of space is quite different from the previous. In addition, Chinese thinks that the Dairimdong's Market is a very comfortable place. Because Dairimdong Market have many Chinese physical facilities. Next, Chinese thinks that the Dairimdong Market is a very friendly place to buy Chinese products easily. This market has become a place of consumption for the Chinese. Eventually, Dairimdong's Market has changed because of Chinese immigrants. It is possible to make satisfactory planning and design proposal to build Chinese quarters in the future through the explanation of space and status by way of culture. There are many careless mistakes in previous subjective planning and design proposal of the designers. Thus, it should consider the problems created by their way of use in later planning and design.

• The Transactions of the Korea Information Processing Society
• /
• v.5 no.10
• /
• pp.2575-2583
• /
• 1998

The productionof the highly relible softwae systems and theirs performance evaluation hae become important interests in the software industry. The software evaluation has been mainly carried out in ternns of both reliability and performance of software system. Software reliability is the probability that no software error occurs for a fixed time interval during software testing phase. These theoretical software reliability models are sometimes unsuitable for the practical testing phase in which a software error at a certain testing stage occurs by causes of the imperfect debugging, abnornal software correction, and so on. Such a certatin software testing stage needs to be considered as an outlying stage. And we can assume that the software reliability does not improve by means of muisance factor in this outlying testing stage. In this paper, we discuss Bavesian software reliability growth modeling and estimation procedure in the presence of an imidentitied outlying software testing stage by the modification of Jehnski Moranda. Also we derive the Bayes estimaters of the software reliability panmeters by the assumption of prior information under the squared error los function. In addition, we evaluate the proposed software reliability growth model with an unidentified outlying stage in an exchangeable model according to the values of nuisance paramether using the accuracy, bias, trend, noise metries as the quantilative evaluation criteria through the compater simulation.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.17 no.12
• /
• pp.292-300
• /
• 2016

The purpose of this study was to investigate the effects of case-based learning about infants and toddlers on healthcare department students, using a video in an emergency care environment. A total of 57 students from a healthcare department of D university in J city were enrolled. They were divided into two groups: The experimental group (n=29) and the control group (n=28). This study is pre-post designed with a non-equivalent control group. The experimental group received a 1-week education for a duration of 3 weeks (3 sessions in total) with 180 minutes per session. The control group received a traditional curriculum of lecture. Before and after the education, we measured the knowledge and skill confidence of emergency care toward infants and toddlers, the academic self-efficacy, and problem solving ability. Data collection and intervention were carried out from November to December of 2014. Data were analyzed with x2-test, paired t-test, unpaired t-test with SPSS version 20.0 Program. The experimental group showed a significantly higher improvement of skill confidence of emergency care toward infants and toddlers (P<001), as well as preferred task difficulty among sub-items of academic self-efficacy (p=.029), approach avoidance style (P=.001), and problem solving confidence (p=.040) among sub-items of problem solving ability on preference compared with the control group. In this study, a case-based learning was verified to be an effective teaching method to enhance professional competency of healthcare department students. The findings from this study suggest that a case-based learning using various educational contents should be developed, expanded, and carried out to promote better learning.

• Korean Journal of Soil Science and Fertilizer
• /
• v.39 no.3
• /
• pp.144-150
• /
• 2006

Chemical characteristics and their interrelationships of 156 soils included by 74 sandy loam and 82 loam soils collected from plastic film house in Chungbuk area were investigated from 1998 to 2001. Seventeen chemical properties including pH, organic matter (OM), electrical conductivity (EC), inorganic nitrogen, available phosphorus, exchangeable cations, CEC, etc., were analyzed by correlation, standardized partial regression coefficient, and principal factor analysis. Standardized partial regression coefficients of chemical properties were estimated to determine the degree of contribution of EC and OM contents in soils. Principal factor analysis was applied to classify the studied chemical properties into different groups having similar chemical properties. The pH of experimental soils ranged from 4.24 to 7.14 and 4.95 to 7.35 for loam and sandy loam soils, respectively. The EC of soils varied from 0.93 to $15.65dS\;m^{-1}$ for loam and $0.91{\sim}22.30dS\;m^{-1}$ for sandy loam soils, respectively with significant differences among them. The EC measured by 1:5 $H_2O$ dilution method and saturation method were significantly related with 8.163 and 8.599 as the slopes of regression equation for loam and sandy loam soils, respectively. These slopes more than 8.0 in this regression equation was higher than the slope of 5.0 that is estimated from dilution coefficient suggesting that EC measured by 1:5 dilution method might be erratic. The standardized partial regression coefficient of different chemical properties for the estimation of EC was in the order of $NO_3{^-}$ > $Cl^-$ > OM > exchangeable Mg for loam soils and $NO_3{^-}$ > exchangeable Mg > $Cl^-$ for sandy loam soils. Contribution order of the chemical properties based on standardized partial regression coefficient differed 1:5 dilution method and saturation method, indicating that different chemical compounds might be present in the extract solutions of these two methods. Consequently the measurement of EC by saturation method was thought be still better for estimation of chemical property because accuracy of EC measurement by 1:5 dilution method can't be improved by any specific coefficient for adjustment of EC. Regardless of differences in soil textures and extraction methods, correlation coefficients between EC and the other chemical properties were routinely in the order of $NO_3{^-}$ > $Cl^-$ > degree of base saturation > exchangeable Mg > exchangeable Ca > $SO{_4}^{2-}$. The principal factor analysis revealed four factor groups of the chemical properties studied. The groups for sandy loam were as follows; ; 1. salt components, 2. soil reaction components, 3. fixed and adsorption components, 4. CEC components. The groupings of loam soils were similar to sandy loam except that exchangeable Na substituted the CEC of sandy loam.

• Journal of Technology Innovation
• /
• v.22 no.4
• /
• pp.235-259
• /
• 2014

New product or new technology developments are directly linked to a firm's survival and thus their performance and improvement are gaining attention in the midst of rapidly changing business environment and aggravating competition. However, despite SMEs' significance in the national economy, they are limited in terms of size and resources in possession, so the government provides a variety of supports as a policy. According to a study on the organizational life cycle, a firm's limits and difficulties differ by growth stage, so the supports need to be tailored. Based on the data from 2,575 firms that responded to the "2011 SMEs Technological Statistics," how technological capability level and deviation in the R&D process affect the R&D sales performance was studied. The result of analysis revealed that the technological capability has a positive impact on the R&D sales performance. It was also learned that the relationship between deviation in the technological capability and R&D sales performance was moderated by the government support. For the hypothesis that the government support would have a different moderating effect by growth stage for the impact the technology level has on the R&D sales performance, the empirical analysis showed a different meaningful moderating effect for each growth stage. The theoretical implications of the study are that, instead of a simple relation of dynamics that does not take the growth stages into account, it suggested a more realistic causal relationship model that reflects the complex environment the SMEs are in and that the need for measuring and using the deviation in technological capability as a research variable has been justified. The practical implications are that the government policy for supports can be tailored to a growth stage and that the guidelines have been suggested to effectively use the government funding by encouraging the SMEs in a different growth stage to adapt to the customized policy.

• Journal of Radiation Protection and Research
• /
• v.20 no.1
• /
• pp.45-52
• /
• 1995

This study is to compare A point doses in human pelvic phantom by film dosimetry, computer planning and manual calculation by using of along-away table. We developed tissue equivalent human pelvic phantom composed of four pieces of cylindrical acryl tubes with water, to simulate intracavitary radiation (ICR) in patients with cervix cancer. When the phantom assembled from 4 pieces, it has a small space for inserting Fletcher-Suit-Delclos applicator like a human vagina. Fletcher-Suit-Delclos applicator inserted into the space was packed tightly with furacin gauzes, and three $^{137}Cs$ sources with radioactivity of $15.7mg\;Ra-eq$ were inserted into the tandem. For the film dosimetry, two pieces of X-OMAT V film (Kodak Co.) of which planes include point A, were arranged orthogonally in the slits between phantoms. A point dose and iso-dose curves were measured by means of optical densitometer. A point doses by film dosimetry, RTP system and manual calculation by using of along-away table were compared, and iso-dose curves by film dosimetry and computer planning were also compared. The dose of A point was 51.2cGy/hr by film dosimetry, 46.7cGy/hr by RTP system and 47.9 cGy/hr by along-away table. A point dose by computer planning was similar to the dose by calculation using of along-away table with acceptable accuracy $({\pm}3%)$, however, the dose by film dosimetry was different from two others with about 10% error. Since most clinical beams contains a scatter component of low energy photons, the correlation between optical density and dose becomes tenuous. In addition, film suffers from several potential errors such as changes in processing conditions, interfilm emulsion differences, and artifacts caused by air pockets adjacent to the film. For these reasons, absolute dosimetry with film is impractical, however, it is very useful for checking qualitative patterns of a radiation distribution. In future, solid state dosimeter such as TLD must be used for the dosimetry of ionizing radiation. When considerable care is used, precision of approximately 3% may be obtained using TLD.

• Tuberculosis and Respiratory Diseases
• /
• v.46 no.5
• /
• pp.662-673
• /
• 1999

Background : Pressure-controlled ventilation (PCV) is frequently used recently as the initial mode of mechanical ventilation in the patients with respiratory failure. Theoretically, because of its high initial inspiratory flow, pressure-controlled ventilation has lower peak inspiratory pressure and improved gas exchange than volume-controlled ventilation (VCV). But the data from previous studies showed controversial results about the gas exchange. Moreover, the comparison study between PCV and VCV with various inspiration : expiration time ratios (I : E ratios) is rare. So this study was performed to compare the respiratory mechanics and gas exchange between PCV and VCV with various I : E raitos. Methods : Nine patients receiving mechanical ventilation for respiratory failure were enrolled. They were ventilated by both PCV and VCV with various I : E ratios (1 : 2, 1 : 1.3 and 1.7 : 1). $FiO_2$, tidal volume, respiratory rate and external positive end-expiratory pressure (PEEP) were kept constant throughout the study. After 20 minutes of each ventilation mode, arterial blood gas, airway pressures, expired $CO_2$ were measured. Results : In both PCV and VCV, as the I : E ratio increased, the mean airway pressure was increased, and $PaCO_2$ and physiologic dead space fraction were decreased. But P(A-a)$O_2$ was not changed. In all three different I : E ratios, peak inspiratory pressure was lower during PCV, and mean airway pressure was higher during PCV. But $PaCO_2$ level, physiologic dead space fraction and P(A-a)$O_2$ were not different between PCV and VCV with three different I : E ratios. Conclusion : There was no difference in gas exchange between PCV and VCV under the same tidal volume, frequency and I : E ratio.

• Journal for History of Mathematics
• /
• v.22 no.3
• /
• pp.1-30
• /
• 2009

Frege's logicism has been frequently regarded as a development in number theory which succeeded to the so called arithmetization of analysis in the late 19th century. But it is not easy for us to accept this opinion if we carefully examine his actual works on real analysis. So it has been often argued that his logicism was just a philosophical program which had not contact with any contemporary mathematical practices. In this paper I will show that these two opinions are all ill-founded ones which are due to the misunderstanding of the theoretical place of Frege's logicism in the context of contemporary mathematical practices. Firstly, I will carefully examine Cantorian definition of real numbers and Frege's critiques of it. On the basis of this, I will show that Frege's aim was to produce the purely logical definition of ratios of quantities. Secondly, I will consider the mathematical background of Frege's logicism. On the basis of this, I will show that his standpoint in real analysis was much subtler than what we used to expect. On the one hand, unlike Weierstrass and Cantor, Frege wanted to get such real analysis that could be universally applicable. On the other hand, unlike most mathematicians who insisted on the traditional conceptions, he would not depend upon any geometrical considerations in establishing real analysis. Thirdly, I will argue that Frege regarded these two aspects - the independence from geometry and the universal applicability - as those which characterized logic itself and, by logicism, arithmetic itself. And I will show that his conception of real numbers as ratios of quantities stemmed from his methodological maxim according to which the nature of numbers should be explained by the common roles they played in various contexts to which they applied, and that he thought that the universal applicability of numbers could not be adequately explicated without such an explanation.

• Horticultural Science & Technology
• /
• v.30 no.5
• /
• pp.586-595
• /
• 2012

This study was conducted to determine the effects of horticultural therapy (HT) program using hydroponics on work adjustment skills of students with mental retardation. Based on the critical role transitional model and special education curriculum for agriculture, especially hydroponics, HT program (total 22 sessions) using hydroponics procedure for Lettuce (Lactuca sativa L. 'Asia Heuk Romaine') was developed. Fourteen (10 males, 4 females) graded $1^{st}$ to $2^{nd}$ with intellectual disabilities were recruited from a special education class in a high school located in Inchon, Korea and then a special farm for hydroponics in Inchon, Korea was offered for the HT program. The students with intellectual disabilities participated in the HT program for 4-month (from September to December of 2011, twice a week, approximately 60 minutes per session). Before and after the HT program, the McCarron assessment neuromuscular development, emotional behavioral checklist, interpersonal negotiation strategies, and KEPAD picture vocational interest test were performed by the teachers and horticultural therapists. As the results, the students significantly improved motor performance (p = 0.002), emotional behavioral strategies (p = 0.00), and interpersonal negotiation strategies (p = 0.05). However, no significant difference between before and after the HT program for vocational interest was observed. In conclusion, the HT program using hydroponics, consists of simple and easy tasks so that it would be applicable for the students with intellectual disabilities positively affected to work adjustment skills by improving the motor performance, emotional behavioral strategies, and interpersonal negotiation strategies. Additionally, HT programs using hydroponics with various kinds of vegetables are required to develop and to apply in practical settings for improving work adjustment skills.