• Title/Summary/Keyword: 개체관계모델

Search Result 171, Processing Time 0.02 seconds

An Algorithm for Finding a Relationship Between Entities: Semi-Automated Schema Integration Approach (엔티티 간의 관계명을 생성하는 알고리즘: 반자동화된 스키마 통합)

  • Kim, Yongchan;Park, Jinsoo;Suh, Jihae
    • Journal of Intelligence and Information Systems
    • /
    • v.24 no.3
    • /
    • pp.243-262
    • /
    • 2018
  • Database schema integration is a significant issue in information systems. Because schema integration is a time-consuming and labor-intensive task, many studies have attempted to automate it. Researchers typically use XML as the source schema and leave much of the work to be done through DBA intervention, e.g., there are various naming conflicts related to relationship names in schema integration. In the past, the DBA had to intervene to resolve the naming-conflict name. In this paper, we introduce an algorithm that automatically generates relationship names to resolve relationship name conflicts that occur during schema integration. This algorithm is based on an Internet collocation and English sentence example dictionary. The relationship between the two entities is generated by analyzing examples extracted based on dictionary data through natural language processing. By building a semi-automated schema integration system and testing this algorithm, we found that it showed about 90% accuracy. Using this algorithm, we can resolve the problems related to naming conflicts that occur at schema integration automatically without DBA intervention.

A Study on the Agent Based Infection Prediction Model Using Space Big Data -focusing on MERS-CoV incident in Seoul- (공간 빅데이터를 활용한 행위자 기반 전염병 확산 예측 모형 구축에 관한 연구 -서울특별시 메르스 사태를 중심으로-)

  • JEON, Sang-Eun;SHIN, Dong-Bin
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.21 no.2
    • /
    • pp.94-106
    • /
    • 2018
  • The epidemiological model is useful for creating simulation and associated preventive measures for disease spread, and provides a detailed understanding of the spread of disease space through contact with individuals. In this study, propose an agent-based spatial model(ABM) integrated with spatial big data to simulate the spread of MERS-CoV infections in real time as a result of the interaction between individuals in space. The model described direct contact between individuals and hospitals, taking into account three factors : population, time, and space. The dynamic relationship of the population was based on the MERS-CoV case in Seoul Metropolitan Government in 2015. The model was used to predict the occurrence of MERS, compare the actual spread of MERS with the results of this model by time series, and verify the validity of the model by applying various scenarios. Testing various preventive measures using the measures proposed to select a quarantine strategy in the event of MERS-CoV outbreaks is expected to play an important role in controlling the spread of MERS-CoV.

Ecosystem Diagnosis and Evaluations Using Various Stream Ecosystem Models (다양한 하천생태모델을 이용한 생태계 진단 및 평가)

  • Kim, Ja-Hyun;Lee, Eui-Haeng;An, Kwang-Guk
    • Korean Journal of Ecology and Environment
    • /
    • v.40 no.3
    • /
    • pp.370-378
    • /
    • 2007
  • The objective of this research was to diagnose integrative ecological health in Bansuk Stream, one of the tributaries of Gap Stream, using the fish assemblage during July 2006${\sim}$April 2006. For this research, we selected six sampling sites and applied some approaches such as the Index of Biological Integrity (IBI), Qualitative Habitat Evaluation Index (QHEI), and necropsy-based Health Assessment Index (HAI). The stream health condition, based on the IBI values, averaged 24 (n= 18, range: $10{\sim}46$), indicating "poor${\sim}$fair" condition according to the criteria of US EPA (1993). Physical habitat condition, based on the QHEI, averaged 116 (n=6, range: $77{\sim}139$), indicating "fair${\sim}$good" condition. Values of IBI were more correlated with 3 metrics of instream cover ($M_1$, r=0.553, p=0.017, n=18), flow/velocity ($M_3$, r=0.627, p=0.005, n=18), and riffes/bends ($M_7$, r=0.631, p=0.005, n=18) than other metrics. Value of HAI in the control was zero (i.e., excellent condition), while the values in the T1 and T2 treatments were 5 (range: 0${\sim}$30) and 50 (range: 40${\sim}$80), respectively. The maximum values of IBI (46) were coincided with zero of HAI. Thus, these approaches seem to be a good tool for a diagnosis and evaluations of stream ecosystem health.

A Study on Optimization Model of Time-Cost Trade-off Analysisusing Particle Swarm Optimization (Particle Swarm Optimization을 이용한 공기-비용 절충관계 최적화 모델에 관한 연구)

  • Park, U-Yeol;An, Sung-Hoon
    • Journal of the Korea Institute of Building Construction
    • /
    • v.8 no.6
    • /
    • pp.91-98
    • /
    • 2008
  • It is time-consuming and difficulty to solve the time-cost trade-off problems, as there are trade-offs between time and cost to complete the activities in construction projects and this problems do not have unique solutions. Typically, heuristic methods, mathematical models and GA models has been used to solve this problems. As heuristic methods and mathematical models are have weakness in solving the time-cost trade-off problems, GA based model has been studied widely in recent. This paper suggests the time-cost trade-off optimization algorithm using particle swarm optimization. The traditional particle swarm optimization model is modified to generate optimal tradeoffs among construction time and cost efficiently. An application example is analyzed to illustrate the use of the suggested algorithm and demonstrate its capabilities in generating optimal tradeoffs among construction time and cost. Future applications of the model are suggested in the conclusion.

Semantic Object Modeling for Shopping Mall Database Design (쇼핑몰 데이터베이스 설계를 위한 의미객체 모델링)

  • Jeon, Tae-Bo;Kim, Ki-Dong;Oh, Jun-Hyung
    • Journal of Industrial Technology
    • /
    • v.25 no.A
    • /
    • pp.123-131
    • /
    • 2005
  • Semantic object model has widely been recognized as an alternative data modeling approach to entity-relationship model for database system design. In this study, we have presented a semantic object model for intermediary type shopping mall consisting of multiple buyers and sellers. Essential processes and information with regard to the customer management, product management, price estimation, product order etc. have been considered for this study. Upon careful examination and analysis of them, a detailed semantic objects and attributes have been drawn and structured into semantic object diagrams. The final objects were converted into an entity-relationship diagram so that intuitive comparison could be made for relational database design. The results in this study may form a conceptual framework for both academic concerns and more complicated system applications.

  • PDF

Systematic Evaluation of Strategic Coalition in the IPD Game with Multi-agents (다중에이전트를 이용한 IPD 게임에서 전략적 연합의 체계적 성능 평가)

  • Yang, Seung-Ryong;Cho, Sung-Bae
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2002.11a
    • /
    • pp.315-318
    • /
    • 2002
  • 반복적 죄수의 딜레마 게임은 사회적 상호작용, 경제활동, 국제관계 등 다양한 현상들을 모델링하기 위한 하나의 방법이다. Axelrod가 이 게임을 제안한 이래, 많은 학자들이 다양한 방법으로 연구를 진행해 왔으나 대부분은 게임자 개인 전략이나 이득함수의 개선에 중점을 두었다. 본 논문에서는 죄수의 딜레마 게임에서 다양한 개체 선택방법과 의사결정 방법을 이용한 전략적 연합을 적용함으로써 일반화 성능을 높이는 결과를 도출하였다. 전략적 연합은 결합 조건이 만족할 경우 자율적으로 형성될 수 있으며, 연합에서의 의사결정은 개인의 의사결정보다 우수하다는 가정 하에 실험을 진행하였다. 실험 결과는 이러한 가정을 뒷받침하여 전략적 연합을 이용한 전략이 테스트 전략에 대해 일반화 성능이 우수함을 보여주고 있다.

  • PDF

An Event-Driven Entity-Relationship Modeling Method for Creating a Normalized Logical Data Model (정규화된 논리적 데이터 모델의 생성을 위한 사건 기반 개체-관계 모델링 방법론)

  • Yoo, Jae-Gun
    • Journal of Korean Institute of Industrial Engineers
    • /
    • v.37 no.3
    • /
    • pp.264-270
    • /
    • 2011
  • A new method for creating a logical data model is proposed. The logical data model developed by the method defines table, primary key, foreign key, and fields. The framework of the logical data model is constructed by modeling the relationships between events and their related entity types. The proposed method consists of a series of objective and quantitative decisions such as maximum cardinality of relationships and functional dependency between the primary key and attributes. Even beginners to database design can use the methology as long as they understand such basic concepts about relational databases as primary key, foreign key, relationship cardinality, parent-child relationship, and functional dependency. The simple and systematic approach minimizes decision errors made by a database designer. In practial database design the method creates a logical data model in Boyce-Codd normal form unless the user of the method makes a critical decision error, which is very unlikely.

Deep Learning based Sentence Analysis for Query Generation (검색어 생성을 위한 딥 러닝 기반 문장 분석 연구)

  • Na, Seong-Won;Yoon, Kyoungro
    • Proceedings of the Korean Society of Broadcast Engineers Conference
    • /
    • 2018.06a
    • /
    • pp.336-337
    • /
    • 2018
  • 최근 이미지의 Visual 정보를 추출하고 Multi label 분류를 통해 나온 결과의 상관관계를 modeling하여 문장으로 출력하는 CNN-RNN 아키텍처가 많은 발전을 이뤘다. 이 아키텍처의 출력은 이미지의 정보가 요약되어 문장으로 표현되기 때문에 Semantic정보가 풍부하여 유사 콘텐츠 검색에도 사용 가능하다. 하지만 결과 문장에 사람이 포함 되면 광범위한 검색 결과를 얻게 되고 부정확한 결과를 초래하게 된다. 이에 본 논문에서는 문장에서 사람을 인식하여 Identity를 부여함으로써 검색어를 좀 더 구체적으로 생성하고자 한다. 이 문제를 해결하기 위해 자연어 처리의 분야 중 하나인 개체명 인식(Named Entity Recognition) 문제로 다루며, 가장 많이 사용되고 있는 모델인 Bidirectional-LSTM-CRF와 CoNLL2003 dataset을 사용하여 수행 한다.

  • PDF

Object Oriented Spatial Data Model using Geographic Relationship Role (지리 관계 역할을 이용한 객체 지향 공간 데이터 모델)

  • Lee, Hong-Ro
    • Journal of Internet Computing and Services
    • /
    • v.1 no.1
    • /
    • pp.47-62
    • /
    • 2000
  • Geographic Information System(GIS) deal with data which can potentially be useful for a wida range of applications. However, the information needs of each application usually vary, specially in resolution, detail level, and representation style, as defined in the modeling phase of the geographic database design. To be able to deal with such diverse needs, the GIS must after features that allow multiple representations for each geographic entity of phenomenon. This paper addresses the problem of formal definition of the objects and their relationships on geographical information systems. The geographical data is divided in two main classes: geo-objects and geo-fields, which describe discrete and continuous representations of spatial reality. I will study the classes and the roles of relationships over geo-fields, geo-objects and nongeo-objects. Therefore, this paper will contribute the efficient design of geographical class hierarchy schema by means of formalizing attribute-domains of classes.

  • PDF

The Study on the FRBR Adoption into Cataloging Rule Focused on its Expression Level (표현형 계층을 중심으로 한 FRBR 모형 분석 및 목록 체계 수용에 관한 연구)

  • Cho Jane
    • Journal of Korean Library and Information Science Society
    • /
    • v.36 no.2
    • /
    • pp.221-239
    • /
    • 2005
  • FRBR, as is new conceptual model of bibliography based on entity-relation model, direct to revision of AACR 3.JSC has progressed work to adopt FRBR conceptual model into cataloging rule, especially for solving the problem of expression level, propose to overall change of uniform title & GMD. This study considers the matters about expression level of FRBR model. And examine possibility of adoption FRBR model to domestic cataloging rule and making out practice.

  • PDF