Identifying New Directions in Database Performance Tuning

Database performance tuning is a complex and varied active research topic. With enterprise relational database management systems still reliant on the same set-based relational concepts that defined early data management products, the disparity between the object-oriented application development model and the object-relational database model, called the object-relational impedance mismatch problem, is addressed by techniques such as object-relational mapping (ORM). However, this has resulted in generally poor query performance for SQL developed by object applications and an irregular fit with cost-based optimisation algorithms, and leads to questions about the need for the relational model to better adapt to ORM-generated queries. This paper discusses database performance optimisation developments and seeks to demonstrate that current database performance tuning approaches need re-examination. Proposals for further work include exploring concepts such as dynamic schema redefinition; query analysis and optimisation modelling driven by machine learning; and augmentation or replacement of the cost-based optimiser model

A grammar of business rules in Information Systems

There are many situations during information system development (ISD) where there is a need to do modelling on a business level before more detailed and robust modelling are done on the technical system level. Most business level modelling uses some form of natural language constructs which are, on the one hand, easy to use by untrained users, but which are too vague and ambiguous to be used in subsequent systems level modelling by systems analysts, on the other hand. The goal of this article is to suggest a subset of morphology, syntax and semantics concepts that may be used to analyse texts containing business rules during Information Systems analysis and design. The contribution of this research is to provide a better understanding of the fundamental entities in business and ISD modelling and their relationships in order to improve informal, mostly textual, business modelling.This article is based on a chapter from a PhD thesis by Pieter Joubert (Towards an integrative modelling technique between business and information systems development) who graduated posthumously in the Department of Informatics at the University of Pretoria on 4 September 2013. (http://repository.up.ac.za/handle/2263/31630)http://www.td-sa.net/http://repository.up.ac.za/handle/2263/31630am201

Langage contrôlé pour la spécification des règles métier dans le contexte de la modélisation des systèmes d'information

Our thesis focuses on controlled natural languages (CNL) for software engineering. It aims at facilitating the adoption of the business rule approach (BRA) by companies by creating a CNL in order to help business experts in the specification of their business rules. Our solution will allow reducing the semantic gap between business experts and system experts to meet not only the need for mutual understanding between them but also to achieve an automatic transfer of the description of business rules to information systems (IS). The CNL that we have created will also ensure the consistency and the traceability of these rules together with their implementationNotre thèse s’inscrit dans le cadre des langages contrôlés pour le génie logiciel. Elle a pour but de faciliter l’adoption de l’approche par règles métier (ARM) par les entreprises en créant un langage contrôlé en vue d’aider à la spécification des règles métier par les experts métier. Notre solution va permettre de réduire la distance sémantique entre les experts métier et les experts système afin de répondre non seulement au besoin d’intercompréhension entre ces derniers mais aussi pour réaliser un transfert automatique de la description des règles métier vers les systèmes d’information (SI). Ce langage contrôlé que nous avons créé permettra d’assurer en plus la consistance et la traçabilité de ces règles avec leur implantatio

A holistic view of the social and technical factors that Influence the assimilation of an mHealth tool in developing countries

The integration of smartphones and mobile devices into healthcare systems has been proposed to address some of the physical barriers to healthcare delivery in rural areas of developing countries. This has prompted a number of intervention initiatives to develop novel mHealth tools for specific regions. However, despite all the research and the investment, there has been slow practical progress. This thesis attributes this slow progress to compartmentalised thinking and limited holistic exploration. In order to understand these problems, this thesis undertook a number of studies, i.e., a review-focused, a past-focused, a future-focused, and policy-focused studies to understand how an mHealth tool could be assimilated in rural areas of developing countries. These studies took place in the context of an mHealth app being explored for introduction to assist with the diagnosis and treatment of sick children under the age of five in Enugu State, Nigeria. Therefore, the objective of this thesis is to create a more socially and technologically holistic understanding of the factors that influence the introduction of mHealth tools into rural areas of developing countries. First, findings from the review-focused study illustrate two key trends in existing research. Most strikingly, little research has looked at the role of patient-to-patient interactions. Furthermore, the interactions between system developers and the other stakeholder groups are notably under-represented. Second, findings from the past-focused study indicate that, (i) at the social-level, there is a perceived limitation of services, human resources and a sense of exclusion from the urban health system; (ii) at ‘material-level, observations were made of the significant infrastructural and technological limitations that discourage rural healthcare workers (RHCWs) and parents/guardians (PGs) from spending prolonged periods at the rural health centres; (iii) at the ‘practice-level’, there is the formal diagnosis treatment method practiced by the RHCWs in the midst of the PGs diagnosis and treatment practices and African traditional healing practices, and (iv) at ‘imbrication-level’, the entanglement of phones with internet access have exposed PGs to a range of health information outside the control or guidance of health professionals. Third, from the future-focused study, findings show a set of factors which are bound as an emerging explanatory model which influence primary appraisal of an mHealth tool in a new context. These factors describe a set of individual and social influences that governments, funding bodies and non-governmental organisations should consider before the introduction of an mHealth tool. Fourth, from the policy-focused study, a framework is proposed that differentiates between interventions targeting traits and states, the latter being situation-specific, and the former which seeks to improve individual’s abilities, job knowledge, and skills as they relate to an mHealth tool. Furthermore, the framework differentiates between individual and social interventions, the former being resilient to personnel change, and the latter seeking to improve crucial situations that would otherwise cause social systems to break down around an mHealth tool. These findings have implications for theory, practice, and future research. These implications are discussed in the final chapter of this thesis