• Journal of the Korean Society for Library and Information Science
• /
• v.45 no.3
• /
• pp.69-85
• /
• 2011

This study reviewed theories for database integration, which combines heterogeneous data structures, and suggested a practical method to integrate databases of Korean Research Memory(KRM) and Infrastructural Basic Research(IBR) as a case study. In order to broadly distribute the outcomes of IBR, it is essential to be connected to and integrated with the database of KRM. As a solution, it was suggested that the current database of IBR should follow standard guidelines as a XML database, and its future database should be integrated with the database of KRM or be established as a stand-alone system

• The Journal of the Korea Contents Association
• /
• v.18 no.2
• /
• pp.262-268
• /
• 2018

It is essential to build a integrated database (DB) to grasp the present status and various analysis of the economic, social and cultural sectors of local governments and to provide various inquiries on the status data of the local governments according to the purpose of analysis. This study proposed a design method of the integrated DB which can support the inquiry and analysis of the data by the local government. The integrated DB should cover a wide range of heterogeneous data on the economic, social and cultural activities of local governments, and it is necessary to design a schema that can integrate the entire data considering differences between local governments and data elements. The data should be structured in accordance with the characteristics, and it should be possible to inquire related data comprehensively through the search through the keywords. In addition, data retrieval and downloading functions are indispensable for the researcher to easily retrieve data necessary for research purpose and to download and modify data for analysis.

• Journal of the military operations research society of Korea
• /
• v.34 no.1
• /
• pp.13-30
• /
• 2008

In this study, the establishment strategies of Military Standardization Information System and Integrated Database(DB) based on standardization information are provided. The establishment strategies introduced here are based on the appliable common(commercial and military) classification of specifications/standards. The common(commercial and military) classification of specifications/standards adapted in this study can be constructed through mapping by 'grouping' between the MS(Military Specification/Standards) and KS(Korean industry Standards) to increase efficiency. In detail, the establishment of Integrated Database(DB) based on standardization information provides the various channel of interactive communication among specifications/standards. Additionally, standardization information systems provide the basis of the integrated specifications/standards converged between the commercial and military sector.

• Genomics & Informatics
• /
• v.7 no.4
• /
• pp.212-216
• /
• 2009

WebChemDB is an integrated chemical database retrieval system that provides access to over 8 million publicly available chemical structures, including related information on their biological activities and direct links to other public chemical resources, such as PubChem, ChEBI, and DrugBank. The data are publicly available over the web, using two-dimensional (2D) and three-dimensional (3D) structure retrieval systems with various filters and molecular descriptors. The web services API also provides researchers with functionalities to programmatically manipulate, search, and analyze the data.

• The Journal of the Korea Contents Association
• /
• v.16 no.6
• /
• pp.441-449
• /
• 2016

The integrated data is an essential in the analysis for the balanced development of the local governments, but economic, social and cultural data in local governments is not being made with integrated management. A variety of information is being published according to the Government 3.0 era, but the researchers has great difficulty in integrating the analysis for one topic because related information is scattered in various sites. This paper proposes an integrated database(DB) of local governments to support the research activities. It has to contains total information of economic, social and cultural activities of local governments, and accommodate the distributed and heterogeneous data. It has the schema designed to integrate the entire data for considering the differences between local governments or data components. We should focus to build a framework for the multifaceted research to enable the cross analysis over common elements.

• Genomics & Informatics
• /
• v.9 no.4
• /
• pp.197-199
• /
• 2011

The biological interpretation of two-dimensional (2D) gel electrophoresis experiments is a key step toward understanding the functions of biological systems. We here present a web-based integrated database, called 2DSpotDB, for the management of proteome data derived from several pathogens. The 2DSpotDB was established as a part of the management of a pathogen proteome project at the Korea National Institute of Health. The goals of the 2DSpotDB implementation are to store and define important pathogen genes, retrieve information obtained by 2D polyacrylamide gel electrophoresis and mass spectrometry, and create an integrated system to provide pathogen proteome information for biological scientists. This database currently contains 14 gels and information on 387 protein spots, among which 329 proteins were identified and annotated.

• The Journal of the Korea Contents Association
• /
• v.20 no.2
• /
• pp.689-699
• /
• 2020

The National Science and Technology Information Center (NDSL) database, which provides academic papers at home and abroad, collects, builds, and manages data collected from various sources. In this study, we analyzed the DB paper schema and DB metadata that are currently constructed and managed to derive an integrated DB schema that can manage the high-value-added papers and manage them efficiently by analyzing distributed DB papers. Also, the final academic information data items were determined through comparison and analysis using the Web of Science and SCOPUS schemas that are currently purchased and possessed. The academic information data items constructed and serviced through this study were summarized into seven papers, authors, abstracts, institutions, themes, journals, and references, and defined as core contents under construction. The integrated DB schema was created through this study, and the results of this study will be used as a basis for constructing the integrated DB collection of high quality academic papers and designing the integrated system.

• Journal of the Korean Geographical Society
• /
• v.40 no.2 s.107
• /
• pp.153-171
• /
• 2005

The newly adopted Korea Geodetic Datum (a.k.a. KGD2002) calls for massive reengineering work on geospatial dataset. The main focus of our study is placed on the strategy and system implementations of the required data reengineering with a keen attention to integrated approaches to interoperability, standardization, and database utilization. Our reengineering strategy includes file-to-file, file-to-DB, DB-to-file, and DB-to-DB conversion for the coordinate transformation of KGD2002. In addition to the map formats of existing standards such as DXF and Shapefile, the newly recommended standards such as GML and SVG are also accommodated in our reengineering environment. These four types of standard format may be imported into and exported from spatial database via KGD2002 transformation component. The DB-to-DB conversion, in particular, includes not only intra-database conversion but also inter-database conversion between SDE/Oracle and Oracle Spatial. All these implementations were carried out in multiple computing environments: desktop and the Web. The feasibility test of our system shows that the coordinate differences between Bessel and GRS80 ellipsoid agree with the criteria presented in the existing researches.

• Journal of the Korea Society of Computer and Information
• /
• v.23 no.3
• /
• pp.41-48
• /
• 2018

The recent sudden increase of big data has characteristics such as continuous generation of data, large amount, and unstructured format. The existing relational database technologies are inadequate to handle such big data due to the limited processing speed and the significant storage expansion cost. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we develop and propose the integrated design methodology based on MongoDB for big data applications. The proposed methodology is more scalable than the existing methodology, so it is easy to handle big data.

• Journal of Food Hygiene and Safety
• /
• v.35 no.6
• /
• pp.607-617
• /
• 2020

Human bio-monitoring (HBM) data is a very important resource for tracking total exposure and concentrations of a parent chemical or its metabolites in human biomarkers. However, until now, it was difficult to execute the integration of different types of HBM data due to incompatibility problems caused by gaps in study design, chemical description and coding system between different sources in Korea. In this study, we presented a standardized code system and HBM knowledge model (KM) based on relational database modeling methodology. For this purpose, we used 11 raw datasets collected from the Ministry of Food and Drug Safety (MFDS) between 2006 and 2018. We then constructed the HBM database (DB) using a total of 205,491 concentration-related data points for 18,870 participants and 86 chemicals. In addition, we developed a summary report-type statistical analysis program to verify the inputted HBM datasets. This study will contribute to promoting the sustainable creation and versatile utilization of big-data for HBM results at the MFDS.