• Title/Summary/Keyword: locks

Search Result 91, Processing Time 0.024 seconds

Adaptive Lock Escalation in Database Management Systems (데이타베이스 관리 시스템에서의 적응형 로크 상승)

  • Chang, Ji-Woong;Lee, Young-Koo;Whang, Kyu-Young;Yang, Jae-Heon
    • Journal of KIISE:Databases
    • /
    • v.28 no.4
    • /
    • pp.742-757
    • /
    • 2001
  • Since database management systems(DBMSS) have limited lock resources, transactions requesting locks beyond the limit mutt be aborted. In the worst carte, if such transactions are aborted repeatedly, the DBMS can become paralyzed, i.e., transaction execute but cannot commit. Lock escalation is considered a solution to this problem. However, existing lock escalation methods do not provide a complete solution. In this paper, we prognose a new lock escalation method, adaptive lock escalation, that selves most of the problems. First, we propose a general model for lock escalation and present the concept of the unescalatable look, which is the major cause making the transactions to abort. Second, we propose the notions of semi lock escalation, lock blocking, and selective relief as the mechanisms to control the number of unescalatable locks. We then propose the adaptive lock escalation method using these notions. Adaptive lock escalation reduces needless aborts and guarantees that the DBMS is not paralyzed under excessive lock requests. It also allows graceful degradation of performance under those circumstances. Third, through extensive simulation, we show that adaptive lock escalation outperforms existing lock escalation methods. The results show that, compared to the existing methods, adaptive lock escalation reduces the number of aborts and the average response time, and increases the throughput to a great extent. Especially, it is shown that the number of concurrent transactions can be increased more than 16 ~256 fold. The contribution of this paper is significant in that it has formally analysed the role of lock escalation in lock resource management and identified the detailed underlying mechanisms. Existing lock escalation methods rely on users or system administrator to handle the problems of excessive lock requests. In contrast, adaptive lock escalation releases the users of this responsibility by providing graceful degradation and preventing system paralysis through automatic control of unescalatable locks Thus adaptive lock escalation can contribute to developing self-tuning: DBMSS that draw a lot of attention these days.

  • PDF

Study on development of the remote control door lock system including speeker verification function in real time (화자 인증 기능이 포함된 실시간 원격 도어락 제어 시스템 개발에 관한 연구)

  • Kwon, Soon-Ryang
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.15 no.6
    • /
    • pp.714-719
    • /
    • 2005
  • The paper attempts to design and implement the system which can remotely check visitors' speech or Image by a mobile phone. This system is designed to recognize who a visitor is through the automatic calling service, not through a short message, via the mobile phone, even when the home owner is outside. In general, door locks are controlled through the home Server, but it is more effective to control door locks by using DTMF signal from a real-time point of view. The technology suggested in this paper makes it possible to communicate between the visiter and the home owner by making a phone call to tile home owner's mobile phone automatically when the visiter visits the house even if the home owner is outside, and if necessary, it allows for the home owner to control the door lock remotely. Thanks to the system, the home owner is not restricted by time or space for checking the visitor's identification and controlling the door lock. In addition, the security system is improved by changing from the existing password form to the combination of password and speaker verification lot the verification procedure required for controlling the door lock and setting the environment under consideration of any disadvantages which may occur when the mobile Phone is lost. Also, any existing problems such as reconnection to tile network for controlling tile door lock are solved by controlling the door lock in real time by use of DTMF signal while on the phone.

Burglary Prevention Effect of Target Hardening through Certified Security Products by WDQ Analysis (WDQ분석을 통한 타겟하드닝 CPTED의 침입범죄 예방효과 검증: 안산시 사례 중심으로)

  • Park, Hyeonho;Kim, Kang-Il;Cho, Joon-Tag
    • Korean Security Journal
    • /
    • no.56
    • /
    • pp.9-30
    • /
    • 2018
  • Crime prevention strategies are introduced to reduce the loss caused by crimes, and Target hardening against domestic burglary attacks is broadly accepted as one of such physical security strategies. In terms of business and home security, target hardening is one of the suite of protective measures that are included in crime prevention through environmental design(CPTED). This can include ensuring all doors and windows are sourced and fitted in such a way that they can resist forcible and surreptitious from the attack of intruder. Target hardening with certified security doors, security windows and secure locks are revealed to be much more effective to deter burglary attacks than other security devices, such as CCTV, lightings and alarms which have largely psychological and indirect impact. A pilot program of target hardening utilizing certified security window and locks was carried out in Ansan city, South Korea in 2016. This study is based on the quasi-experimental design of this program for a residential area. The researchers tried to verify the crime displacement effect of the target hardening program and the diffusion effects of crime prevention benefits by analysing the crime statistics. The evaluation utilized WDQ(Weighted Displacement Quotient) technique to analyze whether the crime displacement occurred, compared the crime statistics of the experimental area with that of buffer zone and controlled areas. The result showed that the target hardening program was significantly effective in crime prevention. The number of burglary in the experimental site with target hardening intervention reduced by 100%, although the areas without the intervention showed reduction in the burglary. The crime displacement was not found at all, and the number of burlary at the buffer zone also reduced significantly.

Concurrency Control for Transaction Management in Mobile Computing (모바일 계산환경에서 거래 관리를 위한 동시성 제어)

  • Rhee, Hae-kyung
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.40 no.6
    • /
    • pp.22-31
    • /
    • 2003
  • Traditional concurrency control strategies for database system are inappropriate for mobile computing environments in which communication disconnection could occur frequently. The time available to access transactions may be extremely limited in mobile computing. In order to ensure that this time is utilized most effectively, the short-lived transactions must be a main stream of transactions. Service handoffs which occur due to communication disconnection, could degrade the performance of mobile transactions especially for short-lived transactions. Altruistic locking protocol is in its nature favorable to short-lived transactions since it applies the donation of locks to long-lived transactions as early as possible. Performance for short-lived transactions could be improved when we applied altruistic locking to mobile computing.

Development of Recliner Sensor for Car-Seat Using Wire Mechanism (와이어 기구를 이용한 자동차 시트 리크라이너 센서 개발)

  • Lee, Jeong-Wan;Jung, Won-Seok
    • Journal of Industrial Technology
    • /
    • v.28 no.A
    • /
    • pp.71-74
    • /
    • 2008
  • Belt Integrated Seat(BIS) has many advantages compared to the existing seats. Due to the development of materials and manufacturing technology, BIS, which has been used restrictely in the past, has gone through a rapid growth. As a result, its advantages have gained attention and the possibility of replacing the existing seats has grown. The need to develop BIS has risen and presently joint development with associated industries is in progress. For its first goal, the development and research of Recliner sensor has been selected. Recliner sensor is an essential part of the BIS in which the belt is incorporated onto the seat. In seat-belts, there is an inclination sensor which locks the belt according to the angle of a car. Because the inclination sensor can change frequently depending on the back of seat, a device which can enhance the inclination sensor according to the angle of the back of seat. It is the Recliner sensor that play's this role. Studies on Recliner sensor within and outside Korea has not yet made a salient progress, and due to this fact, the joint development has made a start by benchmarking other company's products. Currently, in other to set the course of the development, a research in patents and various other information is being done. In addition, for the purpose of developing a product which will be compatible with the existing products, a prototype will be made and tested before a new product makes its launching on the market.

  • PDF

A Study on the Remodeling of Living Research about living environment renovation for disabled - Based on 27 cases of residence renovation in Incheon city - (신체장애인의 주거환경 개조에 관한 연구 - 인천시 주거개조 사례 27개를 중심으로 -)

  • Cho, Cheol-Ho;Soh, Jun-Young
    • Korean Institute of Interior Design Journal
    • /
    • v.19 no.2
    • /
    • pp.234-242
    • /
    • 2010
  • The twenty seven houses at Incheon city, were remodeled in 2009 for the physically handicapped people. This research had been done the analysis of the itemized questionnaire by the needs of the physically handicapped for their better living environment and suggested the following remodeling devices. First of all, there was the priority for the remodeling of their living facilities. According to their priority, they wanted to remodel their bathroom, kitchen & dining room, veranda, living room, and hall way. These were based on their needs of movement, personal hygiene, convenient closet, and cabinet usage. In particular, their demands were shown as followings. The wheelchair using handicapped people required safe doorknobs, unslippery floor materials, removal of step levels, and heights adjustable washing stand for their bathroom. They also requested washboard, non-threshold, and automatic door locks. Otherwise, the disabled in critical condition who could not move anything preferred the remodeling of inner structure of living spaces and automatic door system. The slight disabled and the families those who have the disabled demanded the remodeling of kitchen & dining room, and preferred the reorganization of closet, cabinets, floor tiles, and turncock. The remodeling of bedroom was mostly requested by the disabled women, people with the brain disorder, and disabled people in critical condition who could not move anything. They wanted the remote controlled lightings.

The Instantaneous Phase-Tracking in PLL using the DFT Algorithm (DFT 알고리즘을 이용한 PLL의 순시 추종)

  • Kim, Youn-Seo;Yang, Oh
    • Journal of the Institute of Electronics Engineers of Korea SC
    • /
    • v.45 no.6
    • /
    • pp.141-148
    • /
    • 2008
  • An utility voltage information, including the frequency, phase angle and amplitude is very important in many industrial systems. The grid-connected photovoltaic system in the limelight as alternative energy needs utility voltage information such as frequency, phase angle and magnitude to connect the grid-line. In this paper, it proposes the instantaneous phase-tracking in PLL that uses the frequency from the utility voltage as a sync signal and locks the phase with compensation for phase difference from DPT algorithm. It also proposes not only DFT algorithm execution by every sample not by one period, but also phase-tracking method in a wide range of frequency not a fixed one. This paper shows the feasibility and the usefulness of the proposed methods through the computer simulation and the experiment.

NUMERICAL ANALYSIS OF THE HYDRAULIC CHARACTERISTICS OF ICE-HARBOR TYPE FISHWAY (아이스하버식 어도 내 수리특성에 관한 수치해석연구)

  • Ko, S.H.;Choi, H.K.;Lee, H.B.;Rhee, S.H.
    • Journal of computational fluids engineering
    • /
    • v.20 no.3
    • /
    • pp.15-19
    • /
    • 2015
  • A fishway is a structure on or around artificial and natural barriers, such as dams, locks and waterfalls, to help fishes' natural migration. In this paper, a computational fluid dynamics (CFD) code, termed SNUFOAM is used to analyze vertical hydraulic characteristic of rollway of fishway. Volume-of-fluid (VOF) method was used to handle free-surface. It is important to determine the factors influencing flow characteristics in fishway because fish use directional information from the flow characteristics to navigate through fishway. Fishway was modeled in 2-D and the influence of the stream velocity, slope, and weir height of fishway was tested. In results, the transition Reynolds number was $2{\times}10^5{\sim}3{\times}10^5$.

A Study on Ergonomic Uncomfortableness on ADL for Korean Elderly People (우리나라 노인들을 대상으로 한 일상생활에서의 인간공학적 불편성 조사 연구)

  • Lee, Yong-Hui;Lee, Dong-Chun;Lee, Sang-Do
    • Journal of the Ergonomics Society of Korea
    • /
    • v.23 no.3
    • /
    • pp.101-109
    • /
    • 2004
  • This paper reports the results on age and gender of Korean elderly people for the level of difficulty in performing household tasks (meal preparation, grocery shopping, house cleaning, laundry), personal tasks (dressing, bathing, grooming), transfer tasks (getting in and out of chairs, getting in and out of bath-tub, using stairs) and management tasks (using telephone, accessing mail, operating door locks). A questionnaire based on the Activities of Daily Living (ADL) scale was constructed and administered to 40 Korean elderly subjects aged from 65 to 84(mean age: 74.5, SD: 5.8) in Busan. Additionally, a logistic regression was performed with age (continuous variable) and gender as predictor variables, and reponses to individual questions as the categorical ordinal response variables. To determine appropriate age separation at which difficulty levels in performing activities of daily living change, a discriminant analysis was performed on the responses. All predictor variables were used in the analysis. Accommodating age related changes in functional abilities, and increasing functional independence of elderly people will entail significant design modifications to products, systems and environments for daily use and living.

Hybrid Controller of Neural Network and Linear Regulator for Multi-trailer Systems Optimized by Genetic Algorithms

  • Endusa, Muhando;Hiroshi, Kinjo;Eiho, Uezato;Tetsuhiko, Yamamoto
    • 제어로봇시스템학회:학술대회논문집
    • /
    • 2005.06a
    • /
    • pp.1080-1085
    • /
    • 2005
  • A hybrid control scheme is proposed for the stabilization of backward movement along simple paths for a vehicle composed of a truck and six trailers. The hybrid comprises the combination of a linear quadratic regulator (LQR) and a neurocontroller (NC) that is trained by a genetic algorithm (GA). Acting singly, either the NC or the LQR are unable to perform satisfactorily over the entire range of the operation required, but the proposed hybrid is shown to be capable of providing good overall system performance. The evaluation function of the NC in the hybrid design has been modified from the conventional type to incorporate both the squared errors and the running steps errors. The reverse movement of the trailer-truck system can be modeled as an unstable nonlinear system, with the control problem focusing on the steering angle. Achieving good backward movement is difficult because of the restraints of physical angular limitations. Due to these constraints the system is impossible to globally stabilize with standard smooth control techniques, since some initial states necessarily lead to jack-knife locks. This paper demonstrates that a hybrid of neural networks and LQR can be used effectively for the control of nonlinear dynamical systems. Results from simulated trials are reported.

  • PDF