• 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.

• Journal of the Korean Society of Food Science and Nutrition
• /
• v.45 no.1
• /
• pp.52-60
• /
• 2016

The biological activity of polysaccharide is greatly influenced by polysaccharide structure and molecular distribution. Here, we developed a rapid and convenient isolation method for fractionating polysaccharides with different characteristics and optimized it using a polysaccharide mixture from Korean persimmon leaves. A crude polysaccharide mixture, persimmon leaves-enzyme (PLE) fraction, was isolated from persimmon leaves digested with pectinase and ethanol precipitation. The PLE fraction was further fractionated with a serially diluted ethanol solution (ethanol : deionized water=4:1, 2:1, 1.5:1, 1:1, and 0.5:1) to produce 10 subfractions (five precipitate fractions labeled from PLE-4 to PLE-0.5 and five supernatant fractions labeled from PLE-4S to PLE-0.5S). HPLC analysis indicated that PLE-4 and -2 consisted of diverse polysaccharides, whereas PLE-1.5, -1, and -0.5 contained high molecular weight (MW) polysaccharides. The fractions from PLE-4 to PLE-1 were mostly composed of 13 different characteristic sugars in rhamnogalacturonan (RG) I and II, and the sugars contained an arabino-${\beta}$-3,6-galactan moiety. However, PLE-0.5 did not contain RG-II or ${\beta}$-arabino-3,6-galactan. Treatment of macrophages with fractions PLE-1.5S and PLE-1S led to a $10{\mu}g/mL$ increase in interleukin (IL)-6 production, whereas treatment with PLE-4S and PLE-2S fractions composed of low MW polysaccharides resulted in reduced levels of IL-6. These results indicate that this isolation method may be useful for the rapid and convenient fractionation of bioactive RGs from polysaccharide mixtures with various properties.

• Analytical Science and Technology
• /
• v.9 no.4
• /
• pp.364-372
• /
• 1996

The sorption and desorption properties of U(VI), Th(IV), Zr(IV), Cu(II), Pb(II), Ni(II), Zn(II), Cd(II) and Mn(II) ions on XAD-16-[2-(2-thiazolylazo)-p-cresol](TAC) chelating resin were studied by elution method for selective separation, concentration and recovery of trace metal ions in sea water. The optimum conditions for the sorption of metal ions were examined with respect to flow rate, pH and concentration of buffer solution. The overall capacities of some metal ions on this chelating resin were 0.41mmol U(VI)/g resin, 0.55mmol Th(IV)/g resin, 0.43mmol Cu(II)/g resin, and 0.32mmol Zr(IV)/g resin, respectively. The elution order of metal ions obtained from breakthrough capacity and overall capacity at pH 5.0 was found as Th(IV)>Cu(II)>U(VI)>Zr(IV)>Pb(II)>Ni(II)>Zn(II)>Cd(II)>Mn(II). Desorption of characteristics for metal ions were investigated with desorption agents such as $HNO_3$, HCl, $HClO_4$, $H_2SO_4$, and $Na_2CO_3$. It was found that most of metal ions except Zr(IV) showed high desorption efficiency with 2M $HNO_3$. But, desorption and recovery of Zr(IV) ion were successfully performed with 1M $H_2SO_4$. The resin was applied for separation and preconcentration of trace amount of U(VI) ion from artificial sea water and the recovery of U(IV) was over 96%.

• The Journal of Korean Institute of Communications and Information Sciences
• /
• v.28 no.6C
• /
• pp.648-658
• /
• 2003

As the usage of image/video contents increase, a security problem for the payed image data or the ones requiring confidentiality is raised. This paper proposed an image encryption methodology to hide the image information. The target data of it is the result from quantization in wavelet domain. This method encrypts only part of the image data rather than the whole data of the original image, in which three types of data selection methodologies were involved. First, by using the fact that the wavelet transform decomposes the original image into frequency sub-bands, only some of the frequency sub-bands were included in encryption to make the resulting image unrecognizable. In the data to represent each pixel, only MSBs were taken for encryption. Finally, pixels to be encrypted in a specific sub-band were selected randomly by using LFSR(Linear Feedback Shift Register). Part of the key for encryption was used for the seed value of LFSR and in selecting the parallel output bits of the LFSR for random selection so that the strength of encryption algorithm increased. The experiments have been performed with the proposed methods implemented in software for about 500 images, from which the result showed that only about 1/1000 amount of data to the original image can obtain the encryption effect not to recognize the original image. Consequently, we are sure that the proposed are efficient image encryption methods to acquire the high encryption effect with small amount of encryption. Also, in this paper, several encryption scheme according to the selection of the sub-bands and the number of bits from LFSR outputs for pixel selection have been proposed, and it has been shown that there exits a relation of trade-off between the execution time and the effect of the encryption. It means that the proposed methods can be selectively used according to the application areas. Also, because the proposed methods are performed in the application layer, they are expected to be a good solution for the end-to-end security problem, which is appearing as one of the important problems in the networks with both wired and wireless sections.

• Journal of Food Hygiene and Safety
• /
• v.35 no.4
• /
• pp.382-390
• /
• 2020

This study was carried out to evaluate the antimicrobial effect of red ginseng (Panax ginseng C.A. Meyer) against several foodborne pathogens including Staphylococcus aureus, Escherichia coli, Candida albicans and Aspergillus niger. The antimicrobial effect was determined by agar diffusion method using red ginseng extract, crude saponin and non-water-soluble fractions. Red ginseng extract showed antimicrobial effect against S. aureus, but not C. albicans or A. niger. The extract showed anti-bacterial activity at concentration above 30% against S. aureus, which cause both food poisoning and atophic dermatitis. Crude saponin showed antibacterial activity above 7.5% against the bacterium. However, the ginsenosides purified from crude saponin showed no antimicrobial activities at 100-200 ㎍/mL. To investigate the mode of growth inhibition, red ginseng extract and crude saponin were added to 0.85% NaCl solution containing S. aureus and then incubated at 35℃ for 12 h. The results showed that viable cells were rapidly reduced in above 10% concentration of red ginseng extract and above 2% of crude saponin, respectively. However, the crude saponin and red ginseng extract did not inhibit the bacterial cells completely at those same concentrations. On the other hand, whereas all non-water-soluble fractions showed inhibition zones above 10 mm against S. aureus, they showed no inhibition effects against E. coli, C. albicans or A. niger. The methanol fraction-1 (MF-1) showed the highest antibacterial activity against S. aureus, and the MIC (minimal inhibitory concentration) was 0.625 mg/mL. These results suggest that red ginseng extract, crude saponin and non-water-soluble fractions show selective antibacterial activity against S. aureus, and non-water-soluble fractions might be used as natural antibacterial agents.

• Journal of the Korean Orthopaedic Association
• /
• v.53 no.6
• /
• pp.513-521
• /
• 2018

Purpose: The purpose of this study was to assess the effectiveness and complications of an ultrasound-guided axillary brachial plexus block performed by orthopedic surgeons. Materials and Methods: From March to May 2017, an ultrasound-guided axillary brachial plexus block was performed on a total of 103 cases of surgery. A VF13-5 transducer from Siemens Acuson X300 was used. The surgical site was included in the range of the anatomic sensory distribution of the blocked nerve, except for the case where an operation time of more than 2 hours was expected due to multiple injuries and the operation of the upper arm. The procedure was performed by 2 orthopedic surgeons in the same method using 50 ml of solution (20 ml of lidocaine HCl in 2%, 20 ml of ropivacaine in 0.75%, 10 ml of normal saline in 0.9%). The success rate of anesthesia induction during surgery, anesthetic induction time, anatomical range of operation, duration of postoperative analgesia and complications were investigated. Results: The results from the 2 practices were similar. The anesthesia was successful in 100 out of 103 patients (97.1%). In these patients, the average needling time was 5.5 minutes (2.5-13.2 minutes), the average induction time to complete anesthesia was 18.4 minutes (5-40 minutes), and the average duration of postoperative analgesia was 402.8 minutes (141-540 minutes). The post-anesthesia immediate complications were dizziness in 1 case, nausea and vomiting in 4 cases, and peri-oral numbness in 2 cases, but surgery was performed without problems. All these 7 cases with complications recovered on the same day. A total of 3 cases failed with anesthesia, and they were treated by an injection with local anesthesia in the operation room in 2 cases and switched to general anesthesia in 1 case. Conclusion: An ultrasound-guided axillary brachial plexus block, which was performed by orthopedic surgeons allows anesthesia in a brief period and the high success rates of anesthesia for certain surgeries of the elbow and surgeries on forearm, wrist and hand. Therefore, it can reduce the waiting time to the operating room. This technique is a relatively safe procedure and dose selective anesthesia is possible.