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

• Geophysics and Geophysical Exploration
• /
• v.1 no.1
• /
• pp.25-30
• /
• 1998

Time-lapse crosswell seismic data, recorded before and after the cavity filling, showed that the filling increased the velocity at a known cavity zone in an old mine site in Inchon area. The seismic response depicted on the tomogram and in conjunction with the geologic data from drillings imply that the size of the cavity may be either small or filled by debris. In this study, I attempted to evaluate the filling effect by analyzing velocity measured from the time-lapse tomograms. The data acquired by a downhole airgun and 24-channel hydrophone system revealed that there exists measurable amounts of source statics. I presented a methodology to estimate the source statics. The procedure for this method is: 1) examine the source firing-time for each source, and remove the effect of irregular firing time, and 2) estimate the residual statics caused by inaccurate source positioning. This proposed multi-step inversion may reduce high frequency numerical noise and enhance the resolution at the zone of interest. The multi-step inversion with different starting models successfully shows the subtle velocity changes at the small cavity zone. The inversion procedure is: 1) conduct an inversion using regular sized cells, and generate an image of gross velocity structure by applying a 2-D median filter on the resulting tomogram, and 2) construct the starting velocity model by modifying the final velocity model from the first phase. The model was modified so that the zone of interest consists of small-sized grids. The final velocity model developed from the baseline survey was as a starting velocity model on the monitor inversion. Since we expected a velocity change only in the cavity zone, in the monitor inversion, we can significantly reduce the number of model parameters by fixing the model out-side the cavity zone equal to the baseline model.

• Journal of Bio-Environment Control
• /
• v.31 no.4
• /
• pp.401-408
• /
• 2022

As research on a controlled environment system based on crop growth environment sensing for sustainable production of horticultural crops and its industrial use has been important, research on how to properly utilize soil moisture sensors for outdoor cultivation is being actively conducted. This experiment was conducted to suggest the proper method of utilizing the TEROS 12, an FDR (frequency domain reflectometry) sensor, which is frequently used in industry and research fields, for each orchard soil in three regions in Korea. We collected soils from each orchard where fruit trees were grown, investigated the soil characteristics and soil water retention curve, and compared TEROS 12 sensor calibration equations to correlate the sensor output to the corresponding soil volumetric water content through linear and cubic regressions for each soil sample. The estimated value from the calibration equation provided by the manufacturer was also compared. The soil collected from all three orchards showed different soil characteristics and volumetric water content values by each soil water retention level across the soil samples. In addition, the cubic calibration equation for TEROS 12 sensor showed the highest coefficient of determination higher than 0.95, and the lowest RMSE for all soil samples. When estimating volumetric water contents from TEROS 12 sensor output using the calibration equation provided by the manufacturer, their calculated volumetric water contents were lower than the actual volumetric water contents, with the difference up to 0.09-0.17 m³·m^-3 depending on the soil samples, indicating an appropriate calibration for each soil should be preceded before FDR sensor utilization. Also, there was a difference in the range of soil volumetric water content corresponding to the soil water retention levels across the soil samples, suggesting that the soil water retention information should be required to properly interpret the volumetric water content value of the soil. Moreover, soil with a high content of sand had a relatively narrow range of volumetric water contents for irrigation, thus reducing the accuracy of an FDR sensor measurement. In conclusion, analyzing soil water retention characteristics of the target soil and the soil-specific calibration would be necessary to properly quantify the soil water status and determine their adequate irrigation point using an FDR sensor.

• Journal of Internet Computing and Services
• /
• v.25 no.4
• /
• pp.65-72
• /
• 2024

To faithfully represent the intention of the work in the exhibition space, lighting that provides high color reproduction like natural light is required. Thus, many lighting technologies have been introduced to improve CRI, but most of them only evaluated the general color rendering index (CRI Ra), which considers eight pastel colors. Natural light provides excellent color rendering performance for all colors, including red and blue, expressed by color rendering index of R9 and R12, but most artificial lighting has the problem that color rendering performance such as R9 and R12 is significantly lower than that of natural light. Recently, lighting technology that provides CRI at the level of natural light is required to realistically express the colors of works including primary colors but related research is very insufficient. Therefore this paper proposes exhibition hall lighting that fulfills CRI with a focus on CRI Ra, R9, and R12 based on the characteristics of natural light. First reinforcement wavelength bands for improving R9 and R12 are selected through analysis of the actual measurement SPD of natural and artificial lighting. Afterward virtual SPDs with a peak wavelength within the reinforcement wavelength band are created and then SPD combination conditions that satisfy CRI Ra≥95, R9, and R12≥90 are derived through combination simulation with a commercial LED light source. Through this, after specifying two types of light sources with 405,630nm peak wavelength that had the greatest impact on the improvement of R9 and R12, the exhibition hall lighting applied with two W/C White LEDs is designed and a control Index DB of the lighting is constructed. Afterward experiments with the proposed method showed that it was possible to achieve high CRI at the level of natural light with average CRI Ra 96.5, R9 96.2, and R12 94.0 under the conditions of illuminance (300-1,000 Lux) and color temperature (3,000-5,000K).

• Korean Journal of Environmental Biology
• /
• v.24 no.3
• /
• pp.248-257
• /
• 2006

Total naturalized plant species in the streams of Jeonju were listed as 109 taxa; 24 families, 75 genera, 106 species, 3 varieties. Dividing by stream, Jeonju stream has 75 taxa; 20 families, 55 genera, 73 species, 2 varieties. Samcheon stream has 86 taxa; 19 families, 64 genera, 84 species, 2 varieties. Soyang stream has 80 taxa; 21 families, 60 genera, 77 species, 3 varieties. Urbanization Index (UI) of total streams (109 taxa) was 40.2%. UI was 27.7% in Jeonju stream (75 taxa), 31.7% in Samcheon stream (86 taxa), 29.5% in Soyang stream (80 taxa). Dividing by degree of naturalization classification, 25 taxa (9.2%) were found in class 5, 17 taxa (6.2%) in class 4, 32 taxa (11.8%) in class 3, 27 taxa (9.9%) in class 2 and 8 taxa (2.9%) in class 1. Dividing by introduction period, 48 taxa (44%) aye in period I, 19 taxa (17%) in period II, 42 taxa (39%) in period III. Dividing by growth type, 48 taxa (44%) are annuals, 25 taxa (23%) are biennials, 33 taxa (30%) are perennials. Dividing by the place of origin, 39 taxa (35%) are from Euyope, 33 taxa (30%) from North America, 11 taxa (10%) from Tropic America, 9 taxa (8%) from Europe Asia,5 taxa (5%) from South America, 5 taxa (5%) from China.

• Radiation Oncology Journal
• /
• v.25 no.1
• /
• pp.54-61
• /
• 2007

[ $\underline{Purpose}$ ]: The purpose of this study is to develop a practical method for determining accurate marker positions for prostate cancer radiotherapy using CT images and kV x-ray images obtained from the use of the on- board imager (OBI). $\underline{Materials\;and\;Methods}$: Three gold seed markers were implanted into the reference position inside a prostate gland by a urologist. Multiple digital image processing techniques were used to determine seed marker position and the center-of-mass (COM) technique was employed to determine a representative reference seed marker position. A setup discrepancy can be estimated by comparing a computed $COM_{OBI}$ with the reference $COM_{CT}$. A proposed algorithm was applied to a seed phantom and to four prostate cancer patients with seed implants treated in our clinic. $\underline{Results}$: In the phantom study, the calculated $COM_{CT}$ and $COM_{OBI}$ agreed with $COM_{actual}$ within a millimeter. The algorithm also could localize each seed marker correctly and calculated $COM_{CT}$ and $COM_{OBI}$ for all CT and kV x-ray image sets, respectively. Discrepancies of setup errors between 2D-2D matching results using the OBI application and results using the proposed algorithm were less than one millimeter for each axis. The setup error of each patient was in the range of $0.1{\pm}2.7{\sim}1.8{\pm}6.6\;mm$ in the AP direction, $0.8{\pm}1.6{\sim}2.0{\pm}2.7\;mm$ in the SI direction and $-0.9{\pm}1.5{\sim}2.8{\pm}3.0\;mm$ in the lateral direction, even though the setup error was quite patient dependent. $\underline{Conclusion}$: As it took less than 10 seconds to evaluate a setup discrepancy, it can be helpful to reduce the setup correction time while minimizing subjective factors that may be user dependent. However, the on-line correction process should be integrated into the treatment machine control system for a more reliable procedure.

• Journal of Environmental Impact Assessment
• /
• v.25 no.5
• /
• pp.319-332
• /
• 2016

Alien turtles belonging to Genus Trachemys have been designated as Invasive Alien Species since 2001 and their import has been banned in Korea. However, current status of import and distribution of the other alien turtles have not been reported. In this study, we aimed to investigate the taxa of alien turtles introduced into Korea, to assess their potential risks to the natural ecosystems and to suggest the future management directions of them in Korea. We identified 73 species of alien turtles belonging to 9 families. Since 2008, more than 6,000 kg of turtles have been imported annually and widely distributed through the pet shops, traditional markets and individual transactions. From the survey of natural habitats, we found that 8 species belonging to 3 families including Chrysemys picta, Pseudemys concinna, P. nelsoni, P. peninsularis, P. rubriventris, Mauremys sinensis, Macrochelys temminckii and Trachemys scripta have inhabited in 12 study sites. Out of 73 alien turtles, the potential adverse impacts of 13 species to ecosystems are serious when we considered status of designation of invasive alien species in other countries. For the management of alien turtles, it is required to register alien turtles in the import list and share general information such as import purpose, distribution and management condition among relevant authorities. The breeders and distributors must be obliged to identify turtles and to record management. The government must check transfer and migration of turtles periodically to prevent their introduction and spread into natural environments. The change of alien turtle populations in natural habitats should be monitored and their management plan should be developed to control the alien turtles in areas where the impacts are significant.

• Journal of the Korean Society of Fisheries and Ocean Technology
• /
• v.35 no.2
• /
• pp.136-146
• /
• 1999

The telemetry system for the oxygen, pH, turbidity and the distribution ecology of fishes was constructed by the authors in order to product and manage effectively in shallow sea culture and setnets fisheries, and then the experiments for the telemetry system carried out at the culturing fishing ground in coast of Sanyang-Myon, Kyoungsangnam-Do and the set net fishing ground located Nungpo bay in Kojedo province respectively from October, 1997 to June 1998.As those results, the techniques suggested in the telemetry system for which find out the relationship between the physical and chemical environment in the sea and the distribution ecology of fishes gave full display its function, and its system could be operated as real time system. This research can also provide base-line data to develope a hybrid system unifying the marine environment information and the fisheries resources information in order to manage effectively coastal fishing ground.

• Journal of Korean Society of Transportation
• /
• v.36 no.2
• /
• pp.155-168
• /
• 2018

In this study, we studied the directional pattern of entering the intersection from the intersection upstream link prior to predicting short future (such as 5 or 10 minutes) intersection direction traffic volume on the interrupted flow, and examined the possibility of traffic volume prediction using traffic assignment model. The analysis method of this study is to investigate the similarity of patterns by performing cluster analysis with the ratio of traffic volume by intersection direction divided by 2 hours using taxi DTG (Digital Tachograph) data (1 week). Also, for linking with the result of the traffic assignment model, this study compares the impact area of 5 minutes or 10 minutes from the center of the intersection with the analysis result of taxi DTG data. To do this, we have developed an algorithm to set the impact area of intersection, using the taxi DTG data and traffic assignment model. As a result of the analysis, the intersection entry pattern of the taxi is grouped into 12, and the Cubic Clustering Criterion indicating the confidence level of clustering is 6.92. As a result of correlation analysis with the impact area of the traffic assignment model, the correlation coefficient for the impact area of 5 minutes was analyzed as 0.86, and significant results were obtained. However, it was analyzed that the correlation coefficient is slightly lowered to 0.69 in the impact area of 10 minutes from the center of the intersection, but this was due to insufficient accuracy of O/D (Origin/Destination) travel and network data. In future, if accuracy of traffic network and accuracy of O/D traffic by time are improved, it is expected that it will be able to utilize traffic volume data calculated from traffic assignment model when controlling traffic signals at intersections.

• Journal of Broadcast Engineering
• /
• v.18 no.6
• /
• pp.895-910
• /
• 2013

Multi-screen service is a service that consumes more than one media in a number of terminals simultaneously or discriminately. This multi-screen service has become useful due to distribute of smart TV and terminals. Also, in case of hybrid broadcasting environment that is convergence of broadcasting and communication environment, it is able to provide various user experience through contents consumed by multiple screens. In hybrid broadcasting environment, scene composition technology can be used as an element technology for multi-screen service. Using scene composition technology, multiple media can be consumed complexly through the specified presentation time and space. Thus, multi-screen service based on the scene composition technology can provide spatial and temporal control and consumption of multiple media by linkage between the terminals. However, existing scene composition technologies are not able to use easily in hybrid broadcasting because of applicable environmental constraints, the difficulty in applying the various terminal and complexity. For this problems, HTML5 can be considered. HTML5 is expected to be applied in various smart terminals commonly, and provides consumption of diverse media. So, in this paper, it proposes the scene composition and multi-screen service technology based on HTML5 that is expected be used in various smart terminals providing hybrid broadcasting environment. For this, it includes the introduction in terms of HTML5 and multi-screen service, the method of providing information related with scene composition and multi-screen service through the extention of elements and attributes in HTML5, media signaling between terminals and the method of synchronization. In addition, the proposed scene composition and multi-screen service technology based on HTML5 was verified through the implementation and experiment.