Implementação de uma solução open source de Business Intelligence com metodologia Ágil

A importância dos sistemas de data warehousing e business intelligence é cada vez mais pronunciada, no sentido de dotar as organizações com a capacidade de guardar, explorar e produzir informação de valor acrescido para os seus processos de tomada de decisão. Esta realidade é claramente aplicável aos sectores da administração pública portuguesa e, muito em particular, aos organismos com responsabilidades centrais no Ministério da Saúde. No caso dos Serviços Partilhados do Ministério da Saúde (SPMS), que tem como missão prover o SNS de sistemas centrais de business intelligence, o apelo dos seus clientes, para que possam contar com capacidades analíticas nos seus sistemas centrais, tem sido sentido de forma muito acentuada. Todavia, é notório que, tanto os custos, como a complexidade, de grande parte destes projetos têm representado uma séria ameaça à sua adoção e sucesso. Por um lado, a administração pública tem recebido um forte encorajamento para integrar e adotar soluções de natureza open source (modelo de licenciamento gratuito), para os seus projetos de sistemas de informação. Por outro lado, temos vindo a assistir a uma vaga de aceitação generalizada de novas metodologias de desenvolvimento de projetos informáticos, nomeadamente no que diz respeito às metodologias Agéis, que se assumem como mais flexíveis, menos formais e com maior grau de sucesso. No sentido de averiguar da aplicabilidade do open source e das metodologias Ágeis aos sistemas de business intelligence, este trabalho documenta a implementação de um projeto organizacional para a SPMS, com recurso a ferramentas open source de licenciamento gratuito e através de uma metodologia de desenvolvimento de natureza Ágil.

Comuns: An Open-Data Provider, Explorer and Analytic Toolbox Based on FOSS

Contém resumo

Laparoscopic versus open splenectomy in the management of hematologic diseases

Splenectomy is the best available treatment for severe forms of hereditary spherocytosis, idiopathic thrombocytopenic purpura, and other hematologic conditions when these prove refractory to conservative management. It has been employed for many decades with low mortality and favorable remission rates. The use of laparoscopic splenectomy in recent years has been rapidly and even enthusiastically adopted in this field. However, the exact role of laparoscopic versus open surgery for hematologic diseases is still debated. In this study of 58 adult patients, laparoscopic procedures were compared with conventional splenectomies for similar indications. METHODS: All patients were operated on within an 8-year period. Subjects underwent similar procedures under the supervision of the same surgical school and were compared regarding age, gender, body mass index, and diagnosis. Laparoscopically managed cases (Group I, n = 30) were prospectively followed according to a written protocol, whereas the same investigation was retrospectively done with regard to traditional laparotomy (Group II, n = 28). Methods included general and demographic findings, duration and technical steps of operation, blood loss, weight of spleen, need for conversion (in minimally invasive subjects), intraoperative and postoperative complications, time until realimentation, postoperative hospitalization, mortality, and late follow-up including recurrence rate. RESULTS: Idiopathic thrombocytopenic purpura was the surgical indication in over 50% of the patients in both groups, but familial spherocytosis, thalassemia, myelodysplasia, and lymphomas were also represented in this series. Laparoscopic procedures took more time to perform (P = 0.004), and postoperative hospitalization was 2 days shorter, but this difference was not statistically significant. Postoperative hematocrit and volume of blood transfusions was equivalent, although the laparoscopic cases had a somewhat lower preoperative hematocrit (NS) and displayed better recovery for this measurement (P = 0.03). More patients in Group I were able to accept oral food on the first day than subjects undergoing conventional operations (P < 0.05). Relatively few conversions were necessary during the minimally invasive surgeries (13.3%), and postoperative early and late complications as well as recurrences occurred in similar proportions. Also, the mean weight of the spleen was not statistically different between the groups, although there was a marked numerical tendency toward larger masses in conventional procedures. No spleen in Group I exceeded 2.0 kg, whereas in Group II values up to 4.0 kg occurred, and the mean weight was 50% higher in the latter group. CONCLUSIONS: 1) Minimally invasive splenectomy was essentially comparable to open surgery with regard to safety, efficacy, and late results; 2) Advantages concerning shorter postoperative hospitalization could not be shown, despite earlier food intake and a non-significant tendency toward earlier discharge; 3) This new modality should be considered an option in cases of hematologic conditions whenever the spleen is not hugely enlarged.

Plastic waste use as aggregate and binder modifier in open-graded asphalts

Road pavements are very important infrastructures for the Society, but they can cause serious environmental impacts during construction, operation and rehabilitation phases. Thus, it is essential to develop surface paving solutions that promote not only the durability but also a comfortable and safe use. In fact, this work aims to study the properties of new opengraded mixtures for surface layers produced with plastic wastes. First, HDPE and EVA wastes were used as bitumen modifiers, and then another plastic waste (PEX) replaced part of the aggregates. After studying the modified binders, the open-graded mixtures were designed, and then they were tested concerning their particle loss, rutting resistance, surface texture and damping effect. It was concluded that both ways of using the plastic wastes can improve the mechanical and functional properties of the open-graded mixtures related to the pavement performance.

State of the art and open questions on cathode preparation based on carbon coated lithium iron phosphate

One important component with particular relevance in battery performance is the cathode, being one of the main responsible elements for cell capacity and cycle life. Carbon coated lithium iron phosphate, C-LiFePO4, active material is one of the most promising cathode materials for the next generation of large scale lithium ion battery applications and strong research efforts are being devoted to it, due to its excellent characteristics, including high capacity, ~170 mAh/g, and safety. This review summarizes the main developments on C-LiFePO4 based cathode film preparation and performance. The effect of the binder, conductive additive, relationship between active material-binder-conductive additive and drying step, in the electrode film fabrication and performance is presented and discussed. Finally, after the presentation of the cell types fabricated with C-LiFePO4 active material and their performance, some conclusions and guidelines for further investigations are outlined.

User expectations for media sharing practices in open display networks

Open Display Networks have the potential to allow many content creators to publish their media to an open-ended set of screen displays. However, this raises the issue of how to match that content to the right displays. In this study, we aim to understand how the perceived utility of particular media sharing scenarios is affected by three independent variables, more specifically: (a) the locativeness of the content being shared; (b) how personal that content is and (c) the scope in which it is being shared. To assess these effects, we composed a set of 24 media sharing scenarios embedded with different treatments of our three independent variables. We then asked 100 participants to express their perception of the relevance of those scenarios. The results suggest a clear preference for scenarios where content is both local and directly related to the person that is publishing it. This is in stark contrast to the types of content that are commonly found in public displays, and confirms the opportunity that open displays networks may represent a new media for self-expression. This novel understanding may inform the design of new publication paradigms that will enable people to share media across the display networks.

Project scheduling and cost minimization with multiple availability constrained resources under stochastic conditions

The authors propose a mathematical model to minimize the project total cost where there are multiple resources constrained by maximum availability. They assume the resources as renewable and the activities can use any subset of resources requiring any quantity from a limited real interval. The stochastic nature is inferred by means of a stochastic work content defined per resource within an activity and following a known distribution and the total cost is the sum of the resource allocation cost with the tardiness cost or earliness bonus in case the project finishes after or before the due date, respectively. The model was computationally implemented relying upon an interchange of two global optimization metaheuristics – the electromagnetism-like mechanism and the evolutionary strategies. Two experiments were conducted testing the implementation to projects with single and multiple resources, and with or without maximum availability constraints. The set of collected results shows good behavior in general and provide a tool to further assist project manager decision making in the planning phase.

On mappings preserving the sharp and star orders

The present paper is devoted to the study of linear maps preserving certain relations, such as the sharp partial order and the star partial order in semisimple Banach algebras and C*-algebras.

Myxomycetes collection preserved in the herbarium of the Federal University of Roraima (Brazil)

First records of myxomycetes in the North region of Brazil go back to the 19th century. Nevertheless, the myxobiota of this region is still largely unexplored, with only 42 species recorded, distributed in 20 genera and seven families. The objectives of this paper were to characterize the Myxomycetes collection of the Herbarium of the Federal University of Roraima (UFRR) and to add new records for the myxobiota of this State. The collection holds specimens collected in fragments of Open Ombrophilous Forest, Seasonal Semi-deciduous Forest, Riparian Forest, deforested areas and urban home gardens in the state of Roraima. The 157 exsiccates were analyzed and identified or redetermined based on identification keys, descriptions and illustrations. The collection is in good conditions of preservation and includes all subclasses of Myxomycetes, 83% of its orders, 50% of its families, and 20 species. Trichiales, with one family, three genera and six species, represents 62% of all exsiccates. Cribraria aff. splendens, Metatrichia vesparia, Physarella oblonga, Stemonaria longa and Stemonitis splendens are new records for Roraima and Arcyria obvelata, Comatricha pulchella, Stemonitis pallida and Stemonitopsis aequalis are referred for the first time in the Northern Region, enlarging the knowledge of the Brazilian geographic distribution of these species.

Repository power: how repositories can support Open Access mandates

Many funding agencies have Open Access mandates in place, but how often are scientific publications as outputs linked to funding details? The benefits of linking funding information to publications as part of the deposit workflow can assist in adhering to Open Access mandates. This paper examines how OpenAIRE – Open Access Infrastructure for Research in Europe – can ease monitoring Open Access and reporting processes for funders, and presents some results and opportunities. It also outlines how it relies on cleaned and curated repository content, a vital cog in the ever turning wheel of the global scholarly landscape, and the benefits it brings.

FOSTER: facilitate open science training for european research

FOSTER aims to support different stakeholders, especially young researchers, in adopting open access in the context of the European Research Area (ERA) and in complying with the open access policies and rules of participation set out for Horizon 2020 (H2020). FOSTER establish a European-wide training programme on open access and open data, consolidating training activities at downstream level and reaching diverse disciplinary communities and countries in the ERA. The training programme includes different approaches and delivery options: elearning, blearning, self-learning, dissemination of training materials/contents, helpdesk, face-to-face training, especially training-the-trainers, summer schools, seminars, etc.

Enquadramento para a compreensão dos impactos do Open Government Data

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

Gender, sex and sexuality in two open access communication journals published in Portugal: a critical overview of current discursive practices

The links between gender, sex and sexuality and their relevance are theoretically and politically problematic (Richardson, 2007). One of the difficulties in understanding their interconnections is that these terms are often used differently and ambiguously by different authors (and even by the same authors). This article reports the results of an analysis of the articles published in open access communication journals with known impact factor, edited in Portugal and published between 2005 and 2012. The diverse conceptualisations of those three basic concepts and of their (inter)relationships within communication research are identified. The complexity and the intricate (and often implicit) nature of both the meanings of these categories and their relationships underlie and justify our attention and further research. What the findings suggest about the current communication research into gender issues published in the two journals surveyed is that the ‘Gender differences discourse’ (Sunderland, 2004) is the most pervasive discourse (also) in academic practice. Additionally, they show that gender and sex are mainly taken for a fact, not a question that is worth being studied. The editors of these journals, as well as the scholars submitting manuscripts, need to be more aware of the traditional nature of the theoretical and methodological choices that they make regarding gender- and sex-related issues, as well as of the relative lack of attention to sexuality as a research subject.

A multicenter, open-label study of the efficacy and safety of telmisartan in mild to moderate hypertensive patients

OBJECTIVE: To evaluate the efficacy and tolerability of telmisartan, given once a day to patients with mild to moderate hypertension, as well as to assess the 24-hour blood pressure profile with ABPM. METHODS: Initially, 163 patients over 18 were selected, regardless of sex, with blood pressure levels >140/90mmHg at visit 1, which was confirmed at visit 2. One hundred thirty-four patients completed the study. After a 4-week placebo run-in phase, telmisartan 40mg/daily was given for 6 weeks. In those patients whose blood pressure (BP) levels were lower than 140/90mmHg, the same dosage was kept for an additional period of 6 weeks. For those who had BP higher than 140/90mmHg, the dosage was increased to 80mg/daily. Sixty-two patients were included in a subgroup that underwent ABPM 3 different times during the study. RESULTS: In the overall group, blood pressure reduction ranged from 162.3±14.5/101.3±5.75 mmHg (baseline) to 147.3±20.1/90.8±10.9 mmHg (week 12) (p<0.05). Mean blood pressure decreases were 14.4mmHg for systolic BP and 10.3mmHg for diastolic BP, after 12 weeks of active treatment. A subanalysis showed that 47 (35%) patients took telmisartan 40mg throughout the study and 81 (65%) had the dosage increased to 80mg daily. Using ABPM, an 8-mmHg reduction in systolic BP as well as a 5-mmHg reduction in diastolic BP were observed, when compared with baseline values in the final 6 hours (18-24 hours after the last dose of study medication). CONCLUSION: Our results confirm that telmisartan given once a day is effective in reducing blood pressure levels in mild to moderate hypertensive patients. This reduction occurs in a sustained and gradual manner during a 24-hour period confirmed by ABPM.