• Title/Summary/Keyword: Entity-Relationship model

Search Result 98, Processing Time 0.04 seconds

ERD Representation using Auto-Generated Form and SQL (자동 생성 폼과 SQL을 이용한 ERD 표현)

  • Ra, Young-Gook
    • The Journal of the Korea Contents Association
    • /
    • v.9 no.5
    • /
    • pp.61-75
    • /
    • 2009
  • Generally, the development of the database application includes the requirement analysis phase of creating ERD (Entity Relationship Diagram) and process models, coding, and testing. From the above phases, the analysis phase is not most formalized. It is usually hard task because (1) customers don't know the details of the desired system; (2) developers can't with ease understand the business logic of the customers; (3) the outcomes of the analysis, which are ERD and process models, are not easy to understand to the customers. This paper propose that the executional forms, which are better to understand the systems, should be presented to the customers instead of the ERD. These forms should accept the data input so that customers can review the various aspects of the outcome models. The developers should be able to instantly implement the business logic and also should be able to visually demonstrate the logic in order to get the details of it. For this goal, the customer supplied business logic should be able to be implemented by the references between forms, actions, constraints from the perspective of the data flow. The customers try to execute the forms implementing the business logic and review their supplied logic find new necessary business logic of their own. Iterating these processes for the requirement analysis would result in the success of the analysis which is sufficiently detailed without conflicts.

A Study on the Data Modeling decreasing the Data Obesity (데이터 비만도를 개선한 데이터 모델링에 관한 연구)

  • Rhee, Hye Kyung;Kim, Hee Wan
    • Journal of Digital Convergence
    • /
    • v.11 no.11
    • /
    • pp.359-366
    • /
    • 2013
  • In this paper, we studied how the data obesity can affect in which the response speed of database gradually slows down. Our research is performed by analyzing how the game data infrastructure is well-formed. Although there are a variety of ways to evaluate to measure the level of infrastructure, we performed with real information system. We analyzed data obesity by comparing the entity-relationship models between the products of real game information system and newly modeled databases. We could find data obesity is over 60% among overall average of game information system. It shows that 45% higher than standard obesity which is 15%. In this paper, data redundancy rate after performing the procedure of the data modeling was 41% resulting in an improvement of 23% compared to 64% of an existing model.

Database Model for Korea Plant Name Index (데이터베이스 모델링 기법을 이용한 국가표준식물목록 전산화 연구)

  • Lee, You-Mi;Kim, Hui
    • Korean Journal of Plant Taxonomy
    • /
    • v.37 no.3
    • /
    • pp.309-321
    • /
    • 2007
  • Korea national arboretum has worked with the plant taxonomic society of Korea to make the first fully electronic floristic checklist in Korea. The result is an ever-expanding online plant name index containing scientifically authorative, up-to-date information on the approximately 7,000 taxa including cultivars. With 37 contributing taxonomists, KPNI is the largest collaborative research projects ever assembled in Korea. A comprehensive database model for the taxonomic data from literature and other sources is presented, which was devised for the Korea National Plant Index database project (KPNI). Gwangreung database model is based on an approach using entity-relationsip diagram. It encompasses taxa of all ranks, nothotaxa and hybrid formulae, cultivars, full synonymy, basionyms, Korean name, and other nomenclatural information. Ths paper presents an analysis of KPNI work processes and an overview how we are approaching the construction of Gwangreung databaese model. It can help the system engineers of other biological information systems to develop their database based on the accurate and integrative taxonomic database.

A Study on the FRBR Model Adaptation to Serials (FRBR 모형의 연속간행물 적용에 대한 연구)

  • Kim, hye-sun;Lee, hye-jin;Jeong, do-heon
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2007.11a
    • /
    • pp.449-453
    • /
    • 2007
  • The fundamentals of FRBR model are based on the International Cataloging Principles and the AACR 3. This study investigated the adaptability of the FRBR model to serials by reviewing how the entity, attribute and relationship concept in the FRBR are applied to serials. Also This study discussed problems associated with applications of the FRBR to serials cataloging.

  • PDF

A Study on the based on FRAD Conceptual Model based Authority Data Scheme for Academic Papers (FRAD 개념 모형 기반의 학술논문 전거데이터 구조에 관한 연구)

  • Lee, Seok-Hyoung;Kwak, Seung-Jin
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.45 no.3
    • /
    • pp.235-257
    • /
    • 2011
  • In this study, we proposed the FRAD concept model of authority data schema for author, organization and journal titles included in the academic papers. Academic information includes author names, affiliations, publishers, journals and conferences. They are used as access points, and there are multiple relationships among these entities. It is expected that the use of authority data for academic information based on FRAD conceptual model could improve more accurate retrieval of information, systematic management of academic information, and various forms of knowledge representation. In this study, our entity-relationship authority data will be linked to the document, and included the several properties and relationship to identify the object.

A Study on the Computer Simulation Model of the Management Organization (Computer에 의한 경영조직의 Simulation에 관한 연구)

  • 이근부
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.1 no.1
    • /
    • pp.49-53
    • /
    • 1978
  • Yet objective of this paper to spell out in detail the relationship between factors design techniques of data analysis and the design of simulation model of the management organization. Yet an organization is more than a collection of individuals. It is something more than the sum of its Parts: it exists as an entity with its own definable objectives. The management process comprise those activities or functions that managers must perform to effectively carry out this asizned role. However, now that O.R. and system approach has been generalized and the assembly system of hard ware or soft ware through computerization is being improved, the systematization of scientific organization is urgently needed. This paper is to set forth :he problem and solution which are most fit for the management organization in relation to computer. Procedure developed are : 1. Interpretation of the management organization. 2. Design of the computer simulation. 3. Application.

  • PDF

A Study on quality Management Performance of the strategic Supply Chain Management between Parts Enterprise and The Manufacturing Industry (부품업체와 제조업체간의 전략적인 공급사슬관리가 품질경영성과에 미치는 영향에 관한 연구)

  • Kim, Gye-Soo
    • Journal of Korean Society for Quality Management
    • /
    • v.28 no.4
    • /
    • pp.204-222
    • /
    • 2000
  • Supply Chain Management is a process-oriented concept, integrated approach to procuring, producing, and delivering products and services to customers. Supply Chain Management covers the management of material, information, and funds flows. A strategic supply chain management produces for value maker and the ultimate customer. One aim of this paper is to determine the effect of contract parameters on the quality of the end product of the supplier-producer chain. The supply chain management is viewed as a single entity rather fragmented. This research constructed model the relationship of supply chain management to quality management. The questionnaire were tested with survey of supplier's employee and the result were analyzed using SEM(Structural Equation Model). As a result, Quality performance positively depends on the communication, coordination, and process management between the supplier and the producer.

  • PDF

A Transformation from Entity-Relationship Model to XML Schema Model (개체-관계 모델에서 XML Schema로 변환)

  • 김창석;김형석;김의정;김대수
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2004.04a
    • /
    • pp.536-542
    • /
    • 2004
  • XML이 웹 상에서 문서 교환의 표준으로 자리잡고 있으며 그 수요가 나날이 증가하고 있다. 그에 따라 XML 데이터나 문서 구조를 모델링하는 XML Schema(W3C XML Schema Spec) 또한 수요가 증가하고 있다. 그러나 XML Schema는 다양한 자료형과 풍부한 표현력을 제공하지만 그 복잡성으로 인해 모델링하기가 어려운 단점이 있다. 본 논문에서는 관계형 데이터베이스 설계의 기본적인 도구인 개체-관계 모델을 이용하여 Ut Schema를 간단하게 생성하는 방법을 제시한다. 개체-관계 모델과 변환 될 XML Schema의 구조는 서로 일대일로 매핑되지 않아 직접 변환할 수는 없다. 그래서 몇 가지 알고리즘을 이용하여 개체-관계 모델을 계층적 구조모델로 변환을 한다. 이렇게 변환된 계층적 구조 모델을 이용하여 최종적으로 XML Schema를 생성한다. 여기서 제시한 알고리즘의 특징은 XML Schema의 중요한 특성들인 재사용성, 전역 및 로컬 기능 등을 가진 문서를 생성한다는 것이다.

  • PDF

System Dynamics Modeling for FDA Regulation Effect of Pharmaceutical Industry (제약산업에서 FDA규제 영향에 관한 시스템 다이내믹스 모델링: FDA규제가 R&D비용에 미치는 영향을 중심으로)

  • Ko, Seong-Pil;Choi, Jeong-Hwan;Nam, Dong-Wok;Lee, Jeong-Dong
    • Korean System Dynamics Review
    • /
    • v.13 no.4
    • /
    • pp.57-80
    • /
    • 2012
  • This research studies effect of FDA regulations in pharmaceutical industry on new drug development. System dynamics is implemented to demonstrate dynamic relationship between FDA regulations and R&D costs, firm's profits, sales. This research is focused on clinical trials of new medical entity process 50~60% portion of total development cost. Simulation results say that firm's profit is more sensitive to increasing the regulation than alleviating the regulation and effect of regulation policy make different result depending on the intensity of regulation and policy direction. Our simulation model provides the instrumental means for the policy makers and strategic decision in pharmaceutical industry.

  • PDF

A Study on Date Modeling for Object - Oriented Database Design (객체지향 데이터베이스 설계를 위한 데이터 모델링에 관한 연구)

  • Park, Won-Ok
    • Asia pacific journal of information systems
    • /
    • v.2 no.2
    • /
    • pp.103-120
    • /
    • 1992
  • Object-Oriented method is a rather difficult one, theories are different as many as they are, and can hardly be found well-applied examples of OOD. So, this paper deal with the history, the needs, the benefits, basic concept of object-oriented design methods, especially the designing procedure which covers from analyzing the requirements, designing the EER(extended entity relationship) model, transforming this model into relational schema, to OODB schema step. Major contributions can be identified; First, the proposed method will ensure that it improve the productivity, increase the software quality, and elevate the maintainability. Second, it provide the framework of how object-oriented schema is constructed for OODB design. Third, suggested realistic case study will enhance the better understanding of how the current business process will be applied to the OODB design step.

  • PDF