• Title/Summary/Keyword: public database

검색결과 823건 처리시간 0.023초

지자체의 복식부기 자산평가를 위한 GIS적용 -거제시를 중심으로- (Application of GIS for Assessing Asset by Double Entry Bookkeeping in Local Government -Focused on Geoje City-)

  • 김동규;조은래;;유환희
    • 한국측량학회지
    • /
    • 제26권2호
    • /
    • pp.175-182
    • /
    • 2008
  • 지방정부는 자체 관할지역에 위치한 모든 자산들을 공적 업무수행을 통해 보호하고 관리하기 위해 공적문서를 작성할 필요가 있으며, 2007년 1월부터 중앙정부는 복식부기 회계제도를 도입하여 자산 및 채무에 관련된 각종 자산관리보고서를 작성하여 운영할 것을 지자체에 강력히 요구하고 있다. 하지만 지하에 설치된 시설물과 같이 몇몇 시설물들은 정확한 조사가 어려운 실정이다. 이에 본 연구에서는 GIS사업에서 구축한 데이터베이스를 사용하여 복식부기에 근거한 지자체의 사회간접자본시설물의 자산평가를 실시하기 위한 방안을 제시하였다. 경남 거제시의 경우를 분석한 결과, 도로 및 상수도시설물과 같은 시설물에 대해서는 GIS 데이터베이스에 있는 항목의 $70{\sim}80%$는 복식부기에 의한 자산평가에 활용될 수 있음을 알 수 있었다. 그러나 복식부기제도와 GIS사업간의 연계성이 미약한 관계로 향후 지자체에서 복식부기를 실질적으로 사용하기 위한 연구가 더 필요하다고 판단된다.

Development of a Tailored Analysis System for Korean Working Conditions Survey

  • Seo, Hwa Jeong
    • Safety and Health at Work
    • /
    • 제7권3호
    • /
    • pp.201-207
    • /
    • 2016
  • Background: Korean Working Conditions Surveys (KWCS), referencing European Working Conditions Surveys, have been conducted three times in order to survey working condition and develop work-related policies. However, we found three limitations for managing the collected KWCS data: (1) there was no computerized system for managing data; (2) statistical KWCS data were provided by limited one-way communication; and (3) the concept of a one-time provision of information was pursued. We suggest a web-based public service system that enables ordinary people to make greater use of the KWCS data, which can be managed constantly in the future. Methods: After considering data characteristics, we designed a database, which was able to have the result of all pairwise combinations with two extracted data to construct an analysis system. Using the data of the social network for each user, the tailored analysis system was developed. This system was developed with three methods: clustering and classification for building a social network, and an infographic method for improving readability through a friendly user interface. Results: We developed a database including one input entity consisting of the sociodemographic characteristics and one output entity consisting of working condition characteristics, such as working pattern and work satisfaction. A web-based public service system to provide tailored contents was completed. Conclusion: This study aimed to present a customized analysis system to use the KWCS data efficiently, provide a large amount of data in a form that can give users a better understanding, and lay the ground for helping researchers and policy makers understand the characteristics.

동시 트랜잭션이 많은 데이터베이스에서 효과적인 개인정보보호 시스템 연구 (A Study of Effective Privacy Protection System on High Concurrent Transaction Database System)

  • 강지원
    • 융합보안논문지
    • /
    • 제12권2호
    • /
    • pp.107-113
    • /
    • 2012
  • 최근 개인정보보호법 제정에 따라 인터넷에서 개인정보를 취급하는 공공기관 및 기업들은 개인정보 보호를 위해 접근제어, 암호화 등 기술적 대책을 강구하고 있다. 개인정보 유출시 공공기관이나 기업은 이미지 훼손뿐만 아니라, 법적책임을 면할 수 없는 실정이다. 그러나, 대용량 데이터베이스 시스템에서 매 접속 시마다 개인정보 항목에 대해 접근제와와 암 복호화를 하도록 하는 것은 성능 저하의 원인이 된다. 본 논문에서는 동시 트랜잭션이 많은 Oracle DBMS 환경에서 JVM(Java Virtual Machine)을 이용한 경량화 시스템을 설계 구현하여 성능에 최소한 영향을 미치면서 개인정보보호법에 정한 요구사항을 효율적이고 안전하게 수행하는 시스템을 제안하였다. 제안 시스템을 A 공공기관 포털 및 인사 시스템 내 개인정보 보호에 적용하여 성능 차이를 검증하였다.

Identification of druggable genes for multiple myeloma based on genomic information

  • Rahmat Dani Satria;Lalu Muhammad Irham;Wirawan Adikusuma;Anisa Nova Puspitaningrum;Arief Rahman Afief;Riat El Khair;Abdi Wira Septama
    • Genomics & Informatics
    • /
    • 제21권3호
    • /
    • pp.31.1-31.8
    • /
    • 2023
  • Multiple myeloma (MM) is a hematological malignancy. It is widely believed that genetic factors play a significant role in the development of MM, as investigated in numerous studies. However, the application of genomic information for clinical purposes, including diagnostic and prognostic biomarkers, remains largely confined to research. In this study, we utilized genetic information from the Genomic-Driven Clinical Implementation for Multiple Myeloma database, which is dedicated to clinical trial studies on MM. This genetic information was sourced from the genome-wide association studies catalog database. We prioritized genes with the potential to cause MM based on established annotations, as well as biological risk genes for MM, as potential drug target candidates. The DrugBank database was employed to identify drug candidates targeting these genes. Our research led to the discovery of 14 MM biological risk genes and the identification of 10 drugs that target three of these genes. Notably, only one of these 10 drugs, panobinostat, has been approved for use in MM. The two most promising genes, calcium signal-modulating cyclophilin ligand (CAMLG) and histone deacetylase 2 (HDAC2), were targeted by four drugs (cyclosporine, belinostat, vorinostat, and romidepsin), all of which have clinical evidence supporting their use in the treatment of MM. Interestingly, five of the 10 drugs have been approved for other indications than MM, but they may also be effective in treating MM. Therefore, this study aimed to clarify the genomic variants involved in the pathogenesis of MM and highlight the potential benefits of these genomic variants in drug discovery.

국내 의과대학 교수의 암정보 활용 현황과 요구도 (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.

데이터마이닝 기법을 이용한 건강보험공단의 수술 통계량 근사치 추정 -허니아 수술을 중심으로- (Estimation of a Nationwide Statistics of Hernia Operation Applying Data Mining Technique to the National Health Insurance Database)

  • 강성홍;서숙경;양영자;이애경;배종면
    • Journal of Preventive Medicine and Public Health
    • /
    • 제39권5호
    • /
    • pp.433-437
    • /
    • 2006
  • Objectives: The aim of this study is to develop a methodology for estimating a nationwide statistic for hernia operations with using the claim database of the Korea Health Insurance Cooperation (KHIC). Methods: According to the insurance claim procedures, the claim database was divided into the electronic data interchange database (EDI_DB) and the sheet database (Paper_DB). Although the EDI_DB has operation and management codes showing the facts and kinds of operations, the Paper_DB doesn't. Using the hernia matched management code in the EDI_DB, the cases of hernia surgery were extracted. For drawing the potential cases from the Paper_DB, which doesn't have the code, the predictive model was developed using the data mining technique called SEMMA. The claim sheets of the cases that showed a predictive probability of an operation over the threshold, as was decided by the ROC curve, were identified in order to get the positive predictive value as an index of usefulness for the predictive model. Results: Of the claim databases in 2004, 14,386 cases had hernia related management codes with using the EDI system. For fitting the models with applying the data mining technique, logistic regression was chosen rather than the neural network method or the decision tree method. From the Paper_DB, 1,019 cases were extracted as potential cases. Direct review of the sheets of the extracted cases showed that the positive predictive value was 95.3%. Conclusions: The results suggested that applying the data mining technique to the claim database in the KHIC for estimating the nationwide surgical statistics would be useful from the aspect of execution and cost-effectiveness.

디지털기술을 이용한 복식 문화유산의 콘텐츠화 현황 (An Analysis on the Digital Contents of Costume Cultural Heritage)

  • 김여경;김정민;홍나영
    • 복식
    • /
    • 제62권4호
    • /
    • pp.136-148
    • /
    • 2012
  • The purpose of this study is to investigate the current infrastructure of database on costume cultural heritage. The contents, kinds and accessibility regarding the digital contents of the websites of literature archives, museums and culturecontent.com by Korea Creative Content Agency were analyzed. First, it was evident that the quantity and quality of the database should be improved. The literature archives are mostly comprised of historical documents; however, the quantity of the database regarding the documents that are commonly studied in the field of traditional costume is not satisfactory. On the other hand, the quality of the database depends on the in-depth understanding of the terminology because errors occur when the contents of literature are transferred to an online database. Second, various information is required to meet the needs and interests of the digital environment. Most of the museums provide information on costume cultural heritage through their websites; nevertheless, it is not thorough and only partial. Third, the reliability of information needs to improve. The various contents provided by culturecontent.com lack reliability as it focuses on the entertainment values. To increase reliability, the source and origin of the information about the costume cultural heritage should be provided and the contents should be proofread before they are exposed to the public. Based on these findings, the researchers put forward the following suggestions: the quantity and quality of the databases should be enriched, and that more diverse information is required. Finally, more attention should be paid to increase the reliability of this information. This study will be an asset for the foundation to build solid databases and popularization of the traditional costumes.

GIS를 이용한 은행마케팅 데이터베이스의 구축과 과제 (Construction and Evaluation of Bank Marketing Database using Geographic Information Systems)

  • 조명희;부기동;김광주;서준석
    • 한국지리정보학회지
    • /
    • 제1권1호
    • /
    • pp.52-69
    • /
    • 1998
  • 마케팅 GIS의 대표적인 분야인 은행마케팅에 있어서의 고객 및 점포관리를 위한 DB를 지방은행인 대구은행을 대상으로 GIS를 이용하여 구축하였다. 이를 위하여 area marketing의 기본개념과 전개방안을 검토하고 수치도로지도, 행정경계, 우편동경계 등의 위치자료와 상공인명감, 지가, 토지이용 등의 속성자료를 포함하는 은행외부자료 및 마케팅과 관련된 은행내부자료를 중심으로 구축하고, 이를 기초로 간단한 공간검색과 분석기능을 지닌 사용자 인터페이스중심의 은행 GIS 시스템을 개발하였다. GIS 기본 패키지는 Map/Info, 인터페이스를 위한 언어로는 Delphi가 각각 사용되었으며, 아울러 구축과정에 있어서의 위치 및 속성자료에 관련된 여러 가지 문제점을 종합적으로 검토 평가하였다.

데이터 품질에 기반을 둔 데이터베이스 운영관리를 위한 정보시스템 운영감리 개선 방안 (An improvement plan of information system operational audit for database operational management based on data quality)

  • 장원재;김동수;민덕기
    • 서비스연구
    • /
    • 제8권2호
    • /
    • pp.41-65
    • /
    • 2018
  • 본 연구는 데이터를 기반으로 개인 또는 기업들이 무한한 이익을 창출하는 사회가 되면서 데이터 품질을 중심으로 데이터베이스 운영관리의 중요성이 증가하고 있는데 이를 체계적으로 관리하는 국내 공공, 민간 기업이 많지 않은 상태에 대한 현황 및 문제점을 분석하고 감리인의 입장에서 개선방향을 구명하고자 하였다. 본 연구를 수행하기 위해 개선된 감리 점검항목을 도출하여 이를 기반으로 감리인 및 IT 전문가들을 통해 설문조사를 하였고, 최종 자료를 분석에 활용하여 연구 가설을 실증적으로 검증하였다. 분석 결과, 데이터 품질에 기반을 둔 데이터베이스 운영관리의 개선된 감리 점검항목에 대하여 감리인의 입장에서 모든 점검항목에 대해 매우 만족한다고 나타났다. 또한 비 감리인에 입장에서도 수용범위에 포함된다고 확인되었다. 본 연구를 통해서 정보시스템 운영감리와 기업의 데이터 운영관리의 수행에 이를 활용하여 개선할 수 있을 것이다.

건강보험 청구자료를 이용한 우리나라 천식환자의 질병비용부담 추계 (Cost-of-illness Study of Asthma in Korea: Estimated from the Korea National Health Insurance Claims Database)

  • 박춘선;권일;강대룡;정혜영;강혜영
    • Journal of Preventive Medicine and Public Health
    • /
    • 제39권5호
    • /
    • pp.397-403
    • /
    • 2006
  • Objectives: We estimated the asthma-related health care utilization and costs in Korea from the insurer's and societal perspective. Methods: We extracted the insurance claims records from the Korea National Health Insurance claims database for determining the health care services provided to patients with asthma in 2003. Patients were defined as having asthma if they had ${\geq}$2 medical claims with diagnosis of asthma and they had been prescribed anti-asthma medicines, Annual claims records were aggeregated for each patient to produce patient-specific information on the total utilization and costs. The total asthma-related cost was the sum of the direct healthcare costs, the transportation costs for visits to health care providers and the patient's or caregivers' costs for the time spent on hospital or outpatient visits. Results: A total of 699,603people were identified as asthma patients, yielding an asthma prevalence of 1.47%. Each asthma patient had 7.56 outpatient visits, 0.01 ED visits and 0.02 admissions per year to treat asthma. The per-capita insurance-covered costs increased with age, from 128,276 Won for children aged 1 to 14 years to 270,729 Won for those aged 75 or older. The total cost in the nation varied from 121,865 million to 174,949 million Won depending on the perspectives. From a societal perspective, direct health care costs accounted for 84.9%, transportation costs for 15.1 % and time costs for 9.2% of the total costs. Conclusions: Hospitalizations and ED visits represented only a small portion of the asthma-related costs. Most of the societal burden was attributed to direct medical expenditures, with outpatient visits and medications emerging as the single largest cost components.