• 제목/요약/키워드: Tree type database

검색결과 43건 처리시간 0.019초

시간 공간 통합 본원적 데이터 모델링 및 그 구현에 관한 연구 (Modeling and Implementation for Generic Spatio-Temporal Incorporated Information)

  • 이우기
    • Journal of Information Technology Applications and Management
    • /
    • 제12권1호
    • /
    • pp.35-48
    • /
    • 2005
  • An architectural framework is developed for integrating geospatial and temporal data with relational information from which a spatio-temporal data warehouse (STDW) system is built. In order to implement the STDW, a generic conceptual model was designed that accommodated six dimensions: spatial (map object), temporal (time), agent (contractor), management (e.g. planting) and tree species (specific species) that addressed the 'where', 'when', 'who', 'what', 'why' and 'how' (5W1H) of the STDW information, respectively. A formal algebraic notation was developed based on a triplet schema that corresponded with spatial, temporal, and relational data type objects. Spatial object structures and spatial operators (spatial selection, spatial projection, and spatial join) were defined and incorporated along with other database operators having interfaces via the generic model.

  • PDF

급성 뇌졸중 환자의 중증도 보정 재원일수 변이에 관한 연구 (The Variation of Factors of severity-adjusted length of stay(LOS) in acute stroke patients)

  • 강성홍;석향숙;김원중
    • 디지털융복합연구
    • /
    • 제11권6호
    • /
    • pp.221-233
    • /
    • 2013
  • 본 연구는 뇌졸중 환자의 효율적인 재원일수 관리를 위해 행정자료를 이용하여 우리나라 의료기관을 이용한 뇌졸중 입원환자의 중증도 보정 적정 재원일수 예측 모형을 개발하고 이를 의료기관에서 활용할 수 있는 방안을 제시하고자 하였다. 이를 위해 2004-2009년 퇴원손상심층조사 자료 중 뇌졸중 입원환자 23,134명을 대상으로 데이터마이닝 기법을 이용하여 뇌졸중 입원환자의 적정 재원일수 예측모형을 개발하였다. 의사결정나무 모형에 따라 뇌졸중 입원환자의 평균재원일수에 가장 큰 영향을 미치는 변수는 뇌졸중 발생유형이었으며, 의사결정나무를 이용하여 개발된 뇌졸중 입원환자의 중증도 보정 재원일수 모형 결과, 적정 재원일수와 실제 재원일수의 차이는 진료비지불방법, 의료기관 소재지, 병상규모가 모두 통계적으로 유의하게 나타났다. 따라서 뇌졸중 입원환자의 재원일수 변이를 줄이고 효율적으로 관리하기 위해서는 개발된 모형을 의료기관의 의료정보시스템에 적용하고 관리하는 활동을 전개해야 할 것이다.

Molecular Characterization of Echovirus 30-Associated Outbreak of Aseptic Meningitis in Korea in 2008

  • Choi, Young-Jin;Park, Kwi-Sung;Baek, Kyoung-Ah;Jung, Eun-Hye;Nam, Hae-Seon;Kim, Yong-Bae;Park, Joon-Soo
    • Journal of Microbiology and Biotechnology
    • /
    • 제20권3호
    • /
    • pp.643-649
    • /
    • 2010
  • Evaluation of the primary etiologic agents that cause aseptic meningitis outbreaks may provide valuable information regarding the prevention and management of aseptic meningitis. In Korea, an outbreak of aseptic meningitis caused by echovirus type 30 (E30) occurred from May to October in 2008. In order to determine the etiologic agent, CSF and/or stool specimens from 140 children hospitalized for aseptic meningitis at Soonchunhyang University Cheonan Hospital between June and October of 2008 were tested for virus isolation and identification. E30 accounted for 61.7% (37 cases) and echovirus 6 accounted for 21.7% (13 cases) of all the human enteroviruses (HEVs) isolates (60 cases in total). For the molecular characterization of the isolates, the VP1 gene sequence of 18 Korean E30 isolates was compared pairwise using the MegAlign with 34 reference strains from the GenBank database. The pairwise comparison of the nucleotide sequences of the VP1 genes demonstrated that the sequences of the Korean strains differed from those of lineage groups A, B, C, D, E, F, and G. Reconstruction of the phylogenetic tree based on the complete VP1 nucleotide sequences resulted in a monophyletic tree, with eight clustered lineage groups. All Korean isolates were segregated from other lineage groups, thus suggesting that the Korean strains were a distinct lineage of E30, and a probable cause of this outbreak. This manuscript is the first report, to the best of our knowledge, of the molecular characteristics of E30 strains associated with an aseptic meningitis outbreak in Korea, and their respective phylogenetic relationships.

Developing a Dynamic Materialized View Index for Efficiently Discovering Usable Views for Progressive Queries

  • Zhu, Chao;Zhu, Qiang;Zuzarte, Calisto;Ma, Wenbin
    • Journal of Information Processing Systems
    • /
    • 제9권4호
    • /
    • pp.511-537
    • /
    • 2013
  • Numerous data intensive applications demand the efficient processing of a new type of query, which is called a progressive query (PQ). A PQ consists of a set of unpredictable but inter-related step-queries (SQ) that are specified by its user in a sequence of steps. A conventional DBMS was not designed to efficiently process such PQs. In our earlier work, we introduced a materialized view based approach for efficiently processing PQs, where the focus was on selecting promising views for materialization. The problem of how to efficiently find usable views from the materialized set in order to answer the SQs for a PQ remains open. In this paper, we present a new index technique, called the Dynamic Materialized View Index (DMVI), to rapidly discover usable views for answering a given SQ. The structure of the proposed index is a special ordered tree where the SQ domain tables are used as search keys and some bitmaps are kept at the leaf nodes for refined filtering. A two-level priority rule is adopted to order domain tables in the tree, which facilitates the efficient maintenance of the tree by taking into account the dynamic characteristics of various types of materialized views for PQs. The bitmap encoding methods and the strategies/algorithms to construct, search, and maintain the DMVI are suggested. The extensive experimental results demonstrate that our index technique is quite promising in improving the performance of the materialized view based query processing approach for PQs.

한라산 영실지역 구상나무 고사연도와 시계열적 생육쇠퇴도 조사 (Investigation of Death Years and Inter-annual Growth Reduction of Korean Firs (Abies Koreana) at Yeongsil in Mt. Halla)

  • 서정욱;김요정;최은비;박준희;김재훈
    • 한국환경복원기술학회지
    • /
    • 제22권3호
    • /
    • pp.1-14
    • /
    • 2019
  • With a view to developing a database of death years of Korean firs (Abies koreana) at Yeongsil in Mt. Halla and investigating their abrupt inter-annual growth reduction tree-ring analysis was employed. To this end, 10 living trees (YSL) were selected to establish a master chronology and 20 dead trees were used to date their dead years. To investigate the difference in death years by death types, 10 trees, which remained standing (YSSD) out of the 20 dead trees were selected. The rest 10 dead trees were already fallen (YSFD). Two increment cores per tree at breast height were extracted in contour direction using an increment borer. A 106-year master chronology (1911-2016) was successfully established from the 10 YSLs. Through cross-dating between individual YSSD time series and the master chronology, it was verified that 1 YSSD was dead in summer 1978, 1 YSSD between autumn 1999 and spring 2000, 2 YSSDs in summer 2007, 1 YSSD in summer 2010, 1 YSSD in summer 2012, and 1 YSSD in summer 2013. The youngest tree rings of 2 YSSDs having no bark were in 1977 and 2002. For the YSFDs, it was verified that 1 YSFD was dead between autumn 1997 and spring 1998, 1 YSFD between autumn 2001 and spring 2002, 2 YSFDs between autumn 2009 and spring 2010, 1 YSFD in summer 2010, and 2 YSFDs between autumn 2012 and spring 2013, while the youngest tree rings of 2 YSFDs having no bark were in 1989 and 2004. To note, the death years of two trees, one from each death type (YSSD and YSFD), could not be verified due to poor cross-dating with the master chronology. The inter-annual growth reductions of YSSD and YSFD occurred more frequently and intensively than YSL. Typically, the YSFD showed the most frequent and intensive inter-annual growth reduction. On comparing the inter-annual growth reductions with the corresponding records of typhoons however we could not find any reliable relationship. Finally, from prior reports and results of the current study it can be concluded that the death and abrupt growth reduction of korean fir at Yeongsil in Mt. Halla are not caused by only a certain environmental factor but various factors.

The Extract of Couroupita guianensis Aubl. Ameliorates Benign Prostatic Hyperplasia In Vitro and In Vivo

  • Kim, Yun Na;Kim, Na-Hyun;Souliya, Onevilay;Uddin, Salah;Lee, Sang Woo;Kim, Soo-Yong;Choi, Sangho;Heo, Jeong-Doo;Jeong, Eun Ju
    • Natural Product Sciences
    • /
    • 제27권4호
    • /
    • pp.274-279
    • /
    • 2021
  • The therapeutic effects of the leaves of Couroupita guianensis, a large tropical tree in the family of Lecythidaceae improving testosterone-induced Benign Prostatic Hyperplasia (BPH) were tested in vitro and in vivo. In BPH rats induced by castration and testosterone treatment, the prostate index was improved in groups administered with the extracts of C. guianensis extracted with 50%-, 100%-ethanol or boiling water, which was comparable with positive control, finasteride. The extract C. guianensis leaves showed significant inhibition on the expressions of type 2 5-alpha reductase (5αR) in RWPE-1 human prostatic epithelial cells, and effectively attenuated the expressions of androgen receptor, type 2 5αR and proliferating cell nuclear antigen in LNCap human prostatic adenocarcinoma cells. The leaves of C. guianensis that exerted evident suppression on BPH-related biomarkers in vitro and improvement of prostate index in vivo has a potential therapeutic use for the treatment of BPH.

Comparative Genome Analysis Reveals Natural Variations in the Genomes of Erwinia pyrifoliae, a Black Shoot Blight Pathogen in Apple and Pear

  • Lee, Gyu Min;Ko, Seyoung;Oh, Eom-Ji;Song, Yu-Rim;Kim, Donghyuk;Oh, Chang-Sik
    • The Plant Pathology Journal
    • /
    • 제36권5호
    • /
    • pp.428-439
    • /
    • 2020
  • Erwinia pyrifoliae is a Gram-negative bacterial plant pathogen that causes black shoot blight in apple and pear. Although earlier studies reported the genome comparison of Erwinia species, E. pyrifoliae strains for such analysis were isolated in 1996. In 2014, the strain E. pyrifoliae EpK1/15 was newly isolated in the apple tree showing black shoot blight in South Korea. This study aimed to better understand the similarities and differences caused by natural variations at the genomic level between newly isolated E. pyrifoliae EpK1/15 and the strain Ep1/96, which were isolated almost 20 years apart. Several comparative genomic analyses were conducted, and Clusters of Orthologous Groups of proteins (COG) database was used to classify functional annotation for each strain. E. pyrifoliae EpK1/15 had similarities with the Ep1/96 strain in stress-related genes, Tn3 transposase of insertion sequences, type III secretion systems, and small RNAs. The most remarkable difference to emerge from this comparison was that although the draft genome of E. pyrifoliae EpK1/15 was almost conserved, Epk1/15 strain had at least three sorts of structural variations in functional annotation according to COG database; chromosome inversion, translocation, and duplication. These results indicate that E. pyrifoliae species has gone natural variations within almost 20 years at the genomic level, and we can trace their similarities and differences with comparative genomic analysis.

ACTA 형식론에 기반한 워크플로우 패턴추출 (Workflow Pattern Extraction based on ACTA Formalism)

  • 이우기;배준수;정재윤
    • 한국정보과학회논문지:데이타베이스
    • /
    • 제32권6호
    • /
    • pp.603-615
    • /
    • 2005
  • 워크플로우 관리 시스템은 다양성과 복잡성이 커지고 있는 비즈니스 프로세스 관리의 해결대안으로서 부각되고있다. 본 연구에서는 주어진 프로세스 흐름을 세 가지의 패턴 즉, 반복블록, 직렬블록 및 병렬블록 등으로 단순화하고 노드의 위상적 순서(topological ordering)를 생성하는 알고리즘을 이용하여 사이클을 찾아 반복블록을 제거하고, 다음으로 직렬 및 병렬블록을 반복적으로 검색하는 수로분기 알고리즘을 포함하는 새로운 모델을 제시한다. 그리고 ACTA 형식론에 기반하여 각 블록을 ECA규칙으로 변환하여 사건(event)을 감지하는 워크플로우 시스템으로의 구현 방안을 제시한다. 그 모델의 결과를 컴퓨터가 수행할 수 있도록 만들어주는 과정 즉, 비즈니스 프로세스를 모델에 입각하여 통제하는 데에 사건-조건-처리(ECA)규칙을 사용한다. 유형별로 ECA 규칙에 입각한 통제 논리를 설계하였으며, 이것은 규칙기반 워크플로우 관리시스템의 기초가 될 수 있다. 또한 본 연구의 결과가 현행 DBMS들의 능동형 규칙(active rule)에 적용될 수 있도록 구체적 대안을 제시하였다.

6-유형 별로 적응적 계층 구조를 갖는 인쇄 한글 인식 (Printed Hangul Recognition with Adaptive Hierarchical Structures Depending on 6-Types)

  • 함대성;이득용;최경웅;오일석
    • 한국콘텐츠학회논문지
    • /
    • 제10권1호
    • /
    • pp.10-18
    • /
    • 2010
  • 한글 인식은 부류 수가 많다는 특성을 가지며 이 특성으로 인해 6-유형으로 사전 분류하는 것이 일반적이다. 사전 분류 후 각 유형들은 초성, 중성, 종성으로 분리하여 인식할 수 있다. 초성, 중성, 종성 각각은 부류의 수는 적지만 'ㅔ', 'ㅖ', 과 같이 서로간의 유사도가 높아 오 인식 되는 경우가 종종 발생한다. 따라서 본 논문에서는 6-유형 각각에 대해 다단계 트리 구조를 가진 계층적 인식 방법을 제안 하였다. 또한 초성, 중성, 종성의 서로 간의 간섭을 줄이기 위해, 초성과 종성의 인식 결과를 중성 분류기의 특징으로 사용하였다. PHD08 데이터베이스의 테스트 집합에 대해 98.96%의 정확률을 보였다.

도시지역 녹화공간의 배식기법 : 공동주택단지 완충녹지의 배식 (Planting Design in Green Open Space, Urban Area : Planting Evaluation of Buffer Green Space in Housing Complex)

  • 조우
    • 한국환경생태학회지
    • /
    • 제12권1호
    • /
    • pp.78-90
    • /
    • 1998
  • 본 연구는 1980년대 후반부터 조성된 5개 신도시 공동주택단지의 완충녹지를 대상으로 녹지의 형태와 식재기법, 효과 등을 분석하여 완충녹지 조성시 배식에 이용할 수 있는 자료 구축을 목적으로 하였다. 연구대상지 완충녹지의 형태는 마운딩형, 사면형, 펴연형이었으며 식재된 수종으로는 교목은 상록수 10종, 낙엽수 20종의 총 30종이었고 관목은 총 13종 이었으며 도시공원 등의 관상용수종과 차이가 없었고 식재는 단층적으로 한 상태였다. 완충녹지에 의해 소음완화 효과는 인정되었으나 7개 조사유형중 4유형에서는 공동주택단지의 소음 기준치(65dB) 이하의 완충효과를 보이지 못했다. 소음완화효과는 마운드형이 효과적이었다. 본 연구대상지는 식재밀도, 녹지용적계수는 완충녹지의 기능을 충족시키지 못하고 있으며 자연림과 비교했을 때 식재밀도가 매우 적었고 녹지용적계수도 기준 녹지에 비해 션격히 낮은 값을 나타내어 개선이 요구되었다. 완충녹지는 높이를 2m 이상으로 한 마운딩형으로 조성지역 인근 자연림의 식생구조를 모델로 하는 복층적 식재기법을 이요하여 조성하는 것이 바람직한 것으로 판단되었다.

  • PDF