• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.26 no.1
• /
• pp.1-7
• /
• 2008

The government is spending a large amount of budget to establish NGIS due to the importance of geospatial information. This paper deals with the study of schema mapping technique which can efficiently establish military topographic DB forest layer using digital forest map and other existing geospatial DB. In order to accomplish this each schema of these types of DB was analyzed then, mapping table which connects related attributes was created and finally, military topographical DB forest layer of the area of interest was efficiently established. This research was able to display solutions that resolved compatibility issues between existing geospatial DB of these types, established by the schema mapping techniques described in this research.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2007.04a
• /
• pp.257-260
• /
• 2007

The government is spending a large amount of budget to establish NGIS due to the importance of geospatial information. This paper deals with the study of schema mapping technique which can efficiently establish military topographic DB forest layer using digital forest map and other existing geospatial DB. In order to accomplish this 1) each schema of these types of DB was analyzed then, 2) mapping table which connects related attributes was created and finally, 3) military topographical DB forest layer of the area of interest was efficiently established. This research was able to display solutions that resolved compatibility issues between existing geospatial DB of these types, established by the schema mapping techniques described in this research.

• Journal of Navigation and Port Research
• /
• v.29 no.10 s.106
• /
• pp.883-890
• /
• 2005

Database Integration problems has been recognized as a critical issue for effective logistics service in logistics environment. However, researches related to effective methodology for this have been studied theoretically in the DB schema integration, are insufficient in the side of the system realization. The aim of this paper is to present a schema integration technique to integrate DB using XML( eXtensible Markup Language) in the part of practical DB integration, a quantitative methodology for the identification of conflict that is a representative problem on database integration. To achieve this aim, we extracted the entity name and attribute name from DB schema and suggested a quantitative methodology to easily fine name conflict that frequently give raise to a trouble when schema integration, based on the level of semantic similarity between attributes and entities.

• Proceedings of the Korean Institute of Navigation and Port Research Conference
• /
• 2005.10a
• /
• pp.353-360
• /
• 2005

Database Integration problems has been recognized as a critical issue for effective logistics service in logistics environment. However, researches related to effective methodology for this have been studied theoretically in the DB schema integration, are insufficient in the side of the system realization. The aim of this paper is to present a schema integration technique to integrate DB using XML(eXtensible Markup Language) in the part of practical DB integration, a quantitative methodology for the identification of conflict that is a representative problem on database integration. To achieve this aim, we extracted the entity name and attribute name from DB schema and suggested a quantitative methodology to easily fine name conflict that frequently give raise to a trouble when schema integration, based on the level of semantic similarity between attributes and entities.

• 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.

• Proceedings of the KSR Conference
• /
• 2008.06a
• /
• pp.1494-1498
• /
• 2008

This paper shows a case study on the design of the schema of the information DB of the City-Train Standardization project. The process used in this case is : Database development, Schema design, and cross referencing of the data with the work process items. The DB and the schema was implemented using computer aided systems engineering tool Cradle■. We expect that the user can find the data and the related information very easily, quickly without omission.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2005.06a
• /
• pp.187-190
• /
• 2005

There have been many studies to improve the performance of a database system focused on modifying data structure, data partitioning, and materializing strategy. The main contribution of this study is to propose a new alternative towards improving database performance by designing single table schema or processing queries virtually in main memory space. Material Requirement Planning(MRP) part explosion process has shown almost 2 times shorter under DB schema we suggested, and even more than 10 times shorter when separating and filtering policy of DB archiving process are assumed. Several experimental results are shown to illustrate the excellence of our solution.

• Proceedings of the Korean Information Science Society Conference
• /
• 2004.10b
• /
• pp.148-150
• /
• 2004

XML(1)이 인터넷 상의 메시지 교환 형식으로 활발히 이용되면서, XML을 이용하는 많은 응용에서는 이를 효율적으로 관리하기 위한 방법이 요구되었다. 이러한 요구에 발 맞추어 현재, XML 데이터의 관리를 위한 많은 연구(3, 4, 5, 6, 7, 8, 9)가 진행 중에 있으나 아직까지는 어떤 방법이 XML 데이터의 관리를 위해 최적의 방법이라는 결론은 없는 실정이다 또한, 이러한 방법들을 실제 응용에 적용하기 위해서는 시스템 관리자가 XML 문서의 특성을 파악하고, 이를 기반으로 XML 데이터의 관리를 위해서 필요한 모든 모듈들을 개별적으로 개발하고 관리해야 한다. 이와 같은 방법은 응용의 측면에서 추가적인 비용과 노력을 추가해야 하는 부담이 발생한다. 본 논문에서는 앞서 언급한 요구사항들을 해결하기 위하여 고려하여 XML Schema to Relational Database Schema (XMLStoDBS)라는 XML문서를 제안하고, 이를 이용하여 응용에서 필요한 XML 데이터 관리 시스템을 자동으로 생성하기 위한 방법을 제안한다. XMLStoDBS는 응용에서 사용하고자 하는 XML Schema또는 DTD의 정보와 실제 데이터가 저장될 데이터베이스의 정보, 이 둘간의 사상관계를 표현하는 문서이다. 우리의 XMLStoDBS는 사용자가 응용에서 사용하고자 하는 XML Schema/DTD의 입력만으로 자동으로 생성되며, 응용에서는 이를 이용하여 응용에 필요한 XML 데이터 관리 시스템을 자동으로 생성할 수 있다.

• Journal of Digital Convergence
• /
• v.11 no.2
• /
• pp.193-203
• /
• 2013

In our thesis we introduce case study for qualifying university graduates system for efficient maintenance. First, we find out factors to make maintenance difficult and present solution for them. Second, we convert system architecture from algorithm-oriented to driving-engine-based, design DB schema, develop algorithms for important components of proposed system, and implement them. Through results of system operation, we show that our system can reduce maintenance cost fairly.

• 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.