Extraction of fact tables from a relational database: an effort to establish rules in denormalization

Relational databases are supported by very well established models. However, some neglected problems can occur with the join operator: semantic mistakes caused by the multiple access path problem and faults when connection traps arise. In this paper we intend to identify and overcome those problems and to establish rules for relational data denormalization. Two denormalization forms are proposed and a case study is presented.info:eu-repo/semantics/publishedVersio

Site Fidelity in Space Use by Spider Monkeys (Ateles geoffroyi) in the Yucatan Peninsula, Mexico

Animal home ranges may vary little in their size and location in the short term but nevertheless show more variability in the long term. We evaluated the degree of site fidelity of two groups of spider monkeys (Ateles geoffroyi) over a 10- and 13-year period, respectively, in the northeastern Yucatan peninsula, Mexico. We used the Local Convex Hull method to estimate yearly home ranges and core areas (defined as the 60% probability contour) for the two groups. Home ranges varied from 7.7 to 49.6 ha and core areas varied from 3.1 to 9.2 ha. We evaluated the degree of site fidelity by quantifying the number of years in which different areas were used as either home ranges or core areas. Large tracts were used only as home ranges and only for a few years, whereas small areas were used as either core area or home range for the duration of the study. The sum of the yearly core areas coincided partially with the yearly home ranges, indicating that home ranges contain areas used intermittently. Home ranges, and especially core areas, contained a higher proportion of mature forest than the larger study site as a whole. Across years and only in one group, the size of core areas was positively correlated with the proportion of adult males in the group, while the size of home ranges was positively correlated with both the proportion of males and the number of tree species included in the diet. Our findings suggest that spider monkey home ranges are the result of a combination of long-term site fidelity and year-to-year use variation to enable exploration of new resources

Quercetin enhances 5-fluorouracil-induced apoptosis in MSI colorectal cancer cells through p53 modulation

Purpose: Colorectal tumors (CRC) with microsatellite instability (MSI) show resistance to chemotherapy with 5-fluorouracil (5-FU), the most widely used pharmacological drug for CRC treatment. The aims of this study were to test the ability of quercetin (Q) and luteolin (L) to increase sensitivity of MSI CRC cells to 5-FU and characterize the dependence of the effects on cells´ p53 status. Methods: Two MSI human CRC derived cell lines were used, CO115 wild-type (wt) for p53 and HCT15 that harbors a p53 mutation. Apoptosis induction in these cells by 5-FU, Q and L alone and in combinations were evaluated by TUNEL and western. The dependence on p53 of the effects was confirmed by small interference RNA (siRNA) in CO115 cells and in MSI HCT116 wt and p53 knockout cells. Results: CO115 p53-wt cells are more sensitive to 5-FU than the p53 mutated HCT15. The combination treatment of 5-FU with L and Q increased apoptosis with a significant effect for Q in CO115. Both flavonoids increased p53 expression in both cell lines, an effect particularly remarkable for Q. The significant apoptotic enhancement in CO115 incubated with Q plus 5-FU involved the activation of the apoptotic mitochondrial pathway. Importantly, knockdown of p53 by siRNA in CO115 cells and p53 knockout in HCT116 cells totally abrogated apoptosis induction, demonstrating the dependence of the effect on p53 modulation by Q. Conclusion: This study suggests the potential applicability of these phytochemicals for enhancement 5-FU efficiency in MSI CRC therapy, especially Q in p53 wt tumors.CPRX was supported by the Foundation for Science and Technology (FCT), Portugal, through the grant SFRH/BD/27524/2006 and the work was supported by the FCT research grant PTDC/AGR-AAM/70418/2006