• 제목/요약/키워드: Conceptual Data Modeling

검색결과 178건 처리시간 0.022초

온톨로지와 개체관계 모델의 상호운용성에 대한 연구 (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.

IDEF0와 개념적 설계를 이용한 물류 CALS/EC 구축 방안 연구 (An implementation methodology for CALS/EC system using IDEF0 and conceptual design in logistics industry)

  • 장기진;김성희
    • 한국전자거래학회지
    • /
    • 제4권1호
    • /
    • pp.37-58
    • /
    • 1999
  • In this paper, we suggest the system analysis method that links IDEF0 and conceptual analysis. Based on the method, we propose the implementation methodology that can be used to build CALS/EC systems in logistics industry. This paper presents data characteristic derived using ICAM DEFinition(IDEF0) and conceptual data modeling. Modeling methodology has been widely used for analysis and design of an enterprise information system. Further IDEF has been considered appropriate for developing functional and database models for the logistics environment.

  • PDF

개념적 데이터 모델링과 정보검색 시스템 디자인 (Conceptual Data Modeling and Information Retrieval System Design)

  • 오삼균
    • 한국문헌정보학회지
    • /
    • 제33권4호
    • /
    • pp.133-156
    • /
    • 1999
  • 이 논문의 목적은 개념적인 데이터 모델링이 기존의 정보 검색(IR) 시스템을 어떤 식으로 보다 향상시킬 수 있는지를 보여주는 것이다. 개념적인 데이터베이스 디자인은 1)개체들간의 관계에 기반하여 새로운 지식을 발견해 내는 데이터 마이닝 능력과 2)기존의 개별적으로 분리된 데이터베이스를 하나의 정보검색 시스템 안으로의 결합을 위해 사용된다 (예: ISI 인용, 시소러스, 서지 데이터베이스를 하나의 정보검색 시스템 안에 결집시킴). 더 나아가서, 개념적인 모델링은 수정을 용이하게 하므로, 새로운 이용자의 요구가 가미될 때마다, 개념적인 데이터 모델링에 기반한 정보검색 시스템을 수정하는 것은 기존의 정보검색 시스템 상에서보다 훨씬 수월해질 수 있다. 보다 향상된 개체-관계(Entity-Relationship) 모델이 이 논문에서 다룬 정보검색 데이터의 개념적 스키마를 개발하는데 사용되었다.

  • PDF

Conceptual Data Modeling: Entity-Relationship Models as Thinging Machines

  • Al-Fedaghi, Sabah
    • International Journal of Computer Science & Network Security
    • /
    • 제21권9호
    • /
    • pp.247-260
    • /
    • 2021
  • Data modeling is a process of developing a model to design and develop a data system that supports an organization's various business processes. A conceptual data model represents a technology-independent specification of structure of data to be stored within a database. The model aims to provide richer expressiveness and incorporate a set of semantics to (a) support the design, control, and integrity parts of the data stored in data management structures and (b) coordinate the viewing of connections and ideas on a database. The described structure of the data is often represented in an entity–relationship (ER) model, which was one of the first data-modeling techniques and is likely to continue to be a popular way of characterizing entity classes, attributes, and relationships. This paper attempts to examine the basic ER modeling notions in order to analyze the concepts to which they refer as well as ways to represent them. In such a mission, we apply a new modeling methodology (thinging machine; TM) to ER in terms of its fundamental building constructs, representation entities, relationships, and attributes. The goal of this venture is to further the understanding of data models and enrich their semantics. Three specific contributions to modeling in this context are incorporated: (a) using the TM model's five generic actions to inject processing in the ER structure; (b) relating the single ontological element of TM modeling (i.e., a thing/machine or thimac) to ER entities and relationships; and (c) proposing a high-level integrated, extended ER model that includes structural and time-oriented notions (e.g., events or behavior).

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.

모델베이스 설계를 위한 개념적 모델링 도구에 관한 연구 (A Conceptual Modeling Tools for the Model Base Design)

  • 정대율
    • 한국정보시스템학회지:정보시스템연구
    • /
    • 제7권1호
    • /
    • pp.181-208
    • /
    • 1998
  • In many literatures of model management, various schemes for representing model base schema have proposed. Ultimately, the goal is to arrive at a set of mutually supportive and synergistic methodologies and tools for the modeling problem domain and model base design. This paper focus on how best to structure and represent conceptual model of problem domain and schema of model base. Semantic concepts and modeling constructs are valuable conceptual tools for understanding the structural relationships and constraints involved in an model management environment. To this end, we reviewed the model management literature, and analyzed the constructs of modeling tools of data model management graph-based approach. Although they have good tools but most of them are not enough for the representation of structural relationships and constraints. So we wanted more powerful tools which can represent diverse constructs in a decision support modeling and model base schema design. For the design of a model base, we developed object modeling framework which uses Object Modeling Techniques (OMT). In Object Modeling Framework, model base schema are classified into conceptual schema, logical schema, and physical schema. The conceptual schema represents the user's view of problem domain, and the logical schema represents a model formatted by a particular modeling language. The schema design, this paper proposes an extension of Object Model to overcome some of the limitations exhibited by the OMT. The proposed tool, Extended Object Model(EOM) have diverse constructs for the representation of decision support problem domain and conceptual model base schema.

  • PDF

More Than 40 Percent of Data Unnecessarily Redundant in Corporate Databases

  • Moon, Jenghyearn
    • International Journal of Advanced Culture Technology
    • /
    • 제9권4호
    • /
    • pp.345-354
    • /
    • 2021
  • Data quality issue in information systems is analyzed with focus on conceptual data modeling. Extensive investigation through triangulation of case studies is attempted to find how much extent inappropriate data modeling practices exercised in real workplace environment. It is revealed that more than 40 percent of data adversely contributed to unnecessary data redundancy, i.e., the level of data obesity is over 40 percent. Another contribution of this paper lies in excavation of all the categories of inappropriate data modeling practices, which has been previously only partially uncovered in the literature. New findings in this paper prove that the extent of inappropriate modeling is more serious that previously reported.

Conceptual Data Modeling on the KRR-1&2 Decommissioning Database

  • Park, Hee-Seoung;Park, Seung-Kook;Lee, Kune-Woo;Park, Jin-Ho
    • Nuclear Engineering and Technology
    • /
    • 제34권6호
    • /
    • pp.610-618
    • /
    • 2002
  • A study of the conceptual data modeling to realize the decommissioning database on the HRR-1&2 was carried out. In this study, the current state of the abroad decommissioning database was investigated to make a reference of the database. A scope of the construction of decommissioning database has been set up based on user requirements. Then, a theory of the database construction was established and a scheme on the decommissioning information was classified . The facility information, work information, radioactive waste information, and radiological information dealing with the decommissioning database were extracted through interviews with an expert group and also decided upon the system configuration of the decommissioning database. A code which is composed of 17 bit was produced considering the construction, scheme and information. The results of the conceptual data modeling and the classification scheme will be used as basic data to create a prototype design of the decommissioning database.

연관규칙 마이닝을 활용한 개념적 데이터베이스 설계 자동화 기법 (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.

연구개발 형상관리 자동화체계에 대한 개념적 데이터모델링 (Conceptual Data Modeling of Integrated Information System for Research & Development Configuration Management)

  • 김인주
    • 한국국방경영분석학회지
    • /
    • 제25권1호
    • /
    • pp.87-106
    • /
    • 1999
  • There are many technical datum in related with design, test & evaluation and logistic support which will be exchanged between geographically isolated units and heterogeneous hardwares & softwares in developing and operating the weapon systems. The paper proposes the conceptual database schema to establish configuration management information systems in which these datum can be automatically interchanged, tracked, audited and status-accounted without errors under the various environments. The paper investigates how to identify and classify the data in accordance with document identification, task analysis, system development, logistic support, system test & evaluation and data management. Furthermore, the investigation includes drawing the subject areas and modeling the conceptual database schema to explain the relationships between these datum. Thus, the paper results in the conceptual framework and data models of configuration management information systems, while additional customization efforts be required in applying the models to a specific weapon systems R&D.

  • PDF