• 안보군사학연구
• /
• 통권1호
• /
• pp.269-310
• /
• 2003

AS Extensible Markup Language(XML) is emerging as the data format of the Internet era, there are increasing needs to efficiently transform between database and XML documents. In this paper, we propose a schema transformation method from relational database to XML database. To transform the schema, we represent input schema as Entity-Relationship diagram. Entity-Relationship model translator scans the input Entity-Relationship diagram using BFS (breadth First Search) and translates the diagram into hierarchical structure model. The XML Schema generator produces XML Scema code using the transformed hierarchical structure model. The proposed method has a merit that having reusability facility of XML Schema property in comparison with existing researches.

• 한국정밀공학회지
• /
• 제16권7호
• /
• pp.132-143
• /
• 1999

In this study, an intermediate model is presented as a new method for development of a parametric simulation program. This model enables us to analyze effectively the static and dynamic structure of a real production system. The static structure of the real system can be modelled in an entity-relationship diagram and the dynamic structure of the real system in a Petri net. The intermediate model consists of an entity-relationship diagram and a Petri net. Using this intermediate model man can not only reduce the time and cost for simulation program development, but also increase the modelling reliability of the developed simulation program. To show the usefulness of this intermediate model. the intermediate models for two production subsystems, manufacturing sub-system and transport subsystem, are set up.

• 한국인터넷방송통신학회논문지
• /
• 제15권1호
• /
• pp.157-163
• /
• 2015

XML은 인터넷 상의 데이터의 표현 및 교환의 사실상 표준으로 자리 잡고 있으며, XML 자체가 데이터를 저장하기 위한 논리적 구조를 표현하고 있지만, 다양하고 복잡한 표현으로 인해 문서 구조를 한 눈에 파악하기에는 어려운 점이 있어 개념적 모델의 도구로 사용하기 적절하지 못한 점이 있다. 본 논문은 XML 스키마 문서 구조를 확장된 개체관계 모델을 이용하여 그래픽 형태로 개념적 모델링할 수 있는 기법을 제안한다. 이를 위해 XML 스키마 구조를 표현하기 위해 확장된 개체관계 모델을 제시하고, XML 스키마 요소들을 확장된 개체관계 모델로 표현하기 위한 표현규칙들을 제시하고, 제안한 기법으로 모델링한 개념적 모델을 논리적 모델인 XML 스키마 문서로 매핑하는 사례를 통해 본 기법의 완전성을 보여준다.

• 산업기술연구
• /
• 제25권A호
• /
• pp.123-131
• /
• 2005

Semantic object model has widely been recognized as an alternative data modeling approach to entity-relationship model for database system design. In this study, we have presented a semantic object model for intermediary type shopping mall consisting of multiple buyers and sellers. Essential processes and information with regard to the customer management, product management, price estimation, product order etc. have been considered for this study. Upon careful examination and analysis of them, a detailed semantic objects and attributes have been drawn and structured into semantic object diagrams. The final objects were converted into an entity-relationship diagram so that intuitive comparison could be made for relational database design. The results in this study may form a conceptual framework for both academic concerns and more complicated system applications.

• 한국인터넷방송통신학회논문지
• /
• 제13권2호
• /
• pp.149-155
• /
• 2013

오늘날 대표적인 데이터베이스 설계 도구로 개체 관계 모델을 사용하고 있으며, 데이터를 표현하고 교환하는 표준 언어로 XML을 사용하고 있다. 그러나 많은 개체 관계 모델 제품들은 각각 서로 다른 표현형식을 사용하기 때문에 이들 제품들 사이에 호환성에 어려운 점이 있으며, XML은 언어가 갖는 복잡성으로 인해 XML을 이용하여 현실세계를 직접 설계하기에는 어려운 점이 있다. 본 논문은 이질적인 제품들 사이의 호환성을 제공하기 위해 개체 관계 모델을 XML 스키마로 변환하는 도구인 ERX(Entity-Relationship model to Xml)를 제안한다. ERX는 입력으로 개체 관계 다이어그램을 받아 이를 변환 규칙을 통해 XML 스키마를 출력한다. 변환 규칙에는 개체집합, 관계집합, 매핑 대응수(mapping cardinality), 일반화(generalization) 개념 등을 포함한다.

• 한국인터넷방송통신학회논문지
• /
• 제11권5호
• /
• pp.11-17
• /
• 2011

본 논문은 개체 관계 모델을 기반으로 하는 논리적 데이터베이스 설계도구인 ER_Modeler 개발에 관한 연구이다. ER_Modeler는 윈도우 상에서 개체 관계 다이어그램(Entity-Relationship Diagram: ERD)을 작성할 수 있는 그래픽 편집도구 기능과 생성된 ERD 정보로부터 논리적 데이터베이스 테이블을 정의하기 위해 데이터 정의어(Data Definition Language: DDL)를 자동 생성하는 기능을 제공한다. 또한 상업적으로 가장 많이 사용되고 있는 Erwin 제품과의 호환성을 제공하기 위해 XML을 이용하여 ERwin과의 Export/Import 기능도 제공해준다.

• 정보처리학회논문지D
• /
• 제11D권3호
• /
• pp.553-562
• /
• 2004

본 논문에서는 데이터베이스 설계시 중요한 과정인 개념설계 단계에서 개체관계도(Entity Relationship Diagram)의 정보를 저장하는 ERD시소러스(Thesaurus)를 구축하고, 이러한 ERD시소러스를 기반으로 하는 뷰 통합 방법론을 제시하고자 한다. 제시된 방법론의 유용성을 입증하기 위하여, 적용사례에 대한 뷰 통합지원시스템의 프로토타입을 구축하였다. 적용결과, ERD시소러스 기반의 방법론이 기존의 뷰 통합 방법론보다 친밀도 분석, 의미충돌 해결, 유 통합과정에서 더 효과적임을 확인할 수 있었다. 따라서 이 방법론이 기존의 단편화된 스키마의 통합이나 대규모 데이터베이스 통합 설계시 유용하게 활용될 수 있을 것으로 기대된다.

• 국제학술발표논문집
• /
• The 6th International Conference on Construction Engineering and Project Management
• /
• pp.693-694
• /
• 2015

While urban regeneration projects are currently under active execution in several old cities in Korea, there are few projects to improve the quality of life of rural communities. Considering the decline of the SOC system, deterioration of housing, and degeneration of economic feasibility, the purpose of this study is to provide solutions to realize an improved economic and social environment of rural communities through an integrated management system for traffic safety and water management systems. Therefore, this research used an Entity-Relationship Diagram to construct an integrated system for traffic safety and water management systems for Chungcheong rural communities. The ERD is prepared by depicting 7 relationships for 13 entities, including traffic accidents and agricultural products, and 26 attributes, including soil moisture and underflow storage. Consequently, it will be possible to set up a decision-making support system that can analyze and evaluate the regeneration index, technology, and management of the systems for Chungcheong rural communities, based on supplier and user perspectives

• 정보기술과데이타베이스저널
• /
• 제6권2호
• /
• pp.45-57
• /
• 1999

This paper makes an attempt to find a systematic portion of the database design process, especially using the Entity-Relationship(E-R) model. Basically, we consider three aspects as a systematic portion of the database design process. They are, the strategy that a designer selects to design an E-R diagram, designer's cognitive style, and the knowledge and preference of the database designer. An experiment has been carried out in order to verify the systematic relationship between above-mentioned three aspects and the E-R modeling performance. The target system is a professional baseball system. A normative E-R diagram was constructed based upon 48 E-R diagrams produced during the experiment. The ANOVA process has been used to analyze the results. It has been found that there exist significant differences in query-answering capacity and the completeness of the E-R model among design methods. Individual differences in cognitive styles has not been found to be significantly related to the modeling performance.

• Journal of Information Technology Applications and Management
• /
• 제18권4호
• /
• pp.95-118
• /
• 2011

In developing information systems, conceptual modeling is among the most fundamental means. The importance attributed to conceptual modeling has not only given rise to a lot of modeling methods, but also to the "yet another modeling approach (YAMA)" syndrome and the "not another modeling approach (NAMA)" hysteria. Criticism of conceptual modeling methods usually targets their lacking of theoretical foundations. In response to such criticism, various approaches towards theoretical foundations of conceptual modeling have been proposed so far. One of the recent responses to the quest for theoretical foundations of conceptual modeling is the reference to the philosophical ontology. The currently most prominent of diverse approaches towards ontological foundations of conceptual modeling appears to be the Bunge-Wand-Weber (BWW) ontology. Recent approaches attempt to regard BWW ontology as another conceptual data model as well as a criterion for evaluating various conceptual models. However, unfortunately, relatively few researches have been made on interoperability between the Entity-Relationship (ER) model, which is the most dominant conceptual data model, and ontology based model. In this paper, we investigate the interoperability between ontology and the ER model. In detail we (i) reclassify components of ER model with respect to ontology concepts, (ii) identify some components that cannot be directly represented in ontology notation, and (iii) present alternative representations to the components to acquire ontologically clear ER diagrams. Additionally, we (iv) present a set of mapping rules for converting the ontologically clear ER diagram into the corresponding ontology. In a case study, we show the process of converting an ER diagram for a concise Project Management System (PMS) into the ontologically clear ER diagram and the corresponding ontology. We also describe an experiment that we undertook to test whether users understand the Ontologically-Clear ER diagram better.