• Title/Summary/Keyword: 서비스 이동

Search Result 5,722, Processing Time 0.035 seconds

Customer perception and expert assessment in restaurant food environment by region - Focused on restaurants in Suwon, Hwaseong city - (도시와 농촌의 한식 음식점 식생활 환경에 대한 고객 인식 및 전문가 평가 비교 - 수원, 화성지역 음식점을 중심으로 -)

  • Oh, Mi Hyun;Choe, Jeong-Sook;Kim, Young;Lee, Sang Eun;Paik, Hee Young;Jang, Mi Jin
    • Journal of Nutrition and Health
    • /
    • v.47 no.6
    • /
    • pp.463-474
    • /
    • 2014
  • Purpose: The aim of this study was to assess the food environment, particularly focusing on restaurants in three areas (Suwon city, Hwaseong Byeongieom-dong, and Bibong-myun). Methods: A total of 662 persons were surveyed on customers' perceptions of the food environment in restaurants. A structured questionnaire composed of 30 questions on 7 factors, sanitation (4 items), displaying information (5), food quality (12), information on nutritional and healthy food choice (6), restaurant's accessibility (1), availability (1), and affordability (1) was used. In addition, an expert assessment of restaurant sanitation, and information on nutritional healthy food choice was conducted through visiting 126 restaurants. Results: Scores (range of score : 1~7) for each factors assessing the restaurant food environment were 5.06 for sanitation factors, 5.05 for displaying information factors, 5.13 for taste appearance factors, and 4.35 for healthy menu factors. Informations on nutritional healthy food choice showed a low rate: only 16.24% of the subjects answered that there is a message encouraging choice of healthy foods and 27.4% answered that menus contain nutritional information. Significant differences in food environment were observed by region (city, town, rural). The restaurants food environment in the rural area turned out to be poorer than that of the other two areas. In comparison of customer perception and expert assessment, significant differences were observed for 'Employee appearances and uniforms are clean and tidy' (p < .05), and 'There is a message encouraging the choice of healthy foods' (p < .05). Conclusion: This study provided evidence for differences of restaurant food environment by regions. In the rural area, there is a problem in restaurant's accessibility, availability, and affordability because of a lack of variety in menu items and restaurants. This results suggest that there is a need for more healthy food restaurants in the rural area.

Effects of climate change on biodiversity and measures for them (생물다양성에 대한 기후변화의 영향과 그 대책)

  • An, Ji Hong;Lim, Chi Hong;Jung, Song Hie;Kim, A Reum;Lee, Chang Seok
    • Journal of Wetlands Research
    • /
    • v.18 no.4
    • /
    • pp.474-480
    • /
    • 2016
  • In this study, formation background of biodiversity and its changes in the process of geologic history, and effects of climate change on biodiversity and human were discussed and the alternatives to reduce the effects of climate change were suggested. Biodiversity is 'the variety of life' and refers collectively to variation at all levels of biological organization. That is, biodiversity encompasses the genes, species and ecosystems and their interactions. It provides the basis for ecosystems and the services on which all people fundamentally depend. Nevertheless, today, biodiversity is increasingly threatened, usually as the result of human activity. Diverse organisms on earth, which are estimated as 10 to 30 million species, are the result of adaptation and evolution to various environments through long history of four billion years since the birth of life. Countlessly many organisms composing biodiversity have specific characteristics, respectively and are interrelated with each other through diverse relationship. Environment of the earth, on which we live, has also created for long years through extensive relationship and interaction of those organisms. We mankind also live through interrelationship with the other organisms as an organism. The man cannot lives without the other organisms around him. Even though so, human beings accelerate mean extinction rate about 1,000 times compared with that of the past for recent several years. We have to conserve biodiversity for plentiful life of our future generation and are responsible for sustainable use of biodiversity. Korea has achieved faster economic growth than any other countries in the world. On the other hand, Korea had hold originally rich biodiversity as it is not only a peninsula country stretched lengthily from north to south but also three sides are surrounded by sea. But they disappeared increasingly in the process of fast economic growth. Korean people have created specific Korean culture by coexistence with nature through a long history of agriculture, forestry, and fishery. But in recent years, the relationship between Korean and nature became far in the processes of introduction of western culture and development of science and technology and specific natural feature born from harmonious combination between nature and culture disappears more and more. Population of Korea is expected to be reduced as contrasted with world population growing continuously. At this time, we need to restore biodiversity damaged in the processes of rapid population growth and economic development in concert with recovery of natural ecosystem due to population decrease. There were grand extinction events of five times since the birth of life on the earth. Modern extinction is very rapid and human activity is major causal factor. In these respects, it is distinguished from the past one. Climate change is real. Biodiversity is very vulnerable to climate change. If organisms did not find a survival method such as 'adaptation through evolution', 'movement to the other place where they can exist', and so on in the changed environment, they would extinct. In this respect, if climate change is continued, biodiversity should be damaged greatly. Furthermore, climate change would also influence on human life and socio-economic environment through change of biodiversity. Therefore, we need to grasp the effects that climate change influences on biodiversity more actively and further to prepare the alternatives to reduce the damage. Change of phenology, change of distribution range including vegetation shift, disharmony of interaction among organisms, reduction of reproduction and growth rates due to odd food chain, degradation of coral reef, and so on are emerged as the effects of climate change on biodiversity. Expansion of infectious disease, reduction of food production, change of cultivation range of crops, change of fishing ground and time, and so on appear as the effects on human. To solve climate change problem, first of all, we need to mitigate climate change by reducing discharge of warming gases. But even though we now stop discharge of warming gases, climate change is expected to be continued for the time being. In this respect, preparing adaptive strategy of climate change can be more realistic. Continuous monitoring to observe the effects of climate change on biodiversity and establishment of monitoring system have to be preceded over all others. Insurance of diverse ecological spaces where biodiversity can establish, assisted migration, and establishment of horizontal network from south to north and vertical one from lowland to upland ecological networks could be recommended as the alternatives to aid adaptation of biodiversity to the changing climate.

A Regression-Model-based Method for Combining Interestingness Measures of Association Rule Mining (연관상품 추천을 위한 회귀분석모형 기반 연관 규칙 척도 결합기법)

  • Lee, Dongwon
    • Journal of Intelligence and Information Systems
    • /
    • v.23 no.1
    • /
    • pp.127-141
    • /
    • 2017
  • Advances in Internet technologies and the proliferation of mobile devices enabled consumers to approach a wide range of goods and services, while causing an adverse effect that they have hard time reaching their congenial items even if they devote much time to searching for them. Accordingly, businesses are using the recommender systems to provide tools for consumers to find the desired items more easily. Association Rule Mining (ARM) technology is advantageous to recommender systems in that ARM provides intuitive form of a rule with interestingness measures (support, confidence, and lift) describing the relationship between items. Given an item, its relevant items can be distinguished with the help of the measures that show the strength of relationship between items. Based on the strength, the most pertinent items can be chosen among other items and exposed to a given item's web page. However, the diversity of the measures may confuse which items are more recommendable. Given two rules, for example, one rule's support and confidence may not be concurrently superior to the other rule's. Such discrepancy of the measures in distinguishing one rule's superiority from other rules may cause difficulty in selecting proper items for recommendation. In addition, in an online environment where a web page or mobile screen can provide a limited number of recommendations that attract consumer interest, the prudent selection of items to be included in the list of recommendations is very important. The exposure of items of little interest may lead consumers to ignore the recommendations. Then, such consumers will possibly not pay attention to other forms of marketing activities. Therefore, the measures should be aligned with the probability of consumer's acceptance of recommendations. For this reason, this study proposes a model-based approach to combine those measures into one unified measure that can consistently determine the ranking of recommended items. A regression model was designed to describe how well the measures (independent variables; i.e., support, confidence, and lift) explain consumer's acceptance of recommendations (dependent variables, hit rate of recommended items). The model is intuitive to understand and easy to use in that the equation consists of the commonly used measures for ARM and can be used in the estimation of hit rates. The experiment using transaction data from one of the Korea's largest online shopping malls was conducted to show that the proposed model can improve the hit rates of recommendations. From the top of the list to 13th place, recommended items in the higher rakings from the proposed model show the higher hit rates than those from the competitive model's. The result shows that the proposed model's performance is superior to the competitive model's in online recommendation environment. In a web page, consumers are provided around ten recommendations with which the proposed model outperforms. Moreover, a mobile device cannot expose many items simultaneously due to its limited screen size. Therefore, the result shows that the newly devised recommendation technique is suitable for the mobile recommender systems. While this study has been conducted to cover the cross-selling in online shopping malls that handle merchandise, the proposed method can be expected to be applied in various situations under which association rules apply. For example, this model can be applied to medical diagnostic systems that predict candidate diseases from a patient's symptoms. To increase the efficiency of the model, additional variables will need to be considered for the elaboration of the model in future studies. For example, price can be a good candidate for an explanatory variable because it has a major impact on consumer purchase decisions. If the prices of recommended items are much higher than the items in which a consumer is interested, the consumer may hesitate to accept the recommendations.

A Study on Switching Intention of Mobile Telecommunication Service User: Focused on Group Differences Based on Innovativeness (이동통신 서비스 이용자의 전환의도에 관한 연구: 개인 혁신성에 따른 집단 간의 차이를 중심으로)

  • Oh, Jong-Chul;Yoon, Sung-Joon
    • Journal of Global Scholars of Marketing Science
    • /
    • v.19 no.1
    • /
    • pp.9-21
    • /
    • 2009
  • Recently, the researches to explain Switching Behavior through Theory of Planned Behavior have been discovered. Many researches say that System factors of mobile telecommunication service(MTS) is positively associated with Switching Intention. But There is no difference of system factors between mobile telecommunication services because of IT technique Development. Thus, this study investigated whether switching cost and alternative's attractiveness influence switching intention concerning mobile telecommunication service by adopting Theory of Planned Behavior (TPB) as an underlying theoretical premise. The study also attempted to determine the moderating effects of personal innovativeness on switching intention. For these purposes the author has developed several hypotheses as follows: H-1. The switching cost of different MTS is associated with the attitude of MTS which is using. H-2. The switching cost of different MTS is associated with the subjective norm of MTS which is using. H-3. The switching cost of different MTS is associated with the perceived behavior control of MTS which is using. H-4. The alternative's attractiveness of different MTS is associated with the attitude of MTS which is using. H-5. The alternative's attractiveness of different MTS is associated with the subjective norm of MTS which is using. H-6. The alternative's attractiveness of different MTS is associated with the perceived behavior control of MTS which is using. H-7. The switching cost of different MTS is associated with the switching intention. H-8. The alternative's attractiveness of different MTS is associated with the switching intention. H-9. The attitude of MTS is associated with the switching intention. H-10. The subjective norm of MTS is associated with the switching intention. H-11. The perceived behavior control of MTS is associated with the switching intention. H-12. The personal innovativeness has been a moderating effects to switching intention. Data has been collected from 403 respondents for this study using a questionnaire method. The survey for the actual analysis of the research was done and analyzed with the customers who have an experience of using Mobile telecommunication service and the samples were selected among the middle and high school students who live in Seoul area, the university students who live in Seoul, Gyeonggi and Chungcheng Provinces, and the ordinary workers who are working in Seoul and Gyeonggi Province. The survey was done for 23 days from March 28, 2008 through April 12, 2008. The positive analysis was done with SPSS 12.0K statistics package and visual PLS program using the analysis techniques of frequency analysis, reliability analysis, correlation analysis and factor analysis. In addition, structural equation modeling was conducted using AMOS 5.0. The data was analyzed by frequency analysis using SPSS 12.0 and structural equation modeling using AMOS 5.0. The result of the overall model analysis is as follows: Chi-Square=378.306, d.f.=107, p-value=0.0, GFI=.904, AGFI= 0.863, IFI= 0.939, NFI= 0.917, RMSEA= 0.079, TLI= 0.922. The results of the overall model analysis were coherent. The following study results were revealed: First, switching cost was related positively to attitude, subjective norm and perceived behavior control, three components of TPB. Second, alternative's attractiveness was related negatively to subjective norm but positively to perceived behavior control. Third, switching cost and attitude was related negatively to switching intention, while perceived behavior control was related positively to switching intention. Finally, the study found the moderating effects of personal innovativeness on switching intention. Based on the results, the study offers marketing strategic implications for mobile telecommunication service industry.

  • PDF

Development of a Real-Time Mobile GIS using the HBR-Tree (HBR-Tree를 이용한 실시간 모바일 GIS의 개발)

  • Lee, Ki-Yamg;Yun, Jae-Kwan;Han, Ki-Joon
    • Journal of Korea Spatial Information System Society
    • /
    • v.6 no.1 s.11
    • /
    • pp.73-85
    • /
    • 2004
  • Recently, as the growth of the wireless Internet, PDA and HPC, the focus of research and development related with GIS(Geographic Information System) has been changed to the Real-Time Mobile GIS to service LBS. To offer LBS efficiently, there must be the Real-Time GIS platform that can deal with dynamic status of moving objects and a location index which can deal with the characteristics of location data. Location data can use the same data type(e.g., point) of GIS, but the management of location data is very different. Therefore, in this paper, we studied the Real-Time Mobile GIS using the HBR-tree to manage mass of location data efficiently. The Real-Time Mobile GIS which is developed in this paper consists of the HBR-tree and the Real-Time GIS Platform HBR-tree. we proposed in this paper, is a combined index type of the R-tree and the spatial hash Although location data are updated frequently, update operations are done within the same hash table in the HBR-tree, so it costs less than other tree-based indexes Since the HBR-tree uses the same search mechanism of the R-tree, it is possible to search location data quickly. The Real-Time GIS platform consists of a Real-Time GIS engine that is extended from a main memory database system. a middleware which can transfer spatial, aspatial data to clients and receive location data from clients, and a mobile client which operates on the mobile devices. Especially, this paper described the performance evaluation conducted with practical tests if the HBR-tree and the Real-Time GIS engine respectively.

  • PDF

A Study on the Menu Development for the Elderly during Busy Farming Season in Gyeongbuk Andong (경북 안동시 농번기 농촌노인 식단개발 연구)

  • Kim, Hae-Young;Park, Chan-Eun;Lee, Hae-Jin;Park, Young-Hee;Lee, Jin-Young
    • Journal of the Korean Society of Food Science and Nutrition
    • /
    • v.38 no.10
    • /
    • pp.1381-1391
    • /
    • 2009
  • Dietary life style of the elderly living in rural areas of Gyeongbuk Andong during the busy farming season was surveyed and a monthly meal plan for the elderly was developed using eco-friendly native crops and considering the characteristics of a busy farming season and their preferences. A week meal plan was selected and applied to those fields. The meal plan was developed for an elder's house in Gyeongbuk Andong during the busy farming season. Especially, to increase the intake of calcium and dietary fiber, bamboo sprouts, pepper leaves, dried slices of whitebait, and fried anchovies were used. Considering the busy farming season, the ginseng chicken soup and the soybean noodle soup were served to provide high quality of protein and to improve health condition. A cold soup of cucumber and brown seaweed was used to supplement liquid, vitamins, and minerals. The results are as follows: the highest score of the preference on a staple was 8.77 for the boiled barley of menu 5; the favorite soup was the ginseng chicken soup (8.73) in menu 4; for side dishes, those in menu 5 were most popular (8.69); the favorite meal was the ginseng chicken soup of menu 4 (8.69). Regarding the amount of leftover foods, the lightest was 30.14 g in Gyeongbuk Andong menu 3 which significantly indicates high preference (p<0.05). The current study was a planned meal service menu using local crops and seasonal foods, which was actually applied to the field resulting in high preference and satisfaction levels.

Suggestion on the Optimal Length of Long Tunnels Considering Traffic Safety Characteristics (교통안전 특성을 고려한 장대터널 적정길이 제시)

  • Kim, Joong-Hyo;Lee, Jeong-Hwan;Kwon, Sung Dae;Ha, Dong Ik
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.34 no.1
    • /
    • pp.203-211
    • /
    • 2014
  • Tunnel reduces travel time as and it is essential facilities for the eco-friendly road construction. In recent years, It has been accelerating the tunnel construction to provide a higher level of traffic service but a driver driving in the narrow and dark tunnel takes characteristically psychological anxiety and the restriction of the sight. Moreover, A driver passing through more than 1,000m long tunnel, as to pass inside the monotonous form of the tunnel for a long time can cause drowsiness and increase the driver load. This driver load can degrade road-holding of the inside of the long tunnel highly and pose a high risk of accidents. Accordingly, In this study is to present the proper length of the Tunnel, considering the characteristics of traffic accident. For this, this study is that the long tunnel that affects traffic safety traffic safety variables are selected and classified. Traffic safety variables are classified in detail as a variable of the traffic accident and velocity one, the applicable variables the number of the traffic accident, the ratio of the traffic accident, driving velocity, the individual vehicle velocity etc. Traffic safety variables are categorized as more than a pole length of the tunnel in order to examine its impact on correlation analysis. The results indicate significant results in traffic accidents in accordance with traffic accidents, traffic safety, selects the variable was Variable depending on the length of the tunnel traffic safety point of significantly increasing the possibility of an accident can be seen as a high point. And the point of the Distribution of selected variables in order to create a traffic safety was a significant increase in traffic safety variables was set at critical intervals. Before reaching the critical point and the corresponding length of the long tunnel was set at the proper length. In this study, the optimum length of the proposed long tunnel through the long tunnel that occur in the future to contribute to reducing traffic accidents would be able to be determined.

Big Five Personality in Discriminating the Groups by the Level of Social Sims (심리학적 도구 '5요인 성격 특성'에 의한 소셜 게임 연구: <심즈 소셜> 게임의 분석사례를 중심으로)

  • Lee, Dong-Yeop
    • Cartoon and Animation Studies
    • /
    • s.29
    • /
    • pp.129-149
    • /
    • 2012
  • The purpose of this study was to investigate the clustering and Big Five Personality domains in discriminating groups by level of school-related adjustment, as experienced by Social Sims game users. Social Games are based on web that has simple rules to play in fictional time and space background. This paper is to analyze the relationships between social networks and user behaviors through the social games . In general, characteristics of social games are simple, fun and easy to play, popular to the public, and based on personal connections in reality. These features of social games make themselves different from video games with one player or MMORPG with many unspecific players. Especially Social Game show a noticeable characteristic related to social learning. The object of this research is to provide a possibility that game that its social perspective can be strengthened in social game environment and analyze whether it actually influences on problem solving of real life problems, therefore suggesting its direction of alternative play means and positive simulation game. Data was collected by administering 4 questionnaires (the short version of BFI, Satisfaction with life, Career Decision-.Making Self-.Efficacy, Depression) to the participants who were 20 people in Seoul and Daejeon. For the purposes of the data analysis, both Stepwise Discriminant analysis and Cluster analysis was employed. Neuroticism, Openness, Conscientiousness within the Big Five Personality domains were seen to be significant variables when it came to discriminating the groups. These findings indicated that the short version of the BFI may be useful in understanding for game user behaviors When it comes to cultural research, digital game takes up a significant role. We can see that from the fact that game, which has only been considered as a leisure activity or commercial means, is being actively research for its methodological, social role and function. Among digital game's several meanings, one of the most noticeable ones is the research on its critical, social participating function. According to Jame Paul gee, the most important merit of game is 'projected identity'. This means that experiences from various perspectives is possible.[1] In his recent autobiography , he described gamer as an active problem solver. In addition, Gonzalo Francesca also suggested an alternative game developing method through 'game that conveys critical messages by strengthening critical reasons'. [2] They all provided evidences showing game can be a strong academic tool. Not only does a genre called social game exist in the field of media and Social Network Game, but there are also some efforts to positively evaluate its value Through these kinds of researches, we can study how game can give positive influence along with the change in its general perception, which would eventually lead to spreading healthy game culture and enabling fresh life experience. This would better bring out the educative side of the game and become a social communicative tool. The object of this game is to provide a possibility that the social aspect can be strengthened within the game environment and analyze whether it actually influences the problem solving of real life problems. Therefore suggesting it's direction of alternative play means positive game simulation.

Antecedents of Trust and Effects on Committment in B2B e-Marketplace (B2B 마켓플레이스에서 신뢰의 선행요인과 몰입에 미치는 영향)

  • Oh, Sang-Hyun;Kim, Sang-Hyeon
    • Journal of Distribution Research
    • /
    • v.13 no.1
    • /
    • pp.1-33
    • /
    • 2008
  • As the interest in the business-to-business(B2B) electronic commerce is increasing, many companies are participating in the B2B e-Marketplaces. The e-Marketplace is defined as the virtual market that many players take part in to transact. The e-Marketplace has an influenced on the manner in which organizational buyers and sellers interact. As a result, it is important to develop an understanding of the behaviors of firms that use these electronic marketplaces. The purpose of this study is to develop a comprehensive model for trust and commitment of B2B e-Marketplace and empirically to examine their structural relationships. Drawing from trust and commitment theory in the interorganizational relationship and B2B electronic commerce context, this study identifies network externality, interactivity, justice, quality of information sharing, institutional assurance as the determinants of trust and commitment of e-Marketplace. The proposed model hypothesized that (1) trust is a function of network externality, interactivity, justice, quality of information sharing, institutional assurance, (2) attitudinal and behavioral commitment is a function of trust, (3) behavioral commitment is a function of attitudinal commitment. The proposed model is tested using organizational-level survey data from 187 buying organizations that conduct business in MRO e-Marketplaces. The data were tested by reliability test, correlation analysis, exploratory factor analysis, confirmatory factor analysis and covariance structure analysis. The results indicate that (1) trust is influenced by network externality, interactivity, justice, institutional assurance, (2) attitudinal commitment and behavioral commitment is influenced by trust (3) behavioral commitment is influenced by attitudinal commitment. Also, the empirical results confirmed that trust play a strong, central role in determinging e-Marketplace commitment. The key theoretical contribution of this research is that it begins to extend interorganizational information system literature in areas such as B2B Internet e-Marketplace. Managerially, this study contributes tn the understanding of the role of B2B e-Markeplace providers in Internet situation. And Limitations of this study and guidelines for future researches are also discussed.

  • PDF

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