• 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.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.11 no.5
• /
• pp.11-17
• /
• 2011

In this paper, we propose ER_Modeler, which is a logical database design tool based on entity-relationship model. ER_Modeler provides the entity-relationship diagrams to be built graphically on windows and generates the graphs into the appropriate data definition language for creating relational database tables. Furthermore, ER_Modeler provides the import/export functions using XML to guarantee the interoperability with ERwin which is one of the most popular commercial products.

• 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.

• International conference on construction engineering and project management
• /
• 2015.10a
• /
• pp.693-694
• /
• 2015

While urban regeneration projects are currently under active execution in several old cities in Korea, there are few projects to improve the quality of life of rural communities. Considering the decline of the SOC system, deterioration of housing, and degeneration of economic feasibility, the purpose of this study is to provide solutions to realize an improved economic and social environment of rural communities through an integrated management system for traffic safety and water management systems. Therefore, this research used an Entity-Relationship Diagram to construct an integrated system for traffic safety and water management systems for Chungcheong rural communities. The ERD is prepared by depicting 7 relationships for 13 entities, including traffic accidents and agricultural products, and 26 attributes, including soil moisture and underflow storage. Consequently, it will be possible to set up a decision-making support system that can analyze and evaluate the regeneration index, technology, and management of the systems for Chungcheong rural communities, based on supplier and user perspectives

• 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.

• Proceedings of the Korea Society of Information Technology Applications Conference
• /
• 2002.11a
• /
• pp.163-170
• /
• 2002

해체 데이터베이스 구조 설계를 위하여 입력과 출력 항목 및 평가 대상 항목을 선정하였다. 해체 활동으로부터 발생되는 수많은 해체 정보들을 코드화하였다. 데이터베이스 구축에 사용되는 설계 도구들을 검토한 후 20 여가지 설계 도구들 중 범용적으로 사용되고 있는 모델링 도구를 이용하여 사용자 요구사항으로부터 도출된 주요 해체 정보들간의 관계를 ERD(Entity Relationship Diagram)를 사용하여 규명하였으며, DFD(Data Flow Diagram)를 이용하여 해체 DB 시스템의 프로세스 흐름을 파악하였다. 해체 데이터베이스 구현의 원할한 진행을 위해 프로토타입을 설계하였다.

• Proceedings of the Korea Society for Industrial Systems Conference
• /
• 2002.11a
• /
• pp.163-170
• /
• 2002

해체 데이터베이스 구조 설계를 위하여 입력과 출력 항목 및 평가 대상 항목을 선정하였다. 해체 활동으로부터 발생되는 수많은 해체 정보들을 코드화하였다. 데이터베이스 구축에 사용되는 설계 도구들을 검토한 후 20여가지 설계 도구들 중 범용적으로 사용되고 있는 모델링 도구를 이용하여 사용자 요구사항으로부터 도출된 주요 해체 정보들간의 관계를 ERD(Entity Relationship Diagram)를 사용하여 규명하였으며, DFD(Data Flow Diagram)를 이용하여 해체 DB 시스템의 프로세스 흐름을 파악하였다 해체 데이터베이스 구현의 원할 한 진행을 위해 프로토타입을 설계하였다.

• Journal of Korean Society of Disaster and Security
• /
• v.6 no.3
• /
• pp.35-42
• /
• 2013

The purpose of this research is to systematize safety management for practical application through analysis and review of several safety standards currently in force among the statutes and rules regarding various safety accidents. Accordingly, the safety standard systems of Japan, US, and Germany were examined and a KOSAM entity relationship diagram (ERD) was drawn based on the ontology system. The ERD consists of the safety standard scope, safety management statute, safety management standard, safety management subjects, causes of safety accidents, and safety management organization entities. Next, each entity was assigned a code and finally a KOSAM safety management condition search screen was designed based on the ERD. This research is expected to bring an overall improvement in safety standard management and operation through safety standard DB construction and the execution of safety management system development.

• IE interfaces
• /
• v.15 no.4
• /
• pp.391-400
• /
• 2002

The internet call systems using CTI(Computer Telephony Integration) functions are designed with system configuration, DFD(Data Flow Diagram) and ERD(Entity Relationship Diagram) in this paper. The internet call systems are constructed to cooperate with conventional CTI call center. The internet phone calls occurred from the web browser of customer can be connected throughout VoIP gateway and PBX to many counselors. The internet call systems can provide various services; customer information service, escorted browsing service, text chatting service, text sharing service, conference service, and statistical analysis service.

• Journal of Distribution Research
• /
• v.6 no.2
• /
• pp.91-108
• /
• 2002

While a lot of research has been done in the area of the B2C e-commerce, heavily on the Internet shopping, a study on the B2B e-commerce has not been improved enough to be competitive for its importance and practical use. We have studied to build an effective database, attempting to complement and further replace in the long term the off-line distribution channel which has yet to be fully evolve with respect to effectiveness and efficiency. For the building of the effective database, we have gathered information from the related institutions and characterized a fishery channel, and surveyed existing literatures and consumers for deriving factors affecting their purchase intentions and satisfactions. Based upon this survey we constructed the entity-relationship diagram(ERD) which possibly provided some perspectives for the future application. This study focuses on the improvement in the distributional efficiency not only minimizing the intra-organizational conflict and resistance but also maximizing the role function of each party of the organization.