• Proceedings of the Korea Information Processing Society Conference
• /
• 2005.11a
• /
• pp.91-94
• /
• 2005

공학적 기반의 응용 프로그램에서는 복합관계(complex relationship) 및 복합객체(complex object)의 개념이 요구되는데, 이러한 개념들은 비즈니스 응용에 적합한 관계형 데이터베이스로 다루기에는 저장과 검색 시 많은 문제점을 야기한다. 이와 같은 문제점을 해결하기 위해서 객체 관계형 데이터베이스 시스템이 출현하게 되었다. 한편, 고전적인 데이터베이스 설계 기법은 개체 관계형 모델(Entity Relationship Model)과 같은 개념적 모델을 사용하며 데이터 중심의 구조적 관점(structural aspect)만을 고려하는 반면, UML(Unified Modeling Language)같은 객체지향형 설계 도구를 사용하여 데이터베이스를 설계할 경우 구조적 관점 및 행위적 관점(behavioral aspect)을 모두 포함한다. UML은 확장 가능한 언어로서, 특정 응용프로그램에 대한 새로운 스테레오타입(stereotype)의 사용이 가능하다. 데이터베이스 설계를 위한 확장된 UML의 스테레오타입이 제안되었지만, 대부분 관계형 데이터베이스에 초점이 맞추어져 있다. 본 논문에서는 객체 관계형 데이터베이스 설계를 위한 확장된 UML 스테레오타입을 기술하며, 복합관계 및 복합객체를 지원하기 위해 Aggregation, Composition, Association의 개념을 재정의한 설계기법을 제안하고, 제안한 설계기법을 지원하는 설계 도구(ORDesigner)의 구현에 대해서 기술한다.

• Journal of Korean Society of Disaster and Security
• /
• v.6 no.3
• /
• pp.35-42
• /
• 2013

The purpose of this research is to systematize safety management for practical application through analysis and review of several safety standards currently in force among the statutes and rules regarding various safety accidents. Accordingly, the safety standard systems of Japan, US, and Germany were examined and a KOSAM entity relationship diagram (ERD) was drawn based on the ontology system. The ERD consists of the safety standard scope, safety management statute, safety management standard, safety management subjects, causes of safety accidents, and safety management organization entities. Next, each entity was assigned a code and finally a KOSAM safety management condition search screen was designed based on the ERD. This research is expected to bring an overall improvement in safety standard management and operation through safety standard DB construction and the execution of safety management system development.

• Korean Journal of Plant Taxonomy
• /
• v.37 no.3
• /
• pp.309-321
• /
• 2007

Korea national arboretum has worked with the plant taxonomic society of Korea to make the first fully electronic floristic checklist in Korea. The result is an ever-expanding online plant name index containing scientifically authorative, up-to-date information on the approximately 7,000 taxa including cultivars. With 37 contributing taxonomists, KPNI is the largest collaborative research projects ever assembled in Korea. A comprehensive database model for the taxonomic data from literature and other sources is presented, which was devised for the Korea National Plant Index database project (KPNI). Gwangreung database model is based on an approach using entity-relationsip diagram. It encompasses taxa of all ranks, nothotaxa and hybrid formulae, cultivars, full synonymy, basionyms, Korean name, and other nomenclatural information. Ths paper presents an analysis of KPNI work processes and an overview how we are approaching the construction of Gwangreung databaese model. It can help the system engineers of other biological information systems to develop their database based on the accurate and integrative taxonomic database.

• Journal of Korean Society for Geospatial Information Science
• /
• v.8 no.2 s.16
• /
• pp.71-78
• /
• 2000

In these days, the attributes data recorded in computerization of cadastral maps is just written in its own format, not considered the relation with graphic data. Therefore, digital information linked attribute data to graphic data is necessary to be performed as fundamental data of graphic information and analysis of various spatial information. This study is to present the possibility of GIS application by constructing cadastral information related to graphic and attribute Information based on the cadastral map. Attribute information was constructed as a relational database form using data modeling and entity-relationship diagram. Thus, this study is expected to be used as a fundamental data for various public planning and design including the effective management of cadastral information and building parcel based land information system by presenting various spatial analysis and application methods.

• Journal of Intelligence and Information Systems
• /
• v.24 no.3
• /
• pp.243-262
• /
• 2018

Database schema integration is a significant issue in information systems. Because schema integration is a time-consuming and labor-intensive task, many studies have attempted to automate it. Researchers typically use XML as the source schema and leave much of the work to be done through DBA intervention, e.g., there are various naming conflicts related to relationship names in schema integration. In the past, the DBA had to intervene to resolve the naming-conflict name. In this paper, we introduce an algorithm that automatically generates relationship names to resolve relationship name conflicts that occur during schema integration. This algorithm is based on an Internet collocation and English sentence example dictionary. The relationship between the two entities is generated by analyzing examples extracted based on dictionary data through natural language processing. By building a semi-automated schema integration system and testing this algorithm, we found that it showed about 90% accuracy. Using this algorithm, we can resolve the problems related to naming conflicts that occur at schema integration automatically without DBA intervention.

• Journal of Distribution Research
• /
• v.6 no.2
• /
• pp.91-108
• /
• 2002

While a lot of research has been done in the area of the B2C e-commerce, heavily on the Internet shopping, a study on the B2B e-commerce has not been improved enough to be competitive for its importance and practical use. We have studied to build an effective database, attempting to complement and further replace in the long term the off-line distribution channel which has yet to be fully evolve with respect to effectiveness and efficiency. For the building of the effective database, we have gathered information from the related institutions and characterized a fishery channel, and surveyed existing literatures and consumers for deriving factors affecting their purchase intentions and satisfactions. Based upon this survey we constructed the entity-relationship diagram(ERD) which possibly provided some perspectives for the future application. This study focuses on the improvement in the distributional efficiency not only minimizing the intra-organizational conflict and resistance but also maximizing the role function of each party of the organization.

• Journal of Intelligence and Information Systems
• /
• v.17 no.3
• /
• pp.169-185
• /
• 2011

Data redundancy is problematic in that it not only induces heavy storage management cost but also could bring critical degradation of information systems. Unfortunately, to our knowledge, only few enterprises willingly afford time and efforts for the faithful conceptual design to prevent the degree of inappropriate data as much as they could, while most of enterprises pay rare attention to the notion of that sort of data quality. Wondering if there would be any other way to design the enterprise.wide data design without prior knowledge about business works is our major motivation for this study. In this paper, we present our data modeling methodology in which associations among objects in each sentences of a business job descriptions are treated as the focal point in database design. A proposed agent for automated design tool simply takes a business job description written in natural language as an input, and then designs an entity relationship diagram with some smart rules. We introduce the scope of the proposed agent and its detailed logics with several examples. And then, we verify the appropriateness of the resulted associations among objects. Lastly, we perform case studies to evaluate the devised agent's applicability to a business field.

• Journal of Korea Multimedia Society
• /
• v.9 no.6
• /
• pp.742-749
• /
• 2006

In the network-based game where it uses the Internet infrastructure, the implementation is possible with the various methods. Such Applications are developed in the multi-tired architecture. There are many cases for the server to be separated from the hardware or the software. In this case, a lot of applications make the distributed process possible and are made as the multi-tiered architecture to develop the reusability of the existing software module. Especially, it is mostly general to separate for the case of a database server to a new tier. One of the important points of multi-tiered server side applications is security and because of this, it is difficult to share the related data about the design skill. Using design patterns, it gives help in reusing the existing written-code for the design of the game that needs a lot of money and time. Design Patterns are related to the software reuse. For the development of more efficient games, if well-defined design patterns are provided to the developers, then it would make more easy advanced game API and make possible the framework for the game development based on the API Through the analysis of the general network-based game currently servicing in the Internet, in this paper, we discuss how to implement a business logic tier using database system among the server side architectures. The main objective of this article is to show an efficient APIs(Application Programming Interfaces) design method which can be used to manage the data that must be saved to the database system among the packets that client/server have to be exchange.

• Journal of the Korean Society of Industry Convergence
• /
• v.23 no.6_2
• /
• pp.1015-1024
• /
• 2020

By nature, smart construction technology is a convergence technology, therefore aptly constructing and running an information system is needed in order to effectively develop and maintain it. Thus, in this study, an information system prototype was developed for the creation and linking of high precision digital maps at road construction sites for the effective performance of the development of the Information Collecting and Analyzing Techniques in the Construction Site (ICAT). For this, (1) defined input/output (I/O) data of each technical detail of ICAT, (2) analyzed the data flow, (3 ) proposed an information system prototype for high precision digital maps development and connection. Based on the information system prototype constructed in this study, it was inferred that each technique and its information for the Smart Construction Technique Development Business was in a consistent flow. Developed information system prototype would enable effective cooperation between subjects directly involved in the technique development, by defining I/O data in advance. Moreover, it would be of value to practitioners for refining the output data from each technique, thereby linking databases and forming Entity Relationship Diagram.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.16 no.1
• /
• pp.15-25
• /
• 2013

The RIMGIS(River Information Management GIS) has been developed since 2000 for public service and practical applications of related works after the standardization of national river data such as the river facility register report, river survey map, attached map, and etc. The RIMGIS has been improved in order to respond proactively to change in the information environment. Recently, Smart River-based river information services and related data have become so large as to be overwhelming, making necessary improvements in managing big data. In this study a plan was suggested both to respond to these changes in the information environment and to provide a future Smart River-based river information service by understanding the current state of RIMGIS, improving RIMGIS itself, redesigning the database, developing distribution, and integrating river information systems. Therefore, primary and foreign key, which can distinguish attribute information and entity linkages, were redefined to increase the usability of RIMGIS. Database construction of attribute information and entity relationship diagram have been newly redefined to redesign linkages among tables from the perspective of a river standard database. In addition, this study was undertaken to expand the current supplier-oriented operating system to a demand-oriented operating system by establishing an efficient management of river-related information and a utilization system capable of adapting to the changes of a river management paradigm.