• Title/Summary/Keyword: 데이터베이스활용

Search Result 2,879, Processing Time 0.037 seconds

A Study on Improvement Methods of Cost Estimation in Order for the Proper Management of Street Trees (도시 가로수 관리 품셈 개선에 관한 연구)

  • Do, Yoon-Taek;Han, Bong-Ho;Park, Seok-Cheol
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.50 no.4
    • /
    • pp.20-36
    • /
    • 2022
  • This study aims to provide basic data for high-quality street tree management by setting reasonable management items and appropriate unit prices by reviewing the adequacy of current street tree management. Currently, street tree management items, except for street tree pruning, use general landscape tree quantity per unit for the street tree management quantity per unit. KEPCO (Korea Electric Power Corporation) applied pruning items from standard electric production infrastructure and carried out the activities at an average unit price of 51% lower for heavy pruning and 39% lower for light pruning than the standard estimate. This was judged to be a level that could not maintain or increase the quality of street tree management. It was determined that an appropriate standard unit price for street tree management was necessary. To improve the quantity per unit for the proper management of street trees, it was necessary to review costs in the field. However, due to the absence of data on actual construction costs in the domestic landscape field, detailed items of the US RSMeans Building Construction Cost Data (RSMeans) were reviewed, and the actual construction costs were calculated by applying personal domestic expenses. As a result, the standard of the estimated unit showed a good ratio of 107% for heavy pruning of street tree pruning compared to the actual construction cost, but light pruning was underestimated with a 59% ratio. Shrub pruning was 82%, weeding was 92%, tree fertilization was 87%, and windbreak wall installation was 91% under-engineered. In addition, it was also confirmed that the watering by sprinkler trucks and chemical spraying were over-designed compared to the actual construction cost at the rates of 118% and 124%, respectively. Due to the specificity of the street trees, the increase in personal expenses and the input cost of equipment, such as road safety controls, were judged to be the main cause of the underestimation of items. Therefore, it is necessary to add items related to street trees and general landscape trees to the landscape maintenance items of the standard of the estimated unit.

Development of Tree Carbon Calculator to Support Landscape Design for the Carbon Reduction (탄소저감설계 지원을 위한 수목 탄소계산기 개발 및 적용)

  • Ha, Jee-Ah;Park, Jae-Min
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.51 no.1
    • /
    • pp.42-55
    • /
    • 2023
  • A methodology to predict the carbon performance of newly created urban greening plans is required as policies based on quantifying carbon performance are rapidly being introduced in the face of the climate crisis caused by global warming. This study developed a tree carbon calculator that can be used for carbon reduction designs in landscaping and attempted to verify its effectiveness in landscape design. For practical operability, MS Excel was selected as a format, and carbon absorption and storage by tree type and size were extracted from 93 representative species to reflect plant design characteristics. The database, including tree unit prices, was established to reflect cost limitations. A plantation experimental design to verify the performance of the tree carbon calculator was conducted by simulating the design of parks in the central region for four landscape design, and the causal relationship was analyzed by conducting semi-structured interviews before and after. As a result, carbon absorption and carbon storage in the design using the tree carbon calculator were about 17-82% and about 14-85% higher, respectively, compared to not using it. It was confirmed that the reason for the increase in carbon performance efficiency was that additional planting was actively carried out within a given budget, along with the replacement of excellent carbon performance species. Pre-interviews revealed that designers distrusted data and the burdens caused by new programs before using the arboreal carbon calculator but tended to change positively because of its usefulness and ease of use. In order to implement carbon reduction design in the landscaping field, it is necessary to develop it into a carbon calculator for trees and landscaping performance. This study is expected to present a useful direction for ntroducing carbon reduction designs based on quantitative data in landscape design.

The Change in Participation Patterns in Play Activities of Children with Autism Spectrum Disorder during COVID-19: A Scoping Review (COVID-19로 인한 자폐스펙트럼 장애아동의 놀이 활동 참여 변화: 주제범위 문헌고찰)

  • Kim, Hyang-Won;Song, Ye-Ji;Kang, Seong-Hyeon;Won, Ha-Eun;Jeong, Yun-Wha
    • The Journal of Korean Academy of Sensory Integration
    • /
    • v.21 no.1
    • /
    • pp.59-73
    • /
    • 2023
  • Objective : To examine changes in participation patterns of children with Autism Spectrum Disorder (ASD) in play activities during COVID-19 by reviewing relevant literature. Methods : This scoping review was conducted via five steps. we created a research question and searched for relevant literature published in English through CINAHL, PubMed, ERIC, MEDLINE, Google Scholar and Google search engine. After selecting the literature based on inclusion criteria, data were charted based on 10 items (i.e., author name, journal name, publication year, nation, authors' majors, research method, participant' age and gender as well as quantitative and qualitative results of study). The results were analyzed using descriptive numerical and thematic analyses. Results : After reviewing 437 articles and 152 websites, six articles were included. Theses articles were conducted by experts from various fields and countries. Five themes were highlighted in selected articles: COVID-19 resulted in (1) decreased time of outdoor play, (2) increased play time on screen, (3) increased time spent with family, (4) increased sensory difficulties, and (5) recommendations for services for children with disabilities and during COVID-19. Conclusion : This study suggests telerehabilitation programs about parental behavior strategies in order to solve difficulties in which children with ASD may experience when participating in play activities during disasters. Study results can be used as fundamental evidence to emphasize importance of play activities and to systematize role of occupational therapists and service guidelines for supporting play activities of children with disabilities in disasters.

A Study on the Countermeasures Taken By the Korean Healthcare and Life Sciences Industry Regarding U.S. Import Refusals: Focus on the Analysis of FDA Violation Codes (한국 바이오헬스 산업의 미국 수입거부 대응 방안 연구 : FDA 위반코드 분석을 중심으로)

  • Yu-Han Lee;Hag-Min Kim
    • Korea Trade Review
    • /
    • v.48 no.3
    • /
    • pp.131-150
    • /
    • 2023
  • The purpose of this study was to find a countermeasure to the U.S. import refusals for the Korean healthcare and life sciences industry. To this end, an analysis of trends during the pandemic was conducted using the KITA Border Rejection Database, which includes information on items and types of import refusals. The reason for rejection was also analyzed according to the FDA violation codes. The degree of countermeasure for import refusals was identified by measuring the unit rejection rate (URR). The results of the analysis showed that the major U.S. import refusals for the Korean healthcare and life sciences industry had expanded from contact lenses to COVID-19 diagnostic kits and drugs after the pandemic broke out. The major reasons for import refusals were non-compliance with the Predicate Device and Drugs Act and non-approval by the FDA for products and facilities. On the other hand, the unit rejection rate (URR) of major items in the Korean healthcare and life sciences industry was measured higher than the industry average. The results therefore showed a low level of response to U.S. import refusals. The results of the analysis of reasons for import refusals by item according to FDA violation codes were as follows. First of all, the main violation for contact lenses and COVID-19 diagnostic kits corresponded to misbranding. This was often due to the fact that Korean companies did not provide the relevant notices and information required by the FDA. Many cases also failed to demonstrate a substantial equivalency compared to predicate devices already on the market. On the other hand, applications for new unapproved drugs were not accepted as they had yet to pass relevant regulations that would prove their safety and efficacy. In conclusion, import refusals for the Korean healthcare and life sciences industry were found to be closely related to technical barriers to trade (TBT).

Comparison of Fat Content and Fatty Acid Composition in Different Parts of Korean Beef and Pork (한우육 및 돈육의 부위별 지방 함량 및 지방산 조성 비교)

  • Jang, Hye-Lim;Park, Seo-Yeon;Lee, Jong-Hun;Hwang, Myung-Jin;Choi, Youngmin;Kim, Se-Na;Kim, Jin-Hyoung;Hwang, Jinbong;Seo, Dongwon;Nam, Jin-Sik
    • Journal of the Korean Society of Food Science and Nutrition
    • /
    • v.46 no.6
    • /
    • pp.703-712
    • /
    • 2017
  • In this study, the fat contents and fatty acid compositions of Korean beef (tenderloin, loin, strip loin, chuck roll, foreshank, top blade, top round, brisket point, center of heel, and ribs) and pork (tenderloin, loin, shoulder loin, foreshank, jowls, ham, eye of round, belly, skirt meat, and ribs) parts were investigated. The fat contents of Korean beef ranged from 5.25% (top round) to 35.94% (brisket point). The major fatty acids were palmitic acid (C16:0), stearic acid (C18:0), and oleic acid (C18:1, n-9); especially, oleic acid was the most abundant. Loin had similar fat content as ribs, but there were some differences in fatty acid composition. Linolenic acid (C18:3, n-3) and linoleic acid (C18:2, n-6) were the most abundant fatty acids in strip loin and ribs (38.63 mg/100 g and 564.71 mg/100 g, respectively). Arachidonic acid (C20:4, n-6) was only found in strip loin, top blade, and ribs, and its amounts were in the following order: ribs (2.50 mg/100 g)> strip loin (1.33 mg/100 g)> top blade (1.19 mg/100 g). Total trans-fatty acid (TFA) content of top round was the lowest among all parts, and the ratio of unsaturated fatty acid (UFA) was the highest in foreshank. The fat contents of pork ranged from 4.16% (tenderloin) to 18.47% (belly), but there was no significant difference in fat content between tenderloin, loin, foreshank, ham, and eye of round. The major fatty acids were palmitic acid, stearic acid, oleic acid, and linoleic acid, and their amounts were in the following order: oleic> palmitic> linoleic> stearic acid. Docosahexaenoic acid (C22:6, n-3) was only detected in belly, and the TFA content of belly was the highest. The ratio of UFA was highest in ham. These findings will be useful in the development of standardization data on fatty acid composition in different parts of Korean beef and pork.

Analysis of Patient Effective Dose in PET/CT; Using CT Dosimetry Programs (CT 선량 측정 프로그램을 이용한 PET/CT 검사 환자의 예측 유효 선량의 분석)

  • Kim, Jung-Sun;Jung, Woo-Young;Park, Seung-Yong
    • The Korean Journal of Nuclear Medicine Technology
    • /
    • v.14 no.2
    • /
    • pp.77-82
    • /
    • 2010
  • Purpose: As PET/CT come into wide use, it caused increasing of expose in clinical use. Therefore, Korea Food and Drug Administration issued Patient DRL (Diagnostic Reference Level) in CT scan. In this study, to build the basis of patient dose reduction, we analyzed effective dose in transmission scan with CT scan. Materials and Methods: From February, 2010 to March 180 patients (age: $55{\pm}16$, weight: $61.0{\pm}10.4$ kg) who examined $^{18}F$-FDG PET/CT in Asan Medical Center. Biograph Truepoint 40 (SIEMENS, GERMANY), Biograph Sensation 16 (SIEMENS, GERMANY) and Discovery STe8 (GE healthcare, USA) were used in this study. Per each male and female average of 30 patients doses were analyzed by one. Automatic exposure control system for controlling the dose can affect the largest by a patient's body weight less than 50 kg, 50-60 kg less, 60 kg more than the average of the three groups were divided doses. We compared that measured value of CT-expo v1.7 and ImPACT v1.0. The relationship between body weight and the effective dose were analyzed. Results: When using CT-Expo V1.7, effective dose with BIO40, BIO16 and DSTe8 respectably were $6.46{\pm}1.18$ mSv, $9.36{\pm}1.96 $mSv and $9.36{\pm}1.96$ mSv for 30 male patients respectably $6.29{\pm}0.97$ mSv, $10.02{\pm}2.42$ mSv and $9.05{\pm}2.27$ mSv for 30 female patients respectably. When using ImPACT v1.0, effective dose with BIO40, BIO16 and DSTe8 respectably were $6.54{\pm}1.21$ mSv, $8.36{\pm}1.69$ mSv and $9.74{\pm}2.55$Sv for 30 male patients respectably $5.87{\pm}1.09$ mSv, $8.43{\pm}1.89$ mSv and $9.19{\pm}2.29$ mSv for female patients respectably. When divided three groups which were under 50 kg, 50~60 kg and over 60 kg respectably were 6.27 mSv, 7.67 mSv and 9.33 mSv respectably using CT-Expo V1.7, 5.62 mSv, 7.22 mSv and 8.91 mSv respectably using ImPACT v1.0. Weight and the effective dose coefficient analysis showed a very strong positive correlation(r=743, r=0.693). Conclusion: Using such a dose evaluation programs, easier to predict and evaluate the effective dose possible without performing phantom study and such dose evaluation programs could be used to collect basic data for CT dose management.

  • PDF

Sodium and Potassium Content of School Meals for Elementary and Junior High School Students in Daegu, Masan, Gwangju, and Jeju (대구, 마산, 광주, 제주지역 학교급식의 나트륨 및 칼륨 함량 분석)

  • Lim, Hyeon-Sook;Ko, Yang Sook;Shin, Dongsoon;Heo, Young-Ran;Chung, Hae-Jung;Chae, In-Sook;Kim, Hwa Young;Kim, Mi-Hye;Leem, Dong-Gil;Lee, Yeon-Kyung
    • Journal of the Korean Society of Food Science and Nutrition
    • /
    • v.42 no.8
    • /
    • pp.1303-1317
    • /
    • 2013
  • The purpose of this study was to determine the sodium (Na) and potassium (K) content of school meals served in elementary and junior high school in Korea. In this study, 872 kinds of school meal dishes were collected from twelve elementary and twelve junior high schools located in four different cities in Korea (Daegu, Masan, Gwangju, and Jeju). The dishes were classified into three main categories; staple dish, subsidiary dish, and dessert. Each main category was further sub-classified into 4 kinds of staple dishes, 15 kinds of subsidiary dishes, and 5 kinds of dessert dishes. The Na and K content of dishes were then analyzed by atomic absorption spectroscopy. The Na content of individual dishes showed considerable differences, ranging from 9 to 2,717 mg/100 g. Among the staple dishes, cooked rice contained relatively less Na, but other staple dishes such as a la carte, noodle, and rice-gruel contained considerably high amounts of Na. Regarding the subsidiary dishes, the Na content of salad was low, but those of Jangachi, stir-fried dishes, and kimchi were considerably high. Among the dessert dishes, beverages, fruit, and milk/dairy products contained relatively low amount of Na, while rice cakes and baked goods, and snacks contained noticeably high amounts of Na. Unlike the Na content, the K content between the dishes did not show much variability. Cooked rice and rice cakes contained relatively low amounts of K, similar to other dishes, and ranged from 104 to 220 mg/100 g. The Na/K ratio was especially high in rice cakes and Jangachi, while of the ratio in beverages, milk/dairy products, salad, and fruit were pretty low. The total content of Na and K and the Na/K ratio of elementary school meals were 974 mg, 378 mg and 2.7, respectively, and those in junior high school meals was 1,466 mg, 528 mg and 3.0. The results show that most school meals provide a significant amount of Na but significantly small amounts of K, as suggested by the Dietary Reference Intakes for Koreans.

Medical Information Dynamic Access System in Smart Mobile Environments (스마트 모바일 환경에서 의료정보 동적접근 시스템)

  • Jeong, Chang Won;Kim, Woo Hong;Yoon, Kwon Ha;Joo, Su Chong
    • Journal of Internet Computing and Services
    • /
    • v.16 no.1
    • /
    • pp.47-55
    • /
    • 2015
  • Recently, the environment of a hospital information system is a trend to combine various SMART technologies. Accordingly, various smart devices, such as a smart phone, Tablet PC is utilized in the medical information system. Also, these environments consist of various applications executing on heterogeneous sensors, devices, systems and networks. In these hospital information system environment, applying a security service by traditional access control method cause a problems. Most of the existing security system uses the access control list structure. It is only permitted access defined by an access control matrix such as client name, service object method name. The major problem with the static approach cannot quickly adapt to changed situations. Hence, we needs to new security mechanisms which provides more flexible and can be easily adapted to various environments with very different security requirements. In addition, for addressing the changing of service medical treatment of the patient, the researching is needed. In this paper, we suggest a dynamic approach to medical information systems in smart mobile environments. We focus on how to access medical information systems according to dynamic access control methods based on the existence of the hospital's information system environments. The physical environments consist of a mobile x-ray imaging devices, dedicated mobile/general smart devices, PACS, EMR server and authorization server. The software environment was developed based on the .Net Framework for synchronization and monitoring services based on mobile X-ray imaging equipment Windows7 OS. And dedicated a smart device application, we implemented a dynamic access services through JSP and Java SDK is based on the Android OS. PACS and mobile X-ray image devices in hospital, medical information between the dedicated smart devices are based on the DICOM medical image standard information. In addition, EMR information is based on H7. In order to providing dynamic access control service, we classify the context of the patients according to conditions of bio-information such as oxygen saturation, heart rate, BP and body temperature etc. It shows event trace diagrams which divided into two parts like general situation, emergency situation. And, we designed the dynamic approach of the medical care information by authentication method. The authentication Information are contained ID/PWD, the roles, position and working hours, emergency certification codes for emergency patients. General situations of dynamic access control method may have access to medical information by the value of the authentication information. In the case of an emergency, was to have access to medical information by an emergency code, without the authentication information. And, we constructed the medical information integration database scheme that is consist medical information, patient, medical staff and medical image information according to medical information standards.y Finally, we show the usefulness of the dynamic access application service based on the smart devices for execution results of the proposed system according to patient contexts such as general and emergency situation. Especially, the proposed systems are providing effective medical information services with smart devices in emergency situation by dynamic access control methods. As results, we expect the proposed systems to be useful for u-hospital information systems and services.

Development of Intelligent Job Classification System based on Job Posting on Job Sites (구인구직사이트의 구인정보 기반 지능형 직무분류체계의 구축)

  • Lee, Jung Seung
    • Journal of Intelligence and Information Systems
    • /
    • v.25 no.4
    • /
    • pp.123-139
    • /
    • 2019
  • The job classification system of major job sites differs from site to site and is different from the job classification system of the 'SQF(Sectoral Qualifications Framework)' proposed by the SW field. Therefore, a new job classification system is needed for SW companies, SW job seekers, and job sites to understand. The purpose of this study is to establish a standard job classification system that reflects market demand by analyzing SQF based on job offer information of major job sites and the NCS(National Competency Standards). For this purpose, the association analysis between occupations of major job sites is conducted and the association rule between SQF and occupation is conducted to derive the association rule between occupations. Using this association rule, we proposed an intelligent job classification system based on data mapping the job classification system of major job sites and SQF and job classification system. First, major job sites are selected to obtain information on the job classification system of the SW market. Then We identify ways to collect job information from each site and collect data through open API. Focusing on the relationship between the data, filtering only the job information posted on each job site at the same time, other job information is deleted. Next, we will map the job classification system between job sites using the association rules derived from the association analysis. We will complete the mapping between these market segments, discuss with the experts, further map the SQF, and finally propose a new job classification system. As a result, more than 30,000 job listings were collected in XML format using open API in 'WORKNET,' 'JOBKOREA,' and 'saramin', which are the main job sites in Korea. After filtering out about 900 job postings simultaneously posted on multiple job sites, 800 association rules were derived by applying the Apriori algorithm, which is a frequent pattern mining. Based on 800 related rules, the job classification system of WORKNET, JOBKOREA, and saramin and the SQF job classification system were mapped and classified into 1st and 4th stages. In the new job taxonomy, the first primary class, IT consulting, computer system, network, and security related job system, consisted of three secondary classifications, five tertiary classifications, and five fourth classifications. The second primary classification, the database and the job system related to system operation, consisted of three secondary classifications, three tertiary classifications, and four fourth classifications. The third primary category, Web Planning, Web Programming, Web Design, and Game, was composed of four secondary classifications, nine tertiary classifications, and two fourth classifications. The last primary classification, job systems related to ICT management, computer and communication engineering technology, consisted of three secondary classifications and six tertiary classifications. In particular, the new job classification system has a relatively flexible stage of classification, unlike other existing classification systems. WORKNET divides jobs into third categories, JOBKOREA divides jobs into second categories, and the subdivided jobs into keywords. saramin divided the job into the second classification, and the subdivided the job into keyword form. The newly proposed standard job classification system accepts some keyword-based jobs, and treats some product names as jobs. In the classification system, not only are jobs suspended in the second classification, but there are also jobs that are subdivided into the fourth classification. This reflected the idea that not all jobs could be broken down into the same steps. We also proposed a combination of rules and experts' opinions from market data collected and conducted associative analysis. Therefore, the newly proposed job classification system can be regarded as a data-based intelligent job classification system that reflects the market demand, unlike the existing job classification system. This study is meaningful in that it suggests a new job classification system that reflects market demand by attempting mapping between occupations based on data through the association analysis between occupations rather than intuition of some experts. However, this study has a limitation in that it cannot fully reflect the market demand that changes over time because the data collection point is temporary. As market demands change over time, including seasonal factors and major corporate public recruitment timings, continuous data monitoring and repeated experiments are needed to achieve more accurate matching. The results of this study can be used to suggest the direction of improvement of SQF in the SW industry in the future, and it is expected to be transferred to other industries with the experience of success in the SW industry.