Representation of functional dependencies in relational databases using linear graphs

Functional dependencies in relational databases are investigated. Eight binary relations, viz., (1) dependency relation, (2) equipotence relation, (3) dissidence relation, (4) completion relation, and dual relations of each of them are described. Any one of these eight relations can be used to represent the functional dependencies in a database. Results from linear graph theory are found helpful in obtaining these representations. The dependency relation directly gives the functional dependencies. The equipotence relation specifies the dependencies in terms of attribute sets which functionally determine each other. The dissidence relation specifies the dependencies in terms of saturated sets in a very indirect way. Completion relation represents the functional dependencies as a function, the range of which turns out to be a lattice. Depletion relation which is the dual of the completion relation can also represent functional dependencies and similarly can the duals of dependency, equipotence, and dissidence relations. The class of depleted sets, which is the dual of saturated sets, is defined and used in the study of depletion relations.

Young people's perceptions of the wood products industry : a relational view

The basis for this study was in poor attractiveness of the wood products industry among young people as a field to study and work in. The purpose was to produce new information of how to improve the relationship between young people and the wood products industry in order to better attract young people with different relational orientation. A survey was conducted among students of comprehensive schools and students of wood industry at vocational schools selected by systematic cluster sampling. The final sample consisted of 613 students. The study combined the theories and concepts of relationships, communication and trust of several disciplines. In addition, it applied theories of relationship marketing, stakeholders, publics, involvement and concepts of reputation and values. It studied the central relational elements in the form of antecedents, relationship state and its consequences. The study examined, how young people with different background and level of interest perceive wood industry as a field to study and work in from relational point of view, what are the central deficiencies in perceived relational elements and what are the public relations activities enhancing the relationship between wood industry and young people with less and high interest in the sector. The results indicate poor visibility of the wood industry among young people: unfamiliarity with the industry and unawareness of the opportunities to study in the field. It appeared that instead of increasing only information sharing, interactive communication in different forms is needed. The study also suggests that behaviors of the industry sector advancing perceived trustworthiness are of crucial importance. Moreover, the wood industry needs to pay attention to its behaviors and communication also among other stakeholder groups, especially the media, as reputation plays an important role in building up trust and satisfaction between young people and the sector. Finally, the less and highly interested young people were found to assess the relationship partly through different relational elements. In order to develop the relationship with highly interested young people they should be regarded clearly as future employees of the wood industry through activities affirming that they are desired and valued employees in the sector. Further, openness of information disclosure, whether concerning current situation or future prospects, seems to increase credibility and attractiveness of the wood industry. Highly interested young people were also found to appreciate socially responsible activities. The less interested young people seem to be insecure about the reliability of the wood industry as an employer, as well as, its ability and interest to invest in young people s skills. In addition,involvement in issues relevant for young people was found crucial in enhancing the relationship with the less interested young people.The conclusions of the study provide tools for enhancing the attractiveness of the wood industry among young people not only to the industry itself, but also to its advocates, teachers and student counselors of comprehensive and vocational schools, authorities and policy makers.

Relational accountability in Indigenizing visual research for participatory communication

This article argues that an indigenous approach to communication research allows us to re-think academic approaches of engaging in and evaluating participatory communication research. It takes as its case study the Komuniti Tok Piksa project undertaken in the Highlands of Papua New Guinea. The project explores ways in which visual methods when paired with a community action approach embedded within an indigenous framework can be used to facilitate social change through meaningful participation. It involves communities to narrate their experiences in regard to HIV and AIDS and assists them in designing and recording their own messages. Local researchers are trained in using visual tools to facilitate this engagement with the communities.

Towards understanding stakeholder salience transition and relational approach to ‘better’ corporate social responsibility: a case for a proposed model in practice

Management and business literature affirm the role played by stakeholders in corporate social responsibility (CSR) practices as crucial, but what constitutes a true business–society partnership remains relatively unexplored. This paper aims to improve scholarly and management understanding beyond the usual managers’ perceptions on salience attributes, to include how stakeholders can acquire missing attributes to inform a meaningful partnership. In doing this, a model is proposed which conceptualises CSR practices and outcomes within the frameworks of stakeholder salience via empowerment, sustainable corporate social performances and partnership quality. A holistic discussion leads to generation of propositions on stakeholder salience management, corporate social performance, corporate–community partnership systems and CSR practices, which have both academic and management implications.

A relational approach to direct mail consumption

- Purpose This paper aims to investigate how direct mail consumption contributes to brand relationship quality. Store flyers and other direct mailings continue to play a significant role in many companies’ communication strategies. Research on this topic predominantly investigates driving store traffic and sales. Less is known regarding the consumer side, such as the value that consumers may derive from the consumption of direct mailings and the effects of such a value on brand relationship quality. To address this limitation, this paper tests a causal model of the contribution of direct mail value to brand commitment, drawing on a value framework that integrates social theory of engagement regimes and literature on experiential customer value. - Design/methodology/approach The empirical work of this paper is based on a rigorous four-study mixed methods design, involving qualitative study, confirmatory factor analysis and partial least squares structural modeling. - Findings The authors develop two second-order formatively designed scales – familiar value and planned value scales – that illustrate the role of engagement regimes in consumer behavior. Although both types of value contribute equally to direct mail attachment, they exert contrasting effects on other mediational consumer responses, such as reading and gratitude. Finally, the proposed theoretical model appears to be robust in predicting customers’ brand commitment. - Research limitations/implications This study provides new insights into the research on consumer value and brand relational communication. - Originality/value This study is the first to consider consumer benefits from the social perspective of engagement regimes.

Women and Marital Breakdown in South India : Reconstructing Homes, Bonds and Persons

Women and Marital Breakdown in South India: Reconstructing Homes, Bonds and Persons is an ethnographic analysis of the situation of divorced and separated women and their families in the South Indian city of Bangalore. The study is based on 16 months of anthropological fieldwork, i.e., participant observation and life history interviews among 50 divorced and separated women from different socio-religious backgrounds in their homes, in the women s organisations and in the Family Court. The study follows the divorced and separated women from their natal homes to their affinal homes through homelessness and legal battles to their reconstructed natal, affinal or single homes in order to find out what it means to be a person within hierarchical gender and kinship relations in South India. Marital breakdown impacts on kin relations and discloses the existing gender relations and power structure through its consequences. It makes the transformability of relational personhood as well as the transformability of relational society and culture visible. Although the study reveals the painful history of women s ill-treatment in marriage, family and kinship systems, it also demonstrates the women s rejection of the domination; and shows their ability to re-negotiate and promote changes not only to their own positions but to the whole hierarchical system as well. The study explores the divorced and separated women s manifold dilemmas, complicated legal battles, and endless arrangements when they have to struggle with the very practical problems of supporting themselves financially, finding and making a new home for themselves, and re-arranging relationships with their kin and friends. As marital breakdown fundamentally transforms the women s relational field, it forces them to recreate substitutive relations in a flexible way and, simultaneously, to re-construct themselves and their lives without a ready or positive cultural or behavioural template. This process reveals the agency of the divorced and separated women as well as shedding light on issues of gender and the cultural construction of the person in South India. This topical study explores the previously neglected subject of marital breakdown in India and shows the new meaning of kinship in South India.

Moral Professionalism in Interaction : Educators' Relational Moral Voices in Urban Schools

The aim of this study was to investigate educators relational moral voices in urban schools and to listen to what they told about moral professionalism and moral practices in challenging urban schools. Their relational moral voices were investigated through the following three questions: 1. What are the educators moral voices in relation to themselves and other people? 2. What are the educators moral voices in relation to their work and society? 3. What kind of interaction process lies between the educators moral voices and the urban school context? The research data of this study were gathered in four urban schools in Jyväskylä and Helsinki. The research schools were chosen for this study according to the criteria of the international Socrates Comenius project called Leading Schools Successfully in Challenging Urban Context: Strategies for Improvement. This study formed part of this project, which investigated successful urban schools as challenging learning environments in nine European countries and explored the principals success in leadership in particular. The data, which included 37 narratively constructed interviews with four principals and key informants selected by the principals, were gathered in interviews conducted in 2006. In other words, the data comprised three interviews with each of four principals, and interviews with two teachers, two parents, and two pupils from each school. In addition, the school deacon from one school was also interviewed. Furthermore, part of the data from one of the research schools included a medium report of the school deacon s work. This study combined the case study method, the narrative approach and the critical incident technique as the methodological framework. In addition, all of these methods served as practical tools for both analyzing and reporting the data. The educators' narrations and the results of the study appear in the original articles (Hanhimäki & Tirri 2008; Hanhimäki 2008b; Hanhimäki & Tirri 2009; Hanhimäki 2008a). The educators moral voices in relation to themselves and other people emerged through the main themes of moral leadership, the development and evaluation process, moral sensitivity, gender, values, and student well-being. The educators moral voices in relation to their work and society emerged through the main themes of multiprofessional cooperation, families and parental involvement, and moral school culture. The idea of moral interaction connected moral professionalism and the methodological combination of this study, which together emphasized social interaction and the creation of understanding and meaning in this interaction. The main point of this study was to state that the educators moral voices emerged in the interaction between the educators themselves and the urban school context. In this interaction, the educators moral professionalism was constructed and shaped in relation to themselves, other people, their work and society. The loudest relational moral voices heard through the main themes were those of caring, cooperation, respect, commitment, and professionalism. When the results were compared to the codes of ethics which guided these educators moral professional work, the ethical principles and values of the codes were clearly visible in their moral practices. The loudest message from the educators narration could be summarized in the words caring, respect and cooperation: at its best, there is just a human being and a human being with caring, respect and cooperation between them. The results of this study emphasize the need for practical approaches such as case studies and the narrative approach in teacher education to encourage educators to become moral professionals capable of meeting the needs of people of varied backgrounds. In addition, opportunities for moral, religious and spiritual education should be noticed and utilized in the plural interaction of urban schools when nurturing pupils and creating a moral school culture. Furthermore, multiprofessional cooperation and parents as the school s primary cooperation partner are needed to carry out the shared duty of moral education in urban schools. Keywords: moral professionalism, educator, relational moral voice, interaction, urban school

On Pushing Multilingual Query Operators into Relational Engines

To effectively support today’s global economy, database systems need to manage data in multiple languages simultaneously. While current database systems do support the storage and management of multilingual data, they are not capable of querying across different natural languages. To address this lacuna, we have recently proposed two cross-lingual functionalities, LexEQUAL[13] and SemEQUAL[14], for matching multilingual names and concepts, respectively. In this paper, we investigate the native implementation of these multilingual functionalities as first-class operators on relational engines. Specifically, we propose a new multilingual storage datatype, and an associated algebra of the multilingual operators on this datatype. These components have been successfully implemented in the PostgreSQL database system, including integration of the algebra with the query optimizer and inclusion of a metric index in the access layer. Our experiments demonstrate that the performance of the native implementation is up to two orders-of-magnitude faster than the corresponding outsidethe- server implementation. Further, these multilingual additions do not adversely impact the existing functionality and performance. To the best of our knowledge, our prototype represents the first practical implementation of a crosslingual database query engine.

Combining heterogeneous classifiers for relational databases

Practical usage of machine learning is gaining strategic importance in enterprises looking for business intelligence. However, most enterprise data is distributed in multiple relational databases with expert-designed schema. Using traditional single-table machine learning techniques over such data not only incur a computational penalty for converting to a flat form (mega-join), even the human-specified semantic information present in the relations is lost. In this paper, we present a practical, two-phase hierarchical meta-classification algorithm for relational databases with a semantic divide and conquer approach. We propose a recursive, prediction aggregation technique over heterogeneous classifiers applied on individual database tables. The proposed algorithm was evaluated on three diverse datasets. namely TPCH, PKDD and UCI benchmarks and showed considerable reduction in classification time without any loss of prediction accuracy. (C) 2012 Elsevier Ltd. All rights reserved.

Simulating grasping behavior of people using the relational description scheme

This paper presents an enhanced relational description for the prescription of the grasp requirement and evolution of the posture of a digital human hand towards satisfaction of this requirement. Precise relational description needs anatomical segmentation of the hand geometry into palmar, dorsal and lateral patches using the palm-plane and joint locations information, and operational segmentation of the object geometry into pull,push and lateral patches with due consideration to the effect of friction. Relational description identifies appropriate patches for a desired grasp condition. Satisfaction of this requirement occurs in two discrete stages,namely,contact establishment and post-contact force exertion for object capturing. Contact establishment occurs in four potentially overlapping phases,namely,re-orientation,transfer,pre- shaping,and closing-in. The novel h and re-orientation phase,enables the palm to face the object in a task sequence scenario, transfer takes the wrist to the ball park ; pre-shaping and close-in finally achieves the contact. In this paper, an anatomically pertinent closed-form formulation is presented for the closing-in phase for identification of the point of contact on the patches ,prescribed by the relational description. Since mere contact does not ensure grasp and slip phenomenon at the point of contact on application of force is a common occurrence, the effect of slip in presence of friction has been studied for 2D and 3D object grasping endeavours and a computational generation of the slip locus is presented.A general slip locus is found to be a non-linear curve even on planar faces.Two varieties of slip phenomena,namely,stabilizing and non-stabilizing slips, and their local characteristics have been identified.Study of the evolution of this slip characteristic over the slip locus exhibited diverse grasping behaviour possibilities. Thus, the relational description paradigm not only makes the requirement specification easy and meaningful but also enables high fidelity hand object interaction studies possible.

A relational contract for water demand management

For necessary goods like water, under supply constraints, fairness considerations lead to negative externalities. The objective of this paper is to design an infinite horizon contract or relational contract (a type of long-term contract) that ensures self-enforcing (instead of court-enforced) behaviour by the agents to mitigate the externality due to fairness issues. In this contract, the consumer is induced to consume at firm-supply level using the threat of higher fair price for future time periods. The pricing mechanism, computed in this paper, internalizes the externality and is shown to be economically efficient and provides revenue sufficiency.

Dynamic multi-relational Chinese restaurant process for analyzing influences on users in social media

We study the problem of analyzing influence of various factors affecting individual messages posted in social media. The problem is challenging because of various types of influences propagating through the social media network that act simultaneously on any user. Additionally, the topic composition of the influencing factors and the susceptibility of users to these influences evolve over time. This problem has not been studied before, and off-the-shelf models are unsuitable for this purpose. To capture the complex interplay of these various factors, we propose a new non-parametric model called the Dynamic Multi-Relational Chinese Restaurant Process. This accounts for the user network for data generation and also allows the parameters to evolve over time. Designing inference algorithms for this model suited for large scale social-media data is another challenge. To this end, we propose a scalable and multi-threaded inference algorithm based on online Gibbs Sampling. Extensive evaluations on large-scale Twitter and Face book data show that the extracted topics when applied to authorship and commenting prediction outperform state-of-the-art baselines. More importantly, our model produces valuable insights on topic trends and user personality trends beyond the capability of existing approaches.

Plot Erosion Model Using Gray Relational Analysis Method

The main factors affecting interrill erosion-including runoff discharge, rainfall intensity, mean flow velocity, and slope gradient-were analyzed by using a gray relational analysis. An equation for interrill erosion was derived by coupling this analysis with dimensional and regression analyses. The values of erosion rates predicted by this equation were in good agreement with experimental observations.