• Title/Summary/Keyword: structured

Search Result 8,148, Processing Time 0.032 seconds

An SQL Function for the Construction of Recursively Structured XML values from the Relational Data (관계 데이터로부터 재귀적 구조의 XML 값을 생성하는 SQL 함수)

  • Park, Sung-Chul;Park, Young-Chul
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.15 no.4
    • /
    • pp.309-313
    • /
    • 2009
  • SQL:2003 standard provides SQL/XML publishing functions to publish the result of an SQL query as XML values but it does not provide any SQL/XML publishing function that can publish the result of a recursive query as recursively structured XML values. Therefore, for the relational tuples which are connected directly or indirectly according to given conditions, to publish both the contents of them and the relationship among them as XML values with the use of appropriate SQL/XML publishing functions, we have to write a nested SQL query. Writing that query, however, is not easy provided that the depth of the connections is deep even if we know the depth of them and is not possible once the depth of the connections is not known in advance. In order to resolve that problem, we propose a new SQL function XMLNEST that can publish the result of a recursive query as recursively structured XML values.

The Analysis of Children's Private Speech on Age and Characteristic of Task (연령 및 과제특성에 따른 유아들의 혼잣말 발화 분석)

  • Lee, Jeong-Hwa;Park, Jeong-Eon;Lee, Myeong-Hee
    • Journal of Fisheries and Marine Sciences Education
    • /
    • v.24 no.4
    • /
    • pp.494-506
    • /
    • 2012
  • The purpose of this study was to analyse 3, 4, 5-year-old children's private speech according to their age and task characteristics (structured task vs. unstructured task). In order to achieve the goal, the main effect of age, characteristic of tasks and interaction effect were considered among age and characteristic of tasks on preschool children's private speech. The subjects were each 30 3, 4, 5-year-olds from preschool in Busan, South Korea. The structured task was puzzle task and the unstructured task was drawing task from TCT-DP. The data was analyzed by repeated measurement two way ANOVA: 3(age) ${\times}$ 2((characteristic of task). As a result, firstly, total private speech of 4-year-old was higher than 3-year-old, 5-year-old in both tasks, and total private speech of 5-year-old was higher than 3-year-old in both tasks. Secondly, the task-irrelevant private speech was not affected by main effect of age and characteristic of task and interaction effect between age and characteristic of task. Thirdly, the task-relevant private speech was received both main effects and interaction effects between age and characteristic of task. Finally, the external manifestation of inner speech were not received effect of age but received effect of characteristic of task, and received interaction effect between age and characteristic of task. The results of this study imply that characteristic of task is an important factor inducing children's private speech.

Atomic Coherence Spectroscopy in the Paraffin Coated Rb Atom Vapor Cell (파라핀 코팅된 Rb원자 증기 셀에서 원자결맞음 분광)

  • Lee, Hyun-Joon;Yu, Ye-Jin;Bae, In-Ho;Moon, Han-Seb
    • Korean Journal of Optics and Photonics
    • /
    • v.19 no.4
    • /
    • pp.334-340
    • /
    • 2008
  • We investigated the electromagnetically induced transparency (EIT) and the Hanle spectrum in a paraffin coated Rb vapor cell. The EIT spectrum was observed in the $F_g=2$, $3{\rightarrow}F_e=3$ transition of the $^{85}Rb$ $D_1$-line by using two independent external cavity diode lasers, and the Hanle spectrum was observed by using one external cavity diode laser in the $\Lambda$-type scheme between the Zeeman sublevels of the $F_g=2{\rightarrow}F_e=1$ transition of the $^{87}Rb$ $D_1$-line. In the Hanle spectrum, we could observe the dual-structured spectrum in the paraffin coated vapor cell. We investigated the dual-structured lineshape by applying an external magnetic field, and varying the direction of the magnetic field. The narrow linewidth of dual-structured EIT was measured to be approximately 200 Hz.

Assessing the Validity of the Preclinical Objective Structured Clinical Examination Using Messick's Validity Framework (Messick의 타당도 틀을 활용한 임상실습 전 실기시험의 타당도 평가)

  • Lee, Hye-Yoon;Yune, So-Jung;Lee, Sang-Yeoup;Im, Sunju
    • Korean Medical Education Review
    • /
    • v.23 no.3
    • /
    • pp.185-193
    • /
    • 2021
  • Students must be familiar with clinical skills before starting clinical practice to ensure patients' safety and enable efficient learning. However, performance is mainly tested in the third or fourth years of medical school, and studies using the validity framework have not been reported in Korea. We analyzed the validity of a performance test conducted among second-year students classified into content, response process, internal structure, relationships with other variables, and consequences according to Messick's framework. As results of the analysis, content validity was secured by developing cases according to a pre-determined blueprint. The quality of the response process was controlled by training and calibrating raters. The internal structure showed that (1) reliability by generalizability theory was acceptable (coefficients of 0.724 and 0.786, respectively, for day 1 and day 2), and (2) the relevant domains had proper correlations, while the clinical performance examination (CPX) and objective structured clinical examination (OSCE) showed weaker relationships. OSCE/CPX scores were correlated with other variables, especially grade point average and oral structured exam scores. The consequences of this assessment were (1) making students learn clinical skills and study themselves, while causing too much stress for students due to lack of motivation; (2) reminding educators of the need to apply practical teaching methods and to give feedback on the test results; and (3) providing an opportunity for faculty to consider developing support programs. It is necessary to develop the blueprint more precisely according to students' level and to verify the validity of the response process with statistical methods.

A Machine Learning-Based Vocational Training Dropout Prediction Model Considering Structured and Unstructured Data (정형 데이터와 비정형 데이터를 동시에 고려하는 기계학습 기반의 직업훈련 중도탈락 예측 모형)

  • Ha, Manseok;Ahn, Hyunchul
    • The Journal of the Korea Contents Association
    • /
    • v.19 no.1
    • /
    • pp.1-15
    • /
    • 2019
  • One of the biggest difficulties in the vocational training field is the dropout problem. A large number of students drop out during the training process, which hampers the waste of the state budget and the improvement of the youth employment rate. Previous studies have mainly analyzed the cause of dropouts. The purpose of this study is to propose a machine learning based model that predicts dropout in advance by using various information of learners. In particular, this study aimed to improve the accuracy of the prediction model by taking into consideration not only structured data but also unstructured data. Analysis of unstructured data was performed using Word2vec and Convolutional Neural Network(CNN), which are the most popular text analysis technologies. We could find that application of the proposed model to the actual data of a domestic vocational training institute improved the prediction accuracy by up to 20%. In addition, the support vector machine-based prediction model using both structured and unstructured data showed high prediction accuracy of the latter half of 90%.

Sandwich-structured High-sensitivity Resistive Pressure Sensor based on Silver Nanowire (샌드위치 구조를 갖는 은 나노와이어 기반 고감도 저항성 압력 센서)

  • Lee, Jinyoung;Kim, Gieun;Shin, Dongkyun;Park, Jongwoon
    • Journal of the Semiconductor & Display Technology
    • /
    • v.17 no.2
    • /
    • pp.1-5
    • /
    • 2018
  • Elastic resistive pressure sensor is fabricated by a direct spray coating of silver nanowires (AgNWs) on uncured polydimethylsiloxane (PDMS) and an additional coating of a conductive polymer, poly(3,4-ethylenedioxythiophene): poly (styrene sulfonate) (PEDOT:PSS). To improve the sensitive and stability, we have fabricated sandwich-structured AgNW/polymer sensor where two AgNW/polymer-coated PDMS films are laminated with the conducting surfaces contacted by pressure lamination. It shows a resistance decrease upon loading due to the formation of dense network of AgNWs. It is demonstrated that the sandwich-structured AgNW/polymer sensor exhibits very high sensitivity ($2.59kPa^{-1}$) and gauge factor (37.8) in the low pressure regime. It can also detect a subtle placement and removal of a weight as low as 3.4 mg, the corresponding pressure of which is about 5.4 Pa. It is shown that the protrusion of AgNWs from PDMS is suppressed substantially by the over-coated PEDOT:PSS layer, thereby reducing hysteresis and rendering the sensor more stable.

MPIL: Market prediction through image learning of unstructured and structured data (비정형, 정형 데이터의 이미지 학습을 활용한 시장예측)

  • Lee, Yoon Seon;Lee, Ju Hong;Choi, Bum Ghi;Song, Jae Won
    • Smart Media Journal
    • /
    • v.10 no.2
    • /
    • pp.16-21
    • /
    • 2021
  • Financial time series analysis plays a very important role economically and socially in modern society and is an important task affecting global development, but due to difficulties such as a lot of noise and uncertainty, financial time series analysis prediction is a difficult research topic. In this paper, we propose a market prediction method (MPIL) by converting unstructured data and structured data into images. For market prediction, it analyzes SNS and news data, which is unstructured data for n days, and converts the market data, which is structured data, to an image with the GADF algorithm, and predicts an ultra-short market that predicts the price of n+1 days through image learning. MPIL has an average accuracy of 56%, which is higher than the 50% average accuracy of the model that predicts the market with LSTM by using sentiment analysis used for existing market forecasting.

The Effects of Chatbot's Error Types and Structures of Error Message on User Experience (챗봇의 오류 유형과 오류 메시지 구조화 여부가 사용자 경험에 미치는 영향)

  • Lee, Mi-Jin;Han, Kwang-Hee
    • The Journal of the Korea Contents Association
    • /
    • v.21 no.6
    • /
    • pp.19-34
    • /
    • 2021
  • The aim of this study is verifying the effects of chatbot's error types and structures of error message on attitude, behavior intention towards the chatbot and perceived usability of the chatbot. The error types of chatbot are divided into 'experience' error and 'agency' error, which set different expectancy level, according to mind perception theory. The structures of error message were either unstructured condition composed of error specification only or structured condition composed of apology, explanation and willingness of improvement. It was found that score of perceived usability was higher in experience error condition than agency error condition. Also, all three scores of dependent variables were higher in structured error message condition than unstructured error message condition. Furthermore, expectation gap of experience didn't predict the dependent variables but expectation gap of agency predicted all three dependent variables. Finally, the tendency of interaction effect between the error type and the structure of the error message on expectation gap of agency was observed. This study confirmed the mitigating effect of structured error messages and the possibility that these effects may vary by the type of error. The result is expected to be applicable to design of error coping strategies that enhance user experience.

Enhancement of Photoluminescence by Ag Localized Surface Plasmon Resonance for Ultraviolet Detection

  • Lyu, Yanlei;Ruan, Jun;Zhao, Mingwei;Hong, Ruijin;Lin, Hui;Zhang, Dawei;Tao, Chunxian
    • Current Optics and Photonics
    • /
    • v.5 no.1
    • /
    • pp.1-7
    • /
    • 2021
  • For higher sensitivity in ultraviolet (UV) and even vacuum ultraviolet (VUV) detection of silicon-based sensors, a sandwich-structured film sensor based on Ag Localized Surface Plasmon Resonance (LSPR) was designed and fabricated. This film sensor was composed of a Ag nanoparticles (NPs) layer, SiO2 buffer and fluorescence layer by physical vapour deposition and thermal annealing. By tuning the annealing temperature and adding the SiO2 layer, the resonance absorption wavelength of Ag NPs matched with the emission wavelength of the fluorescence layer. Due to the strong plasmon resonance coupling and electromagnetic field formed on the surface of Ag NPs, the radiative recombination rate of the luminescent materials and the number of fluorescent molecules in the excited state increased. Therefore, the fluorescent emission intensity of the sandwich-structured film sensor was 1.10-1.58 times at 120-200 nm and 2.17-2.93 times at 240-360 nm that of the single-layer film sensor. A feasible method is provided for improving the detection performance of UV and VUV detectors.

Presentation on Research Trends and Suggestion for further research and education on Objective Structured Clinical Examination and Clinical Performance Examination in Korean Medicine Education: Scoping Review (한의학교육에서 객관구조화진료시험과 진료수행평가에 대한 연구 동향과 후속 연구 및 교육에 대한 제언: 주제범위 문헌고찰)

  • Shin, Jinyeong;Go, Yerim;Song, Changjin;Cho, Eunbyul;Leem, Jungtae
    • Journal of Society of Preventive Korean Medicine
    • /
    • v.26 no.2
    • /
    • pp.87-112
    • /
    • 2022
  • Objectives : This study reviewed existing studies on clinical examination of Korean medicine to investigate the trends and gaps of existing research on clinical performance examination (CPX) or objective structured clinical examination (OSCE) in Korean medicine education. Methods : We conducted a scoping review according to the five steps suggested by Arksey and O'Malley. Six databases(RISS, OASIS, KMBASE, KISS, ScienceON, and DBpia) were searched and studies published from 2012 to July 15, 2022 were considered. The subjects of the study were limited to domestic studies about OSCE or CPX conducted in Korean medicine education. Results : Among the 25 selected papers, 17 studies implemented OSCE or CPX in practice. Those studies were conducted in 8 clinical departments and 9 of them used standardized patients. All 14 survey studies reported positive answers in satisfaction, efficacy, and self-assessment. OSCE, CPX scoring items were developed by modifying existing tools or developing through expert surveys or through literature review and significant cases. Conclusions : This study is expected to be used as basic data for following studies and promote clinical examination. From now on, the colleges of Korean medicine should proceed research on large-scale students about extended subjects through various research methods to obtain objective results that can be generalized and acquire validity and reliability. In order to promote such research, it is necessary to induce cooperation from institutions related to Korean Medicine and local universities to develop modules, implement, and conduct post-evaluation.