• 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 Korean Library and Information Science Society
• /
• v.39 no.4
• /
• pp.189-214
• /
• 2008

Objective of this research is to point out problems of geographic division structure in current Korean Decimal Classification System and provide solutions. For this purpose key classification methods were divided to decimal and non-decimal classification methods and analyzed for geographical division principles. In addition, national institutes regional division standards from Korea, USA and Japan were researched. Through these analysis, we provided suggestions to improve the table of geographical division in KDC4 including public institutions administrative district classification structure relations and consistency, and other regional divisional standards (proposal) instead of typical administrative district reflecting various geographical conditions.

• Journal of Korean Library and Information Science Society
• /
• v.21
• /
• pp.195-229
• /
• 1994

This article investigates the normative principles suggested by Rangannathan as the guiding principles for his theories, consisting of basic laws, fundamental laws, canons, principles and postulates. His five basic laws and five laws of library science are re-interpreted from the view point of library classification. And three planes of idea plane, verbal plane and notational plane, one of the core ideas in his analytico-synthetic theory of library classification, are analyzed. This article also suggests the demonstration model for this three planes using the ideas from chemistry ad chemical equation. In the last part, it analyzes the canons for library classification of three planes. These normative principles are basically guiding principles for so-called analytico-synthetic or faceted classification. But they can be a n.0, pplied to most of modern classification. But they can be a n.0, pplied to most of modern classification schemes, especially to semi-enumerative schemes including DDC, KDC, etc. so that they can improve the schemes. From this regard, these principles can also be helpful to the KDC, on the verge of the revision of its fourth edition.

• Journal of the Korean Society for Library and Information Science
• /
• v.46 no.3
• /
• pp.181-201
• /
• 2012

This study aims to analyze and compare the structures of auxiliary tables regarding places - for example, Korea using several decimal classification systems such as DDC, UDC, KDC and NDC. For each auxiliary table, the codes were described in detail and the special characteristics were discussed. The common characteristics and the different aspects of different decimal classification systems were investigated as well as divisions of Korea in Korean Wikipedia and an administrative district classification system. This study suggests a new basic summary for the expansion of codes of Korea in auxiliary table in DDC with its principles and options and it will be useful for revising process of many decimal classification systems.

• Journal of the Korean Society for information Management
• /
• v.18 no.3
• /
• pp.285-309
• /
• 2001

The industry information grows faster than any other information resources in the Internet age. Unfortunately, however, there is no consensus on the standard of the classification among the information providers of the industry fields. This may a problematic issue not only in building a continuous and systematic development of the industry information, but also in the use of the information among the users. This study aims to propose a well-structured and/or an efficient classification scheme for the industry information to help the users with easy to retrieve the Internet resources. To do this, we analyzed the subject classification scheme of the domestic industry information on the web sites, which is largely adopted the \"Korean Standard for the Industry Classification\". In addition, we suggested the principle of the subject classification and their hierarchial structure derived from the analysis of the knowledge and document classification scheme. As a result, it was suggested an optimized industry classification scheme based on the analysis of the validity test of classification item measured by the quantitative analysis of the industry information, which it currently accessible through the Internet. Internet.

• Journal of Korean Library and Information Science Society
• /
• v.45 no.1
• /
• pp.103-123
• /
• 2014

This study investigated general problems concerning the tourism field in the KDC 6th edition based comparative analysis academic characteristics and classification system, and suggested on some ideas for the improvements of them. Results of the study are summarized as follows. First, academic field of tourism is generally divided into a general tourism, tourists, tourism attraction, and tourism media, but classification system of tourism is limited to parts of tourism attraction and a general tourism. Tourism attraction and tourism media are dispersed among the subject. Second, I analyzed on tourism from the collection database at the National Library of Korea. Based on analysis of the data. the keyword frequency of tourism management, type, development, psychology, industry, and convention etc. was relatively high. Third, modified classification of items was basically performed through the academic characteristics of the tourism and the keyword analysis, and maintaining the existing KDC classification system caused less confusion as much as possible. Also, based on this matter was added to the relative indexes.

• Journal of Korean Library and Information Science Society
• /
• v.48 no.3
• /
• pp.63-81
• /
• 2017

This study investigated general problems concerning the social welfare field in the KDC 6th edition based comparative analysis academic characteristics and classification system, and suggested on some ideas for the improvements of them. Results of the study are summarized as follows. First, a main field of the social welfare is generally divided into a general social welfare, social works, and social welfare services to special classes and groups including people with disabilities, young people, aged, women, and families. Second, I analyzed on social welfare from the collection database at the National Library of Korea. Based on analysis of the data. the keyword frequency of social welfare policy and management, pensions, care services, and support works for the underprivileged was relatively high. Third, modified classification of items was basically performed through the academic characteristics of the social welfare and the keyword analysis, and maintaining the existing KDC classification system caused less confusion as much as possible.

• Journal of Korean Library and Information Science Society
• /
• v.43 no.3
• /
• pp.101-120
• /
• 2012

This study investigated general problems concerning the clothing and textiles field in the KDC 5th edition based comparative analysis academic characteristics and classification system, and suggested on some ideas for the improvements of them. Results of the study is summarized as follows. First, the classification system of the clothing and textiles field is generally divided by costume, dyeing engineering, leather & fur processing, textiles and textile industries, manufacturing clothes, management of clothing, and textile arts. Second, I proposed improvements based on analyzing problems of KDC 5th to the clothing and textiles field from the collection database at the National Library of Korea. Third, basically improvements of KDC system was based on the knowledge of the clothing and textiles field. I tried to maintain as the KDC existing classification system was to retain as much as possible, and to move between items was minimal.

• Journal of Korean Library and Information Science Society
• /
• v.35 no.4
• /
• pp.171-191
• /
• 2004

This study presents revision scheme of Korean Decimal Classification appropriate for classification of children-related materials, mainly centered on social science(300) and pure science(400) occupying the majority of children-related materials in school Libraries. Towards this goal, 1 have studied the development and use of classification system for children-related materials available in domestic and overseas school libraries or children's libraries, and researched elementary school 4th, 5th, and 6th grade students' degree of understanding on classification item terms and children-related materials terms used for KDC's social science and Pure science. Based on the results of analysis, f have presented revision scheme of Korean Decimal Classification item terms and class numbers for children-related materials.

• Communications of Mathematical Education
• /
• v.29 no.3
• /
• pp.313-330
• /
• 2015

The classification is an important activity that is directly related to concept formation. Thus it will need to be made meaningful learning to classification through learner-centered teaching. But we doubts weather teaching and learning to the classification are reflected in the constructivist philosophy of 'learner-centered' well or not. The purpose of this study was to analyze critically the content of elementary textbooks and guidebook for teachers relating to the classification of angles and triangles in terms of constructivism. As a result, there is a problem in the classification of angles that are not provided a reasonable chance to set criteria by agreement of the communities. There is a problem in the classification of triangles that has the characteristics of radical development in terms of diversity. In addition, response of students was predicted like anyone who already acquired knowledge. And it has the shortcomings that the opportunity to have a choice and a discussion to hierarchical and partition classification are not provided. The followings are proposed based on such features; faithful reflection of 'Learner-centered' principle, careful prediction of student response, teaching that focus on process than results.