Design and evaluation of a consulting system for database design

Database design is a difficult problem for non-expert designers. It is desirable to assist such designers during the problem solving process by means of a knowledge based (KB) system. A number of prototype KB systems have been proposed, however there are many shortcomings. Few have incorporated sufficient expertise in modeling relationships, particularly higher order relationships. There has been no empirical study that experimentally tested the effectiveness of any of these KB tools. Problem solving behavior of non-experts, whom the systems were intended to assist, has not been one of the bases for system design. In this project a consulting system for conceptual database design that addresses the above short comings was developed and empirically validated.^ The system incorporates (a) findings on why non-experts commit errors and (b) heuristics for modeling relationships. Two approaches to knowledge base implementation--system restrictiveness and decisional guidance--were used and compared in this project. The Restrictive approach is proscriptive and limits the designer's choices at various design phases by forcing him/her to follow a specific design path. The Guidance system approach which is less restrictive, provides context specific, informative and suggestive guidance throughout the design process. The main objectives of the study are to evaluate (1) whether the knowledge-based system is more effective than a system without the knowledge-base and (2) which knowledge implementation--restrictive or guidance--strategy is more effective. To evaluate the effectiveness of the knowledge base itself, the two systems were compared with a system that does not incorporate the expertise (Control).^ The experimental procedure involved the student subjects solving a task without using the system (pre-treatment task) and another task using one of the three systems (experimental task). The experimental task scores of those subjects who performed satisfactorily in the pre-treatment task were analyzed. Results are (1) The knowledge based approach to database design support lead to more accurate solutions than the control system; (2) No significant difference between the two KB approaches; (3) Guidance approach led to best performance; and (4) The subjects perceived the Restrictive system easier to use than the Guidance system. ^

A methodology to select an enterprise resource planning system for a small or medium sized enterprise

Enterprise Resource Planning (ERP) systems are software programs designed to integrate the functional requirements, and operational information needs of a business. Pressures of competition and entry standards for participation in major manufacturing supply chains are creating greater demand for small business ERP systems. The proliferation of new offerings of ERP systems introduces complexity to the selection process to identify the right ERP business software for a small and medium-sized enterprise (SME). The selection of an ERP system is a process in which a faulty conclusion poses a significant risk of failure to SME’s. The literature reveals that there are still very high failure rates in ERP implementation, and that faulty selection processes contribute to this failure rate. However, the literature is devoid of a systematic methodology for the selection process for an ERP system by SME’s. This study provides a methodological approach to selecting the right ERP system for a small or medium-sized enterprise. The study employs Thomann’s meta-methodology for methodology development; a survey of SME’s is conducted to inform the development of the methodology, and a case study is employed to test, and revise the new methodology. The study shows that a rigorously developed, effective methodology that includes benchmarking experiences has been developed and successfully employed. It is verified that the methodology may be applied to the domain of users it was developed to serve, and that the test results are validated by expert users and stakeholders. Future research should investigate in greater detail the application of meta-methodologies to supplier selection and evaluation processes for services and software; additional research into the purchasing practices of small firms is clearly needed.^

Intelligent retrieval system for conditions of contract documents in construction

The outcome of this research is an Intelligent Retrieval System for Conditions of Contract Documents. The objective of the research is to improve the method of retrieving data from a computer version of a construction Conditions of Contract document. SmartDoc, a prototype computer system has been developed for this purpose. The system provides recommendations to aid the user in the process of retrieving clauses from the construction Conditions of Contract document. The prototype system integrates two computer technologies: hypermedia and expert systems. Hypermedia is utilized to provide a dynamic way for retrieving data from the document. Expert systems technology is utilized to build a set of rules that activate the recommendations to aid the user during the process of retrieval of clauses. The rules are based on experts knowledge. The prototype system helps the user retrieve related clauses that are not explicitly cross-referenced but, according to expert experience, are relevant to the topic that the user is interested in.

Design and evaluation of a consulting system for database design

Database design is a difficult problem for non-expert designers. It is desirable to assist such designers during the problem solving process by means of a knowledge based (KB) system. Although a number of prototype KB systems have been proposed, there are many shortcomings. Firstly, few have incorporated sufficient expertise in modeling relationships, particularly higher order relationships. Secondly, there does not seem to be any published empirical study that experimentally tested the effectiveness of any of these KB tools. Thirdly, problem solving behavior of non-experts, whom the systems were intended to assist, has not been one of the bases for system design. In this project, a consulting system, called CODA, for conceptual database design that addresses the above short comings was developed and empirically validated. More specifically, the CODA system incorporates (a) findings on why non-experts commit errors and (b) heuristics for modeling relationships. Two approaches to knowledge base implementation were used and compared in this project, namely system restrictiveness and decisional guidance (Silver 1990). The Restrictive system uses a proscriptive approach and limits the designer's choices at various design phases by forcing him/her to follow a specific design path. The Guidance system approach, which is less restrictive, involves providing context specific, informative and suggestive guidance throughout the design process. Both the approaches would prevent erroneous design decisions. The main objectives of the study are to evaluate (1) whether the knowledge-based system is more effective than the system without a knowledge-base and (2) which approach to knowledge implementation - whether Restrictive or Guidance - is more effective. To evaluate the effectiveness of the knowledge base itself, the systems were compared with a system that does not incorporate the expertise (Control). An experimental procedure using student subjects was used to test the effectiveness of the systems. The subjects solved a task without using the system (pre-treatment task) and another task using one of the three systems, viz. Control, Guidance or Restrictive (experimental task). Analysis of experimental task scores of those subjects who performed satisfactorily in the pre-treatment task revealed that the knowledge based approach to database design support lead to more accurate solutions than the control system. Among the two KB approaches, Guidance approach was found to lead to better performance when compared to the Control system. It was found that the subjects perceived the Restrictive system easier to use than the Guidance system.

Combined effects of short-term exposure to elevated CO2 and decreased O2 on the physiology and energy budget of the thick shell mussel Mytilus coruscus

Hypoxia and ocean acidification are two consequences of anthropogenic activities. These global trends occur on top of natural variability. In environments such as estuarine areas, short-term acute pH and O2 fluctuations are occurring simultaneously. The present study tested the combined effects of short-term seawater acidification and hypoxia on the physiology and energy budget of the thick shell mussel Mytilus coruscus. Mussels were exposed for 72 h to six combined treatments with three pH levels (8.1, 7.7 and 7.3) and two dissolved oxygen (DO) levels (2 mg/L, 6 mg/L). Clearance rate (CR), food absorption efficiency (AE), respiration rate (RR), ammonium excretion rate (ER), O:N ratio and scope for growth (SFG) were significantly reduced, and faecal organic dry weight ratio (E) was significantly increased at low DO. Low pH did not lead to a reduced SFG. Interactive effects of pH and DO were observed for CR, E and RR. Principal component analysis (PCA) revealed positive relationships among most physiological indicators, especially between SFG and CR under normal DO conditions. These results demonstrate that Mytilus coruscus was sensitive to short-term (72 h) exposure to decreased O2 especially if combined with decreased pH levels. In conclusion, the short-term oxygen and pH variation significantly induced physiological changes of mussels with some interactive effects.

Physiological energetics of the thick shell mussel Mytilus coruscus exposed to seawater acidification and thermal stress

Anthropogenic CO2 emissions have caused seawater temperature elevation and ocean acidification. In view of both phenomena are occurring simultaneously, their combined effects on marine species must be experimentally evaluated. The purpose of this study was to estimate the combined effects of seawater acidification and temperature increase on the energy budget of the thick shell mussel Mytilus coruscus. Juvenile mussels were exposed to six combined treatments with three pH levels (8.1, 7.7 and 7.3) * two temperatures (25 °C and 30 °C) for 14 d. We found that clearance rates (CRs), food absorption efficiencies (AEs), respiration rates (RRs), ammonium excretion rates (ER), scope for growth (SFG) and O:N ratios were significantly reduced by elevated temperature sometimes during the whole experiments. Low pH showed significant negative effects on RR and ER, and significantly increased O:N ratios, but showed almost no effects on CR, AE and SFG of M. coruscus. Nevertheless, their interactive effects were observed in RR, ER and O:N ratios. PCA revealed positive relationships among most physiological indicators, especially between SFG and CR under normal temperatures compared to high temperatures. PCA also showed that the high RR was closely correlated to an increasing ER with increasing pH levels. These results suggest that physiological energetics of juvenile M. coruscus are able to acclimate to CO2 acidification with a little physiological effect, but not increased temperatures. Therefore, the negative effects of a temperature increase could potentially impact the ecophysiological responses of M. coruscus and have significant ecological consequences, mainly in those habitats where this species is dominant in terms of abundance and biomass.

Structural, stratigraphic and sedimentological characterisation of a wide rift system : The Triassic rift system of the Central Atlantic Domain

Acknowledgments The authors would like to thank Shell E&P Rijswijk, for supporting this research. The authors are grateful to Pat Shannon, Catherine Baudon and Dominique Frizon de Lamotte for many discussions on rift processes. We would like to thank Steven Bergman for thorough comments on an early version of the paper, and Chris Morley and an anonymous reviewer for sharing ideas and references for writing a better paper

International expert opinion on the management of infection caused by azole-resistant Aspergillus fumigatus

Acknowledgements We thank Gilead Sciences Europe Ltd., UK for financially supporting logistical aspects of this study. The logistics of the meeting were handled by Congress Care, Den Bosch, The Netherlands. The sponsor was not involved in the selection of the participants or procedures, or in the discussion, data collection, analysis or writing of the manuscript. The medical writer was financially supported by the Dutch Society for Medical Mycology and the Department of Medical Microbiology, Radboud University Medical Centre, Nijmegen, The Netherlands.

Modulating membership grades to gain consensus for fuzzy set uncertainty values in a clinical decision support system

This paper deals with a very important issue in any knowledge engineering discipline: the accurate representation and modelling of real life data and its processing by human experts. The work is applied to the GRiST Mental Health Risk Screening Tool for assessing risks associated with mental-health problems. The complexity of risk data and the wide variations in clinicians' expert opinions make it difficult to elicit representations of uncertainty that are an accurate and meaningful consensus. It requires integrating each expert's estimation of a continuous distribution of uncertainty across a range of values. This paper describes an algorithm that generates a consensual distribution at the same time as measuring the consistency of inputs. Hence it provides a measure of the confidence in the particular data item's risk contribution at the input stage and can help give an indication of the quality of subsequent risk predictions. © 2010 IEEE.

Seawater carbonate chemistry and Bathymodiolus brevior shell variables near Eifuku volcano, Japan, 2009

Increasing atmospheric carbon dioxide levels are causing ocean acidification, compromising the ability of some marine organisms to build and maintain support structures as the equilibrium state of inorganic carbon moves away from calcium carbonate. Few marine organisms tolerate conditions where ocean pH falls significantly below today's value of about 8.1 and aragonite and calcite saturation values below 1. Here we report dense clusters of the vent mussel B. brevior in natural conditions of pH values between 5.36 and 7.29 on northwest Eifuku volcano, Mariana arc, where liquid carbon dioxide and hydrogen sulphide emerge in a hydrothermal setting. We find that both shell thickness and daily growth increments in shells from northwest Eifuku are only about half those recorded from mussels living in water with pH>7.8. Low pH may therefore also be implicated in metabolic impairment. We identify four-decade-old mussels, but suggest that the mussels can survive for so long only if their protective shell covering remains intact: crabs that could expose the underlying calcium carbonate to dissolution are absent from this setting. The mussels' ability to precipitate shells in such low-pH conditions is remarkable. Nevertheless, the vulnerability of molluscs to predators is likely to increase in a future ocean with low pH.

Seawater carbonate chemistry, calcification and shell size of hard clam Mercenaria mercenaria during experiments, 2011

Increasing atmospheric carbon dioxide threatens to decrease pH in the world's oceans. Coastal and estuarine calcifying organisms of significant ecological and economical importance are at risk; however, several biogeochemical processes drive pH in these habitats. In particular, coastal and estuarine sediments are frequently undersaturated with respect to calcium carbonate due to high rates of organic matter remineralization, even when overlying waters are saturated. As a result, the post-larval stages of infaunal marine bivalves must be able to deposit new shell material in conditions that are corrosive to shell. We measured calcification rates on the hard clam, Mercenaria spp.,in 5 post-larval size classes (0.39, 0.56, 0.78, 0.98, and 2.90 mm shell height) using the alkalinity anomaly method. Acidity of experimental water was controlled by bubbling with air-CO2 blends to obtain pH values of 8.02, 7.64, and 7.41, corresponding to pCO2 values of 424, 1120, and 1950 µatm. These pH values are typical of those found in many near-shore terrigenous marine sediments. Our results show that calcification rate decreased with lower pH in all 5 size classes measured. We also found a significant effect of size on calcification rate, with the smaller post-larval sizes unable to overcome dissolution pressure. Increased calcification rate with size allowed the larger sizes to overcome dissolution pressure and deposit new shell material under corrosive conditions. Size dependency of pH effects on calcification is likely due to organogenesis and developmental shifts in shell mineralogy occurring through the post-larval stage. Furthermore, we found significantly different calcification rates between the 2 sources of hard clams we used for these experiments, most likely due to genotypic differences. Our findings confirm the susceptibility of the early life stages of this important bivalve to decreasing pH and reveal mechanisms behind the increased mortality in post-larval juvenile hard clams related to dissolution pressure, that has been found in previous studies.

Seawater carbonate chemistry and shell length of Mediterranean pteropod Cavolinia inflexa larvae during experiments

Larvae of the Mediterranean pteropod Cavolinia inflexa were maintained at controlled pHT values of 8.1, 7.82 and 7.51, equivalent respectively to pCO2 levels of 380, 857 and 1713 µatm. At pHT 7.82 larvae exhibited malformations and lower shell growth, compared to the control condition. At pHT 7.51 the larvae did not make shells but were viable and showed a normal development. However, smaller shells or no shells will have both ecological (food web) and biogeochemical (export of carbon and carbonate) consequences. These results confirm that 1pteropods, as well as the species dependent upon them as a food resource, will be severely impacted by ocean acidification.

Seawater carbonate chemistry and conditions of Mytilus edulis extracellular body fluids and shell composition in a pH-treatment experiment: Acid-base status, trace elements and delta11B, 2012

Mytilus edulis were cultured for 3 months under six different seawater pCO2 levels ranging from 380 to 4000 µatm. Specimen were taken from Kiel Fjord (Western Baltic Sea, Germany) which is a habitat with high and variable seawater pCO2 and related shifts in carbonate system speciation (e.g., low pH and low CaCO3 saturation state). Hemolymph (HL) and extrapallial fluid (EPF) samples were analyzed for pH and total dissolved inorganic carbon (CT) to calculate pCO2 and [HCO3]. A second experiment was conducted for 2 months with three different pCO2 levels (380, 1400 and 4000 µatm). Boron isotopes (delta11B) were investigated by LA-MC-ICP-MS (Laser Ablation-Multicollector-Inductively Coupled Plasma-Mass Spectrometry) in shell portions precipitated during experimental treatment time. Additionally, elemental ratios (B/Ca, Mg/Ca and Sr/Ca) in the EPF of specimen from the second experiment were measured via ICP-OES (Inductively Coupled Plasma-Optical Emission Spectrometry). Extracellular pH was not significantly different in HL and EPF but systematically lower than ambient water pH. This is due to high extracellular pCO2 values, a prerequisite for metabolic CO2 excretion. No accumulation of extracellular [HCO3] was measured. Elemental ratios (B/Ca, Mg/Ca and Sr/Ca) in the EPF increased slightly with pH which is in accordance with increasing growth and calcification rates at higher seawater pH values. Boron isotope ratios were highly variable between different individuals but also within single shells. This corresponds to a high individual variability in fluid B/Ca ratios and may be due to high boron concentrations in the organic parts of the shell. The mean delta11B value shows no trend with pH but appears to represent internal pH (EPF) rather than ambient water pH.

Economic crisis and national health system

The text analyzes the impact of the economic crisis in some critical aspects of the National Health System: outcomes, health expenditure, remuneration policy and privatization through Private Public Partnership models. Some health outcomes related to social inequalities are worrying. Reducing public health spending has increased the fragility of the health system, reduced wage income of workers in the sector and increased heterogeneity between regions. Finally, the evidence indicates that privatization does not mean more efficiency and better governance. Deep reforms are needed to strengthen the National Health System.