• Journal of KIISE:Databases
• /
• v.33 no.5
• /
• pp.526-537
• /
• 2006

The most representative approach for efficient storing of XML data is to store XML data in relational databases. The merit of this approach is that it can easily accept the realistic status that most data are still stored in relational databases. This approach needs to convert XML data into relational data or relational data into XML data. The most important issue in the translation is to reflect structural and semantic relations of RDB to XML schema model exactly. Many studies have been done to resolve the issue, but those methods have several problems: Not cover structural semantics or just support explicit referential integrity relations. In this paper, we propose an algorithm for extracting implicit referential integrities automatically. We also design and implement the suggested algorithm, and execute comparative evaluations using translated XML documents. The proposed algorithm provides several good points such as improving semantic information extraction and conversion, securing sufficient referential integrity of the target databases, and so on. By using the suggested algorithm, we can guarantee not only explicit referential integrities but also implicit referential integrities of the initial relational schema model completely. That is, we can create more exact XML schema model through the suggested algorithm.

• Spatial Information Research
• /
• v.20 no.1
• /
• pp.47-57
• /
• 2012

An Administrative Boundary is the basic of spatial information to cover geographical and regional area. Its importance has arisen in our society at the Smart world era. However, it is difficult to serve exact boundary's lines as administrative boundaries are based on the cadastre lines of land register ; these partly are overlay each other or has gaps. So, it Should be adjusted. But, the maintenance work of administration boundaries causes a conflict or confusion unless we offer concrete procedures and detailed plans previously. Therefore, a rational method is required to prevent side-effects such as confusion, disagreem ent and a conflict etc. In this Study, we present a method and 5 step procedures to make better use in a practical maintenance work. we researched on basic studies of Administrative boundary's concept, history. And we performed a field survey as well as analysis of current problems. considering these results, we suggest usage of various spatial data sources, stake-holders' participation, a method of Nearest district's boundaries to maintain administrative boundaries. Throughout the method, we expect it to serve correct boundary-data to various fields without a big confusion. it is also useful to apply its results not only for re-surveying our land but for recording appropriate boundary-data as rational lines.

• Journal of environmental and Sanitary engineering
• /
• v.7 no.2
• /
• pp.95-110
• /
• 1992

Much progress has been made in understanding the subcellular events of the human lung injuries after acute exposure to environmental air pollutants. Host of those events represent oxidative damages mediated by reactive oxygen species such as superoxide, hydrogen peroxide, and the hydroxy, free radical. Recently, nitric oxide (NO) was found to be endogenously produced by endothelial cells and cells of the reticulo-endothelial system as endothelialderived relaxation factor (EDRF) which is a vasoactive and neurotransmitter substance. Together with superoxide, NO can form another strong oxidant, peroxonitrite. The relative importance of exogenous sources of $N0/N0_2$ and endogenous production of NO by the EDRF producing enzymes in the oxidative stresses to the heman lung has to be elucidated. The exact events leading to chronic irreversible damage are still yet to be known. From chronic exposure to oxidant gases, progressive epithelial and interstitial damages develop. Type I epithelial cells become thicker and cover a smaller average alveolar surface area while thee II cells proliferate instead. Under acute damages, the extent of loss of the alveolar epithelial cell lining, especially type II cells appears to be a good predictor of the ensuing irreversible damage to alveolar compartment. Interstitial matrix undergo remodeling during chronic exposure with increased collagen fibers and interstitial fibroblasts. However, Inany of these changes can be reversed after cessation of exposure. Among chronic lung injuries, genetic damages and repair responses received particular attention in view of the known increased lung cancer risks from exposure to several air pollutants. Heavy metals from foundry emission, automobile traffics, and total suspended particulate, especially polycystic aromatic hydrocarbons have been positively linked with the development of lung cancer. Asbestos in another air pollutant with known risk of lung cancer and mesothelioma, but asbestos fibers are nonauthentic in most bioassays. Studies using the electron spin resonance spin trapping method show that the presence of iron in asbestos accelerates the production of the hydroxy, radical in vitro. Interactions of these reactive oxygen species with particular cellular components and disruption of cell defense mechanisms still await further studies to elucidate the carcinogenic potential of asbestos fibers of different size and chemical composition. The distribution of inhaled pollutants and the magnitude of their eventual effects on the respiratory tract are determined by pollutant-independent physical factors such as anatomy of the respiratory tract and level and pattern of breathing, as well as by pollutant-specific phyco-chemical factors such as the reactivity, solubility, and diffusivity of the foreign gas in mucus, blood and tissue. Many of these individual factors determining dose can be quantified in vitro. However, mathematical models based on these factors should be validated for its integrity by using data from intact human lungs.

• Journal of Korean Society of Forest Science
• /
• v.83 no.3
• /
• pp.322-330
• /
• 1994

The Universal Soil Loss Equation (USLE) has been widely used to predict long-term soil loss by incorporating several erosion factors, such as rainfall, soil, topography, and vegetation. This study is aimed to introduce the LISLE within geographic information system(GIS) environment. The Kwangneung Experimental Forest located in Kyongki Province was selected for the study area. Initially, twelve years of hourly rainfall records that were collected from 1982 to 1993 were processed to obtain the rainfall factor(R) value for the LISLE calculation. Soil survey map and topographic map of the study area were digitized and subsequent input values(K, L, S factors) were derived. The cover type and management factor (C) values were obtained from the classification of Landsat Thematic Mapper(CM) satellite imagery. All these input values were geographically registered over a common map coordinate with $25{\times}25m^2$ ground resolution. The USLE was calculated for every grid location by selecting necessary input values from the digital base maps. Once the LISLE was calculated, the resultant soil loss values(A) were represented by both numerical values and map format. Using GIS to run the LISLE, it is possible to pent out the exact locations where soil loss potential is high. In addition, this approach can be a very effective tool to monitor possible soil loss hazard under the situations of forest changes, such as conversion of forest lands to other uses, forest road construction, timber harvesting, and forest damages caused by fire, insect, and diseases.

• Journal of Korean Ophthalmic Optics Society
• /
• v.18 no.3
• /
• pp.231-239
• /
• 2013

Purpose: To design and fabricate the auto pattern maker for the development. Methods: we got the necessary data, needed in design, by using CAD. Based on the these data, we fabricated the trial product for the development of the auto pattern maker. Results: The auto pattern maker were composed with combinations of many elements; pattern making assembly, control panel, frame attachment and prober unit. The pattern making assembly was comprised of the cutter, the pattern holder, pattern remover and silence cover which could minimize the sound during the cutting process. The control panel was designed to be connected and operated with the main printed circuit board. The prober could get the eye shape data by scanning of 1.8 degrees around the groove of the frame through the encoding data according to the address. After starting, scanning was carried out in two passes, i.e. one right-handed and one left-handed. Communication connector could send the eye shape data from auto pattern maker to outer system with the RS232C transmission system. By using the one-way analysis of variance, we got the error rate of cut pattern size for ${\Phi}22mm$, ${\Phi}55mm$ and ${\Phi}62mm$. Because F-value was 0.510 and p-value was 0.601, no statistically significant differences were found. Also, the mean cutting error of the auto pattern maker was 0.0274 mm. Conclusions: we could succeed in making the trial product by applying it to the development of the auto pattern maker. The role of this auto pattern maker is to find a exact required size of lens to fit the frame by measuring the frame. The acquired data are transferred to outer system for grinding and finishing with patternless process. Also, the trial product can produce pattern to fit the frame. Therefore, it was confidently expected that the optometrists could handily produce pattern to fit the frame with this trial product and dispense the ophthalmic lens because of its efficiency and convenience compared to the past.

• Korean Journal of Heritage: History & Science
• /
• v.54 no.1
• /
• pp.52-69
• /
• 2021

The transcriptions of Buddhist sutra in the Goryeo Dynasty are more elaborate and splendid than those of any other period and occupy a very important position in Korean bibliography. Among them, the transcriptions made on indigo paper show decorative features that represent the dignity and quality that nobles would have preferred. Particularly, during the Goryeo Dynasty, a large number of transcriptions were made on indigo paper, often in hand-scrolled and folded forms. If flexibility was not guaranteed, the hand-scrolled form caused inconvenience and damage when handling the transcription because of the structural limitations of the material that is rolled up and opened. It was possible to overcome these shortcomings by changing from the hand-scrolled to the folded form to obtain convenience and structural stability. The folded form of the transcription utilizes the same principle as the folding screen, so it is a structure that can be folded and unfolded, and it is made by connecting parts at regularly spaced intervals. No matter how small the transcription is, if it is made of thin paper, it is difficult to handle it and to maintain its shape and structure. For this reason, the folded transcription was usually made of thick paper to support the structure, and the cover was made thicker than the inner part to protect the contents. In other words, the forded form was generally manufactured to suit the characteristics of maintaining strength by making the paper thick. Because a large amount of indigo paper was needed to make this type of transcription, it is assumed that there were craftsmen who were in charge only of dark dyeing the papers. Usually, paper dyeing requires much more dye than silk dyeing, and dyeing dozens of times would be required to obtain the deep indigo color of the base of the transcription of Buddhist sutra in the Goryeo Dynasty. Unfortunately, there is no record of the Goryeo Dynasty's indigo blue paper manufacturing technique, and the craftsmen who made indigo paper no longer remain, so no one knows the exact method of making indigo paper. Recently, Hanji artisans, natural dyers, and conservators attempted to restore the Goryeo Dynasty's indigo paper, but the texture and deep colors found in the relics could not be reproduced. This study introduces the process of restoring indigo paper in the Goryeo Dynasty through collaboration between dyeing artisans, Hanji artisans, and conservators for conservation of the transcription of Buddhist sutra in the late Goryeo dynasty, yielding a suggested method of making indigo paper.