Should optional properties be used in conceptual modelling? A theory and three empirical tests

An important feature of some conceptual modelling grammars is the features they provide to allow database designers to show real-world things may or may not possess a particular attribute or relationship. In the entity-relationship model, for example, the fact that a thing may not possess an attribute can be represented by using a special symbol to indicate that the attribute is optional. Similarly, the fact that a thing may or may not be involved in a relationship can be represented by showing the minimum cardinality of the relationship as zero. Whether these practices should be followed, however, is a contentious issue. An alternative approach is to eliminate optional attributes and relationships from conceptual schema diagrams by using subtypes that have only mandatory attributes and relationships. In this paper, we first present a theory that led us to predict that optional attributes and relationships should be used in conceptual schema diagrams only when users of the diagrams require a surface-level understanding of the domain being represented by the diagrams. When users require a deep-level understanding, however, optional attributes and relationships should not be used because they undermine users' abilities to grasp important domain semantics. We describe three experiments which we then undertook to test our predictions. The results of the experiments support our predictions.

Research output of Australian general practice: A comparison with medicine, surgery and public health

Objectives: To compare the productivity of Australian general practice in terms of research publications with the productivity of other medical disciplines. Design: A survey of Australian general practice, medicine, surgery and public health publications carried out by manual searching of specific journals and an electronic search of the US National Library of Medicine's PubMed database. Main outcome measures: The number of original research publications by Australian general practitioners, physicians, surgeons and public health physicians during 1999; the relative publication rate of Australian general practice, medicine, surgery and public health over the period 1990-1999. Results: Of original research articles published in 1999, GPs authored 65% (17/26) in Australian Family Physician and 3% (3/90) in the Medical Journal of Australia; physicians published 4% and 37%, respectively. The electronic search identified 54 research articles relating to Australian general practice published in 1999 in 21 different journals, only two of which were primary care journals. Over the period 1990-1999, there was a publication rate of one general practice [discipline] article per 1000 GPs in practice per year. Corresponding rates for medicine, surgery and public health were 105/1000, 61/1000 and 148/1000, respectively. Conclusions: There is considerable disparity between the level of research output of general practice and that of the disciplines of medicine, surgery and public health. If we are to have effective general practice research, we urgently need to develop research skills, a supportive infrastructure and a culture that nurtures research.

Health services research using linked records: who consents and what is the gain?

Objective: To assess consent to record linkage, describe the characteristics of consenters and compare self-report versus Medicare records of general practitioner use. Method. Almost 40,000 women in the Australian Longitudinal Study on Women's Health were sent a request by mail for permission to link their Medicare records and survey data. Results: 19,700 women consented: 37% of young (18-23 years), 59% of mid-age (4550 years) and 53% of older women (70-75 years). Consenters tended to have higher levels of education and, among the older cohort, were in better health than nonconsenters. Women tended to under-report the number of visits to general practitioners. Conclusions: Record linkage of survey and Medicare data on a large scale is feasible. The linked data provide information on health and socio-economic status which are valuable for understanding health service utilisation. Implications: Linked records provide a powerful tool for health care research, particularly in longitudinal studies.

Identification of an apolipoprotein(e) variant associated with type III hyperlipoproteinaemia in an indigenous Australian

As a result of testing for lipid and apolipoprotein(e) (apo E) phenotype status of an indigenous Australian community, an apo E variant associated with type III hyperlipoproteinaemia has been identified. Apo E phenotype was determined by analysis of VLDL by isoelectric focusing, and genotype on DNA amplified by polymerase chain reaction, using two different restriction enzyme isotyping assays. Phenotypes and genotypes were discordant in samples from two subjects and an abnormal-sized restriction fragment was also observed in their genotyping gel patterns. DNA sequencing studies revealed this was due to a single nucleotide deletion. 3817delC, at amino acid 136 on apo E. This resulted in a new reading frame and the premature termination of the apo E protein due to a stop codon (TGA) at nucleotide 4105. The variant apo E null allele showed a recessive mode of inheritance and, in combination with the E2 allele, resulted in the type III hyperlipoproteinaemic phenotype but when inherited with the E4 allele had no marked effect on plasma lipids.