• 제목/요약/키워드: entity-relationship model

검색결과 99건 처리시간 0.021초

How Practitioners Perceive a Ternary Relationship in ER Conceptual Modeling

  • Jihae Suh;Jinsoo Park;Buomsoo Kim;Hamirahanim Abdul Rahman
    • Asia pacific journal of information systems
    • /
    • 제28권2호
    • /
    • pp.75-92
    • /
    • 2018
  • Conceptual modeling is well suited as a subject that constitutes the "core" of the Information Systems (IS) discipline and has grown in response to IS development. Several modeling grammars and methods have been studied extensively in the IS discipline. Previous studies, however, present deficiencies in research methods and even put forward contradictory results about the ternary relationship in conceptual modeling. For instance, some studies contend that the semantics of a binary relationship are better for novices, but others argue that a ternary relationship is better than three binary relationships when the association among three entity types clearly exists. The objective of this research is to acquire complete and accurate understanding of the ternary relationship, specifically to understand practitioners' modeling performance when utilizing either a ternary or binary relationship. To the best of our knowledge, no previous work clearly compares real-world modeler performance differences between binary and ternary representations. By investigating practitioners' understanding of ternary relationship and identifying practitioners' cognition, this research can broaden the perspective on conceptual modeling.

온톨로지와 개체관계 모델의 상호운용성에 대한 연구 (An Investigation on the Interoperability between Ontology and the Entity-Relationship Model)

  • 이동훈;김남규;정인환
    • 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.

전자의무기록 식별을 위한 메타데이터의 연구 (The Study of Metadata Model to Identify Electronic Medical Record)

  • 홍성호;김영섭
    • 반도체디스플레이기술학회지
    • /
    • 제13권2호
    • /
    • pp.63-66
    • /
    • 2014
  • Managing electronic medical record is very difficult, because the currently electronic medical system is not designed standard that is uniform and proper. In this paper, in order to overcome this situation, we propose meta-data for the management of the electronic medical record as a single system. To this end, we first analyzed the research on electronic medical records and related standards. Second, we, on the basis of the analysis result, abstracted electronic medical record and entities related on electronic medical, and we designed an entity-relationship model. And finally, we have to complete the meta-data through the setting attributes in this entity-relationship model. Through this study, it was possible that we can complete metadata highly expressive medical records, and suggest an alternative for problem of current medical records systems.

관계 역할에 따른 개체 - 관계 모델의 객체지향 데이타베이스 모델로 변환 (Transforming an Entity - Relationship Model into an Object - Oriented Database Model Depending on the Role of Relationship)

  • 김삼남;이홍로;류근호
    • 한국정보처리학회논문지
    • /
    • 제4권7호
    • /
    • pp.1665-1680
    • /
    • 1997
  • 다양한 응용 분야의 데이터베이스 설계시에 시스템 사용자와 설계자 간의 이해를 증진시키고 올바른 모델링을 위해 개체-관계 모델이 많이 사용되고 있다. 그렇지만 효과적인 구현을 위해 이 개체-관계 모델로 표현된 데이터베이스는 데이터 조작과 표현이 효율적인 객체지향 데이터베이스 모델로 변환되어야 한다. 이를 위해 개체-관계 모델의 모든 개념을 객체지향 모델의 개념으로 의미의 손실없이 변환시키는 방법이 연구되어야 한다. 이 논문은 일반화 상속과 집단화 상속의 개념을 도입하여 개체-관계 모델의 기능을 확장시켰고, 개체-관계 모델의 각 성분을 객체지향 데이터베이스 모델의 성분으로 변환시키는 규칙을 제시하고자 한다. 이 변환 규칙에서 역할에 따른 변환 기법을 제시하고, 이 제시된 변환 규칙을 이용하여 개체-관계 모델에서 객체지향 모델의 스키마로 의미의 손실 없이 변환됨을 예로써 보인다. 제안된 변환 기법은 데이터베이스 설계의 논리적 모델 설계에 활용될 수 있다.

  • PDF

Requirement-Oriented Entity Relationship Modeling

  • Lee, Sang-Won;Shin, Kyung-Shik
    • Journal of Information Technology Applications and Management
    • /
    • 제17권3호
    • /
    • pp.1-24
    • /
    • 2010
  • Most of enterprises depend on a data modeler during developing their management information systems. In formulating business requirements for information systems, they widely and naturally use the interview method between a data modeler and a field worker. But, the discrepancy between both parties would certainly cause information loss and distortion that lead to let the systems not faithful to real business works. To improve or avoid modeler-dependant data modeling process, many automated data design CASE tools have been introduced. However, since most of traditional CASE tools just support drawing works for conceptual data design, a data modeler could not generate an ERD faithful to real business works and a user could not use them without any knowledge on database. Although some CASE tools supported conceptual data design, they still required too much preliminary database knowledge for a user. Against these traditional CASE tools, we proposed a Requirement-Oriented Entity Relationship Model for automated data design tool, called ROERM. Based on Non-Stop Methodology, ROERM adopts inner systematic modules for complete and sound ERD that is faithful to real field works, where modules are composed of interaction modules with a user, rules of schema operations and sentence translations. In addition to structure design of ROERM, we also devise detailed algorithms and perform an experiment for a case study.

  • PDF

교수.학습 디지털 컨텐트 통합 메타데이터 및 개체-관계 모델 설계 (Design of Unification Meta-data and Entity-Relationship Model for Educational Digital Content)

  • 구덕회
    • 정보교육학회논문지
    • /
    • 제6권3호
    • /
    • pp.317-327
    • /
    • 2002
  • 최근 초 중등학교의 ICT 활용 교수 학습을 지원하기 위한 디지털 컨텐트 서비스 시스템이 다양하게 만들어지고 있다. 이 시스템들은 초 중등학교의 교사와 학생들을 주 사용자로 하고 있는데, 일관된 계획이나 표준안 없이 필요에 따라 하나씩 만들어지다 보니 실제 사용자들에게는 교수 학습 디지털 컨텐트에 대한 전체적인 통합 검색이나 체계적인 활용 인터페이스를 제공하지 못하고 있다. 이와 같은 문제를 해소하기 위하여 본 연구에서는 국제적인 메타데이터 표준안인 Dublin Core Education을 수용한 교수 학습 디지털 컨텐트 통합 메타데이터 기술항목을 제시하고 이를 구현하기 위한 개체-관계 모델을 설계하였다. 이러한 통합 메타데이터 및 개체-관계 모델 설계 결과는 다양한 교수 학습 디지털 컨텐츠의 통합 검색 및 일관된 활용 인터페이스를 구현할 수 있는 기초 연구로서, 초 중등학교 교사와 학생들이 보다 유용하게 사용할 수 있는 서비스 시스템을 개발하는데 기여할 수 있을 것으로 본다.

  • PDF

관계형 데이터베이스에 기반한 버전이 지원되는 VHDL 모델의 관리 기법 (A Methodology for Management of Version Supported VHDL Models Based on Relational Database)

  • 박휴찬
    • 한국시뮬레이션학회논문지
    • /
    • 제11권2호
    • /
    • pp.55-66
    • /
    • 2002
  • VHDL has been. widely used in modeling and simulation of hardware designs. However, complex relationship between components of the designs makes the VHDL modeling problem very difficult. Furthermore, after the initial creation of VHDL models, they evolve into many versions over their lifetime. To cope with such difficulties, this paper proposes a new methodology for the management of VHDL models supporting versions. Its conceptual bases are system entity structure and relational database. Within the methodology, a family of hierarchical structures of a design is organized in the form of VHDL model structure. It is, in turn, represented in the form of relational tables. Once the model structure is built in such a way, a specific simulation model which meets design objective is pruned from the model structure. The details of VHDL codes are systematically synthesized by combining it with the primitive models in a model base. These algorithms are also defined in terms of relational algebraic operations.

  • PDF

연관규칙 마이닝을 활용한 개념적 데이터베이스 설계 자동화 기법 (Automated Conceptual Data Modeling Using Association Rule Mining)

  • 손윤호;김인규;김남규
    • 한국정보시스템학회지:정보시스템연구
    • /
    • 제18권4호
    • /
    • pp.59-86
    • /
    • 2009
  • Data modeling can be regarded as a series of processes to abstract real-world business concerns. The conceptual modeling phase is often regarded as the most difficult stage in the entire modeling process, because quite different conceptual models may be produced even for similar business domains based on users' varying requirements and the data modelers' diverse perceptions of the requirements. This implies that an object considered as an entity in one domain may be considered as an attribute in another, and vice versa. However, many traditional knowledge-based automated database design systems unfortunately fail to construct appropriate Entity-Relationship Diagrams(ERDs) for a given set of requirements due to the rigid assumption that an object should be classified as an entity if it has been classified as an entity in previous applications. In this paper, we propose an alternative automation system which can generate ERDs from business descriptions using association rule mining technique. Our system can be differentiated from the traditional ones in that our system can perform data modeling only based on business description written by domain workers, rather than relying on any kind of knowledge base. Since the proposed system can produce various versions of ERDs from the same business descriptions simultaneously, users can have the opportunity to choose one of the ERDs as being the most appropriate, based on their business environment and requirements. We performed a case study for personnel management in a university to evaluate the practicability of the proposed system This paper summarizes the result of it in the experiment section.

웹사이트의 정보 모델과 사용성의 관계 (A Study on the Relation Between Information Model and Usability of Website)

  • 이지수
    • 디자인학연구
    • /
    • 제13권4호
    • /
    • pp.67-76
    • /
    • 2000
  • 웹사이트는 다양한 컨텐츠 영역에서 여러 유형의 사용자 활동을 지원하며, 이에 따라 주요 인터페이스 디자인 문제를 추출하기 위한 서로 다른 접근을 요구한다. 본 연구에서는 웹사이트의 매체적 역할을 중심으로 개발자, 사용자, 웹사이트간의 관계를 이해하고 사용성에 관한 디자인 요소들에 대해 보다 체계적인 관점에서 파악함으로써 인터페이스 구현의 기초적인 틀을 마련하고자 한다. 매체적 측면에서 웹사이트는 사용자와 개발자 사이에 존재하는 일종의 정보체라 할 수 있다. 사용성을 중심으로 한 정보체의 형성에는 사용자, 개발자, 웹사이트 및 여러 환경적 요인들과 관련된 다양한 디자인 요소들이 포함된다. 이는 궁극적으로 정보체를 매개로 한 상호작용에 있어서 사용자와 정보체가 보다 수용하는 상태, 즉 공통적인 개념모델의 형성을 위한 것이 되어야 한다. 이를 위해서는 사용자 목표 및 인지적, 정서적 측면의 사용자 특성에 대한 이해를 바탕으로 크게 합목적성, 효율성, 주관적 만족의 사용성이 요구된다. 이러한 맥락에 따라 정보체의 기본 구조 즉, 정보 모델을 설정하고 이에 따른 디자인 요소 및 이의 특질에 대해 파악한다. 정보모델은 크게 내용 수준, 구성 수준, 표현 수준으로 구분할 수 있으며 각 수준별로 사용자의 적절한 인지적, 정서적 측면의 작용을 위한 디자인 요소들을 파악함으로써 인터페이스 디자인의 주요 문제를 체계적으로 이해한다.

  • PDF