• CRM연구
• /
• 제2권2호
• /
• pp.53-70
• /
• 2009

분석 CRM 영역에서는 고객 데이터 분석을 통하여 고객 행동과 관련된 통찰력을 얻는 것이 중요하다. 이러한 분석 과정에서, 사용자 스스로 기업 데이터베이스에서 대용량 고객 이력 데이터를 조회하고 추출하기 위해서는 SQL 을 사용하여 자유롭게 질의구문을 작성할 수 있어야 한다. 그런데 일반 사용자들이 이러한 업무를 수행하고자 할 때, 기업 데이터베이스 구성 요소에 대한 전문적인 지식이 부족하기 때문에 정보 탐색에 있어서 어려움을 겪는다. 이를 해결하기 위한 방안으로 본 연구에서는 사용자가 제공하는 자연어 수준의 질의를 분석하고, 데이터베이스를 구성하는 값을 중심으로 올바른 질의 결과를 제공하기 위한 데이터베이스 구성요소 인덱싱 방법론을 제안한다. 구체적으로 기업 데이터베이스를 구성하는 세 가지 요소인 관계, 속성, 값에 대한 정보를 읽어 들여 요약 정보에 대한 인덱스를 구성한 다음 사용자의 자연어 질의에서 분석된 의미 단위 별로 데이터베이스 요약 정보와 연결해주는 TableRank 기법을 소개한다. 실험용 데이터베이스를 대상으로 테스트를 수행한 결과, 사용자의 자연어 질의 결과가 데이터베이스를 구성하는 값 정보와 연결되는 것이 관찰되었다. 논문의 후반부에서는 자연어 질의를 자동적으로 처리하기 위한 선행 모듈 개발의 시사점을 정리하고, 향후 기업 데이터베이스 자동 검색 시스템으로 발전하기 위한 방안에 대해서도 설명한다.

• 무역학회지
• /
• 제47권3호
• /
• pp.75-92
• /
• 2022

This study aims to analyze the International trade network of Water transport service using Social Network Analysis for defining the status of Korean Water transport industry. This study use World Input-Output Table of Asian Development Bank from 2000 to 2020 and build the International trade matrix of Water transport service from that. Therefore, this study analyze Out-degree centrality, In-degree centrality and betweenness centrality of Korea and other main countries in the matrix of World Water transport industry. As a result, Korea rank above 10th in the all centralities and the total output also rank 8th in the world, therefore, this study show the importance of Korean Water transport industry in the world. However, Singapore has the highest centrality in the world, even though China has the largest Total output among 63 countries.

• 자원환경지질
• /
• 제22권2호
• /
• pp.141-150
• /
• 1989

In order to make economic and geological evaluation of coal in Korea, proximate and ultimate analyses were carried out as well as coal petrological studies such as maceral analyses, vitrinite reflectance and sporinite fluorescence measurement. The coeffcient of correlation between each factor of both conventional utilization and coal petrological parameters were studied as in Table 5 and 6. Their conclusions were as follow: (1) for anthracite, the good parameters of coal rank are mean vitrinite reflectance, carbon content, hydrogen content and H/C atomic ratio: (2) for brown coal and sub-bituminous coal, the good parameters of coal rank are carbon content, calorific value, moisture content, hydrogen content, oxygen content and O/C atomic ratio as well as vitrinite reflectance and sporinite fluorescence. An attempt is made to infer the coalforming environment by utilization of coal petrological analyses and to make comparison of coal analyses with proximate and ultimate analyses throughout the island arc region including Japan, Philippine and Indonesia and continental region including USA, Canada and Australia. As a result, meceral composition of Paleozoic and Mesozoic anthracite are similar to that of the Paleozoic continental coals, which were formed under dry conditions or low water table, but the coalification degree suddenly increased during Daebo orogeny (middle Jurassic to lower Cretaceous). The Tertiary coal resembles those of Tertiary island arc region coal characterized by higher calorific value, volatile matter content and H/C atomic ratio and by the formation of coal under wet conditions or higher water table.

• 환경영향평가
• /
• 제6권1호
• /
• pp.111-119
• /
• 1997

This study was carried out to suggest the best statistical test which may be used to quantify the change of water quality between two groups. Traditional t-test may not be used in cases where the normality of underlying population distribution is not assured. Three non-parametric tests which are based on the relative order of the measurements, were studied to find out the applicability in water quality data analysis. The sign test is based on the sign of the deviation of the measurement from the median value, and the binomial distribution table is used. The signed rank test utilizes not only the sign but also the magnitude of the deviation. The Wilcoxon rank-sum test which is basically same as Mann-Whitney test, tests the mean difference between two independent samples which may have missing data. Among the three non-parametric tests studied, the singed rank test was found out to be applicable in the quantification of the change of water quality between two samples.

• 대한기계학회:학술대회논문집
• /
• 대한기계학회 2003년도 추계학술대회
• /
• pp.1512-1517
• /
• 2003

This paper presents the calibration for the parallel typed tilting table. The calibration system needs only simple sensing device which is a digital indicator to measure the orientation of a table. The calibration algorithm is developed by a measurement operator. It eliminates the concern about the poor parameter observability due to a large number of parameters of parallel-mechanism. This paper uses the QR-decomposition to find the optimal calibration configurations maximizing the linear independence of rows of a observation matrix. The number of identifiable parameters is examined by the rank of the observation matrix, which represents the parameter observability. The method is applied to a Parallel-typed Tilting Table and all the necessary kinematic parameters are identifiable.

• 대한기계학회논문집A
• /
• 제29권6호
• /
• pp.795-803
• /
• 2005

This paper studies the observability of calibration system with a measurement operator. The calibration system needs a simple digital indicator to measure the mobile table movements with respect to the MC coordinate. However, it yields the concern about the poor parameter observability due to measuring only a part of the movements. We uses the QR-decomposition to find the optimal calibration configurations maximizing the linear independence of rows of an observation matrix. The number of identifiable parameter is examined by the rank of the observation matrix, which represents the parameter observability. The method is applied to a 6-axis MC with parallel tilting table and the calibration results are presented. These results verify that all necessary kinematic parameters are observable and the calibration system has robustness to the noise using optimal calibration configurations.

• 대한지역사회영양학회지
• /
• 제20권1호
• /
• pp.53-60
• /
• 2015

Objectives: The purpose of this study is to provide the basic data for efficient operation and management of the military foodservice by analyzing the satisfaction of the quality of the foodservice and the perception of the military foodservice which are provided according to the ranks of the soldiers. Methods: A total of 252 military personnel (48 Private, 87 Private first class, 74 Corporal and 43 Sergeant) participated in Gyeonggi area from November 1 to 30, 2013, and data were analyzed by the SPSS Win (ver 18.0). Results: The perception with foodservice, variety of menu (p < 0.001), importance (p < 0.01), problem (p < 0.05) and leftover reason (p < 0.05) significantly differed by the rank of the soldiers. With regard to the satisfaction with food, there were significant difference by rank for all items (p < 0.01). Satisfaction with facilities did not indicate significant differences by rank. Satisfaction with sanitation indicated significant difference by rank in the categories of table ware (p < 0.05), process of distribution (p < 0.05), employee's uniform (p < 0.001) and drinking water (p < 0.05). Satisfaction with service indicated significant difference by rank with regard to kindness of employees (p < 0.01), providing information on foodservice (p < 0.05) and fast distribution (p < 0.01). Conclusions: In order to improve the satisfaction of all ranks, there is a need to offer a variety of nutritionally balanced menu and a proper amount of food provided through the voluntary food distribution services. The results also suggested the need to find a sustainable foodservice management plan to carry out satisfaction surveys regularly in the military foodservice.

• 대한산업공학회지
• /
• 제12권2호
• /
• pp.101-108
• /
• 1986

Computer programs for IBM PC/XT/AT or compatibles, are presented for running 9 nonparametric tests. They include sign test, Wilcoxon signed rank test, Mann-Whitney Wilcoxon test, Kruskal-Wallis test, Kolmogorov-Smirnov one sample and two sample tests, Kendall and Spearman rank correlation coefficient tests, and Chi square test for contingency table. Each program is written with BASIC language and is combined into a statistical package, 'NONPARA'. It is easily accessible through the menu programs. The alogorithms on which each test is based, are also explained and 3 examples are given.

• Journal of the Korean Data and Information Science Society
• /
• 제16권2호
• /
• pp.477-505
• /
• 2005

This paper gives a computer code that gives p-value's for Kendall's Tau table. The code centers around finding the cumulative frequency of a given Sigma value. Current tables usually give critical values for given cut-off percentages. For small sample sizes the critical values may be inexact, and for large samples the values are not be published. SPSS has a built in function for finding the Kendall rank correlation, but the output does not include the Sigma value. Before the code is given, this paper will concentrate around how to find the Sigma value, and the related tau statistic. The computer code is written in MATLAB, but the ideas can be easily transferred to different languages.

• Journal of Electrical Engineering and Technology
• /
• 제2권3호
• /
• pp.408-412
• /
• 2007

It is almost impossible to secure the reproductibility and stability of a commercial Thick-Film Metal Oxide Semiconductor Gas Sensor since it is very difficult to keep the consistency of the manufacturing environment. Thus it is widely known that the general Semiconductor-Oxide Gas Sensors are not appropriate for precise measurement systems. In this paper, the output characteristic analyzer of the various Thick-Film Metal Oxide Semiconductor Gas Sensors that are used to recognize the air quality within an automobile are proposed and examined. The analyzed output characters in a normal air chamber are grouped by sensor ranks and used to fill out the characteristic table of the Thick-Film Metal Oxide Semiconductor Gas Sensors. The characteristic table is used to determine the rank of the sensor that is equipped in the current air cleaner system of an automobile. The proposed air control system can also adapt the on-demand operation that recognizes the history of the passenger's manual-control.