• Journal of KIISE:Computing Practices and Letters
• /
• v.15 no.3
• /
• pp.154-166
• /
• 2009

Database query and reporting tools, OLAP tools and data mining tools are typical front-end tools in Business Intelligence environment which is able to support gathering, consolidating and analyzing data produced from business operation activities and provide access to the result to enterprise's users. Traditional reporting tools have an advantage of creating sophisticated dynamic reports including SQL query result sets, which look like documents produced by word processors, and publishing the reports to the Web environment, but data source for the tools is limited to RDBMS. On the other hand, OLAP tools and data mining tools have an advantage of providing powerful information analysis functions on each own way, but built-in visualization components for analysis results are limited to tables or some charts. Thus, this paper presents a system that integrates three typical front-end tools to complement one another for BI environment. Traditional reporting tools only have a query editor for generating SQL statements to bring data from RDBMS. However, the reporting tool presented by this paper can extract data also from OLAP and data mining servers, because editors for OLAP and data mining query requests are added into this tool. Traditional systems produce all documents in the server side. This structure enables reporting tools to avoid repetitive process to generate documents, when many clients intend to access the same dynamic document. But, because this system targets that a few users generate documents for data analysis, this tool generates documents at the client side. Therefore, the tool has a processing mechanism to deal with a number of data despite the limited memory capacity of the report viewer in the client side. Also, this reporting tool has data structure for integrating data from three kinds of data sources into one document. Finally, most of traditional front-end tools for BI are dependent on data source architecture from specific vendor. To overcome the problem, this system uses XMLA that is a protocol based on web service to access to data sources for OLAP and data mining services from various vendors.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.21 no.4
• /
• pp.259-267
• /
• 2020

This study measured the Particulate Matter (PM) concentration according to altitude (30 m, 60 m, 90 m, 120 m, and 150 m) in three different environments: a construction site, natural environment (arboretum), and residential area. PM_2.5 and PM₁₀ values at 30 m above the construction site were 18.63 ㎍/㎥ and 24.23 ㎍/㎥ while values at 150 m were 10.89 ㎍/㎥ and 10.61 ㎍/㎥, respectively, indicating the average concentration decreased as altitude increased. PM_2.5 and PM₁₀ values at 30 m above the natural environment were 9.03 ㎍/㎥ and 11.21 ㎍/㎥ while those at 150 m were 3.42 ㎍/㎥ and 3.57 ㎍/㎥, respectively, showing lower average concentrations as altitude increased. PM_2.5 and PM₁₀ values at 30 m above the residential area were 10.65 ㎍/㎥ and 12.06 ㎍/㎥ while those at 150 m were 4.24 ㎍/㎥ and 5.17 ㎍/㎥, also demonstrating lower PM concentrations as altitude increased. The PM concentrations decreased as altitude increased at all tested sites and also decreased between environments in the following order: construction site, residential area, and natural environment. The results of this study are significant because PM concentrations were measured at various altitudes at different land-use sites. The results are expected to serve as basic data for decision-making in both regional and urban planning.

• Journal of Animal Science and Technology
• /
• v.48 no.3
• /
• pp.479-486
• /
• 2006

The current study was conducted to examine the effect of feeding and management practices on milk quality and dairy farm productivity in Korea. Fifty dairy farms in Gyunggi (11), Gangwon (22), Chungnam (17) provinces were surveyed to collect data on the herd size, housing style, feeding management, waste disposal, milking practices and milk yield. Milk tank samples from all farms under study were also collected to enumerate its composition and quality parameters. Large dairy herds are equiped with better housing, milking and waste control facilities than medium and small dairy herds. Higher concentrate feeding to lactating cows was noticed in small dairy herds (47.51 %) than in medium (32.59 %) and large dairy herds (31.82 %). The decrease in concentrate feeding to lactating cows with increase in number of cows per farm resulted in a simultaneous increase in the use of imported forages. Bacterial count in milk was affected by housing and milking facilities at dairy farms. Higher bacterial counts (Coliform and E. coli) in milk were observed in cows housed in stanchion than those under free stall with saw dust bedding. The bacterial counts were higher with bucket milking system than with pipe-line and parlour systems. The increase in the number of dairy cows per farm and thus better management and milking facilities resulted in a reduction in somatic cell score. Milk yield (per cow) was higher in herds with less somatic cell score. Average milk protein concentration was between 2.89 to 2.98 % and milk urea nitrogen was between 21.81 to 23.31mg/ml on surveyed dairy farms. This study concluded that large herd size with better dairy cow management facilities is crucial to produce quality milk with better dairy farm income.

• Journal of the Korean Society of Radiology
• /
• v.9 no.6
• /
• pp.393-401
• /
• 2015

Radiation therapy for lung cancer is an effective treatment during monotherapy or combination therapy. Studies have reported that the optimum utilization rate of radiation therapy is estimated at 61% to 74%. Radiation therapy in Korea has been investigated to be low; further studies are needed. This study was intended to assess the appropriateness of the use of radiation and to reveal the use of radiation therapy-related factors by examining radiation therapy in lung cancer patients of Busan and South Gyeongnam Province. This study was aimed at the population diagnosed with lung cancer in Busan and South Gyeongnam Province. To conduct the study, 1036 patients enrolled in two hospitals were collected and 897 appropriate as subjects were selected. We compared the optimum utilization rate and actual rate of radiation therapy, and revealed the adequacy and related factors for use of radiotherapy. Of 897 patients, 503 (56%) were treated with medical therapy and 394 (44%) were given radiotherapy. The radiotherapy utilization rate of all lung cancer patients was 42%. The proportion of non-small cell lung cancer by histologic type was 33% and that of small cell lung cancer was 90%. Factors related to radiation therapy used in cancer were age, histological type, clinical stage, doctor refereed to, and clinical examination. Compared to radiation utilization by region (site), curative chest therapy was 42%; palliative treatment was 26%. In the comparison of histologic types, utilization of small-cell lung cancer is lower; the lowest especially in the stage III. Utilization of radiation therapy in Busan and South Gyeongnam Province was lower than the reasonable one. Utilization difference could be explained by patient factors, tumor factors, and health service factors. To improve utilization,development ofoutreach service programs and activation of the multidisciplinary team are required.

• KOREAN JOURNAL OF CROP SCIENCE
• /
• v.42 no.5
• /
• pp.579-596
• /
• 1997

A simulation study was carried out to delineate potential effects of the lake-induced climate change on crop productivity around Lake Imha which was formed after a multi-purpose dam construction in Andong, Korea. Twenty seven cropping zones were identified within the 30 km by 25 km study area. Five automated weather stations were installed within the study area and operated for five years after the lake formation. A geostatistical method was used to calculate the monthly climatological normals of daily maximum and minimum temperature, solar radiation and precipitation for each cropping zone before and after the dam construction. Daily weather data sets for 30 years were generated for each cropping zone from the monthly normals data representing "No lake" and "After lake" climatic scenarios, respectively. They were fed into crop models (ORYZA1 for rice, SOYGRO for soybean, CERES-maize for corn) to simulate the yield potential of each cropping zone. Calculated daily maximum temperature was higher after the dam construction for the period of October through March and lower for the remaining months except June and July. Decrease in daily minimum temperature was predicted for the period of April through August. Monthly total radiation was predicted to decrease after the lake formation in all the months except February, June, and September and the largest drop was found in winter. But there was no consistent pattern in precipitation change. According to the model calculation, the number of cropping zones which showed a decreased yield potential was 2 for soybean and 6 for corn out of 27 zones with a 10 to 17% yield drop. Little change in yield potential was found at most cropping zones in the case of paddy rice, but interannual variation was predicted to increase after the lake formation. the lake formation.

• Korean journal of applied entomology
• /
• v.7
• /
• pp.5-13
• /
• 1969

Present system of seed potato production in Korea has several weak points and consequently has difficulties in covering annual shortage of 60,000 tons of seed potatoes. The author has an opinion that this so called 'High land system' of seed potato production adopted by the Government should be replaced by the 'Coastal area system' which is proposed by the author and has many advantages over present 'High land system'(2). In coastal areas where enormous acreage of rice paddies are spread, mostly around the villages. the primary host plants of the vectors are found. Therefore, the only source of aphid vectors are limited to the villages. The farmer's houses scattered more sparsely also have minor importance. In the previous paper(2), the author reported that the aphid vector populations were lower in the coastalareas than at Taegwanryong where the Alpine Experiment Station for the production. of seed potatoes is located. However, the number to vectors at Okku showed rather high density, where the trap was placed at the distance of 200 m from a village where peach and Hibiscus trees, the primary hosts of Myzus pesrsicae and Aphis gossypii were grown. To clarify the flight distance from the source of the aphid vectors, a trial was carried out in the Kwanghwal area, Kimje-gun, Cholla-pukto. on the western coast. 13 traps were placed at four directions and the distances between the traps were 250 m. (Fig. I) The traps 'Were operated from June 21 to October 31. The results are shown in Table 1. A total of some 70 species of aphids were found, including 5 speceis of potato virus vectors. The vectors are as follows: I. Myzus persicae (Sulzer) 2. Aphis gossypii Glover 3. Aulacorthum solani (Kaltenbach) 4. Lipaphis erysimi (Kaltenbach) 5. Macrosiphoniella sanborni (Gillette) Out of a total of 12,797 aphids, 5,187$(48\%)$ vectors were found. The trap catches at the 13 locations are shown in Fig. 2 and the numbers of the vectors at each location for each vector, except Macro-siphoniella sanborni. of which only a single individual was caught, are shown in Fig. 3-6. Number of vectors at C (3,279) (Centre of the village) is considerably higher than that at Suwon (763); however, EI. SI. WI and NI. where the distanecs from Care 250 m, showed lower numbers of vectors than that at Taegwanryong (347). The number of vectors at NI was rather than at the other 3 locations at the distance of 250m from the village. This was because C was in the southern part of the village. Consequently NI was much closer to the village than the other 3 locations of the same distance from C. Numbers of catches of the most important vector. Myzus persicae, are shown in Fig.3. The distribution pattern is typical except $S-2\;and\;W_3$, where several farmer's houses were found. If only the rice paddies were found in these locations. the numbers of the vectors would be small as the distances increase. Numbers of catches of the other 3 vectors are shown in Fig. 4-6. From these results. the author has drawn the following conclusions: 1. The aphid vector sources at the rice paddy belt in the western coast are the villages. 2. The vector densities at the locations where the distances are 250 m from the centre of the village are lower than that at Taegwanryong. 3. The vector densities become gradually lower as the distances from the centre of village increase. However. depending on the host plant situation at each location, the vector densities are variable. These minor sources of aphid vectors may be eliminated so that seed potatoes can be grown. 4. Thus. under the direction of specialists, fields suitable for seed potato production can be found in the coastal areas.

• Journal of Korean Society of Forest Science
• /
• v.85 no.4
• /
• pp.605-618
• /
• 1996

Namsan area supposed to be a disturbed ecosystem and Kwangneung area considered to be a natural ecosystem were selected for the study. On the basis of the plant species composition, the study was planned to examine structural plant species diversity so as to provide basic ecological information to restore more stable and healthy ecosystem for Namsan. The stratified sample plot method was employed for collecting vegetation data, establishing $20m{\times}20m$ square plots for overstory trees, $4m{\times}4m$ plots for mid-story woody plants, and $1m{\times}1m$ plots for ground vegetation. The herbaceous plants were periodically investigated by taking into account for seasonal(spring, summer, and autumn) variation in presence. Ecological attributes were evaluated through analyzing species composition, species diversity, life forms, interspecies association, and growing habitat for various forest types, vertical layers, life forms, and seasonal variation. Even though the species diversity index of canopy trees in the deciduous forest of Namsan was estimated higher than that of the natural forest of Kwangneung, overall species diversity of plants in Kwangneung area was greater than that in Namsan area. Herbaceous plants presented in Kwangneung but not in Namsan were Aconitum pseudo-proliferum, Botrychium virginianum, Dryopteris tokyoensis, Scutellaria insignis, Tricyrtis dilatata, and Viola kamibayashii, most of them were endemic species of Kwangneung. Elaeagnus umbellata, and Prunes padus var. seoulensis were found only in Namsan. Such species typically composed of the natural deciduous forest as Acer mono, Acer triflorum, Carpinus laxiflora, Cornus controversa, Fraxinus mandshurica, and Phellodendron amurertse were limited growing in a small size of area in Namsan. The future project should be made for encouraging the growth and expansion of the distribution of such species to restore biodiversity in Namsan area.

• Culinary science and hospitality research
• /
• v.17 no.1
• /
• pp.142-154
• /
• 2011

The purpose of this research is to examine the awareness and preference for a variety of Kimchi and Kimchi intake patterns among the students living in Chungbuk province. Four hundred samples, consisting of elementary, middle, and high school students, were surveyed; and a total of 366 usable, completed copies of the questionnaire were used for the research. The collected data were statistically analyzed using SPSS 10.0. The results of the analysis were as follows: First, Kimchi was considered traditional (24.3%), nutritious (20.5%), fermented (l9.2%), and healthy (16.1%). Second, the main reason Kimchi was preferred was its "hot taste" (25.4%), "chewy texture" (17.4%), and "sour taste" (14.0%). The students preferred their Kimchi a little hot, moderately salty, and properly fermented with a moderate amount of seasoning and did not care much about any particular parts of Kimchi. Third, 75.4% of the students ate Kimchi more than twice a day, and 78.0% of the students consumed more than 3 pieces($2.5{\times}3.0cm$) of Kimchi per meal. Fourth, elementary students wanted the school foodservice to develop bite-sized Kimchi while middle school students wanted to eat their favorite parts of Kimchi without the fishy smell. High school students wanted to eat cool and fresh Kimchi. Finally, the students wanted Kimchi to contain the following fruit and vegetables: pears (48.9%), apples (34.2%), and pineapples (30.0%), young radishes (44.9%), turnips (37.5%), and sesame leaves (34.9%). This study concludes that it is necessary to educate young students about traditional Korean food culture, serve them various types of Kimchi, change the service style, and develop new Kimchi recipes to increase Kimchi intake in school foodservices.

• Journal of the Korean Society of Food Science and Nutrition
• /
• v.39 no.10
• /
• pp.1555-1564
• /
• 2010

This study investigated consumer's recognition of food labeling in order to contribute to the development of food labels which are more informative to consumers. The questionnaires had been collected from 120 male and female customers living in Seoul with the age between 10's and 60's from November 2nd to November 7th 2009. For checking the food label at the time of purchase, 58.3% of the consumers checked the food label and the main reason for checking the food label was to confirm sell-by date (60.1%). Sixty percent of the consumers were satisfied with the current food labeling. Among those who are not satisfied, 30.6% complained about difficult terms to understand and 25.8% were dissatisfied with insufficient information. In every age group, most people were not satisfied with labeling on food ingredient and additives, followed by date of manufacture and sell-by date. 53.1% of consumers demanded to label date of manufacture and sell-by date together. For more clear information, consumers wanted use-by date (47.5%) rather than sell-by date (23.3%). 56.7% of consumers was dissatisfied with warning information such as allergic warning and the reasons for dissatisfaction were poor visibility (37.5%) and insufficient information (33.4%). Moreover most consumers (90.0%) showed little knowledge on irradiation. To improve of the food labeling standards into consumer-oriented standards, both amendment of the food labeling standards and consumer education will be necessary.

• Journal of Korean Home Economics Education Association
• /
• v.29 no.3
• /
• pp.125-140
• /
• 2017

The purpose of this study was to investigate the relationship of covert narcissism and the sense of alienation with SNS addiction proneness and the influence of them on SNS addiction proneness in order to find a way to conduct an intervention for the SNS addiction proneness of middle school students, and verify the mediating effect of self-esteem on the relationship between covert narcissism, the sense of alienation, and SNS addiction proneness. For this purpose, data were collected online from the first to third grade middle school students who had the experience of using SNS within the past one week, and finally, the data of a total of 341 participants were used for analysis. First, as a result of the analysis of the correlation between covert narcissism, the sense of alienation, self-esteem and SNS addiction proneness, covert narcissism and the sense of alienation showed a significant positive correlation with SNS addiction proneness. On the other hand, there was a significant negative correlation between self-esteem and SNS addiction proneness. Second, the investigation of the effects of covert narcissism, alienation, and self-esteem on SNS addiction proneness showed that covert narcissism, the sense of alienation, and self-esteem had a significant effect on the SNS addiction proneness. The higher the levels of covert narcissism and the sense of alienation, the higher the level of SNS addiction proneness. On the other hand, the higher the level of self-esteem, the lower the level of SNS addiction proneness. Third, the mediating effect of self-esteem was verified for the relationship of covert narcissism and the sense of alienation with SNS addiction proneness. Although covert narcissism and the sense of alienation may directly affect SNS addiction proneness, it was found that they had a significant effect on the SNS addiction proneness through self-esteem as a mediating variable. In other words, it was found that as the levels of the covert narcissism and the sense of alienation were increased, the level of the self-esteem was lowered, which led to a higher level of SNS addiction proneness. In order to form a proper network culture for adolescents, education on appropriate use of SNS that can be put into practice in everyday life should be conducted, and healthy and desirable SNS culture should be created. In addition, systematic education and management should be provided so that students can develop the ability to control and regulate themselves.