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.

High body mass index is not a barrier to physical activity: Analysis of international rugby players' anthropometric data

Recent data indicate that levels of overweight and obesity are increasing at an alarming rate throughout the world. At a population level (and commonly to assess individual health risk), the prevalence of overweight and obesity is calculated using cut-offs of the Body Mass Index (BMI) derived from height and weight. Similarly, the BMI is also used to classify individuals and to provide a notional indication of potential health risk. It is likely that epidemiologic surveys that are reliant on BMI as a measure of adiposity will overestimate the number of individuals in the overweight (and slightly obese) categories. This tendency to misclassify individuals may be more pronounced in athletic populations or groups in which the proportion of more active individuals is higher. This differential is most pronounced in sports where it is advantageous to have a high BMI (but not necessarily high fatness). To illustrate this point we calculated the BMIs of international professional rugby players from the four teams involved in the semi-finals of the 2003 Rugby Union World Cup. According to the World Health Organisation (WHO) cut-offs for BMI, approximately 65% of the players were classified as overweight and approximately 25% as obese. These findings demonstrate that a high BMI is commonplace (and a potentially desirable attribute for sport performance) in professional rugby players. An unanswered question is what proportion of the wider population, classified as overweight (or obese) according to the BMI, is misclassified according to both fatness and health risk? It is evident that being overweight should not be an obstacle to a physically active lifestyle. Similarly, a reliance on BMI alone may misclassify a number of individuals who might otherwise have been automatically considered fat and/or unfit.

Constructing an Internationalisation Readiness Index

In this study we incorporate a pre-internationalisation phase into the traditional Uppsala model of firm internationalisation to address the question: Where does the process begin? We identify through the literature four concepts fundamental to the ability of a firm to begin internationalisation of its operations: stimuli, attitudinal/psychological commitment, resources and lateral rigidity. Through a survey of 274 Australian exporting and non-exporting firms we collect data relating to the four pre-internationalisation concepts. An internationalisation readiness index is constructed and applied to some representative cases to establish its validity as a diagnostic tool.

Developing a rural land investment performance index for New Zealand

Agricultural production is one of the major industries in New Zealand and accounts for over 60% of all export trade. The farming industry comprises 70,000 entities ranging in size from small individual run farms to large corporate operations. The reliance of the New Zealand economy to the international rural sector has seen considerable volatility in the rural land markets over the past four decades, with significant shifts in rural land prices based on location, land use and underlying international rural commodity prices. With the increasing attention being paid to the rural sector, especially in relation to food production and bio-fuels, there has been an increasing corporate interest in rural land ownership in relatively low subsidised agricultural producing countries such as New Zealand and Australia. A factor that has limited this participation of institutional investors previously has been a lack of reliable and up-to-date investment performance data for this asset class. This paper is the initial starting phase in the development of a New Zealand South Island rural land investment performance index and covers the period 1990-2007. The research in this paper analyses all rural sales transactions in the South Island and develops a capital return index for rural property based on major rural property land use. Additional work on this index will cover both total return performance and geographic location.