• Title/Summary/Keyword: column name

Search Result 24, Processing Time 0.027 seconds

Design and Implementation of Dictionary-based Column Name Standardization System (사전기반 항목명 표준화 시스템 설계 및 구현)

  • Shin, Su-Mi;Moon, Young-Su
    • Proceedings of the Korean Society of Computer Information Conference
    • /
    • 2021.07a
    • /
    • pp.621-624
    • /
    • 2021
  • 최근 빅데이터에 대한 관심이 높아지면서 분석을 위해 필요한 데이셋의 표준화에 대한 중요성이 강조되고 있다. 데이터 표준화를 위해서는 업무 처리에 필요한 모든 데이터의 명명 규칙을 규정하고 그 기준에 따라 표준 명칭을 부여하여야 한다. 본 연구에서는 사전을 기반으로 하는 항목명 표준화 시스템을 제안하였다. 제안한 시스템은 공개된 표준단어사전을 활용하여 유의어를 포함한 참조 사전을 구축하고 이를 기반으로 표준사전을 구축하여 표준 항목명을 제공한다. 기 구축된 데이터셋의 항목명을 입력하거나 사용자가 원하는 새로운 항목명을 입력하면 항목명 표준화 시스템은 표준화된 한글 항목명과 영문 항목명, 그리고 테이블 설계에 사용하는 영문 약어명을 출력한다. 본 연구에서 제안한 시스템을 테이블 설계에 활용하거나 기 구축된 데이터셋을 표준화하는데 적용하면 일관된 데이터 해석이나 관리가 가능할 것으로 기대된다.

  • PDF

Structural Performance Evaluation of Joint between PHC Pile and Steel Tube Column (강관기둥과 PHC 파일을 연결하는 접합부에 관한 구조성능평가)

  • Kim, Sang-Bong;Oh, Jin-Tak;Kim, Young-Sik;Ju, Young-Kyu
    • Journal of Korean Association for Spatial Structures
    • /
    • v.15 no.3
    • /
    • pp.85-93
    • /
    • 2015
  • This paper presents a foundation pile to steel column connection that can resist large magnitude of moment and that can be easy installed. The developed joint has spherical shape and it is given the name HAT joint to mean Hallow half-sphere steel joint. Four types of HAT joints are developed. Namely, H-type, T-type, P-type and K-type. In this paper I will talk about the performance assessment of T-type(Tube Column) and P-type(Pile Column) of HAT joints with finite element analysis and experiment on a full scale model is presented.

Effect of Surfactant Solution pH on Surfactant-Assisted Remediation (계면활성제를 이용한 오염복원에 있어서 계면 활성제 용액 pH의 효과)

  • Dal-Heui Lee;Rovert D. Cody
    • Economic and Environmental Geology
    • /
    • v.34 no.3
    • /
    • pp.301-306
    • /
    • 2001
  • Column tests were conducted to investigate the optimal condition of surfactant solution pH that can affect the removal efficiency in surfactant-assisted remediation. Toluene and 1,2,4-trichlorobenzene were chosen as the model hydrophobic substances. Two Iowa soils, Fruitfield sand and Webster clay loam, were leached with solutions of 4%(v/v) sodium diphenyl oxide disulfonate (DOSL, trade name Dowfax 8390), or 4%(v/v) trideceth-19-carboxylic acid (TDCA, trade name Sandopan JA36), or 4% (v/v) octylphenoxypoly ethoxyethanol (OPEE, trade name Triton X100). The test results revealed that a maximum removal of toluene and 1,2,4-trichlorobenzene was obtained at pH 10 of surfactant solution, and maximum recoveries of added toluene (94%) or 1 ,2,4- trichlorobenzene (97 %) were obtained for DOSL surfactant solution in Fruitfield sandy soil column. Increased removal efficiency by pH control of both toluene and 1,2,4trichlorobenzene was 16% and 20% for DOSL with Fruitfild sandy soil, respectively. In addition, the maximum recoveries of added toluene or I ,2,4-trichlorobenzene were 89% and 93% for DOSL surfactant solution in Webster clay loam soil column. The maximum increase of toluene and 1,2,4-trichlorobenzene removal was 26% and 19% for DOSL with Webster clay loam soil, respectively. These experimental results indicate that maintaining a high pH surfactant solution in surfactant-assisted remediation is desirable for efficient removal of NAPLs from contminated soils.

  • PDF

A Study on the Types and Causes of Medication Errors and Related Drugs - by Analyzing AJNs Medication Error 73 Cases - (임상에서의 투약오류원인과 관련 의약품 분석 - AJN에 기고된 Medication Error 기사의 73사례를 중심으로 -)

  • Cho Won Sun
    • Journal of Korean Public Health Nursing
    • /
    • v.16 no.1
    • /
    • pp.176-189
    • /
    • 2002
  • The purpose of this study were to illustrate the various medication error types and causes and identified to related drugs to provide basic data for preventing nurses' medication error by analysing 73 cases of AJN 'medication Error' column(1993, Oct -2000, Nov). Nurses' types of medication error were classified into 7 types. The most frequent error types are wrong medication$(21.9\%)$ and the wrong dose$(21.9\%)$ together. The others are wrong $time(4.1\%)$, $omission(2.7\%)$, mechanical $error(2.7\%)$, incorrect IV $rate(1.4\%)$. wrong route $administration(1.4\%)$ in order. Nurses' causes of medication error were 9 kinds. The most frequent type is confusing between similar drug shape, color, size, name, injection devices and patient's $name(43.9\%)$ and the others are lack of knowledge about $drugs(26.8\%),\; slips(7.3\%),\; miscalculating\;dose(4.9\%)$, incorrect adjusts $devices(4.9\%)$, difficulty to read or illegible decimal $point(4.9\%),$ $abbreviation(2.4\%)$, fatigue with $overwork(2.4\%)$ and no communication with $patient(2.4\%)$ in order. Related drugs with medication error are as follows. - dose unit(IU. minims. mcg/min. mEq) : Heparin. insulin. synthetic calcitonin, some enzymes and hormones, vitamins, some antibiotics, tuberculin injection. MgSO4 injection. nitroglycerin - similar size, color and shape drug : $0.9\%$ N/S and acetic acid $0.25\%$ for irrigation. premixed 2mg lidocaine sol. and $0.9\%$ N/S, gentamycin 20mg/2mL for children and 80mg/2mL for adult, dextroamphetamine 5mg and 10mg capsule. sedatives chloral hydrate 250mg/5mL and 500mg/5mL - similar name :Aredia(pamidronate disodium) and Adriamycin(doxorubicin), Lamictal (lamotrigine) and Lamisil 250mg. Elderpryl and enalapril, cefotaxime and cefoxitin, carboplatin and cisplatin, sumatriptan and zolmitriptan, Celebrex and Celexa, Humulin and Humalog, Percodan and Percocet, Diabeta and Diabinese, Epivir and Retrovir, Xanax(alprazolam) and Zantac(ranitidine) - decimal point : low molecular weight warfarin, methotrexate - unfamiliar drug uses of familiar drug ; methotrexate. droperidol, imipramine, propranolol - number of drug name(misleading chemical name) : 6-thioguanine, 6-mercaptopurine, 5-fluorouracil - type of administration route : Oxycodone(OxyContin). - administration time : acarbose(Precose). - injection way (Z-track method): hydroxyzine - epidural cathether : LMWHs(enoxaparin, dalteparin), - ADD Vantage self contained delivery system : ceftriaxone(Rocephin)

  • PDF

Direct Purification of Lysozyme from Hen Egg White Using High Density Mixed Mode Adsorbent

  • KIM, WON KYUNG;BONG HYUN CHUNG
    • Journal of Microbiology and Biotechnology
    • /
    • v.9 no.3
    • /
    • pp.292-296
    • /
    • 1999
  • The high density mixed mode adsorbent known by the trade name of Mimo-AD was used to purify lysozyme directly from the hen egg white (HEW). The homogenized hen egg white was treated with the adsorbent in a stirred vessel for lysozyme adsorption, and then the adsorbent, easily separated from the HEW by sedimentation, was packed into a column. The remaining HEW and contaminant proteins were removed by washing with pH 11 distilled water in an expanded-bed state, and subsequently the elution was performed with pH 12 distilled water in a packed-bed state. By this simple and rapid adsorption, washing, and elution procedure, lysozyme was purified to>95% with an overall recovery yield of 66%. This process offers a great potential for industrial application by allowing the extraction of lysozyme while retaining the commercial value of HEW.

  • PDF

Simple Purification of Bromelain from Pineapple

  • Ko, Bo-Sung;Hwang, Yong-Il;Lee, Seung-Cheol
    • Preventive Nutrition and Food Science
    • /
    • v.1 no.1
    • /
    • pp.106-110
    • /
    • 1996
  • Bromelain(EC 3.4.22.4), the collective name for the proteolytic enzymes found in tissues of the plant family Bromeliaceae(pineapple), has been used as a tenderizing agent in food processing, and as an antiinflammatory agent in pharmaceuticals. In this paper, we describe the simple purification method of bromelain using Korean pineapple fruit. After removing contaminants at 30% saturation of ammonium sulfate, the supernatant obtained was treated again with ammonium sulfate to 80% saturation. Wit the above salt fractionation, partially purified bromelain could be obtained. To get highly purified bromelain, the previous 30% to 80% ammonium sulfate treated precipitate was dialyzed against 25mM sodium acetate buffer(pH 5.0) followed by passing through a CM- cellulose cation exchange column. Fruit bromelain was eluted as a major peak at 0.5~0.8M NaCI gradient. The present method is simpler with high wield than the traditional purification method-acetone treatment and several consecutive chromatographic processes.

  • PDF

Etymological Explanation of the Scientific Names for Trees and the Foreign Names of Them(II) (수목학명(樹木學名)의 어원구명(語源究明) 및 외국명(外國名) 조사(調査)(제(第)2보(報)))

  • Kim, Jyeung Gook
    • Journal of Korean Society of Forest Science
    • /
    • v.31 no.1
    • /
    • pp.53-61
    • /
    • 1976
  • Though it is not easy for those who study dendrology to memorize all the scientific names of trees, the names remaines in their memory can facilitate the understanding of foreign technical books. The scientific name of a tree indicates characteristics of shape, color, and other aspects of the tree and by analyzing the name we can see common element found in other scientific names of trees. It is helpful to those who want to memorize and study the scientific names of trees if they understand their etymology. The preseut study is the seconds report of the investigation which aims at examining the etymology of the scientific names of native and foreign trees growing in Korea and their original names not only at the habitat but in Japan, China, England, Germany, and France. While the first report, which was made known in Theses Vol. 9. (The City College of Seoul 1975), is the examination of the scientific names of trees belonging to Gymnospermae, the present report is that of scientific names of trees belonging to Piperales: 2 families, 2 genera and 2 species; and trees belonging to Salicales: 1 family, 3 genera, 44 species, 16 varieties, and 3 forms. As the etymology of the scientific names of trees is made clear, this study will help those who want memorize the scientific names and study foreign technical books and it is also useful for international interchange of trees. The classification is depended chiefly on Dendrology by Prof. Lee Tchang-bok and "Plant Resources of Korea" shown in Biblography No. 10; the native names of trees on Jumoku Daizusetsu by Dr. Uehara; and etymology on A source-Book of Biological Names and Terms by E.C. Jager. In the column of etymology of the scientific names for genera, species, varieties and forms, Gr. stands for Greek, L. for Latin, NL. for New Latin, and genit. for genitive.

  • PDF

A Design of XML-Based Distributed MDR Retrieval System for Data Preparation (데이터준비를 위한 XML 기반의 분산 MDR 검색 시스템 설계)

  • Ko Sucbum;Youn Sungdae
    • Journal of Korea Multimedia Society
    • /
    • v.7 no.9
    • /
    • pp.1329-1338
    • /
    • 2004
  • The purpose of data mining is to extract multi-dimensional information from a large database. The only information that we can extract from a large database is the column name, data type or simple comments included in the columns of database tables. With such unstructured and scarce information, it is very difficult and time taking to collect and to cleanse data by analyzing the purpose, characteristic and schema of the column during the data preparation step. In order to solve this problem, we propose solutions for reducing the time spent data preparation step in a relational database environment in this paper. That is, we propose useful elements to be considered during the data preparation step and then these elements are organized to constitute MDR(Metadata Registry) which is becoming the international standard of ISO/IEC : ll179. Finally, we propose a XML-based distributed MDR retrieval system that is convertible among heterogeneous systems and heterogeneous DBMSS.

  • PDF

A Study of Pattern Change Medical Advertiging (의료법개정 전.후에 따른 의료광고의 변화 -주요 3대 일간지를 중심으로-)

  • Hwang, Byeong-Duk;Ha, Eun-Jung
    • The Korean Journal of Health Service Management
    • /
    • v.2 no.1
    • /
    • pp.155-165
    • /
    • 2008
  • This study is aims finding out characteristics and change levels of medical advertizing between before and after revised medical laws. We investigated to medical advertizing of 3 major newspaper(Josen, Joongang, Donga) to achieve study purpose. After revised medical laws, major change is seen below. 1. Increase rates of medical advertizing was 65.5%. Specially, increase rates of medical advertizing by each department were differently each department; Dermatology was 450%, dentist's clinic was 342%, orthopedic surgery was 171%, and plastic surgery was 133%. In spite of increasing trends of most departments, urology decreased to 50% than before revised medical laws. 2. Of types of medical advertizing, Question and Answer type increased to 230% than before. Illegal level of medical advertizing was 10.4%. 3. The contents of medical advertizing were hospital location, photograph before and after treatments, and carrier, name and introduction of medical staffs. 4. The size of medical advertizing increased 1.73 column then before. The size of medical advertizing in clinics was shown statistically increase than hospital level. With above results, it is cleared that increase rates and trends of medical advertizing are more increased and complicated before revised medical laws. We try to be better situations for patients to get more exactly information and facts.

  • PDF

First record of Neottia japonica (Orchidaceae) from Korea (한국 미기록 식물: 아기쌍잎난초(난과))

  • So, Ji Hyeon;Chung, Mi Sook;Chung, Young Sun;Lee, Nam Sook
    • Korean Journal of Plant Taxonomy
    • /
    • v.43 no.3
    • /
    • pp.161-164
    • /
    • 2013
  • Neottia japonica (Blume) Szlach. (Orchidaceae), previously known to be native in southern part of Japan and Taiwan, was found in Seogwipo-si, Jeju-do, Korea. This species is distinguished from the related taxa of Neottia pinetorum (Lindle.) Szlach and N. nipponica (Makino) Szlach. by smaller plant, lip with T-shaped lamella and auricles embracing column, and flowering in the spring. The local name was given as "A-gi-ssangnip-nan-cho" based on the cuter and smaller plant than N. pinetorum. The description and illustrations of the species on morphological characters, voucher specimens, and photograph at the habitat are provided.