• Korean Management Science Review
• /
• v.20 no.2
• /
• pp.1-16
• /
• 2003

Previous research on data extraction and integration for data warehousing has concentrated mainly on the relational DBMS or partly on the object-oriented DBMS. Mostly, it describes issues related with the change data (deltas) capture and the incremental update by using the triggering technique of active database systems. But, little attention has been paid to data extraction approaches from other types of source systems like hierarchical DBMS, etc. and from source systems without triggering capability. This paper argues, from the practical point of view, that we need to consider not only the types of information sources and capabilities of ETT tools but also other factors of source systems such as operational characteristics (i.e., whether they support DBMS log, user log or no log, timestamp), and DBMS characteristics (i.e., whether they have the triggering capability or not, etc), in order to find out appropriate data extraction techniques that could be applied to different source systems. Having applied several different data extraction techniques (e.g., DBMS log, user log, triggering, timestamp-based extraction, file comparison) to S bank's source systems (e.g., IMS, DB2, ORACLE, and SAM file), we discovered that data extraction techniques available in a commercial ETT tool do not completely support data extraction from the DBMS log of IMS system. For such IMS systems, a new date extraction technique is proposed which first creates Index database and then updates the data warehouse using the Index database. We illustrates this technique using an example application.

• Journal of the Korean Association of Oral and Maxillofacial Surgeons
• /
• v.46 no.5
• /
• pp.328-334
• /
• 2020

Objectives: This study aimed to validate the effectiveness of a recently proposed difficulty index for removal of impacted mandibular third molars based on extraction time and suggest a modified difficulty index including the presence of pathologic conditions associated with third molars. Materials and Methods: This retrospective study enrolled 65 male patients younger than 25 years with third molars. Extraction time was calculated from start of the incision to the last suture. The difficulty scores for third molars were based on spatial relationship (1-5 points), depth (1-4 points), and ramus relationship (1-3 points) using cone-beam computed tomography. The difficulty index was defined as follows: I (3-4 points), II (5-7 points), III (8-10 points), and IV (11-12 points). The modified difficulty score was calculated by adding one point to the difficulty score if the third molar was associated with a pathologic condition. Two modified difficulty indices, based on the presence of pathologic conditions, were as follows: the half-level up difficulty index (HDI) and the one-level up difficulty index (ODI) from the recently proposed difficulty index. Results: The correlations between extraction time and difficulty index and or modified difficulty indices were significant (P<0.001). The correlation coefficient between extraction time and difficulty index was 0.584. The correlation coefficients between extraction time and HDI and ODI were 0.728 and 0.764, respectively. Conclusion: Extraction time of impacted third molars exhibited a moderate correlation with difficulty index and was strongly correlated with the modified indices. Considering the clinical implications, the difficulty index of surgical extraction should take into consideration the pathologic conditions associated with third molars.

• Korean Journal of Materials Research
• /
• v.32 no.6
• /
• pp.293-300
• /
• 2022

This study investigated a graded-refractive-index (GRIN) coating pattern capable of improving the light extraction efficiency of GaN light-emitting diodes (LEDs). The planar LEDs had total internal reflection thanks to the large difference in refractive index between the LED semiconductor and the surrounding medium (air). The main goal of this paper was to reduce the trapped light inside the LED by controlling the refractive index using various compositions of (TiO₂)_x(SiO₂)_1-x in GRIN LEDs consisting of five dielectric layers. Several types of multilayer LEDs were simulated and it was determined the transmittance value of the LEDs with many layers was greater than the LEDs with less layers. Then, the specific ranges of incident angles of the individual layers which depend on the refractive index were evaluated. According to theoretical calculations, the light extraction efficiency (LEE) of the five-layer GRIN is 25.29 %, 28.54 % and 30.22 %, respectively. Consequently, the five-layer GRIN LEDs patterned enhancement outcome LEE over the reference planar LEDs. The results suggest the increased light extraction efficiency is related to the loss of Fresnel transmission and the release of the light mode trapped inside the LED chip by the graded-refractive-index.

• Journal of applied mathematics & informatics
• /
• v.40 no.1_2
• /
• pp.289-303
• /
• 2022

This article examines the multidimensional index extraction method of the disability social security system based on data mining. While creating the data warehouse of the social security system for the disabled, we need to know the elements of the social security indicators for the disabled. In this context, a clustering algorithm was used to extract the indicators of the social security system for the disabled by investigating the historical dimension of social security for the disabled. The simulation results show that the index extraction method has high coverage, sensitivity and reliability. In this paper, a multidimensional extraction method is introduced to extract the indicators of the social security system for the disabled based on data mining. The simulation experiments show that the method presented in this paper is more reliable, and the indicators of social security system for the disabled extracted are more effective in practical application.

• International Journal of Industrial Entomology and Biomaterials
• /
• v.26 no.2
• /
• pp.113-118
• /
• 2013

In this study, silk sericin films were prepared using different extraction methods, and the molecular conformation of sericin was examined using Fourier-transform infrared spectroscopy with attenuated total reflection geometry. Additionally, the effect of the film side (air-facing side or plate-facing side) on the molecular conformation of the sericin films was investigated. Interestingly, the molecular conformation of the sericin film depended on the film side. The molecular conformation of air-facing side of the sericin film was significantly influenced by extraction solution and time. The ${\beta}$-sheet crystallization and the crystallinity index of the sericin film markedly increased with an increase in the extraction time in hot water. The order of the crystallinity indices for the sericin films obtained with different extraction solutions was as follows: citric acid solution > urea solution >> hot water. In contrast, no remarkable differences were observed in the molecular conformation of the plate-facing side of the sericin film after extraction in hot water for different time periods. Urea and citric acid solution extractions showed remarkably higher crystallinity indices for sericin than those obtained after hot water extraction. However, no significant differences were observed in the crystallinity index of sericin between urea and citric acid solution extraction in plate-facing side of the film.

• The Transactions of the Korea Information Processing Society
• /
• v.7 no.4
• /
• pp.1122-1131
• /
• 2000

The efficiency of thesytem depends upon an accurate extraction capability of index terms in the system of information search or in that of automatic index. Therefore, extraction of accurate index terms is of utmost importance. This report presents the generation methods of composition noun for efficient index term extraction by using words of high frequency appearance, so that the right documents can be found during information search. For the sake of presentation of this method, index terms of composition noun shall be extracted by applying the rule of composition and disintegration to the nouns with high frequency of appearance in the documents, such as those with upper 30%∼40% of frequency ratio. In addition, for he purpose of effecting an inspection of validity in relation to a composition of high frequency nouns such as those with upper 30∼40% of frequency ratio as presented in this report, it proposes an adequate frquency ratio during noun composition. Based upon the proposed application, in this short documents with less than 300 syllables, low frequency omissions were noticed, when composed with nouns in the upper 30% of frequency ratio; whereas the documents with more than 30 syllables, when composed with nouns in he upper 40% of frequency ration, had a considerable reduction of low frequency omissions. Thus, total number of index terms has decreased to 57.7% of these existing and an accurate extraction of index terms with an 85.6% adequacy ratio became possible.

• Journal of Environmental Science International
• /
• v.21 no.10
• /
• pp.1265-1274
• /
• 2012

This study was conducted to investigate the extraction characteristics including total polyphenol compound content (TPC) and the antioxidative effect of Rumex crispus root extract on commercial corn oil. Extraction yield was increased with extraction temperature but decreased with extraction ratio. No significant differences in aromatics content were found among the extracts prepared with various extraction conditions; extraction ratio, extraction temperature, extraction pH and composition of extractant. Total flavonoid content of the extract was increased with extraction temperature and extraction pH, and highest value of it was found when extractant composition of ethanol in water was 75%. Total polyphenol compound content (TPC) of the extract with 10 fold extraction ratio showed the highest value, but no significant difference in TPC was found with extraction temperature. Reducing power and DPPH (${\alpha}$,${\alpha}$-diphenyl-${\beta}$-picrylhydrazyl) radical scavenging ability (RSA) of the extract in spectrophotometric absorbance were decreased with extraction ratio but increased with extraction temperature and showed 63.1%~98.4% and 67.6%~86.7% of those of ascorbic acid in reducing power and DPPH RSA, respectively. The antioxidative effects of the extract on corn oil were 84.8~93.0% of that of commercial butylated hydroxytoluene, the antioxidant index value was highest when the ethanol composition to water in extractant was equal ratio.

• Journal of Korean Library and Information Science Society
• /
• v.36 no.2
• /
• pp.327-348
• /
• 2005

The purpose of this study is to emphasize the importance of index definition and to prepare the basis of optimal index in bibliographic retrieval system. For the purpose, this research studied a index extraction theory on index tag definition and index normalization from the bibliographic marc database and analyzed a retrieval utilization rate of extracted index. In this experiment, we divided index between text-type and code-type about the generated 29,219,853 indexes from 2,200,488 bibliographic records and analyzed utilization rate by the comparison of index-type and index term of web logs. According to the result, the text-type indexes such as title, author, publication, subject are showed high utilization rate while the code-type indexes were showed low utilization rate. So this study suggests that the unused index is removed from index definition to optimize index.

• Journal of Dental Rehabilitation and Applied Science
• /
• v.30 no.3
• /
• pp.223-230
• /
• 2014

Purpose: The purpose of this study was to evaluate the improvement and posttreatment stability of patients treated with extraction of lower incisors. Materials and Methods: The total of 20 patients with extracted lower incisors were analyzed by means of diagnostic models and panoramic x-rays at the time of initial, final and after 2 years of retention period of the treatment. Irregularity index, overjet, overbite, tooth size-arch length discrepancy (TSALD), intercanine width, intermolar width and American Board of Orthodontics cast/radiographic evaluation (ABO-CRE) were analyzed. Statistical analysis was performed using Wilcoxon signed-rank test. Results: After treatment, irregularity index showed significant decrease (P = 0.000). TSALD showed significant increase (P = 0.028). During retention period, irregularity index showed significant increase (P = 0.001). For ABO-CRE, total score showed significant decrease after treatment (P = 0.000) and showed average decreased which was not significant result (P = 0.053). Conclusion: Through evaluation of stability of extraction of lower incisors by means of diagnostic models and panoramic x-rays, it can be concluded that lower incisor extraction treatment had been stable for 2 years after treatment.

• Journal of KIISE:Software and Applications
• /
• v.29 no.8
• /
• pp.584-594
• /
• 2002

In information retrieval or digital library, one of the most important factors is to find out the exact information which users need. In this paper, we present an efficient index term extraction method which makes it possible to guess the content of documents and get the information more exactly. To find out index terms in a document, we use lexical chains. Before generating lexical chains, we roughly disambiguate the senses of nouns in a document using specific concept, called semantic window. Semantic window is that we look ahead semantic relations of peripheral nouns and disambiguate the senses of nouns. After generating lexical chains with sense-disambiguated nouns, we find out strong chains by some metrics and extract index terms from a few strong chains. We evaluated our system, using results of a key phrase extraction system, KEA. This system works in general domains of documents Including Information Retrieval and Digital Library.