• 제목/요약/키워드: relational model

검색결과 564건 처리시간 0.025초

Database Design Methodology : Converting a Relational Schema into an Object-Relational Schema

  • Sunit Gala;Kim, Won
    • 정보기술과데이타베이스저널
    • /
    • 제1권1호
    • /
    • pp.9-30
    • /
    • 1994
  • The objective of this paper is to give a brief review of relational design methodology, and show how a relational schema can be converted into an object-relational schema. We first introduce relational terminology and describe the relational design process along with its limitations. Next we show how the relational model can be extended to overcome these limitations : these extensions form the core of an object-relational data model ; we use the UniSQL/X data model as an example. We illustrate the process or converting a relational schema into an object-relational schema, and show the benefits of this conversion with respect to queries. The conversion process is then summarized as a set of guidelines. Finally, we make our conclusions.

  • PDF

Risk assessment of karst collapse using an integrated fuzzy analytic hierarchy process and grey relational analysis model

  • Ding, Hanghang;Wu, Qiang;Zhao, Dekang;Mu, Wenping;Yu, Shuai
    • Geomechanics and Engineering
    • /
    • 제18권5호
    • /
    • pp.515-525
    • /
    • 2019
  • A karst collapse, as a natural hazard, is totally different to a normal collapse. In recent years, karst collapses have caused substantial economic losses and even threatened human safety. A risk assessment model for karst collapse was developed based on the fuzzy analytic hierarchy process (FAHP) and grey relational analysis (GRA), which is a simple and effective mathematical algorithm. An evaluation index played an important role in the process of completing the risk assessment model. In this study, the proposed model was applied to Jiaobai village in southwest China. First, the main controlling factors were summarized as an evaluation index of the model based on an investigation and statistical analysis of the natural formation law of karst collapse. Second, the FAHP was used to determine the relative weights and GRA was used to calculate the grey relational coefficient among the indices. Finally, the relational sequence of evaluation objects was established by calculating the grey weighted relational degree. According to the maximum relational rule, the greater the relational degree the better the relational degree with the hierarchy set. The results showed that the model accurately simulated the field condition. It is also demonstrated the contribution of various control factors to the process of karst collapse and the degree of collapse in the study area.

기업 간 협업 네트워크의 창발 : 관계 역량을 중심으로 (Emergence of Inter-organizational Collaboration Networks : Relational Capability Perspective)

  • 박철순
    • 한국경영과학회지
    • /
    • 제40권4호
    • /
    • pp.1-18
    • /
    • 2015
  • This paper proposes relational capability as a main driver of constructing inter-organizational collaboration networks. Based on social network theory and relational view literature, three components of relational capability are constructed and implemented by an agent-based model. The components include organizational capability, structural capability, and trust between a partner and a focal firm. These three components are updated by two micro mechanisms: structural mechanism and relational mechanism. Structural mechanism is a feedback loop in which the relational capability increases structural capability and vice versa. Relational mechanism is a learning-by-doing process in which a focal firm experiences success or failure of collaboration and the experience increases or decreases cumulative trust in a partner firm. Result of agent-based simulation shows that a collaboration network emerges through interactions of firm's relational capabilities and the characteristics of emerged networks vary with the contribution of structural capability and trust to relational capability. Specifically, in case structural capability contributes more to relational capability, the average degree centrality and collaboration proportion increases as time passes and enters into an equilibrium state. In that case, almost every firms participated in the network collaborates each other so that the emerged network becomes highly cohesive. In case trust contributes more to relational capability, the results are reversed. In an equilibrium state, the balance of contribution between structural capability and trust makes an emerged network larger and maximizes average degree centrality of the network.

잠재성장모형을 적용한 유아기 관계적 공격성의 발달궤적 (Trajectories of Relational Aggression in Preschool Children by the Latent Growth Curve Model)

  • 신유림
    • 가정과삶의질연구
    • /
    • 제30권2호
    • /
    • pp.189-196
    • /
    • 2012
  • The purpose of this study was to investigate trajectories of relational aggression in preschool children. The latent growth curve model was used to examine relational aggression in 3 to 5 year olds. The participants were 3-year-old children recruited from preschools and daycare centers. The children's verbal ability was assessed by interview and teachers completed measurements of negative emotionality and relational aggression. The findings suggest that relational aggression decreased during the preschool years. Gender, language ability, and negative emotionality showed positive effects on the initial level of relational aggression. Moreover, gender and negative emotionality had negative effects, however, language ability had positive effects on the change rate of relational aggression.

An Estimation of an Old Age Mortality Rate Using CK Model and Relational Model

  • Jung, Kyunam;Kim, Donguk
    • Communications for Statistical Applications and Methods
    • /
    • 제19권6호
    • /
    • pp.859-868
    • /
    • 2012
  • Due to a rapidly aging society, the future Korea mortality rate is important for planning national financial strategies and social security policies. Old age mortality statistics are very limited in their ability to project a future mortality rate; therefore, it is essential to accurately estimate the old age mortality rate. In this paper, we show that the CK model with a Relational model as a base model provides accurate estimates of old age mortality rates.

Generic Data Model 기반의 XML DBMS 설계 및 구현 (Designing and Implementing XML DBMS based on Generic Data Model)

  • 임종선;주경수
    • 한국전자거래학회지
    • /
    • 제8권1호
    • /
    • pp.103-111
    • /
    • 2003
  • Nowadays XML is used for exchanging information in e-Commerce, especially B2B. Necessity of XML DBMS has being increased to efficiently process XML data. So a lots of database products for supporting XML are rapidly appeared in the market. In this paper, we made an XML DBMS system based on Generic Data Model. First we developed XML Adaptor based on Generic Data Model and added it on relational DBMS for developing XML DBMS. XML Adaptor is composed of Query Convertor and XML Repository System. The Query Convertor parse commands that are for XML data manipulation and then call the relevant component of XML Repository System for relational database operation. The XML Repository System handles relational database operations such as create, delete, store, and etc. In this way we can use a relational DBMS for manipulation XML data. Therefor we can build more economically XML DBMS.

  • PDF

관계형 데이터베이스에 기반한 버전이 지원되는 VHDL 모델의 관리 기법 (A Methodology for Management of Version Supported VHDL Models Based on Relational Database)

  • 박휴찬
    • 한국시뮬레이션학회논문지
    • /
    • 제11권2호
    • /
    • pp.55-66
    • /
    • 2002
  • VHDL has been. widely used in modeling and simulation of hardware designs. However, complex relationship between components of the designs makes the VHDL modeling problem very difficult. Furthermore, after the initial creation of VHDL models, they evolve into many versions over their lifetime. To cope with such difficulties, this paper proposes a new methodology for the management of VHDL models supporting versions. Its conceptual bases are system entity structure and relational database. Within the methodology, a family of hierarchical structures of a design is organized in the form of VHDL model structure. It is, in turn, represented in the form of relational tables. Once the model structure is built in such a way, a specific simulation model which meets design objective is pruned from the model structure. The details of VHDL codes are systematically synthesized by combining it with the primitive models in a model base. These algorithms are also defined in terms of relational algebraic operations.

  • PDF

IFC의 객체기반 관계형 데이터베이스로의 매핑 (Mapping IFC to Object-oriented Relational Database)

  • 김선우;이강
    • 한국건설관리학회:학술대회논문집
    • /
    • 한국건설관리학회 2007년도 정기학술발표대회 논문집
    • /
    • pp.301-305
    • /
    • 2007
  • 대부분의 상용 데이터베이스 관리시스템은 관게형 데이터베이스 (relational database) 기술에 기반하고 있다. 그러나, 객체지향언어인 EXPRESS로 정의된 IFC(Industry Foundation Classes)를 일반적으로 많이 사용되는 관계형 데이터베이스로 매핑하려면 서로 구조가 달라 미핑과정이 매우 복잡해진다. 한편 IFC를 객체기반 데이터베이스(object-oriented database)나 객채관계형 데이터베이스(object-oriented relational database)와 같은 객체기반의 데이터베이스로 매핑하게 되면 그 과정이 비교적 단순해지고, 많은 장점을 가질 수 있다. 본 연구에서는 장기적으로 IFC와 객체기술에 기반한 통합정보교환기술을 실용화하기 위하여 먼저 관계형, 객체지향형 데이터베이스의 개념에 대해 살펴보고, IFC를 객체관계형 데이터베이스로의 매핑방법에 대하여 알아본다.

  • PDF

RDB의 묵시적 참조 무결성 추출 알고리즘에 대한 성능 평가 (Performance Evaluation about Implicit Referential Integrities Extraction Algorithm of RDB)

  • 김진형;정동원
    • 한국시뮬레이션학회:학술대회논문집
    • /
    • 한국시뮬레이션학회 2005년도 추계학술대회 및 정기총회
    • /
    • pp.71-76
    • /
    • 2005
  • XML is rapidly becoming one of the most widely adopted technologies for information exchange and representation on the World Wide Web. However, the large part of data is still stored in a relational database. Hence, we need to convert relational data into XML documents. The most important point of the conversion is to reflect referential integrities In relational schema model to XML schema model exactly. Until now, FT, NeT and CoT are suggested as existing approaches for conversion from the relational schema model to the XML schema model but these approaches only reflect referential integrities which are defined explicitly for conversion. In this paper, we suggest an algorithm for automatic extraction of implicit referential integrities such as foreign key constraints which is not defined explicitly in the initial relational schema model. We present translated XML documents by existing algorithms and suggested algorithms as comparison evaluation. We also compare suggested algorithm and conventional algorithms by simluation in accuracy part.

  • PDF

사용자 데모를 이용한 관계적 개체 기반 정책 학습 (Learning Relational Instance-Based Policies from User Demonstrations)

  • 박찬영;김현식;김인철
    • 한국정보과학회논문지:소프트웨어및응용
    • /
    • 제37권5호
    • /
    • pp.363-369
    • /
    • 2010
  • 데모-기반 학습은 사용자가 직접 작업을 시연함으로써 로봇에게 쉽게 새로운 작업지식을 가르칠 수 있다는 장점이 있다. 하지만 기존의 많은 데모-기반 학습법들은 상태공간과 정책들을 표현하기 위해 속성-값 벡터 모델을 이용하였다. 속성-값 벡터 모델의 제한성으로 인해, 이들은 학습과정의 효율성도 낮고 학습된 정책의 재사용성도 낮았다. 본 논문에서는 기존의 속성-값 모델 대신 관계적 모델을 이용하는 새로운 데모-기반 작업 학습법을 제안한다. 이 방법에서는 사용자 데모 기록에서 추출한 훈련 예들에 관계적 개체-기반 학습법을 적용함으로써, 동일 작업영역내의 다른 유사한 작업들에도 활용하기 용이한 관계적 개체-기반 정책을 유도한다. 이 관계적 정책은 (상태, 목표) 쌍으로 표현되는 임의의 한 상황에 대해 이것에 대응하는 하나의 실행동작을 결정해주는 역할을 한다. 본 논문에서는 데모-기반 관계적 정책 학습법에 대해 자세히 소개한 후, 로봇 시뮬레이터를 이용한 실험을 통해 이 학습법의 효과를 분석해본다.