Since July 2021, the Korea Radioactive Waste Agency has been conducting a safety case development study for the Korean deep geological repository program. The safety case includes generating scenarios in which radioactive materials from spent nuclear fuel repository reach the human biosphere by combining selective FEPs (Features, Events, and Processes). This safety case should be able to transparently explain the process in which conclusions have been drawn not only to stakeholders but also to the public by presenting safety arguments. The scenario development stage consisting of FEP screening, scenario generation, and uncertainty analysis procedures should have a database management system. Database management system was performed in countries such as Sweden, which obtained approval for the construction of spent nuclear fuel repositories, and the United States, where various preliminary research was carried out. Korea Atomic Energy Research Institute also has experience in designing and operating its own database, which has conducted preliminary research on disposal of the spent nuclear fuel. Currently, the safety assessment of the Korean spent nuclear fuel repository is in the early stages of research, but it is necessary to set up a basic framework for database design while the collection of FEP data from domestic and international preliminary studies is under development, and it is advantageous for efficient database construction and operation. Therefore, this paper presents the current status of database design considering completeness and transparency from the FEP screening stage to the scenario development stage in the safety assessment process of the Korean spent nuclear fuel repository. In this process, the functional requirements that the database should provide, the database schema capable of implementing them, and simple examples are presented together. The objectives of this database design are flexible FEPs management, high integrity and consistency, and expandability for linking with the safety case database. The FEP data to be inputted into the database includes a list of major opened FEPs, including International FEPs from Nuclear Energy Agency, which were referred for PFEPs (Project-specific FEPs), and PFEPs applied to POSIVA's Olkiluoto repository. As an additional function, queries from the database are used to visually express the process of deriving scenarios through Rock Engineering System, a widely known scenario generation methodology.
근대 신문·잡지의 데이터베이스 축적은 연구자의 원서에 대한 손쉬운 접근과 용이한 데이터 추출을 가능하게 해주었고, 더불어 인문학과 문화예술을 포함한 다양한 전공분야의 연구성과로 이어지고 있다. 그러나 이 같은 성과가 연구 쪽으로만 한정되며, 대학교육과는 별도의 학문영역에서만 다루어지고 있는 것은 분명 아쉬운 부분이다.
대학한문교육에서 근대 신문매체를 활용한다면, 실생활의 한자어뿐만 아니라 관련 한자들이 출 현한 사회·문화적 배경을 학습하는 데에도 큰 도움을 준다. 또한 『황성신문』을 비롯한 당시의 근대 신문·잡지들이 통합검색이 가능한 데이터베이스로 제공되고 있어 자료의 접근성면에서도 편리함을 갖추고 있다.
따라서 본고에서는 근대 신문을 활용한 수업모형(TBL)을 소개했으며, 교육방법론과 더불어 활용적 가치 및 효용성 등에 대해 검토하였다. 이 같은 신문매체와 데이터베이스를 활용한 교육설계는 현대학교육의 효용성이나 방법론적 고민을 조금이나마 줄여줄 수 있을 것으로 기대한다. 비록 본 논문은 대학 한문교육을 중심으로 수업모형을 제시했지만, 그 교육적 가치는 인문학 전반을 아우를 수 있다.
Korea is part of a region of low to moderate seismicity located inside the Eurasian plate with bedrock located at depths less than 30 m. However, the spectral acceleration obtained from site response analyses based on the geologic conditions of inland areas of the Korean peninsula are significantly different from the current Korean seismic code. Therefore, suitable site classification scheme and design response spectra based on local site conditions in the Korean peninsula are required to produce reliable estimates of earthquake ground motion. In this study, site-specific response analyses were performed at more than 300 sites with at least 100 sites at each site categories of SC, SD, and SE as defined in the current seismic code in Korea. The process of creating a huge database of input parameters - such as shear wave velocity profiles, normalized shear modulus reduction curves, damping curves, and input earthquake motions - for site response analyses were described. The response spectra and site coefficients obtained from site response analyses were compared with those proposed for the site categories in the current code. Problems with the current seismic design code were subsequently discussed, and the development and verifications of new site classification system and corresponding design response spectra are detailed in companion papers (II-development of new site categories and design response spectra and III-Verifications)
This study investigated the design and establishment of AtoN(Aids to Navigation) in the AtoN Simulator. In recent years, IALA(International Association of Lighthouse Authorities) has raised the need of a system which could verify whether AtoN is appropriate for the design of AtoN and placement planning. An AtoN Simulator provides simulation circumstances, including the topographical and environmental characteristics of a primary harbor and the characteristics of a navigating ship and the maritime traffic. In the present study, we have developed an AtoN simulator system, including the integrated system design and the construction of an AtoN database. The AtoN Manager was developed as a virtual AtoN to manage the AtoN simulation. However, the data and materials are difficult to manage. Hence, an AtoN Manager and an AtoN simulation system have been needed for an effective managing of the AtoN properties database data. For the database structure design, we have analyzed the database design methodology. The AtoN properties have been analyzed for the effective data management. The AtoN properties designed in the present paper were classified into 19 categories. The status and properties database of AtoN were installed in 14 major ports, those were applied to the AtoN Manager. Designing the AtoN properties database was defined to reduce confusion of the use of English terms and abbreviations. The terms and acronyms have been defined in the AtoN properties and designed to the properties database structure for each AtoN. Before structuring the database for the AtoN Manager, the data of the AtoN properties for each harbor have been organized in accordance with the Excel system. The regulated data were converted into the AtoN properties database in use for the AtoN Manager. The database based on the AtoN properties table structure to each AtoN was designed. The AtoN simulator was implemented by the AtoN Manager applied to the AtoN properties database.
Since 2000s, proper utilization of IoT (Internet of Things) technology is a key factor for a firm to become more competitive, and this stream is not exceptional for the food and agriculture industry. Along with this stream, Korea government organization, for example MAFRA (Ministry of Agriculture, Food and Rural Affairs), elected to adopt IoT technology, such as USN and RFID technologies, in the food and agriculture industry. Based on the IoT technology, MAFARA launched six “IoT based farm” project in 2007. IoT based farm project includes IoT based greenhouse system project, and it shows drastic efficiency in terms of cost reduction. When it comes to the productivity, however, the effect of IoT based greenhouse system is still ambiguous. In this regard, this study conducted systems analysis and design for IoT based tomato greenhouse in order to help farmers’ decision making related to the productivity by establishing standardized database structure and designing output form to analyze productivity indices. Proposed systems analysis and design can be utilized as a data analysis tools by farmers. Productivity data from the proposed systems is can be used by researchers to identify the relationship among environment, plant growth and productivity. Policy makers also can refer to the data and output forms to predict the quantity of fruit during certain period and to revise production guideline more precisely.
We have designed data processing server system to include data archiving, photometric processing and light curve analysis for KMTNet (Korea Microlensing Telescope Network). Outputs of each process are reported to the main photometric database, which manages the whole processing steps and archives the photometric results. The database is developed using ORACLE 11g Release 2 engine. It allows to select objects applying any set of criteria such as RA/DEC coordinate and Star ID, etc. We tested the performance of the database using the OGLE photometric data. The searching time for querying 70,000,000 records was under 1 second. The database is fully accessed using query forms via web page.
본 논문에서는 유도무기 통합 설계 프레임워크를 위한 데이터베이스를 설계하였다. 실제 개발에 앞서 유도무기 설계에 필요한 데이터베이스를 위한 요구도를 분석하였으며, 데이터베이스 설계 개념을 정립하였다. 또한 해석도구 간의 데이터흐름 등을 파악하였으며, 이들 정보를 토대로 테이블들을 구성하고 각 객체관계를 정의하여 데이터베이스 스키마를 설계 및 구축하였다. 개발된 DB는 유도무기 통합 설계 프레임워크에 통합되었으며 프레임워크내의 데이터 저장, 검색 및 관리 등의 역할을 수행하며, 유도무기 설계에 적용하여 그 효용성을 검증하였다.
이 논문에서는 철근콘크리트 구조물의 최적설계를 위해 기둥과 보 부재 설계 단면의 데이터베이스를 구성하고 이로부터 단면 번호와 단면 저항 능력간의 관계를 나타내는 회귀분석식을 구성하여, 직접 탐색법으로 빠르게 최적해를 검색하는 효율적인 알고리즘을 제안하였다. 설계 실무에서 가격을 고려하여 설계하기보다는 성능 최적화에 가까운 설계를 수행한다는 사실로부터 제안된 알고리즘을 이용하여 성능 최적화와 가격 최적화를 모두 수행하여 그 결과를 비교 검토하였고, 예제 구조물을 대상으로 적용성과 효율성을 검토하였다. 본 알고리즘은 목적 함수 구성시 제한 조건이 없고 전개 과정이 매우 단순하면서도 빠른 수렴성을 보이며 선택된 해가 설계 규준과 실무상의 제한 조건에 부합하므로 바로 적용 가능하다는 장점이 있다. 전체 구조물의 최적화는 개별 부재의 최적화를 통해 이루어진다.
본 연구에서는 도로교의 지진피해평가체계를 구축하기 위해 필요한 정보항목들을 정의하고 우리나라 실정에 맞는 데이터 베이스 구축방법을 제시하였다. 도로교 지진피해평가를 위한 정보요소는 크게 구조물 관련 정보와 위치관련 정보로 구분하였다. 구조물 관련정보는 도로망에 위치한 교량의 지진피해를 예측하는데 필요한 도로교의 취약도 곡선 정보항목으로 구성하였다. 위치관련 정보항목인 도로망의 데이터구조는 상세한 교차로 모델링이 가능하도록 기존의 GIS 데이터구조를 보다 세분화하여 정의하였다. 고속도로망에 위치한 110개의 교량을 대상으로 시범 시스템을 개발하였으며, 제시된 데이터베이스 구축 방법은 도로망의 신속한 피해복구를 위한 의사결정 지원체계 구축에 효과적으로 활용이 가능함을 보였다.
Computerized visual database construction of architectural precedents has just begun in some research institutes in the world. In Korea the first visual database has shown its testl version by S architectural design firm in september 1996. In this article the author discusses the historical contexts and the recent computerization cases, the traits, the uses and the limits of architectural visual database system of precedents. The forms and contents of data fields in two cases are compared with a focus on the description of architectural traits of each data entry. Compared to the KIA format, the S database has better performance for architectural design reference because it collects more pictures and drawings and larger texts for the field of architectural chracteristics. But this latter also is constrained by its capacity of memory and so lacks the reciprocity of the DOORS in the Graduate School of Design, Harvard University. A visual database system which has more flexible allocation of memory and respondent with the users is yet to be prepared. But this system also should be maintained by some experts in architectural history, theory and criticism, because their knowledge is essential for selection of precedents and revision of the data description. A full-fledged electronic visual database in architecture will not only save much effort for the architect, but also will change the architects' design behavior. Nevertheless this does not mean the automatic promotion of architects' creativity.
Meanwhile, reference evapotranspiration(ET0) is important information for agricultural management including irrigation planning and drought assessment, the database of reference evapotranspiration for future periods was rarely constructed especially at districts unit over the country. The Coupled Model Intercomparison Project Phase 5 (CMIP5) provides several meteorological data such as precipitation, average temperature, humidity, wind speed, and radiation for long-term future period at daily time-scale. This study aimed to build a database for reference evapotranspiration using the climate forecasts at high resolution (the outputs of HadGEM3-RA provided by Korea Meteorological Administration (KMA)). To estimate reference evapotranspiration, we implemented four different models such as FAO Modified Penman, FAO Penman-Monteith, FAO Blaney-Criddle, and Thornthwaite. The suggested database system has an open architecture so that user could add other models into the database. The database contains 5,050 regions’ data for each four models and four Representative Concentration Pathways (RCP) climate change scenarios. The developed database system provides selecting features by which the database users could extract specific region and period data.
해상 교통량이 증가함에 따라 높아지는 선박 사고위험을 줄이기 위해 안전 운항을 위한 시스템은 필수적이다. 국제해사기구의 SOLAS에서는 선박에 AIS(Automatic Identification System)의 탑재를 의무화 하였다. AIS는 육상과 타 선박에 신원, 종류, 위치, 항해 상태를 포함한 각종 항해정보와 선박상태를 자동으로 알리는 시스템이다. 안전운항을 위한 응용서비스 개발의 대부분의 경우에 AIS는 활용될 수 있으므로, 체계적인 정보의 관리가 필요하다. 본 논문에서는 수신된 메시지 정보를 관리하기 위해 데이터베이스를 도입하였다. AIS메시지를 정적정보와 동적정보로 나누어 저장하고, 전자해도 기반 AIS 정보를 디스플레이하는 시스템 구현을 통해 설계의 결과를 확인했다.
As information has been brought to public attention, information storage as well as information usability has been important. Rural information is produced in many areas and institutions. However, it is difficult to use rural information comprehensively. Since formats for management are various, it is difficult to have unified frame. In this research, a schema of database fer integrating rural data is designed to improve usability using dimensional modeling. First of all, rural data are analyzed for designing integrated rural database schema. Rural data used are 'National Agricultural Statistics' and 'Gun annual statistical report'. Analysis shows that there are three considerations; administrative district, time-dependency and classification of data. Considering these three requisite, we designed database schema using dimensional modeling. The reason of using dimensional modeling is to improve usability and effectiveness. If the database was designed using ER modeling, many tables have to be joined every searching time. Separately from integrated rural database schema, user's database schema is designed considering usability. Through user's database, users can modify data or generate new data and save these processes. These make it possible to use generated data repeatedly. We evaluate usability, contribution, and effectiveness of data manipulation on the integrated rural database. We propose an integrated rural database structure improving the accessibility and usability of rural data and information and verified the data model based on a practical example.