• CRM연구
• /
• v.2 no.2
• /
• pp.53-70
• /
• 2009

Understanding consumer behavior based on the analysis of the customer data is one essential part of analytic CRM. To do this, the analytic skills for data extraction and data processing are required to users. As a user has various kinds of questions for the consumer data analysis, the user should use database language such as SQL. However, for the firm's user, to generate SQL statements is not easy because the accuracy of the query result is hugely influenced by the knowledge of work-site operation and the firm's database. This paper proposes a natural language based database search framework finding relevant database elements. Specifically, we describe how our TableRank method can understand the user's natural query language and provide proper relations and attributes of data records to the user. Through several experiments, it is supported that the TableRank provides accurate database elements related to the user's natural query. We also show that the close distance among relations in the database represents the high data connectivity which guarantees matching with a search query from a user.

• Korea Trade Review
• /
• v.47 no.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.

• Economic and Environmental Geology
• /
• v.22 no.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.

• Journal of Environmental Impact Assessment
• /
• v.6 no.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.

• Proceedings of the KSME Conference
• /
• 2003.11a
• /
• 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.

• Transactions of the Korean Society of Mechanical Engineers A
• /
• v.29 no.6 s.237
• /
• 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.

• Korean Journal of Community Nutrition
• /
• v.20 no.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.

• Journal of Korean Institute of Industrial Engineers
• /
• v.12 no.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
• /
• v.16 no.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
• /
• v.2 no.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.