• Journal of KIISE:Computing Practices and Letters
• /
• v.16 no.11
• /
• pp.1031-1040
• /
• 2010

Hash join is one of the core algorithms in databases management systems. If a hash join cannot complete in one-pass because the available memory is insufficient (i.e., hash table overflow), however, it may incur a few sequential writes and excessive random reads. With harddisk as the tempoary storage for hash joins, the I/O time would be dominated by slow random reads in its probing phase. Meanwhile, flash memory based SSDs (flash SSDs) are becoming popular, and we will witness in the foreseeable future that flash SSDs replace harddisks in enterprise databases. In contrast to harddisk, flash SSD without any mechanical component has fast latency in random reads, and thus it can boost hash join performance. In this paper, we investigate several important and practical issues when flash SSD is used as tempoary storage for hash join. First, we reveal the va patterns of hash join in detail and explain why flash SSD can outperform harddisk by more than an order of magnitude. Second, we present and analyze the impact of cluster size (i.e., va unit in hash join) on performance. Finally, we emperically demonstrate that, while a commerical query optimizer is error-prone in predicting the execution time with harddisk as temporary storage, it can precisely estimate the execution time with flash SSD. In summary, we show that, when used as temporary storage for hash join, flash SSD will provide more reliable cost estimation as well as fast performance.

• Journal of Korean Society of Transportation
• /
• v.20 no.7
• /
• pp.107-116
• /
• 2002

Crash Cushion is a kind of safety facilities on roadside which acts the role of absorbing impact energy when vehicles are driven out of normal route such as Gore area of freeway off ramp. Criteria for severity index considering accident occurrence possibility are needed to have strong effect on installing the facilities. However, present criteria for establishing crash cushion design do not include such processes. Therefore, the paper presents two kinds of study to develop criteria for severity index. First of all, development of accident forecasting model on freeway off ramp is presented. The module is a relationship between accidents and road environment by negative binomial distribution (NB) which is called to reflect very well quality of accidents at Gore of crash cushion installed freeway Secondly, freeway exiting behavior model is developed because the human factor is the most important one. However, many literatures have shown between road environment and accidents which are more quantitative than human factor. The study supposed advanced process steps on actual freeway and analysed correlation between variables and accidents. The criteria for severity index is presented to determine whether to install or not by benefit cost analysis for each module. The standard for severity index will help to determine whether to install the crash cushion or not and to estimate severity for freeway and off ramp.

• Journal of Korean Society of Transportation
• /
• v.31 no.1
• /
• pp.37-46
• /
• 2013

Lane closure in freeway work zone due to maintenance and repair of freeway facilities results in abrupt change of traffic flow. Sudden change of traffic flow results strong interactions among vehicles, and reduces capacity compared to the ordinary traffic condition. Such capacity reduction is likely to cause congestion, traffic queues, and economic loss cost. This study aims to determine the base capacity for a short-term freeway work zone that can be used to establish a work zone schedule in advance without any traffic impact. First, the research collected detector data and schedule data of road works on all freeways in Korea. Second, the research determined 23 study sites finding the capacity values of work zone after matching two kinds of data. All study sites had varying characteristics regarding traffic flow being adjacent to work zone during road works. The capacity values were reviewed in terms of lane closure configuration, the types of work, and design speed. Finally, research proposed capacity values for a short-term freeway work zone with the design speeds of 100 kph, 120 kph and 1,700 pcphpl, 1,750 pcphpl, respectively.

• KIPS Transactions on Computer and Communication Systems
• /
• v.2 no.12
• /
• pp.533-540
• /
• 2013

Anonymity is the one of main reasons for substantial improvement of Internet. It encourages various users to express their opinion freely and helps Internet based distributed systems vitalize. But, anonymity can cause unexpected threats because personal information of an online user is hidden. Especially, distributed systems are threatened by Sybil attack, where one malicious user creates and manages multiple fake online identities. To prevent Sybil attack, the traditional solutions include increasing the complexity of identity generation and mapping online identities to real-world identities. But, even though the high complexity of identity generation increases the generation cost of Sybil identities, eventually they are generated and there is no further way to suppress their activity. Also, the mapping between online identities and real identities may cause high possibility of losing anonymity. Recently, some methods using online social network to prevent Sybil attack are researched. In this paper, a new method is proposed for extracting a user's system-wide Sybil-resistant trust value by using the properties embedded in online social network graphs. The proposed method can be categorized into 3 types based on sampling and decision strategies. By using graphs sampled from Facebook, the performance of the 3 types of the proposed method is evaluated. Moreover, the impact of Sybil attack on nodes with different characteristics is evaluated in order to understand the behavior of Sybil attack.

• Journal of Intelligence and Information Systems
• /
• v.22 no.2
• /
• pp.13-31
• /
• 2016

Despite expectations of short- or long-term positive effects of corporate social responsibility (CSR) on firm performance, the results of existing research into this relationship are inconsistent partly due to lack of clarity about subordinate CSR concepts. In this study, keywords related to CSR concepts are extracted from atypical sources, such as newspapers, using text mining techniques to examine the relationship between CSR and firm performance. The analysis is based on data from the New York Times, a major news publication, and Google Scholar. We used text analytics to process unstructured data collected from open online documents to explore the effects of CSR on short- and long-term firm performance. The results suggest that the CSR index computed using the proposed text - online media - analytics predicts long-term performance very well compared to short-term performance in the absence of any internal firm reports or CSR institute reports. Our study demonstrates the text analytics are useful for evaluating CSR performance with respect to convenience and cost effectiveness.

• Korean Journal of Social Welfare Studies
• /
• no.37
• /
• pp.5-33
• /
• 2008

This study examines the use of medical care by the poor through analysing KNHANES III databases, and the focus of the study is on under-satisfaction of medical needs and the impact of the medicare system. The results of analysis are summerized as follows; the poor had generally suffered from poor health condition, and did not have economic resoure to satisfy the medical needs. But, the beneficiaries of the medicare used much more medical care than non-poor. The result of logistic regression suggest that the medicare affected significantly on increase of uses. Consquently, the medicare system effectively made up the lack of economic resoure of the poor. However, the Medicare did not sufficient to satisfy all the medical needs of the poor. Over 20% of the poor had experinced the abandonment of meical care uses, "the lack of econmic resource" was most important reason. The result of logistic regression suggest that all the poor such as Medicare I and Medicare II beneficiaries, and near-poor class had much more probabilities of giving up the use of medical care than non-poor. It is necessary to raise up the benefit level of the current medicare system such as the reduction of non-secured medical cost, the alleviation of user's burden etc.

• Proceedings of the Korea Water Resources Association Conference
• /
• 2017.05a
• /
• pp.55-55
• /
• 2017

가뭄은 국민생활 및 경제 등에 막대한 손실을 초래하며, 지역사회 공동체나 사회기능에 심각한 영향을 끼칠 수 있는 재해이다. 가뭄피해 최소화를 위해서는 단기대응, 복구지원 등의 사후대책에서 사전대비 및 예방으로의 정책 전환이 필요하며, 이러한 정책 수립을 뒷받침하기 위해서는 가뭄에 따른 정량적인 피해영향 평가가 우선적으로 필요하다. 하지만 가뭄 피해의 범위 및 형태는 워낙 광범위하기 때문에, 피해추정을 위한 잣대라 할 수 있는 영향평가 기법조차 제대로 정립되지 못하고 있는 실정이다. 국내에서는 분야별(기상, 농업, 수문)로 지수화 된 지표를 이용한 가뭄 평가가 주로 수행되고 있으며, 경제적 영향평가는 방법론에 대한 시범 연구 수준이다. 가뭄기록조사 등 과거 가뭄피해 자료에서도 피해액의 금액환산이 되지 않은 사례가 대부분이며 급수차지원, 관정개발 등 사후복구비 위주의 일부 자료만이 피해금액으로 제시되어 있을 뿐이다. 댐, 저수지 등에 의한 용수공급 안정성으로 인해, 기상학적인 가뭄이 즉시 물부족으로 인한 피해로 이어지지는 않지만, 물부족이 발생하거나 부족량이 예측되는 상황에서 피해규모를 시스템적으로 추정 및 비교할 수 있는 기법 개발의 필요성에 의해 잠재피해액 개념의 공급지장비용 추정기법을 개발하였다. 공급지장비용 또는 편익 도출을 위한 이론적 배경으로, 경제적 가치 또는 파급효과를 분석하기 위한 방법은 경제학적 접근법과 비경제학적 접근법으로 구분된다. 경제학적 접근법에서 사용하는 진술선호 기법의 경우 전국을 대상으로 설문 등의 과정을 거쳐 지불의사액을 도출하는 과정이 필요하기 때문에 많은 조사비용이 소요된다. 비경제학적 또는 공학적 접근법으로 분류되는 대체비용법은 이론적 배경이 약하고 대체항목의 선택에 주의가 필요하다는 단점이 있으나, 물가자료, 산업통계, 수자원통계 등 기초자료의 주기적 업데이트가 유리하며, 정신적 피해를 제외할 경우 피해비용 추정결과의 편차가 진술선호기법 보다는 작은 장점이 있다. 본 연구에서는 피해비용의 과대추정에 유의하여 대체비용법에 기반한 일본 후생노동성의 감 단수피해추정기법을 우리나라 자료에 맞게 수정하여 공급지장비용을 추정하였으며, 경제학적 접근법에 의한 용수의 한계가치비용 등과 비교를 통해 적용성을 검토하였다.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.20 no.4
• /
• pp.76-85
• /
• 2019

Recently, various investigation of vegetable oil which is extracted from natural resources is being progressed because of its low cost and environmental aspect. However, double bonds in vegetable oil should be substituted to other high reactive functional group due to its low reactivity for synthesizing bio-polymeric materials. ${\alpha}$-eleostearic acid, which is consist of conjugated triene, is the main component of tung oil, and the conjugated triene allows tung oil to have higher reactivity than other vegetable oil. In this study, tung oil is copolymerized with styrene and divinylbenzene to make thermoset resin without any substitution of functional group. Thermal and mechanical properties are measured to investigate the effects of the composition of each monomer on the synthesized thermoset resin. The result shows that the products have only one Tg, which means the synthesized thermoset resins are homogeneous in molecular level. Mechanical properties show that tung oil act as soft segment in the copolymer and make more elastic product. On the other hand, divinylbenzene acts as hard segment and makes more brittle product.

• Korean Chemical Engineering Research
• /
• v.57 no.1
• /
• pp.51-57
• /
• 2019

A plant layout problem has a large impact on the overall construction cost of a plant. When determining a plant layout, various constraints associating with safety, environment, sufficient maintenance area, passages for workers, etc have to be considered together. In general plant layout problems, the main goal is to minimize the length of piping connecting equipments as satisfying various constraints. Since the process may suffer from the heat and friction loss, the piping length between equipments should be shorter. This problem can be represented by the mathematical formulation and the optimal solutions can be investigated by an optimization solver. General researches have overlooked many constraints such as maintenance spaces and safety distances between equipments. And, previous researches have tested benchmark processes. What the lack of general researches is that there is no realistic comparison. In this study, the plant layout of a real industrial C3MR (Propane precooling Mixed Refrigerant) process is studied. A MILP (Mixed Integer Linear Programming) including various constraints is developed. To avoid the violation of constraints, penalty functions are introduced. However, conventional optimization solvers handling the derivatives of an objective functions can not solve this problem due to the complexities of equations. Therefore, the PSO (Particle Swarm Optimization), which investigate an optimal solutions without differential equations, is selected to solve this problem. The results show that a proposed method contributes to saving the capital expenditures.

• The Journal of The Korea Institute of Intelligent Transport Systems
• /
• v.17 no.6
• /
• pp.1-13
• /
• 2018

The number of deaths in Korea is higher than the OECD average. Therefore, an e-Call system is being developed as a vehicle ICT-based emergency rescue system that automatically detects an accident in the event of a vehicle accident and transmits related information to the center. In order to overcome the limitations of social acceptability and function of e-Call system, we propose a model that allows users to be aware of the necessity of service voluntarily. We predicted the market share of e-call services according to the proposed business model and analyzed it through B/C analysis. Benefits are calculated on a penetration basis, and device purchase and communications costs are calculated for each period. B/C analysis shows that pessimistic scenarios are 0.98 in 2025 and 1.01 in 2030. In an optimistic scenario, it is 1.05 in 2025 and 1.20 in 2030, which is more economical.