• Title/Summary/Keyword: entity relation db

Search Result 7, Processing Time 0.024 seconds

Electrical Fire Cause Diagnosis System based on Fuzzy Inference

  • Lee, Jong-Ho;Kim, Doo-Hyun
    • International Journal of Safety
    • /
    • v.4 no.2
    • /
    • pp.12-17
    • /
    • 2005
  • This paper aims at the development of an knowledge base for an electrical fire cause diagnosis system using the entity relation database. The relation database which provides a very simple but powerful way of representing data is widely used. The system focused on database construction and cause diagnosis can diagnose the causes of electrical fires easily and efficiently. In order to store and access to the information concerned with electrical fires, the key index items which identify electrical fires uniquely are derived out. The knowledge base consists of a case base which contains information from the past fires and a rule base with rules from expertise. To implement the knowledge base, Access 2000, one of DB development tools under windows environment and Visual Basic 6.0 are used as a DB building tool. For the reasoning technique, a mixed reasoning approach of a case based inference and a rule based inference has been adopted. Knowledge-based reasoning could present the cause of a newly occurred fire to be diagnosed by searching the knowledge base for reasonable matching. The knowledge-based database has not only searching functions with multiple attributes by using the collected various information(such as fire evidence, structure, and weather of a fire scene), but also more improved diagnosis functions which can be easily wed for the electrical fire cause diagnosis system.

Development of the Railroad Geotechnical Information Management System Using Web GIS (웹 GIS 기반 철도 지반정보 관리프로그램의 개발)

  • 황선근;이성혁;김현기;김정무
    • Journal of the Korean Society for Railway
    • /
    • v.7 no.1
    • /
    • pp.20-25
    • /
    • 2004
  • Railroad geotechnical information management system was developed by using Web GIS and DB in this study. The standardization of railroad geotechnical information is progressed by classifying three groups as like basic informations, vibration informations along railway lines and design drawings. The basic informations consisted of basic and dynamic properties of soils, geophysical exploration and seismic survey/exploration. And the specification for 'human exposure to whole-body vibration' was adopted to construct the vibration informations along railway lines. The informations as like drawings and photographs were saved by changing to graphic files in the standardization of design drawings. In the case of standardization of geographical information, the topographical maps(NGIS, 1:5000) were primarily used as digital maps. Another digital maps(KRRI, 1:5000) and their geographical DB based on NGI code system were added on this maps. The standardized informations were used to construct their database. And railroad information management system was developed using Entity-Relation(ER) model which had a good feasibility for expansion and transition to other system in designing stage of database. This system consisted of layer selection, search and analysis of geotechnical informations and Zeus DB was adopted for GIS operating and user interface. This system could be a good tool for saving, searching and analyzing the geotechnical and geophysical informations. These DB systems would offered the basic informations to plans, design and construction of railroad lines etc. in practical use.

Construction of Case-based System for the Cause Diagnosis of an Electrical Fires (전기화재 원인진단을 위한 사례기반 시스템 구축)

  • Lee, Jong-Ho;Kim, Doo-Hyun;Kim, Sung-Chul
    • Fire Science and Engineering
    • /
    • v.21 no.2 s.66
    • /
    • pp.42-47
    • /
    • 2007
  • This paper presents the development of a case-based system for an electrical fire cause diagnosis system using the entity relation database. The relation database which provides a very simple but powerful way of representing data is widely used. The system focused on database construction and cause diagnosis can diagnose the causes of electrical fires easily and efficiently. In order to store and access to the information concerned with electrical fires, the key index items which identify electrical fires uniquely are derived out. The case-based system consists of a case which contains information from the past fires. The case-based system could present the cause of a newly occurred fire to be diagnosed by searching the case-based database for reasonable matching. The case-based system has not only searching functions with multiple attributes by using the collected various information(such as fire evidence, structure, and weather of a fire scene) but also more improved diagnosis functions which can be easily used for the electrical fire cause diagnosis system.

A Study on Network Hierarchy Model which uses a Dynamic Segmentation Technique (동적 분할 기법을 이용한 네트워크 계층 모델에 관한 연구)

  • Joo, Yong-Jin;Lee, Yong-Ik;Moon, Kyung-Ky;Park, Soo-Hong
    • Spatial Information Research
    • /
    • v.14 no.2 s.37
    • /
    • pp.245-260
    • /
    • 2006
  • A practical use of the location information and user requirement are increased in a mobile environment which supports the portability. And Various service which GIS is related with a Spatial DB have been processed. Generally, logical relation of a traffic network which organizes the Road DB uses a basic node-link structure. In this way, Designed structure can not be flexible at various model apply and are not efficient with a database retrieval in a maintenance management side. In this research, We supplement with the problem of a existing network model and the limitation of the building through the design of a network model which uses dynamic segmentation. And we tried to implement efficient hierarchy model at the retrieval of the network and presentation. Designed model supports a stage presentation of various level and a hierarchy entity relation and We are expected to supplement a network spatial modelling function which the GIS has.

  • PDF

EVMS Database System Implementation for interworking of WBS & CBS based management in Construction Works (건설공사의 활동·내역 연동관리를 위한 기성관리운영시스템(EVMS) 데이터 모델링 및 구현)

  • Park, Hong-Tae;Lee, Bu-Hyung
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.12 no.6
    • /
    • pp.2851-2858
    • /
    • 2011
  • The schedule management in construction project have been performed independently by two method, WBS base management and CBS based management, However, the integrated management model is needed according to efficiency of construction project management and introduction of new EVMS system of KOREA government. For this purpose, interworking database system is designed through efficient modeling of WBS based management data and CBS based management data and relation establishment between entities in this paper. WBS based management DB consists of 4 entities and CBS based management DB consists of 3 entity and one of the 4 WBS DB entities is used to play interworking role between WBS and CBS, Also, attributes of all entities are well defined so that data consistency, integrity and newest are guaranteed. The designed interworking database model was realized using Nex-Pert Pro and the efficiency of data interworking was proved.

Develoment of Railroad Geotechnical Information Database (철도 지반정보 자료의 표준화 DB 개발)

  • Kim Jung-Moo;Kim Hyun-Ki;Lee Seong-Hyeok;Hwang Seon-Keun
    • Proceedings of the KSR Conference
    • /
    • 2003.05a
    • /
    • pp.388-392
    • /
    • 2003
  • In this study, various railroad geotechnical informations were standardized. The standardization was progressed by classifying the informations as basic properties, railroad vibrations and design plans. Basic informations included soil properties(27), dynamic property(1), geophysical prospecting(1), and elastic wave prospecting(4). Specification for 'human exposure to whole-body vibration' was used to construct the information of railroad vibration. And in the case of the information of design plan, the way to save by graphic files was chosen. Thus standardized informations examined their application by setting up database. Entity-Relation(E-R) model was used in the design of database and by this, the database system was constructed. This database system will be able to serve the performance enhancement of railroad system.

  • PDF

Database Schema Design for Integrated Missile Design and Optimization (유도무기 통합최적설계를 위한 데이터베이스 설계 연구)

  • Lee, Jae-Woo;Lee, Seung-Jin;Choi, Seok-Min;Cho, Guk-Hyun;Kim, Kwang-Sik;Lee, Jeong-Oog;Jung, Karp-Joo
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.21 no.6
    • /
    • pp.563-569
    • /
    • 2008
  • In this paper, the missile database system for the multidisciplinary design and optimization framework has been designed and investigated. The requirements of the missiles database are analyzed and the database design concept has been defined first. The data flow among the analysis disciplines is investigated and the Entity-Relation diagram is constructed to develop the database table and to define the database schema. The developed database system is integrated into the missile design framework to perform the store, search and management of the design data during the design and analysis of the missile development, hence the efficiency and validity of the database designed in this study has been demonstrated.