• Title/Summary/Keyword: Relational Data Model

Search Result 336, Processing Time 0.026 seconds

UML Extension for Object-Relational Database Design - Focusing on Oracle11g - (객체-관계형 데이터베이스 설계를 위한 UML 확장 - Oracle11g를 중심으로 -)

  • Joo, Kyung-Soo;Jho, Do-Hyung
    • Journal of Internet Computing and Services
    • /
    • v.12 no.6
    • /
    • pp.149-159
    • /
    • 2011
  • The current applications can be characterized as consisting of complex objects related by complex relationship. Therefore the relational database has been extended to object-relational database because of the complex objects. Accordingly, we need database design methodology for object-relational database. In this pager, we develop an integrated design methodology based on a extended UML class diagram for object-relational database. We make the extend UML class diagram by adding new stereotypes for object-relational database. Also we propose a guideline for transforming the extended UML class diagram to object-relational database schema. We use SQL:1999 as a object-relational data model and Oracle11g as a target object-relational database. We can build more easily and efficiently object-relational database for Oracle11g by using our methodology. Finally we applied our methodology on a computer classroom reservation system for evaluation the methodology.

Detection of Dangerous Situations using Deep Learning Model with Relational Inference

  • Jang, Sein;Battulga, Lkhagvadorj;Nasridinov, Aziz
    • Journal of Multimedia Information System
    • /
    • v.7 no.3
    • /
    • pp.205-214
    • /
    • 2020
  • Crime has become one of the major problems in modern society. Even though visual surveillances through closed-circuit television (CCTV) is extensively used for solving crime, the number of crimes has not decreased. This is because there is insufficient workforce for performing 24-hour surveillance. In addition, CCTV surveillance by humans is not efficient for detecting dangerous situations owing to accuracy issues. In this paper, we propose the autonomous detection of dangerous situations in CCTV scenes using a deep learning model with relational inference. The main feature of the proposed method is that it can simultaneously perform object detection and relational inference to determine the danger of the situations captured by CCTV. This enables us to efficiently classify dangerous situations by inferring the relationship between detected objects (i.e., distance and position). Experimental results demonstrate that the proposed method outperforms existing methods in terms of the accuracy of image classification and the false alarm rate even when object detection accuracy is low.

An empirical comparison of static fuzzy relational model identification algorithms

  • Bae, Sang-Wook;Lee, Kee-Sang;Park, Gwi-Tae
    • 제어로봇시스템학회:학술대회논문집
    • /
    • 1994.10a
    • /
    • pp.146-151
    • /
    • 1994
  • An empirical comparison of static fuzzy relational models which are identified with different fuzzy implication operators and inferred by different composition operators is made in case that all the information is represented by the fuzzy discretization. Four performance measures (integral of mean squared error, maximal error, fuzzy equality index and mean lack of sharpness) are adopted to evaluate and compare the quality of the fuzzy relational models both at the numerical level and logical level. As the results, the fuzzy implication operators useful in various fuzzy modeling problems are discussed and it is empirically shown that the selection of data pairs is another important factor for identifying the fuzzy model with high quality.

  • PDF

Cross-national study on the effect of forgiveness on relational performance: Business service firms in Korea, Japan, and China (용서가 관계성과에 미치는 영향에 관한 국제비교 연구: 한국, 일본, 중국의 비즈니스서비스 기업을 중심으로)

  • Noh, Jeonpyo
    • International Area Studies Review
    • /
    • v.15 no.3
    • /
    • pp.3-28
    • /
    • 2011
  • The present study empirically tested hypotheses delineated from a proposed model of trust-forgiveness-performance of business services, Empirical data was collected from 506 business service companies in Korea, Japan and China. The structural equation model analysis confirmed the significant effect of forgiveness on relational performance and trust on forgiveness, and also found there exist meaningful cross-national differences and similarities both in intensity and directionality of the relations.

Development of relational river data model based on river network for multi-dimensional river information system (다차원 하천정보체계 구축을 위한 하천네트워크 기반 관계형 하천 데이터 모델 개발)

  • Choi, Seungsoo;Kim, Dongsu;You, Hojun
    • Journal of Korea Water Resources Association
    • /
    • v.51 no.4
    • /
    • pp.335-346
    • /
    • 2018
  • A vast amount of riverine spatial dataset have recently become available, which include hydrodynamic and morphological survey data by advanced instrumentations such as ADCP (Acoustic Doppler Current Profiler), transect measurements obtained through building various river basic plans, riverine environmental and ecological data, optical images using UAVs, river facilities like multi-purposed weir and hydrophilic sectors. In this regard, a standardized data model has been subsequently required in order to efficiently store, manage, and share riverine spatial dataset. Given that riverine spatial dataset such as river facility, transect measurement, time-varying observed data should be synthetically managed along specified river network, conventional data model showed a tendency to maintain them individually in a form of separate layer corresponding to each theme, which can miss their spatial relationship, thereby resulting in inefficiency to derive synthetic information. Moreover, the data model had to be significantly modified to ingest newly produced data and hampered efficient searches for specific conditions. To avoid such drawbacks for layer-based data model, this research proposed a relational data model in conjunction with river network which could be a backbone to relate additional spatial dataset such as flowline, river facility, transect measurement and surveyed dataset. The new data model contains flexibility to minimize changes of its structure when it deals with any multi-dimensional river data, and assigned reach code for multiple river segments delineated from a river. To realize the newly developed data model, Seom river was applied, where geographic informations related with national and local rivers are available.

Template-based Automatic 3D Model Generation from Automotive Freehand Sketch (템플릿을 이용한 자동차 프리핸드 스케치의 3D 모델로 자동변환)

  • Cheon, S.U.;Han, S.H.
    • Korean Journal of Computational Design and Engineering
    • /
    • v.12 no.4
    • /
    • pp.283-297
    • /
    • 2007
  • Seamless data integration in the CAx chain of the CAD/CAPP/CAM/CNC has been achieved to a high degree, but research concerning the transfer of data from conceptual sketches to a CAD system should be carried out further. This paper presents a method for reconstructing a 3D model from a freehand sketch. Sketch-based modeling research can be classified into gestural modeling methods and reconstructional modeling methods. This research involves the reconstructional modeling method. Here, Mitani's seminal work, designed for box-shaped 3D model using a predefined template, is improved by leveraging a relational template and specialized for automotive design. Matching between edge graphs of the relational template and the sketch is formulated and solved as the assignment problem using the feature vectors of the edges. Including the stroke preprocessing method required to generate an edge graph from a sketch, necessary procedures and relevant techniques for implementing the template-based modeling method are described. Examples from a working implementation are given.

An Efficient Transformation Technique from Relational Schema to Redundancy Free XML Schema (관계형 스키마로부터 중복성이 없는 XML 스키마로의 효율적인 변환 기법)

  • Cho, Jung-Gil
    • Journal of Internet Computing and Services
    • /
    • v.11 no.6
    • /
    • pp.123-133
    • /
    • 2010
  • XML has been become the new standard for publishing and exchanging data on the Web. However, most business data is still stored and maintained in relational database management systems. As such, there is an increasing need to efficiently publish relational data as XML data for Internet-based applications. The most important issue in the transformation is to reflect structural and semantic relations of RDB to XML schema exactly. Most transformation approaches have been done to resolve the issue, but those methods have several problems. In this paper, we discuss algorithm in transforming a relational database schema into corresponding XML schema in XML Schema. We aim to achieve not only explicit/implicit referential integrity relation information but also high level of nested structure while introducing no data redundancy for the transformed XML schema. To achieve these goals, we propose a transformation model which is redundancy free and then we improve the XML Schema structure by exploring more nested structure.

A Study on User's Voluntary Behavior in Company Social Networks(CSN) (기업의 관계적 성과로서 기업소셜네트워크 이용자의 자발행동에 관한 연구)

  • Kang, Inwon;Cho, Eunsun
    • Journal of Information Technology Services
    • /
    • v.13 no.2
    • /
    • pp.35-53
    • /
    • 2014
  • Company Social Networks (CSN) has emerged as a commonly used marketing channel. One of the most important advantages in CSN is the user's voluntary behavior as a relational performance. We classified level of voluntary behavior, as 'consumption', 'active participation', and 'creative contribution' to comprehend different relational performance of CSN. Moreover, we proposed research model to compare positive attitude and negative attitude. This study aims to investigate 'the process of user's voluntary behavior in CSN' which is causal relationship between benefits of CSN, user's attitude and voluntary behavior. Empirical results with 175 valid questionnaire data revealed that CSN benefit factors played a significant role in trust and distrust. Based on these effects, trust and distrust have different influences as level of voluntary behavior, just as proposed. For practitioners, it is crucial finding that users are more active behavior based on strong trust.

Structural Relationship Between the Expectation Value of YouTube Sports Content Viewers, Brand Image, Brand Attitude, and Continuance Viewing Intention

  • Byun, Kyung-Won
    • International journal of advanced smart convergence
    • /
    • v.9 no.3
    • /
    • pp.215-220
    • /
    • 2020
  • The purpose of this study is to analyze the structural relationship among expectation value(relational, hedonistic), brand image, brand attitude, continuance viewing intention. The survey subjects to achieve the purpose of this study were selected the 521 YouTube sports contents Viewer in the metropolitan area. Data processing was done with SPSS 23 for frequency analysis, Cronbach's α analysis. Also, AMOS 21 was used for confirmatory factor analysis and structural equation model analysis. The results of the analysis are as follows: First, both relational value and,, hedonistic value had a positive effect on the brand image. Second, both relational value and,, hedonistic value had a positive effect on the brand attitude. Third, both brand image and brand attitudee had a positive effect on the brand attitude.

구매자.판매자간 거래관계의 특성이 관계성과에 미치는 영향 : 관계규범과 관계투자를 중심으로

  • 김종훈
    • Journal of Distribution Research
    • /
    • v.4 no.1
    • /
    • pp.71-92
    • /
    • 1999
  • The basic purpose of this study is to investigate how the traits of the buyer-seller transaction-relationship relate to relationship performance, including relationship performance explicitly in the proposed model. The traits examined include relational norm, formalization, market uncertainty, and relationship investment. It is hypothesized that relational norm and formalization have positive impacts on relationships performance while market uncertainty has a minus impact. In addition, it is hypothesized that relational norm has a positive moderating impact on the effect of relationship investment--the investment and efforts for maintaining a relationship to relationship performance. A mail-survey to the manufacturers of machinery and equipment about their relationships with the parts suppliers was performed. Data provided a strong support for the hypotheses. As hypothesized, relationship performance and formalization generally had positive impacts on relationship performance and formalization generally had positive impacts on relationship performance while market uncertainty showed negative impacts. Also, there is a good evidence for the positive moderating effect of relational norm to the impact of relationship investment on relationship performance.

  • PDF