데이타베이스 논리적모델의 설계에 관한 연구

鄭逸周 홍익대학교 산업기술연구소 1999 産業技術 Vol.9 No.-

The Entity-Relationship(E-R) model has been considered as a useful tool for designing the logical database for the enterprise. This paper makes an attempt to find a more systematic portion of the database design process. Basically, we consider the process of designing the relational models through the use of the E-R model. This approach would provide the benefits of having more realistic database models. First, the relationship between the E-R model and the relational model has been established. Especially, the relationship between FD and entity and relationship types are important. The process of translating the E-R models into relational mode can be summarized into several rules. In designing the relational model, the cardinalities play an important role. Depending upon different types of cardinalities, different relations are required. Finally, the whole process of designing the relational model has been demonstrated starting from an E-R diagram. From this example it has been shown that the whole design process can be achieved in a systematic way with relatively simple steps.

E-R 모델을 이용한 소프트웨어의 자동생성

鄭逸周 홍익대학교 산업기술연구소 2003 産業技術 Vol.13 No.-

This paper makes an attempt to suggest a process of automatically generating application software based on the Entity-Relationship model. 1. The designer develops an E-R model of an real-world system. 2. The software generator automatically generates a stereo-type application system. 3. The generator produces database schema and link information between application programs. 4. The designer designs the user interface including menu, screen design and so on. Finally, the generator integrates all the elements of an application system. Five basic program generation rules, three extended rules and a database generation rule have been suggested. By following each rule with the generator, the designer can build an application with an extremely efficient manner compared with traditional approaches. A set of computer programs have been developed in order to show the applicability of the automated software generation process suggested in this paper. It has been demonstrated from the case study that the idea of applying an automated generator in systems development based upon the E-R model worked well.

소프트웨어 시스템 자동생성 방법론에 관한 연구

鄭逸周 홍익대학교 산업기술연구소 2001 産業技術 Vol.11 No.-

Increasing the productivity of the software development process has long been the goal of software engineering. The Entity-Relationship(E-R) model has been considered as a useful tool for designing the logical database for the enterprise. This paper makes an attempt to show a way of applying the E-R model in enhancing the capability of a CASE tool. Especially, we employ a software engineering tool called HYCASE for our purposes. The HYCASE system has been used in actual software development projects. Therefore the tool is very practical compared with many tools for limited scope of application. It has been found that the E-R model can play an important role in enhancing the automatic generation capability of HYCASE.

데이타베이스 설계 방법에 관한 연구

鄭逸周 홍익대학교 산업기술연구소 1997 産業技術 Vol.7 No.-

Since the Entity-Relationship (E-R) model was proposed in the database area, it has been considered as an important tool for desiging the logical database model for the enterprise. However, the problem of designing the E-R model has been process of designing the E-R model more closely, and to find a more systematic collection of information requirements of the users of the system. The database should be able to answer the various queries of the users. As a way of integration information requirements of the users in an organized manner, and thus creating the logical database which represents the global view of proposed. The QIM views that the database is an integration of the queries that the users pose on the database in order to perform their jobs properly. The QIM stats with a set of database queries and suggests a way of integrating them in order to arrive at the global view of the database. The method also suggests a step-by-step process of converting a set of database queries into a logical database structure. In doing so, the concepts of local and global E-R model are proposed. The process of creating the E-R model is essentially identical to combining the local E-R model into a global E-R model. It has been demonstrated that this method can be used to create a logical database structure in a systemetic way. The E-R model thus created can be used as a conceptual database in an organization.

객체지향 데이터베이스의 설계에 관한 연구

鄭逸周 홍익대학교 산업기술연구소 2000 産業技術 Vol.10 No.-

The Entity-Relationship(E-R) model has been considered as a useful tool for designing the logical database for the enterprise. Recently the object-oriented database has become more important in modleing complex real world. Therefore there is a need to implement the E-R model in the object-oriented environment. This paper makes an attempt to show a way of representing the E-R model in the object-oriented database environment. Especially, we employ the ODMG-93 standards and an OODBMS for our purposes. The ODMG standard has been considered as a major leading force behind the current expansion of the object-oriented database in the OODB field. We show how the E-R model can be implemented into an actual OODBMS. We use the VERSANT OODBMS in order to show the process. It has been found that the E-R model can be successfully represented in the objected-oriented environment. Especially, an expanded version of the E-R model, where the subtype semantic is added, has been found more useful in the object-oriented environment.

개체연관 모델의 설계 성과에 관한 연구

鄭逸周 홍익대학교 산업기술연구소 1998 産業技術 Vol.8 No.-

The Entity-Relationship(E-R) model has been considered as a useful tool for designing the logical database for the enterprise. This paper makes an attempt to find a more systematic portion of the database design process. Basically we consider three aspects as a systematic portion of the database design process. They are, first the strategy that a designer selects to design an E-R diagram, second, designer's cognitive style and finally the knowledge and preference that the diegner possesses about the reality to be represented by the E-R model. 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 the Korean professional baseball system. A normative E-R diagram was constructed based upon 360 query questions to the baseball database. ANOVA process has shown significant differences in query-answering capacity and the number of entity and relationship type. However, individual differences in cognitive styles has not been found to be significantly related to the E-R modeling performance.

농촌 정보화 문제에 대한 연구

鄭逸周 홍익대학교 경영연구소 1994 경영연구 Vol.19 No.-

객체지향 시스템을 이용한 개체연관 모델의 구현

鄭逸周 홍익대학교 동북아연구소 2006 企業經營硏究 Vol.3 No.-

The Entity-Relationship(E-R) model has been considered as a useful tool for designing the logical database for the enterprise. Recently the object-oriented database has become more important in modleing complex real world. Therefore there is a need to implement the E-R model in the object-oriented environment. This paper makes an attempt to show a way of representing the E-R model in the object-oriented database environment. Especially, we employ the ODMG 3.0 standards and one OODBMS for our purposes. The ODMG standard has been considered as a major leading force behind the current expansion of the object-oriented database in the field. We also show how the E-R model can be implemented actual OODBMS's. We use VERSANT to show the process. It has been found that the E-R model can be successfully represented in the objected-oriented language. Especially, an expanded version of the E-R model, where the subtype semantic is added, has been found more useful in the object-oriented environment.

한국의 정보화 전략 수립에 관한 연구

鄭逸周 홍익대학교 산업기술연구소 1996 産業技術 Vol.6 No.-

韓國 塗料産業의 實狀과 代理店 經營의 問題點 : 他社와 ㅂ社의 經營政策 比較

鄭日柱 건국대학교 경영대학원 1992 論文集 Vol.5 No.-