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.

Computer-aided tool for the teaching of relational algebra in data base courses

This article describes the design and implementation of computer-aided tool called Relational Algebra Translator (RAT) in data base courses, for the teaching of relational algebra. There was a problem when introducing the relational algebra topic in the course EIF 211 Design and Implementation of Databases, which belongs to the career of Engineering in Information Systems of the National University of Costa Rica, because students attending this course were lacking profound mathematical knowledge, which led to a learning problem, being this an important subject to understand what the data bases search and request do RAT comes along to enhance the teaching-learning process.It introduces the architectural and design principles required for its implementation, such as: the language symbol table, the gramatical rules and the basic algorithms that RAT uses to translate from relational algebra to SQL language. This tool has been used for one periods and has demonstrated to be effective in the learning-teaching process.  This urged investigators to publish it in the web site: www.slinfo.una.ac.cr in order for this tool to be used in other university courses.

Elemental abundances and classification of carbon-enhanced metal-poor stars

We present a detailed study of carbon-enhanced metal-poor (CEMP) stars, based on high-resolution spectroscopic observations of a sample of 18 stars. The stellar spectra for this sample were obtained at the 4.2 m William Herschel Telescope in 2001 and 2002, using the Utrecht Echelle Spectrograph, at a resolving power R similar to 52 000 and S/N similar to 40, covering the wavelength range lambda lambda 3700-5700 angstrom. The atmospheric parameters determined for this sample indicate temperatures ranging from 4750 K to 7100 K, log g from 1.5 to 4.3, and metallicities -3.0 <= [Fe/H]<=-1.7. Elemental abundances for C, Na, Mg, Sc, Ti, Cr, Cu, Zn, Sr, Y, Zr, Ba, La, Ce, Nd, Sm, Eu, Gd, Dy are determined. Abundances for an additional 109 stars were taken from the literature and combined with the data of our sample. The literature sample reveals a lack of reliable abundance estimates for species that might be associated with the r-process elements for about 67% of CEMP stars, preventing a complete understanding of this class of stars, since [Ba/Eu] ratios are used to classify them. Although eight stars in our observed sample are also found in the literature sample, Eu abundances or limits are determined for four of these stars for the first time. From the observed correlations between C, Ba, and Eu, we argue that the CEMP-r/s class has the same astronomical origin as CEMP-s stars, highlighting the need for a more complete understanding of Eu production.

Is the date of birth an advantage/ally to excel in handball?

The Relative Age Effect (RAE) has been analyzed in a population of Spanish international handball players (n=161) divided into four different levels: Senior, Junior, Juvenile and Promising Talents. The variables registered were quarter, half year and year of birth using the initial information of their date of birth. The data were collected from the Royal Spanish Handball Federation on-line data base. The statistical method used was the χ2 and the minimum level of significance was set at p<0.05. The total results on distribution by quarter show a significant difference (χ2= 21.68; p<0.01) with a greater frequency of players born in the first quarter (40.37%) compared to those born in the second (22.36%), third (16.15%) and fourth quarter (21.12%). The total results on the distribution of birth date by half year show a significant difference (χ2= 10.44; p<0.01) with a greater frequency of players born in the first half of the year (62.73%). With regard to the rate of births registered in an even numbered or odd numbered year there are significant differences when the rates for an even numbered year (64.60%) and an odd numbered year (35.40%) are compared with those of the general population (χ2= 13.72; p<0.001). Based on the data collected and analyzed it can be concluded that there is a RAE in the basic categories of the Spanish national men’s handball teams according to quarter, half year and year of birth (even or odd numbered), but there exists little knowledge about the causes and consequence which may be produced by, or derive from, this effect.

Transportation infrastructure impacts on firm location: the effect of a new metro line in the suburbs of Madrid

Firm location patterns emerge as a consequence of multiple factors, including firm considerations, labor force availability, market opportunities, and transportation costs. Many of these factors are influenced by changes in accessibility wrought by new transportation infrastructure. In this paper we use spatial statistical techniques and a micro-level data base to evaluate the effects of Madrid?s metro line 12 (known as Metrosur) expansion on business location patterns. The case study is the municipality of Alcorcon, which is served by the new metro line since 2003. Specifically, we explore the location patterns by different industry sectors, to evaluate if the new metro line has encouraged the emergence of a ?Metrosur spatial economy?. Our results indicate that the pattern of economic activity location is related to urban accessibility and that agglomeration, through economies of scale, also plays an important role. The results presented in this paper provide evidence useful to inform efficient transportation, urban, and regional economic planning.

The journey to delivered value in Australian procurement

In line with developments overseas Australian clients are turning to considerations of value in project procurement. Until the 1980s the industry operated in a largely traditional manner however the extremely adversarial behaviour exhibited during towards the end of the decade led to a number of significant events and initiatives including the publication of “No Dispute”, the Gyles Royal Commission into the Building Industry, the Construction Industry Development Agency (CIDA) and the work of the Australian Procurement and Construction Council (APCC). A number of research projects in progress in the CRC for Construction Innovation (CRC CI) are focussing on the assessment of value and methodologies to support the delivery of value in the procurement and management of engineering and construction projects. This paper charts the emergence of several key drivers in the process and illustrates how they can be integrated into a comprehensive Decision Support System that balances value to stakeholders with project imperatives and incorporates a lessons learned data base which enriches the decision making process to optimise delivery method design and selection.

On-line estimation of Allan variance parameters

A new online method is presented for estimation of the angular random walk and rate random walk coefficients of IMU (inertial measurement unit) gyros and accelerometers. The online method proposes a state space model and proposes parameter estimators for quantities previously measured from off-line data techniques such as the Allan variance graph. Allan variance graphs have large off-line computational effort and data storage requirements. The technique proposed here requires no data storage and computational effort of O(100) calculations per data sample.

Agreement Patterns in English : Diachronic Corpus Studies on Common-Number Pronouns

This study reports a diachronic corpus investigation of common-number pronouns used to convey unknown or otherwise unspecified reference. The study charts agreement patterns in these pronouns in various diachronic and synchronic corpora. The objective is to provide base-line data on variant frequencies and distributions in the history of English, as there are no previous systematic corpus-based observations on this topic. This study seeks to answer the questions of how pronoun use is linked with the overall typological development in English and how their diachronic evolution is embedded in the linguistic and social structures in which they are used. The theoretical framework draws on corpus linguistics and historical sociolinguistics, grammaticalisation, diachronic typology, and multivariate analysis of modelling sociolinguistic variation. The method employs quantitative corpus analyses from two main electronic corpora, one from Modern English and the other from Present-day English. The Modern English material is the Corpus of Early English Correspondence, and the time frame covered is 1500-1800. The written component of the British National Corpus is used in the Present-day English investigations. In addition, the study draws supplementary data from other electronic corpora. The material is used to compare the frequencies and distributions of common-number pronouns between these two time periods. The study limits the common-number uses to two subsystems, one anaphoric to grammatically singular antecedents and one cataphoric, in which the pronoun is followed by a relative clause. Various statistical tools are used to process the data, ranging from cross-tabulations to multivariate VARBRUL analyses in which the effects of sociolinguistic and systemic parameters are assessed to model their impact on the dependent variable. This study shows how one pronoun type has extended its uses in both subsystems, an increase linked with grammaticalisation and the changes in other pronouns in English through the centuries. The variationist sociolinguistic analysis charts how grammaticalisation in the subsystems is embedded in the linguistic and social structures in which the pronouns are used. The study suggests a scale of two statistical generalisations of various sociolinguistic factors which contribute to grammaticalisation and its embedding at various stages of the process.

Young Men s Sexual Behaviour in Finland and Estonia : Opportunities for prevention of sexually transmitted infections

Background: The incidence of sexually transmitted infections (STIs) in most EU states has gradually increased and the rate of newly diagnosed HIV cases has doubled since 1999. STIs differ in their clinical features, prognosis and transmission dynamics, though they do share a common factor in their mode of transmission −that is, human behaviour. The evolvement of STI epidemiology involves a joint action of biological, epidemiological and societal factors. Of the more immediate factors, besides timely diagnosis and appropriate treatment, STI incidence is influenced by population patterns of sexual risk behaviour, particularly the number of sexual partners and the frequency of unprotected intercourse. Assessment of sexual behaviour, its sociodemographic determinants and time-trends are important in understanding the distribution and dynamic of STI epidemiology. Additionally, in the light of the basic structural determinants, such as increased level of migration, changes in gender dynamics and impacts from globalization, with its increasing alignment of values and beliefs, can reveal future challenges related to STI epidemiology. STI case surveillance together with surveillance on sexual behaviour can guide the identification of preventive strategies, assess their effectiveness and predict emerging trends. The objective of this study was to provide base line data on sexual risk behaviour, self-reported STIs and their patterns by sociodemographic factors as well as associations of sexual risk behaviour with substance use among young men in Finland and Estonia. In Finland national population based data on adult men s sexual behaviour is limited. The findings are discussed in the context of STI epidemiology as well as their possible implications for public health policies and prevention strategies. Materials and Methods: Data from three different cross-sectional population-based surveys conducted in Finland and Estonia, during 1998 2005, were used. Sexual behaviour- and health-related questions were incorporated in two surveys in Finland; the Health 2000, a large scale general health survey, focussed on young adults, and the Military health behavioural survey on military conscripts participating in the mandatory military training. Through research collaboration with Estonia, similar questions to the Finnish surveys were introduced to the second Estonian HIV/AIDS survey, which was targeted at young adults. All surveys applied mail-returned, anonymous, self-administered questionnaires with multiple choice formatted answers. Results: In Finland, differences in sexual behaviour between young men and women were minor. An age-stratified analysis revealed that the sex-related difference observed in the youngest age group (18 19 years) levelled off in the age group 20 24 and almost disappeared among those aged 25 29. Marital status was the most important sociodemographic correlate for sexual behaviour for both sexes, singles reporting higher numbers of lifetime-partners and condom use. This effect was stronger for women than for men. However, of those who had sex with casual partners, 15% were married or co-habiting, with no difference between male and female respondents. According to the Military health behavioural survey, young men s sexual risk behaviour in Finland did not markedly change over a period of time between 1998 and 2005. Approximately 30−40% of young men had had multiple sex partners (more than five) in their lifetime, over 20% reported having had multiple sex partners (at least three) over the past year and 50% did not use a condom in their last sexual intercourse. Some 10% of men reported accumulation of risk factors, i.e. having had both, multiple sex partners and not used a condom in their last intercourse, over the past year of the survey. When differences and similarities were viewed within Finland and Estonia, a clear sociodemographic patterning of sexual risk behaviour and self-reported STIs was found in Finland, but a somewhat less consistent trend in Estonia. Generally, both, alcohol and drug use were strong correlates for sexual risk behaviour and self-reported STIs in Finland and Estonia, having a greater effect on engagement with multiple sex partners rather than unprotected intercourse or self-reported STIs. In Finland alcohol use, relative to drug use, was a stronger predictor of sexual risk behaviour and self-reported STIs, while in Estonia drug use predicted sexual risk behaviour and self-reported STIs stronger than alcohol use. Conclusions: The study results point to the importance for prevention of sexual risk behaviour, particularly strategies that integrate sexual risk with alcohol and drug use risks. The results point to the need to focus further research on sexual behaviour and STIs among young people; on tracking trends among general population as well as applying in-depth research to identify and learn from vulnerable and high-risk population groups for STIs who are exposed to a combination of risk factors.

The survey of Lake Victoria's fishers

The findings are presented of a survey conducted regarding the fishers of Lake Victoria, which examined the relationships affecting supply flows of raw material on to the market, and also the characteristics of fishing activities and their effects on fish quality and distribution. Fish marketing plays a vital role in the lives of much of the lake basin's population, both in terms of employment and nutrition. The results of the survey comprise, in part, a base-line data set which will facilitate further research, analysis and management decision-making in relation to stakeholders of the lake's resources. Data collection, methods and research difficulties encountered are described and details given of a profile of a boat owner/renter and aslo of a profile of a crew member. The survey shows that Lake Victoria's fishery is one of very limited diversity. The fishers recount that they consistently target one or more of the 3 most common species within the lake (Nile perch, tilapia and dagaa) and very rarely consider any other species type. The largest proportion of fishers on the lake are Nile perch fishers; there is considerable demand for this species, and hence fishers have little incentive to either target alternative fish species, not to try and establish firm marketing outlets through the creation of arrangements with their principal buyers. In Kenyan waters, however, the number of Nile perch fishers is equaled by the number of dagaa fishers; this fish now commands a considerable portion of the market for fish from Lake Victoria through its availability as well as its relatively low prices. The tilapia fishery is in decline, and all 3 riparian states would not appear to be attracting investment almost certainly as a result of declining catches. For many of those working in Lake Victoria's fishery, the problems faced appear most often to be associated with the vagaries of an unstable market which may rise or fall depending on the state of the international market or the state of access roads to fish landings. (PDF contains 42 pages)

Computer system support for data analysis

This thesis is an investigation into the nature of data analysis and computer software systems which support this activity.

The first chapter develops the notion of data analysis as an experimental science which has two major components: data-gathering and theory-building. The basic role of language in determining the meaningfulness of theory is stressed, and the informativeness of a language and data base pair is studied. The static and dynamic aspects of data analysis are then considered from this conceptual vantage point. The second chapter surveys the available types of computer systems which may be useful for data analysis. Particular attention is paid to the questions raised in the first chapter about the language restrictions imposed by the computer system and its dynamic properties.

The third chapter discusses the REL data analysis system, which was designed to satisfy the needs of the data analyzer in an operational relational data system. The major limitation on the use of such systems is the amount of access to data stored on a relatively slow secondary memory. This problem of the paging of data is investigated and two classes of data structure representations are found, each of which has desirable paging characteristics for certain types of queries. One representation is used by most of the generalized data base management systems in existence today, but the other is clearly preferred in the data analysis environment, as conceptualized in Chapter I.

This data representation has strong implications for a fundamental process of data analysis -- the quantification of variables. Since quantification is one of the few means of summarizing and abstracting, data analysis systems are under strong pressure to facilitate the process. Two implementations of quantification are studied: one analagous to the form of the lower predicate calculus and another more closely attuned to the data representation. A comparison of these indicates that the use of the "label class" method results in orders of magnitude improvement over the lower predicate calculus technique.

Base de dados meteorologicos do CNPH na internet.

2000

Central nervous system drugs: Low temperature X-ray structures of (I) the base 5-(2,3-dichlorophenyl)-2,4-diamino-6-fluoromethyl-pyrimidine (4030W92) and (II) 5-(2,6-dichlorophenyl)-1-H-2,4-diamino-6-methyl-pyrimidine methanesulphonic acid salt (227C89)

The X-ray crystal structures of (I), the base 4030W92, 5-(2,3-dichlorophenyl)-2,4-diamino-6-fluoromethyl-pyrimidine, C11H9Cl2FN4, and (II) 227C89, the methanesulphonic acid salt of 5-(2,6-dichlorophenyl)-1-H-2,4-diamino-6-methyl-pyrimidine, C11H11Cl2N4 center dot CH3O3S, have been carried out at low temperature. A detailed comparison of the two structures is given. Structure (I) is non-centrosymmetric, crystallizing in space group P2(1) with unit cell a = 10.821(3), b = 8.290(3), c = 13.819(4) angstrom, beta = 105.980(6)degrees, V = 1191.8(6) angstrom(3), Z = 4 (two molecules per asymmetric unit) and density (calculated) = 1.600 mg/m(3). Structure (II) crystallizes in the triclinic space group P (1) over bar with unit cell a = 7.686(2), b = 8.233(2), c = 12.234(2) angstrom, alpha = 78.379(4), beta = 87.195(4), gamma = 86.811(4)degrees, V = 756.6(2) angstrom(3), Z = 2, density (calculated) = 1.603 mg/m(3). Final R indices [I > 2sigma(I)] are R1 = 0.0572, wR2 = 0.1003 for (I) and R1 = 0.0558, wR2 = 0.0982 for (II). R indices (all data) are R1 = 0.0983, wR2 = 0.1116 for (I) and R1 = 0.1009, wR2 = 0.1117 for (II). 5- Phenyl-2,4 diaminopyrimidine and 6-phenyl-1,2,4 triazine derivatives, which include lamotrigine (3,5-diamino-6-(2,3-dichlorophenyl)-1,2,4-triazine), have been investigated for some time for their effects on the central nervous system. The three dimensional structures reported here form part of a newly developed data base for the detailed investigation of members of this structural series and their biological activities.