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.

Implementation of an interactive relational graphics database

The benefits that accrue from the use of design database include (i) reduced costs of preparing data for application programs and of producing the final specification, and (ii) possibility of later usage of data stored in the database for other applications related to Computer Aided Engineering (CAE). An INTEractive Relational GRAphics Database (INTERGRAD) based on relational models has been developed to create, store, retrieve and update the data related to two dimensional drawings. INTERGRAD provides two languages, Picture Definition Language (PDL) and Picture Manipulation Language (PML). The software package has been implemented on a PDP 11/35 system under the RSX-11M version 3.1 operating system and uses the graphics facility consisting of a VT-11 graphics terminal, the DECgraphic 11 software and an input device, a lightpen.

GRDB: A general purpose relational database system

This article discusses the design and development of GRDB (General Purpose Relational Data Base System) which has been implemented on a DEC-1090 system in Pascal. GRDB is a general purpose database system designed to be completely independent of the nature of data to be handled, since it is not tailored to the specific requirements of any particular enterprise. It can handle different types of data such as variable length records and textual data. Apart from the usual database facilities such as data definition and data manipulation, GRDB supports User Definition Language (UDL) and Security definition language. These facilities are provided through a SEQUEL-like General Purpose Query Language (GQL). GRDB provides adequate protection facilities up to the relation level. The concept of “security matrix” has been made use of to provide database protection. The concept of Unique IDentification number (UID) and Password is made use of to ensure user identification and authentication. The concept of static integrity constraints has been used to ensure data integrity. Considerable efforts have been made to improve the response time through indexing on the data files and query optimisation. GRDB is designed for an interactive use but alternate provision has been made for its use through batch mode also. A typical Air Force application (consisting of data about personnel, inventory control, and maintenance planning) has been used to test GRDB and it has been found to perform satisfactorily.

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.

The Relational Self, the Social Bond and the Dynamics of Personal Relationships : A Sociological Analysis

This study analyses personal relationships linking research to sociological theory on the questions of the social bond and on the self as social. From the viewpoint of disruptive life events and experiences, such as loss, divorce and illness, it aims at understanding how selves are bound to their significant others as those specific people ‘close or otherwise important’ to them. Who form the configurations of significant others? How do different bonds respond in disruptions and how do relational processes unfold? How is the embeddedness of selves manifested in the processes of bonding, on the one hand, and in the relational formation of the self, on the other? The bonds are analyzed from an anti-categorical viewpoint based on personal citations of significance as opposed to given relationship categories, such as ‘family’ or ‘friendship’ – the two kinds of relationships that in fact are most frequently significant. The study draws from analysis of the personal narratives of 37 Finnish women and men (in all 80 interviews) and their entire configurations of those specific people who they cite as ‘close or otherwise important’. The analysis stresses the subjective experiences, while also investigating the actualized relational processes and configurations of all personal relationships with certain relationship histories embedded in micro-level structures. The research is based on four empirical sub-studies of personal relationships and a summary discussing the questions of the self and social bond. Discussion draws from G. H. Mead, C. Cooley, N. Elias, T. Scheff, G. Simmel and the contributors of ‘relational sociology’. Sub-studies analyse bonds to others from the viewpoint of biographical disruption and re-configuration of significant others, estranged family bonds, peer support and the formation of the most intimate relationships into exclusive and inclusive configurations. All analyses examine the dialectics of the social and the personal, asking how different structuring mechanisms and personal experiences and negotiations together contribute to the unfolding of the bonds. The summary elaborates personal relationships as social bonds embedded in wider webs of interdependent people and social settings that are laden with cultural expectations. Regarding the question of the relational self, the study proposes both bonding and individuality as significant. They are seen as interdependent phases of the relationality of the self. Bonding anchors the self to its significant relationships, in which individuality is manifested, for example, in contrasting and differentiating dynamics, but also in active attempts to connect with others. Individuality is not a fixed quality of the self, but a fluid and interdependent phase of the relational self. More specifically, it appears in three formats in the flux of relational processes: as a sense of unique self (via cultivation of subjective experiences), as agency and as (a search for) relative autonomy. The study includes an epilogue addressing the ambivalence between the social expectation of individuality in society and the bonded reality of selves.

Modelling and Forecasting Property Rents and Returns (summary section only)

Recently, focus of real estate investment has expanded from the building-specific level to the aggregate portfolio level. The portfolio perspective requires investment analysis for real estate which is comparable with that of other asset classes, such as stocks and bonds. Thus, despite its distinctive features, such as heterogeneity, high unit value, illiquidity and the use of valuations to measure performance, real estate should not be considered in isolation. This means that techniques which are widely used for other assets classes can also be applied to real estate. An important part of investment strategies which support decisions on multi-asset portfolios is identifying the fundamentals of movements in property rents and returns, and predicting them on the basis of these fundamentals. The main objective of this thesis is to find the key drivers and the best methods for modelling and forecasting property rents and returns in markets which have experienced structural changes. The Finnish property market, which is a small European market with structural changes and limited property data, is used as a case study. The findings in the thesis show that is it possible to use modern econometric tools for modelling and forecasting property markets. The thesis consists of an introduction part and four essays. Essays 1 and 3 model Helsinki office rents and returns, and assess the suitability of alternative techniques for forecasting these series. Simple time series techniques are able to account for structural changes in the way markets operate, and thus provide the best forecasting tool. Theory-based econometric models, in particular error correction models, which are constrained by long-run information, are better for explaining past movements in rents and returns than for predicting their future movements. Essay 2 proceeds by examining the key drivers of rent movements for several property types in a number of Finnish property markets. The essay shows that commercial rents in local markets can be modelled using national macroeconomic variables and a panel approach. Finally, Essay 4 investigates whether forecasting models can be improved by accounting for asymmetric responses of office returns to the business cycle. The essay finds that the forecast performance of time series models can be improved by introducing asymmetries, and the improvement is sufficient to justify the extra computational time and effort associated with the application of these techniques.

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.