• Title/Summary/Keyword: manual-based test

Search Result 292, Processing Time 0.03 seconds

Automation Tool Design for PL/SQL Applications Conversion (PL/SQL 응용프로그램 전환을 위한 자동화 도구 설계)

  • Jee, Jungeun;Lee, Jeongkun;Choi, Yongrak;Shin, Yongtae
    • KIPS Transactions on Software and Data Engineering
    • /
    • v.7 no.8
    • /
    • pp.287-296
    • /
    • 2018
  • In the recent commercial DBMS market, as the users' burden and complaint which are related to high price licensing policy and late technical support service are increasingly rising, the concern for use of open source DBMS which has no problem with compatibility or stability is escalating. Due to the fact, the cases saving the cost are growing by converting Oracle Corporation's applications, which has about 60% share in the DBMS market, to an open source DBMS. However, in converting non-interchange sentences to an ANSI standard-based open source DBMS because of the use of PL/SQL in Oracle Corporation provides, a lot of manual work accompanies, so there is a lot of loss of time and money. Therefore, a tool that automatically converts PL/SQL to standard SQL is required. The proposed automation tool for the conversion of applications converts PL/SQL to Java Stored Procedure, an open source DBMS-based ANSI standard programming language. Through carrying out a test on the automation tool, it is proved that the tool will contribute to shortening time and saving cost by verifying the identity of input-output data and its reliability after correcting errors in converting to Java Stored Procedure.

Development of NCS Based Vocational Curriculum Model for the Practical and Creative Human Respirces (실전 창의형 인재 양성을 위한 NCS 기반 직업교육과정의 모형 개발)

  • Kim, Dong-Yeon;Kim, Jinsoo
    • 대한공업교육학회지
    • /
    • v.39 no.2
    • /
    • pp.101-121
    • /
    • 2014
  • The study aims to develop the NCS based vocational curriculum model for the practical and creative human resources. For effectiveness of the study, the study consists of literature studies of both domestic and international, contents analysis, case study, expert(9samples) consultation and review, and in-depth-interview of the three advisory members. The validity of the developed model is analyzed through mean, standard deviation and contents validity ratio(CVR). The main results of the model development in our study are as follow. First, our NCS based vocational curriculum model for the practical and creative human resources is developed with the analyses of NCS development manuals, training standard utilization and training curriculum organization manuals, NCS learning module development manual and case studies, NCS research report, NCS based curriculum pilot development resources directed toward the high schools and vocational school as well as the domestic and international literature study on career training model like NCS. Second, based on the findings of our analysis in combination with the findings from the consultations with the expert and advisory committee, total 19 sub-factors of each step and domain are extracted. The sub-factors of domain in step 1 are the competency unit, definition of competency unit, competency unit element, performance criteria, range of variable, guide of assessment, key competency; in step 2, they are subject title, subject objectives, chapter title, chapter objectives, pedagogical methods, assessment methods and basic job competence; and in step 2, they are NCS based subject matrix table, NCS based subject profile, NCS based job training curriculum table, NCS based subjects organization flowchart, NCS based job training operation plan. Third, the final model including step 3 NCS based subject profile are developed in association with the linked organizational sub-factors of step 1 and step 2. Forth, the validity tests for the final model by the step and domain yield the mean 4.67, CVR value 1.00, indicating the superior validity. Also, the means of each sub-factors are all over 4.33 with the CVR value 1.00, indicating the high validity as well. The means of the associated organizations within the model are also over 4.33 with the CVR value of 1.00. Standard deviations are all .50 or lower which are small. Fifth, based on the validity test results and the in-depth-interview of the expert and advisory committee, the model is adjusted complemented to establish final model of the NCS based vocational curriculum for the practical and creative human resources.

Analysis of Factors Related to Pain Relief on Modified Mammography (변형 유방촬영술시 통증완화에 따른 요인 분석)

  • Jang, Myung Mi;Kim, Hwa Sun
    • Journal of the Korean Society of Radiology
    • /
    • v.11 no.5
    • /
    • pp.413-421
    • /
    • 2017
  • Mammography, the basic test for finding and treating increased breast cancer, gives the anxiety of cancer and radiation exposure to most women. In addition, it gave very severe compression pain, so we studied the degree of pain and tried to reduce the pain. The purpose of this study is to compare and analyze the modified imaging technique and the basic imaging technique based on clinical experience, respectively. The subjects of this study were 160 women from 30 to 60 years old who visited to Seoul Boramae Hospital operated by Seoul National University Hospital from February to March 2017 for breast screening. Modified 80 persons and 80 persons were divided into two groups, and each group was asked to fill out questionnaires sequentially without knowing the subjects. The first method is a modified method in which an automatic pedal is divided into four or more presses, a manual pressure is used together, and an attitude is described in detail. Secondly, we used only the automatic pedal compression method and press it within 1-3 times. In the mean of the pain distribution, the experimental group (modified method) was 2.49 and the control group (basic method) had an average of 4.86, which showed 48.8% less pain. In this modified method, the pain scores of the experimental group were lower than those of the control group, and the degree of the pain was statistically significant.

Line Matching Method for Linking Wayfinding Process with the Road Name Address System (길찾기 과정의 도로명주소 체계 연계를 위한 선형 객체 매칭 방법)

  • Bang, Yoon Sik;Yu, Ki Yun
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.24 no.4
    • /
    • pp.115-123
    • /
    • 2016
  • The road name address system has been in effect in Korea since 2012. However, the existing address system is still being used in many fields because of the difference between the spatial awareness of people and the road name address system. For the spatial awareness based on the road name address system, various spatial datasets in daily life should be referenced by the road names. The goal of this paper is to link the road name address system with the wayfinding process, which is closely related to the spatial awareness. To achieve our goal, we designed and implemented a geometric matching method for spatial data sets. This method generates network neighborhoods from road objects in the 'road name address map' and the 'pedestrian network data'. Then it computes the geometric similarities between the neighborhoods to identify corresponding road name for each object in the network data. The performance by F0.5 was assessed at 0.936 and it was improved to 0.978 by the manual check for 10% of the test data selected by the similarity. By help of our method, the road name address system can be utilized in the wayfinding services, and further in the spatial awareness of people.

Factors Affecting Adherence to Pharmacotherapy in Children with Attention-Deficit Hyperactivity Disorder: A Retrospective Study (주의력결핍 과잉행동장애 아동의 약물치료 순응도에 영향을 미치는 요인 : 후향적 연구)

  • Kim, Yoon-Jung;Oh, So-Young;Lee, Ji-Ah;Moon, Su-Jin;Lee, Won-Hae;Bahn, Geon-Ho
    • Journal of the Korean Academy of Child and Adolescent Psychiatry
    • /
    • v.21 no.3
    • /
    • pp.174-181
    • /
    • 2010
  • Objectives: To identify the factors affecting long-term adherence to methylphenidate treatment in children with attention-deficit hyperactivity disorder (ADHD). Methods: A retrospective medical record review of 239 ADHD patients (mean age $9.3{\pm}2.6$ years, range 6.0-17.4 years) who had visited the child and adolescent psychiatry clinic at a university hospital, in Seoul, Korea from March 2005 to February 2008. Subjects were diagnosed as ADHD based on the criteria set forth in the Diagnostic and Statistical Manual of Mental Disorders 4th edition, text revision version (DSM-IV-TR) and underwent neuropsychological tests including the continuous performance test (CPT). Treatment discontinuation was defined as the last prescription date when the medication possession rate (MPR) became less than 0.80. Subjects were divided into three groups and labeled as Group I, non-adherence without pharmacotherapy, Group II, non-adherence with short-term pharmacotherapy, and Group III, adherence with long-term pharmacotherapy. Results: Ninety (37.7%) patients were grouped as non-adherent (Groups I+II) and 149 (62.3%) as adherent (Group III). The adherence group exhibited lower intelligence, higher symptom severity, and a higher number of comorbid psychiatric disorders than controls. The use of stimulants was significantly associated with long-term adherence to treatment. Additionally, the duration of interval between the date of the first visit and the date of the first prescription was positively associated with long-term adherence. Conclusion: About two-thirds of patients diagnosed as ADHD adhered to the treatment six months after the first visit. With respect to patient evaluation and the development of treatment strategies, factors affecting early drop-out and longer follow-up must be considered.

A Study of Torsional Vibrations of Suspended Bridges (현수교(懸垂橋)의 비틀림진동(振動)에 관한 연구(硏究))

  • Min, Chang Shik;Kim, Saeng Bin;Son, Seong Yo
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.3 no.3
    • /
    • pp.27-37
    • /
    • 1983
  • A method of dynamic analysis is developed for torsional free vibrations of elliptical-box girder type or stiffening truss system suspension bridge. In this study, the method based on a finite element technique using a digital computer, is illustrated by two numerical examples, the Namhae Bridge which is located in Kyungsang nam-do opened on June, 1973, and the Mt. Chunma Bridge is simple span pedestrian's suspension bridge with lateral bracing system in Mt. Chunma, Kyungki-do, are used. In general, dynamic modes of complex suspension bridges are three-dimensional in form, i.e., coupling between vertical and torsional motions. However, introduced that amplitudes of oscillation are infinitesimal for coincidence with the purpose of it's use, thereupon, the torsional vibration analyses are treated without coupling terms. A sufficient number of natural frequencies and mode shapes for torsional free vibration are presented in this paper. In the case of Mt. Chunma Bridge, the natural frequencies and periods are computed with and without reinforcement, respectively, and compared their discrepancies. The influence of the auxiliary reinforcing cables is prevailing in the first few modes, namely, 1st and 2nd in symmetric and 1st, 2nd and 3rd in antisymmetric vibration, and conspicuous in the symmetric compared with the antisymmetric motion, but in the higher modes, this kind of simple accessory elucidates rether converse effects. In the Namhae Bridge, the results are compared with the Manual's obtained by wind tunnel test. It reveals commendable agreement.

  • PDF

Wire Recognition on the Chip Photo based on Histogram (칩 사진 상의 와이어 인식 방법)

  • Jhang, Kyoungson
    • Journal of the Institute of Electronics and Information Engineers
    • /
    • v.53 no.5
    • /
    • pp.111-120
    • /
    • 2016
  • Wire recognition is one of the important tasks in chip reverse engineering since connectivity comes from wires. Recognized wires are used to recover logical or functional representation of the corresponding circuit. Though manual recognition provides accurate results, it becomes impossible, as the number of wires is more than hundreds of thousands. Wires on a chip usually have specific intensity or color characteristics since they are made of specific materials. This paper proposes two stage wire recognition scheme; image binarization and then the process of determining whether regions in binary image are wires or not. We employ existing techniques for two processes. Since the second process requires the characteristics of wires, the users needs to select the typical wire region in the given image. The histogram characteristic of the selected region is used in calculating histogram similarity between the typical wire region and the other regions. The first experiment is to select the most appropriate binarization scheme for the second process. The second experiment on the second process compares three proposed methods employing histogram similarity of grayscale or HSV color since there have not been proposed any wire recognition method comparable by experiment. The best method shows more than 98% of true positive rate for 25 test examples.

Efficiently Development Plan from the User's Need Analysis of the Army Tactical C4I(ATCIS) System (지상전술 C4I(ATCIS)체계 운용자 요구분석을 통한 효율적 발전 방안)

  • Park, Chang-Woon;Yang, Hae-Sool
    • The Journal of the Korea Contents Association
    • /
    • v.8 no.5
    • /
    • pp.246-259
    • /
    • 2008
  • This study was to minimize the trial and error in the primary step of the C4I system(ATCIS) of the each army corps on the front line, and test the economy and efficiency was tested by reviewing related papers and the system characteristics of other countries. The relationship was researched by analyzing the collected survey data and survey data related to the user's requirement level such as the army standards, that is, commonality, timeliness, simplification, automaticity, field availability and viability, multi-stage security and interoperability, unification. The result showed that the C4I system was efficiently operated through the system reliability for the specification of the system and operation manual, maneuverability and security, adaptability of the war field and system support and management, and good education and training about system operation, and less system maintenance and supplementary element. As a result, the development plan confirmed that the continuous operator education and the construction of the maintenance, and the upgrade digitalization(C4ISR+D) with the korean characteristics based on IT of network systems, and system development of the measurement model of the operator performance must be continuously supplemented in the near future.

Improvement of the HCM Delay Estimation Model for Exclusive Permitted Left Turns (비보호 좌회전 지체도 추정모형의 개선)

  • 김진태
    • Journal of Korean Society of Transportation
    • /
    • v.21 no.2
    • /
    • pp.107-118
    • /
    • 2003
  • Highway Capacity Manual (HCM) provides an analytical delay estimation model to assist the evaluation of traffic at a signalized intersection. The model revised and included in the HCM published in the year 2000 reflects the results of recent studies and is utilized in various fields of transportation studies. For the implementation of the model in the case of permitted left turns, the HCM supplement provides a computational procedure to adjust the saturation flow rate of permitted left toms. The model however, is originally designed for a protected movement and thus underestimates the delay of permitted left turns due to its difference right-of-way nature. This document describes (1) a review of the theoretical background of the HCM delay estimation model, (2) problems embedded in the model for the delay estimation of permitted left turns, (3) a proposed model developed in this study to improve the delay estimation for permitted left turns and (4) a set of verification tests. In order to reflect various traffic and control conditions in the test, simulation studies were performed to by using the field data based on 120 different permitted left-turn scenarios. Comparison studies conducted between sets of delays estimated by the HCM and the proposed models against a set of the CORSIM delays and showed that the proposed model improved the estimation of the permitted left-turn delays. The explanatory variable of the relationship between the HCM delay and the simulation delay was 0.47 and the one between the delay estimated by the proposed model and the simulation delay was 0.77.

Implementation of Character and Object Metadata Generation System for Media Archive Construction (미디어 아카이브 구축을 위한 등장인물, 사물 메타데이터 생성 시스템 구현)

  • Cho, Sungman;Lee, Seungju;Lee, Jaehyeon;Park, Gooman
    • Journal of Broadcast Engineering
    • /
    • v.24 no.6
    • /
    • pp.1076-1084
    • /
    • 2019
  • In this paper, we introduced a system that extracts metadata by recognizing characters and objects in media using deep learning technology. In the field of broadcasting, multimedia contents such as video, audio, image, and text have been converted to digital contents for a long time, but the unconverted resources still remain vast. Building media archives requires a lot of manual work, which is time consuming and costly. Therefore, by implementing a deep learning-based metadata generation system, it is possible to save time and cost in constructing media archives. The whole system consists of four elements: training data generation module, object recognition module, character recognition module, and API server. The deep learning network module and the face recognition module are implemented to recognize characters and objects from the media and describe them as metadata. The training data generation module was designed separately to facilitate the construction of data for training neural network, and the functions of face recognition and object recognition were configured as an API server. We trained the two neural-networks using 1500 persons and 80 kinds of object data and confirmed that the accuracy is 98% in the character test data and 42% in the object data.