Column-based databases: estudo exploratório no âmbito das bases de dados NoSQL

O aumento da quantidade de dados gerados que se tem verificado nos últimos anos e a que se tem vindo a dar o nome de Big Data levou a que a tecnologia relacional começasse a demonstrar algumas fragilidades no seu armazenamento e manuseamento o que levou ao aparecimento das bases de dados NoSQL. Estas estão divididas por quatro tipos distintos nomeadamente chave/valor, documentos, grafos e famílias de colunas. Este artigo é focado nas bases de dados do tipo column-based e nele serão analisados os dois sistemas deste tipo considerados mais relevantes: Cassandra e HBase.

Monitoring and analysis of queries in distributed databases

Dissertação de Mestrado em Engenharia Informática

Electronic transport across linear defects in graphene

We investigate the low-energy electronic transport across grain boundaries in graphene ribbons and infinite flakes. Using the recursive Green’s function method, we calculate the electronic transmission across different types of grain boundaries in graphene ribbons. We show results for the charge density distribution and the current flow along the ribbon. We study linear defects at various angles with the ribbon direction, as well as overlaps of two monolayer ribbon domains forming a bilayer region. For a class of extended defect lines with periodicity 3, an analytic approach is developed to study transport in infinite flakes. This class of extended grain boundaries is particularly interesting, since the K and K0 Dirac points are superposed.

Monovarietal extra-virgin olive oil classification: a fusion of human sensory attributes and an electronic tongue

Olive oil quality grading is traditionally assessed by human sensory evaluation of positive and negative attributes (olfactory, gustatory, and final olfactorygustatory sensations). However, it is not guaranteed that trained panelist can correctly classify monovarietal extra-virgin olive oils according to olive cultivar. In this work, the potential application of human (sensory panelists) and artificial (electronic tongue) sensory evaluation of olive oils was studied aiming to discriminate eight single-cultivar extra-virgin olive oils. Linear discriminant, partial least square discriminant, and sparse partial least square discriminant analyses were evaluated. The best predictive classification was obtained using linear discriminant analysis with simulated annealing selection algorithm. A low-level data fusion approach (18 electronic tongue signals and nine sensory attributes) enabled 100 % leave-one-out cross-validation correct classification, improving the discrimination capability of the individual use of sensor profiles or sensory attributes (70 and 57 % leave-one-out correct classifications, respectively). So, human sensory evaluation and electronic tongue analysis may be used as complementary tools allowing successful monovarietal olive oil discrimination.

Electronic structure and optical signatures of semiconducting transition metal dichalcogenide nanosheets

CONSPECTUS: Two-dimensional (2D) crystals derived from transition metal dichalcogenides (TMDs) are intriguing materials that offer a unique platform to study fundamental physical phenomena as well as to explore development of novel devices. Semiconducting group 6 TMDs such as MoS2 and WSe2 are known for their large optical absorption coefficient and their potential for high efficiency photovoltaics and photodetectors. Monolayer sheets of these compounds are flexible, stretchable, and soft semiconductors with a direct band gap in contrast to their well-known bulk crystals that are rigid and hard indirect gap semiconductors. Recent intense research has been motivated by the distinct electrical, optical, and mechanical properties of these TMD crystals in the ultimate thickness regime. As a semiconductor with a band gap in the visible to near-IR frequencies, these 2D MX2 materials (M = Mo, W; X = S, Se) exhibit distinct excitonic absorption and emission features. In this Account, we discuss how optical spectroscopy of these materials allows investigation of their electronic properties and the relaxation dynamics of excitons. We first discuss the basic electronic structure of 2D TMDs highlighting the key features of the dispersion relation. With the help of theoretical calculations, we further discuss how photoluminescence energy of direct and indirect excitons provide a guide to understanding the evolution of the electronic structure as a function of the number of layers. We also highlight the behavior of the two competing conduction valleys and their role in the optical processes. Intercalation of group 6 TMDs by alkali metals results in the structural phase transformation with corresponding semiconductor-to-metal transition. Monolayer TMDs obtained by intercalation-assisted exfoliation retains the metastable metallic phase. Mild annealing, however, destabilizes the metastable phase and gradually restores the original semiconducting phase. Interestingly, the semiconducting 2H phase, metallic 1T phase, and a charge-density-wave-like 1T' phase can coexist within a single crystalline monolayer sheet. We further discuss the electronic properties of the restacked films of chemically exfoliated MoS2. Finally, we focus on the strong optical absorption and related exciton relaxation in monolayer and bilayer MX2. Monolayer MX2 absorbs as much as 30% of incident photons in the blue region of the visible light despite being atomically thin. This giant absorption is attributed to nesting of the conduction and valence bands, which leads to diversion of optical conductivity. We describe how the relaxation pathway of excitons depends strongly on the excitation energy. Excitation at the band nesting region is of unique significance because it leads to relaxation of electrons and holes with opposite momentum and spontaneous formation of indirect excitons.

Flexible organic–inorganic hybrid layer encapsulation for organic opto-electronic devices

In this work we produce and study the flexible organic–inorganic hybrid moisture barrier layers for the protection of air sensitive organic opto-electronic devices. The inorganic amorphous silicon nitride layer (SiNx:H) and the organic PMMA [poly (methyl methacrylate)] layer are deposited alternatingly by using hot wire chemical vapor deposition (HW-CVD) and spin-coating techniques, respectively. The effect of organic–inorganic hybrid interfaces is analyzed for increasing number of interfaces. We produce highly transparent (∼80% in the visible region) hybrid structures. The morphological properties are analysed providing a good basis for understanding the variation of the water vapor transmission rate (WVTR) values. A minimum WVTR of 4.5 × 10−5g/m2day is reported at the ambient atmospheric conditions for 7 organic/inorganic interfaces. The hybrid barriers show superb mechanical flexibility which confirms their high potential for flexible applications.

Optical properties of zirconium oxynitride films: the effect of composition, electronic and crystalline structures

tThis work is devoted to the investigation of zirconium oxynitride (ZrOxNy) films with varied opticalresponses prompted by the variations in their compositional and structural properties. The films wereprepared by dc reactive magnetron sputtering of Zr, using Ar and a reactive gas mixture of N2+ O2(17:3).The colour of the films changed from metallic-like, very bright yellow-pale and golden yellow, for low gasflows to red-brownish for intermediate gas flows. Associated to this colour change there was a significantdecrease of brightness. With further increase of the reactive gas flow, the colour of the samples changedfrom red-brownish to dark blue or even to interference colourations. The variations in composition dis-closed the existence of four different zones, which were found to be closely related with the variationsin the crystalline structure. XRD analysis revealed the change from a B1 NaCl face-centred cubic zirco-nium nitride-type phase for films prepared with low reactive gas flows, towards a poorly crystallizedover-stoichiometric nitride phase, which may be similar to that of Zr3N4with some probable oxygeninclusions within nitrogen positions, for films prepared with intermediate reactive gas flows. For highreactive gas flows, the films developed an oxynitride-type phase, similar to that of -Zr2ON2with someoxygen atoms occupying some of the nitrogen positions, evolving to a ZrO2monoclinic type structurewithin the zone where films were prepared with relatively high reactive gas flows. The analysis carriedout by reflected electron energy loss spectroscopy (REELS) revealed a continuous depopulation of thed-band and an opening of an energy gap between the valence band (2p) and the Fermi level close to 5 eV.The ZrN-based coatings (zone I and II) presented intrinsic colourations, with a decrease in brightness anda colour change from bright yellow to golden yellow, red brownish and dark blue. Associated to thesechanges, there was also a shift of the reflectivity minimum to lower energies, with the increase of thenon-metallic content. The samples lying in the two last zones (zone III, oxynitride and zone IV, oxide films)revealed a typical semi-transparent-optical behaviour showing interference-like colourations only dueto the complete depopulation of the d band at the Fermi level. The samples lying in these zones presentedalso an increase of the optical bandgap from 2 to 3.6 eV.

Column-based databases: estudo exploratório no âmbito das bases de dados NoSQL

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

Document-based databases: estudo comparativo no âmbito das bases de dados NoSql

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

Psychometric properties of assessment instruments for autism spectrum disorder: a systematic review of Brazilian studies

Objective To systematically review the scientific literature on the psychometric properties of international instruments for the assessment of autism spectrum disorder (ASD) in the Brazilian population. Methods A search of bibliographic references was conducted in six electronic databases: PsycINFO, PubMed, IndexPsi, Lilacs, Capes (theses and dissertations) and SciELO. The studies were selected by two independent researchers. Results The procedure identified 11 studies of the Brazilian population that encompassed six ASD assessment tools. Given the information provided, the adaptation of the M-CHAT, a screening instrument, was the best conducted. All steps of the adaptation process were described and the changes made to the final version of the instrument were presented, which was not addressed in other studies. In terms of reliability, all of the instruments that assessed internal consistency showed adequate values. In addition, the ADI-R and the CARS adaptations also satisfactorily contemplated inter-rater reliability and test-retest indices, respectively. Finally, all studies aiming to validate instruments showed evidence of validity and sensitivity, and specificity values above 0.90 were observed in the ASQ, ADI-R and ABC. Conclusion Considering both the psychometric aspects and the copyright information, the screening instrument that currently appears to be best indicated for clinical and research use is the M-CHAT. It was also noticed that there are still no specific ASD diagnostic tools available for use in Brazil. This lack of diagnostic instruments consists in a critical situation for the improvement of clinical practice and the development of research in this area.

Concepts and objects of awareness in Alzheimer’s disease: an updated systematic review

ABSTRACT Objectives To compare and discuss the objects of awareness in Alzheimer’s disease (AD): awareness of cognitive deficits, of functional activities, of social-emotional functioning and behavioral impairment. Methods A search in the PsycINFo, Pilots, PubMed/Medline and ISI electronic databases according to Prisma methodology was performed. We included studies about awareness in people with AD published between 2010 and 2015, with the combination of keywords: “Alzheimer AND awareness of deficits”, “Alzheimer AND anosognosia”, “Alzheimer AND insight”, “dementia AND awareness of deficits”, “dementia AND anosognosia”, “dementia AND insight”. The articles were categorized according to the specific object of awareness. Results Seven hundred and ten records were identified and, after application of the exclusion criteria, 191 studies were retrieved for potential use. After excluding the duplicates, 46 studies were included. Most studies assessed the cognitive domain of awareness, followed by the functional, social-emotional, and behavioral impairment domains. Memory deficits were not sufficient to explain impaired awareness in AD. Longitudinal studies did not find discrepancies between patients and caregivers’ reports, indicating that awareness is not related to cognition. Conflicting findings were observed, including the relation between awareness, mood, severity of disease, and personal characteristics. Conclusions The studies show lack of conceptual consensus and significant methodological differences. The inclusion of samples without differentiation of dementia etiology is associated to symptomatic differences, which affect awareness domains. Awareness in AD is a complex and multidimensional construct. Different objects elicit different levels of awareness.

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.

Breastfeeding and depression: a systematic review of the literature

Background: Research has separately indicated associations between pregnancy depression and breastfeeding, breastfeeding and postpartum depression, and pregnancy and postpartum depression. This paper aimed to provide a systematic literature review on breastfeeding and depression, considering both pregnancy and postpartum depression. Methods: An electronic search in three databases was performed using the keywords: “breast feeding”, “bottle feeding”, “depression”, “pregnancy”, and “postpartum”. Two investigators independently evaluated the titles and abstracts in a first stage and the full-text in a second stage review. Papers not addressing the association among breastfeeding and pregnancy or postpartum depression, non-original research and research focused on the effect of antidepressants were excluded. 48 studies were selected and included. Data were independently extracted. Results: Pregnancy depression predicts a shorter breastfeeding duration, but not breastfeeding intention or initiation. Breastfeeding duration is associated with postpartum depression in almost all studies. Postpartum depression predicts and is predicted by breastfeeding cessation in several studies. Pregnancy and postpartum depression are associated with shorter breastfeeding duration. Breastfeeding may mediate the association between pregnancy and postpartum depression. Pregnancy depression predicts shorter breastfeeding duration and that may increase depressive symptoms during postpartum. Limitations: The selected keywords may have led to the exclusion of relevant references. Conclusions: Although strong empirical evidence regarding the associations among breastfeeding and pregnancy or postpartum depression was separately provided, further research, such as prospective studies, is needed to clarify the association among these three variables. Help for depressed pregnant women should be delivered to enhance both breastfeeding and postpartum psychological adjustment.

Step towards to improve the voluntary interruption of pregnancy by means of business intelligence

With the implementation of Information and Communication Technologies in the health sector, it became possible the existence of an electronic record of information for patients, enabling the storage and the availability of their information in databases. However, without the implementation of a Business Intelligence (BI) system, this information has no value. Thus, the major motivation of this paper is to create a decision support system that allows the transformation of information into knowledge, giving usability to the stored data. The particular case addressed in this chapter is the Centro Materno Infantil do Norte, in particular the Voluntary Interruption of Pregnancy unit. With the creation of a BI system for this module, it is possible to design an interoperable, pervasive and real-time platform to support the decision-making process of health professionals, based on cases that occurred. Furthermore, this platform enables the automation of the process for obtaining key performance indicators that are presented annually by this health institution. In this chapter, the BI system implemented in the VIP unity in CMIN, some of the KPIs evaluated as well as the benefits of this implementation are presented.

Electronic tongue: a versatile tool for mineral and fruit-flavored waters recognition

Natural mineral waters (still), effervescent natural mineral waters (sparkling) and aromatized waters with fruit-flavors (still or sparkling) are an emerging market. In this work, the capability of a potentiometric electronic tongue, comprised with lipid polymeric membranes, to quantitatively estimate routinely quality physicochemical parameters (pH and conductivity) as well as to qualitatively classify water samples according to the type of water was evaluated. The study showed that a linear discriminant model, based on 21 sensors selected by the simulated annealing algorithm, could correctly classify 100 % of the water samples (leave-one out cross-validation). This potential was further demonstrated by applying a repeated K-fold cross-validation (guaranteeing that at least 15 % of independent samples were only used for internal-validation) for which 96 % of correct classifications were attained. The satisfactory recognition performance of the E-tongue could be attributed to the pH, conductivity, sugars and organic acids contents of the studied waters, which turned out in significant differences of sweetness perception indexes and total acid flavor. Moreover, the E-tongue combined with multivariate linear regression models, based on sub-sets of sensors selected by the simulated annealing algorithm, could accurately estimate waters pH (25 sensors: R 2 equal to 0.99 and 0.97 for leave-one-out or repeated K-folds cross-validation) and conductivity (23 sensors: R 2 equal to 0.997 and 0.99 for leave-one-out or repeated K-folds cross-validation). So, the overall satisfactory results achieved, allow envisaging a potential future application of electronic tongue devices for bottled water analysis and classification.