• Title/Summary/Keyword: Entity-Relationship model

Search Result 96, Processing Time 0.027 seconds

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

  • Lee, Dong-Hoon;Kim, Nam-Gyu;Jung, In-Hwan
    • Journal of Information Technology Applications and Management
    • /
    • v.18 no.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 (전자의무기록 식별을 위한 메타데이터의 연구)

  • Hong, Sung Ho;Kim, Young Seop
    • Journal of the Semiconductor & Display Technology
    • /
    • v.13 no.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 (관계 역할에 따른 개체 - 관계 모델의 객체지향 데이타베이스 모델로 변환)

  • Kim, Sam-Nam;Lee, Hong-Ro;Ryu, Keun-Ho
    • The Transactions of the Korea Information Processing Society
    • /
    • v.4 no.7
    • /
    • pp.1665-1680
    • /
    • 1997
  • The Entity-Relationship (E-R) model is widely used not only to increase understanding between user and designer, but also to model the relationship of real world data appropriately when designing database system in many application areas. It should be then transformed into an Object-Oriented database model which gives good merits to represent and manipulate data efficiently. Therefore, a method of transforming an E-R model into an Object-Oriented database model should be studied, but without losing any semantics of concept for the E-R model. This paper not only deals with transformation rules taking as input the elements of E-R model and delivering the elements of an Object-Oriented database model, but also improves the concept of generalization and aggregation inheritance. The paper also presents a method of transformation of relationship depending on these rules. The proposed method that obtains Object-Oriented database schema from an E-R model with preserving the properties of the E-R model is shown with examples. The method presented is able to be used to the logical database design.

  • PDF

Requirement-Oriented Entity Relationship Modeling

  • Lee, Sang-Won;Shin, Kyung-Shik
    • Journal of Information Technology Applications and Management
    • /
    • v.17 no.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 (교수.학습 디지털 컨텐트 통합 메타데이터 및 개체-관계 모델 설계)

  • Koo, Duk-Hoi
    • Journal of The Korean Association of Information Education
    • /
    • v.6 no.3
    • /
    • pp.317-327
    • /
    • 2002
  • The need to support the ICT-using teaching and learning at elementary and secondary schools has led to various digital content service systems. The systems are designed to target the teachers and the students as the major users. The problems involved in them is that they do not provide such services as the integrated search and the systematic use of interface in terms of actual users' use of teaching and learning digital content. It's because they have been created at demands at each time. In an attempt to solve this problem, this study set out to suggest the integrated meta-data items of a teaching and learning digital content, which reflects the Dublin Core Education, the international meta-data standard. It also aimed to design an entity-relationship model to realize the digital content. The results of the integrated meta-data and the entity-relationship model will be utilized as a basic research to help the users to search for various teaching and learning digital contents on an integrated basis and to realize a consistent user interface. Furthermore, they are expected to contribute to the development a service system the teachers and the students can make better use of.

  • PDF

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

  • 박휴찬
    • Journal of the Korea Society for Simulation
    • /
    • v.11 no.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 (연관규칙 마이닝을 활용한 개념적 데이터베이스 설계 자동화 기법)

  • Son, Yoon-Ho;Kim, In-Kyu;Kim, Nam-Gyu
    • The Journal of Information Systems
    • /
    • v.18 no.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 (웹사이트의 정보 모델과 사용성의 관계)

  • 이지수
    • Archives of design research
    • /
    • v.13 no.4
    • /
    • pp.67-76
    • /
    • 2000
  • Websites support various user activities in a wide range of contents domain and so they require different approach to extract principal design problems. In the point of media perspective on websites, this paper figures out the relationship between designer, user and website and discusses design factors of usability. It aims for the basic framework for interface design. In the media perspective website is an information entity mediating user and designer. Information entity is composed of various design factors relating to user, designer, website and others. It intends that user and information entity are accommodative to each other and have common conceptual model. To do so it is necessary for achieving usability objectives such as effectiveness, efficiency and satisfaction based on the understanding user goal, cognitive and affective characteristics. In the point of usability we examine design factors and features that are appropriate for users cognitive and affective function according to information entity model that constitutes contents, organization and representation level.

  • PDF

A Study on the Application of the Two Step Supply System of Public Rental Housing - Focused on the cases of SI housing with skeleton rental in Japan - (공공임대주택의 2단계 공급방식 적용 방안에 관한 연구 - 일본 스켈레톤 임대형 SI주택 사례를 중심으로 -)

  • Yi, Yong-Kyu;Park, Ji-Young
    • Journal of the Architectural Institute of Korea Planning & Design
    • /
    • v.35 no.7
    • /
    • pp.45-52
    • /
    • 2019
  • In recent years, there has been a demand for a residential supply model that can actively and flexibly cope with various housing demands in the changing paradigm of public rental housing. This study focuses on the two-step supply system that has been studied in Japan. It was used to examine and analyze cases to recommend a supply plan that can be used for domestic public rental housing. In more detail, the literature review of the two-step supply system discloses that four types by supply methods (A-1, A-2, B-2, and C-2) and four types of relationship (construction and management combine entities type, management entity type, construction entity type, a separated entity type) can be categorized. In addition, from the actual case study, it revealed that the way of linking and supplying activities among the entity can have a great influence on "ease of supply (supply)", "diversity of housing demand (diversity)," and "quality of construction (construction)". "Ease of supply (supply)" refers to whether the construction entity is separated, and the owner is a manager. "Diversity" refers to whether the management subject is separated, and if the owner is also the constructor or the manager. "Construction" is whether the management entity is connected and managed by the management entity and can be evaluated in "Good", "Middle", and "Bad" level. As a summary, even if the existing public rental housing in Korea can be separated into a skeleton and infill system, the result suggested that it has a limitation on response to residential demand. In addition, the paper was able to propose an improved plan to make the infill as a secondary operator.