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

검색결과 2,110건 처리시간 0.027초

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

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

  • 황성진
    • 한국의류학회지
    • /
    • 제35권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)

  • 박철순
    • 한국경영과학회지
    • /
    • 제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.

Implementation issues for Uncertain Relational Databases

  • Yu, Hairong;Ramer, Arthur
    • 한국지능시스템학회:학술대회논문집
    • /
    • 한국퍼지및지능시스템학회 1998년도 The Third Asian Fuzzy Systems Symposium
    • /
    • 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)

  • 신유림
    • 가정과삶의질연구
    • /
    • 제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.

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

  • 장정빈;김신;최정일
    • 품질경영학회지
    • /
    • 제45권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)

  • 심희옥
    • 한국생활과학회지
    • /
    • 제16권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)

  • 전효진
    • 한국식품조리과학회지
    • /
    • 제22권2호
    • /
    • 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)

  • 박귀정
    • 한국융합학회논문지
    • /
    • 제9권9호
    • /
    • pp.371-378
    • /
    • 2018
  • 본 연구는 입원경험이 있는 고객을 대상으로 관계혜택 특성에 따라 고객을 세분화하고 세분고객집단별 의료서비스 성과를 비교하기 위함이다. 연구결과, 관계혜택에 따른 세분집단은 3개의 군집으로 유형화되었으며 각각의 집단은 집단특성을 고려하여 감성적 관계 집단, 연속적 관계 집단, 단속적 관계 집단으로 명명하였다. 먼저 감성적 관계집단은 의료서비스의 관계혜택 중 서비스제공자와 고객 간의 공감, 확신을 중요시하는 집단이며, 연속적 관계 집단은 사회적, 확신적, 경제적 혜택 인식이 가장 높은 집단이며, 단속적 관계 집단은 단순히 거래중심적인 집단으로 나타났다. 다음으로, 세분집단별로 고객만족, 신뢰, 재방문의도 간의 차이를 분석한 결과, 집단별 성과요인들에는 모두 유의한 차이가 있음을 확인하였다. 이는 고객경험에 근거한 관계혜택 집단별로 차별적인 고객 관리전략이 필요함을 시사한다.

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

  • 주경수;조도형
    • 인터넷정보학회논문지
    • /
    • 제12권6호
    • /
    • pp.149-159
    • /
    • 2011
  • 현재의 응용시스템들은 복합관계성으로 관련지어진 복합객체를 갖고 있다는 특징을 갖는다. 이러한 특징은 기존의 관계형 데이터베이스로 표현하기에는 한계가 있어 관계형 데이터베이스는 객체-관계형 데이터베이스로 확장되었다. 이에 따라서 기존의 관계형 데이터베이스 설계 방법론과 같은 객체-관계형 데이터베이스 설계 방법론이 요구된다. 본 논문에서는 스테레오타입과 태그값 그리고 제약조건을 이용한, UML 클래스다이어그램 확장에 기반하여 객체-관계형 데이터베이스를 위한 통합된 설계방법론을 개발한다. 아울러 확장된 UML 클래스다이어그램을 객체-관계형 데이터베이스 스키마로의 변환을 위한 가이드라인을 제시한다. 개발한 설계방법론에서 사용하는 객체-관계형 모델은 SQL:1999를 이용하였으며, 객체-관계형 데이터베이스 구현은 Oracle11g로 하였다. 많은 객체-관계형 DBMS는 존재하지만 객체-관계형 데이터베이스 설계에 있어서 일관된 방법론은 제시되지 않았다. 본 논문에서 제시하는 방법론을 적용함으로써 일관된 방법으로 객체-관계형 데이터베이스 설계를 가능하게 한다. 사례 연구로, 제안한 설계방법론을 컴퓨터교실 예약시스템에 대하여 적용한다.