• 제목/요약/키워드: column name

검색결과 24건 처리시간 0.02초

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

  • 신수미;문영수
    • 한국컴퓨터정보학회:학술대회논문집
    • /
    • 한국컴퓨터정보학회 2021년도 제64차 하계학술대회논문집 29권2호
    • /
    • pp.621-624
    • /
    • 2021
  • 최근 빅데이터에 대한 관심이 높아지면서 분석을 위해 필요한 데이셋의 표준화에 대한 중요성이 강조되고 있다. 데이터 표준화를 위해서는 업무 처리에 필요한 모든 데이터의 명명 규칙을 규정하고 그 기준에 따라 표준 명칭을 부여하여야 한다. 본 연구에서는 사전을 기반으로 하는 항목명 표준화 시스템을 제안하였다. 제안한 시스템은 공개된 표준단어사전을 활용하여 유의어를 포함한 참조 사전을 구축하고 이를 기반으로 표준사전을 구축하여 표준 항목명을 제공한다. 기 구축된 데이터셋의 항목명을 입력하거나 사용자가 원하는 새로운 항목명을 입력하면 항목명 표준화 시스템은 표준화된 한글 항목명과 영문 항목명, 그리고 테이블 설계에 사용하는 영문 약어명을 출력한다. 본 연구에서 제안한 시스템을 테이블 설계에 활용하거나 기 구축된 데이터셋을 표준화하는데 적용하면 일관된 데이터 해석이나 관리가 가능할 것으로 기대된다.

  • PDF

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

  • 김상봉;오진탁;김영식;주영규
    • 한국공간구조학회논문집
    • /
    • 제15권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.

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

  • Dal-Heui Lee;Rovert D. Cody
    • 자원환경지질
    • /
    • 제34권3호
    • /
    • pp.301-306
    • /
    • 2001
  • 계면활성제를 이용한 오염복원에 있어서 제거효율에 영향을 주는 계면활성제 용액 pH의 최적범위를 조사하기 위하여 주상실험이 수행되었다. 톨루엔과 1,2,4-trichlorobenzene이 소수성 유기 화합물로서 선택되었다. 4%(v/v)의 sodium diphenyl oxide disulfonate(DOSL), trideceth-19-carboxylic acid(TDCA), octylphenoxypoly ethosye-thanol(OPEE)을 사용하여 두 종류의 아이오와 토양(Fruitfield sand, Webster clay loam)에 대한 용출실험을 수행하였다. 실험결과, 톨루엔과 1,2,4-trichlorobenzene의 제거효율은 계면활성제 용액 pH 10에서 나타났고, Furifield 사질토양에서 DOSL을 이용한 경우 최대 제거효율은 각각 94%, 97%였다. Fruitfield 사질토양에서 DOSL을 사용한 경우, pH 조절에 의하여 증가된 톨루엔과 1,2,4-trichlorobenzene의 제거효율은 각각 16%와 20%였다. Webster clay loam에서 DOSL을 이용한 경우 최대 제거효율은 각각 89%, 93%였다. Webster clay loam에서 DOSL을 사용한 경우, pH 조절에 의하여 증가된 톨루엔과 1,2,4-trichlorobenzene의 제거효율은 각각 26%와 19%였다. 이러한 실험결과는 NAPLs로 오염된 토양을 복원하는데 있어서 계면활성제 용액의 pH를 높게 유지하는 것이 바람직하다는 것을 의미한다.

  • PDF

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

  • 조원순
    • 한국보건간호학회지
    • /
    • 제16권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
    • /
    • 제9권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
    • /
    • 제1권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

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

  • 김정국
    • 한국산림과학회지
    • /
    • 제31권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

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

  • 고석범;윤성대
    • 한국멀티미디어학회논문지
    • /
    • 제7권9호
    • /
    • pp.1329-1338
    • /
    • 2004
  • 데이터마이닝은 방대한 데이터로부터 다차원적인 정보를 추출하는 것이다. 방대하게 구축되어 있는 데이터베이스에서 임의의 테이블의 컬럼에 대해 참조 할 수 있는 정보는 단순하게 컬럼명과 자료형 혹은 간단한 주석 정도이다. 그러한 비구조적이고 빈약한 내용만으로는 데이터마이닝을 위한 자료수집 및 자료탐색 단계에서 컬럼의 용도와 특성 및 스키마를 파악하여 데이터를 정제하고 수집하는 것이 난해 할 뿐만 아니라 너무 많은 시간이 소요된다. 이러한 문제를 해결하기 위해 본 논문에서는 관계형 데이터베이스 환경에서 데이터준비 단계 에 대부분의 시간을 소요하는 문제를 해결하기 위한 방안을 제안한다. 즉, 데이터 준비 단계에서 유용한 요소들을 메타데이터의 표준인 ISO/IEC : 11179 MDR (MetaData Registry) 규격에 맞는 표준 메타데이터를 제안하고, 이기종 및 이질 DBMS간에 호환 가능한 XML 기반의 분산 MDR 검색 시스템 구조를 제안한다.

  • PDF

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

  • 황병덕;하은정
    • 보건의료산업학회지
    • /
    • 제2권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)

  • 소지현;정미숙;정영순;이남숙
    • 식물분류학회지
    • /
    • 제43권3호
    • /
    • pp.161-164
    • /
    • 2013
  • 일본과 대만에 분포하는 것으로 알려진 난과의 아기쌍잎난초(Neottia japonica (Blume) Szlach.)가 제주도 서귀포시에서 발견되었다. 이 종은 식물체가 작으며 입술꽃잎에 꽃술대를 둘러싸는 소열편과 T자 모양의 신장된 육상체가 있고 꽃이 이른 봄에 피는 특징에 의해 근연종들인 쌍잎난초 및 털쌍잎난초와 구별된다. 국명은 쌍잎난초보다 귀엽고 작아서 아기쌍잎난초로 신칭하였다. 아기쌍잎난초의 형태적 특징을 기재하고, 확증표본, 도해와 생태 사진을 첨부하였다.