• 산업공학
• /
• 제16권spc호
• /
• pp.45-48
• /
• 2003

Entity-relationship modeling for designing relational database is a very complicated thinking process that requires extensive knowledge and experiences. It is very likely that designers make mistakes in this process. In order to minimize the mistakes, a systematic method to guide the thinking process is needed. In this research, an entity-relationship modeling system is developed, which resolves the whole process of information modeling, data modeling, and functional dependency relationship analysis into small and simple decision-making steps. Therefore, it can reduce the possibility of making decision errors and improve the efficiency of the modeling process. It's functionality and efficiency is verified through some modeling examples. It is expected that the modeling system can be commercialized, if some functions are added, such as detection, warning, and correction of decision errors, and educational help.

• 한국기록관리학회지
• /
• 제10권2호
• /
• pp.193-214
• /
• 2010

최근 메타데이터 표준의 국제적 흐름은 기록을 둘러싼 다양한 맥락정보를 개체로 설정하고 이들 각 개체 간의 다양한 관계를 보여주는 다중 개체 모형의 적용이다. 이에, 이 논문에서는 다중 개체 모형을 적용한 기록관리 메타데이터의 표준인 ISO 23081-2, 호주, 뉴질랜드, 호주의 뉴사우스웨일즈주, 퀸즈랜드주, 사우스오스트레일리 아주 표준의 특징을 비교 분석하였다. 분석은 1) 적용범위, 2) 개체수, 3) 개체 내 카테고리, 4) 요소 설계 방법을 중심으로 비교하고, 다중 개체에 있어서 가장 핵심인 관계(relationship) 개체가 어떻게 구현될 수 있는지, 실제 사례를 통해 살펴본다. 마지막으로 앞선 분석을 통해 다중 개체 모형을 적용하여 표준을 제정 할 때 고려해야 할 몇 가지 사항들을 정리해 본다.

• 산업기술연구
• /
• 제25권A호
• /
• pp.123-131
• /
• 2005

Semantic object model has widely been recognized as an alternative data modeling approach to entity-relationship model for database system design. In this study, we have presented a semantic object model for intermediary type shopping mall consisting of multiple buyers and sellers. Essential processes and information with regard to the customer management, product management, price estimation, product order etc. have been considered for this study. Upon careful examination and analysis of them, a detailed semantic objects and attributes have been drawn and structured into semantic object diagrams. The final objects were converted into an entity-relationship diagram so that intuitive comparison could be made for relational database design. The results in this study may form a conceptual framework for both academic concerns and more complicated system applications.

• 한국건설관리학회논문집
• /
• 제5권4호
• /
• 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.

• 정보처리학회논문지D
• /
• 제11D권3호
• /
• pp.553-562
• /
• 2004

본 논문에서는 데이터베이스 설계시 중요한 과정인 개념설계 단계에서 개체관계도(Entity Relationship Diagram)의 정보를 저장하는 ERD시소러스(Thesaurus)를 구축하고, 이러한 ERD시소러스를 기반으로 하는 뷰 통합 방법론을 제시하고자 한다. 제시된 방법론의 유용성을 입증하기 위하여, 적용사례에 대한 뷰 통합지원시스템의 프로토타입을 구축하였다. 적용결과, ERD시소러스 기반의 방법론이 기존의 뷰 통합 방법론보다 친밀도 분석, 의미충돌 해결, 유 통합과정에서 더 효과적임을 확인할 수 있었다. 따라서 이 방법론이 기존의 단편화된 스키마의 통합이나 대규모 데이터베이스 통합 설계시 유용하게 활용될 수 있을 것으로 기대된다.

• 반도체디스플레이기술학회지
• /
• 제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.

• 한국기계가공학회지
• /
• 제14권4호
• /
• pp.108-117
• /
• 2015

In this paper, as a previous step of software development, through an analysis step in the basic design process of the FPSO crane, ERD, which could help develop common understanding between its developer and the user, was introduced. From the flowchart of the design process, the overall work flow in its development was understood. Then, after the design process of the crane was divided into many entities, the attributes of each entity were defined and the relationships between the entities were established, followed by ERD creation through the use of IDEF1X notation. The results of the analysis can be readily understood even by users who lack of software knowledge, and then their change requirements can be immediately reflected in the developed system that requires modification.

• 한국콘텐츠학회논문지
• /
• 제9권5호
• /
• pp.61-75
• /
• 2009

통상적으로 데이터베이스 어플리케이션을 구현하는 과정은 ERD(Entity Relationship Diagram)와 프로세스 모델을 산출하는 분석 과정을 거쳐 코딩, 테스팅 (testing)으로 프로젝트를 완성한다. 이 과정에서 가장 정형화되지 못한 부분이 분석과정으로 (1) 고객이 자신이 원하는 시스템의 세부 사항까지 알지 못한다; (2) 고객의 비즈니스 (business) 로직을 개발자가 이해하기 어렵다; (3) 분석 산출물인 ERD와 프로세스 모델을 고객이 이해하기 어렵다 등의 이유 때문이다. 본 논문은 분석 과정을 효과적으로 수행하기 위하여 가장 중요한 분석 산출물인 ERD (Entity Relationship Diagram)를 고객이 이해하기 쉬운 폼 형태로 제시할 것을 제안한다. 이 폼들은 데이터를 입력할 수 있게 하여 고객이 입체적으로 모델을 평가할 수 있어야 하며 분석 과정에서 발견되는 비즈니스 로직을 즉각 구현하여 고객이 이 폼들을 실행하면서 구현되는 로직을 평가, 이해하여 비즈니스 로직을 세부적으로 제공할 수 있게 하여야 한다. 이 목적을 위하여 고객이 제공하는 비즈니스 로직을 폼과 폼끼리의 참조를 포함하는 데이터 플로우(data flow) 형태로 우리의 폼 시스템에서 구현할 수 있어야 한다. 고객은 추상적인 ERD 대신에 데이터를 포함하고, 데이터 플로우 로직이 구현되어 있는 폼들을 실행 시켜 보면서 자신이 제공한 비즈니스 로직을 검토할 수 있으며 새로운 로직을 발견할 수 있다. 이러한 과정을 반복적으로 수행하면서 고객과 개발자는 충분히 세부적이고 모순이 없는 분석 과정을 성공적으로 수행할 수 있게 된다.

• 한국경영과학회지
• /
• 제21권3호
• /
• pp.175-195
• /
• 1996

In conventional analysis methods, data and process are loosely coupled for building information systems. Several object oriented approaches have been proposed to integrate data and process. However, object oriented analysis requires a radical paradigm and thus system analysts find difficulties in generating object models direcctly from end users. To alleviate these difficulties, this paper proposes a methodology for deriving an object model by using structured analysis results. Objects are obtianed primarily from entities in Entity-Relationship Diagram. Methods are obtained through the analysis of the relationship between processes and data stores in Data Flow Diagram Methods are assigned to the objects by using object/process matrices. A real-life case is illustrated to demonstrate the usefulness of the methodology.

• 한국실내디자인학회논문집
• /
• 제13권6호
• /
• pp.48-56
• /
• 2004

The Affordance, discussed in the theory of ecological perception of environmental psychology, is the concept of perception that deals with inter-relationship between environment and human. It is a theory seeking for gradual evolution, with the change of user experience behavior and the space, by getting feed-backs from the analysis of perception of characteristics of 3-dimensional space and the user as moving entity. Although there has been many attempts to define the Affordance and apply its concept to the architecture, now there's a need to identify the Affordance in the real architectural space, represent Affordance of space and the user inter-relationship in the architecture and apply its design specifically, Thus, the purpose of this study is to present the methodology of applying Affordance in architectural space design by identifying the Affordance of space concept of human experience behavior in the architectural space and analyze its recognition process.