Paged similarity queries

An important feature of a database management systems (DBMS) is its client/server architecture, where managing shared memory among the clients and the server is always an tough issue. However, similarity queries are specially sensitive to this kind of architecture, since the answer sizes vary widely. Usually, the answers of similarity query are fully processed to be sent in full to the user, who often is interested in just parts of the answer, e.g. just few elements closer or farther to the query reference. Compelling the DBMS to retrieve the full answer, further ignoring its majority is at least a waste of server processing power. Paging the answer is a technique that splits the answer onto several pages, following client requests. Despite the success of paging on traditional queries, little work has been done to support it in similarity queries. In this work, we present a technique that not only provides paging in similarity range or k-nearest neighbor queries, but also supports them in two variations: the forward similarity query and the backward similarity query. They return elements either increasingly farther of increasingly closer to the query reference. The reported experiments show that, depending on the proportion of the interesting part over the full answer, both techniques allow answering queries much faster than it is obtained in the non-paged way. (C) 2010 Elsevier Inc. All rights reserved.

Seamlessly integrating similarity queries in SQL

Modern database applications are increasingly employing database management systems (DBMS) to store multimedia and other complex data. To adequately support the queries required to retrieve these kinds of data, the DBMS need to answer similarity queries. However, the standard structured query language (SQL) does not provide effective support for such queries. This paper proposes an extension to SQL that seamlessly integrates syntactical constructions to express similarity predicates to the existing SQL syntax and describes the implementation of a similarity retrieval engine that allows posing similarity queries using the language extension in a relational DBM. The engine allows the evaluation of every aspect of the proposed extension, including the data definition language and data manipulation language statements, and employs metric access methods to accelerate the queries. Copyright (c) 2008 John Wiley & Sons, Ltd.

GIS applied to geotechnical and environmental risk management in a Brazilian oil pipeline

The paper presents the development of a decision support system for the management of geotechnical and environmental risks in oil pipelines using a geographical information system. The system covers a 48.5 km long section of the So Paulo to Brasilia (OSBRA) oil pipeline, which crosses three municipalities in the northeast region of the So Paulo state (Brazil) and represents an area of 205.8 km(2). The spatial database was created using geo-processing procedures, surface and intrusive investigations and geotechnical reports. The risk assessment was based mainly on qualitative models (relative numeric weights and multicriteria decision analysis) and considered pluvial erosion, slope movements, soil corrosion and third party activities. The maps were produced at a scale of 1:10,000.

FWM Constraints Management for Lightpath Establishment in GMPLS Networks

In all-optical networks, management of physical layer restrictions should collaborate in lightpath establishment. Label-Switched Path validation in Generalized MultiProtocol Label Switching on Dense Wavelength Division Multiplexing network requires the treatment of the physical impairment-related parameters along the provisioned route. In this paper we propose, for the first time in our view, the generation of an optical layer database by simulation that specifically characterizes the dynamic FWM impairments for the lightpaths provisioned in a GMPLS/DWDM network.

A decision support system to facilitate management of patients with acute gastrointestinal bleeding

Objective: To develop a model to predict the bleeding source and identify the cohort amongst patients with acute gastrointestinal bleeding (GIB) who require urgent intervention, including endoscopy. Patients with acute GIB, an unpredictable event, are most commonly evaluated and managed by non-gastroenterologists. Rapid and consistently reliable risk stratification of patients with acute GIB for urgent endoscopy may potentially improve outcomes amongst such patients by targeting scarce health-care resources to those who need it the most. Design and methods: Using ICD-9 codes for acute GIB, 189 patients with acute GIB and all. available data variables required to develop and test models were identified from a hospital medical records database. Data on 122 patients was utilized for development of the model and on 67 patients utilized to perform comparative analysis of the models. Clinical data such as presenting signs and symptoms, demographic data, presence of co-morbidities, laboratory data and corresponding endoscopic diagnosis and outcomes were collected. Clinical data and endoscopic diagnosis collected for each patient was utilized to retrospectively ascertain optimal management for each patient. Clinical presentations and corresponding treatment was utilized as training examples. Eight mathematical models including artificial neural network (ANN), support vector machine (SVM), k-nearest neighbor, linear discriminant analysis (LDA), shrunken centroid (SC), random forest (RF), logistic regression, and boosting were trained and tested. The performance of these models was compared using standard statistical analysis and ROC curves. Results: Overall the random forest model best predicted the source, need for resuscitation, and disposition with accuracies of approximately 80% or higher (accuracy for endoscopy was greater than 75%). The area under ROC curve for RF was greater than 0.85, indicating excellent performance by the random forest model Conclusion: While most mathematical models are effective as a decision support system for evaluation and management of patients with acute GIB, in our testing, the RF model consistently demonstrated the best performance. Amongst patients presenting with acute GIB, mathematical models may facilitate the identification of the source of GIB, need for intervention and allow optimization of care and healthcare resource allocation; these however require further validation. (c) 2007 Elsevier B.V. All rights reserved.

Elementary Petri net inside RFID distributed database (PNRD)

Usually, a Petri net is applied as an RFID model tool. This paper, otherwise, presents another approach to the Petri net concerning RFID systems. This approach, called elementary Petri net inside an RFID distributed database, or PNRD, is the first step to improve RFID and control systems integration, based on a formal data structure to identify and update the product state in real-time process execution, allowing automatic discovery of unexpected events during tag data capture. There are two main features in this approach: to use RFID tags as the object process expected database and last product state identification; and to apply Petri net analysis to automatically update the last product state registry during reader data capture. RFID reader data capture can be viewed, in Petri nets, as a direct analysis of locality for a specific transition that holds in a specific workflow. Following this direction, RFID readers storage Petri net control vector list related to each tag id is expected to be perceived. This paper presents PNRD cornerstones and a PNRD implementation example in software called DEMIS Distributed Environment in Manufacturing Information Systems.

Clinical management for epidermolysis bullosa dystrophica

Epidermolysis bullosa (EB) consists of a group of genetic hereditary disorders in which patients frequently present fragile skin and mucosa that form blisters following minor trauma. More than 20 subtypes of EB have been recognized in the literature. Specific genetic mutations are well characterized for most the different EB subtypes and variants. The most common oral manifestations of EB are painful blisters affecting all the oral surfaces. Dental treatment for patients with EB consists of palliative therapy for its oral manifestations along with typical restorative and periodontal procedures. The aim of this article is to describe two dental clinical treatments of recessive dystrophic EB cases and their specific clinical manifestations. The psychological intervention required during the dental treatment of these patients is also presented.

Management of a complex dentoalveolar trauma: a case report

This paper describes the case of a 12-year-old male patient who presented a severe lateral luxation of the maxillary central incisors due to a bicycle fall. Treatment involved suture of the soft tissues lacerations, and repositioning and splinting of the injured teeth, followed by endodontic treatment and periodontal surgery. After a 2-year follow-up, clinical and radiographic evaluation revealed that the incisors presented satisfactory esthetic and functional demands.

Fire management and the nesting of Athene cunicularia (Aves, Strigidae) in grasslands in central Cerrado, Brazil

Fire management is a common practice in several reserves in the Cerrado, but its influences on bird reproduction remain unknown. In addition, the nesting biology of the Burrowing Owl (Athene cunicularia) has been studied in numerous environments, but not in tropical grasslands managed by fire. This study examined the effects of fire management on the nesting biology of A. cunicularia in Emas National Park, State of Goias, central Brazilian Cerrado. We compared the number of breeding pairs and their burrows in October and November 2009 at 15 study sites in grasslands managed by fire (firebreaks) and unmanaged grasslands adjacent to and distant from firebreaks. We visited active burrows two-four times and described the burrow entrances and sentinel sites and counted and observed adults and young. A total of 19 burrows were found at firebreaks. One and two burrows were found in grasslands adjacent to and distant from firebreaks, respectively. For all burrows found, one to three young reached the adult size, being able to fly and/or run in early November. The 22 burrows found were in the ground, associated or not with termite and ant nests. Most (86.4%) burrows had only one entrance. Only three burrows had two or three entrances. Structures used as sentinel perches by adults were mounds in front of the burrow entrances, termite nests, shrubs and trees. Most of these sentinel sites were shorter than 2 m high and located less than 10 m from the burrow entrance. At Emas National Park, firebreaks appear to provide more attractive conditions to the nesting of A. cunicularia than unmanaged grasslands, likely because of the short herbaceous stratum due to frequent burning of firebreaks. This study suggests that fire management provides suitable conditions for the successful reproduction of A. cunicularia in firebreaks at Emas National Park.

Barreiras às intervenções relacionadas à saúde do trabalhador do setor saúde no Brasil

OBJETIVO: Identificar na literatura situações que possam impedir ou prejudicar as ações de prevenção de acidentes e doenças ou de promoção da saúde de trabalhadores do setor saúde. MÉTODO: Foi realizada uma revisão da literatura utilizando a base SciELO para o período de 1967 a 2008, complementada por busca na base PubMed para o período de 1950 a 2008. Os seguintes termos foram utilizados para identificar artigos em português, inglês e espanhol: trabalho, trabalhador, ocupacional, riscos, doenças, ergonomia, capacidade para o trabalho, qualidade de vida, organização, acidentes, condições de trabalho, intervenção e administração. Foram selecionados artigos sobre prevenção de doenças e acidentes e sobre promoção da saúde no trabalho em serviços de saúde latino-americanos. Também foram selecionados artigos sobre intervenções em ambientes de trabalho no setor saúde. RESULTADOS: Foram identificadas as seguintes situações desfavoráveis: programas de intervenção sem boa base teórica e não integrados à gestão do serviço como um todo; falhas em avaliar a eficácia das intervenções; vigilância da saúde restrita a doenças e agravos específicos; falta de compromisso da gestão com as intervenções; falhas na comunicação; falta de participação e controle por parte dos trabalhadores sobre o ambiente de trabalho; e programas e intervenções baseados exclusivamente na mudança comportamental dos trabalhadores. CONCLUSÕES: A literatura mostra que todas as barreiras citadas afetam tanto a melhoria do estado de saúde dos trabalhadores em saúde quanto a sua capacidade para o trabalho

Contaminated sites and brownfield management State of art in Brazil and in Germany

Purpose - The aim of this paper is to briefly present aspects of public brownfield management policies from Brazilian and German points of view. Design methodology approach - The data collection method combined literature and documental research. The bibliography included Brazilian and German literature about brownfield management. The documental research includes Brazilian and German legislation and official documents published by CETESB, the Environmental Company of the State of São Paulo, Brazil. Furthermore, publications of German governmental research institutions have been integrated in the paper. Findings - In Brazil, despite the lack of a federal public policy, the State of São Paulo has approved specific rules to deal with contaminated sites. Topics that could be targets of scientific studies have been identified. Experiences in Germany show that it is essential to have political will and cooperation between the different political levels and technical disciplines. Partnerships between German and Brazilian universities would be welcome as there is a wide range of opportunities for academic post-graduation studies and research focusing on human resources capacitation in environmental management. Originality value - The paper makes an original contribution of exploring an area (brownfield management) that is at the forefront of discussion in academe and industry

Immediate reconstruction following breast-conserving surgery: management of the positive surgical margins and influence on secondary reconstruction

The efficacy of breast-conserving surgery for the local control of early breast cancer has been repeatedly evidenced. Although immediate reconstruction following breast-conserving surgery has been described, little information is available regarding surgical management in reoperative settings due to positive margins. We studied the influence of intraoperatively assessed and postoperatively controlled surgical margin status on the type of breast-conserving surgery and report our results regarding complications in a reoperative breast reconstruction scenario. All patients were seen by a multidisciplinary team who recommended breast-conserving surgery. According to the breast volume, ptosis and tumor size/location, the patients were also evaluated by a plastic surgeon, who recommended reconstruction with the appropriate technique. Intraoperative assessment of surgical margins was determined by histological examination of frozen sections. The mean follow-up time was 48months. Two hundred and eighteen patients (88.5 per cent ) underwent breast-conserving surgery and immediate reconstruction. Twelve (5.5 per cent ) patients had a positive tumor margin after review of the permanent section. All patients underwent re-exploration. In 1.3 per cent , a second reconstructive technique was indicated and in 2.2 per cent a skin-sparing mastectomy with total reconstruction was performed. Our findings support the important role of the intraoperative assessment of surgical margins and its interference in the selection of reconstruction techniques and negative margins; however, it will not guarantee complete excision of the tumor. Success depends on coordinated planning with the oncologic surgeon and careful intraoperative management

Aspectos estratégicos e econômicos da política de bonificação em quantidade de produto

ste trabalho objetiva identificar a percepção dos gestores de controladoria de indústrias sobre os aspectos estratégicos e econômicos da decisão de bonificação em quantidade de produto. A premissa é que os resultados econômicos gerados pela decisão de desconto no preço e de bonificação em quantidade de produto são iguais, considerando a mesma quantidade de produto entregue ao cliente. Com base no banco de dados da FIPECAFI- FEA-USP, analisaram-se 91 questionários encaminhados a controllers atuantes em diversos setores. Os resultados revelam: 1) um número muito significativo de empresas da amostra selecionada adota a bonificação em produtos; 2) a área comercial é a principal responsável por essa decisão; e 3) identificação da percepção dos controllers sobre aspectos decisórios de bonificação em quantidade de produtos.

ELECTRONIC GOVERNMENT POLICIES IN BRAZIL: CONTEXT, ICT MANAGEMENT AND OUTCOMES

The State Reform processes combined with the emergence and use of Information and Communication Technology (ICT) originated electronic government policies and initiatives in Brazil. This paper dwells on Brazilian e-government by investigating the institutional design it assumed in the state's public sphere, and how it contributed to outcomes related to e-gov possibilities. The analyses were carried out under an interpretativist perspective by making use of Institutional Theory. From the analyses of interviews with relevant actors in the public sphere, such as state secretaries and presidents of public ICT companies, conclusions point towards low institutionalization of e-gov policies. The institutional design of Brazilian e-gov limits the use of ICT to provide integrated public services, to amplify participation and transparency, and to improve public policies management.