Rules for mapping a conceptual model onto various data base management systems. Available in 2 volumes.

The design and implementation of data bases involve, firstly, the formulation of a conceptual data model by systematic analysis of the structure and information requirements of the organisation for which the system is being designed; secondly, the logical mapping of this conceptual model onto the data structure of the target data base management system (DBMS); and thirdly, the physical mapping of this structured model into storage structures of the target DBMS. The accuracy of both the logical and physical mapping determine the performance of the resulting systems. This thesis describes research which develops software tools to facilitate the implementation of data bases. A conceptual model describing the information structure of a hospital is derived using the Entity-Relationship (E-R) approach and this model forms the basis for mapping onto the logical model. Rules are derived for automatically mapping the conceptual model onto relational and CODASYL types of data structures. Further algorithms are developed for partly automating the implementation of these models onto INGRES, MIMER and VAX-11 DBMS.

Business cycles, long waves, and company langevity in Birmingham area metal industries 1780-1980

This doctoral thesis originates from an observational incongruence between the perennial aims and aspirations of economic endeavour and actually recorded outcomes, which frequently seem contrary to those intended and of a recurrent, cyclical type. The research hypothesizes parallel movement between unstable business environments through time, as expressed by periodically fluctuating levels of economic activity, and the precipitation rates of industrial production companies. A major problem arose from the need to provide theoretical and empirical cohesion from the conflicting, partial and fragmented interpretations of several hundred historians and economists, without which the research question would remain unanswerable. An attempt to discover a master cycle, or superimposition theorem, failed, but was replaced by minute analysis of both the concept of cycles and their underlying data-bases. A novel technique of congregational analysis emerged, resulting in an integrated matrix of numerical history. Two centuries of industrial revolution history in England and Wales was then explored and recomposed for the first time in a single account of change, thereby providing a factual basis for the matrix. The accompanying history of the Birmingham area provided the context of research into the failure rates and longevities of firms in the city's staple metal industries. Sample specific results are obtained for company longevities in the Birmingham area. Some novel presentational forms are deployed for results of a postal questionnaire to surviving firms. Practical demonstration of the new index of national economic activity (INEA) in relation to company insolvencies leads to conclusions and suggestions for further applications of research into the tempo of change, substantial Appendices support the thesis and provide a compendium of information covering immediately contiguous domains.

Knowledge elicitation and knowledge representation in a large domain with multiple experts

This paper describes the knowledge elicitation and knowledge representation aspects of a system being developed to help with the design and maintenance of relational data bases. The size algorithmic components. In addition, the domain contains multiple experts, but any given expert's knowledge of this large domain is only partial. The paper discusses the methods and techniques used for knowledge elicitation, which was based on a "broad and shallow" approach at first, moving to a "narrow and deep" one later, and describes the models used for knowledge representation, which were based on a layered "generic and variants" approach. © 1995.