Facilitating evolution in relational database design : a procedure to evaluate and refine novice database designers' schemata : a thesis presented in partial fulfilment of the requirements for the degree of Master of Business Studies in Information Systems at Massey University

Relational database management systems (RDBMS) have become widely used by many industries in recent years. Latterly these systems have begun to expand their market by becoming readily available at minimal cost to most users of modern computing technology. The quality of applications developed from RDBMSs however is largely dependent upon the quality of the underlying schema. This research looks at the area of schema design and in particular schemata designed by people who have a minimal understanding of relational concepts. It uses a survey and case studies to help define some of the issues involved in the area. A procedure to modify existing schemata is described, and the schema from one of the case studies used to apply the schema re-design procedure to a real database design. The results are compared to the original schema as well as a schema designed using a conventional application of the NIAM analysis and design methodology. The research supports the hypothesis that database applications based on schemata designed by lay-persons are currently being used to support business data management requirements. The utility, reliability and longevity of these applications depend to some extent on the quality of the underlying schema and its ability to store the required data and maintain that data's integrity. The application of the schema re-design procedure presented in this thesis reveals refinements on the original schema and provides a method for lay-persons to evaluate and improve existing database designs. A number of issues and questions related to the focus of this research are raised and, although outside the scope of the research, are noted as suggestions for further work

Bottom-up constructions of top-down transformational change : change leader interventions and qualitative schema change in a spatially differentiated technically-oriented public professional bureaucracy

In the face of knowledge deficits in and poor outcome assessments of Organisation Transformation (OT), there is a need for a better understanding of the relationship between change leader interventions and qualitative organisational schema change, the collective knowledge structures that must be replaced or significantly elaborated if OT is to be realised. Previous research on this relationship has (a) focused on imposed structural interventions and given little attention to large-scale human process interventions, (b) given little attention to the radical structural interventions frequently involved in the transformation of public organisations, (c) given little scrutiny to how organisational schema have been conceptualised, (d) given little scrutiny to recent propositions on schema change dynamics that may be contentious, and (e) given little consideration to the change management contexts in which leader influence may be neutralised. In the light of these gaps in the literature, this thesis investigates, from the perspective of change recipients, the relationship between complex large-scale change leader interventions and qualitative organisational schema change in change management contexts thought to be inimical to leader influence. In particular, how efficacious are change leader interventions in realising qualitative organisational schema change in such contexts? An interpretive longitudinal case study design was used to address this question. The case organisation is a spatially differentiated technically-oriented public Professional Bureaucracy located in Queensland. In this context, this thesis investigates, over a three-year period, the creation and evolution of three schema change contexts, or change trajectories, created by two temporally disconnected yet functionally inter-related change leader interventions. Data collection techniques included focus group interviews, semi-structured interviews, and secondary sources. Data were collected from several sites, including Head Office functions and Regional and District offices, across Queensland. Data were collected on four occasions across the three-year period from early 2000 to late 2002. The results reveal that (a) while there are no panaceas, public managers need more sophisticated intervention theories based on a knowledge of the relative efficacy of different interventions rather than relying on, predominantly, structural interventions, (b) viewing organisational schema in one-dimensional rather than multidimensional terms masks both the complexity of organisational schema change and the possibility of partial rather than configurational schema change, (c) while inter-schema conflict or dialectical processes were apparent, successful schema change was better explained by teleological processes than by dialectical processes, and (d) change leaders can have a powerful influence on OT in change management contexts thought to be inimical to change leader influence yet their influence is linked to high investments of time and effort

ADEPT2 - Next Generation Process Management Technology

If current process management systems shall be applied to a broad spectrum of applications, they will have to be significantly improved with respect to their technological capabilities. In particular, in dynamic environments it must be possible to quickly implement and deploy new processes, to enable ad-hoc modifications of single process instances at runtime (e.g., to add, delete or shift process steps), and to support process schema evolution with instance migration, i.e., to propagate process schema changes to already running instances. These requirements must be met without affecting process consistency and by preserving the robustness of the process management system. In this paper we describe how these challenges have been addressed and solved in the ADEPT2 Process Management System. Our overall vision is to provide a next generation process management technology which can be used in a variety of application domains

Component Approach to Software Development for Distributed Multi-Database System

The paper deals with a component based approach for software development in a distributed environment for the database retrieval operations. A Core Component for a distributed multi-database system has been proposed. The core Component is modeled using three interfaces User, Administrator and Databases Handler. The User Interface is the starting point of access for the Core Component. The Administrator interface deals with access control privileges for users and local databases. The Database Handler facilitates global schema management and site management.Assertion, Core Component, Component Based Software Development, Multi-Database, Schema

Self-Schema, Self-Concept, and Principal Role of Conflict Management Styles at Workplace

The purpose of current literature review is to classify the crucial role of styles of conflict management at workplace, and their effects on self-schema and self-concept of employees. The outcomes of this study establish the conflict management styles that have fundamental contribution on employees’ self-schema and self-concept at workplace. As well, the present investigation concentrated on styles of conflict management as main organizational factors; and their effect on behavior, attitude, performance, and reaction of employees. Moreover, lack of attention to these styles lead to reductions of employees’ engagement, performance, and presentation at work environment. Therefore, this research supports employees’ attitude and behavior regarding styles of conflict management; and their relation with self-schema and self-concept. Keywords: conflict management styles, employees, self-concept, self-schema, workplace

Combining Provenance Management and Schema Evolution

The combination of provenance management and schema evolution using the CHASE algorithm is the focus of our research in the area of research data management. The aim is to combine the construc- tion of a CHASE inverse mapping to calculate the minimal part of the original database — the minimal sub-database — with a CHASE-based schema mapping for schema evolution

Schema evolution in the star framework

The STAR data model supports the definition of object schemata, according either to some design methodology or to the designer's decision. Object schemata allow a flexible management of the various representations that are created during the design of a particular object. Object schemata can evolve or even be dynamically defined, departing from an existing object schema and making changes to it. Schema evolution facilities are a valuable support for both the definition of new design objects and design methodology management. Schema evolution is maintained through versions, so that version management is applied not only to design objects themselves, but also to object schemata. Consistency is guaranteed for schema operations, based on a set of invariant rules