• Title/Summary/Keyword: Entity-Relationship model

Search Result 96, Processing Time 0.028 seconds

ER2XML: An Implementation of XML Schema Generator based on the Entity-Relationship Model (ER2XML :개체-관계 모델을 기반으로한 XML Schema 생성기의 구현)

  • Kim Chang Suk;Son Dong-Cheul
    • The KIPS Transactions:PartD
    • /
    • v.12D no.1 s.97
    • /
    • pp.1-12
    • /
    • 2005
  • The XML is emerging as standard language for data exchange on the Web. Therefore a demand of XML Schema(W3C MLL Schema Spec.) that verifies XML document becomes increasing. However, XML Schema has a weak point for design because of its complication despiteof various data and abundant expressiveness. This paper shows a simple way of design for XML Schema using a fundamental means for database design, the Entity-Relationship model. The conversion from the Entity-Relationship model to XML Schema can not be directly on account of discordance between the two models. So we present some algorithms to generate XML Schema from the Entity-Relationship model. The algorithms produce XML Schema codes using a hierarchical view representation. An important objective of this automatic generation is to preserve XML Schema's characteristics such as reusability, global and local ability, ability of expansion and various type changes.

A Transformation Military Databases based on the Relational Data model into XML Databases (관계형 데이터 모델 기반 군사용 데이터베이스의 XML 데이터베이스로의 변환)

  • Kim, Chang-Seok;Kim, Eong-Su
    • Journal of National Security and Military Science
    • /
    • s.1
    • /
    • pp.269-310
    • /
    • 2003
  • AS Extensible Markup Language(XML) is emerging as the data format of the Internet era, there are increasing needs to efficiently transform between database and XML documents. In this paper, we propose a schema transformation method from relational database to XML database. To transform the schema, we represent input schema as Entity-Relationship diagram. Entity-Relationship model translator scans the input Entity-Relationship diagram using BFS (breadth First Search) and translates the diagram into hierarchical structure model. The XML Schema generator produces XML Scema code using the transformed hierarchical structure model. The proposed method has a merit that having reusability facility of XML Schema property in comparison with existing researches.

  • PDF

Research on the Process of Constructing Application Systems Using the E-R Model and an Automated Application Generator (E-R 모델과 자동생성기를 이용한 응용시스템의 구축 과정에 관한 연구)

  • Chung, Il-Choo
    • Journal of Information Technology Applications and Management
    • /
    • v.12 no.4
    • /
    • pp.133-155
    • /
    • 2005
  • 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 designer inputs the entity and relationship types, and attributes shown in the E-R model, and also the basic operations of the application system to the software generator. 3. The application generator produces database schema and link information between application programs, and then automatically generates a stereo-type application system. In order for the automated application generator to build the application system in a systematic way, four basic program generation rules have been suggested. A set of computer programs have been developed in order to show the applicability of the automated software generation process suggested in this paper. By following each rule with the generator, the designer can build an application in an efficient manner compared with traditional (manual programming) approaches. 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 is feasible.

  • PDF

Entity aspect-relationship model for knowlege representation (지식표현을 위한 객체 측면-관계성 모델)

  • 김일도;박도순;황종선
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 1991.10a
    • /
    • pp.285-292
    • /
    • 1991
  • 객체-관계성(ER:entity-relationship)모델을 이용한 지식표현모델은 실세계를 객체(entity)들 또는 객체들의 집합들 사이의 서로간에 관계성(relationship)으로 나타낸다. 그러나 고정된 측면에서 표현되기 때문에 하나의 객체를 여러가지 측면에서 관찰할 수 없다. 반면 객체-측면(EA:entity-aspect)모델은 객체노드와 측면노드의 두가지 형을 갖는 노드들로 구성되어 측면에 따라 서로 다른 지식을 표현 할 수 있으므로 하나의 객체를 여러가지 측면에서 관찰할 수 있고, 그 세부적 계층구조를 나타낼 수 있는 장점이 있으나 너무 계층성을 강조하며, 객체간의 관계성을 나타낼 수가 없어 계층구조 속에 포함되지 않은 객체는 지식으로 표현 할 수 없어 실세계의 다양한 지식을 표현하는데 부자연스럽다. 따라서 본 논문에서는 객체-관계성(ER)모델의 관계성과 객체-측면(EA)모델의 측면성을 통합하여 객체 측면-관계성(EAR)모델을 제시하고, 이 모델에서 객체간의 관계성을 하나의 객체로 간주함으로 IS-A측면에 의하여 하위레벨로 계승할 수 있음을 보였다.

  • PDF

Research on the Impact of Entities' Cooperation Ability of Emergency Entities

  • Ji, Feng;Min, Byung-Won
    • International Journal of Contents
    • /
    • v.18 no.1
    • /
    • pp.56-64
    • /
    • 2022
  • To improve the cooperation ability of emergency entities, in this research, the emergency activities model, skill contribution degree, entity-relationship strength, activity continuity, and emergency entity cooperation degree were defined. Emergency entity cooperation degree and emergency activity continuity table were constructed with emergency cases, emergency plans, and emergency drill plans, and factors were further excavated which affected them. In this paper, we focus on the factors which affect the cooperation ability of emergency entities, the relationship between the emergency cooperation ability and the number of cooperation, entity-relationship intensity, emergency activity frequency, and skill contribution of fire entities and medical entities were obtained. These data results are of great significance to decision-makers in formulating emergency rescue and emergency plans.

Comparison of Database Models for Developing a Pavement Performance Analysis System

  • Choi Jae-ho
    • Korean Journal of Construction Engineering and Management
    • /
    • v.5 no.4 s.20
    • /
    • 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.

A Generation from Entity-Relationship Model to XML Schema Model (개체-관계 모델에선 XML Schema의 생성)

  • Kim, Chang-Suk;Kim, Dae-Su;Son, Dong-Cheul
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.14 no.6
    • /
    • pp.667-673
    • /
    • 2004
  • The XML is emerging as standard language for data exchange on the Web. Therefore the demand of XML Schema(W3C XML Schema Spec.) that verifies XML document becomes increasing. However, XML Schema has a weak point for design because of its complication despite of various data and abundant expressiveness. This paper shows a simple way of design for XML Schema using a fundamental means for database design, the Entity-Relationship model. The conversion from the Entity-Relationship model to XML Schema can not be directly on account of discordance between the two models. So we present some algorithms to generate XML Schema from the Entity-Relationship model. The algorithms produce XML Schema codes using a hierarchical view representation. An important objective of this automatic generation is to preserve XML Schema's characteristics such as reusability, global and local ability, ability of expansion and various type changes.

An Experimental Research on the Design Characteristics and Performance of the Entity-Relationship Model (개체관계 모형의 설계 특성과 성과에 관한 실험적 연구)

  • 정일주
    • The Journal of Information Technology and Database
    • /
    • v.6 no.2
    • /
    • pp.45-57
    • /
    • 1999
  • This paper makes an attempt to find a systematic portion of the database design process, especially using the Entity-Relationship(E-R) model. Basically, we consider three aspects as a systematic portion of the database design process. They are, the strategy that a designer selects to design an E-R diagram, designer's cognitive style, and the knowledge and preference of the database designer. 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 a professional baseball system. A normative E-R diagram was constructed based upon 48 E-R diagrams produced during the experiment. The ANOVA process has been used to analyze the results. It has been found that there exist significant differences in query-answering capacity and the completeness of the E-R model among design methods. Individual differences in cognitive styles has not been found to be significantly related to the modeling performance.

  • PDF

Towards Effective Entity Extraction of Scientific Documents using Discriminative Linguistic Features

  • Hwang, Sangwon;Hong, Jang-Eui;Nam, Young-Kwang
    • KSII Transactions on Internet and Information Systems (TIIS)
    • /
    • v.13 no.3
    • /
    • pp.1639-1658
    • /
    • 2019
  • Named entity recognition (NER) is an important technique for improving the performance of data mining and big data analytics. In previous studies, NER systems have been employed to identify named-entities using statistical methods based on prior information or linguistic features; however, such methods are limited in that they are unable to recognize unregistered or unlearned objects. In this paper, a method is proposed to extract objects, such as technologies, theories, or person names, by analyzing the collocation relationship between certain words that simultaneously appear around specific words in the abstracts of academic journals. The method is executed as follows. First, the data is preprocessed using data cleaning and sentence detection to separate the text into single sentences. Then, part-of-speech (POS) tagging is applied to the individual sentences. After this, the appearance and collocation information of the other POS tags is analyzed, excluding the entity candidates, such as nouns. Finally, an entity recognition model is created based on analyzing and classifying the information in the sentences.

Enhancing Expressiveness of Conceptual Modeling for Bibliographic Relationships - A Reflection on the FRBR Entity-Relationship Model - (공통기술표현포맷에 기반한 다매체자료의 검색효율 향상에 관한 연구)

  • Choi, Yun-Seon;Renear, Allen
    • Journal of the Korean Society for information Management
    • /
    • v.23 no.4 s.62
    • /
    • pp.5-15
    • /
    • 2006
  • The Functional Requirements for Bibliographic Records (FRBR) is a 'conceptual model of the bibliographic universe' developed by the International Federation of Library Associations and Institutions (IFLA). Although some studies have suggested improvements in FRBR, and others explore alternative approaches, less attention has been paid to analyzing the internal coherence and consistency of the FRBR view as presented not only in the FRBR entity-relationship model and text of the FRBR document, but also in the related explanations and presentations of FRBR expositors. Our investigations have noted some interesting discrepancies between the general FRBR approach as presented in various expository documents and the specific account presented in the FRBR ER model and the FRBR document. We see that in one case these discrepancies can be easily remedied by adding additional modeling constructs and assertions, but in another case (the supposed 'inheritance' of attributes across the Group 1 entities), there is a substantial difficulty in maintaining a consistent model. We discuss several alternative approaches to enhancing the expressiveness of FRBR in order remedy this problem. We note that none is entirely satisfactory.