• Title/Summary/Keyword: relationship entity

Search Result 215, Processing Time 0.029 seconds

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

A Methodology for View Integration Using ERD Thesaurus (ERD시소러스를 이용한 뷰 통합 방법론)

  • Lee, Won-Jo;Koh, Jae-Jin;Jang, Gil-Sang
    • The KIPS Transactions:PartD
    • /
    • v.11D no.3
    • /
    • pp.553-562
    • /
    • 2004
  • This paper constructs ERD thesaurus that is storing information about Entity Relationship Diagram(ERD), and proposes an ERD thesaurus-based methodology for view integration in an important conceptual design step in designing databases. To show the usefulness of proposed methodology, the prototype for view integration support system is implemented for the applied case. As a result, ERD thesaurus-based methodology is more effective than the existing methodologies for view Integration in the aspects of affinity analysis, semantic conflicts resolution, and view Integration processes. Therefore, our methodology is expected to be utilized in integrating the existing fragmented schema or designing a large database integration.

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
    • /
    • v.28 no.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.

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 Ancient Greek Physical Education Spirit

  • Han, Do Ryung
    • Journal of the Korea Society of Computer and Information
    • /
    • v.22 no.4
    • /
    • pp.99-105
    • /
    • 2017
  • Plato and Aristotle examined what the true spirit of physical education is and what kind of relationship it is, from the perspective of dividing into two parts of the body and mind. And the relationship between human body and mind, knowledge and behavior. Plato and Aristotle examined the harmonious combination of body and mind and what is the desirable relationship setting. In Plato's soul and body in philosophical centered ideological aspect, human education center emphasizes poetry education, but physical education is recognized as essential education for human education. Plato's body contour emphasizes the harmony of soul and body, not the superiority of the body to the mind. In Plato's education room, physical education should be preceded and then mental education should be done. I thought that there could be no independent souls without bodies. It is not an independent entity but a unified entity. Because there is a body, there is a soul. There is a soul, so a body exists. Aristotle thought that the body was more important than Plato, and that the body should be preceded by the soul.

An Experimental Research on the Design Characteristics and Performance of the Entity-Relationship Model (개체관계 모형의 설계 특성과 성과에 관한 실험적 연구)

  • 정일주
    • The Journal of Information Technology and Database
    • /
    • v.6 no.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.

  • PDF

Comparison of Database Models for Developing a Pavement Performance Analysis System

  • Choi Jae-ho
    • Korean Journal of Construction Engineering and Management
    • /
    • v.5 no.4 s.20
    • /
    • pp.79-86
    • /
    • 2004
  • One of the most difficult tasks in pavement management information systems is establishing the links between performance measures of a structure and the design and construction inputs. In-situ pavement performance can be considered a response variable to many project input variables, such as design, construction, and traffic loading effects. If we are to fully understand the component of pavement performance and specify the inputs through design and construction specifications to achieve that performance we must develop quantitative relationship between input and response variables through a scientific, fully integrated Pavement Performance Analysis System (PPAS). Hence, the objective of this study is to design a database model required for developing an effective database template that will allow analysis of pavement performance measures based on design and construction information linked by location. In order to select the most appropriate database model, a conceptual database model (Entity Relationship Model) and dimensional model, which is believed to be the most effective modeling technique for data warehouse project, are designed and compared. It is believed that other state highway agencies could adopt the proposed design strategy for implementing a PPAS at the discretion of the state highway agencies.

Entity Matching for Vision-Based Tracking of Construction Workers Using Epipolar Geometry (영상 내 건설인력 위치 추적을 위한 등극선 기하학 기반의 개체 매칭 기법)

  • Lee, Yong-Joo;Kim, Do-Wan;Park, Man-Woo
    • Journal of KIBIM
    • /
    • v.5 no.2
    • /
    • pp.46-54
    • /
    • 2015
  • Vision-based tracking has been proposed as a means to efficiently track a large number of construction resources operating in a congested site. In order to obtain 3D coordinates of an object, it is necessary to employ stereo-vision theories. Detecting and tracking of multiple objects require an entity matching process that finds corresponding pairs of detected entities across the two camera views. This paper proposes an efficient way of entity matching for tracking of construction workers. The proposed method basically uses epipolar geometry which represents the relationship between the two fixed cameras. Each pixel coordinate in a camera view is projected onto the other camera view as an epipolar line. The proposed method finds the matching pair of a worker entity by comparing the proximity of the all detected entities in the other view to the epipolar line. Experimental results demonstrate its suitability for automated entity matching for 3D vision-based tracking of construction workers.

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.