• Title/Summary/Keyword: E-R Schema Design

Search Result 6, Processing Time 0.026 seconds

A Semantic Classification Model for e-Catalogs

  • Kim, Dong-Kyu;Lee, Sang-Goo;Chun, Jong-Hoon
    • Proceedings of the CALSEC Conference
    • /
    • 2004.02a
    • /
    • pp.302-309
    • /
    • 2004
  • ·Catalogs -information about products and services -Contents + Classification Schema + Operational Issues ·What do we do with them? -[Schulten, et a;, 2001] ‥Narrow down search for complete set of applicable products ‥Comprehend individual description to the precision needed -Support other applications that use product information ‥SCM, ERP, e-Procurement, etc. ·Catalog Management System -Design, storage, navigation & retrieval, transformation, communication, publication(omitted)

  • PDF

Automated Generation of Software Systems in Systems Construction (시스템 구축 과정에서 소프트웨어 자동생성 도구의 적용)

  • 정일주
    • Journal of Information Technology Application
    • /
    • v.3 no.4
    • /
    • pp.63-92
    • /
    • 2001
  • This paper makes an attempt to look at the process of automatically generating an application software system based on the Entity-Relationship (E-R) model. Basically, the process consists of five steps as follows: First, the designer develops an E-R model of an real-world system. Second, the software generator automatically generates a stereo-type application system. Third, the generator produces database schema and link information between application programs. Fourth, the designer designs the user interface including menu, screen design and so on. Finally, the generator completes the process integrating 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 case study has been included 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.

  • PDF

Transforming an Entity - Relationship Model into an Object - Oriented Database Model Depending on the Role of Relationship (관계 역할에 따른 개체 - 관계 모델의 객체지향 데이타베이스 모델로 변환)

  • Kim, Sam-Nam;Lee, Hong-Ro;Ryu, Keun-Ho
    • The Transactions of the Korea Information Processing Society
    • /
    • v.4 no.7
    • /
    • pp.1665-1680
    • /
    • 1997
  • The Entity-Relationship (E-R) model is widely used not only to increase understanding between user and designer, but also to model the relationship of real world data appropriately when designing database system in many application areas. It should be then transformed into an Object-Oriented database model which gives good merits to represent and manipulate data efficiently. Therefore, a method of transforming an E-R model into an Object-Oriented database model should be studied, but without losing any semantics of concept for the E-R model. This paper not only deals with transformation rules taking as input the elements of E-R model and delivering the elements of an Object-Oriented database model, but also improves the concept of generalization and aggregation inheritance. The paper also presents a method of transformation of relationship depending on these rules. The proposed method that obtains Object-Oriented database schema from an E-R model with preserving the properties of the E-R model is shown with examples. The method presented is able to be used to the logical database design.

  • PDF

Implementing Database for Designing Super High Temperature Vacuum Furnace (초고온 진공로 설계를 위한 데이터베이스 구축)

  • Kim, Jong-Hwa;Do, Sang-Yun;Lee, Jae-U;Jeong, Gap-Ju
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 2004.05a
    • /
    • pp.273-276
    • /
    • 2004
  • Multidisciplinary Design Optimization (MDO) is an individual and parallel design framework applied in designing large and complex systems. for successful implementation of MDO framework it is essential to manage data in efficient and integrated manner. In this study, we present a case study to implement database to support designing super high temperature vacuum furnace with MDO technology. For that purpose we first extract required data based on the analysis of design process and then data flows between different programs are analyzed. Finally an E-R diagram is presented to design database schema.

  • PDF

A Service Framework for Supporting XML-based National Research and Development Report Contents (XML 기반 국가연구개발보고서 콘텐츠 서비스의 프레임워크 설계)

  • Shon, Ho-Sun;Lee, Jong-Yun
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.12 no.1
    • /
    • pp.427-435
    • /
    • 2011
  • The information management system for the national R&D reports on the level of each government department have been operated in order to have special affiliated organizations collect detailed information, construct databases for R&D reports, and operate their information system; thus, the current classification system for the R&D reports on the governmental level is insufficient. Also, each department requires to prepare a standardized electronic original text service system since mutually different electronic original text services have been provided. therefore, this paper sets up the following research goals and detailed research contents. The goals of this study are to establish methods to standardize the forms of national R&D reports and suggest the framework for XML-based national R&D reports services by analyzing the problems in the forms of previous national R&D reports services. As detailed research contents, first, Identify the current R&D electronic original reports services by each government department. Second, this paper analyzed primary overseas science technology information service systems related with national research and development reports and related database schemata. this paper proposed the XML-based national R&D reports service framework through analyzing the problems in the framework of the existing national R&D reports service system and also established and suggested the methods to provide database schema design and report portal services. Lastly, it is expected that this paper will have academic contribution to enhancing R&D investment efficiency by utilizing collaboratively the information and resources related with national R&D through establishing the general information management system for national-dimension R&D reports and also managing science technology information efficiently and developing a user-centered integrated information system.

Transforming an Entity-Relationship Model into a Temporal Object Oriented Model Based on Object Versioning (객체 버전화를 중심으로 시간지원 개체-관계 모델의 시간지원 객체 지향 모델로 변환)

  • 이홍로
    • Journal of Internet Computing and Services
    • /
    • v.2 no.2
    • /
    • pp.71-93
    • /
    • 2001
  • Commonly to design a database system. a conceptual database has to be designed and then it is transformed into a logical database schema prior to building a target database system. This paper proposes a method which transforms a Temporal Entity-Relationship Model(TERM) into a Temporal Object-Oriented Model(TOOM) to build an efficient database schema. I formalize the time concept in view of object versioning and specify the constraints required during transformation procedure. The proposed transformation method contributes to getting the logical temporal data from the conceptual temporal events Without any loss of semantics, Compared to other approaches of supporting various properties, this approach is more general and efficient because it is the semantically seamless transformation method by using the orthogonality of types of objects, semantics of relationships and constraints over roles.

  • PDF