• The Journal of Society for e-Business Studies
• /
• v.14 no.4
• /
• pp.1-17
• /
• 2009

E-Catalogs which describe products or services are one of the most important data for the electronic commerce. E-Catalogs are created, updated, and removed in order to keep up-to-date information in e-Catalog database. However, when the number of catalogs increases, information integrity is violated by the several reasons like catalog duplication and abnormal classification. Catalog search, duplication checking, and automatic classification are important functions to utilize e-Catalogs and keep the integrity of e-Catalog database. To implement these functions, probabilistic models that use statistics of index words extracted from e-Catalogs had been suggested and the feasibility of the methods had been shown in several papers. However, even though these functions are used together in the e-Catalog management system, there has not been enough consideration about how to share common data used for each function and how to effectively manage statistics of index words. In this paper, we suggest a method to implement these three functions by using simple SQL supported by relational database management system. In addition, we use materialized views to reduce the load for implementing an application that manages statistics of index words. This brings the efficiency of managing statistics of index words by putting database management systems optimize statistics updating. We showed that our method is feasible to implement three functions and effective to manage statistics of index words with empirical evaluation.

• Proceedings of the Korea Water Resources Association Conference
• /
• 2023.05a
• /
• pp.15-15
• /
• 2023

2020년 기준 국내 상수도 보급률은 99.1% 차지하고 있으며(환경부, 2019), 수도관리차원에서 수돗물은 먹는 물로 시판되어질 만큼 우수한 관리체계를 유지하고 있다. 그 반면에 지하수는 생활용수, 식품가공, 농·축산, 양어, 군부대를 비롯한 전국지역에서 연간 10억 8천만톤 용수를 소비하고 있음에도 (환겨례 신문, 2013; 환경부, 2019) 사용되는 지하수의 약 65%가 음용수 불가판정을 받았으며, 최근 지하수의 오염비율은 급격히 증가하는 추세이다. 특히, 지하수관정의 관리부주의에 의한 수질오염 및 수인성 다제내성균(슈퍼박테리아) 등에 의한 오염사례가 국내는 물론, 국제적으로 다수 보고되고 있는 실정이다 (환경부, 2013). 현재 지하수 수질관리는 공공기관 및 지자체 지정기관을 통해 진행되고 있으며, 검사기간은 수질채취로부터 통상 7~15일정도 소요되어 수질 관리 및 기준, 검사주기에 대한 애로가 많다. 현장 지하수관정에서 실시간 수질을 모니터링하고 이에 연동된 자동 수처리 시스템의 개발 및 도입은 나날이 심각해지는 환경오염 상황에서 선제적 예방과 해결방법으로 중요한 요소기술이다. 현재 지하수오염 및 부적합 음용의 수질처리는 화학약품, 필터여과, UV살균, O₃ (플라즈마)을 이용하는 것이 대표적이나, 화학약품의 경우 2차 오염이나 식품 세척 및 가공에 있어 부적합성의 한계점이 있다. 필터여과의 대표적인 RO필터의 경우 약 50% 순손실이 발생하고, UV 살균의 경우 UV에 의한 사용관리자의 위험 및 장비의 광부식 문제, O₃ 의 경우 고압전류 사용에 따른 위험성 등의 한계점이 나타나고 있다. 지하수 수질정화를 위한 광유도 활성산소(¹O₂, ·O^-₂)는 광감응제에 가시광의 빛 조사를 통해 생성되는 활성산소로의 에너지 및 전자 전이가 동시 진행되어 단일항 산소(¹O₂)와 슈퍼옥사이드 이온(·O^-₂)을 생성하게 된다. 생성된 활성산소는 유해미생물 또는 유기화학물과 개열, 제거, 치환 반응 등을 통해 미생물사멸 및 유해화학물질들이 분해 가능하다. 이를 이용한 지하수 유해미생물 사멸기술, 장비, 실시간 지하수의 분석기술 및 정수처리, 지하수 물순환 시스템 개발뿐만 아니라 지하수 음용수 및 오염개선, 지하수 기저유출에 의한 오염원 저감으로부터 지류·지천, 하천 본류 수질개선 등의 대상지역에 활용 가능하다. 또한 광유도 활성산소는 기존 상수도 수처리에 있어 오존(O₃) 처리와 이산화티탄을 이용한 AOP과정을 단일처리 공정으로, 기존 O₃ 의 특성상 확산 거리가 매우 길어 사람을 포함한 생체 내에 유입 시 다양한 부작용 발생과 O₃ 차폐시설 요구의 문제점 극복의 대안으로 환경 및 인체에 무해한 광유도 활성산소 시스템을 적극적으로 도입 및 적용해야 한다. 본 연구 목적은 정류상태 흡광분광기술을 이용한 실시간 수질 모니터링과 광유도 활성산소를 이용한 유해 미생물의 멸균효능 및 지하수 수질관리 기술로의 적용 가능성을 제시하고자 한다.

• Journal of Food Hygiene and Safety
• /
• v.20 no.3
• /
• pp.185-190
• /
• 2005

Perilla oil was measured on hygiene state and quality change for oil press condition. All sample .was commercially salted perilla oil, and was tested standard items. The result showed violative rate of $23.1\%$, and violative items were acid value and iodine value. Relationship between D.B.I. and iodine value was 0.78, so that unsuitability of iodine value should be caused of oxidation factor. But acid value was not relationship comparatively. The quality change appeared very small by roasting conditions, but quality of perilla seed gaye many influence on quality of oil. Therefore use of fresh perilla seed is a matter of great importance to quality of perilla oil. Perilla oil was demanded many attention on Quality management for stage and sold period because of high possibility of quality change.

• Clean Technology
• /
• v.26 no.1
• /
• pp.39-54
• /
• 2020

This study analyzed the groundwater quality according to the depth and geological features in Gyeongsangnam-do area using groundwater quality monitoring network data to grasp the groundwater quality characteristics and to provide basic data for policy making on efficient groundwater management. Five hundred and three data sets were acquired from background water quality exclusive monitoring network in soil groundwater information system for five years (2013 ~ 2017). Except for the total coliforms and tracer items such as mercury, phenol, and others, the parameters of water quality were significant or very significant, depending on depth and geological features. As the depth got deeper, the average value of pH and electrical conductivity increased; water temperature, dissolved oxygen, oxide reduction potential, arsenic, total coliforms, and turbidity decreased; and total unfit rate for drinking water standards was lower. It was found that the sum of the positive and negative ions was the highest in the clastic sedimentary rock and the lowest in metamorphic rock. The total unfit rate for drinking water standards was the highest for metamorphic rocks, followed by clastic sedimentary rock and unconsolidated sediments and, finally, intrusive igneous rock with the lowest penetration. The Na-Cl water type, which indicated the possibility of contamination by external pollutants, appeared only at some points in shallow depths and in clastic sedimentary rocks.

• Journal of Food Hygiene and Safety
• /
• v.19 no.2
• /
• pp.84-96
• /
• 2004

This study aims at developing an easily-applicable Sanitation Standard Operating Procedure(SSOP) program for Fresh raw-fish manufacturing. It compares the sanitation inspection results of SSOP-program-applied procedure and non-applied procedure. The samplings for bacteriological examination were collected from the touching surface of food and from the personal workers. The sanitation status was recorded in the check-up list. The results were statistically analyzed to ascertain the efficiency of the SSOP program. The present official KFDA check-up list for sanitation inspection is composed of 51 items. Each item is judged to be fit or unfit to the standards. When the unfit items are more than 6, the work-place is judged to be insanitary. But in this study, the results of sanitation inspection are scaled in points in the 70％ allotment, and the results of bacteriological examination are scaled in points in 30％, totaling 100％. Below 60 scores are judged to be insanitary and administratively punished; 61-75 scores are judged to be average; 76-85 good; above 86 excellent. The sanitation inspection scores by the improved check-up list went up by two grades from 71.8 (before SSOP program) to 88.6 (after SSOP program). The results of bacteriological examination also improved from 57.5 to 98.2. The total scores of both results converted in the allotment of 70％ and 30％ also showed an improvement by two grades from 66.4 (before SSOP program) to 93.4 (after SSOP program). The above results show that the manufacturers participated in this study are following the 8 essential sanitary procedures which are needed to anchor the HACCP system.

• Journal of Soil and Groundwater Environment
• /
• v.12 no.1
• /
• pp.103-115
• /
• 2007

Risk assessment by living indicator species provides the information about the ecosystem disturbance, disapperance of symbiosis and change of living group. In the initial stage of this kind research, the degree of contamination was reported using the level of simple number, but simple number may not represent the risk itself which can be casued in the living organisms. Risk assessment using various indicator species overcomes these limitations and can be expanded to the DNA level. In many developed counties, the government has supervised the researches about the indicator species for the monitoring and its application to ecosystem restoration. Several living indicator species found in the vicinity of the abandoned Au mines such as fern, earthworm, bacteria, rhizosphere-rhizoplane, salamamdor and DNA change of these species are described in this paper.

• Journal of Convergence for Information Technology
• /
• v.10 no.3
• /
• pp.115-125
• /
• 2020

Problem-Based Learning is the most commonly used teaching method in the field of education as the demand for talented people with creative problem-solving abilities has increased in recent society. In this study, we developed a tool that can simply and regularly measure the learning effects of applying Problem-Based Learning on the classroom. Twenty-two preliminary items for the development were constructed by gathering expert opinions about items collected in existing research of Problem-Based Learning effects measurement. Using this preliminary items, data were collected from 124 students who took the subject-based study. And the validity and reliability were verified through Rash analysis. 11 of 124 students and 1 of 22 items were found to nonconforming and excluded. In addition, the optimal scale for the configuration of this tool was found to be a four-point scale, and the reliability of separation on the subject and the item was found to be excellent. We hope that the assessment tools of Problem-Based Learning effectiveness developed in this study will be actively used to measure learning effectiveness and manage the quality of education.

• Journal of Preventive Medicine and Public Health
• /
• v.19 no.2 s.20
• /
• pp.273-280
• /
• 1986

'Medicinal water' have been used for the treatment of disease and the promotion of health. To study the quality and health effect of 'medicinal water', the eleven springs located near Taegu City during the period of March 27-February 17, 1986 were tested for biological and physiochemical examination and were checked for sanitary environment around the spring. Among them three springs (27.3%) had a good sanitary equipments and only one was negative for biological examination. Three 'medicinal warer' were accepted as potable by physicochemical examination. According to above findings, all of the 'medicinal water' sampled from the springs located near Taegu City were not potable by this sanitary survey adopted Drinking Water Standard in Korea. Kachang and Youngchum 'medicinal water' were more contaminated by heavy metals and bacteria than those of other springs. To solve the problem of contamination by heavy metals that originated from uncertain sources, we should search for the sources of water contamination, remove it completely and also support the environmental equipments and management system in protection of safe 'medicinal water' supply.

• Journal of Food Hygiene and Safety
• /
• v.29 no.2
• /
• pp.152-157
• /
• 2014

This study was carried out to investigate the residual sulfur dioxide residues ($SO_2$) in commercial medicinal herbs in Korea in 2013. Among a total of 116 samples of 11 different kinds of herbs, 71 samples (11 Kinds) were domestic, and 45 samples (10 Kinds) were imported. The residual contents of $SO_2$ in the samples were determinated by a modified Monier-Williams method. Of the 116 samples, 6 samples (5.2%, 4 Kinds) failed to meet the regulations for sulfur dioxide residues of KFDA in medicinal herbs. Among 6 unsuitable samples, 1 samples (1.4%) were domestic, and 5 samples (11.1%, 3 Kinds) were imported. The highest amount of sulfur dioxide residues was 1546.3 mg/kg (Lycii Fructus) in the domestic samples. Regardless of region, $SO_2$ contents were not found at Anemarrhenae Rhizoma, Citri Unshius Pericarpium, Eucommiae Cortex, Forsythiae Fructus, Gardeniae Fructus, Leonuri Herba and Lonicerae Folium et caulis. These data will be used as a basic data for the future legislation on the regulation and control of sulfur dioxide of herbal medicines.

• The Journal of the Korea Contents Association
• /
• v.14 no.5
• /
• pp.458-467
• /
• 2014

Pain is one of the most common and painful symptoms that cancer patients suffer from. Pain seriously affects 30-50% of the patients at the early cancer diagnosis stage or who receive active anticancer treatments, 60-70% of the patients with progressive cancer, and 80-90% of the patients at the late stage of cancer. However, there is no systematic and easy pain control program for the cancer patients. In this study, an algorithm is proposed to provide quick pain relief service upon the occurrence of sudden pain, for the purpose of controlling the sudden pain that cancer operation survivors experience. In developing the algorithm, questionnaires, evaluation forms and National Comprehensive Cancer Network (NCCN) guideline were considered, and a trial service was provided to a group of 20 cancer patients for a month to evaluate the designed algorithm. The results of the trial service were examined by expert medical workers to evaluate the proposed algorithm, and a 90% compatibility decision was derived, which verified the effectiveness of the proposed algorithm. In the case of incompatibility decision, the management of the pain diary did not have compatible results. Therefore, the further study will additionally address the customized pain diary algorithm.