• Title/Summary/Keyword: Database(DB)

Search Result 1,498, Processing Time 0.033 seconds

The Study on the Development of Analysis and Management System for Traffic Accident Spatial DB (교통사고 공간 DB관리 및 분석 시스템 개발에 관한 연구)

  • Yu Ji Yeon;Jeon Jae Yong;Jeon Hyeong Seob;Cho Gi Sung
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.23 no.4
    • /
    • pp.345-352
    • /
    • 2005
  • In up-to-date information anger time it is caused by with business of traffic accident control and analysis and two time it accomplishes a business. National Police Office which controls a traffic accident does not execute an up-to-date technique. And, it is working yet by the hand, There is to traffic accident analysis and the research regarding the analysis against the research which it follows in geography element and composition element and an accident cause is weak. Consequently, effectively establishment and it enforces a traffic safety policy and from the hazard which it evaluates traffic accident data the system and scientific analysis against a traffic accident occurrence cause and a feature in basic must become accomplished. The research which it sees constructs a traffic accident data in GIS base. It is like that, it uses the PDA where is not the collection of data of text form in existing and at real-time it converts store and an accident data rightly in standard traffic accident data form and it will be able to manage. It was related with a space data peculiarity and the research regarding the system development with the geography analysis data about an accident cause under manifesting it accomplished.

A Study on the Characteristics of the Patients Discharged Against Medical Advice (한 대학병원 자의퇴원 환자의 특성 연구 - 퇴원환자 지료정보 DB를 이용하여 -)

  • Hong, Joonhyun;Choi, Kwisook;Lee, Jeonghwa;Lee, Eunmee
    • Quality Improvement in Health Care
    • /
    • v.8 no.2
    • /
    • pp.208-217
    • /
    • 2001
  • Background : The objective of this study is proving the basic data for developing a management system for the discharges against medical advice(AMA) by identifying the characteristics of the AMA patients of an university hospital for 10 years. Methods : By using discharge abstract data base, we divided the total discharges(435,254) into two groups, discharge against medical advice and discharge with discharge order. We confirmed the characteristics of AMA group by analyzing discharge abstract data of the both groups by SAS software V6.12 and $x^2$ test. Medical records of AMA patients in the year 2000 were reviewed to identify the reasons for AMA which we couldn't extract from discharge abstract DB. Result : The total number of AMA for 10 years were 9,358(2.15%) and the AMA rate has been continuously decreased for 10 years. Male, admission through emergency room, discharges admission via other hospital, patients without operation during hospitalization, discharges in hopeless or not improved condition showed higher AMA rate. The AMA rate was higher as the age of the patients was higher, and the average length of stay was longer in AMA patients than in those with discharge order. The AMA rate in psychiatry was highest(14.3%) and it was higher in surgery departments than those of medical or other sections. The AMA rate varied by attending physicians even in the same department and it was statistically significant. Patients with the principal diagnosis of "medical observation and evaluation for suspected diseases" showed the highest AMA rate(15.5%), and that of schizophrenia or psychosis was the nest. One hundred twenty-one patients(19.5%) out of 622 AMA in 2000 discharged against medical advice for transfer to order health care facilities. Among them 71 patients(58.7%) discharged with their medical care information, such as copies of medical record, medical certificates, summaries, etc. Written oath of the patients discharged AMA was filed in their medical records in 466 cases(74.9%) although some of them were incomplete. Conclusion : Characteristics of AMA discharge could be used as the basic data in developing a system to manage the patients who have risk factors to leave the hospital against medical advice. By reducing number of patients leaving the hospital against medical advice we can increase satisfaction of medical providers and consumers.

  • PDF

Development of an Informetric Analysis System KnowledgeMatrix (계량정보분석시스템 KnowledgeMatrix 개발)

  • Lee, Bangrae;Yeo, Woon Dong;Lee, June Young;Lee, Chang-Hoan;Kwon, Oh-Jin;Moon, Yeong-ho
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2007.11a
    • /
    • pp.167-171
    • /
    • 2007
  • Application areas of Knowledge Discovery in Database (KDD) have been expanded into many R&D management processes including technology trends analysis, forecasting and evaluation etc. Established research field such as informetrics (or scientometrics) has recently fully utilized techniques or methods of KDD. Various systems have been developed to support works of analyzing large-scale R&D related databases such as patent DB or bibliographic DB by a few researchers or institutions. But extant systems have some problems for korean users to use. Their prices is not cheap, korean language process not available, and user's demands not reflected. To solve these problems, Korea Institute of Science and Technology Information (KISTI) developed stand-alone type information analysis system named as KnowledgeMatrix. KnowledgeMatrix system offer various functions to analyze retrieved data set from databases. Knowledge Matrix main operation unit is composed of user-defined lists and matrix generation, cluster analysis, visualization, data pre-processing. KnowledgeMatrix show better performances and offer more various functions than extant systems.

  • PDF

Development of the KnowledgeMatrix as an Informetric Analysis System (계량정보분석시스템으로서의 KnowledgeMatrix 개발)

  • Lee, Bang-Rae;Yeo, Woon-Dong;Lee, June-Young;Lee, Chang-Hoan;Kwon, Oh-Jin;Moon, Yeong-Ho
    • The Journal of the Korea Contents Association
    • /
    • v.8 no.1
    • /
    • pp.68-74
    • /
    • 2008
  • Application areas of Knowledge Discovery in Database(KDD) have been expanded to many R&D management processes including technology trends analysis, forecasting and evaluation etc. Established research field such as informetrics (or scientometrics) has utilized techniques or methods of KDD. Various systems have been developed to support works of analyzing large-scale R&D related databases such as patent DB or bibliographic DB by a few researchers or institutions. But extant systems have some problems for korean users to use. Their prices is not moderate, korean language processing is impossible, and user's demands not reflected. To solve these problems, Korea Institute of Science and Technology Information(KISTI) developed stand-alone type information analysis system named as KnowledgeMatrix. KnowledgeMatrix system offer various functions to analyze retrieved data set from databases. KnowledgeMatrix's main operation unit is composed of user-defined lists and matrix generation, cluster analysis, visualization, data pre-processing. Matrix generation unit help extract information items which will be analyzed, and calculate occurrence, co-occurrence, proximity of the items. Cluster analysis unit enable matrix data to be clustered by hierarchical or non-hierarchical clustering methods and present tree-type structure of clustered data. Visualization unit offer various methods such as chart, FDP, strategic diagram and PFNet. Data pre-processing unit consists of data import editor, string editor, thesaurus editor, grouping method, field-refining methods and sub-dataset generation methods. KnowledgeMatrix show better performances and offer more various functions than extant systems.

The Application of Species Richness Estimators and Species Accumulation Curves to Traditional Ethnobotanical Knowledges in South Korea (남한지역 전통민속식물지식 자료를 활용한 종누적곡선 분석 및 종풍부도 추정 연구)

  • Park, Yuchul;Chang, Kae Sun;Kim, Hui
    • Korean Journal of Plant Resources
    • /
    • v.30 no.5
    • /
    • pp.481-488
    • /
    • 2017
  • Under circumstances of rapid disappearing of traditional ethnobotanical knowledge, traditional ethnobotanical knowledge surveys are the major step in documenting useful species with a conservation priority. In the ethnobotanical research, the relevance to the survey intensity, ethnobotanical information and plant species richness is the most important research theme. We made up TEK database in south Korea using metadata which had been published by the Korea National Arboretum. We calculated species richness using species richness estimator like ACE, Chao1, Chao2, ICE, Jack 1, Jack 2, and Bootstrap. Species accumulation curves showed each province sampling efforts appeared to be wide range of variance so that Gangwon province need more sampling efforts, and Chungnam province approached a horizontal asymptote earlier. We found heterogeneous patterns in the rarefaction curves of TEK species between gender for each categories of use (medicinal, food and handicrafts). Comparing with regional floral diversities, it was predicted that more diverse species would be found in some provinces by carrying out additional survey.

Antioxidant capacity in seedling of colored-grain wheat under water deficit condition

  • Kim, Dae Yeon;Hong, Min Jeong;Jung, Woo Joo;Seo, Yong Weon
    • Proceedings of the Korean Society of Crop Science Conference
    • /
    • 2017.06a
    • /
    • pp.140-140
    • /
    • 2017
  • Nutritious and functional foods from crop have received great attention in recent years. Colored-grain wheat contains high phenolic compound and a large number of flavonoid. The anthocyanin and polyphenolic synthesis and accumulation is generally stimulated in response to biotic or abiotic stresses. Here, we analyzed genome wide transcripts in seedling of colored-grain wheat response to ABA and PEG treatment. About 900 and 1500 transcripts (p-value < 0.05) from ABA and PEG treatment were aligned to IWGSC1+popseq DB which is composed of over 110,000 transcripts including 100,934 coding genes. NR protein sequences of Poaceae from NCBI and protein sequence of transcription factors originated from 83 species in plant transcription factor database v3.0 were used for annotation of putative transcripts. Gene ontology analysis were conducted and KEGG mapping was performed to show expression pattern of biosynthesis genes related in flavonoid, isoflavonoid, flavons and anthocyanin biopathway. DroughtDB (http://pgsb.helmholtz-muenchen.de/droughtdb/) was used for detection of DEGs to explain that physiological and molecular drought avoidance by drought tolerance mechanisms. Drought response pathway, such as ABA signaling, water and ion channels, detoxification signaling, enzymes of osmolyte biosynthesis, phospholipid metabolism, signal transduction, and transcription factors related DEGs were selected to explain response mechanism under water deficit condition. Anthocyanin, phenol compound, and DPPH radical scavenging activity were measured and antioxidant activity enzyme assays were conducted to show biochemical adaptation under water deficit condition. Several MYB and bHLH transcription factors were up-regulated in both ABA and PEG treated condition, which means highly expressed MYB and bHLH transcription factors enhanced the expression of genes related in the biosynthesis pathways of flavonoids, such as anthocyanin and dihydroflavonols in colored wheat seedlings. Subsequently, the accumulation of total anthocyanin and phenol contents were observed in colored wheat seedlings, and antioxidant capacity was promoted by upregulation of genes involved in maintaining redox state and activation of antioxidant scavengers, such as CAT, APX, POD, and SOD in colored wheat seedlings under water deficit condition. This work may provide valuable and basic information for further investigation of the molecular responses of colored-grain wheat to water deficit stress and for further gene-based studies.

  • PDF

Development of the Precision Image Processing System for CAS-500 (국토관측위성용 정밀영상생성시스템 개발)

  • Park, Hyeongjun;Son, Jong-Hwan;Jung, Hyung-Sup;Kweon, Ki-Eok;Lee, Kye-Dong;Kim, Taejung
    • Korean Journal of Remote Sensing
    • /
    • v.36 no.5_2
    • /
    • pp.881-891
    • /
    • 2020
  • Recently, the Ministry of Land, Infrastructure and Transport and the Ministry of Science and ICT are developing the Land Observation Satellite (CAS-500) to meet increased demand for high-resolution satellite images. Expected image products of CAS-500 includes precision orthoimage, Digital Surface Model (DSM), change detection map, etc. The quality of these products is determined based on the geometric accuracy of satellite images. Therefore, it is important to make precision geometric corrections of CAS-500 images to produce high-quality products. Geometric correction requires the Ground Control Point (GCP), which is usually extracted manually using orthoimages and digital map. This requires a lot of time to acquire GCPs. Therefore, it is necessary to automatically extract GCPs and reduce the time required for GCP extraction and orthoimage generation. To this end, the Precision Image Processing (PIP) System was developed for CAS-500 images to minimize user intervention in GCP extraction. This paper explains the products, processing steps and the function modules and Database of the PIP System. The performance of the System in terms of processing speed, is also presented. It is expected that through the developed System, precise orthoimages can be generated from all CAS-500 images over the Korean peninsula promptly. As future studies, we need to extend the System to handle automated orthoimage generation for overseas regions.

A Study on the Improvement of River Management System Based on Riverbed Change Data Management Program for Utilization of Advanced Bathymetry Data (선진화된 하천측량자료 활용 및 관리를 위한 하상변동 자료관리 프로그램 기반의 하도유지관리체계 개선에 관한 연구)

  • Jo, Myung-Hee;Kim, Kyung-Jun;Kim, Hyun-Jung
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.16 no.3
    • /
    • pp.115-125
    • /
    • 2013
  • The systematic management of river is difficult due to various environmental factors such as season and terrain deformation. Especially, river terrain are rapidly changing by natural and anthropogenic factors such as torrential rain during the summer and river development projects. Thus in this conditions, building the advanced river management system is an essential condition to support the ongoing management of survey data and to acquire data regularly through river terrain survey in order to maintain an active river. The need to build an efficient system have been increased through the enhancement and advancement of River Management Geographic Information Systems(RIMGIS). In this study, database design system and Riverbed Change Data Management Program was developed for systematic management of new river terrain survey data and the efficient use of river data dynamic changes. The key features are construction of river survey data, cross and longitudinal section monitoring and analysis of riverbed change data. Maintenance tasks which can be utilized in river-based architecture was constructed. The expected results are to be able to manage river systematically, and utilization of river topographic survey data efficiently for river maintenance work.

A Study on the Satisfaction Analysis on Officially Assessed Land Price Using Time Seriate Geostatistical Analysis (시계열적 공간통계 기법을 활용한 공시지가의 만족도 분석에 관한 연구)

  • Choi, Byoung Gil;Na, Young Woo;Hyeon, Chang Seop;Cho, Tae In
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.36 no.2
    • /
    • pp.95-104
    • /
    • 2018
  • This study has the purpose of suggesting the method to analyze the spatiotemporal change of satisfaction concerning the officially assessed land price using geostatistical analysis. Analyzing the spatial distribution characteristic of officially assessed land price using present GIS (Geographic Information System) or is staying at qualitatively suggesting the improvement method of the officially assessed land price system. Grouping the appeal strength based on the official price and opinion price of officially assessed land price, GIS DB (Database) was constructed and the time seriate satisfaction were analyzed and compared through spatial density analysis and spatial autocorrelation analysis. As a result, it was found that the difference between the official price and the applicant's price differed depending on individual land, but most of the respondents requested the increase or the reduction of the average land price, which resulted in a large number of request. Analyzing the satisfaction of the officially assessed land price by using GIS, it was known that satisfaction of officially assessed land price could be analyzed by using the difference of the opinion price and not only the officially assessed land price. Spatiotemporal change of officially assessed land price satisfaction was known to be possible through spatiotemporal pattern analysis method such as spatiotemporal auto-corelation analysis and hotspot analysis etc using GIS. In short, regionally positive or negative significant relationship was investigated through spatiotemporal analysis using annual data.

Automatic Measurement Method of Traffic Signs Using Image Recognition and Photogrammetry Technology (영상인식과 사진측량 기술을 이용한 교통표지 자동측정 방법)

  • Chang, Sang Kyu;Kim, Jin Soo
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.21 no.3
    • /
    • pp.19-25
    • /
    • 2013
  • Recently, more accurate database information of facilities is being required, with the increase in importance of urban road facility management. Therefore, this study proposed how to automatically detect particular traffic signs necessary for efficient construction of road facility DB. For this study, central locations of facilities were searched, after recognition and automatic detection of particular traffic signs through an image. Then, coordinate values of traffic signs calculated in the study were compared with real coordinate values, in order to evaluate the accuracy of traffic sign locations which were finally detected. Computer vision technology was used in recognizing and detecting traffic signs through OPEN CV-based coding, and photogrammetry was used in calculating accurate locations of detected traffic signs. For the experiment, circular road signal(No Parking) and triangular road signal(Crosswalk) were chosen out of various kinds of road signals. The research result showed that the circular road signal had a nearly 50cm error value, and the triangular road signal had a nearly 60cm error value, when comparing the calculated coordinates with the real coordinates. Though this result is not satisfactory, it is considered that there would be no problem to find locations of traffic signs.