• 제목/요약/키워드: 제어 모델

검색결과 5,474건 처리시간 0.035초

The Effects of amino acid balance on heat production and nitrogen utilization in broiler chickens : measurement and modeling

  • Kim, Jj-Hyuk;MacLeod, Murdo G.
    • Proceedings of the Korea Society of Poultry Science Conference
    • /
    • 한국가금학회 2004년도 제21차 정기총회 및 학술발표회
    • /
    • pp.80-90
    • /
    • 2004
  • Three experiments were performed to test the assumption that imbalanced dietary amino acid mixtures must lead to increased heat production (HP). The first experiment was based on diets formulated to have a wide range of crude protein (CP) concentrations but a fixed concentration of lysine, formulated to be the first-limiting amino acid. In the second (converse) experiment, lysine concentration was varied over a wide range while CP content was kept constant. To prevent the masking of dietary effects by thermoregulatory demands, the third experiment was performed at 30 $^{\circ}C$ with the diets similar to the diets used in the second experiment. The detailed relationships among amino acid balance, nitrogen (N) metabolism and energy (E) metabolism were investigated in a computer-controlled chamber calorimetry system. The results of experiments were compared with the predictions of a computerised simulation model of E metabolism. In experiment 1. with constant lysine and varying CP, there was a 75 % increase in N intake as CP concentration increased. This led to a 150 % increase in N excretion. with no significant change in HP. Simulated HP agreed with the empirically determined results in not showing a trend with dietary CP. In experiment 2, with varying lysine but constant CP, there was a 3-fold difference in daily weight gain between the lowest and highest lysine diets. HP per bird increased significantly with dietary lysine concentration. There was still an effect when HP was adjusted for body weight differences, but it failed to maintain statistical significance. Simulated HP results agreed in showing little effect of varying lysine concentration and growth rate on HP. Based on the results of these two experiments, the third experiment was designed to test the response of birds to dietary lysine in high ambient temperature. In experiment 3 which performed at high ambient temperature (30 $^{\circ}C$), HP per bird increased significantly with dietary lysine content, whether or not adjusted for body-weight. The trend was greater than in the previous experiment (20 $^{\circ}C$).

  • PDF

An Efficient Method for Establishing Canopy Photosynthesis Curves of Lettuce (Lactuca sativa L.) with Light Intensity and CO2 Concentration Variables Using Controlled Growth Chamber (생육 챔버를 이용하여 광도 및 이산화탄소 농도 변수를 갖는 상추(Lactuca sativa L.)의 군락 광합성 곡선의 효율적 도출 방법)

  • Jung, Dae Ho;Kim, Tae Young;Son, Jung Eek
    • Journal of Bio-Environment Control
    • /
    • 제29권1호
    • /
    • pp.43-51
    • /
    • 2020
  • For developing a canopy photosynthesis model, an efficient method to measure the photosynthetic rate in a growth chamber is required. The objective of this study was to develop a method for establishing canopy photosynthetic rate curves of romaine lettuce (Lactuca sativa L.) with light intensity and CO2 concentration variables using controlled growth chamber. The plants were grown in plant factory modules, and the canopy photosynthesis rates were measured in sealed growth chambers made of acrylic (1.0 × 0.8 × 0.5 m). First, the canopy photosynthetic rates of the plants were measured, and then the time constants were compared between two application methods: 1) changing light intensity (340, 270, 200, and 130 μmol·m-2·s-1) at a fixed CO2 concentration (1,000 μmol·mol-1) and 2) changing CO2 concentration (600, 1,000, 1,400, and 1,800 μmol·mol-1) at a fixed light intensity (200 μmol·m-2·s-1). Second, the canopy photosynthetic rates were measured by changing the light intensity at a CO2 concentration of 1,000 μmol·mol-1 and compared with those measured by changing the CO2 concentration at a light intensity of 200 μmol·m-2·s-1. The time constant when changing the CO2 concentration at the fixed light intensity was 3.2 times longer, and the deviation in photosynthetic rate was larger than when changing the light intensity. The canopy photosynthetic rate was obtained stably with a time lag of one min when changing the light intensity, while a time lag of six min or longer was required when changing the CO2 concentration. Therefore, changing the light intensity at a fixed CO2 concentration is more appropriate for short-term measurement of canopy photosynthesis using a growth chamber.

Antihepatotoxic effect of ethanol extracts from steam-dried ginseng berry on ᴅ-galactosamine/lipopolysaccharide-sensitized mice (ᴅ-galactosamine/lipopolysaccharide로 감작된 급성간독성 마우스 모델에서 인삼열매추출물의 간독성 개선 효과)

  • Jang, Su Kil;Park, Jun Sub;Ahn, Jeong Won;Jo, Boram;Kim, Hyun Soo;Kim, JeongHoon;Kim, Sang Yun;Park, Jung Youl;Lee, Do Ik;Park, Hee Yong;Joo, Seong Soo
    • Korean Journal of Food Science and Technology
    • /
    • 제49권6호
    • /
    • pp.676-684
    • /
    • 2017
  • The present study aimed to examine the hepatoprotective effects of ethanol extracts from steam-dried ginseng berry (SGBE) in both $\text\tiny{D}$-Galactosamine/Lipopolysaccharide ($\text\tiny{D}$-GalN/LPS)-sensitized mice and in vitro models. Our results clearly demonstrated that SGBE significantly reduced the level of aspartate aminotransferase, alanine aminotransferase, alkaline phosphatase, and lactate dehydrogenase in blood, and $TNF{\alpha}$ was normalized in 8 h after the treatment with $\text\tiny{D}$-GalN/LPS. Coincidently, major organs remained unimpaired when compared to $\text\tiny{D}$-GalN/LPS control group. Moreover, p38, which stimulates expression of NAFLD-associated cytokines, was markedly inhibited when treated with SGBE. In vitro analysis revealed that the main components of SGBE, linoleic acid and ginsenoside Re/Rd, may play a role in protecting liver from $\text\tiny{D}$-GalN/LPS-induced toxicity. Finally, we concluded that SGBE may be a promising therapeutic agent for preventing damage to the liver.

Development of Rain Shelter for Chinese Cabbage Rainproof Cultivation (배추재배용 비가림하우스 개발)

  • Yu, In Ho;Lee, Eung Ho;Cho, Myeong Whan;Ryu, Hee Ryong;Moon, Doo Gyung
    • Journal of Bio-Environment Control
    • /
    • 제23권4호
    • /
    • pp.293-302
    • /
    • 2014
  • This study was carried out to develop rain shelter which can make an appropriate size and environment for Chinese cabbage rainproof cultivation. Fifty three farms with chinese cabbage rainproof cultivation system have been investigated to set up width and height of rain shelter. Mostly the width of 6m was desired for rain shelter and the height of 1.6m for their eaves, so these values were chosen as the dimensions for rain shelter. After an analysis of their structural safety and installation costs by the specifications of the rafter pipe, Ø$25.4{\times}1.5t$ and 90cm have been set as the size of rafter that such size costs the least. This size is stable with $27m{\cdot}s^{-1}$ of wind velocity and 17cm of snow depth. Therefore it is difficult to apply this dimension to area with higher climate load. In order to sort out such problem, the rain shelter has been designed to avoid damage on frame by opening plastic film to the ridge. Once greenhouse band is loosen by turning the manual switch at the both sides of rain shelter and open button of controller is pushed then switch motor rises up along the guide pipe and plastic film is opened to the ridge. Chinese cabbage can be damaged by insects if rain shelter is opened completely as revealed a field. To prevent this, farmers can install an insect-proof net. Further, the greenhouse can be damaged by typhoon while growing Chinese cabbage therefore the effect of an insect-proof net on structural safety has been analyzed. And then structural safety has been analyzed through using flow-structure interaction method at the wind condition of $40m{\cdot}s^{-1}$. And it assumed that wind applied perpendicular to side of the rain shelter which was covered by insect-proof net. The results indicated that plastic film was directly affected by wind therefore high pressure occurred on the surface. But wind load on insect-proof net was smaller than on plastic film and pressure distribution was also uniform. The results of structural analysis by applying pressure data extracted from flow analysis indicated that the maximum stress occurred at the end of pipe which is the ground part and the value has been 54.6MPa. The allowable stress of pipe in the standard of structural safety must be 215 MPa or more therefore structural safety of this rain shelter is satisfied.

Ship's Hull Fouling Management and In-Water Cleaning Techniques (선체부착생물관리와 수중제거기술)

  • Hyun, Bonggil;Jang, Pung-Guk;Shin, Kyoungsoon;Kang, Jung-Hoon;Jang, Min-Chul
    • Journal of the Korean Society of Marine Environment & Safety
    • /
    • 제24권6호
    • /
    • pp.785-795
    • /
    • 2018
  • The International Maritime Organization (IMO) has recognized the risk of hull fouling and announced '2011 Guidelines for the control and management of ship's biofouling to minimize the transfer of invasive aquatic species'and is planning international regulations to enforce them in the future. In this study, to effectively respond to future international regulation, we introduce the case of leading countries related to management of hull fouling and also investigate environmental risk assessment techniques for in-water cleaning. Australia and New Zealand, the leading countries in hull fouling management, have established hull fouling regulations through biological and chemical risk assessment based on in-water cleaning scenarios. Most European countries without their government regulation have been found to perform in-water cleaning in accordance with the IMO's hull fouling regulations. In the Republic of Korea, there is no domestic law for hull fouling organisms, and only approximately 17 species of marine ecological disturbance organisms, are designated and managed under the Marine Ecosystem Law. Since in-water cleaning is accompanied by diffusion of alien species and release of chemical substances into aquatic environments, results from biological as well as chemical risk assessment are performed separately, and then evaluation of in-water cleaning permission is judged by combining these two results. Biological risk assessment created 40 codes of in-water cleaning scenarios, and calculated Risk Priority Number (RPN) scores based on key factors that affect intrusion of alien species during in-water cleaning. Chemical risk assessment was performed using the MAMPEC (Marine Antifoulant Model to Predict Environmental Concentrations), to determine PEC and PNEC values based on copper concentration released during in-water cleaning. Finally, if the PEC/PNEC ratio is >1, it means that chemical risk is high. Based on the assumption that the R/V EARDO ship performs in-water cleaning at Busan's Gamcheon Port, biological risk was estimated to be low due to the RPN value was <10,000, but the PEC/PNEC ratio was higher than 1, it was evaluated as impossible for in-water cleaning. Therefore, it will be necessary for the Republic of Korea to develop the in-water cleaning technology by referring to the case of leading countries and to establish domestic law of ship's hull fouling management, suitable for domestic harbors.

The Study on the Marine Eco-toxicity and Ecological Risk of Treated Discharge Water from Ballast Water Management System Using Electrolysis (전기분해원리를 이용한 선박평형수관리장치의 배출수에 대한 해양생태독성 및 해양환경위해성에 관한 연구)

  • Shon, M.B.;Son, M.H.;Lee, J.;Son, Y.J.;Lee, G.H.;Moon, C.H.;Kim, Y.S.
    • Journal of the Korean Society for Marine Environment & Energy
    • /
    • 제16권2호
    • /
    • pp.88-101
    • /
    • 2013
  • The International Convention for the Control and Management of Ship's Ballast Water and Sediments was adopted at 2004 and then various BWMS (ballast water management system) have been developed. In this study, WET (whole effluent toxicity) test with algae (diatom) Skeletonema costatum as primary producer, invertebrate (rotifera) Brachionus plicatilis as 1st consumer and fish (olive flounder) Paralichthys olivaceus as predator, chemical analysis and ERA (environmental risk assessment) were conducted to assess the unacceptable effect on marine ecosystem by emitting the discharge water treated with AquaStar$^{TM}$ BWMS using electrolysis as main treatment equipment for removing the marine organisms in the ship's ballast water. The most sensitive test organism on discharge water treated with AquaStar$^{TM}$ BWMS was S. costatum that gave the NOEC value of 25.00%, LOEC value of 50.00% and 72hr-$EC_{50}$ value of 69.97% from WET test result for 20 psu salinity treated discharge water. NOEC and LOEC value of B. plicatilis and P. olivaceus exposed at 20 psu salinity treated discharge water were 50.00% and 100.00%, respectively. In the chemical analysis results, total number of substances produced by AquaStar$^{TM}$ BWMS was 18 which were bromate, 7 volatile halogenated organic compounds, 7 halogenated acetic acids, 3 halogenated acetonitriles and chloropicrin. Eighteen substances did not consider as persistence and bioaccumulative chemicals. Uncertainty of toxic property of 18 substances was high. PECs of 18 substances calculated by MAMPEC model were ranged from $4.58{\times}10^{-4}$ to $4.87{\mu}g\;L^{-1}$, PNECs of them were ranged from $1.6{\times}10^{-2}$ to $3.2{\times}10^2{\mu}g\;L^{-1}$. And, the PEC/PNEC ratio of 18 substances did not exceed 1. Therefore, ERA for produced substances indicate that the discharge water treated with AquaStar$^{TM}$ BWMS does not pose unacceptable effect on marine life. And $EC_{50}$ value of S. costatum on discharge water treated by BWMS using the electrolysis had positive correlation with initial TRO concentration, concentration and kind & level of HAAs.

Removal of Aqueous Arsenic Via Adsorption onto Si Slag (규소 슬래그를 이용한 수용상 비소 흡착 제거)

  • Kim, Seong Hee;Seol, Jeong Woo;Lee, Woo Chun;Kim, Soon-Oh
    • Economic and Environmental Geology
    • /
    • 제46권6호
    • /
    • pp.521-533
    • /
    • 2013
  • This study was initiated to evaluate the applicability of Si slag as an adsorbent via investigation of the main properties of Si slag as an adsorbent aw well as characterization of adsorption features between aqueous arsenic and Si slag. The specific surface area of Si slag was measured to be 6.71 $m^2/g$ which seems to be slightly higher than those of other slags, but relatively lower than those of iron (oxyhydr)oxides extensively used for arsenic controlling processes. The point of zero salt effect (PZSE) of Si slag determined by potentiometric titration appeared to be comparatively high (7.3), indicating the Si slag may be favorably used for adsorption of arsenic which predominantly exists as an oxy-anions. The results of adsorption isotherm indicate that regardless of arsenic species, Langmuir-type isotherm is the most suitable to simulate the adsorption of arsenic onto Si slag. With regard to pH-dependence of arsenic adsorption, the adsorption maxima of arsenite was centered at pH 7, and the adsorption was remarkably decreased in the other pH conditions. In the case of arsenate, on the other hand, the adsorption was highest at the lowest pH (4.0) and then gradually decreased with the increase of pH. Based on the results of kinetic experiments, it is likely that the adsorption of arsenite approached equilibrium within 2 hr, but it took about 8 hr for arsenate adsorption to be equilibrated. In addition, the Pseudo second order was evaluated to be most consistent with the empirical data of arsenic adsorption onto Si slag in this study. Under identical conditions, the affinity of arsenate onto Si slag was estimated to be nearly 6 times higher than that of arsenite.

Immunomodulatory Activity of Water Extract of Ulmus macrocarpa in Macrophages (유근피 추출물이 대식세포 면역조절에 미치는 영향)

  • Kwon, Da Hye;Kang, Hye-Joo;Choi, Yung Hyun;Chung, Kyung Tae;Lee, Jong Hwan;Kang, Kyung Hwa;Hyun, Sook Kyung;Kim, Byung Woo;Hwang, Hye Jin
    • Journal of Life Science
    • /
    • 제26권1호
    • /
    • pp.50-58
    • /
    • 2016
  • The root bark of Ulmus macrocarpa has been used in traditional medicine for the treatment of various diseases such as edema, infection and inflammation. Nevertheless, the biological activities and underlying mechanisms of the immunomodulatory effects remain unclear. In this study, as part of our ongoing screening program to evaluate the immunomodulatory potential of new compounds from traditional medicinal resources, we investigated the effects of U. macrocarpa water extract (UME) on immune modulation in a murine RAW 264.7 macrophage model. As immune response parameters, the productions of as nitric oxide (NO) and cytokines such tumor necrotic factor (TNF)-α, interleukin (IL)-1β and IL-10 were evaluated. Although the release of IL-1β remained unchanged in UME-treated RAW 264.7 macrophages, the productions of NO, TNF-α and IL-10 were significantly increased, along with the increased expression of inducible NO synthase, TNF-α and IL-10 expression at concentrations with no cytotoxicity. UME treatment also induced the nuclear translocation of nuclear factor κB (NF-κB), and phosphorylation of Akt and mitogen-activated protein kinases (MAPKs) indicating that UME activated macrophages through the activation of NF-κB, phosphoinositide-3-kinase (PI3K)/Akt and MAPKs signaling pathways in RAW 264.7 macrophages. Furthermore, pre-treatment with UME significantly attenuated the production of NO, but not TNF-α, IL-1β and IL-10, in lipopolysaccharide-stimulated RAW 264.7 cells suggesting that UME may be useful in preventing inflammatory diseases mediated by excessive production of NO. These findings suggest that the beneficial therapeutic effects of UME may be attributed partly to its ability to modulate immune functions in macrophages.

On-Line Determination Steady State in Simulation Output (시뮬레이션 출력의 안정상태 온라인 결정에 관한 연구)

  • 이영해;정창식;경규형
    • Proceedings of the Korea Society for Simulation Conference
    • /
    • 한국시뮬레이션학회 1996년도 춘계학술대회
    • /
    • pp.1-3
    • /
    • 1996
  • 시뮬레이션 기법을 이용한 시스템의 분석에 있어서 실험의 자동화는 현재 많은 연구와 개발이 진행 중인 분야이다. 컴퓨터와 정보통신 시스템에 대한 시뮬레이션의 예를 들어 보면, 수많은 모델을 대한 시뮬레이션을 수행할 경우 자동화된 실험의 제어가 요구되고 있다. 시뮬레이션 수행회수, 수행길이, 데이터 수집방법 등과 관련하여 시뮬레이션 실험방법이 자동화가 되지 않으면, 시뮬레이션 실험에 필요한 시간과 인적 자원이 상당히 커지게 되며 출력데이터에 대한 분석에 있어서도 어려움이 따르게 된다. 시뮬레이션 실험방법을 자동화하면서 효율적인 시뮬레이션 출력분석을 위해서는 시뮬레이션을 수행하는 경우에 항상 발생하는 초기편의 (initial bias)를 제거하는 문제가 선결되어야 한다. 시뮬레이션 출력분석에 사용되는 데이터들이 초기편의를 반영하지 않는 안정상태에서 수집된 것이어야만 실제 시스템에 대한 올바른 해석이 가능하다. 실제로 시뮬레이션 출력분석과 관련하여 가장 중요하면서도 어려운 문제는 시뮬레이션의 출력데이터가 이루는 추계적 과정 (stochastic process)의 안정상태 평균과 이 평균에 대한 신뢰구간(confidence interval: c. i.)을 구하는 것이다. 한 신뢰구간에 포함되어 있는 정보는 의사결정자에게 얼마나 정확하게 평균을 추정할 구 있는지 알려 준다. 그러나, 신뢰구간을 구성하는 일은 하나의 시뮬레이션으로부터 얻어진 출력데이터가 일반적으로 비정체상태(nonstationary)이고 자동상관(autocorrelated)되어 있기 때문에, 전통적인 통계적인 기법을 직접적으로 이용할 수 없다. 이러한 문제를 해결하기 위해 시뮬레이션 출력데이터 분석기법이 사용된다.본 논문에서는 초기편의를 제거하기 위해서 필요한 출력데이터의 제거시점을 찾는 새로운 기법으로, 유클리드 거리(Euclidean distance: ED)를 이용한 방법과 현재 패턴 분류(pattern classification) 문제에 널리 사용 중인 역전파 신경망(backpropagation neural networks: BNN) 알고리듬을 이용하는 방법을 제시한다. 이 기법들은 대다수의 기존의 기법과는 달리 시험수행(pilot run)이 필요 없으며, 시뮬레이션의 단일수행(single run) 중에 제거시점을 결정할 수 있다. 제거시점과 관련된 기존 연구는 다음과 같다. 콘웨이방법은 현재의 데이터가 이후 데이터의 최대값이나 최소값이 아니면 이 데이터를 제거시점으로 결정하는데, 알고기듬 구조상 온라인으로 제거시점 결정이 불가능하다. 콘웨이방법이 알고리듬의 성격상 온라인이 불가능한 반면, 수정콘웨이방법 (Modified Conway Rule: MCR)은 현재의 데이터가 이전 데이터와 비교했을 때 최대값이나 최소값이 아닌 경우 현재의 데이터를 제거시점으로 결정하기 때문에 온라인이 가능하다. 평균교차방법(Crossings-of-the-Mean Rule: CMR)은 누적평균을 이용하면서 이 평균을 중심으로 관측치가 위에서 아래로, 또는 아래서 위로 교차하는 회수로 결정한다. 이 기법을 사용하려면 교차회수를 결정해야 하는데, 일반적으로 결정된 교차회수가 시스템에 상관없이 일반적으로 적용가능하지 않다는 문제점이 있다. 누적평균방법(Cumulative-Mean Rule: CMR2)은 여러 번의 시험수행을 통해서 얻어진 출력데이터에 대한 총누적평균(grand cumulative mean)을 그래프로 그린 다음, 안정상태인 점을 육안으로 결정한다. 이 방법은 여러 번의 시뮬레이션을 수행에서 얻어진 데이터들의 평균들에 대한 누적평균을 사용하기 매문에 온라인 제거시점 결정이 불가능하며, 작업자가 그래프를 보고 임의로 결정해야 하는 단점이 있다. Welch방법(Welch's Method: WM)은 브라운 브리지(Brownian bridge) 통계량()을 사용하는데, n이 무한에 가까워질 때, 이 브라운 브리지 분포(Brownian bridge distribution)에 수렴하는 성질을 이용한다. 시뮬레이션 출력데이터를 가지고 배치를 구성한 후 하나의 배치를 표본으로 사용한다. 이 기법은 알고리듬이 복잡하고, 값을 추정해야 하는 단점이 있다. Law-Kelton방법(Law-Kelton's Method: LKM)은 회귀 (regression)이론에 기초하는데, 시뮬레이션이 종료된 후 누적평균데이터에 대해서 회귀직선을 적합(fitting)시킨다. 회귀직선의 기울기가 0이라는 귀무가설이 채택되면 그 시점을 제거시점으로 결정한다. 일단 시뮬레이션이 종료된 다음, 데이터가 모아진 순서의 반대 순서로 데이터를 이용하기 때문에 온라인이 불가능하다. Welch절차(Welch's Procedure: WP)는 5회이상의 시뮬레이션수행을 통해 수집한 데이터의 이동평균을 이용해서 시각적으로 제거시점을 결정해야 하며, 반복제거방법을 사용해야 하기 때문에 온라인 제거시점의 결정이 불가능하다. 또한, 한번에 이동할 데이터의 크기(window size)를 결정해야 한다. 지금까지 알아 본 것처럼, 기존의 방법들은 시뮬레이션의 단일 수행 중의 온라인 제거시점 결정의 관점에서는 미약한 면이 있다. 또한, 현재의 시뮬레이션 상용소프트웨어는 작업자로 하여금 제거시점을 임의로 결정하도록 하기 때문에, 실험중인 시스템에 대해서 정확하고도 정량적으로 제거시점을 결정할 수 없게 되어 있다. 사용자가 임의로 제거시점을 결정하게 되면, 초기편의 문제를 효과적으로 해결하기 어려울 뿐만 아니라, 필요 이상으로 너무 많은 양을 제거하거나 초기편의를 해결하지 못할 만큼 너무 적은 양을 제거할 가능성이 커지게 된다. 또한, 기존의 방법들의 대부분은 제거시점을 찾기 위해서 시험수행이 필요하다. 즉, 안정상태 시점만을 찾기 위한 시뮬레이션 수행이 필요하며, 이렇게 사용된 시뮬레이션은 출력분석에 사용되지 않기 때문에 시간적인 손실이 크게 된다.

  • PDF

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

  • Chang, Ji-Woong;Lee, Young-Koo;Whang, Kyu-Young;Yang, Jae-Heon
    • Journal of KIISE:Databases
    • /
    • 제28권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