• Title/Summary/Keyword: 존재의 언어

Search Result 711, Processing Time 0.03 seconds

Assumptions on the Location of Changokbyeong and Saahm Park Soon's Garden Remains (창옥병(蒼玉屛)의 위치 비정(比定) 및 사암(思菴) 박순(朴淳)의 정원유적 연구)

  • Rho, Jae-Hyun;Park, Joo-Sung;Choi, Jong-Hee
    • Journal of the Korean Institute of Traditional Landscape Architecture
    • /
    • v.34 no.4
    • /
    • pp.37-50
    • /
    • 2016
  • Recognizing the problem of fallacy in geographical name of Changokbyeong(蒼玉屛), assumption has been made on the location of Changokbyeong through literature research on antique maps, ancient paintings, and old prose, through field survey on rock inscriptions and landscape characteristics, and through interviews with local people. Furthermore, Baegyeonwa, the Cuckoo Hut, and Iyangjung(二養亭), an annex to the cottage, both of which were managed by Saahm Park Soon(思菴 朴淳), the Subject of Jouissance, were studied in depth with emphasis on the spatial structure as well as special features of the area as a garden. The major findings are as follows: Changokbyeong is a spatial threshold that imparts a sense of unity with Okbyeng seowon(玉屛書院) and indeed Changokbyeong is presumed to have been the frontal river terrace of Okbyeng seowon according to the analysis of antique maps and rock inscriptions. This ancient location and the Ogari Stone Wall, the present day Changokbyeong, are only 460m away so that both areas are considered as falling under the influence of Changokbyeong landscape. The expression "Changokbyeong Geupsangeum(蒼玉屛及散襟)" written in an old prose tells us that the high rock wall with Sangeumdae inscribed on the rock might be the rock wall of Changokbyeong. In addition, while not a single rock inscription has been found on the Ogari Stone Wall, 11 rock inscriptions designed and ordered by Saahm Park Soon, the Subject of Jouissance, are found on every corner of the high rock wall standing in front of Okbyeng seowon, 8 of those 11 being place names and recitative poems(known as Jeyeongsi: 題詠詩) in close formation resembling the handwritings in a little notebook. This provides a strong evidence for assuming the location of Changokbyeong to be the frontal river terrace of Okbyeng seowon. The "Songgyun Jeoljo Suwol Jeongshin(松筠節調 水月精神)" rock inscription on Changokbyeong should be considered as the stamping ground and as the symbolic language of Changokbyeong that bears the high character and nobility of the Subject of Jouissance, Saahm Park Soon. The inscription should also be recognized as the handwritings of Wooahm Song Si-Yeol(尤庵 宋時烈) correcting the misconceptions that persisted until today. Meanwhile, the garden remains of Saahm's Changokbyeong are composed of four sites: Sangeumdae-Sugyeongdae-Cheonghakdae-Baekhakdae from the left. At the back of Sangeumdae, there is the original house, the Baegyeonwa(拜鵑窩), and on the fantastically shaped stone wall at the left of Baekhakdae, there is the annex, the Iyangjung, together creating a landscape composition that overlooks the splendor of the Ogari Stone Wall. The Iyangjung is located on the highest spot to the left of the four sites, and it is believed to have been a little outhouse and library for Saahm which remains to the present day as a place where Saahm's character can be felt. The drinking plates[窪樽] made of rock that are affectionately arranged on the broad flat rock in front of Iyangjung is part of the garden remains that reflects the artistic taste of Saahm regarding the drinking culture at the time.

The Structure of the Theory of Three Natures from the Hermeneutic Perspective of "the Three Turns of the Dharma Cakra" ('3전법륜설'의 해석학적 지평으로 본 삼성설의 구조)

  • Kim, Jae-gweon
    • Journal of Korean Philosophical Society
    • /
    • v.117
    • /
    • pp.35-55
    • /
    • 2011
  • This article purports to clarify the doctrinal characteristics of the $Yog{\bar{a}}c{\bar{a}}ra$ school's hermeneutic interpretations of the "theory of the three turns of the Dharma Cakra" in the Saṃdbinirmocana-sūtra through early Indian $Yog{\bar{a}}c{\bar{a}}ra$ treatises such as the $Yog{\bar{a}}c{\bar{a}}rabb{\bar{u}}mi-vy{\bar{a}}kby{\bar{a}}$ and the. $Vy{\bar{a}}khy{\bar{a}}yukti$. It will probe how these interpretations apply co the theory of two truths or that of three natures($trisvabh{\bar{a}}va$) among the main doctrines of the $Yog{\bar{a}}c{\bar{a}}ra$ school. Especially, the peculiar characteristic of the "theory of the three turns of the Dharma Cakra" is such chat the thought of ${\acute{s}}{\bar{u}}nyat{\bar{a}}$ in the lineage of $Praj{\bar{n}}{\bar{a}}p{\bar{a}}ramita-s{\bar{u}}tras$ is regarded as incomplete, as the early school of Madhyamaka represented by $N{\bar{a}}g{\bar{a}}rjuna$ is conceived of as belonging to the second period of turn. Speaking of the further details of the "theory of the three turns of the Dharma Cakra", the $Yog{\bar{a}}c{\bar{a}}ra$ school subdivides the realm of saṃvṛti satya in $N{\bar{a}}g{\bar{a}}rjuna^{\prime}s$ theory of two truths; that is, it divides the saṃvṛti into merely linguistic existence and actual existence, and the thus-created structure of the theory of three natures on the basis of ocher-dependent nature(paratantra-$svabh{\bar{a}}va$) makes it possible to establish the doctrinal system of the thought of ${\acute{s}}{\bar{u}}nyat{\bar{a}}$ that is not subject to "nihilism or ${\acute{s}}{\bar{u}}nyat{\bar{a}}$ attached to evil." In effect, the above hermeneutic interpretation of the "theory of the three turns of the Dharma Cakra" is inherited into the structure of the $abh{\bar{u}}taparikalpa$ in the $Madhy{\bar{a}}nta-vibh{\bar{a}}ga$ so that, as seen in the commentary of Sthiramati, it is ascertained to apply to later doctrines through its secure establishment. To summarize its characteristics succinctly, firstly the $abh{\bar{u}}taparikalpa$ newly established as a saṃvṛti-satya is set up as the other-dependent nature, which is seen to have been set up particularly in order to sublate both the $Sarv{\bar{a}}stiv{\bar{a}}da^{\prime}s$ realist "view of being" and the Madhyamaka's "view of ${\acute{s}}{\bar{u}}nyat{\bar{a}}$" that impairs the ocher-dependent nature as a samvṛti-satya. In other words, according to the five kinds of views suggested in Sthiramati's commentary, the three natures are seen to be presented as the fundamental truth in order to unify all the doctrinal systems available ever since the beginning of Buddhism. Then, the theory of three natures is established principally on the basis of the $abh{\bar{u}}taparikalpa$, while the two truths of the $Yog{\bar{a}}c{\bar{a}}ra$ school are clearly ascertained to have been embedded in the structure of the $abh{\bar{u}}taparikalpa$. In fact, this might be understood to reflect the unique ontological view of reality or truth in the $Yog{\bar{a}}c{\bar{a}}ra$ School.

A Study on "Reason and Madness" in Hegel's 『Phenomenology of Spirit』 - An Interpretation searching for the possibility of the dialogue between Hegel and Lacan - (헤겔 『정신현상학』에서의 '이성과 광기'의 문제 - 헤겔의 라캉과의 대화 가능성에서 본 하나의 해석 -)

  • Lee, Jong-chul
    • Journal of Korean Philosophical Society
    • /
    • v.115
    • /
    • pp.249-279
    • /
    • 2010
  • The Law of the Heart, which appears in the chapter "B. The Actualization of Rational Self-consciousness Through its own Activity" in Hegel's Phenomenology of Spirit represents that the self-certainty of the reason may be the another face of the Madness. The Reason's indubitable certainty is the testimony of the truth for Descartes, and it also plays a role as the moral maxim of the conscience for Kant. But this subjective certainty unavoidably leads to the Madness of self-conceit, which unifies the consciousness and the reality ignoring the difference between them. The typical attitude appearing in the reformer like Don Quixote and also romantic idealists reveals the fact that modern reason and the psychosis can be both faces of one and the same coin. The Mirror Stage, the Imaginary, and the Formula of the Desire in Lacan's Theory shows that the Image of completeness is the result of Mis-understanding. Even if the Mirror stage is necessary for the Formation of the subject, at the same time it should also lead to the next stage, i.e., the Symbolic Order. It is considered as the realm of the Otherness, which refers to the realm of language or that of law. If the Ego can't go through the symbolic castration acted on by the Name of the Father, he will be remained in the prison of the Imaginary. The Madness also shows the similar process. For Hegel the Discipline of the Labor or the Death as absolute Otherness that inevitably delays the Desire plays the same role as the name of Father. It may be the experience of Separation or that of Sublation of the individual towards the universal, which is equivalent to the experience of Symbolic castration in Lacan. Furthermore there may be the difference between Hegel and Lacan as the following; while in Hegel the experience of Separation is founded on the spontaneity of the Spirit, for Lacan it is to be compelled and structured by the absolute Other.

Aspect-Based Sentiment Analysis Using BERT: Developing Aspect Category Sentiment Classification Models (BERT를 활용한 속성기반 감성분석: 속성카테고리 감성분류 모델 개발)

  • Park, Hyun-jung;Shin, Kyung-shik
    • Journal of Intelligence and Information Systems
    • /
    • v.26 no.4
    • /
    • pp.1-25
    • /
    • 2020
  • Sentiment Analysis (SA) is a Natural Language Processing (NLP) task that analyzes the sentiments consumers or the public feel about an arbitrary object from written texts. Furthermore, Aspect-Based Sentiment Analysis (ABSA) is a fine-grained analysis of the sentiments towards each aspect of an object. Since having a more practical value in terms of business, ABSA is drawing attention from both academic and industrial organizations. When there is a review that says "The restaurant is expensive but the food is really fantastic", for example, the general SA evaluates the overall sentiment towards the 'restaurant' as 'positive', while ABSA identifies the restaurant's aspect 'price' as 'negative' and 'food' aspect as 'positive'. Thus, ABSA enables a more specific and effective marketing strategy. In order to perform ABSA, it is necessary to identify what are the aspect terms or aspect categories included in the text, and judge the sentiments towards them. Accordingly, there exist four main areas in ABSA; aspect term extraction, aspect category detection, Aspect Term Sentiment Classification (ATSC), and Aspect Category Sentiment Classification (ACSC). It is usually conducted by extracting aspect terms and then performing ATSC to analyze sentiments for the given aspect terms, or by extracting aspect categories and then performing ACSC to analyze sentiments for the given aspect category. Here, an aspect category is expressed in one or more aspect terms, or indirectly inferred by other words. In the preceding example sentence, 'price' and 'food' are both aspect categories, and the aspect category 'food' is expressed by the aspect term 'food' included in the review. If the review sentence includes 'pasta', 'steak', or 'grilled chicken special', these can all be aspect terms for the aspect category 'food'. As such, an aspect category referred to by one or more specific aspect terms is called an explicit aspect. On the other hand, the aspect category like 'price', which does not have any specific aspect terms but can be indirectly guessed with an emotional word 'expensive,' is called an implicit aspect. So far, the 'aspect category' has been used to avoid confusion about 'aspect term'. From now on, we will consider 'aspect category' and 'aspect' as the same concept and use the word 'aspect' more for convenience. And one thing to note is that ATSC analyzes the sentiment towards given aspect terms, so it deals only with explicit aspects, and ACSC treats not only explicit aspects but also implicit aspects. This study seeks to find answers to the following issues ignored in the previous studies when applying the BERT pre-trained language model to ACSC and derives superior ACSC models. First, is it more effective to reflect the output vector of tokens for aspect categories than to use only the final output vector of [CLS] token as a classification vector? Second, is there any performance difference between QA (Question Answering) and NLI (Natural Language Inference) types in the sentence-pair configuration of input data? Third, is there any performance difference according to the order of sentence including aspect category in the QA or NLI type sentence-pair configuration of input data? To achieve these research objectives, we implemented 12 ACSC models and conducted experiments on 4 English benchmark datasets. As a result, ACSC models that provide performance beyond the existing studies without expanding the training dataset were derived. In addition, it was found that it is more effective to reflect the output vector of the aspect category token than to use only the output vector for the [CLS] token as a classification vector. It was also found that QA type input generally provides better performance than NLI, and the order of the sentence with the aspect category in QA type is irrelevant with performance. There may be some differences depending on the characteristics of the dataset, but when using NLI type sentence-pair input, placing the sentence containing the aspect category second seems to provide better performance. The new methodology for designing the ACSC model used in this study could be similarly applied to other studies such as ATSC.

The Cognitive Performance, Emotional and Behavioral Problems of the Children with ADHD Showing the Difference between Visual and Auditory Attention (시각 주의력과 청각 주의력의 차이를 보이는 주의력 결핍.과잉활동장애 아동의 인지기능과 정서 및 행동 문제)

  • Son, Jung Woo
    • Korean Journal of Biological Psychiatry
    • /
    • v.13 no.2
    • /
    • pp.70-81
    • /
    • 2006
  • Objective : The purpose of this study was to investigate the differences of the cognitive performance, emotional and behavioral problems among the attention-deficit/hyperactivity disorder(ADHD) groups that show the difference between visual and auditory attention. Method : Using 'ADHD Diagnostic System(ADS)', visual attention and auditory attention of 98 children diagnosed as ADHD were measured. According to the omission and commission error of ADS, they were divided into three groups ; 1) the group whose each visual omission and commission error scores were higher than each auditory omission and commission error scores(VV group), 2) the group whose each auditory omission and commission error scores were higher than each visual omission and commission error scores(AA group), 3) the group that was the rest of VV and AA group(M group). And the results of both the subscales of Korean Educational Development Institute-Wechsler Intelligence Scale for Children(KEDI-WISC) and the subscales of Korean Child Behavior Checklist(K-CBCL) among three groups were compared. Finally, the correlation between the visual omission, visual commission, auditory omission, auditory commission error and the results of KEDI-WISC, K-CBCL were investigated. Results : The results were as follows ; 1) In 98 ADHD children, the number of VV group(N=56) was higher than that of AA (N=10) and M group (N=32). 2) All mean scores of the subscales of KEDI-WISC of VV group were higher than those of M and AA group. The score of verbal IQ(p=.039) of VV group was significantly higher than that of AA group and the scores of block design(p=.015), Kaufman's factor 2(p=.045), performance IQ(p=.004) were significantly higher than those of M group. The score of full IQ(p=.004) were significantly higher than that of M and AA group. 3) The mean scores of all K-CBCL subscales of VV group were higher than those of M and AA group, except the score of Somatic complaint subscale. The score of Social subscale(p=.041) of VV group was significantly higher than that of AA group. The score of Withdrawn subscale(p=.021) of AA group was significantly higher than that of VV group. 4) There were no significant correlation between the scores of visual omission/commission error and those of each subscale of KEDI-WISC. But, there were many significant correlations between the scores of auditory omission/commission error and those of each subscale of KEDI-WISC. 5) There were significant correlation between the score of the visual omission error and that of Thought problem subscale(r=.205, p=.043) of K-CBCL. There were significant correlation between the scores of the auditory omission error and those of Social subscale(r=-.319, p=.001), Social problems subscale(r=.206, p=.042), Thought problem subscale(r=.235, p=.021). Finally, there were significant correlation between the scores of auditory commission error and those of Social subscale(r=-.241, p=.017), Thought problem subscale(r=.235, p=.020). Conclusion : The ADHD children whose auditory attention ability were higher than visual attention ability had relatively better cognitive performance and less emotional/behavioral problems than the others. The more comprehensive experiment will be needed about the cognitive performance, emotion and behavior problems of the ADHD children showing the difference between visual and auditory attention.

  • PDF

A Study on the Product Design Case Study of Differential Design Concept (차별화 된 디자인 개념의 제품디자인 사례 연구)

  • 이덕상;한세준;김홍규;조철희
    • Archives of design research
    • /
    • v.17 no.2
    • /
    • pp.335-350
    • /
    • 2004
  • Design takes concrete form from the things which are not yet exist to the molded reality. Creation of value which is accompanied by the rational value could be possible only through the searching examination of the basic concept. All designs are under circumstances because the results and the character of the problems are different under the given conditions and circumstances which are the characteristic of the design. The aim of this study is searching for the differential design conce- pt which is the most appropriate and reasonable in the basic design process in which the phase of the analysis, synthesis and evaluation of the problem. First of all the pursuit value of the times and the change of the view point of value of the product design. How the pursuit value of times were searched and analyzed. Analyze the successful product design realization of the typical trend of the modern design which are 3-2. function-focused design, 3-3. emotion-centered design, 3-4. image communicative design through the metaphor, 3-5. environmental affinity design. On the base of the case analysis how to apply the differential design concept which is coming as a trend in the future society which are sustainable developing society was examined closely. The outcome through the analysis of the success cases are as follows, \circled1 the value of the spirit of the times should be emphasized as the design image, \circled2 environmental appropriateness should be taken into consideration as the first primary factor, \circled3 the realization of value of the fulfillment of differential consumer's needs, \circled4 lead to prolong the life cycle of the product, \circled5 promote the sustaining growth of enterprise, \circled6 user-centered product value should be the first consideration. \circled7 It is necessary to overcome the cultural andinguistic barriers and to reflect the metaphor which people remember well. \circled8 The application of human's true character should be decided beforehand. It is the commonness of values of times and customs. \circled9 The differentiated design concept which meets our mental satisfaction, not material one, will be required. In addition to this the creative and differentiated design concepts which are accompanied by the good design factor under the base of product could achieve the emotional consensus from the consumers. That is, the value of all designs should be estimated by the base of the humanism ' The human beings are the barometer of all things".ngs".uot;.

  • PDF

A Comparative Study on the Acceptability and the Consumption Attitude for Soy Foods between Korean and Canadian University Students (한국과 캐나다 대학생들의 콩가공식품에 대한 수응도 및 소비실태 비교 연구)

  • Ahn Tae-Hyun;Paliyath Gopinadhan
    • KOREAN JOURNAL OF CROP SCIENCE
    • /
    • v.51 no.5
    • /
    • pp.466-476
    • /
    • 2006
  • The objective of this study was to compare and analyze the acceptability and consumption attitude for soy foods between Korean and Canadian university students as young consumers. This survey was carried out by questionnaire and the subjects were n=516 in Korea and n=502 in Canada. Opinions for soy foods in terms of general knowledge were that soy foods are healthy (86.5% in Korean and 53.4% in Canadian) or neutral (11.6% in Korean and 42.8% in Canadian), dairy foods can be substituted by soy foods (51.9% in Korean and 41.8% in Canadian), and soy foods are not only for vegetarians and milk allergy Patients but also for ordinary People (94.2% in Korean and 87.6% in Canadian). In main sources of information about soy foods, the rate by commercials on TV, radio or magazine was the highest (58.0%) for Korean students and the rate by family or friend was the highest(35.7%) for Canadian students. In consumption attitude, all of Korean students have purchased soy foods but only 55.4% of Canadian students have purchased soy foods, and soymilk was remarkably recognized and consumed then soy beverage and margarine in order. 76.4% of Korean students and 65.1% of Canadian students think soy foods are general and popular and can purchase easily, otherwise, in terms of price, soy foods were expensively recognized as 'more expensive than dairy foods' was 59.1% (Korean) and 54.7% (Canadian), and 'similar to dairy foods' was 36.8% (Korean) and 39.9% (Canadian). Major reasons for the rare consumption were 'I am not interested in soy foods' in Korean students (27.3%) and 'I prefer dairy foods to soy foods' in Canadian students (51.7%). However, consumption of soy foods in both countries are very positive and it will be increased.

Movie 's Emotional Ambivalence (영화 <부러진 화살>의 정서적 이중성)

  • Kim, Guyl-Hun
    • The Journal of the Korea Contents Association
    • /
    • v.13 no.3
    • /
    • pp.65-75
    • /
    • 2013
  • Movie captured audience's whole sense organs to the screen which is made up of visual story-telling decorated by color, sound, and smell. The audience rediscovered native emotions(pleasure, fear, terror) suppressed and left in the compressed world of space and time, that is to say a movie world separated from the real world, by being immersed in the movie story. This study revealed audience's feelings of pleasure and fear by analyzing the movie . First of all, the pleasure would be discussed in terms of Nietzsche's "the will to power." Nietzsche defined something to breathe, move, and will as being alive, and he insisted that its power to life is 'the will to power.' Human beings wish to have power and want to increase it: pleasure, the real motivation of human behaviors and phenomena. The movie well revealed the pleasure by showing nonperson's challenge and victory against social rulers. Second, the fear and terror of the audience will be discussed in terms of in Lacan's psychoanalysis. Lacan extended Freud's id, ego, and superego into the worlds of reality, imagine, and symbol, and suggested a father in symbol world among those worlds. He suggested as a basic and connecting instrument of the socialization just like Signifi$\acute{e}$ and Signifiant, Saussure' basic linguistic structure in "Cours de lingustique g$\acute{e}$n$\acute{e}$rale"(1916). Because father is the symbol and the metaphor of law, the absence of him and resistance against him means obstacles of social stabilization. Finally this paper will also discuss that the fear from the absence of law and the pleasure provoked by self-preserving instincts, that is to say natural feelings, are connected to values of progressivism and conservatism.

A Study on Speech Recognition Using the HM-Net Topology Design Algorithm Based on Decision Tree State-clustering (결정트리 상태 클러스터링에 의한 HM-Net 구조결정 알고리즘을 이용한 음성인식에 관한 연구)

  • 정현열;정호열;오세진;황철준;김범국
    • The Journal of the Acoustical Society of Korea
    • /
    • v.21 no.2
    • /
    • pp.199-210
    • /
    • 2002
  • In this paper, we carried out the study on speech recognition using the KM-Net topology design algorithm based on decision tree state-clustering to improve the performance of acoustic models in speech recognition. The Korean has many allophonic and grammatical rules compared to other languages, so we investigate the allophonic variations, which defined the Korean phonetics, and construct the phoneme question set for phonetic decision tree. The basic idea of the HM-Net topology design algorithm is that it has the basic structure of SSS (Successive State Splitting) algorithm and split again the states of the context-dependent acoustic models pre-constructed. That is, it have generated. the phonetic decision tree using the phoneme question sets each the state of models, and have iteratively trained the state sequence of the context-dependent acoustic models using the PDT-SSS (Phonetic Decision Tree-based SSS) algorithm. To verify the effectiveness of the above algorithm we carried out the speech recognition experiments for 452 words of center for Korean language Engineering (KLE452) and 200 sentences of air flight reservation task (YNU200). Experimental results show that the recognition accuracy has progressively improved according to the number of states variations after perform the splitting of states in the phoneme, word and continuous speech recognition experiments respectively. Through the experiments, we have got the average 71.5%, 99.2% of the phoneme, word recognition accuracy when the state number is 2,000, respectively and the average 91.6% of the continuous speech recognition accuracy when the state number is 800. Also we haute carried out the word recognition experiments using the HTK (HMM Too1kit) which is performed the state tying, compared to share the parameters of the HM-Net topology design algorithm. In word recognition experiments, the HM-Net topology design algorithm has an average of 4.0% higher recognition accuracy than the context-dependent acoustic models generated by the HTK implying the effectiveness of it.

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