Object-oriented querying of existing relational databases

In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome the drawbacks of relational systems, especially the poor query facilities of SQL, we propose a schema transformation and a query translation algorithm. The schema transformation algorithm uses additional semantic information to enhance the relational schema and transform it into a corresponding object-oriented schema. If the additional semantic information can be deducted from an underlying entity-relationship design schema, the schema transformation may be done fully automatically. To query the created object-oriented schema, we use the Structured Object Query Language (SOQL) which provides declarative query facilities on objects. SOQL queries using the created object-oriented schema are much shorter, easier to write and understand and more intuitive than corresponding S Q L queries leading to an enhanced usability and an improved querying of the database. The query translation algorithm automatically translates SOQL queries into equivalent SQL queries for the original relational schema

Learning from AI : new trends in database technology

Recently some researchers in the areas of database data modelling and knowledge representations in artificial intelligence have recognized that they share many common goals. In this survey paper we show the relationship between database and artificial intelligence research. We show that there has been a tendency for data models to incorporate more modelling techniques developed for knowledge representations in artificial intelligence as the desire to incorporate more application oriented semantics, user friendliness, and flexibility has increased. Increasing the semantics of the representation is the key to capturing the "reality" of the database environment, increasing user friendliness, and facilitating the support of multiple, possibly conflicting, user views of the information contained in a database

Towards a Characterisation of Assets and Knowledge Created in Technological Agreements Some Evidence from the Automobile-Robotics Sector

This paper tries to bring new insights on the dynamics of inter-firm by focusing on cognitive and organisational dimensions. We consider the knowledge bases created inside the agreement and the characteristics of such knowledge bases (such as tacitness, level of generality, degree of centralisation...). The nature of assets for supporting this creation is also essential for the redeployability of knowledge created. We began by a brief review of some problems encountered by transactions cost economics and present some case studies of agreements between firms in the automobile and robotics sector. After having presented a taxonomy of knowledge and assets involved in such agreements, we bring some new discussion on the exploration/exploitation's dilemma. We argue finally that our taxonomy may be fruitful for a better understanding of the dynamic of firm boudaries by trying to go deeper into the "black box" of agreements.Inter-firm relations, automobile industry, technological agreements

A method for data base management and analysis for wind tunnel data

To respond to the need for improved data base management and analysis capabilities for wind-tunnel data at the Langley 16-Foot Transonic Tunnel, research was conducted into current methods of managing wind-tunnel data and a method was developed as a solution to this need. This paper describes the development of the data base management and analysis method for wind-tunnel data. The design and implementation of the software system are discussed and examples of its use are shown

Sustainable supply chain management needs sustainable logistics services. The strategic role played by logistics service providers

Purpose – The purpose of this research is to examine the concept of sustainable service co-creation in triadic business relationships in logistics and supply chain management. More companies seek to develop sustainable solutions that would not be sustainable exclusively for themselves but for the supply chain they belong to. In doing that – especially when dealing with services – they may need the external support from logistics service providers (LSPs). This paper aims to explore the innovative initiatives undertaken by LSPs in triadic relationship management with their customers and suppliers while co-creating sustainable services along the supply chain. Design/methodology/approach – To investigate the research question, a systematic literature review and empirical exploratory investigation through case study will be conducted adopting the qualitative methodology, to explore trends and evolving paradigms. Findings – A literature review conducted in this paper enriches existing literature through an integration of sustainability in a viable system approach and logistics service provision, in particular, it investigates the ways in which sustainability is achieved. It is assumed that the triadic relationship among an LSP and its customers and suppliers requires significant modifications in collaboration and an innovative approach in operating procedures. Research limitations/implications – This paper is an exploratory study and limited in its scope to an example of a relationship that focuses mainly on three actors: the supplier, the LSP and the customer. However, it could be extended in terms of numbers of case studies investigated. Practical implications – The implications arising from the literature and the empirical research offer a range of current sustainable practices in the services sector. This could be a starting point for other research and company activities. Originality/value – There is little research that addresses the issue of sustainability and logistics service providers simultaneously, hence the present paper is meant to fill the gap by providing a foundation which actors of different supply chains could use as a benchmark. This study gives evidence of how logistics services may contribute to sustainable development. Key words – sustainable supply chain management, logistics service providers, viable system approach, co-creation, business relationship managemen

The load shedding advisor: An example of a crisis-response expert system

A Prolog-based prototype expert system is described that was implemented by the Network Operations Branch of the NASA Goddard Space Flight Center. The purpose of the prototype was to test whether a small, inexpensive computer system could be used to host a load shedding advisor, a system which would monitor major physical environment parameters in a computer facility, then recommend appropriate operator reponses whenever a serious condition was detected. The resulting prototype performed significantly to efficiency gains achieved by replacing a purely rule-based design methodology with a hybrid approach that combined procedural, entity-relationship, and rule-based methods