• 제목/요약/키워드: Database and statistics

검색결과 435건 처리시간 0.028초

Disagreement of ICD-10 Codes Between a Local Hospital Information System and a Cancer Registry

  • Sriplung, Hutcha;Kantipundee, Tirada;Tassanapitak, Cheamjit
    • Asian Pacific Journal of Cancer Prevention
    • /
    • 제16권1호
    • /
    • pp.259-263
    • /
    • 2015
  • Background: In the field of cancer, the ICD-10 coding convention is based on the site of a neoplasm in the body and usually ignores the morphology, thus the same code may be assigned to tumors of different morphologic types in an organ. Nowadays, all general (provincial) and center hospitals in Thailand are equipped with the hospital information system (HIS) database. Objective: This study aimed to find the characteristics and magnitude of agreement represented by the positive predictive value (PPV) of provisional cancer diagnoses in the HIS database in Pattani Hospital in Thailand in comparison with the final cancer diagnosis of the ICD-10 codes generated from a well established cancer registry in Songklanagarind Hospital, the medical school hospital of Prince of Songkla University. Materials and Methods: Data on cancer patients residing in Pattani province who visited Pattani Hospital from January 2007 to May 2011 were obtained from the HIS database. The ICD-10 codes of the HIS computer database of Pattani Hospital were compared against the ICD-10 codes of the same person recorded in the hospital-based cancer registry of Songklanagarind Hospital. The degree of agreement or positive predictive value (PPV) was calculated for each sex and for both sexes combined. Results: A total of 313 cases (15.9%) could be matched in the two databases. Some 222 cases, 109 males and 113 females, fulfilled the criteria of referral from Pattani to Songklanagarind Hospitals. Of 109 male cancer cases, 76 had the same ICD-10 codes in both hospitals, thus, the PPV was 69.7% (95%CI: 60.2-78.2%). Agreement in 76 out of 113 females gave a PPV of 67.3% (95%CI: 57.8-75.8%). The two percentages were found non-significant with Fisher's exact p-value of 0.773. The PPV for combined cases of both sexes was 68.5% (95%CI: 61.9-74.5%). Conclusions: Changes in final diagnosis in the referral system are common, thus the summary statistics of a hospital without full investigation facilities must be used with care, as the statistics are biased towards simple diseases able to be investigated by available facilities. A systematic feedback of patient information from a tertiary to a referring hospital should be considered to increase the accuracy of statistics and to improve the comprehensive care of cancer patients.

Dr. Image를 이용한 구강악안면방사선과 의료영상 관리 (Management of oral and maxillofacial radiological images)

  • 김은경
    • Imaging Science in Dentistry
    • /
    • 제32권3호
    • /
    • pp.129-134
    • /
    • 2002
  • Purpose : To implement the database system of oral and maxillofacial radiological images using a commercial medical image management software with personally developed classification code. Materials and methods : The image database was built using a slightly modified commercial medical image management software, Dr. Image v.2.1 (Bit Computer Co., Korea). The function of wild card '*' was added to the search function of this program. Diagnosis classification codes were written as the number at the first three digits, and radiographic technique classification codes as the alphabet right after the diagnosis code. 449 radiological films of 218 cases from January, 2000 to December, 2000, which had been specially stored for the demonstration and education at Dept. of OMF Radiology of Dankook University Dental Hospital, were scanned with each patient information. Results: Cases could be efficiently accessed and analyzed by using the classification code. Search and statistics results were easily obtained according to sex, age, disease diagnosis and radiographic technique. Conclusion : Efficient image management was possible with this image database system. Application of this system to other departments or personal image management can be made possible by utilizing the appropriate classification code system.

  • PDF

KRISTAL기반의 FSTA 구축을 위한 효율적인 관리 시스템 구현 (Efficient Management System Implementation for FSTA Database based on KRISTAL)

  • 윤희준;이석형;윤화묵;김한기
    • 한국콘텐츠학회:학술대회논문집
    • /
    • 한국콘텐츠학회 2006년도 춘계 종합학술대회 논문집
    • /
    • pp.495-498
    • /
    • 2006
  • 국내의 정보서비스 업체나 기관들은 세계적인 과학기술정보의 최신 동향과 연구 정보를 제공하기 위해 해외에서 발행된 데이터베이스를 도입, 구축한 정보를 서비스로 제공하고 있다. 여러 데이터베이스 중에서 FSTA(Food Science and Technology Abstracts)는 전 세계의 식품과학, 식품공학, 식품기술 및 음식과 관련된 식품 영양학에 관한 광범위한 초록 정보를 제공하는 데이터베이스이다. 식품과학에 관련된 정보를 유일하게 제공하는 FSTA 데이터베이스를 한국과학기술정보연구원(KISTI)에서 개발한 정보검색관리 시스템인 KRISTAL를 기반으로 데이터베이스를 구축하여 서비스를 제공할 수 있도록 데이터베이스 도입, 구축, 검색, 수정, 재구축, 통계 등의 여러 과정이 필요하다. 본 논문은 국내 이용자들에게 FSTA 데이터베이스의 정보를 서비스하기 위해 FSTA 데이터베이스를 입수하는 단계부터 KRISTAL 정보검색관리 시스템에 구축하는 단계까지의 과정을 체계적으로 구축하여 효율적으로 관리할 수 있도록 하는 시스템을 구현하는데 있다. 보다 빠르고 정확한 FSTA 데이터베이스 구축을 통해 사용자들은 최신의 FSTA 데이터베이스를 검색하여 원하는 정보를 얻을 수 있다.

  • PDF

재해 취약성 평가를 위한 기상자료 처리 프로그램 MetSystem 개발 (Development of Meteorologic Data Retrieval Program for Vulnerability Assessment to Natural Hazards)

  • 장민원;김상민
    • 농촌계획
    • /
    • 제19권4호
    • /
    • pp.47-54
    • /
    • 2013
  • Climate change is the most direct threatening factors in sustaining agricultural productivity. It is necessary to reduce the damages from the natural hazards such as flood, drought, typhoons, and snowstorms caused by climate change. Through the vulnerability assessment to adapt the climate change, it is possible to analyze the priority, feasibility, effect of the reduction policy. For the vulnerability assessment, broad amount of weather data for each meterological station are required. Making the database management system for the meteorologic data could troubleshoot of the difficulties lie in handling and processing the weather data. In this study, we generated the meteorologic data retrieval system (MetSystem) for climate change vulnerability assessment. The user interface of MetSystem was implemented in the web-browser so as to access to a database server at any time and place, and it provides different query executions according to the criteria of meteorologic stations, temporal range, meteorologic items, statistics, and range of values, as well as the function of exporting to Excel format (*.xls). The developed system is expected that it will make it easier to try different analyses of vulnerability to natural hazards by the simple access to meteorologic database and the extensive search functions.

Nationwide Mortality Data after Flow-Diverting Stent Implantation in Korea

  • Kim, Tackeun;Kwon, O-Ki;Lee, Heeyoung;Cho, Min Jai;Jeong, Hyun Jean;Ban, Seung Pil
    • Journal of Korean Neurosurgical Society
    • /
    • 제61권2호
    • /
    • pp.219-223
    • /
    • 2018
  • Objective : To investigate nationwide statistics on flow-diverting stent usage for cerebral aneurysm treatment and related mortality data. Methods : We requested data extraction from the National Health Insurance Service claims database using electronic data interchange codes (J3207064, J3207073). Patient and hospital information as well as death statistics were collected from the database. Results : A total of 169 procedures were performed using flow-diverting stents for cerebral aneurysm treatment from November 2014 to December 2016 in Korea. The majority of primary diagnosis was unruptured intracranial aneurysm. During the study period, nine subjects died, including one patient initially diagnosed with subarachnoid hemorrhage. The crude mortality rate was 5.3%. Five patients died within one month after the procedure; therefore, the estimated periprocedural mortality rate was $3.0{\pm}1.3%$. The mortality rate as of the last day of 2016 was $6.3{\pm}2.1%$. Conclusion : In a 171 person-year follow-up in a Korean series, nine deaths occurred after flow-diverting stent treatment. The crude mortality rate in Korea (5.3%) was higher than that reported in a previous meta-analysis (3.8%).

클라우드 컴퓨팅 환경에서 데이터 관리 및 교환을 위한 표준화 방안 연구 (A Study on Standardization for Data Management and Exchange in Cloud Computing Environments)

  • 정동원;박혜민;두미경;임성준
    • 한국컴퓨터정보학회:학술대회논문집
    • /
    • 한국컴퓨터정보학회 2012년도 제45차 동계학술발표논문집 20권1호
    • /
    • pp.113-115
    • /
    • 2012
  • 이 논문에서는 클라우드 컴퓨팅 환경을 위한 데이터 관리 및 교환을 위한 표준화 방안에 대하여 논의한다. 클라우드 컴퓨팅은 최근 많은 관심이 집중되어 있으며, 최근 국내 외 표준 개발 활동이 활발하게 이루어지고 있다. 데이터 교환 및 공유는 클라우드 컴퓨팅 환경은 물론 다양한 컴퓨팅 환경에서 기본적으로 해결되어야 하는 주제이다. 현재 클라우드 컴퓨팅 분야의 국제 표준화 기구에서 표준 개발 활동이 이루어지고 있다. 이 논문에서는 데이터 관리 및 교환 분야에서 기반 표준을 개발하고 있는 ISO/IEC JTC 1/SC 32의 표준화 현황을 분석하고, 이를 기반으로 클라우드 컴퓨팅 환경에서 데이터 교환 및 공유를 위한 표준화 방안에 대하여 기술한다.

  • PDF

Prediction of skewness and kurtosis of pressure coefficients on a low-rise building by deep learning

  • Youqin Huang;Guanheng Ou;Jiyang Fu;Huifan Wu
    • Wind and Structures
    • /
    • 제36권6호
    • /
    • pp.393-404
    • /
    • 2023
  • Skewness and kurtosis are important higher-order statistics for simulating non-Gaussian wind pressure series on low-rise buildings, but their predictions are less studied in comparison with those of the low order statistics as mean and rms. The distribution gradients of skewness and kurtosis on roofs are evidently higher than those of mean and rms, which increases their prediction difficulty. The conventional artificial neural networks (ANNs) used for predicting mean and rms show unsatisfactory accuracy in predicting skewness and kurtosis owing to the limited capacity of shallow learning of ANNs. In this work, the deep neural networks (DNNs) model with the ability of deep learning is introduced to predict the skewness and kurtosis on a low-rise building. For obtaining the optimal generalization of the DNNs model, the hyper parameters are automatically determined by Bayesian Optimization (BO). Moreover, for providing a benchmark for future studies on predicting higher order statistics, the data sets for training and testing the DNNs model are extracted from the internationally open NIST-UWO database, and the prediction errors of all taps are comprehensively quantified by various error metrices. The results show that the prediction accuracy in this study is apparently better than that in the literature, since the correlation coefficient between the predicted and experimental results is 0.99 and 0.75 in this paper and the literature respectively. In the untrained cornering wind direction, the distributions of skewness and kurtosis are well captured by DNNs on the whole building including the roof corner with strong non-normality, and the correlation coefficients between the predicted and experimental results are 0.99 and 0.95 for skewness and kurtosis respectively.

Development of new on-line statistical program for the Korean Society for Radiation Oncology

  • Song, Si Yeol;Ahn, Seung Do;Chung, Weon Kuu;Shin, Kyung Hwan;Choi, Eun Kyung;Cho, Kwan Ho
    • Radiation Oncology Journal
    • /
    • 제33권2호
    • /
    • pp.142-148
    • /
    • 2015
  • Purpose: To develop new on-line statistical program for the Korean Society for Radiation Oncology (KOSRO) to collect and extract medical data in radiation oncology more efficiently. Materials and Methods: The statistical program is a web-based program. The directory was placed in a sub-folder of the homepage of KOSRO and its web address is http://www.kosro.or.kr/asda. The operating systems server is Linux and the webserver is the Apache HTTP server. For database (DB) server, MySQL is adopted and dedicated scripting language is the PHP. Each ID and password are controlled independently and all screen pages for data input or analysis are made to be friendly to users. Scroll-down menu is actively used for the convenience of user and the consistence of data analysis. Results: Year of data is one of top categories and main topics include human resource, equipment, clinical statistics, specialized treatment and research achievement. Each topic or category has several subcategorized topics. Real-time on-line report of analysis is produced immediately after entering each data and the administrator is able to monitor status of data input of each hospital. Backup of data as spread sheets can be accessed by the administrator and be used for academic works by any members of the KOSRO. Conclusion: The new on-line statistical program was developed to collect data from nationwide departments of radiation oncology. Intuitive screen and consistent input structure are expected to promote entering data of member hospitals and annual statistics should be a cornerstone of advance in radiation oncology.

국내 의과대학 교수의 암정보 활용 현황과 요구도 (The Current Status of Utilization and Demand on Cancer Information in the Faculties of Medical School in Korea)

  • 임민경;박숙경;양정희;이영성
    • Journal of Preventive Medicine and Public Health
    • /
    • 제36권1호
    • /
    • pp.39-46
    • /
    • 2003
  • Objectives : To investigate the availability and demand for overall cancer-related information, and to establish a basic plan for the construction of a cancer database and information system based on the research results from Korea. Methods : Postal and telephone surveys were carried out, between August 2001 and November 2001, of 323 affiliated faculty professors from medical universities and colleges in Korea. The data were analyzed with descriptive statistical methods, with regard to the present status and demand for health and cancer-related information. Results : Most (over 80%) subjects studied utilized the health-related information provided on Internet website from foreign countries, such as Medline, but similar comprehensive information system lacked in Korea. The construction of a cancer-related database of domestic research results was revealed to be in a great demand. Information on registration and statistics (52.8%), study results (48.5%) and study resources (37.4%) were the major ingredients required in the database. In constructing a database of the cancer-related research results, a full-text service, continuous updating of data, and the development of standardized user-friendly searching tool were regarded as the necessary components. The formulation of an information sharing system, regarding cancer-related clinical trials, was investigated as being quite feasible. Conclusion : This study demonstrated the great importance of cancer information systems, and much demand for an available cancer-related database based on Korean research results.

자연재해 평가를 위한 방재기상 DB 정보 (Prevention Meteorological Database Information for the Assessment of Natural Disaster)

  • 박종길;정우식;최효진
    • 한국방재학회 논문집
    • /
    • 제7권3호
    • /
    • pp.41-49
    • /
    • 2007
  • 자연재해로부터 야기되는 피해를 줄이고 자연재해저감활동을 전개하기 위해서는 기상정보와 재해자료에 근거한 정확한 예보와 방재활동이 요구된다. 또한 사전방재활동을 위해서는 방재기상정보로의 처리가 필요하다. 이를 위하여 본 연구에서는 행정자치부에서 발행하는 통계연보와 재해연보, 중앙재해대책본부에서 발행한 최근 10년간 자연재해 피해 현황, 기상청에서 발행한 기상연보를 이용하였다. 이들 4가지 자료를 이용하여 자연재해의 원인과 피해요소, 발생빈도, 취약지역 등을 분석하였는데, 이들 자료는 피해내역과 기상현상에 대한 분류 및 용어가 일치하지 않으므로, 재해의 종류와 피해액을 비교 분석한 결과, 기상재해 원인과 피해 요소, 피해액, 피해지역 등과 같은 재해 변수를 선정하고, 재해연보를 이용하여 database를 구축하였다. 이렇게 구축된 database는 앞으로 자연재해 저감계획과 risk model을 개발하고 자연재해를 평가하는데 유용하게 쓰일 수 있다.