• Title/Summary/Keyword: Limited resources

Search Result 2,473, Processing Time 0.034 seconds

Studies on the Physico-Chemical Characteristics of Different Casing Materials Affecting Mycelial Growth and Yield of Cultivated Mushroom, Agaricus bisporus (Lange) Sing. (양송이의 균사생장(菌絲生長) 및 자실체(子寶體) 수량(收量)에 미치는 복토재료(覆土材料)의 이화학적(理化學的) 성질(性質)에 관(關)한 연구(硏究))

  • Kim, Dong-Soo
    • The Korean Journal of Mycology
    • /
    • v.3 no.1
    • /
    • pp.1-19
    • /
    • 1975
  • Since the importance of casing in fruit body formation of Agaricus bisporus has been emphasized, physico-chemical characteristics of casing materials were discussed by many workers and a mixture of peat and mineral soil as proper casing material has been adopted in many of mushroom growing countries. Because of limited resources of peat in Korea, it is necessary to find practical performance and substitutional materials for casing. The effect of casing on mycelial growth and mushroom yield of A. bisporus varied with materials, its combination and practices etc. The experiments to be discussed in this paper are concerned with pH and Ca of casing material which influence A bisporus, and changes of physico-chemical characteristics with mixing ratio of casing materials and its effect on A. bisporus. The optimum range of moisture content of each material, management of watering and application of physico-chemical characteristics casing materials was also investigated and re-use of weathered spent compost for casing material was described. 1. The effect of calcium on mycelial growth of A. bisporus at various pH in Halbschalentest showed different results with calcium sources. Best results were obtained around neutrality and fresh weight of fruit bodies grown in the range of pH 7 to 8 was highest among the tested levels. 2. Available moisture, pore space, organic matter, cation exchangeable capacity and exchangeable cation was increased by an increase of mixing ratio of peat in casing materials, while an adverse effect was obtained by addition of sand. 3. Mycelial growth on clay loam was more rapid at a lower bulk density of 0.75g/cc and at 20% moisture content on a dry weight basis at the same bulk density. 4. Mixing ratio of casing materials, 60 to 80 per cent by volume of peat mixed with 20 to 40 per cent of clay loam produced the highest yield of fresh fruit bodies and sand the lowest. However, per cent of open cap was highest in peat and lowest in sand. 5. Days required for fruit body initiation was shortened in mixtures of peat and clay loam by one to three days compared with other materials and the formation of flushes was clear. 6. The effect of some physico-chemical characteristics of casing materials on the fresh weight of fruit bodies were estimated by a multiple regression equation; Y=-923.86+$8.18X_1+8.04X_2+7.90X_3+0.12X_4+2.03X_5-0.82X_6-0.54X_7$ where $X_1,X_2,X_3,X_4,X_5,X_6,X_7$ are sand, silt, clay, available moistuer, porosity, organic matter and exchangeable cation respectively. The productivity of certain casing material could be predicted from this equation. 7. Fresh weight of fruit bodies was positively correlated with porosity exchangeable cation, organic matter, available moisture, silt and clay of materials; while sand was negatively correlated. On the contrary, sand was the unique factor reducing per cent of open cap. 8. Distribution of three phases of high productive casing material was concentrated in the range of 10 to 30 per cent solids, 15 to 30 per cent liquids, and 50 to 60 per cent in air volume. 9. Fresh weight of fruit bodies from peat was not affected with heavy watering but in clay loam and sandy loam severe crop losses occurred. Fresh weight of individual fruit was increased and open caps were decreased with heavy watering but light watering resulted in adverse effects: its effect was especially great in peat. 10. Optimum range of moisture content by weight on a dry basis was different with each casing material. To maintain optimum moisture content concerned with yield of fruit bodies and open cap, sandy loam and peat mixtures required daily watering of 0.6, 0.6 to 1. 2 and 1.2 to 2.4 liters per $3.3m^2$ of bed area, respectively. 11. Maximum yield of fruit body was recorded in the range of pF 2. 0 to 2. 5 of casing materials if organic matter content was below 4.2 per cent and in pF 1. 3 to 1.8 if above 7.1%. 12. pF curve of a certain casing material could be draws from moisture content at various pF values by multiple regression equations provided texture, organic matter and calcium of the casing material are given. Optimum moisture range of the casing materials also could be estimated by the equation. 13. It was possible to improve the phyico-chemical characteristics of clay loam and sandy loam by addition of weathered spent compost although the effect was less than in the case of peat. Fresh weight of fruit bodies wsa increased by addition of weathered spent compost but its effect was not as remarkable as peat. Accordingly, further studies will be required.

  • PDF

The Pulation Structure of the Pacific Cod (Gadus macrocephalus Tilesius) Based on Mitochondrial DNA Sequences (미토콘드리아 유전자 염기서열 분석에 의한 대구 계군 분석)

  • Seo, Young-Il;Kim, Joo-Il;Oh, Taeg-Yun;Lee, Sun-Kil;Park, Jong-Hwa;Kim, Hee-Yong;Cho, Eun-Seob
    • Journal of Life Science
    • /
    • v.20 no.3
    • /
    • pp.336-344
    • /
    • 2010
  • To assess population structure and genetic diversity among the Pacific cod (Gadus macrocephalus), we investigated mtDNA COI gene sequences of 7 populations. Samples were obtained from Sokcho, Wolsung, Geojedo, Yeosu, Geomundo and Westsouth in 2008 and 2009 (n=28). The sequence analysis of 28 individual samples showed 8 haplotypes, ranging in sequence divergence by pairwise comparisons from 0.2 to 2.2% (1 bp-11 bp). The Gal haplotype was found in Wolsung, Geojedo, Yeosu, Geomundo and Westsouth, and was regarded as the main haplotype of Korean Pacific cod. Ga2, Ga3, Ga6 and Ga7 haplotypes were found only in Sokcho. In the PHYLIP analysis, 8 haplotypes formed two independent groups: cladeA consisted of Ga2, Ga3, Ga6 and Ga7 haplotypes, whereas cladeB contained Gal, Ga4, Ga5 and Ga8 haplotypes. The genetic relationship between the two groups was weakly supported by bootstrap analysis(<50%). In pairwise comparisons between 6 populations other than that from Sokcho, a very high per generation migration ratio ($N_m$=infinite) and a very low level of geographic distance ($F_{sr}=-0.0123-(-0.0423)$) were observed. The estimates of genetic distance between Sokcho and the other localities were all statistically significant (p<0.05, p<0.01, p<0.001), indicating a limited mtDNA-based gene flow between Sokcho and other regions. The finding of the lowest genetic diversity in the Sokcho population (nucleotide diversity=0.00589) may be a result of relatively small population size and interrupted gene flow to other localities. Consequently, the overall considerable migration of Pacific cod population in Korea caused a genetically homogeneous structure to form, although a distinct population was found in this study.

Risk Assessment of Pine Tree Dieback in Sogwang-Ri, Uljin (울진 소광리 금강소나무 고사발생 특성 분석 및 위험지역 평가)

  • Kim, Eun-Sook;Lee, Bora;Kim, Jaebeom;Cho, Nanghyun;Lim, Jong-Hwan
    • Journal of Korean Society of Forest Science
    • /
    • v.109 no.3
    • /
    • pp.259-270
    • /
    • 2020
  • Extreme weather events, such as heat and drought, have occurred frequently over the past two decades. This has led to continuous reports of cases of forest damage due to physiological stress, not pest damage. In 2014, pine trees were collectively damaged in the forest genetic resources reserve of Sogwang-ri, Uljin, South Korea. An investigation was launched to determine the causes of the dieback, so that a forest management plan could be prepared to deal with the current dieback, and to prevent future damage. This study aimedto 1) understand the topographic and structural characteristics of the area which experienced pine tree dieback, 2) identify the main causes of the dieback, and 3) predict future risk areas through the use of machine-learning techniques. A model for identifying risk areas was developed using 14 explanatory variables, including location, elevation, slope, and age class. When three machine-learning techniques-Decision Tree, Random Forest (RF), and Support Vector Machine (SVM) were applied to the model, RF and SVM showed higher predictability scores, with accuracies over 93%. Our analysis of the variable set showed that the topographical areas most vulnerable to pine dieback were those with high altitudes, high daily solar radiation, and limited water availability. We also found that, when it came to forest stand characteristics, pine trees with high vertical stand densities (5-15 m high) and higher age classes experienced a higher risk of dieback. The RF and SVM models predicted that 9.5% or 115 ha of the Geumgang Pine Forest are at high risk for pine dieback. Our study suggests the need for further investigation into the vulnerable areas of the Geumgang Pine Forest, and also for climate change adaptive forest management steps to protect those areas which remain undamaged.

A Study on the Intelligent Service Selection Reasoning for Enhanced User Satisfaction : Appliance to Cloud Computing Service (사용자 만족도 향상을 위한 지능형 서비스 선정 방안에 관한 연구 : 클라우드 컴퓨팅 서비스에의 적용)

  • Shin, Dong Cheon
    • Journal of Intelligence and Information Systems
    • /
    • v.18 no.3
    • /
    • pp.35-51
    • /
    • 2012
  • Cloud computing is internet-based computing where computing resources are offered over the Internet as scalable and on-demand services. In particular, in case a number of various cloud services emerge in accordance with development of internet and mobile technology, to select and provide services with which service users satisfy is one of the important issues. Most of previous works show the limitation in the degree of user satisfaction because they are based on so called concept similarity in relation to user requirements or are lack of versatility of user preferences. This paper presents cloud service selection reasoning which can be applied to the general cloud service environments including a variety of computing resource services, not limited to web services. In relation to the service environments, there are two kinds of services: atomic service and composite service. An atomic service consists of service attributes which represent the characteristics of service such as functionality, performance, or specification. A composite service can be created by composition of atomic services and other composite services. Therefore, a composite service inherits attributes of component services. On the other hand, the main participants in providing with cloud services are service users, service suppliers, and service operators. Service suppliers can register services autonomously or in accordance with the strategic collaboration with service operators. Service users submit request queries including service name and requirements to the service management system. The service management system consists of a query processor for processing user queries, a registration manager for service registration, and a selection engine for service selection reasoning. In order to enhance the degree of user satisfaction, our reasoning stands on basis of the degree of conformance to user requirements of service attributes in terms of functionality, performance, and specification of service attributes, instead of concept similarity as in ontology-based reasoning. For this we introduce so called a service attribute graph (SAG) which is generated by considering the inclusion relationship among instances of a service attribute from several perspectives like functionality, performance, and specification. Hence, SAG is a directed graph which shows the inclusion relationships among attribute instances. Since the degree of conformance is very close to the inclusion relationship, we can say the acceptability of services depends on the closeness of inclusion relationship among corresponding attribute instances. That is, the high closeness implies the high acceptability because the degree of closeness reflects the degree of conformance among attributes instances. The degree of closeness is proportional to the path length between two vertex in SAG. The shorter path length means more close inclusion relationship than longer path length, which implies the higher degree of conformance. In addition to acceptability, in this paper, other user preferences such as priority for attributes and mandatary options are reflected for the variety of user requirements. Furthermore, to consider various types of attribute like character, number, and boolean also helps to support the variety of user requirements. Finally, according to service value to price cloud services are rated and recommended to users. One of the significances of this paper is the first try to present a graph-based selection reasoning unlike other works, while considering various user preferences in relation with service attributes.

Learning Material Bookmarking Service based on Collective Intelligence (집단지성 기반 학습자료 북마킹 서비스 시스템)

  • Jang, Jincheul;Jung, Sukhwan;Lee, Seulki;Jung, Chihoon;Yoon, Wan Chul;Yi, Mun Yong
    • Journal of Intelligence and Information Systems
    • /
    • v.20 no.2
    • /
    • pp.179-192
    • /
    • 2014
  • Keeping in line with the recent changes in the information technology environment, the online learning environment that supports multiple users' participation such as MOOC (Massive Open Online Courses) has become important. One of the largest professional associations in Information Technology, IEEE Computer Society, announced that "Supporting New Learning Styles" is a crucial trend in 2014. Popular MOOC services, CourseRa and edX, have continued to build active learning environment with a large number of lectures accessible anywhere using smart devices, and have been used by an increasing number of users. In addition, collaborative web services (e.g., blogs and Wikipedia) also support the creation of various user-uploaded learning materials, resulting in a vast amount of new lectures and learning materials being created every day in the online space. However, it is difficult for an online educational system to keep a learner' motivation as learning occurs remotely, with limited capability to share knowledge among the learners. Thus, it is essential to understand which materials are needed for each learner and how to motivate learners to actively participate in online learning system. To overcome these issues, leveraging the constructivism theory and collective intelligence, we have developed a social bookmarking system called WeStudy, which supports learning material sharing among the users and provides personalized learning material recommendations. Constructivism theory argues that knowledge is being constructed while learners interact with the world. Collective intelligence can be separated into two types: (1) collaborative collective intelligence, which can be built on the basis of direct collaboration among the participants (e.g., Wikipedia), and (2) integrative collective intelligence, which produces new forms of knowledge by combining independent and distributed information through highly advanced technologies and algorithms (e.g., Google PageRank, Recommender systems). Recommender system, one of the examples of integrative collective intelligence, is to utilize online activities of the users and recommend what users may be interested in. Our system included both collaborative collective intelligence functions and integrative collective intelligence functions. We analyzed well-known Web services based on collective intelligence such as Wikipedia, Slideshare, and Videolectures to identify main design factors that support collective intelligence. Based on this analysis, in addition to sharing online resources through social bookmarking, we selected three essential functions for our system: 1) multimodal visualization of learning materials through two forms (e.g., list and graph), 2) personalized recommendation of learning materials, and 3) explicit designation of learners of their interest. After developing web-based WeStudy system, we conducted usability testing through the heuristic evaluation method that included seven heuristic indices: features and functionality, cognitive page, navigation, search and filtering, control and feedback, forms, context and text. We recruited 10 experts who majored in Human Computer Interaction and worked in the same field, and requested both quantitative and qualitative evaluation of the system. The evaluation results show that, relative to the other functions evaluated, the list/graph page produced higher scores on all indices except for contexts & text. In case of contexts & text, learning material page produced the best score, compared with the other functions. In general, the explicit designation of learners of their interests, one of the distinctive functions, received lower scores on all usability indices because of its unfamiliar functionality to the users. In summary, the evaluation results show that our system has achieved high usability with good performance with some minor issues, which need to be fully addressed before the public release of the system to large-scale users. The study findings provide practical guidelines for the design and development of various systems that utilize collective intelligence.

Intents of Acquisitions in Information Technology Industrie (정보기술 산업에서의 인수 유형별 인수 의도 분석)

  • Cho, Wooje;Chang, Young Bong;Kwon, Youngok
    • Journal of Intelligence and Information Systems
    • /
    • v.22 no.4
    • /
    • pp.123-138
    • /
    • 2016
  • This study investigates intents of acquisitions in information technology industries. Mergers and acquisitions are a strategic decision at corporate-level and have been an important tool for a firm to grow. Plenty of firms in information technology industries have acquired startups to increase production efficiency, expand customer base, or improve quality over the last decades. For example, Google has made about 200 acquisitions since 2001, Cisco has acquired about 210 firms since 1993, Oracle has made about 125 acquisitions since 1994, and Microsoft has acquired about 200 firms since 1987. Although there have been many existing papers that theoretically study intents or motivations of acquisitions, there are limited papers that empirically investigate them mainly because it is challenging to measure and quantify intents of M&As. This study examines the intent of acquisitions by measuring specific intents for M&A transactions. Using our measures of acquisition intents, we compare the intents by four acquisition types: (1) the acquisition where a hardware firm acquires a hardware firm, (2) the acquisition where a hardware firm acquires a software/IT service firm, (3) the acquisition where a software/IT service firm acquires a hardware firm, and (4) the acquisition where a software /IT service firm acquires a software/IT service firm. We presume that there are difference in reasons why a hardware firm acquires another hardware firm, why a hardware firm acquires a software firm, why a software/IT service firm acquires a hardware firm, and why a software/IT service firm acquires another software/IT service firm. Using data of the M&As in US IT industries, we identified major intents of the M&As. The acquisition intents are identified based on the press release of M&A announcements and measured with four categories. First, an acquirer may have intents of cost saving in operations by sharing common resources between the acquirer and the target. The cost saving can accrue from economies of scope and scale. Second, an acquirer may have intents of product enhancement/development. Knowledge and skills transferred from the target may enable the acquirer to enhance the product quality or to expand product lines. Third, an acquirer may have intents of gain additional customer base to expand the market, to penetrate the market, or to enter a foreign market. Fourth, a firm may acquire a target with intents of expanding customer channels. By complementing existing channel to the customer, the firm can increase its revenue. Our results show that acquirers have had intents of cost saving more in acquisitions between hardware companies than in acquisitions between software companies. Hardware firms are more likely to acquire with intents of product enhancement or development than software firms. Overall, the intent of product enhancement/development is the most frequent intent in all of the four acquisition types, and the intent of customer base expansion is the second. We also analyze our data with the classification of production-side intents and customer-side intents, which is based on activities of the value chain of a firm. Intents of cost saving operations and those of product enhancement/development can be viewed as production-side intents and intents of customer base expansion and those of expanding customer channels can be viewed as customer-side intents. Our analysis shows that the ratio between the number of customer-side intents and that of production-side intents is higher in acquisitions where a software firm is an acquirer than in the acquisitions where a hardware firm is an acquirer. This study can contribute to IS literature. First, this study provides insights in understanding M&As in IT industries by answering for question of why an IT firm intends to another IT firm. Second, this study also provides distribution of acquisition intents for acquisition types.

Evaluation of Denitrification Reactivity by the Supported Nanoscale Zero-Valent Iron Prepared in Ethanol-Water Solution (이중용매에서 제조된 나노영가철을 이용한 질산성질소의 환원반응성 평가)

  • Park, Heesu;Park, Yong-Min;Oh, Soo-Kyeong;Lee, Seong-Jae;Choi, Yong-Su;Lee, Sang-Hyup
    • Korean Chemical Engineering Research
    • /
    • v.46 no.5
    • /
    • pp.1008-1012
    • /
    • 2008
  • Nanoscale zero-valent iron(nZVI) is famous for its high reactivity originated from its high surface area and it has received considerable attentions as one of the latest innovative technologies for treating contaminated groundwater. Due to its fine powdery form, nZVI has limited filed applications. The efforts to overcome this shortcoming by immobilizing nZVI on a supporting material have been made. This study investigated the differences of resin-supported nZVI's characteristics by changing the preparation methods and evaluated its reactivity. The borohydride reduction of an iron salt was proceeded in ethanol/water solvent containing a dispersant and the synthesis was conducted in the presence of ion-exchange resin. The resulting material was compared to that prepared in a conventional way of using de-ionized water by measuring the phyrical and chemical characteristics. BET surface area and Fe content of nZVI-attached resin was increased from $31.63m^2/g$ and 18.19 mg Fe/g to $38.10m^2/g$ and 22.44 mg Fe/g, respectively, by switching the solution medium from water to ethanol/water with a dispersant. The reactivity of each material was tested using nitrate solution without pH control. The pseudo first-order constant of $0.462h^{-1}$ suggested the reactivity of resin-supported nZVI prepared in ethanol/water was increased 61 % compared to that of the conventional type of supported nZVI. The specific reaction rate constant based on surface area was also increased. The results suggest that this new supported nZVI can be used successfully in on-site remediation for contaminated groundwater.

Construction of Gene Network System Associated with Economic Traits in Cattle (소의 경제형질 관련 유전자 네트워크 분석 시스템 구축)

  • Lim, Dajeong;Kim, Hyung-Yong;Cho, Yong-Min;Chai, Han-Ha;Park, Jong-Eun;Lim, Kyu-Sang;Lee, Seung-Su
    • Journal of Life Science
    • /
    • v.26 no.8
    • /
    • pp.904-910
    • /
    • 2016
  • Complex traits are determined by the combined effects of many loci and are affected by gene networks or biological pathways. Systems biology approaches have an important role in the identification of candidate genes related to complex diseases or traits at the system level. The gene network analysis has been performed by diverse types of methods such as gene co-expression, gene regulatory relationships, protein-protein interaction (PPI) and genetic networks. Moreover, the network-based methods were described for predicting gene functions such as graph theoretic method, neighborhood counting based methods and weighted function. However, there are a limited number of researches in livestock. The present study systemically analyzed genes associated with 102 types of economic traits based on the Animal Trait Ontology (ATO) and identified their relationships based on the gene co-expression network and PPI network in cattle. Then, we constructed the two types of gene network databases and network visualization system (http://www.nabc.go.kr/cg). We used a gene co-expression network analysis from the bovine expression value of bovine genes to generate gene co-expression network. PPI network was constructed from Human protein reference database based on the orthologous relationship between human and cattle. Finally, candidate genes and their network relationships were identified in each trait. They were typologically centered with large degree and betweenness centrality (BC) value in the gene network. The ontle program was applied to generate the database and to visualize the gene network results. This information would serve as valuable resources for exploiting genomic functions that influence economically and agriculturally important traits in cattle.

International Legal Regulation for Environmental Contamination on Outer Space Activities (우주에서의 환경오염 방지를 위한 국제법적 규제)

  • Lee, Young-Jin
    • The Korean Journal of Air & Space Law and Policy
    • /
    • v.24 no.1
    • /
    • pp.153-194
    • /
    • 2009
  • The resources of outer space are for the common exploitation of mankind, and it is a common responsibility of mankind to protect the outer space environment. With the rapid development of space science and technology, and especially with the busy space activities of some major space powers, environmental contamination or space debris is steadily increasing in quantity and has brought grave potential threats and actual damage to the outer space environment and human activities in space. Especially We must mitigate and seek out a solution to remove space debris which poses a threat directly to man's exploitation and use of outer space activities in the Low Earth Orbit (LEO) and in the Geostationary Orbit (GEO), through international cooperation and agreement in the fields of space science, economics, politics and law, in order to safeguard the life and property of mankind and protect the earth's environment. While the issue of space debris has been the subject of scientific study and discussion for some time now, it has yet to be fully addressed within the context of an international legal framework. During the earlier stages of the space age, which began in the late 1950s, the focus of international lawmakers and diplomats was the establishment of basic rules which sought to define the legal nature of outer space and set out the parameters for space activities and the nature and scope of activities carried out in outer space were quite limited. Consequently, environmental issues and the risks that might arise from the generation of space debris did not receive priority attention within the context of the development international space law. In recent years, however, the world has seen dramatic advances in technology and increases in the type and number of space-related activities which are being carried out. In addition, the number of actors in this field has exploded from two highly developed States to a vast array of different States, intergovernmental and nongovernmental organizations, including private industry. Therefore, the number of artificial objects in the near-Earth space is continually increasing. As has been previously mentioned, COPUOS was the entity that created the existing five treaties, and five sets of legal Principles, which form the core of space law, and COPUOS is clearly the most appropriate entity to oversee the creation of this regulatory body for the outer space environmental problem. This idea has been proposed by various States and also at the ILA Conference in Buenos Aires. The ILA Conference in Buenos Aires produced an extensive proposal for such a regulatory regime, dealing with space debris issues in legal terms This article seeks to discuss the status of international law as it relates to outer space environmental problem and space debris and indicate a course of action which might be taken by the international community to develop a legal framework which can adequately cope with the complexity of issues that have recently been recognized. In Section Ⅱ,Ⅲ and IV of this article discuss the current status of international space law, and the extent to which some of the issues raised by earth and space environment are accounted for within the existing United Nations multilateral treaties. Section V and VI discuss the scope and nature of space debris issues as they emerged from the recent multi-year study carried out by the ILA, Scientific and Technical Subcommittee, Legal Subcommittee of the United Nations Committee on the Peaceful Uses of Outer Space ("COPUOS") as a prelude to the matters that will require the attention of international lawmakers in the future. Finally, analyzes the difficulties inherent in the future regulation and control of space debris and the activities to protect the earth's environment. and indicates a possible course of action which could well provide, at the least, a partial solution to this complex challenge.

  • PDF

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