• Title/Summary/Keyword: DB설계

Search Result 971, Processing Time 0.028 seconds

Spatial OLAP Implementation for GIS Decision-Making - With emphasis on Urban Planning - (GIS 의사결정을 지원하기 위한 Spatial OLAP 구현 - 도시계획을 중심으로 -)

  • Kyung, Min-Ju;Yom, Jae-Hong
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.27 no.6
    • /
    • pp.689-698
    • /
    • 2009
  • SOLAP system integrates and complements the functions of both OLAP and GIS systems. This enables users not only to easily access geospatial data but also to analyze and extract information for decision making. In this study a SOLAP system was designed and implemented to provide urban planners with GIS information when making urban planning decisions. Rapid urbanization in Korea has brought about ill-balanced urban structure as the result of development without detailed analysis of urban plans. Systematic urban planning procedures and automated systems are crucial for detail analysis of future development plans. Data regarding the development regulations and current status of land use need to be assessed precisely and instantly. Multi-dimensional aspects of a suggested plan must be formulated instantly and examined thoroughly using 'what if' scenarios to come up with a best possible plan. The SOLAP system presented in this study designed the dimension tables and the fact tables for supplying timely geospatial information to the planners when making decisions regarding urban planning. The database was implemented using open source DBMS and was populated with necessary attribute data which was freely available from the Statistics Korea bureau homepage. It is anticipated the SOLAP system presented in this study will contribute to better urban planning decisions in Korea through more timely and accurate provision of geospatial information.

Research on DB Construction and Utilization Measure to Analyze the Cause of Weapon System Software Engineering Change and Derive Improvement Plan (무기체계 소프트웨어 기술변경 원인분석과 개선방안 도출을 위한 데이터베이스 구축 및 활용 방안연구)

  • Oh, Jin-Woo;Kim, Jong-Kyu;Yu, Ji-seon;Yun, Jae-Hyeong;Song, Chi-Hoon
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.22 no.4
    • /
    • pp.331-337
    • /
    • 2021
  • Owing to the limited development period and budget of the weapon system, many problems have arisen in the operation stage after mass production. Therefore, engineering changes are also increasing. On the other hand, an analysis of the cause of problems and improvement of the system equipment performed in engineering changes cannot be managed synthetically. Hence, important actual data can only be used once. In particular, unlike hardware where the shape of the equipment is changed or the part number is changed, the contents of software engineering changes are only partially included in the proposal. Moreover, only the extent to which the version of the source package and the executable file has been changed can be identified. Therefore, this paper proposes a method to build and utilize a database for cause analysis and improvement plan data of weapon-system software engineering changes and software technical support. The above utilization measure can contribute to the quality assurance of weapon-system software developed in the future by preemptively applying real-world data when developing similar weapon systems.

The Effect of a Physical Touch Play Program in Children: A Systematic Review and Meta-analysis (아동의 신체접촉놀이 프로그램에 대한 효과 : 체계적 문헌고찰 및 메타분석)

  • Yoon, Jeong Ah
    • Journal of Life Science
    • /
    • v.32 no.10
    • /
    • pp.821-831
    • /
    • 2022
  • This study evaluated the effects of physical touch play programs in children through a systematic literature review and meta-analysis. A literature search for journal articles published before August 2022 was conducted using KERIS, KISS, DBpia, and ScienceON. The keywords used for the search were 'child', 'infant', 'physical touch', 'physical touch play', 'physical touch activities' and 'physical touch play program'. For the study's purpose, seven studies were selected through a systematic process of using several databases and were used to estimate the effect size of physical touch play programs. A meta-analysis was performed using a random effects model, and the effect size on cognitive function was calculated. Hedges' g of the physical touch play program was 6.20 (95% CI: 3.74-8.66), indicating a large effect size. To determine heterogeneity (I2= 95.4%, Q = 417.30, p<0.001), moderator analysis was performed using the total number of times and intervention duration. The total number of times was statistically significant; the other moderators did not differ significantly. This study systematically analyzed the results of physical touch play programs on children in Korea. It also provides insights that can be applied to the design of physical touch play programs for children. To present more evidence that supports the effectiveness of physical touch programs, further research is warranted.

A Design and Implementation of Chick Incubation System Based on IoT

  • Sejong Lee;Sol Lee
    • Journal of the Korea Society of Computer and Information
    • /
    • v.29 no.9
    • /
    • pp.179-186
    • /
    • 2024
  • In this paper, we design and implement an Internet of Things (IoT)-based chick incubation system. The system consists of three key components: the IoT incubator, the IoT server system, and the smartphone application. The IoT incubator is composed of an Arduino board, temperature and humidity sensors, a temperature and humidity controller, a ventilation controller, and an egg turning controller. The temperature and humidity sensors measure the temperature and humidity inside the IoT incubator and send the data to the temperature and humidity controller on the Arduino board. Additionally, it provides the function of transmitting temperature, humidity, and control history data to the IoT server via WiFi. It also offers automatic control of ventilation, egg turning, and temperature and humidity on a daily basis. The IoT server system receives data from the incubator, stores it in a database, and provides query data upon request from the smartphone. The smartphone application retrieves historical data through the server and monitors the temperature and humidity data of the IoT incubator in real-time, controlling the IoT incubator to ensure that the set temperature and humidity ranges are maintained. If the temperature and humidity data deviate from the set ranges, it sends alarms and emergency messages to the user. The IoT-based chick incubation system developed in this paper is a low-cost model due to its reduced manufacturing cost, making it highly beneficial for self-sustaining poultry farms.

A Study on Public Interest-based Technology Valuation Models in Water Resources Field (수자원 분야 공익형 기술가치평가 시스템에 대한 연구)

  • Ryu, Seung-Mi;Sung, Tae-Eung
    • Journal of Intelligence and Information Systems
    • /
    • v.24 no.3
    • /
    • pp.177-198
    • /
    • 2018
  • Recently, as economic property it has become necessary to acquire and utilize the framework for water resource measurement and performance management as the property of water resources changes to hold "public property". To date, the evaluation of water technology has been carried out by feasibility study analysis or technology assessment based on net present value (NPV) or benefit-to-cost (B/C) effect, however it is not yet systemized in terms of valuation models to objectively assess an economic value of technology-based business to receive diffusion and feedback of research outcomes. Therefore, K-water (known as a government-supported public company in Korea) company feels the necessity to establish a technology valuation framework suitable for technical characteristics of water resources fields in charge and verify an exemplified case applied to the technology. The K-water evaluation technology applied to this study, as a public interest goods, can be used as a tool to measure the value and achievement contributed to society and to manage them. Therefore, by calculating the value in which the subject technology contributed to the entire society as a public resource, we make use of it as a basis information for the advertising medium of performance on the influence effect of the benefits or the necessity of cost input, and then secure the legitimacy for large-scale R&D cost input in terms of the characteristics of public technology. Hence, K-water company, one of the public corporation in Korea which deals with public goods of 'water resources', will be able to establish a commercialization strategy for business operation and prepare for a basis for the performance calculation of input R&D cost. In this study, K-water has developed a web-based technology valuation model for public interest type water resources based on the technology evaluation system that is suitable for the characteristics of a technology in water resources fields. In particular, by utilizing the evaluation methodology of the Institute of Advanced Industrial Science and Technology (AIST) in Japan to match the expense items to the expense accounts based on the related benefit items, we proposed the so-called 'K-water's proprietary model' which involves the 'cost-benefit' approach and the FCF (Free Cash Flow), and ultimately led to build a pipeline on the K-water research performance management system and then verify the practical case of a technology related to "desalination". We analyze the embedded design logic and evaluation process of web-based valuation system that reflects characteristics of water resources technology, reference information and database(D/B)-associated logic for each model to calculate public interest-based and profit-based technology values in technology integrated management system. We review the hybrid evaluation module that reflects the quantitative index of the qualitative evaluation indices reflecting the unique characteristics of water resources and the visualized user-interface (UI) of the actual web-based evaluation, which both are appended for calculating the business value based on financial data to the existing web-based technology valuation systems in other fields. K-water's technology valuation model is evaluated by distinguishing between public-interest type and profitable-type water technology. First, evaluation modules in profit-type technology valuation model are designed based on 'profitability of technology'. For example, the technology inventory K-water holds has a number of profit-oriented technologies such as water treatment membranes. On the other hand, the public interest-type technology valuation is designed to evaluate the public-interest oriented technology such as the dam, which reflects the characteristics of public benefits and costs. In order to examine the appropriateness of the cost-benefit based public utility valuation model (i.e. K-water specific technology valuation model) presented in this study, we applied to practical cases from calculation of benefit-to-cost analysis on water resource technology with 20 years of lifetime. In future we will additionally conduct verifying the K-water public utility-based valuation model by each business model which reflects various business environmental characteristics.

Development of GIS based Water Quality Simulation System for Han River and Kyeonggi Bay Area (한강과 경기만 지역 GIS 기반 통합수질모의 시스템 개발)

  • Lee, Chol-Young;Kim, Kye-Hyun
    • Journal of Korea Spatial Information System Society
    • /
    • v.10 no.4
    • /
    • pp.77-88
    • /
    • 2008
  • There has been growing demands to manage the water quality of west coastal region due to the large scale urbanization along the coastal zone, the possibility of application of TMDL(Total Maximum Daily Loadings) to Han river, and the natural disaster such as oil spill incident in Taean, Chungnam. However, no system has been developed for such purposes. In this background, the demand of GIS based effective water quality management has been increased to monitor water quality environment and propose best management alternatives for Han river and Kyeonggi bay. This study mainly focused on the development of integrated water quality management system for Han river bas in and its estuary are a connected to Kyeonggi bay to support integrated water quality management and its plan. Integration was made based on GIS by spatial linking between water quality attributes and location information. A GIS DB was built to estimate the amount of generated and discharged water pollutants according to TMDL technical guide and it included input data to use two different water quality models--W ASP7 for Han river and EFDC for coastal area--to forecast water quality and to suggest BMP(Best management Practices). The results of BOD, TN, and TP from WASP7 were used as the input to run EFDC. Based on the study results, some critical areas which have relatively higher pollutant loadings were identified, and it was also identified that the locations discharging water pollutant loadings to river and seasonal factor affected water quality. And the relationship of water quality between river and its estuary area was quantitatively verified. The results showed that GIS based integrated system could be used as a tool for estimating status-quo of water quality and proposing economically effective BMPs to mitigate water pollution. Further studies need to be made for improving system's capabilities such as adding decision making function as well as cost-benefit analysis, etc. Also, the concrete methodology for water quality management using the system need to be developed.

  • PDF

Effects for kangaroo care: systematic review & meta analysis (캥거루 케어가 미숙아와 어머니에게 미치는 효과 : 체계적 문헌고찰 및 메타분석)

  • Lim, Junghee;Kim, Gaeun;Shin, Yeonghee
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.17 no.3
    • /
    • pp.599-610
    • /
    • 2016
  • This paper reports the results of a systematic review (SR) and meta-analysis research to compare the effect of Kangaroo care, targeting mothers and premature infants. A randomized clinical trial study was performed until February 2015. The domestic literature contained the non-randomized clinical trial research without restriction according to the level of the study design. A search of the Ovid-Medline, CINAHL, PubMed and KoreaMed, the National Library of KOREA, the National Assembly Library, NDSL, KISS and RISS. Through the KMbase we searched and combined the main term ((kangaroo OR KC OR skin-to-skin) AND (care OR contact)) AND (infant OR preterm OR Low Birth Weight OR LBW), ((kangaroo OR kangaroo OR kangaroo) AND (care OR nursing care OR management OR skin contact)) was made; these were all combined with a keywords search through the selection process. They were excluded in the final 25 studies (n=3051). A methodology checklist for randomized controlled trials (RCTs) designed by SIGN (Scottish Intercollegiate Guidelines Network) was utilized to assess the risk of bias. The overall risk of bias was regarded as low. In 16 studies that were evaluated as a grade of "++", 9 studies were evaluated as a grade of "+". As a result of meta-analysis, kangaroo care regarding the effects of premature mortality, severe infection/sepsis had an insignificant effect. Hyperthermia incidence, growth and development (height and weight), mother-infant attachment, hypothermia incidence, length of hospital days, breast feeding rate, sleeping, anxiety, confidence, and gratification of mothering role were considered significant. In satisfaction of the role performance, depression and stress presented contradictory research results for individual studies showing overall significant difference. This study has some limitations due to the few RCTs comparing kangaroo care in the country. Therefore, further RCTs comparing kangaroo care should be conducted.

Study on Reduction Effect of the Non-Point Pollutants through Riparian Buffer Zones (비점오염부하 저감을 위한 수변완충지대의 효율적 조성 연구)

  • Choi, I-Song;Kim, Sung-Won;Jung, Sang-Jun;Woo, Hyo-Seop;Oh, Jong-Min
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2007.05a
    • /
    • pp.1793-1797
    • /
    • 2007
  • 한강 "수변구역"에서 비점오염물질의 공공수역 유입을 억제하기 위한 다양한 방법들 중에서 보편적이고 자연친화적인 방법은 다양한 생물의 서식공간이며, 동시에 본류로 유입되는 과정에서 수질을 정화시키는 수질개선 공간인 수변완충구역, 또는 지대를 설정하여 관리하는 것이다. 그러나 이러한 수변완충지대 효과 분석 및 설정에 관한 연구는 국내에서 아직 수행되지 않았다. 본 연구의 목적은 수변구역의 자정능력을 높이는 것은 물론 그 밖의 하천 연안에서 비점오염물질의 차단과 처리능력을 증진시키고 수변 생태계의 서식처 보전 및 복원을 위해서 수변완충지대의 수질정화 기술개발과 생물다양성을 창출하는 수변완충지대 조성 기법을 개발하는데 있다. 본 연구에서는 기존 수변완충지의 추가적인 조성과 보완, 시험완충지 생태구조 및 기능 기초조사, 시험완충지 오염부하 저감효과의 실험 및 분석, 수변완충지대 설치 구상 등의 연구를 수행하였다. 수행 지역은 한강수계 지역으로 남한강 수변인 경기도 양평군 병산리에서 실시하였으며, 잔디와 갈대, 갯버들, 혼합지역, 자연그대로의 상태(대조지역)의 5 구역으로 구분하였고, 깊이별로 샘플을 채취하여 유입수와 표면유출, 하부유출을 비교해 보았다. 연구 결과, 5 가지 구역 중 잔디 구역의 SS, T-N, T-P, TOC의 제거 효율이 각각 76.7%, 85.2%, 97.6%, 83.3%로 가장 좋은 오염물질 제거 효율을 보였으며, 깊이 별 분석에서는 표면유출에서 하부유출로 갈수록 월등한 효율을 보였다. 따라서 본 연구를 통하여 비점오염원에 대한 한강수계의 수자원 보호 효과를 기대할 수 있고, 수변완충지대의 조성, 유지관리기술의 개발을 통한 수변완충지대의 계획과 설계에 직접적인 기여를 할 수 있으며, 수변구역에 설치 가능한 Riparian Buffer Zone의 중요성과 효율성을 알려 현재 하상 저니 준설 및 폭기 위주의 사업에서 생태 공학적 복원을 적극 고려한 정화사업으로 확대 추진하고자 한다.해결책을 얻어내는 상호보완적인 결과를 추구한다. 그가 디자인하는 작품은 전형적인 이미지를 내포하지 않는다. 즉 그의 작품은 기존의 가치와 이념적인 것은 배제하고, 창의적인 개념을 도출하였다.형모서리는 건물 특화 성격이 강하므로 불가피할 경우 소형 액센트 광고 위치를 미리 벽면으로 할애하는 것이 경관 및 입면계획에 유리한 것으로 분석되었다. 불확실도 해석모형 등의 새로운 기능을 추가하여 제시하였다. 모든 입출력자료는 프로젝트 단위별로 운영되어 data의 관리가 손쉽도록 하였으며 결과를 DB에 저장하여 다른 모형에서도 적용할 수 있도록 하였다. 그리고 HyGIS-HMS 및 HyGIS-RAS 모형에서 강우-유출-하도 수리해석-범람해석 등이 일괄되게 하나의 시스템 내에서 구현될 수 있도록 하였다. 따라서 HyGIS와 통합된 수리, 수문모형은 국내 하천 및 유역에 적합한 시스템으로서 향후 HydroInformatics 구현을 염두에 둔 특화된 국내 수자원 분야 소프트웨어의 개발에 기본 토대를 제공할 것으로 판단된다.았다. 또한 저자들의 임상병리학적 연구결과가 다른 문헌에서 보고된 소아 신증후군의 연구결과와 큰 차이를 보이지 않음을 알 수 있었다. 자극에 차이가 있지 않나 추측되며 이에 관한 추후 연구가 요망된다. 총대장통과시간의 단축은 결장 분절 모두에서 줄어들어 나타났으나 좌측결장 통과시간의 감소 및 이로 인한 이 부위의 통과시간 비율의 저하가 가장 주요하였다. 이러한 결과는 차가운 생수 섭취가 주로 결장 근위부를 자극하는 효과를 발휘하는 것이 아닌가 해석된다. 이와 같은 연구결과를 통해 생다시마를 주원료로 개발된 생다시마차와 생다시마 음료가 만성 기능성 변비 증세를 개선하는 효능이 잠재적으로 있음을 확인하였다. 그러나 생약제재의 변비약 수준으로 변비 개선 효능을 증대하기 위해서는 재료 배합비의 개선이나 대장 운동기능을 향상시키는 유효성분의 보강 등이 필요하다는 점도 알 수 있었다.더불어 산화물질 해독에 관여하는

  • PDF

The Contents of Namsan Park Records at the Seoul Metropolitan Archives (서울기록원 소장 남산공원 기록물의 현황과 내용)

  • Kim, Jung-Hwa;Gil, Jihye;Seo, Young-Ai;Park, Hee-Soung;Choi, Hyeyoung;Lee, Myeong-Jun
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.50 no.6
    • /
    • pp.110-123
    • /
    • 2022
  • Namsan Park in Seoul was designated as a "grand park" in 1954 and is currently operated as an 'Urban Nature Park Area' and four 'neighborhood parks.' However, despite the park's historical and cultural value as an urban park, it has been discussed mainly from a perspective revolving around notions of a mountain or a city wall. To ensure a comprehensive exploration of Namsan Park's history, this study examined public records at the Seoul Metropolitan Archives (SMA), which houses the city's permanent records for preservation and organization. To this end, documents in the SMA Database (DB) were analyzed, yielding 1,359 records concerning Namsan Park. Based on the contents, general characteristics of the urban park were identified through production periods, record types, and disclosure types. Then, essential keywords concerning organizations, people, geographical areas, subjects, and business functions were examined. Finally, the contents and characteristics of Namsan Park in public records were scrutinized, focusing on specific spaces. This research also uncovered important information, such as park drawings, photos, planting lists, plant parcel lists, and significant discussions and decisions regarding the operation and management of the park. Although the public records do not contain a comprehensive history of Namsan Park, it was possible to check the primary historical changes and deliberation processes pertaining to the park's history. Therefore, continuous research intended to interpret and describe public records is expected to identify many implications. In addition, because the public records showed heterogeneous characteristics that center on specific periods and events, an essential task is to advance collaboration and networking with various related institutions, designers, researchers, and citizens.

Developments of Local Festival Mobile Application and Data Analysis System Applying Beacon (비콘을 활용한 위치기반 지역축제 모바일 애플리케이션과 데이터 분석 시스템 개발)

  • Kim, Song I;Kim, Won Pyo;Jeong, Chul
    • Korea Science and Art Forum
    • /
    • v.31
    • /
    • pp.21-32
    • /
    • 2017
  • Local festivals form the regional cultures and atmosphere of communication; they increase the demand of domestic tourism businesses and thus, have an important role in ripple effects (e.g. regional image improvement, tourist influx, job creation, regional contents development, and local product sales) and economic revitalization. IoT (Internet of Thing) technologies have been developed especially, beacon-one of the IoT services has been applied as plenty of types and forms both domestically and internationally. However, notwithstanding expansion of current digital mobile technologies, it still remains as difficult for the individual to track the information about all the local festivals and to fulfill the tourists' needs of enjoying festivals given the weak strategic approaches and advertisement activities. Furthermore, current festival-related mobile applications don't function well as delivering information and have numerous contents issues (e.g. ways of information delivery within the festival places, independent application usage for each festival, one time usage due to one time event). This research, based on the background mentioned above, aims to develop the local festival mobile application and data analysis system applying beacon technology. First of all, three algorithms were developed, namely, 'festival crowding algorithm', 'visitor stats algorithm', and 'customized information algorithm', and then beta test was followed with the developed application and data analysis system. As a result, they could form the database of visitors' types and behaviors, and provide functions and services, such as personalized information, waiting time for festival contents, and 'hot place' function. Besides, in Google Play store, they also got the titles given with more than 13,000 downloads within first three months and as the most exposed application related with festivals; and, thus, got credited with their marketability and excellence. This research follows this order: chapter 2 shows the literature review of local festival related with technology development, beacon service, and festival application. In Chapter 3, design plans and conditions are described of developing local festival mobile application and data analysis system with beacon. Chapter 4 evaluates the results of the beta performance test to verify applicability of the developed application and data analysis system, and lastly, chapter 5 explains the conclusion and suggests the future research.