• Title/Summary/Keyword: Time Average Method

Search Result 3,294, Processing Time 0.036 seconds

A Study On the Operating Room Nurses' Performances of Duties and Their Fatigue (수술실간호사의 직무수행과 피로에 관한 연구)

  • Park, Jeong Sook
    • Korean Journal of Occupational Health Nursing
    • /
    • v.6 no.2
    • /
    • pp.110-127
    • /
    • 1997
  • The aim of this study is to present the basic datum for the promotion of effectiveness and improvement of nursery tasks, by grasping the situation of operating room nurses tasks and the degree of their fatigue. For these researches, 70 nurses out of the operating rooms of 3 university-affiliated hospitals-two in Seoul and one in Pusan, were chosen at random by a non-probability sampling method. These researches were done from April 14 to April 26 in 1997 by questionairing method. The questionaire was composed of 30 items, which asks the examinees of their physical, mental, and neurosensory symptoms, with 10 items respectively. The reliability of the research instrument was turned out very high with Cronbach's ${\alpha}=.9376$. The datum were electronically processed using Statistics Program for Social Sciences(SPSS). The analysis of datum in this study has a general character, in which the demosociological character and the special ex-officio character was calculated by frequency and percentage. The situation of tasks in operating rooms was calculated by frequency and percentage. The fatigue of operating room nurses was calculated by average and standard deviation. To compare the fatigue with regard to the character of operating room nurse's tasks, t-test and F-test(ANOVA) were used after the character of variations, and the variations at the level of P<.05 which might have some meaning was verified after the fact with Duncan's Multiple Range(DMR). The results of this research are as follows : 1) The nurses working in operating rooms show their fatigue in three fields-in Group I physical symptoms 3.28, in Group III neurosensory symptoms 2.85, and in Group II mental symptoms 2.73, which shows I Dominant type (general type). 2) They complain, in Group I they are "feeling the heavy legs," 3.28 and in Group II they "occasionally forget soon what to do," 3.09. and in Group III, they "feel lumbago," 3.47, which is the highest rate of the three. The highest rate results from the character of their tasks, in which they have to move rapidly the heavy appliances and do their jobs standing many hours, especially wearing heavy radiation protector. 3) As to transportation, subway using group feel the greatest fatigue, 3.18(F=4.315, P=.008). 4) As to department, nurses in the orthopedic's surgery part feel the greatest fatigue, 3.26(F=2.040, P=.050). 5) As to the change of physical symptoms, the group answering that they found physical abnormality after working in operating rooms show the greatest fatigue, 3.12(t=-3.13, P=.003). 6) At to the general circumstances, the group answering that they receive insufficient consideration on their physical abnormality in their department, show the greatest fatigue, 3.10(F=3.200, P=0.47). 7) As to the relation with superior officers, the group answering that their superior officer has an impetuous temperament, show great fatigue, 3.11(F=4.855, P=.011). 8) As to the time of feeling fatigue, the fatigue reaches the highest point 1~2 hours after operations, 3.04(F=2.703, P=.046). 9) When they feel fatigue after scrub nurse duties, they feel the greatest fatigue 2 hours after the duties, 3.09( F=2.841, P=.038). 10) As to the operation instruments, when they use complex instruments borrowing from the outside in addition to the basic instruments, their fatigue becomes the greatest, 3.09(F=7.831, P=.000). 11) As to the kind of operation, when they participate in orthopedic's surgery operations, they feel the greatest fatigue, 3.18(F=4.362, P=.000). With the above results, it is proved that the degree of operating room nurses' fatigue is considerably high. So it may be concluded that the measure for lessening the fatigue should be find immediately, not on the level of personal matters but on the level of hospital nursing administration.

  • PDF

A Follow-up Study of Fertility and Pregnancy Wastage of Women in Rural Area (추적조사에 의한 농촌 여성의 출산력과 임신소모율)

  • Park, Jung-Han;Kim, Sin-Hyang;Chun, Byung-Yeol;Kim, Gui-Yeon;Yeh, Min-Hae;Cho, Seong-Eok;Cho, Jae-Yeon
    • Journal of Preventive Medicine and Public Health
    • /
    • v.21 no.1 s.23
    • /
    • pp.21-30
    • /
    • 1988
  • To measure the fertility rate and pregnancy wastage of women in rural area, 3,780 married women under 50 years old who were not sterilized either woman or husband in Gunwee county were followed up for 2 years. Seventeen Myun health workers visited these women periodically to check the status of their family planning practice and menstruation. Pregnant women were interviwed for their past obstetric history and followed up to the time of delivery. Family planning was practiced in 51.6% of the 6,826 women-years observed during the period from April 1, 1985 to March 31, 1987. Pregnancy, abortion and delivery covered 7.6% of the observed women-years and family planning was not practiced in 36.5% of the women-years. When sterilized women at the beginning of the study were included, the family planning practice rate was 72.1% which was slightly higher than the national family planning practice rate. However, 28% of the women of 30-39 years old had not practiced family planning although they had 2-3 children and they used more such less effective methods as safe-period method and condom than the women of 20-29 years old. Overall pregnancy rate was 14.3 per 100 woman-years. Women of 25-29 years old had the highest pregnancy rate of 27.4 per ,100 woman-years. Pregnancy wastage including spontaneous and induced abortions and still births was 22.0% of all pregnancies and it increased with the age of women; 15.8% in women less than 30 years old and 43.7% in women of 30 years and over. Women who terminated the pregnancy with induced abortion had more pregnancies, more previous induced and spontaneous abortions and shorter pregnancy interval than those women who terminated with live birth. Pregnant women terminated with a live birth had received 4.2 prenatal cares on the average. Eighty-five percent of deliveries occurred at a medical facility and 15% at home which was substantially lower home delivery rate than the other rural area of Korea. This may be due to the effects of the demonstration project for the primary health care in 1970s in Gunwee county. These findings suggest that family planning service in rural area should be strengthened by promoting the use of more effective contraceptive method among women over 30 years of age.

  • PDF

A Study on the Manufacture of the Artificial Cardiac Tissue Valve (생체판의 제작 및 실험)

  • Kim, Hyoung-Mook;Song, Yo-Jun;Sohn, Kwang-Hyun
    • Journal of Chest Surgery
    • /
    • v.12 no.4
    • /
    • pp.383-394
    • /
    • 1979
  • Treatment of valvular heart disease with valve replacement has been one of the most popular procedures in cardiac surgery recently. Although, first effort was directed toward the prosthetic valve, it soon became popular that bioprosthesis, the valvular xenograft, was prefered in the majority cases. Valvular xenograft has some superiority to the artificial prosthetic valve in some points of thromboembolism and hemolytic anemia, and it also has some inferiority of durability, immunologic reaction and resistance to Infection. Tremendous efforts were made to cover the inferiority with several methods of collection, preservation, and valve mounting of the porcine valve or pericardium of the calf, and also with surgical technique of the valvular xenograft replacement. Auther has collected 320 porcine aortic valves immediately after slaughter, and aortic cusps were coapted with cotton balls in the Valsalva sinuses to protect valve deformity after immersion in the Hanks' solution, and oxidation, cross-linking and reduction procedures were completed after the proposal of Carpentier in 1972. Well preserved aortic valves were suture mounted in the hand-made tissue valve frame of 19, 21, and 23 mm J.d., and also in the prosthetic vascular segment of 19 mm Ld. with 4-0 nylon sutures after careful trimming of the aortic valves. Completed valves were evaluated with bacteriologic culture, pressure tolerance test with tolerane gauge, valve durability test in the saline glycerine mixed solution with tolerance test machine in the speed of 300 rpm, and again with pathologic changes to obtain following results: 1. Bacteriologic culture of the valve tissue in five different preservation method for two weeks revealed excellent and satisfactory result in view of sterilization including 0.65% glutaraldehyde preservation group for one week bacteriologic culture except one tissue with Citobacter freundii in 75% ethanol preserved group. 2. Pressure tolerance test was done with an apparatus composed of V-connected manometer and pressure applicator. Tolerable limit of pressure was recorded when central leaking jet of saline was observed. Average pressure tolerated in each group was 168 mmHg in glutaraldehyde, 128 mmHg in formaldehyde, 92 mmHg in Dakin's solution, 48 mmHg in ethylene oxide gas, and 26 mmHg in ethanol preserved group in relation to the control group of Ringer's 90 mmHg respectively. 3. Prolonged durability test was performed in the group of frame mounted xenograft tissue valve with 300 up-and-down motion tolerance test machine/min. There were no specific valve deformity or wearing in both 19, 21, and 23 mm valves at the end of 3 months (actually 15 months), and another 3 months durability test revealed minimal valve leakage during pressure tolerance test due to contraction deformity of the non-coronary cusp at the end of 6 months (actually 30 months) in the largest 23 mm group. 4. Histopathologic observation was focussed in three view points, endothelial cell lining, collagen and elastic fiber destructions in each preservation methods and long durable valvular tolerance test group. Endothel ial cell lining and collagen fiber were well preserved in the glutaraldehyde and formaldehyde treated group with minimal destruction of elastic fiber. In long durable tolerance test group revealed complete destruction of the endothelial cell lining with minimal destruction of the collagen and elastic fiber in 3 month and 6 month group in relation to the time and severity. In conclusion, porcine xenograft treated after the proposal of Carpentier in 1972 and preserved in the glutaraldehyde solution was the best method of collection, preservation and valve mounting. Pressure tolerance and valve motion tolerance test, also, revealed most satisfactory results in the glutaraldehyde preserved group.

  • PDF

Strain Improvement and Bioprocess Optimization for Enhanced Production of Haluronic Acid(HA) in Bioreactor Cultures of Streptococcus zooepidemicus (히알루론산 생산성 향상을 위한 Streptococcus zooepidemicus 균주 개량 및 발효조 배양공정 최적화)

  • Kim, Soo Yeon;Chun, Gie-Taek
    • Microbiology and Biotechnology Letters
    • /
    • v.48 no.3
    • /
    • pp.344-357
    • /
    • 2020
  • Strain improvement and bioprocess development were undertaken to enhance hyaluronic acid(HA) production by Streptococcus zooepidemicus cells. Using a high-yielding mutant strain, statistical medium optimization was carried out in shake flask cultures, resulting in 52% increase in HA production (5.38 g/l) at the optimal medium composition relative to the parallel control cultures. For sufficient supply of dissolved oxygen (DO), which turned out to be crucial for enhanced production of HA, agitation system and speed were intensively investigated in 5 L bioreactor cultures. Increase in oxygen mass transfer coefficient (kLa) through increment of agitation speed (rpm) and 35% expansion of diameter of the newly-designed impellers showed significantly positive effects on HA production. By installing an expanded Rushton-turbine impeller for efficient break-down of sparged air, and an extended marine impeller above the Rushton-turbine impeller for efficient mixing of the air-born viscous fermentation broth, maximum amount of HA (9.79 g/l) was obtained at 450 rpm, 1.8 times higher level than that of the corresponding flask culture. Subsequently, the possibility of bioprocess scale-up to a 50 L bioreactor was investigated. Despite almost identical maximum HA production (9.11 vs 9.25 g/l), the average HA volumetric productivity (rp) of the 50 L culture turned out only 74% compared to the corresponding 5 L culture during the exponential phase, possibly caused by shear damages imposed on the producing cells at the high stirring in the 50 L culture. The scale-up process could be successfully achieved if a scale-up criterion of constant oxygen mass transfer coefficient (kLa) is applied to the 50 L pilot-scale bioreactor system.

Development of Movement Analysis Program and its Feasibility Test in Streotactic Body Radiation Threrapy (복부부위의 체부정위방사선치료시 호흡에 의한 움직임분석 프로그램 개발 및 유용성 평가)

  • Shin, Eun-Hyuk;Han, Young-Yih;Kim, Jin-Sung;Park, Hee-Chul;Shin, Jung-Suk;Ju, Sang-Gyu;Lee, Ji-Hea;Ahn, Jong-Ho;Lee, Jai-Ki;Choi, Doo-Ho
    • Progress in Medical Physics
    • /
    • v.22 no.3
    • /
    • pp.107-116
    • /
    • 2011
  • Respiratory gated radiation therapy and stereotactic body radiation therapy require identical tumor motions during each treatment with the motion detected in treatment planning CT. Therefore, this study developed a tumor motion monitoring and analysis system during the treatments employing RPM data, gated setup OBI images and a data analysis software. A respiratory training and guiding program which improves the regularity of breathing was used to patients. The breathing signal was obtained by RPM and the recorded data in the 4D console was read after treatment. The setup OBI images obtained gated at 0% and 50% of breathing phases were used to detect the tumor motion range in crenio-caudal direction. By matching the RPM data recorded at the OBI imaging time, a factor which converts the RPM motion to the tumor motion was computed. RPM data was entered to the institute developed data analysis software and the maximum, minimum, average of the breathing motion as well as the standard deviation of motion amplitude and period was computed. The computed result is exported in an excel file. The conversion factor was applied to the analyzed data to estimate the tumor motion. The accuracy of the developed method was tested by using a moving phantom, and the efficacy was evaluated for 10 stereotactic body radiation therapy patients. For the sine wave motion of the phantom with 4 sec of period and 2 cm of peak-to-peak amplitude, the measurement was slightly larger (4.052 sec) and the amplitude was smaller (1.952 cm). For patient treatment, one patient was evaluated not to qualified to SBRT due to the usability of the breathing, and in one patient case, the treatment was changed to respiratory gated treatment due the larger motion range of the tumor than treatment planed motion. The developed method and data analysis program was useful to estimate the tumor motion during treatment.

Distribution and Growth of Bacteria in the Hypertrophic Lake Shiwha (과영양성 시화호에서 박테리아의 분포 및 성장)

  • Choi, Dong-Han;Kang, Sulk-Won;Song, Ki-Don;Huh, Sung-Hoi;Cho, Byung-Cheol
    • The Sea:JOURNAL OF THE KOREAN SOCIETY OF OCEANOGRAPHY
    • /
    • v.2 no.2
    • /
    • pp.92-100
    • /
    • 1997
  • Distribution of bacterial abundance and production was investigated during October, 1995-August, 1996 in Lake Shiwha constructed artificially in 1994. Its water column was distinguished by two layers: the brackish surface layer with salinity ranged from 6 to 20‰ and the saline hypoxic/anoxic bottom layer with salinity of 17 to 27‰ Except for samples collected in March, 1996 (on average 13 ${\mu}g\;l^{-1}$), chlorophyll a concentration ranged from 27.6 to 249.5 ${\mu}g\;l^{-1}$ in the euphotic zone, indicating the hypertrophic condition of Lake Shiwha during most of the studied period. In this study, bacterial productions measured by $^3H$-thymidine incorporation method were similar to those by $^{14}C$-leucine incorporation method. In hypertrophic, surface waters of Lake Shiwha, bacterial abundance and production ranged from 1.4 to $19.5{\times}10^9\;cells\;l^{-1}$ and from 1.6 to $126.5{\times}10^7\;cells\;l^{-1}\;h^{-1}$ respectively; 2 to 4 fold and 2 to 30 fold higher than those in eutrophic coastal waters outside of Lake Shiwha, respectively. Turnover times of bacterial community in the surface layer of Lake Shiwha ranged from 0.2 to 8.9 day, indicating that bacteria in the lake seemed to adapt to the hypertrophic condition. In the hypoxic bottom layer, bacterial abundance and production was up to 3 fold and 20 fold lower than those in the surface layer, and showed slow bacterial growth. Significant correlations between the bacterial abundance, production, and community turnover time with water temperature indicate water temperature was the important factor controlling distribution and growth of bacteria. However, during summer season, bacterial production seemed to be regulated by supply of substrates.

  • PDF

Studies on the Processing and Management Forms of Filatures (우리나라 제사공장의 공정 관리실태에 관한 조사연구)

  • 송기언;이인전
    • Journal of Sericultural and Entomological Science
    • /
    • no.12
    • /
    • pp.37-45
    • /
    • 1970
  • The processing management forms of our country's filature factories in 1969 are summarized as follows. (1) About 80% of total cocoon collection is made within 5 days involving peak day, and 10% of cocoon collection is finished until 3 days before and after the peak day, (2) About 92% of alive cocoons transported on unpaved road, and about 40% of the cocoons purchased by all factories are loaded on trucks from common selling station which is far beyond 40km, therefore a new packing system of alive cocoons to drop the damage of cocoon qualities, should be taken. (3) 22% of all factories in our. country have only low-temperature cocoon drying machine. Therefore the installment of hot-air cocoon drying machine is required urgently. (4) In view of cocoon qualities in our country, the grouping method of cocoon for reeling. taken by about 50% of the factories at percent, which classify cocoons for reeling as high group (1,2,3,4 grades) and low group(5,6 grades), will have to be replaced by the method tat classify them high group (1,2 grades) middle group (3,4 grades), low group (5,6 grades). (5) The .ratio of cocoon assorting stood about 10% in multi-ends reeling, about 15% in automatic reeling, conclusively, the ratio of cocoon assorting for automatic reeling was higher tan that for multi-ends reeling. One person's ability for a day in cocoon assorting reaches to about 80-100kg. (6) Cocoon cooking condition requires the increase of the cooking time, the pressure and temperature used to be prolonged as much as the qualities of cocoons are material cocoon ior automatic and double cocoon machines are treated uncompletely. (7) Automatic silk reeling is being performed at 1-2$^{\circ}C$ lower in reeling water temperature and operated at about twice velocity. (8) The temperature and humidity of rereeling room stood at 25$^{\circ}C$, 67.2% R.H and 32.3$^{\circ}C$, 51.9% R.H of rereeling machine are showed, Average rereeling velocity is 233m/min and large reefs charged for one person are 7.5 reels and form of skein used in all factories is double skein. (9) About 73% of water sources for filature used under-earth water. About 48% of all filature factories in our country have not yet water purifying equipments. Installation of the equipment for these factories seems to be urgent, (10) Denier .balance, sizing reel, seriplane, are being used in most factories as self-inspection apparatus. (11) More than 90% of the factories use the vacum tank in rereeling process and about 20% of them use it in cocoon cooing process (12) Only 21% of the factories use chemicals in filature process. About all them use "Seracol 100" in cocoon cooking process and "Seracol 500" in rereeling process, (13) Above survey results explain each all factories show large difference in the processing management. Therefore, it is believed that intercommunication through seminar or technical exchange will contribute to the production evaluation of cocoon in our filature industry.

  • PDF

Studies on the Changes of Sex Hormone Concentrations in Milk during the Reproductive Stages of Dairy Cows (유우의 번식과정에 따른 유즙중의 성호르몬 수준 변화에 관한 연구)

  • 김상근;이재근
    • Korean Journal of Animal Reproduction
    • /
    • v.9 no.1
    • /
    • pp.9-30
    • /
    • 1985
  • The study was carried out to find out the changes of the sex hormone levels in the milk of Holstein cows during the reproductive stages such as the estrous cycle, pregnancy and periparturient period. The FSH, LH, estradiol-17$\beta$ and progesterone from the milk samples were assayed by radioimmunoassay methods. The results of this study were summarized as follows: 1. The levels of progesterone and estradiol-17$\beta$ were similar among inter-quarters, but they were higher in after milking than before milking times, with no statistical significance. 2. The milk progesterone levels during the estrous cycles reached a peak mean level of 3.55$\pm$0.26ng/$m\ell$ at 15 days after estrus and they did not show any differences among the length of estrous cycles. The estradiol-17$\beta$ levels during the estrous cycles showed a peak level of 36.40$\pm$2.38pg/$m\ell$ at estrus, and decreased(17.20$\pm$0.46 pg/$m\ell$ to 18.65$\pm$1.26pg/$m\ell$) at luteal phase. 3. The FSH levels during the estrous cycles ranged from 2.25$\pm$0.23mIU/$m\ell$ to 4.35$\pm$0.24mIU/$m\ell$ showing significant changes. The LH levels during the estrous cycles gradually increased and remained a peak level of 10.90$\pm$0.36mIU/$m\ell$ from 20 to 25 days after estrus. 4. The progesterone levels during the pregnancy were decreased from 30 to 60 days after artificial insemination, and therafter continuously increased until 240 days. The estradiol-17$\beta$ levels during the pregnancy were 24.56$\pm$1.19pg/$m\ell$ at day 30 after artificial inseminaton, and increased rapidly until 180 days. The levles were agagin decreased by 26.17$\pm$3.03pg/$m\ell$ until 210 days and markedly increased by 68.00$\pm$8.70pg/$m\ell$ until 240 days. 5. The prolactin levels during the pregnancy were 31.27$\pm$2.31ng/$m\ell$ and 42.60$\pm$2.37ng/$m\ell$ at day 150 and 240 after artificial insemination respectively. The LH levels during the pregnancy reached a peak of 27.47$\pm$7.90mIU/$m\ell$ at day 30 after artificial insemination, and thereafter gradually decreased. 6. The progesterone levels during the periparturient period reached a peak of 4.61$\pm$0.34ng/$m\ell$ at day 3 prepartum, and thereafter gradually decreased, and showed 2.05$\pm$0.60ng/$m\ell$ at day 7 postpartum. The estradiol-17$\beta$ levels during the periparturient period showed high level from 207.23$\pm$6.04pg/$m\ell$ at day 1 prepartum to 239.90$\pm$13.90pg/$m\ell$ at day 2 prepartum, and thereafter began to decline and reached 51.87$\pm$1.72pg/$m\ell$ at by 7 postpartum. 7. The prolactin levels during the periparturient period showed relatively higher level at the time of parturition. The LH levels during the periparturient period rnage from 6.32$\pm$0.32mIU/$m\ell$ to 13.90$\pm$1.37mIU/$m\ell$ showing significant changes. 8. The progesterone levels(4.6$\pm$0.8ng/$m\ell$) of the pregnant cows were significantly higher than those (1.84$\pm$1.4ng/$m\ell$) of nonpregnant cows. The cows of artificial insemination from 61 to 90 days after parturition showed higher progesterone levels. 9. During 20 to 25 days after artificial insemination, the accuracy of pregnancy diagnosis from milk progesterone levels were 94.4% for nonpregnant cows(<2.3ng/$m\ell$), and 75.0% for pregnant cows( 3.2ng/$m\ell$). The average overall accuracy of pregnancy prediction for nonpregnant and pregnant cows 83.3% 10. The results obtained this study suggest that the understanding of the endocrinological mechanisms by means of milk hormone analysis during the estrous cycle, pregnancy and parturition would give the basic information needed for increasing efficiency of reproduction. This study would not only provide an accurate method of the early pregnancy diagnosis by milk progesterone levels but also contribute to the research of providing the method of detecting of FSH levels in milk, which was difficult in blood serum.

  • PDF

Experimental Comparison and Analysis of Measurement Results Using Various Flow Meters (유량측정 기기별 측정성과에 대한 실험적 비교분석)

  • Lee, Jae-Hyug;Lee, Suk-Ho;Jung, Sung-Won;Kim, Tae-Woong
    • Journal of Wetlands Research
    • /
    • v.12 no.1
    • /
    • pp.95-103
    • /
    • 2010
  • Discharge data examine the process of hydrologic cycle and used significantly in water resource planning and irrigation and flood control planning. However, it needs lots of time and money to get the discharge data. So discharge rating curve is usually used in converting discharge data. Therefore reliability of discharge rating curve absolutely depends on quality of discharge data. Many engineers who study hydrologic engineering make high quality discharge data to develop reliable discharge rating curve. And they carry out research on standard and method of discharge measurement, and equipment improvement. Now various flow meters are utilized to make discharge data in Korea. However, accuracy of equipment and experimental research data from measurement are not enough. In this paper, constant discharge flowed through standard concrete channel, and the velocity is measured using various flow meters. Also Discharge is calculated by measured data to compare and analyze. The equipment for the experiment is Price AA(USGS Type AA Current meter), flow meter, ADC, C2 small current meter, flow tracker, Electromagnetic current meter. The discharge got form various flow meters which are widely used for discharge measurement. The various depths of water were examined and compared such as 0.30 m, 0.35 m, 0.40 m, 0.45 m, 0.50 m, 0.55 m. The experiment progresses a round-measurement on 6-case. Wading measurement(one point method : the 60 % height in surface of the water) was applied to improve creditability and accuracy among measurement methods. USGS Type AA current Meter, Flow Meter, ADC, C2 Small Current meter got the certificate of quality guaranteed. So the results of experiment were used to compare discharge. The Results showed the difference based on USGS Type AA current Meter at average discharge and velocity. Electromagnetic current meter made differences over $\pm$ 10 % and Flow Meter made differences under $\pm$ 10 %. Also ADC, Flow Meter, C2 Small Current meter made differences under $\pm$ 5 %.

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