The SB-index and the HSB-index: efficient indices for spatial data warehouses

Spatial data warehouses (SDWs) allow for spatial analysis together with analytical multidimensional queries over huge volumes of data. The challenge is to retrieve data related to ad hoc spatial query windows according to spatial predicates, avoiding the high cost of joining large tables. Therefore, mechanisms to provide efficient query processing over SDWs are essential. In this paper, we propose two efficient indices for SDW: the SB-index and the HSB-index. The proposed indices share the following characteristics. They enable multidimensional queries with spatial predicate for SDW and also support predefined spatial hierarchies. Furthermore, they compute the spatial predicate and transform it into a conventional one, which can be evaluated together with other conventional predicates by accessing a star-join Bitmap index. While the SB-index has a sequential data structure, the HSB-index uses a hierarchical data structure to enable spatial objects clustering and a specialized buffer-pool to decrease the number of disk accesses. The advantages of the SB-index and the HSB-index over the DBMS resources for SDW indexing (i.e. star-join computation and materialized views) were investigated through performance tests, which issued roll-up operations extended with containment and intersection range queries. The performance results showed that improvements ranged from 68% up to 99% over both the star-join computation and the materialized view. Furthermore, the proposed indices proved to be very compact, adding only less than 1% to the storage requirements. Therefore, both the SB-index and the HSB-index are excellent choices for SDW indexing. Choosing between the SB-index and the HSB-index mainly depends on the query selectivity of spatial predicates. While low query selectivity benefits the HSB-index, the SB-index provides better performance for higher query selectivity.

An illustrated key to the genera and subgenera of the Recent azooxanthellate Scleractinia (Cnidaria, Anthozoa), with an attached glossary

The 120 presently recognized genera and seven subgenera of the azooxanthellate Scleractinia are keyed using gross morphological characters of the corallum. All genera are illustrated with calicular and side views of coralla. All termes used in the key are defined in an illustrated glossary. A table of all species-level keys, both comprehensive and faunistic, is provided covering the last 40 years.

Frequency and predictors of symptomatic intracranial hemorrhage after intravenous thrombolysis for acute ischemic stroke in a Brazilian public hospital

OBJECTIVE: Scarce data are available on the occurrence of symptomatic intracranial hemorrhage related to intravenous thrombolysis for acute stroke in South America. We aimed to address the frequency and clinical predictors of symptomatic intracranial hemorrhage after stroke thrombolysis at our tertiary emergency unit in Brazil. METHOD: We reviewed the clinical and radiological data of 117 consecutive acute ischemic stroke patients treated with intravenous thrombolysis in our hospital between May 2001 and April 2010. We compared our results with those of the Safe Implementation of Thrombolysis in Stroke registry. Univariate and multiple regression analyses were performed to identify factors associated with symptomatic intracranial transformation. RESULTS: In total, 113 cases from the initial sample were analyzed. The median National Institutes of Health Stroke Scale score was 16 (interquartile range: 10-20). The median onset-to-treatment time was 188 minutes (interquartile range: 155-227). There were seven symptomatic intracranial hemorrhages (6.2%; Safe Implementation of Thrombolysis in Stroke registry: 4.9%; p = 0.505). In the univariate analysis, current statin treatment and elevated National Institute of Health Stroke Scale scores were related to symptomatic intracranial hemorrhage. After the multivariate analysis, current statin treatment was the only factor independently associated with symptomatic intracranial hemorrhage. CONCLUSIONS: In this series of Brazilian patients with severe strokes treated with intravenous thrombolysis in a public university hospital at a late treatment window, we found no increase in the rate of symptomatic intracranial hemorrhage. Additional studies are necessary to clarify the possible association between statins and the risk of symptomatic intracranial hemorrhage after stroke thrombolysis.

A comparative radiographic investigation of femoroacetabular impingement in young patients with and without hip pain

OBJECTIVE: To compare the existence of radiographic abnormalities in two groups of patients, those with and without hip pain. METHODS: A total 222 patients were evaluated between March 2007 and April 2009; 122 complained of groin pain, and 100 had no symptoms. The individuals in both groups underwent radiographic examinations of the hip using the following views: anteroposterior, Lequesne false profile, Dunn, Dunn 45º, and Ducroquet. RESULTS: A total of 1110 radiographs were evaluated. Female patients were prevalent in both groups (52% symptomatic, 58% asymptomatic). There were statistically significant differences between the groups in age (p<0.0001), weight (p = 0.002) and BMI (p = 0.006). The positive findings in the group with groin pain consisted of the presence of a bump on the femoral head in the anteroposterior view (p<0.0001) or in the Dunn 45º view (p = 0.008). The difference in the a angle in the anteroposterior, Dunn, Dunn 45º, and Ducroquet views for all of the cases studied was p,0.0001. The joint space measurement differed significantly between groups in the Lequesne view (p = 0.007). The Lequesne anteversion angle (ρ) and the femoral offset measurement also differed significantly (p = 0.005 and p = 0.0001, respectively). CONCLUSIONS: We conclude that the best views for diagnosing a femoroacetabular impingement are the anteroposterior pelvic orthostatic, the Dunn 45º, and the Ducroquet views. The following findings correlated with hip pain: a decrease in the femoral offset, an increase in the α angle, an increase in the Lequesne ρ angle, a decrease in the CE angle of Wiberg, a thinner articular space and the presence of a bump on the femoral head-neck transition.

One-repetition maximum test and isokinetic leg extension and flexion: correlations and predicted values

The most typical maximum tests for measuring leg muscle performance are the one-repetition maximum leg press test (1RMleg) and the isokinetic knee extension/flexion (IKEF) test. Nevertheless, their inter-correlations have not been well documented, mainly the predicted values of these evaluations. This correlational and regression analysis study involved 30 healthy young males aged 18-24y, who have performed both tests. Pearson's product moment correlation between 1RMleg and IKEF varied from 0.20 to 0.69 and the more exact predicted test was to 1RMleg (R2 = 0.71). The study showed correlations between 1RMleg and IKEF although these tests are different (isotonic vs. isokinetic) and provided further support for cross determination of 1RMleg and IKEF by linear and multiple linear regression analysis.