• 제목/요약/키워드: proper technique

Search Result 1,264, Processing Time 0.034 seconds

Materialized View Selection Algorithm using Clustering Technique in Data Warehouse (데이터 웨어하우스에서 클러스터링 기법을 이용한 실체화 뷰 선택 알고리즘)

  • Yang, Jin-Hyuk;Chung, In-Jeong
    • Annual Conference of KIPS
    • /
    • 2000.04a
    • /
    • pp.28-35
    • /
    • 2000
  • In order to acquire the precise and fast response for an analytical query, proper selection of the views to materialize in data warehouse is very crucial. In traditional algorithms, the whole relation is considered to be selected as materialized views. However, materializing the whole relation rather than a part of relation results in much worse performance in terms of time and space cost. Therefore, we present a new algorithm for selection of views to materialize using clustering method in order to improve the performance of data warehouse including this problem. In the presented algorithm, ASVMR(Algorithm for Selection of Views to Materialize using Reduced table), we first generate reduced tables in data warehouse using automatic clustering based on attribute-values density, then we consider the combination of reduced tables as materialized views instead of the combination of the original base relations. We also show the experimental results in which both time and space cost are approximately 1.8 times better than the conventional algorithms.

  • PDF

Model Algorithms for Estimates of Inhalation Exposure and Comparison between Exposure Estimates from Each Model (흡입 노출 모델 알고리즘의 구성과 시나리오 노출량 비교)

  • Park, Jihoon;Yoon, Chungsik
    • Journal of Korean Society of Occupational and Environmental Hygiene
    • /
    • v.29 no.3
    • /
    • pp.358-367
    • /
    • 2019
  • Objectives: This study aimed to review model algorithms and input parameters applied to some exposure models and to compare the simulated estimates using an exposure scenario from each model. Methods: A total of five exposure models which can estimate inhalation exposure were selected; the Korea Ministry of Environment(KMOE) exposure model, European Centre for Ecotoxicology and Toxicology of Chemicals Targeted Risk Assessment(ECETOC TRA), SprayExpo, and ConsExpo model. Algorithms and input parameters for exposure estimation were reviewed and the exposure scenario was used for comparing the modeled estimates. Results: Algorithms in each model commonly consist of the function combining physicochemical properties, use characteristics, user exposure factors, and environmental factors. The outputs including air concentration ($mg/m^3$) and inhaled dose(mg/kg/day) are estimated applying input parameters with the common factors to the algorithm. In particular, the input parameters needed to estimate are complicated among the models and models need more individual input parameters in addition to common factors. In case of CEM, it can be obtained more detailed exposure estimates separating user's breathing zone(near-field) and those at influencing zone(far-field) by two-box model. The modeled exposure estimates using the exposure scenario were similar between the models; they were ranged from 0.82 to $1.38mg/m^3$ for concentration and from 0.015 to 0.180 mg/kg/day for inhaled dose, respectively. Conclusions: Modeling technique can be used for a useful tool in the process of exposure assessment if the exposure data are scarce, but it is necessary to consider proper input parameters and exposure scenario which can affect the real exposure conditions.

Leakage detection and management in water distribution systems

  • Sangroula, Uchit;Gnawali, Kapil;Koo, KangMin;Han, KukHeon;Yum, KyungTaek
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2019.05a
    • /
    • pp.160-160
    • /
    • 2019
  • Water is a limited source that needs to be properly managed and distributed to the ever-growing population of the world. Rapid urbanization and development have increased the overall water demand of the world drastically. However, there is loss of billions of liters of water every year due to leakages in water distribution systems. Such water loss means significant financial loss for the utilities as well. World bank estimates a loss of $14 billion annually from wasted water. To address these issues and for the development of efficient and reliable leakage management techniques, high efforts have been made by the researchers and engineers. Over the past decade, various techniques and technologies have been developed for leakage management and leak detection. These include ideas such as pressure management in water distribution networks, use of Advanced Metering Infrastructure, use of machine learning algorithms, etc. For leakage detection, techniques such as acoustic technique, and in recent yeats transient test-based techniques have become popular. Smart Water Grid uses two-way real time network monitoring by utilizing sensors and devices in the water distribution system. Hence, valuable real time data of the water distribution network can be collected. Best results and outcomes may be produced by proper utilization of the collected data in unison with advanced detection and management techniques. Long term reduction in Non Revenue Water can be achieved by detecting, localizing and repairing leakages as quickly and as efficiently as possible. However, there are still numerous challenges to be met and future research works to be conducted in this field.

  • PDF

Dry Season Evaporation From Pine Forest Stand In The Middle Mountains Of Nepal

  • Gnawali, Kapil;Jun, KyungSoo
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2016.05a
    • /
    • pp.330-330
    • /
    • 2016
  • The quantification of dry season evaporation in regions, where the magnitude of dry season flows is key to the regional water supply, is essential for good water management. Also, tree transpiration has a significant role in the water balance of a catchment whenever it is tree populated, especially in water limited environments. Such is the case in the Middle Mountains of Nepal where dry season flows play a significant role in downstream water provisioning and their proper functioning is key to the welfare of millions of people. This research seeks to study the transpiration of a pine forest stand in the Jikhu Khola Watershed in the Middle Mountains of Nepal. To the author's knowledge, no single study has been made so far to estimate the dry season evaporation from the planted forest stand in the Middle Mountains of Nepal. The study was carried out in planted pine forest embedded within the Jikhu Khola Catchment. Field campaigns of sap flow measurements were carried out from September, 2010 to February, 2011 in the selected plot of 15*15m dimension, to characterize dry season evaporation. This was done by measuring sap fluxes and sapwood areas over the six trees of different Diameter at Breast Height (DBH) classes. The sap flux was assessed using Granier's thermal dissipation probe (TDP) technique while sapwood area was determined using several incremental core(s) taken with a Pressler borer and immediately dyeing with methyl orange for estimating the actual depth of sapwood area. Transpiration of the plot was estimated by considering the contribution of each tree class. For this purpose, sap flux density, sapwood area and the proportion of total canopy area were determined for each tree class of the selected plot. From these data, hourly and diurnal transpiration rates for the plot were calculated for experimental period. Finally, Cienciala model was parameterized using the data recorded by the ADAS and other terrain data collected in the field. The calibrated model allowed the extrapolation of Sap flux density (v) over a six month period, from September 2010 to February 2011. The model given sap flux density was validated with the measured sap flux density from Grainier method.

  • PDF

Efficient Assessment and Recommendations System using IRT and Data Mining (IRT와 데이터 마이닝을 이용한 효과적인 평가 및 추천시스템)

  • Kim Cheon-Shik;Jung Myung-Hee
    • Journal of the Korea Society of Computer and Information
    • /
    • v.11 no.4 s.42
    • /
    • pp.109-117
    • /
    • 2006
  • E-learning method has many advantages that supplement the shortfalls of offline education. For this reason, today's offline educational institutions adopted the online education technique to improve learning effectiveness. Recently, general universities have partially adopted online learning. As a result, a study is searching for ways to improve the effectiveness of education by copying the merits of the existing offline education onto the online education. Thus a proper evaluation of learners and a feedback provision are considered necessary to improve the effectiveness of online learning. This study aims to suggest a model that will improve learning efficiency by adapting the advantages of offline education to online learning. To evaluate properly, this study conducted Item Response Test to examine the learners and finally ensure them an adequate level of education. Also, this study suggested a way to enhance learning efficiency by finding out each learner's study habits and to address the weaknesses of online learning. It is expected that the suggested method would be helpful in bettering learner's ability to study in school environment.

  • PDF

Polymer Inkjet Printing: Construction of Three-Dimensional Structures at Micro-Scale by Repeated Lamination

  • Yun, Yeon-Hee;Kim, Jae-Dong;Lee, Byung-Kook;Cho, Yong-Woo;Lee, Hee-Young
    • Macromolecular Research
    • /
    • v.17 no.3
    • /
    • pp.197-202
    • /
    • 2009
  • Solution-based, direct-write patterning by an automated, computer-controlled, inkjet technique is of particular interest in a wide variety of industrial fields. We report the construction of three-dimensional (3D), micro-patterned structures by polymer inkjet printing. A piezoelectric, drop-on-demand (DOD) inkjet printing system and a common polymer, PVA (poly(vinyl alcohol)), were explored for 3D construction. After a systematic preliminary study with different solvent systems, a mixture of water and DMSO was chosen as an appropriate solvent for PVA inks. The use of water as a single solvent resulted in frequent PVA clogging when the nozzles were undisturbed. Among the tested polymer ink compositions, the PVA inks in a water/DMSO mixture (4/1 v/v) with concentrations of 3 to 5 g/dL proved to be appropriate for piezoelectric DOD inkjet printing because they were well within the proper viscosity and surface tension range. When a dot was printed, the so-called 'coffee-ring effect' was significant, but its appearance was not prominent in line printing. The optimal polymer inkjet printing process was repeated slice after slice up to 200 times, which produced a well-defined, 3 D micro-patterned surface. The overall results implied that piezoelectric DOD polymer inkjet printing could be a powerful, solid-freeform, fabrication technology to create a controlled 3D architecture.

Risk factors of African swine fever virus in suspected infected pigs in smallholder farming systems in South-Kivu province, Democratic Republic of Congo

  • Bisimwa, Patrick N.;Dione, Michel;Basengere, Bisimwa;Mushagalusa, Ciza Arsene;Steinaa, Lucilla;Ongus, Juliette
    • Journal of Veterinary Science
    • /
    • v.22 no.3
    • /
    • pp.35.1-35.13
    • /
    • 2021
  • Background: African swine fever (ASF) is an infectious viral disease of domestic pigs that presents as a hemorrhagic fever, and for which no effective vaccine is available. The disease has a serious negative social and economic impact on pig keepers. There is limited information on the potential risk factors responsible for the spread of ASF in South Kivu. Objective: The aim of this study was to determine the potential risk factors associated with ASF infection in suspected ASF virus (ASFV)-infected pigs. Methods: We sampled whole blood from 391 pigs. Additionally, 300 pig farmers were interviewed using a structured questionnaire. Viral DNA was detected by using the real-time polymerase chain reaction technique. Results: The majority of pigs sampled, 78% (95% confidence interval [CI], 74.4-82.6), were of local breeds. Over half, 60.4% (95% CI, 55.5-65.2), were female, and most of them, 90.5% (95% CI, 87.6-93.4), were adult pigs (> 1 year old). Viral DNA was detected in 72 of the 391 sampled pigs, indicating an overall infection rate of 18.4% (95% CI, 14.5-22.4). Multivariable logistic regression analysis revealed several risk factors positively associated with ASFV infection: feeding with swill in pen (odds ratio [OR], 3.8; 95% CI, 2.12-6.77); mixed ages of pigs in the same pen (OR, 3.3; 95% CI, 1.99-5.57); introduction of new animals to the farm (OR, 5.4; 95% CI, 1.91-15.28). The risk factors that were negatively (protective) correlated with ASFV positivity were the presence of male animals and the use of an in-pen breeding system. Conclusion: Local pig farmers should be encouraged to adopt proper husbandry and feeding practices in order to increase the number of ASF-free farms.

Technical Review of How to Determine the Exact Location of Needle Tip During Office-Based Injection Augmentation of the Vocal Folds Via Cricothyroid Approach (외래에서 시행하는 경윤상갑상막 접근 성대주입술 중 주입 위치를 정확하게 파악하는 방법에 관한 기술적 고찰)

  • Park, Sung Joon;Kwon, Tack-Kyun
    • Journal of the Korean Society of Laryngology, Phoniatrics and Logopedics
    • /
    • v.29 no.2
    • /
    • pp.70-75
    • /
    • 2018
  • The office-based, un-sedated vocal fold injection laryngoplasty has re-emerged in the past decade as an appealing alternative to microsuspension laryngoscopic procedure which is conducted under general anesthesia. The trend toward vocal fold injection laryngoplasty in an in-office setting was possible due to technological evolution for visualization and new injection materials. However, invisibility of the injection needle has been the main shortcomings of cricothyroid approach. The purpose of this review is to provide an up-to-date review of office-based, trans-cricothyroid membrane approach injection laryngoplasty technique under local anesthesia and efforts made to increase the preciseness of amount and location of the injected materials in the management of glottic insufficiency. A review of variable efforts undertaken to maximize the result of cricothyroid approach by technically increasing accuracy of the location of needle tip was done. With the proper patient selection and utilization of the new technologies, office-based and un-sedated vocal fold injection laryngoplasty via cricothyroid approach can be redeem as a main-stay in the management of glottic insufficiency, such as vocal fold paralysis, vocal fold paresis, vocal fold atrophy and vocal fold scar.

Predictive Optimization Adjusted With Pseudo Data From A Missing Data Imputation Technique (결측 데이터 보정법에 의한 의사 데이터로 조정된 예측 최적화 방법)

  • Kim, Jeong-Woo
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.20 no.2
    • /
    • pp.200-209
    • /
    • 2019
  • When forecasting future values, a model estimated after minimizing training errors can yield test errors higher than the training errors. This result is the over-fitting problem caused by an increase in model complexity when the model is focused only on a given dataset. Some regularization and resampling methods have been introduced to reduce test errors by alleviating this problem but have been designed for use with only a given dataset. In this paper, we propose a new optimization approach to reduce test errors by transforming a test error minimization problem into a training error minimization problem. To carry out this transformation, we needed additional data for the given dataset, termed pseudo data. To make proper use of pseudo data, we used three types of missing data imputation techniques. As an optimization tool, we chose the least squares method and combined it with an extra pseudo data instance. Furthermore, we present the numerical results supporting our proposed approach, which resulted in less test errors than the ordinary least squares method.

Influence of surface treatments and repair materials on the shear bond strength of CAD/CAM provisional restorations

  • Jeong, Ki-Won;Kim, Sung-Hun
    • The Journal of Advanced Prosthodontics
    • /
    • v.11 no.2
    • /
    • pp.95-104
    • /
    • 2019
  • PURPOSE. To evaluate the effect of surface treatments and repair materials on the shear bond strength and to measure the fracture toughness of CAD/CAM provisional restoration materials. MATERIALS AND METHODS. Four CAD/CAM (3D printing: Nextdent C&B and ZMD-1000B Temporary, CAD/CAM resin block: Yamahachi PMMA disk and Huge PMMA block) and four conventional (monometacrylate: Jet and Alike, dimetacrylate: Luxatemp and Protemp 4) materials were selected to fabricate disk-shaped specimens and divided into six groups according to surface treatment (n=10). CAD/CAM materials were repaired with Jet or Luxatemp, while conventional materials were repaired with their own materials. The shear bond strength was measured by using universal testing machine. Ten rectangular column-shaped specimens for each material were fabricated to measure the fracture toughness by single edge v notched beam technique. Statistical analysis was performed by one-way ANOVA. RESULTS. The highest shear bond strength of CAD/CAM materials was achieved by SiC paper + sandblasting. It was also accomplished when repairing 3D printing materials with Luxatemp, and repairing CAD/CAM resin blocks with Jet. Yamahachi PMMA disk showed the highest fracture toughness. Nextdent C&B showed the lowest fracture toughness value but no statistically significant difference from Alike and Luxatemp (P>.05). CONCLUSION. In order to successfully repair the CAD/CAM provisional restoration, mechanical surface treatment and appropriate repair material according to the CAD/CAM material type should be selected. The CAD/CAM provisional materials have proper mechanical properties for clinical use as compared to conventional materials.