From a NoSQL data source to a business intelligence solution: An experiment

We are living in the era of Big Data. A time which is characterized by the continuous creation of vast amounts of data, originated from different sources, and with different formats. First, with the rise of the social networks and, more recently, with the advent of the Internet of Things (IoT), in which everyone and (eventually) everything is linked to the Internet, data with enormous potential for organizations is being continuously generated. In order to be more competitive, organizations want to access and explore all the richness that is present in those data. Indeed, Big Data is only as valuable as the insights organizations gather from it to make better decisions, which is the main goal of Business Intelligence. In this paper we describe an experiment in which data obtained from a NoSQL data source (database technology explicitly developed to deal with the specificities of Big Data) is used to feed a Business Intelligence solution.

7to77, A new database querying experience

Nowadays, the vulgarization of information and communication technologies has reached to a level that the majority of people spend a lot of time using software to do regular tasks, ranging from games and ordinary time and weather utilities to some more sophisticated ones, like retail or banking applications. This new way of life is supported by the Internet or by specific applications that changed the image people had about using information and communication technologies. All over the world, the first cycle of studies of educational systems also has been addressed with the justification that this encourages the development of children. Taking this into consideration, we design and develop a visual explorer system for relational databases that can be used by everyone, from “7 to 77”, in an intuitive and easy way, getting immediate results – a new database querying experience. Thus, in this paper we will expose the main characteristics and features of this visual database explorer, showing how it works and how it can be used to execute the most current data manipulation operations over a database.

Aging and Alzheimer's disease: Searching for novel molecular cues

Tese de Doutoramento em Ciências da Saúde

Rockburst laboratory tests database - Application of data mining techniques

Rockburst is characterized by a violent explosion of a block causing a sudden rupture in the rock and is quite common in deep tunnels. It is critical to understand the phenomenon of rockburst, focusing on the patterns of occurrence so these events can be avoided and/or managed saving costs and possibly lives. The failure mechanism of rockburst needs to be better understood. Laboratory experiments are undergoing at the Laboratory for Geomechanics and Deep Underground Engineering (SKLGDUE) of Beijing and the system is described. A large number of rockburst tests were performed and their information collected, stored in a database and analyzed. Data Mining (DM) techniques were applied to the database in order to develop predictive models for the rockburst maximum stress (σRB) and rockburst risk index (IRB) that need the results of such tests to be determined. With the developed models it is possible to predict these parameters with high accuracy levels using data from the rock mass and specific project.

Historical analysis of the Brazilian cervical cancer screening program from 2006 to 2013: a time for reflection

BACKGROUND: The Cervical Cancer Database of the Brazilian National Health Service (SISCOLO) contains information regarding all cervical cytological tests and, if properly explored, can be used as a tool for monitoring and managing the cervical cancer screening program. The aim of this study was to perform a historical analysis of the cervical cancer screening program in Brazil from 2006 to 2013. MATERIAL AND METHODS: The data necessary to calculate quality indicators were obtained from the SISCOLO, a Brazilian health system tool. Joinpoint analysis was used to calculate the annual percentage change. RESULTS: We observed important trends showing decreased rates of low-grade squamous intraepithelial lesions (LSIL) and high-grade squamous intraepithelial lesions (HSIL) and an increased rate of rejected exams from 2009 to 2013. The index of positivity was maintained at levels below those indicated by international standards; very low frequencies of unsatisfactory cases were observed over the study period, which partially contradicts the low rate of positive cases. The number of positive cytological diagnoses was below that expected, considering that developed countries with low frequencies of cervical cancer detect more lesions annually. CONCLUSIONS: The evolution of indicators from 2006 to 2013 suggests that actions must be taken to improve the effectiveness of cervical cancer control in Brazil.

Searching for therapeutic strategies in a mouse modelo of Machado-Joseph disease: targeting proteostases

Tese de Doutoramento em Ciências da Saúde

Prevalence of thyroiditis and immunohistochemistry study searching for a morphologic consensus in morphology of autoimmune thyroiditis in a 4613 autopsies series

We sought to verify the prevalence of lymphocytic thyroiditis (LT) and Hashimoto's thyroiditis (HT) in autopsy materials. Cases examined between 2003 and 2007 at the Department of Pathology of Faculty of Medicine of São Paulo University were studied. Immunohistochemical analyses were conducted in selected cases to characterize the type of infiltrating mononuclear cells; in addition, we evaluated the frequency of apoptosis by TUNEL assay technique and caspase-3 immunostaining. Significant increase in overall thyroiditis frequency was observed in the present series when compared with the previous report (2.2978% vs. 0.0392%). Thyroiditis was more prevalent among older people. Selected cases of LT and HT (5 cases each) had their infiltrating lymphocytes characterized by immunohistochemical analyses. Both LT and HT showed similar immunostaining patterns for CD4, CD8, CD68, thus supporting a common pathophysiology mechanism and indicating that LT and HT should be considered different presentations of a same condition, that is, autoimmune thyroiditis. Moreover, apoptosis markers strongly evidenced that apoptosis was present in all studied cases. Our results demonstrated an impressive increase in the prevalence of thyroiditis during recent years and our data support that the terminology of autoimmune thyroiditis should be used to designate both LT and HT. This classification would facilitate comparison of prevalence data from different series and studies.

DNA evidence collecting in criminal investigation: Portuguese and Thai legal approaches

Doctoral Thesis in Juridical Sciences (Specialty in Public Legal Sciences)

Increase in mortality due to myocardial infarction in the Brazilian city of São Paulo during winter

OBJECTIVE: To study the seasonal variation in mortality due to myocardial infarction in the city of São Paulo. METHODS: We analyzed the database of PROAIM (Programa de Aprimoramento de Informações de Mortalidade) containing the registrations of the certificates of deaths due to myocardial infarction (International Classification of Diseases, 10th edition, classification I21) of the residents of the municipality of São Paulo during 12 months (from December 1996 to November 1997). The number of deaths was corrected for a standard period of 90 days and then it was divided by the corresponding population to obtain the event rate per 10 thousand inhabitants. The magnitude of the seasonal variation, which was defined by the difference of the relative risks between the seasons with higher and lower mortality, was estimated. RESULTS: A total of 5,615 deaths due to myocardial infarction were included in the study. Sixty-one per cent occurred in the male sex, and the mean age was 68 years. The mortality rate during winter was always higher and that during summer was lower than that during the other seasons (P<0.01), independent from age and sex. Seasonal variations in deaths due to myocardial infarction was 30% in the general group, being 23% in individuals who died younger than 75 years, and 44% in the older ones. CONCLUSION: A marked seasonal variation in mortality due to myocardial infarction was observed in the city of São Paulo, with a significant increase in its magnitude and age distribution during the winter, similar to those reported in regions of North America and Europe with temperate climates.

Trends in Productive Years of Life Lost to Premature Mortality Due to Coronary Heart Disease

OBJECTIVE: To estimate the number of productive years of life lost to premature death due to coronary heart disease in Brazil and to report their trends over a 20-year period. METHODS: The Brazilian Ministry of Health raw database on death due to coronary heart disease from 1979-1998 was used. The productive years of life lost to premature death were estimated using 20 and 59 years of age as the cut points for the productive years, replacing the potential years of 1 and 70 of the original formula. A descriptive analysis was provided with adjustments, means, proportions, ratios, percentages of increase or reduction, and mobile means. RESULTS: A 35.8% increase in death for males and 51.3% for females was observed, +43.3% being the relative difference for females. The annual means of the productive years of life prematurely lost were analyzed in 140,865 males and 58,559 females, with the differential ratio between the age groups ranging from 2.3 to 2.5. The annual means were less favorable for males. Within each group (intragroup), the ratios decreased with the increase in age, and the age means at the time of death remained constant. The raw tendencies decreased in the 20- to 29-year age group and increased in the 40- to 59-year age group for females and the 40- to 49-year age group for males. When adjusted, the raw tendencies decreased. CONCLUSION: The 43.3% increase in the number of female deaths as compared with that of males and the ascending tendency in the productive years of life lost in the 40- to 59-year age group point to the influence of unfavorable changes in female lifestyles and suggest a deficiency in programs for prevention and control of risk factors and in their treatment in both sexes.

Pulmonary Embolism Mortality in Brazil from 1989 to 2010: Gender and Regional Disparities

Abstract Background: A significant variation in pulmonary embolism (PE) mortality trends have been documented around the world. We investigated the trends in mortality rate from PE in Brazil over a period of 21 years and its regional and gender differences. Methods: Using a nationwide database of death certificate information we searched for all cases with PE as the underlying cause of death between 1989 and 2010. Population data were obtained from the Brazilian Institute of Geography and Statistics (IBGE). We calculated age-, gender- and region-specific mortality rates for each year, using the 2000 Brazilian population for direct standardization. Results: Over 21 years the age-standardized mortality rate (ASMR) fell 31% from 3.04/100,000 to 2.09/100,000. In every year between 1989 and 2010, the ASMR was higher in women than in men, but both showed a significant declining trend, from 3.10/100,000 to 2.36/100,000 and from 2.94/100,000 to 1.80/100,000, respectively. Although all country regions showed a decline in their ASMR, the largest fall in death rates was concentrated in the highest income regions of the South and Southeast Brazil. The North and Northeast regions, the lowest income areas, showed a less marked fall in death rates and no distinct change in the PE mortality rate in women. Conclusions: Our study showed a reduction in the PE mortality rate over two decades in Brazil. However, significant variation in this trend was observed amongst the five country regions and between genders, pointing to possible disparities in health care access and quality in these groups.

Use of DNA profiles for investigation using a simulated national DNA database: Part I. Partial SGM Plus profiles.

In traditional criminal investigation, uncertainties are often dealt with using a combination of common sense, practical considerations and experience, but rarely with tailored statistical models. For example, in some countries, in order to search for a given profile in the national DNA database, it must have allelic information for six or more of the ten SGM Plus loci for a simple trace. If the profile does not have this amount of information then it cannot be searched in the national DNA database (NDNAD). This requirement (of a result at six or more loci) is not based on a statistical approach, but rather on the feeling that six or more would be sufficient. A statistical approach, however, could be more rigorous and objective and would take into consideration factors such as the probability of adventitious matches relative to the actual database size and/or investigator's requirements in a sensible way. Therefore, this research was undertaken to establish scientific foundations pertaining to the use of partial SGM Plus loci profiles (or similar) for investigation.

Safety and occlusion rates of surgical treatment of unruptured intracranial aneurysms: a systematic review and meta-analysis of the literature from 1990 to 2011.

BACKGROUND AND PURPOSE: Surgical clipping of unruptured intracranial aneurysms (UIAs) has recently been challenged by the emergence of endovascular treatment. We performed an updated systematic review and meta-analysis on the surgical treatment of UIAs, in an attempt to determine the aneurysm occlusion rates and safety of surgery in the modern era. METHODS: A detailed protocol was developed prior to conducting the review according to the Cochrane Collaboration guidelines. Electronic databases spanning January 1990-April 2011 were searched, complemented by hand searching. Heterogeneity was assessed using I(2), and publication bias with funnel plots. Surgical mortality and morbidity were analysed with weighted random effect models. RESULTS: 60 studies with 9845 patients harbouring 10 845 aneurysms were included. Mortality occurred in 157 patients (1.7%; 99% CI 0.9% to 3.0%; I(2)=82%). Unfavourable outcomes, including death, occurred in 692 patients (6.7%; 99% CI 4.9% to 9.0%; I(2)=85%). Morbidity rates were significantly greater in higher quality studies, and with large or posterior circulation aneurysms. Reported morbidity rates decreased over time. Studies were generally of poor quality; funnel plots showed heterogeneous results and publication bias, and data on aneurysm occlusion rates were scant. CONCLUSIONS: In studies published between 1990 and 2011, clipping of UIAs was associated with 1.7% mortality and 6.7% overall morbidity. The reputed durability of clipping has not been rigorously documented. Due to the quality of the included studies, the available literature cannot properly guide clinical decisions.

Four-month-olds make triangular bids to father and mother during trilogue play with still-face

(from the journal abstract) A new observational procedure, Trilogue Play with Still-face, revealed 4-month-olds' capacities to address both their fathers and mothers, by rapidly shifting gaze and affect between them. Infants were observed in four interactive contexts: (1) '3-together' play with both parents; (2) '2 + 1' play with one parent engaging and the other as third party; (3) the same, with one parent posing a still-face; (4) '3-together' play. Infants were able to discriminate between the four contexts. They coordinated three social poles of attention in each one. Their affect configurations were context sensitive. These findings demonstrate the infant's social capacities for triangular, three-person interactions, in addition to dyadic, two-person, and triadic, two-person plus object, ones. They support a view of intersubjectivity as primary and point to a promising field of investigation for the study of family process. (PsycINFO Database Record (c) 2005 APA, all rights reserved)

Predicting positive food challenges in children sensitised to peanuts/tree nuts.

BACKGROUND: Children with atopic diseases in early life are frequently found with positive IgE tests to peanuts/tree nuts without a history of previous ingestion. We aimed to identify risk factors for reactions to nuts at first introduction. METHODS: A retrospective case-note and database analysis was performed. Recruitment criteria were: patients aged 3-16 yr who had a standardized food challenge to peanut and/or tree nuts due to sensitisation to the peanut/tree nut (positive spIgE or SPT) without previous consumption. A detailed assessment was performed of factors relating to food challenge outcome with univariate and multivariate logistic regression analysis. RESULTS: There were 98 food challenges (47 peanut, 51 tree nut) with 29 positive, 67 negative and 2 inconclusive outcomes. A positive maternal history of allergy and a specific IgE >5 kU/l were strongly associated with a significantly increased risk of a positive food challenge (OR 3.73; 95% CI 1.31-10.59; p = 0.013 and OR 3.35; 95% CI 1.23-9.11; p = 0.007, respectively). Adjusting for age, a three year-old with these criteria has a 67% probability of a positive challenge. There was no significant association between types of peanut/tree nut, other food allergies, atopic conditions or severity of previous food reactions and positive challenges. CONCLUSIONS: We have demonstrated an association between the presence of maternal atopic history and a specific IgE >5 kU/l, with a significant increase in the likelihood of a positive food challenge. Although requiring further prospective validation these easily identifiable components should be considered when deciding the need for a challenge.