On Implementing Joins, Aggregates and Universal Quantifier in Temporal Databases using SQL Standards

A feasible way of implementing a temporal database is by mapping temporal data model onto a conventional data model followed by a commercial database management system. Even though extensions were proposed to standard SQL for supporting temporal databases, such proposals have not yet come across standardization processes. This paper attempts to implement database operators such as aggregates and universal quantifier for temporal databases, implemented on top of relational database systems, using currently available SQL standards.

Abbildung von XML-Dokumenten auf SQL:2003-konforme Datentypen

Die Auszeichnungssprache XML dient zur Annotation von Dokumenten und hat sich als Standard-Datenaustauschformat durchgesetzt. Dabei entsteht der Bedarf, XML-Dokumente nicht nur als reine Textdateien zu speichern und zu transferieren, sondern sie auch persistent in besser strukturierter Form abzulegen. Dies kann unter anderem in speziellen XML- oder relationalen Datenbanken geschehen. Relationale Datenbanken setzen dazu bisher auf zwei grundsätzlich verschiedene Verfahren: Die XML-Dokumente werden entweder unverändert als binäre oder Zeichenkettenobjekte gespeichert oder aber aufgespalten, sodass sie in herkömmlichen relationalen Tabellen normalisiert abgelegt werden können (so genanntes „Flachklopfen“ oder „Schreddern“ der hierarchischen Struktur). Diese Dissertation verfolgt einen neuen Ansatz, der einen Mittelweg zwischen den bisherigen Lösungen darstellt und die Möglichkeiten des weiterentwickelten SQL-Standards aufgreift. SQL:2003 definiert komplexe Struktur- und Kollektionstypen (Tupel, Felder, Listen, Mengen, Multimengen), die es erlauben, XML-Dokumente derart auf relationale Strukturen abzubilden, dass der hierarchische Aufbau erhalten bleibt. Dies bietet zwei Vorteile: Einerseits stehen bewährte Technologien, die aus dem Bereich der relationalen Datenbanken stammen, uneingeschränkt zur Verfügung. Andererseits lässt sich mit Hilfe der SQL:2003-Typen die inhärente Baumstruktur der XML-Dokumente bewahren, sodass es nicht erforderlich ist, diese im Bedarfsfall durch aufwendige Joins aus den meist normalisierten und auf mehrere Tabellen verteilten Tupeln zusammenzusetzen. In dieser Arbeit werden zunächst grundsätzliche Fragen zu passenden, effizienten Abbildungsformen von XML-Dokumenten auf SQL:2003-konforme Datentypen geklärt. Darauf aufbauend wird ein geeignetes, umkehrbares Umsetzungsverfahren entwickelt, das im Rahmen einer prototypischen Applikation implementiert und analysiert wird. Beim Entwurf des Abbildungsverfahrens wird besonderer Wert auf die Einsatzmöglichkeit in Verbindung mit einem existierenden, ausgereiften relationalen Datenbankmanagementsystem (DBMS) gelegt. Da die Unterstützung von SQL:2003 in den kommerziellen DBMS bisher nur unvollständig ist, muss untersucht werden, inwieweit sich die einzelnen Systeme für das zu implementierende Abbildungsverfahren eignen. Dabei stellt sich heraus, dass unter den betrachteten Produkten das DBMS IBM Informix die beste Unterstützung für komplexe Struktur- und Kollektionstypen bietet. Um die Leistungsfähigkeit des Verfahrens besser beurteilen zu können, nimmt die Arbeit Untersuchungen des nötigen Zeitbedarfs und des erforderlichen Arbeits- und Datenbankspeichers der Implementierung vor und bewertet die Ergebnisse.

Avaluació de l'estàndard SQL : 1999 respecte les característiques orientades a l'objecte que suporta i la seva implementació als SGBD object-relacional

En aquest treball s'intenta fer una síntesi de les especificacions aportades per l'estàndard definit com a SQL: 1999, tot analitzant les ampliacions que fan referència a la nova orientació a l'objecte i a la incorporació de l'herència com a principal element diferenciador.

Critical applications of SW 846 US EPA methods to evaluation of marine samples quality

Technical evaluation of analytical data is of extreme relevance considering it can be used for comparisons with environmental quality standards and decision-making as related to the management of disposal of dredged sediments and the evaluation of salt and brackish water quality in accordance with CONAMA 357/05 Resolution. It is, therefore, essential that the project manager discusses the environmental agency's technical requirements with the laboratory contracted for the follow-up of the analysis underway and even with a view to possible re-analysis when anomalous data are identified. The main technical requirements are: (1) method quantitation limits (QLs) should fall below environmental standards; (2) analyses should be carried out in laboratories whose analytical scope is accredited by the National Institute of Metrology (INMETRO) or qualified or accepted by a licensing agency; (3) chain of custody should be provided in order to ensure sample traceability; (4) control charts should be provided to prove method performance; (5) certified reference material analysis or, if that is not available, matrix spike analysis, should be undertaken and (6) chromatograms should be included in the analytical report. Within this context and with a view to helping environmental managers in analytical report evaluation, this work has as objectives the discussion of the limitations of the application of SW 846 US EPA methods to marine samples, the consequences of having data based on method detection limits (MDL) and not sample quantitation limits (SQL), and present possible modifications of the principal method applied by laboratories in order to comply with environmental quality standards.

Feasibility of using solid sampling graphite furnace atomic absorption spectrometry for preparation of spiked filter papers with Cu and Zn as standards for direct solid analysis

An approach was developed for the preparation of cryogenic ground spiked filter papers with Cu and Zn for use as synthetic calibrating standards for direct solid microanalysis. Solid sampling graphite furnace atomic absorption spectrometry was used to evaluate the microhomogeneity and to check the applicability of the synthetic calibrating standards for the direct determination of Cu and Zn in vegetable certified reference materials. The found concentrations presented no statistical differences at the 95% confidence level. The homogeneity factors ranged from 2.7 to 4.2 for Cu and from 6.4 to 11.5 for Zn.

Developing and implementing an open and non-proprietary device description for FOUNDATION fieldbus based on software standards

Support for interoperability and interchangeability of software components which are part of a fieldbus automation system relies on the definition of open architectures, most of them involving proprietary technologies. Concurrently, standard, open and non-proprietary technologies, such as XML, SOAP, Web Services and the like, have greatly evolved and been diffused in the computing area. This article presents a FOUNDATION fieldbus (TM) device description technology named Open-EDD, based on XML and other related technologies (XLST, DOM using Xerces implementation, OO, XMIL Schema), proposing an open and nonproprietary alternative to the EDD (Electronic Device Description). This initial proposal includes defining Open-EDDML as the programming language of the technology in the FOUNDATION fieldbus (TM) protocol, implementing a compiler and a parser, and finally, integrating and testing the new technology using field devices and a commercial fieldbus configurator. This study attests that this new technology is feasible and can be applied to other configurators or HMI applications used in fieldbus automation systems. (c) 2008 Elsevier B.V. All rights reserved.

Forest certification in Amazonia: standards matter

Forest Stewardship Council (FSC) certification promises international consumers that `green-label` timber has been logged sustainably. However, recent research indicates that this is not true for ipe (Tabebuia spp.), currently flooding the US residential decking market, much of it logged in Brazil. Uneven or non-application of minimum technical standards for certification could undermine added value and eventually the certification process itself. We examine public summary reports by third-party certifiers describing the evaluation process for certified companies in the Brazilian Amazon to determine the extent to which standards are uniformly applied and the degree to which third-party certifier requirements for compliance are consistent among properties. Current best-practice harvest systems, combined with Brazilian legal norms for harvest levels, guarantee that no certified company or community complies with FSC criteria and indicators specifying species-level management. No guidelines indicate which criteria and indicators must be enforced, or to what degree, for certification to be conferred by third-party assessors; nor do objective guidelines exist for evaluating compliance for criteria and indicators for which adequate scientific information is not yet available to identify acceptable levels. Meanwhile, certified companies are expected to monitor the long-term impacts of logging on biodiversity in addition to conducting best-practice forest management. This burden should reside elsewhere. We recommend a clarification of `sustained timber yield` that reflects current state of knowledge and practice in Amazonia. Quantifiable verifiers for best-practice forest management must be developed and consistently employed. These will need to be flexible to reflect the diversity in forest structure and dynamics that prevails across this vast region. We offer suggestions for how to achieve these goals.

Mental health nursing standards and practice indicators for Australia: a review of current literature

There are many changes and challenges facing the mental health care professional working in Australia in the 21st Century. Given the significance of their number and the considerable extent to which care is delivered by them, mental health nurses in particular must be at the forefront of the movement to enhance and improve mental health care. Mental health nurses in Australia must not only keep up with the changes, we should be setting the pace for others across the profession worldwide. The increasingly complex field of mental health nursing demands nurses who are not only equipped to face the challenges but are confident in doing so. Definitive guidelines for practice, clear expectations regarding outcomes and specific means by which to evaluate both practice and outcomes are vital. Strengthening the role and vision of mental health nursing so that there is clarity about both and highlighting core values by which to perform will enable us to become focused on our future and what we can expect to both give to and receive from our chosen profession and how we can, and do, contribute to mental health care. The role of the mental health nurse is undergoing expansion and there are new hurdles to overcome along with the new benefits this brings. To support this, nationally adopted, formalised standards of practice and means by which to measure these, i.e., practice indicators formerly known as clinical indicators, are required. It is important to have national standards and practice indicators because of the variances in the provision of mental health across Australia – different legislation regarding mental health policies and processes, different nursing registration bodies and Nursing Councils, for example – which create additional barriers to cohesion and uniformity. Improvements in the practice of mental health nursing lead to benefits for consumer outcomes as well as the overall quality of mental health care available in Australia. The emphasis on rights-based care, particularly consumer and carer rights, demands evidence-based, up-to-date mental health care delivered by competent, capable professionals. Documented expectations for performance by nurses will provide all involved with yardsticks by which to evaluate outcomes. Flowing on from these benefits are advances in mental health care generally and enhancements to Australia’s reputation and position within the health care arena throughout the world. Currently, the ‘Standards for Practice’ published by the Australian New Zealand College of Mental Health Nurses (ANZCMHN) in 1995 and the practice indicators developed by Skews et al. (2000) provide a less formal guide for mental health nurses working in Australia. While these earlier standards and practice indicators have played some role in supporting mental health nurses they have not been nationally or enthusiastically adopted and there are a multitude of reasons for this. This report reviews the current literature available on practice indicators and standards for practice and describes an evidence-based rationale as to why a review and renewal of these is required and why it is important, not just for mental health nurses but to the field of mental health in general. The term ‘practice indicator’ is used, except where a quotation utilises ‘clinical indicator’, to more accurately reflect the broad spectrum of nursing roles, i.e. not all mental health nursing work involves a clinical role.

Estimating the cost of contact for non-resident parents: A budget standards approach

Most Western countries have, for some time, provided income support and/or taxation relief to parents with children in their care. The significant amount of research into the costs of children to couple and sole parent households has been important in assessing and developing family support policies. Changing societal expectations about the level of involvement of fathers in child rearing activities has highlighted the need to understand the costs facing usually male non-resident parents in having contact with their children. The budget standards methodology is used in this paper to estimate the costs for non-resident parents exercising regular contact with their children. Costs of contact are found to be high. For contact with one child for 20 per cent of the year, costs of contact represent about 40 per cent of the costs of that same child in an intact couple household with a medium income and more than half of the costs of that child in a household with low income. Household infrastructure and transportation is the reason for high costs. One implication of this finding is that the total cost of children substantially increases when parents separate. The article discusses some policy implications of these findings. This research is of relevance to social security, taxation, family law and child support policies and administration.