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

Search Result 2,125, Processing Time 0.028 seconds

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

  • Sunit Gala;Kim, Won
    • The Journal of Information Technology and Database
    • /
    • v.1 no.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

The Effects of Relational Benefits on Relationship Quality and CRM Effects in Fashion Retail Stores (관계편익이 관계품질과 패션 소매업체의 CRM 성과에 미치는 영향)

  • Hwang, Sun-Jin
    • Journal of the Korean Society of Clothing and Textiles
    • /
    • v.35 no.2
    • /
    • pp.230-241
    • /
    • 2011
  • This study investigates how the relational benefits of fashion retail stores influence the relationship quality (trust, satisfaction, and commitment) and CRM effects (revisit intention and word of mouth intention). This study also analyzes the moderating effect of consumer characteristics between relational benefits and relationship quality. The subjects of this study consisted of 340 female consumers whose age ranged from 20 to 50s and the results were analyzed using AMOS 18.0 and SPSS 12.0. The results of the study were as follows: First, there were three types of relational benefits of psychological, social and economic relational benefits in the CRM activities of fashion retail stores. In addition, it was found that the psychological and economic relational benefits had positive effects on the relational qualities of fashion retail stores; however, the social relational benefits did not have any effects on the relational qualities of fashion retail stores. Second, the relationship quality had a positive influence on CRM effects such as revisit intention and word of mouth intention. Third, it was confirmed that the consumer characteristics variables were effective mediators linking the relational benefits and relational qualities of fashion retail stores.

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

  • Park, Chulsoon
    • Journal of the Korean Operations Research and Management Science Society
    • /
    • v.40 no.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.

Implementation issues for Uncertain Relational Databases

  • Yu, Hairong;Ramer, Arthur
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 1998.06a
    • /
    • pp.128-133
    • /
    • 1998
  • This paper aims to present some ideas for implementation of Uncertain Relational Databases (URD) which are extensions of classical relational databases. Our system firstly is based on possibility distribution and probability theory to represent and manipulate fuzzy and probabilistic information, secondly adopts flexible mechanisms that allow the management of uncertain data through the resources provided by both available relational database management systems and front-end interfaces, and lastly chooses dynamic SQL to enhance versatility and adjustability of systems.

  • PDF

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

  • Shin, Yoo-Lim
    • Journal of Families and Better Life
    • /
    • v.30 no.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.

The Structural Effects of Relational Benefits on Brand Loyalty in Financial Institute (금융기관에서 관계편익이 브랜드충성도에 미치는 구조적 영향)

  • Jang, Jungbin;Kim, Shin;Choi, Jeongil
    • Journal of Korean Society for Quality Management
    • /
    • v.45 no.1
    • /
    • pp.39-54
    • /
    • 2017
  • Purpose: This study evaluated the effect of customer relationship management (CRM) on customer's brand loyalty in the holistic perspective of relational benefits, relationship quality and relation value. This paper attempted to find out the psychological process that links the relational benefits and brand loyalty. Methods: The data was collected by using the structured questionnaires to VIP customers and general customers of major domestic banks. The proposed research model is empirically tested using 324 valid questionnaires using SPSS 23 and AMOS 23. Results: This research indicated the partially positive relationship between the relational benefits and relation values, and between relational benefits and relationship quality. The relation value and relationship quality positively affects the relation commitment and the relation commitment also positively affects brand loyalty. This study also shows that the relation value affects the brand loyalty through the mediation of relation commitment, but also the relationship quality affects the brand loyalty through the media of relation commitment. Conclusions: This study investigates the role of perceptional factors(relational value and relationship quality) and affective factors(relation commitment) to find the relationship between relational benefits and brand loyalty. It also suggest the relative influence of relational benefits on relation value.

A Cross-Sectional and Longitudinal Study on Bullying/Victimization and Overt/Relational Aggression: Focused on gender (또래 괴롭힘과 외현과 관계적 공격성에 관한 횡단 및 종단연구: 성별을 중심으로)

  • Sim, Hee-Og
    • Korean Journal of Human Ecology
    • /
    • v.16 no.6
    • /
    • pp.1107-1118
    • /
    • 2007
  • This study explored the consistency of bullying, victimization and aggressive victimization, the relationships between bullying, victimization and aggressive victimization and overt/relational aggression, and the relationships between bullying groups and overt/relational aggression with gender. The subjects were 4th grade children and 2 years later they were contacted again. Instruments were the Bully-Behavior Scale, the Peer-Victimization Scale and the Peer Nomination Instrument. Bullying, victimization and aggressive victimization were decreased while there were consistencies in overt and relational aggression from 4th to 6th grade. In the correlation analysis, male victims at Time 1 were negatively related to overt and relational aggression at both Time 1 and Time 2. Female bullies were positively related to relational aggression at both Time 1 and Time 2. In the cross-sectional relations of overt aggression with bullying groups, there was a gender difference. In the relational aggression with bullying groups, only bullying groups had a significant difference. In the longitudinal relations of overt aggression with bullying groups, only gender had a significant difference. Males appeared to be more overtly aggressive than females. In the relational aggression, bullying groups, gender, and the interaction between bullying groups and gender had significant differences. Female bullies were more likely to be relationally aggressive than other groups.

Relational Characteristics and Satisfaction of Foodservice Businesses in Association to Distribution Channels (외식업체의 유통경로상 관계특성과 만족에 관한 경로모형 연구)

  • Jeon Hyo-Jin
    • Korean journal of food and cookery science
    • /
    • v.22 no.2 s.92
    • /
    • pp.250-257
    • /
    • 2006
  • Foodservice industry and distribution business could make mutual prpgress when they join forces in responding to environmental uncertainty in an efficient manner. The purpose of this study was to examine the relational characteristics of domestic food service businesses and distribution firms in conjunction with the distribution channels and ensuing conflicts between them, to present possible alternatives on and how they should communicate with each other to achieve a satisfactory result. The relational characteristics and ensuing conflicts of food service businesses and distribution firms appeared to be significantly characterized by incongruities of target, role and perception. The types of relational characteristics that were triggered by the disagreement of roles and perception combined to decrease the intensity of the relational commitment. A satisfactory transactional relationship served to ease their conflicts caused by perceptual disagreement, and the soos of conflicts that were rooted in the discord of roles and of perception that increased the degree of relational commitment. As for relational performance, relational commitment, satisfaction with distribution channel and satisfaction with suppliers allowed them to maintain their relationship on a long-term basis.

A Study on the Customer Segmentation and Performance by Medical Service Experience : Focusing on the Relational Benefits (의료서비스 경험에 의한 고객세분화와 성과에 관한 연구: 병원-고객 간의 관계혜택을 중심으로)

  • Park, Gwijeong
    • Journal of the Korea Convergence Society
    • /
    • v.9 no.9
    • /
    • pp.371-378
    • /
    • 2018
  • The purpose of this study is to classify the customers according to the characteristics of the relational benefits and to compare the performances of the sub-groups. As a result of the research, the group type according to the relational benefits was subdivided into 3 groups, and each group was named emotional relational group, continuous relational group and intermittent relational group considering customer characteristics. First, the emotional relational group is the group that emphasizes the empathy and assurance between the service provider and the customer, and the continuous relational group is the group with the highest social, confidence and economic benefits. The intermittent relational group was simply a transaction-oriented group. This implies that a differentiated customer management strategy is needed for each relational benefit group based on customer experience in medical services.

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.