• Title/Summary/Keyword: ER Model

Search Result 265, Processing Time 0.026 seconds

A Transforming Method between Extended Entity-relationship Model and Object-relational Database using Triple graph grammer (트리플 그래프 문법을 사용한 확장 개체-관계 모델과 객체-관계 모델간의 변환 방법)

  • Nhung, Nguyen Thi;Song, Sang-Geun;Shin, Jung-Hoon;Lee, Sang-Jun
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2012.06c
    • /
    • pp.78-80
    • /
    • 2012
  • 개체 관계(ER) 모델과 확장 개체 관계(EER) 모델은 개념적 데이터베이스 설계분야에서 가장 많이 사용되는 모델이다. 확장 개체 관계 모델은 여전히 객체지향 데이터베이스를 처리하는데 강력하나 최신 객체관계 데이터베이스와 UML과 같은 새로운 데이터베이스 모델링을 처리하기에는 부족함이 많다. 따라서 본 논문에서는 이러한 객체 관계 데이터베이스를 지원하기 위한 확장 개체 관계 기반의 변환 방법을 제안한다. 변환 규칙은 트리플 그래프 문법을 사용하여 정의하고 MOFRON TGG 에디터를 이용하여 표현한다. 트리플 그래프 문법 규칙에 따라 본 제안 방법은 자동 ORDB 개발 프레임워크에 적용할 수 있다.

Mouse models of breast cancer in preclinical research

  • Park, Mi Kyung;Lee, Chang Hoon;Lee, Ho
    • Laboraroty Animal Research
    • /
    • v.34 no.4
    • /
    • pp.160-165
    • /
    • 2018
  • Breast cancer remains the second leading cause of cancer death among woman, worldwide, despite advances in identifying novel targeted therapies and the development of treating strategies. Classification of clinical subtypes (ER+, PR+, HER2+, and TNBC (Triple-negative)) increases the complexity of breast cancers, which thus necessitates further investigation. Mouse models used in breast cancer research provide an essential approach to examine the mechanisms and genetic pathway in cancer progression and metastasis and to develop and evaluate clinical therapeutics. In this review, we summarize tumor transplantation models and genetically engineered mouse models (GEMMs) of breast cancer and their applications in the field of human breast cancer research and anti-cancer drug development. These models may help to improve the knowledge of underlying mechanisms and genetic pathways, as well as creating approaches for modeling clinical tumor subtypes, and developing innovative cancer therapy.

SQL Learning Tool Using TPC-H model (TPC-H 데이터모델을 이용한 SQL 교육 도구)

  • Pack, Inhye;Kim, Jieun;Jeon, Minah;Shim, Jaehee;Kang, Hyunjeong;Park, Uchang
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2011.11a
    • /
    • pp.1532-1533
    • /
    • 2011
  • 본 연구에서는 SQL를 배우고자 하는 개발자들에게 SQL 문법을 학습할 수 있는 교육용 Tool을 개발한다. 개발자가 예제와 설명을 통하여 SQL 문법을 배우고 ER-Diagram을 보면서 논리적인 DB의 개념을 이용하여 쉽게 학습할 수 있다. 예제는 초급과 중급으로 나누어져 있어 사용자의 수준에 맞는 학습이 선택가능하다. TPC-H 데이터는 DSS 환경에서 사용되는 표준 데이터 모델로 Database Generater를 통해 생성하며 본 연구에서 사용자가 데이터량의 조정이 가능하도록 구성하였다.

The Resonance Characteristic Analysis for Speed Control of Parallel Connected Dual SPMSMs fed by a Single Inverter (단일 인버터로 두 대의 영구자석 동기전동기 병렬운전에 대한 공진특성해석)

  • Yun, Chul;Kwon, Woo-Hyen
    • The Transactions of The Korean Institute of Electrical Engineers
    • /
    • v.66 no.4
    • /
    • pp.643-650
    • /
    • 2017
  • This pap4er analyzes resonance characteristics of a slave motor that is not controlled by load and parameter differences between Dual motors during parallel operation in middle-low speed. Dual SPMSMs(Surface mounted Permanent Magnet Synchronous Motor) connected in parallel to a single inverter controlled by the master and slave control in this paper. Based on the stability analysis of the SPMSM for a variation of torque angle, the 6th nonlinear state equation of the torque angle variation in the SIMM(Single Inverter Multi Motor) structure is derived according to a mathematical model for the dual motors. In general, an analysis of the 6th order nonlinear state equation is complex. Therefore, a resonance frequency generated from the slave motor is found from the characteristic equation of the 2nd order system obtained by linearization and model reduction near steady state operation point. Through simulations and experiments, it is confirmed that the stability analysis of the SPMSMs and state equation models are useful for the variation of the torque angle analyzed in this paper.

Regional allocation of carbon emissions in China based on zero sum gains data envelopment analysis model

  • Wen, Lei;Zhang, Er nv
    • Environmental Engineering Research
    • /
    • v.21 no.1
    • /
    • pp.91-98
    • /
    • 2016
  • Along with China's increasing share in global total $CO_2$ emissions, there is a necessity for China to shoulder large emission-mitigating responsibility. The appropriate allocation of $CO_2$ emission quotas can build up a solid foundation for future emissions trading. In views of originality, an optimized approach to determine $CO_2$ emissions allocation efficiency based on the zero sum gains data envelopment analysis (ZSG-DEA) method is proposed. This paper uses a non-radial ZSG-DEA model to allocate $CO_2$ emissions between different Chinese provinces by 2020 and treats $CO_2$ as the undesirable output variable. Through the calculation of efficiency allocation amounts of provincial $CO_2$ emissions, all provinces are on the ZSG-DEA efficiency frontier. The allocation results indicate that the cumulative optimal amounts of $CO_2$ emissions in 2020 were higher than the actual amounts in 13 provinces, and lower in other 17 provinces, and show that different provinces have to shoulder different mitigation burdens in terms of emission reduction.

Salubrinal Alleviates Pressure Overload-Induced Cardiac Hypertrophy by Inhibiting Endoplasmic Reticulum Stress Pathway

  • Rani, Shilpa;Sreenivasaiah, Pradeep Kumar;Cho, Chunghee;Kim, Do Han
    • Molecules and Cells
    • /
    • v.40 no.1
    • /
    • pp.66-72
    • /
    • 2017
  • Pathological hypertrophy of the heart is closely associated with endoplasmic reticulum stress (ERS), leading to maladaptations such as myocardial fibrosis, induction of apoptosis, and cardiac dysfunctions. Salubrinal is a known selective inhibitor of protein phosphatase 1 (PP1) complex involving dephosphorylation of phospho-eukaryotic translation initiation factor 2 subunit $(p-eIF2)-{\alpha}$, the key signaling process in the ERS pathway. In this study, the effects of salubrinal were examined on cardiac hypertrophy using the mouse model of transverse aortic constriction (TAC) and cell model of neonatal rat ventricular myocytes (NRVMs). Treatment of TAC-induced mice with salubrinal ($0.5mg{\cdot}kg^{-1}{\cdot}day^{-1}$) alleviated cardiac hypertrophy and tissue fibrosis. Salubrinal also alleviated hypertrophic growth in endothelin 1 (ET1)-treated NRVMs. Therefore, the present results suggest that salubrinal may be a potentially efficacious drug for treating pathological cardiac remodeling.

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.

The Relationship between Exchange Rate and Trade Balance: Empirical Evidence from Sri Lanka

  • FATHIMA THAHARA, Aboobucker;FATHIMA RINOSHA, Kalideen;FATHIMA SHIFANIYA, Abdul Jawahir
    • The Journal of Asian Finance, Economics and Business
    • /
    • v.8 no.5
    • /
    • pp.37-41
    • /
    • 2021
  • This study aims to investigate the relationship between the exchange rate and Trade Balance. Trade Balance is used as the dependent variable, and the independent variables are Exchange Rate, Gross Domestic Product, and Inflation. Augmented Dickey-Fuller unit root test was adopted to test the stationary property of time series data, Auto Regressive Distributed Lag model was employed to find the long run and short-run relationship and long-run adjustment, Bound test approach, the unrestricted Error Correction Model and Granger Causality Test are used to analyze the data from 1977 to 2019. The research findings suggest that inflation has a positive impact on the trade balance in the short run. The exchange rate and the Gross Domestic Product have adverse effects on Trade balance in the long run. The coefficient of ER in the previous year is negative, and the coefficient of TB in the previous year is positive and significant. This is consistent with the J-Curve phenomenon, which states that devaluation may not improve trade balance in the immediate period, but will significantly impact the trade balance improvement in subsequent periods. Hence Marshall Lerner Condition exists in Sri Lanka.

How Practitioners Perceive a Ternary Relationship in ER Conceptual Modeling

  • Jihae Suh;Jinsoo Park;Buomsoo Kim;Hamirahanim Abdul Rahman
    • Asia pacific journal of information systems
    • /
    • v.28 no.2
    • /
    • pp.75-92
    • /
    • 2018
  • Conceptual modeling is well suited as a subject that constitutes the "core" of the Information Systems (IS) discipline and has grown in response to IS development. Several modeling grammars and methods have been studied extensively in the IS discipline. Previous studies, however, present deficiencies in research methods and even put forward contradictory results about the ternary relationship in conceptual modeling. For instance, some studies contend that the semantics of a binary relationship are better for novices, but others argue that a ternary relationship is better than three binary relationships when the association among three entity types clearly exists. The objective of this research is to acquire complete and accurate understanding of the ternary relationship, specifically to understand practitioners' modeling performance when utilizing either a ternary or binary relationship. To the best of our knowledge, no previous work clearly compares real-world modeler performance differences between binary and ternary representations. By investigating practitioners' understanding of ternary relationship and identifying practitioners' cognition, this research can broaden the perspective on conceptual modeling.

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.