Optimizing multiple dimensional queries simultaneously in multidimensional databases

Some significant progress related to multidimensional data analysis has been achieved in the past few years, including the design of fast algorithms for computing datacubes, selecting some precomputed group-bys to materialize, and designing efficient storage structures for multidimensional data. However, little work has been carried out on multidimensional query optimization issues. Particularly the response time (or evaluation cost) for answering several related dimensional queries simultaneously is crucial to the OLAP applications. Recently, Zhao et al. first exploited this problem by presenting three heuristic algorithms. In this paper we first consider in detail two cases of the problem in which all the queries are either hash-based star joins or index-based star joins only. In the case of the hash-based star join, we devise a polynomial approximation algorithm which delivers a plan whose evaluation cost is $ O(n^{\epsilon }$) times the optimal, where n is the number of queries and is a fixed constant with . We also present an exponential algorithm which delivers a plan with the optimal evaluation cost. In the case of the index-based star join, we present a heuristic algorithm which delivers a plan whose evaluation cost is n times the optimal, and an exponential algorithm which delivers a plan with the optimal evaluation cost. We then consider a general case in which both hash-based star-join and index-based star-join queries are included. For this case, we give a possible improvement on the work of Zhao et al., based on an analysis of their solutions. We also develop another heuristic and an exact algorithm for the problem. We finally conduct a performance study by implementing our algorithms. The experimental results demonstrate that the solutions delivered for the restricted cases are always within two times of the optimal, which confirms our theoretical upper bounds. Actually these experiments produce much better results than our theoretical estimates. To the best of our knowledge, this is the only development of polynomial algorithms for the first two cases which are able to deliver plans with deterministic performance guarantees in terms of the qualities of the plans generated. The previous approaches including that of [ZDNS98] may generate a feasible plan for the problem in these two cases, but they do not provide any performance guarantee, i.e., the plans generated by their algorithms can be arbitrarily far from the optimal one. Received: July 21, 1998 / Accepted: August 26, 1999     

The road to intelligence

It is argued that robotic platforms are the way forward towards building intelligent systems, where multiple sensors and manipulation are used for cognitive processes. It is also argued that the cue for developing the right architecture for such a system is human language.     

A platform for the development of patient applications in the domain of personalized health

Personalized health (p-health) systems can contribute significantly to the sustainability of healthcare systems, though their feasibility is yet to be proven. One of the problems related to their development is the lack of well-established development tools for this domain. As the p-health paradigm is focused on patient self-management, big challenges arise around the design and implementation of patient systems. This paper presents a reference platform created for the development of these applications, and shows the advantages of its adoption in a complex project dealing with cardio-vascular diseases.     

Inserts for fastening sheet molding compounds

New stainless steel inserts are developed for fastening sheet molding compound (SMC). Using these molded-in inserts, SMC components can be assembled without protrusions. The inserts consist of two mating surfaces which interlock through the existence of a shoulder male boss and a shoulder female counterbore. Repeated assembly and disassembly can take place without damaging the material being fastened. The strength of the joint, when using these interlocking inserts, is comparable to that when using bolts. Also being investigated is the strength of the joint after being immersed in water for half a month. The difference between the dry and wet strengths for the inserted samples is less than that for the bolted samples. Load versus extension plots show that these particular inserts provide a more rigid joint than a bolted connection.     

Distinct Tomato Cultivars Are Characterized by a Differential Pattern of Biochemical Responses to Drought Stress

Future climate scenarios suggest that crop plants will experience environmental changes capable of affecting their productivity. Among the most harmful environmental stresses is drought, defined as a total or partial lack of water availability. It is essential to study and understand both the damage caused by drought on crop plants and the mechanisms implemented to tolerate the stress. In this study, we focused on four cultivars of tomato, an economically important crop in the Mediterranean basin. We investigated the biochemical mechanisms of plant defense against drought by focusing on proteins specifically involved in this stress, such as osmotin, dehydrin, and aquaporin, and on proteins involved in the general stress response, such as HSP70 and cyclophilins. Since sugars are also known to act as osmoprotectants in plant cells, proteins involved in sugar metabolism (such as RuBisCO and sucrose synthase) were also analyzed. The results show crucial differences in biochemical behavior among the selected cultivars and highlight that the most tolerant tomato cultivars adopt quite specific biochemical strategies such as different accumulations of aquaporins and osmotins. The data set also suggests that RuBisCO isoforms and aquaporins can be used as markers of tolerance/susceptibility to drought stress and be used to select tomato cultivars within breeding programs.     

Specific Local Predictors That Reflect the Tropism of Endometriosis—A Multiple Immunohistochemistry Technique

Ectopic endometrial epithelium associates a wide spectrum of symptomatology. Their evolution can be influenced by inflammatory and vascular changes, that affect not only the structure and cell proliferation rate, but also symptoms. This prospective study involved tissue samples from surgically treated patients, stained using classical histotechniques and immunohistochemistry. We assessed ectopic endometrial glands (CK7+, CK20−), adjacent blood vessels (CD34+), estrogen/progesterone hormone receptors (ER+, PR+), inflammatory cells (CD3+, CD20+, CD68+, Tryptase+), rate of inflammatory cells (Ki67+) and oncoproteins (BCL2+, PTEN+, p53+) involved in the development of endometriosis/adenomyosis. A CK7+/CK20− expression profile was present in the ectopic epithelium and differentiated it from digestive metastases. ER+/PR+ were present in all cases analyzed. We found an increased vascularity (CD34+) in the areas with abdominal endometriosis and CD3+−:T-lymphocytes, CD20+−:B-lymphocytes, CD68+:macrophages, and Tryptase+: mastocytes were abundant, especially in cases with adenomyosis as a marker of proinflammatory microenvironment. In addition, we found a significantly higher division index-(Ki67+) in the areas with adenomyosis, and inactivation of tumor suppressor genes-p53+ in areas with neoplastic changes. The inflammatory/vascular/hormonal mechanisms trigger endometriosis progression and neoplastic changes increasing local pain. Furthermore, they may represent future therapeutic targets. Simultaneous-multiple immunohistochemical labelling represents a valuable technique for rapidly detecting cellular features that facilitate comparative analysis of the studied predictors.     

Improvement of Glycaemia and Endothelial Function by a New Low-Dose Curcuminoid in an Animal Model of Type 2 Diabetes

Curcumin has been suggested as a promising treatment for metabolic diseases, but the high doses required limit its therapeutic use. In this study, a new curcuminoid is synthesised to increase curcumin anti-inflammatory and antioxidant potential and to achieve hypoglycaemic and protective vascular effects in type 2 diabetic rats in a lower dose. In vitro, the anti-inflammatory effect was determined through the Griess reaction, and the antioxidant activity through ABTS and TBARS assays. In vivo, Goto-Kakizaki rats were treated for 2 weeks with the equimolar dose of curcumin (40 mg/kg/day) or curcuminoid (52.4 mg/kg/day). Fasting glycaemia, insulin tolerance, plasma insulin, insulin signalling, serum FFA, endothelial function and several markers of oxidative stress were evaluated. Both compounds presented a significant anti-inflammatory effect. Moreover, the curcuminoid had a marked hypoglycaemic effect, accompanied by higher GLUT4 levels in adipose tissue. Both compounds increased NO-dependent vasorelaxation, but only the curcuminoid exacerbated the response to ascorbic acid, consistent with a higher decrease in vascular oxidative and nitrosative stress. SOD1 and GLO1 levels were increased in EAT and heart, respectively. Altogether, these data suggest that the curcuminoid developed here has more pronounced effects than curcumin in low doses, improving the oxidative stress, endothelial function and glycaemic profile in type 2 diabetes.     

Order vs. Disorder: Cholesterol and Omega-3 Phospholipids Determine Biomembrane Organization

Lipid structural diversity strongly affects biomembrane chemico-physical and structural properties in addition to membrane-associated events. At high concentrations, cholesterol increases membrane order and rigidity, while polyunsaturated lipids are reported to increase disorder and flexibility. How these different tendencies balance in composite bilayers is still controversial. In this study, electron paramagnetic resonance spectroscopy, small angle neutron scattering, and neutron reflectivity were used to investigate the structural properties of cholesterol-containing lipid bilayers in the fluid state with increasing amounts of polyunsaturated omega-3 lipids. Either the hybrid 1-stearoyl-2-docosahexaenoyl-sn-glycero-3-phosphocholine or the symmetric 1,2-docosahexaenoyl-sn-glycero-3-phosphocholine were added to the mixture of the naturally abundant 1-palmitoyl-2-oleyl-sn-glycero-3-phosphocholine and cholesterol. Our results indicate that the hybrid and the symmetric omega-3 phospholipids affect the microscopic organization of lipid bilayers differently. Cholesterol does not segregate from polyunsaturated phospholipids and, through interactions with them, is able to suppress the formation of non-lamellar structures induced by the symmetric polyunsaturated lipid. However, this order/disorder balance leads to a bilayer whose structural organization cannot be ascribed to either a liquid ordered or to a canonical liquid disordered phase, in that it displays a very loose packing of the intermediate segments of lipid chains.     

Insights into the Pharmacokinetics and In Vitro Cell-Based Studies of the Imidazoline I2 Receptor Ligand B06

The impact of neurodegenerative diseases (ND) is becoming unbearable for humankind due to their vast prevalence and the lack of efficacious treatments. In this scenario, we focused on imidazoline I₂ receptors (I₂-IR) that are widely distributed in the brain and are altered in patients with brain disorders. We took the challenge of modulating I₂-IR by developing structurally new molecules, in particular, a family of bicyclic α-iminophosphonates, endowed with high affinity and selectivity to these receptors. Treatment of two murine models, one for age-related cognitive decline and the other for Alzheimer’s disease (AD), with representative compound B06 ameliorated their cognitive impairment and improved their behavioural condition. Furthermore, B06 revealed beneficial in vitro ADME-Tox properties. The pharmacokinetics (PK) and metabolic profile are reported to de-risk B06 for progressing in the preclinical development. To further characterize the pharmacological properties of B06, we assessed its neuroprotective properties and beneficial effect in an in vitro model of Parkinson’s disease (PD). B06 rescued the human dopaminergic cell line SH-SY5Y from death after treatment with 6-hydroxydopamine (6-OHDA) and showed a crucial anti-inflammatory effect in a cellular model of neuroinflammation. This research reveals B06 as a putative candidate for advancing in the difficult path of drug discovery and supports the modulation of I₂-IR as a fresh approach for the therapy of ND.