• Title/Summary/Keyword: 제안식 비교 분석

Search Result 971, Processing Time 0.031 seconds

Flood Risk Estimation Using Regional Regression Analysis (지역회귀분석을 이용한 홍수피해위험도 산정)

  • Jang, Ock-Jae;Kim, Young-Oh
    • Journal of the Korean Society of Hazard Mitigation
    • /
    • v.9 no.4
    • /
    • pp.71-80
    • /
    • 2009
  • Although desire for living without hazardous damages grows these days, threats from natural disasters which we are currently exposed to are quiet different from what we have experienced. To cope with this changing situation, it is necessary to assess the characteristics of the natural disasters. Therefore, the main purpose of this research is to suggest a methodology to estimate the potential property loss and assess the flood risk using a regional regression analysis. Since the flood damage mainly consists of loss of lives and property damages, it is reasonable to express the results of a flood risk assessment with the loss of lives and the property damages that are vulnerable to flood. The regional regression analysis has been commonly used to find relationships between regional characteristics of a watershed and parameters of rainfall-runoff models or probability distribution models. In our research, however, this model is applied to estimate the potential flood damage as follows; 1) a nonlinear model between the flood damage and the hourly rainfall is found in gauged regions which have sufficient damage and rainfall data, and 2) a regression model is developed from the relationship between the coefficients of the nonlinear models and socio-economic indicators in the gauged regions. This method enables us to quantitatively analyze the impact of the regional indicators on the flood damage and to estimate the damage through the application of the regional regression model to ungauged regions which do not have sufficient data. Moreover the flood risk map is developed by Flood Vulnerability Index (FVI) which is equal to the ratio of the estimated flood damage to the total regional property. Comparing the results of this research with Potential Flood Damage (PFD) reported in the Long-term Korea National Water Resources Plan, the exports' mistaken opinions could affect the weighting procedure of PFD, but the proposed approach based on the regional regression would overcome the drawback of PFD. It was found that FVI is highly correlated with the past damage, while PFD does not reflect the regional vulnerabilities.

A Comparison of Body Shape Changes Between Deep Tissue Massage and Illite-Combined Deep Tissue Massage - Focusing on women in their 30s - (딥티슈마사지와 일라이트병행 딥티슈마사지의 체형변화 비교 -30대 여성을 대상으로-)

  • Jeong, In-Sun;Park, Jeong-Yeon
    • Journal of Korea Entertainment Industry Association
    • /
    • v.14 no.6
    • /
    • pp.279-287
    • /
    • 2020
  • This study aims to put forth an efficient way of improving body shapes by examining the effects of deep tissue massage and illite-combined deep tissue massage on body shape changes, and identifying body shape changes when applying each method. This study targeted twenty women in their thirties, and ten separate subjects were placed in different groups. Then deep tissue massage and illite-combined deep tissue massage were performed once a week, for a total of eight weeks. Moire Topography was applied before the experiments, four weeks later and eight weeks later to compare changes in spinous process inclination, shoulders and hips. The data collected were analyzed using SPSS v. 21.0, and the study results are as follows. In relation to general characteristics of the subjects, professionals occupied the highest proportion of them, and 90% of them were married. Here, 77.8% of them had experience in giving birth, and 78.6% of them chose natural birth. In addition, 57.1% of the subjects holding a majority had two children. When measuring spinous process inclination, shoulders and hips in the illite-combined deep tissue massage group and in the deep tissue massage group before the experiments, the illite-combined deep tissue massage group showed somewhat higher values in every area than the deep tissue massage group, but no statistically significant differences were not found, which means the homogeneity existed between them. When comparing body shape changes between the two massage methods, there were significant differences(p<.05, p<.01), because the illite-combined deep tissue massage group showed a much higher decline in spinous process inclination, shoulders and hips than the deep tissue massage group. This implies illite-combined deep tissue massage was more effective in improving body shapes than deep tissue massage. Therefore, illite-combined deep tissue massage is considered to be helpful in improving body shapes, and it is anticipated that this massage method can be used in relevant fields, including the skin care industry.

In-service teacher's perception on the mathematical modeling tasks and competency for designing the mathematical modeling tasks: Focused on reality (현직 수학 교사들의 수학적 모델링 과제에 대한 인식과 과제 개발 역량: 현실성을 중심으로)

  • Hwang, Seonyoung;Han, Sunyoung
    • The Mathematical Education
    • /
    • v.62 no.3
    • /
    • pp.381-400
    • /
    • 2023
  • As the era of solving various and complex problems in the real world using artificial intelligence and big data appears, problem-solving competencies that can solve realistic problems through a mathematical approach are required. In fact, the 2015 revised mathematics curriculum and the 2022 revised mathematics curriculum emphasize mathematical modeling as an activity and competency to solve real-world problems. However, the real-world problems presented in domestic and international textbooks have a high proportion of artificial problems that rarely occur in real-world. Accordingly, domestic and international countries are paying attention to the reality of mathematical modeling tasks and suggesting the need for authentic tasks that reflect students' daily lives. However, not only did previous studies focus on theoretical proposals for reality, but studies analyzing teachers' perceptions of reality and their competency to reflect reality in the task are insufficient. Accordingly, this study aims to analyze in-service mathematics teachers' perception of reality among the characteristics of tasks for mathematical modeling and the in-service mathematics teachers' competency for designing the mathematical modeling tasks. First of all, five criteria for satisfying the reality were established by analyzing literatures. Afterward, teacher training was conducted under the theme of mathematical modeling. Pre- and post-surveys for 41 in-service mathematics teachers who participated in the teacher training was conducted to confirm changes in perception of reality. The pre- and post- surveys provided a task that did not reflect reality, and in-service mathematics teachers determined whether the task given in surveys reflected reality and selected one reason for the judgment among five criteria for reality. Afterwards, frequency analysis was conducted by coding the results of the survey answered by in-service mathematics teachers in the pre- and post- survey, and frequencies were compared to confirm in-service mathematics teachers' perception changes on reality. In addition, the mathematical modeling tasks designed by in-service teachers were evaluated with the criteria for reality to confirm the teachers' competency for designing mathematical modeling tasks reflecting the reality. As a result, it was shown that in-service mathematics teachers changed from insufficient perception that only considers fragmentary criterion for reality to perceptions that consider all the five criteria of reality. In particular, as a result of analyzing the basis for judgment among in-service mathematics teachers whose judgment on reality was reversed in the pre- and post-survey, changes in the perception of in-service mathematics teachers was confirmed, who did not consider certain criteria as a criterion for reality in the pre-survey, but considered them as a criterion for reality in the post-survey. In addition, as a result of evaluating the tasks designed by in-service mathematics teachers for mathematical modeling, in-service mathematics teachers showed the competency to reflect reality in their tasks. However, among the five criteria for reality, the criterion for "situations that can occur in students' daily lives," "need to solve the task," and "require conclusions in a real-world situation" were relatively less reflected. In addition, it was found that the proportion of teachers with low task development competencies was higher in the teacher group who could not make the right judgment than in the teacher group who could make the right judgment on the reality of the task. Based on the results of these studies, this study provides implications for teacher education to enable mathematics teachers to apply mathematical modeling lesson in their classes.

Incremental Ensemble Learning for The Combination of Multiple Models of Locally Weighted Regression Using Genetic Algorithm (유전 알고리즘을 이용한 국소가중회귀의 다중모델 결합을 위한 점진적 앙상블 학습)

  • Kim, Sang Hun;Chung, Byung Hee;Lee, Gun Ho
    • KIPS Transactions on Software and Data Engineering
    • /
    • v.7 no.9
    • /
    • pp.351-360
    • /
    • 2018
  • The LWR (Locally Weighted Regression) model, which is traditionally a lazy learning model, is designed to obtain the solution of the prediction according to the input variable, the query point, and it is a kind of the regression equation in the short interval obtained as a result of the learning that gives a higher weight value closer to the query point. We study on an incremental ensemble learning approach for LWR, a form of lazy learning and memory-based learning. The proposed incremental ensemble learning method of LWR is to sequentially generate and integrate LWR models over time using a genetic algorithm to obtain a solution of a specific query point. The weaknesses of existing LWR models are that multiple LWR models can be generated based on the indicator function and data sample selection, and the quality of the predictions can also vary depending on this model. However, no research has been conducted to solve the problem of selection or combination of multiple LWR models. In this study, after generating the initial LWR model according to the indicator function and the sample data set, we iterate evolution learning process to obtain the proper indicator function and assess the LWR models applied to the other sample data sets to overcome the data set bias. We adopt Eager learning method to generate and store LWR model gradually when data is generated for all sections. In order to obtain a prediction solution at a specific point in time, an LWR model is generated based on newly generated data within a predetermined interval and then combined with existing LWR models in a section using a genetic algorithm. The proposed method shows better results than the method of selecting multiple LWR models using the simple average method. The results of this study are compared with the predicted results using multiple regression analysis by applying the real data such as the amount of traffic per hour in a specific area and hourly sales of a resting place of the highway, etc.

Framework on Soil Quality Indicator Selection and Assessment for the Sustainable Soil Management (지속가능한 토양환경 관리를 위한 토양질 지표의 선정과 평가체계)

  • Ok, Yong-Sik;Yang, Jae-E.;Park, Yong-Ha;Jung, Yeong-Sang;Yoo, Kyung-Yoal;Park, Chol-Soo
    • Journal of Environmental Policy
    • /
    • v.4 no.1
    • /
    • pp.93-111
    • /
    • 2005
  • Defining soil quality in scopes and applications is one of the prerequisite for the sustainable management of soil environment to orient researches, strategies and policies. However, definition of soil quality is controversial depending upon a viewpoint of soil science or soil environment. Soil quality can be, irrespective of the disciplines, defined as the capacity of a soil to function within ecosystem boundaries to sustain biological productivity, maintain environmental quality and promote plant and animal health. Common to all of the soil quality concepts can be summarized as the capacity of soil to function effectively at present and in the future. The OECD includes soil quality as one of the agri-environment indicators. This article intends to i) summarize the current soil quality research, and ii) provide information on protocol of soil quality assessment. A framework for soil quality was divided into three steps: indicator selection as minimum data set (MDS), scoring of the selected indicators, and integration of scores into soil quality index. Korean government suggested possible physical and chemical indicators such as bulk density and organic matter for paddy and upland soils to OECD. The framework of soil quality assessment is not yet implemented in Korea. Countries such as USA, Canada and New Zealand have constructed the framework on soil quality assessment and developed a user-friendly version of soil quality assessment tools to evaluate the integrated effects of various soil management practices. The protocol provided in this review might help policymakers, scientists, and administrators improve awareness about soil quality and understand the way of soil environment management.

  • PDF

Life Cylcle Assessment (LCA) on Rice Production Systems: Comparison of Greenhouse Gases (GHGs) Emission on Conventional, Without Agricultural Chemical and Organic Farming (쌀 생산체계에 대한 영농방법별 전과정평가: 관행농, 무농약, 유기농법별 탄소배출량 비교)

  • Ryu, Jong-Hee;Kwon, Young-Rip;Kim, Gun-Yeob;Lee, Jong-Sik;Kim, Kye-Hoon;So, Kyu-Ho
    • Korean Journal of Soil Science and Fertilizer
    • /
    • v.45 no.6
    • /
    • pp.1157-1163
    • /
    • 2012
  • This study was performed a comparative life cycle assessment (LCA) among three rice production systems in order to analyze the difference of greenhouse gases (GHGs) emissions and environment impacts. Its life cycle inventory (LCI) database (DB) was established using data obtained from interview with conventional, without agricultural chemical and organic farming at Gunsan and Iksan, Jeonbuk province in 2011. According to the result of LCI analysis, $CO_2$ was mostly emitted from fertilizer production process and rice cropping phase. $CH_4$ and $N_2O$ were almost emitted from rice cultivation phase. The value of carbon footprint to produce 1 kg rice (unhulled) on conventional rice production system was 1.01E+00 kg $CO_2$-eq. $kg^{-1}$ and it was the highest value among three rice production systems. The value of carbon footprints on without agricultural chemical and organic rice production systems were 5.37E-01 $CO_2$-eq. $kg^{-1}$ and 6.58E-01 $CO_2$-eq. $kg^{-1}$, respectively. Without agricultural chemical rice production system whose input amount was the smallest had the lowest value of carbon footprint. Although the yield of rice from organic farming was the lowest, its value of carbon footprint less than that of conventional farming. Because there is no compound fertilizer inputs in organic farming. Compound fertilizer production and methane emission during rice cultivation were the main factor to GHGs emission in conventional and without agricultural chemical rice production systems. In organic rice production system, the main factors to GHGs emission were using fossil fuel on machine operation and methane emission from rice paddy field.

Video Scene Detection using Shot Clustering based on Visual Features (시각적 특징을 기반한 샷 클러스터링을 통한 비디오 씬 탐지 기법)

  • Shin, Dong-Wook;Kim, Tae-Hwan;Choi, Joong-Min
    • Journal of Intelligence and Information Systems
    • /
    • v.18 no.2
    • /
    • pp.47-60
    • /
    • 2012
  • Video data comes in the form of the unstructured and the complex structure. As the importance of efficient management and retrieval for video data increases, studies on the video parsing based on the visual features contained in the video contents are researched to reconstruct video data as the meaningful structure. The early studies on video parsing are focused on splitting video data into shots, but detecting the shot boundary defined with the physical boundary does not cosider the semantic association of video data. Recently, studies on structuralizing video shots having the semantic association to the video scene defined with the semantic boundary by utilizing clustering methods are actively progressed. Previous studies on detecting the video scene try to detect video scenes by utilizing clustering algorithms based on the similarity measure between video shots mainly depended on color features. However, the correct identification of a video shot or scene and the detection of the gradual transitions such as dissolve, fade and wipe are difficult because color features of video data contain a noise and are abruptly changed due to the intervention of an unexpected object. In this paper, to solve these problems, we propose the Scene Detector by using Color histogram, corner Edge and Object color histogram (SDCEO) that clusters similar shots organizing same event based on visual features including the color histogram, the corner edge and the object color histogram to detect video scenes. The SDCEO is worthy of notice in a sense that it uses the edge feature with the color feature, and as a result, it effectively detects the gradual transitions as well as the abrupt transitions. The SDCEO consists of the Shot Bound Identifier and the Video Scene Detector. The Shot Bound Identifier is comprised of the Color Histogram Analysis step and the Corner Edge Analysis step. In the Color Histogram Analysis step, SDCEO uses the color histogram feature to organizing shot boundaries. The color histogram, recording the percentage of each quantized color among all pixels in a frame, are chosen for their good performance, as also reported in other work of content-based image and video analysis. To organize shot boundaries, SDCEO joins associated sequential frames into shot boundaries by measuring the similarity of the color histogram between frames. In the Corner Edge Analysis step, SDCEO identifies the final shot boundaries by using the corner edge feature. SDCEO detect associated shot boundaries comparing the corner edge feature between the last frame of previous shot boundary and the first frame of next shot boundary. In the Key-frame Extraction step, SDCEO compares each frame with all frames and measures the similarity by using histogram euclidean distance, and then select the frame the most similar with all frames contained in same shot boundary as the key-frame. Video Scene Detector clusters associated shots organizing same event by utilizing the hierarchical agglomerative clustering method based on the visual features including the color histogram and the object color histogram. After detecting video scenes, SDCEO organizes final video scene by repetitive clustering until the simiarity distance between shot boundaries less than the threshold h. In this paper, we construct the prototype of SDCEO and experiments are carried out with the baseline data that are manually constructed, and the experimental results that the precision of shot boundary detection is 93.3% and the precision of video scene detection is 83.3% are satisfactory.

Development of Yóukè Mining System with Yóukè's Travel Demand and Insight Based on Web Search Traffic Information (웹검색 트래픽 정보를 활용한 유커 인바운드 여행 수요 예측 모형 및 유커마이닝 시스템 개발)

  • Choi, Youji;Park, Do-Hyung
    • Journal of Intelligence and Information Systems
    • /
    • v.23 no.3
    • /
    • pp.155-175
    • /
    • 2017
  • As social data become into the spotlight, mainstream web search engines provide data indicate how many people searched specific keyword: Web Search Traffic data. Web search traffic information is collection of each crowd that search for specific keyword. In a various area, web search traffic can be used as one of useful variables that represent the attention of common users on specific interests. A lot of studies uses web search traffic data to nowcast or forecast social phenomenon such as epidemic prediction, consumer pattern analysis, product life cycle, financial invest modeling and so on. Also web search traffic data have begun to be applied to predict tourist inbound. Proper demand prediction is needed because tourism is high value-added industry as increasing employment and foreign exchange. Among those tourists, especially Chinese tourists: Youke is continuously growing nowadays, Youke has been largest tourist inbound of Korea tourism for many years and tourism profits per one Youke as well. It is important that research into proper demand prediction approaches of Youke in both public and private sector. Accurate tourism demands prediction is important to efficient decision making in a limited resource. This study suggests improved model that reflects latest issue of society by presented the attention from group of individual. Trip abroad is generally high-involvement activity so that potential tourists likely deep into searching for information about their own trip. Web search traffic data presents tourists' attention in the process of preparation their journey instantaneous and dynamic way. So that this study attempted select key words that potential Chinese tourists likely searched out internet. Baidu-Chinese biggest web search engine that share over 80%- provides users with accessing to web search traffic data. Qualitative interview with potential tourists helps us to understand the information search behavior before a trip and identify the keywords for this study. Selected key words of web search traffic are categorized by how much directly related to "Korean Tourism" in a three levels. Classifying categories helps to find out which keyword can explain Youke inbound demands from close one to far one as distance of category. Web search traffic data of each key words gathered by web crawler developed to crawling web search data onto Baidu Index. Using automatically gathered variable data, linear model is designed by multiple regression analysis for suitable for operational application of decision and policy making because of easiness to explanation about variables' effective relationship. After regression linear models have composed, comparing with model composed traditional variables and model additional input web search traffic data variables to traditional model has conducted by significance and R squared. after comparing performance of models, final model is composed. Final regression model has improved explanation and advantage of real-time immediacy and convenience than traditional model. Furthermore, this study demonstrates system intuitively visualized to general use -Youke Mining solution has several functions of tourist decision making including embed final regression model. Youke Mining solution has algorithm based on data science and well-designed simple interface. In the end this research suggests three significant meanings on theoretical, practical and political aspects. Theoretically, Youke Mining system and the model in this research are the first step on the Youke inbound prediction using interactive and instant variable: web search traffic information represents tourists' attention while prepare their trip. Baidu web search traffic data has more than 80% of web search engine market. Practically, Baidu data could represent attention of the potential tourists who prepare their own tour as real-time. Finally, in political way, designed Chinese tourist demands prediction model based on web search traffic can be used to tourism decision making for efficient managing of resource and optimizing opportunity for successful policy.

Case Study of Menu Satisfaction Index in Business & Industry Food Service (산업체급식 메뉴 만족도 조사도구의 활용에 대한 사례연구)

  • Lee, Hae-Young;Ahn, Sun-Jung;Yang, Il-Sun
    • Journal of the Korean Society of Food Science and Nutrition
    • /
    • v.37 no.11
    • /
    • pp.1443-1451
    • /
    • 2008
  • This study was performed to develop menu satisfaction index in Business & Industry (B&I) food service and to survey customer's menu satisfaction using the index. The menu satisfaction index included 16 items with Likert 5 point. Cronbach's alpha to assess the internal reliability of the developed scales was 0.8917, which indicated highly reliable. Construct validity was assessed by principal components analysis and then four factors explaining 65.964% of the total variance were found. Among the 15 items of menu satisfaction, the average scores of all items were above 3.0 out of 5. As a result of analysis on menu satisfaction factors, 'propriety of food temperature' (3.52 out of 5) was the highest consideration followed by 'sufficiency of format' (3.46), 'excellence in food' (3.35) and 'well-being orientation' (3.31). It could be said that customer's perception on the menu quality was very positive. Four factors were correlated with overall menu satisfaction positively. Especially, 'excellence in food', and 'well-being orientation' and 'sufficiency of format' affected significantly on overall menu satisfaction. It concluded that customers were satisfied with portion size, temperature, price but their needs for taste and health/nutrition-related service would be increased. The menu satisfaction developed in this study should be applied to other B & I food service operation by type.

Automated-Database Tuning System With Knowledge-based Reasoning Engine (지식 기반 추론 엔진을 이용한 자동화된 데이터베이스 튜닝 시스템)

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

  • PDF