• Journal of the Korean Dietetic Association
• /
• v.15 no.3
• /
• pp.286-297
• /
• 2009

Studies based on food analysis or food databases use the national standard food database. Although Internet information services are increasing gradually, users are only able to get definitive and profitable information using standard food terms. Until now, it has been uncommon to find food retrieval services that include users' regional or historical characteristics. Thus, this study introduces a prototype for Food and Dish Synonym Retrieval (NutriSyn) that includes synonyms and related words. The environments which NutriSyn was implemented were Linux for the server operating system, the Microsoft Windows series for the users' operating system and Apache for a web server. The development languages used are PHP, JavaScript and HTLM with a MySQL database. Users can access NutriSyn using Internet browsers. The main menu items are (1) Food Synonym DB, (2) Dish Synonym DB, (3) Food Information DB, (4) Dish Information DB, and (5) Food and Menu Synonym Retrieval. This system is expected to be a useful tool for food experts and interdisciplinary research.

• Journal of the Korean Home Economics Association
• /
• v.45 no.1
• /
• pp.111-125
• /
• 2007

By examining the existing Galot products in the market, we aimed to discover areas for new development and lay out the foundational system for establishing a database(DB) of their pattern grading. For the analysis, the team focused mainly on Galot in forms of casual korean traditional clothes, since they have the largest market share. The main accomplishments from this research are as follows. First, because adult females are the largest segment to consider in deciding the size system for grading, we selected three sizes that have to be compatible with the KS Clothing Standardized Sizing. Second, for basic pattern grading, we applied the reference size indicated in KS Clothing Standardized Size, and also used half dart sloper and dartless sloper. Third, we categorized designs according to the presence or absence of a dart, the structure of closure, and the shape of the sleeve and neck. We indicated the grading points with numbers and body area in Korean to make it easier for the users to understand when using the computer system and doing manual work. To further increase the user convenience, we provided diagrams for categorized designs, pattern grading layout, and a table for calculated grading points variation.

• Journal of the Korean Society for Railway
• /
• v.7 no.1
• /
• pp.20-25
• /
• 2004

Railroad geotechnical information management system was developed by using Web GIS and DB in this study. The standardization of railroad geotechnical information is progressed by classifying three groups as like basic informations, vibration informations along railway lines and design drawings. The basic informations consisted of basic and dynamic properties of soils, geophysical exploration and seismic survey/exploration. And the specification for 'human exposure to whole-body vibration' was adopted to construct the vibration informations along railway lines. The informations as like drawings and photographs were saved by changing to graphic files in the standardization of design drawings. In the case of standardization of geographical information, the topographical maps(NGIS, 1:5000) were primarily used as digital maps. Another digital maps(KRRI, 1:5000) and their geographical DB based on NGI code system were added on this maps. The standardized informations were used to construct their database. And railroad information management system was developed using Entity-Relation(ER) model which had a good feasibility for expansion and transition to other system in designing stage of database. This system consisted of layer selection, search and analysis of geotechnical informations and Zeus DB was adopted for GIS operating and user interface. This system could be a good tool for saving, searching and analyzing the geotechnical and geophysical informations. These DB systems would offered the basic informations to plans, design and construction of railroad lines etc. in practical use.

• Journal of Cadastre & Land InformatiX
• /
• v.50 no.2
• /
• pp.81-100
• /
• 2020

The purpose of this study was to propose applicability of spatial data and quality check criteria for estimating damage from storm and flood. Using the data from the National Disaster Management System and National Spatial Data Infrastructure, spatial database for estimation of storm and flood damage has been mapped to each type of damage. This was proposed as the quality check criteria for damage analysis. Through this study, it is possible to utilize the spatial database for estimating storm and flood damage. The reliability of analysis results are ensured through the quality check criteria.

• Economic and Environmental Geology
• /
• v.48 no.6
• /
• pp.509-523
• /
• 2015

This study introduces newly implemented geological well logs database for Jeju public water wells, built for a research project focusing on integrated hydrogeology database of Jeju Island. A detailed analysis of the existing 1,200 Jeju Island geological logs for the public wells developed since 1970 revealed six major indications to be improved for their use in Jeju geological logs DB construction: (1) lack of uniformity in rock name classification, (2) poor definitions of pyroclastic deposits and sand and gravel layers, (3) lack of well borehole aquifer information, (4) lack of information on well screen installation in many water wells, (5) differences by person in geological logging descriptions. A new Jeju geological logs DB enabling standardized input and output formats has been implemented to overcome the above indications by reestablishing the names of Jeju volcanic and sedimentary rocks and utilizing a commercial, database-based input structured, geological log program. The newly designed database structure in geological log program enables users to store a large number of geology, well drilling, and test data at the standardized DB input structure. Also, well borehole groundwater and aquifer test data can be easily added without modifying the existing database structure. Thus, the newly implemented geological logs DB could be a standardized DB for a large number of Jeju existing public wells and new wells to be developed in the future at Jeju Island. Also, the new geological logs DB will be a basis for ongoing project 'Developing GIS-based integrated interpretation system for Jeju Island hydrogeology'.

• Journal of Korean Society for Geospatial Information Science
• /
• v.16 no.3
• /
• pp.79-85
• /
• 2008

This study aims to derive a practical coordinate transformation method for the existing geographic information database. After analyzing the status and problems of existing 1/1,000 digital base map and GIS application database, the transformation parameters are estimated and the accuracy of the transformation is determined based on the transformed coordinates. We analyzed the accuracy of a transformation using the published national transformation coefficients as well as the estimated local transformation coefficients using national and urban control points in a study area. In addition, the 1/1,000 digital base map from aerial triangulation is compared with respect to the coordinates of urban control points. Based on the comparison, the biases on the national control points which were used at the time of digital map generation was analyzed. Then, the accuracy of transformed coordinates based on the world geodetic system using local transformation coefficients estimated from urban control points are determined. We also analyzed the transformation accuracy of underground infrastructure database using the same transformation method as the case of 1/1,000 digital base map. Through this study, it was found that the estimation of transformation coefficients by Molodensky-Badekas using urban control points was suitable for a local government. Furthermore, it was obvious that the accuracy of a 2-dimensional affine transformation was comparable to that of 7 parameter transformation for a local area. Applying the coordinate transformation and bias correction, we could transform GIS application database which was built by an offset surveying based on digital base map within the transformation accuracy of 10 cm. Therefore, it was judged that there will not be a big problem on the transformation of the GIS DB to the world geodetic system.

• Journal of the Korea Society for Simulation
• /
• v.25 no.1
• /
• pp.29-34
• /
• 2016

Many researchers have used cohort DB (database) to predict the occurrence of disease or to keep track of disease spread. Cohort DB is Big Data which has simply stored disease and health information as separated DB table sets. To measure the relations between health information, It is necessary to reconstruct cohort DB which follows research purpose. In this paper, XML descriptor, editor has been used to construct ontology-based Big Data cohort DB. Also, we have developed ontology based cohort DB search system to check results of relations between health information. XML editor has used 7 layered Ontology development 101 and OWL API to change cohort DB into ontology-based. Ontology-based cohort DB system can measure the relation of disease and health information and can be used effectively when semantic relations are found. We have developed ontology-based cohort DB search system which can measure the relations between disease and health information. And it is very effective when searched results are semantic relations.

• The Journal of the Korea Contents Association
• /
• v.10 no.6
• /
• pp.49-54
• /
• 2010

As information on gene sequences is not only diverse but also extremely huge in volume, high-performance computer and information technology techniques are required to build and analyze gene sequence databases. This has given rise to the discipline of bioinformatics, a field of research where computers are utilized to collect, to manage, to save, to evaluate, and to analyze biological data. In line with such continued development in bioinformatics, the Korea Institute of Science and Technology Information (KISTI) has built an infrastructure for the biological information, based on the information technology, and provided the information for researchers of bioscience. This paper analyzes the reference fields of Genbank, the most frequently used gene database by the global researchers among the life information databases, and proposes the interface method to NDSL which is the science and technology information integrated service provided by KISTI. For these, after collecting Genbank data from NCBI FTP site, we rebuilt the database by separating Genbank text files into the basic gene data and the reference data. So new tables are generated through extracting the paper and patent information from Genbank reference fields. Then we suggest the method of connection with the paper DB and the patent DB operated by KISTI.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.19 no.2
• /
• pp.47-62
• /
• 2016

An integrated database(DB) system was developed to manage the marine geological data and geophysical data acquired from around the Korean peninsula from 2009 to 2013. Geological data such as size analysis data, columnar section images, X-ray images, heavy metal data, and organic carbon data of sediment samples, were collected in the form of text files, excel files, PDF files and image files. Geophysical data such as seismic data, magnetic data, and gravity data were gathered in the form of SEG-Y binary files, image files and text files. We collected scientific data from research projects funded by the Ministry of Oceans and Fisheries, data produced by domestic marine organizations, and public data provided by foreign organizations. All the collected data were validated manually and stored in the archive DB according to data processing procedures. A geographic information system was developed to manage the spatial information and provide data effectively using the map interface. Geographic information system(GIS) software was used to import the position data from text files, manipulate spatial data, and produce shape files. A GIS DB was set up using the Oracle database system and ArcGIS spatial data engine. A client/server GIS application was developed to support data search, data provision, and visualization of scientific data. It provided complex search functions and on-the-fly visualization using ChartFX and specially developed programs. The system is currently being maintained and newly collected data is added to the DB system every year.

• Journal of Plant Biotechnology
• /
• v.45 no.4
• /
• pp.289-298
• /
• 2018

The Biosafety Division of the National Academy of Agricultural Science has developed a 'Crop Composition DB' that provides analytical data on commercialized crops. It can be used as a reference in the 'Comparative Evaluation by Compositional Analysis' for the safety assessment of genetically modified (GM) crops. This database provides the composition of crops cultivated in Korea, and thus upgrades the data to check the extent of changes in the compositional content depending on the cultivated area, varieties and year. The database is a compilation of data on the antioxidant, nutrient and secondary metabolite compositions of rice and capsicum grown in two or more cultivation areas for a period of more than two years. Data analysis was conducted under the guidelines of the Association of Official Analytical Chemists or methods previously reported on papers. The data was provided as average, minimum and maximum values to assess whether the statistical differences between the GM crops and comparative non-GM crops fall within the biological differences or tolerances of the existing commercial crops. The Crop Composition DB is an open-access source and is easy to access based on the query selected by the user. Moreover, functional ingredients of colored crops, such as potatoes, sweet potatoes and cauliflowers, were provided so that food information can be used and utilized by general consumers. This paper introduces the feature and usage of 'Crop Composition DB', which is a valuable tool for characterizing the composition of conventional crops.