Childhood Physical Activity Involvement in Active and Inactive Female Adults

Current trends show progressive declines in levels of physical activity from childhood through adolescence and adulthood, most notably for females. The current study examined organized activity involvement in active and inactive females (age 18) using retrospective data. Results indicated that active females participated in significantly more physical activities than inactive females from age 6 to age 18. No significant differences were found between groups for non-physical activities. In addition, parents of active and inactive females were the most influential factor in initiating physical activity. However, parents of active females initiated more physical activity involvement than did parents of inactive females. Results also indicate that certain periods in childhood and adolescence appear to be critical for developing long-term physical activity habits.

Terrain Controls and Landscape-Scale Susceptibility Modelling of Active-Layer Detachments, Sabine Peninsula, Melville Island, Nunavut

Modelling the susceptibility of permafrost slopes to disturbance can identify areas at risk to future disturbance and result in safer infrastructure and resource development in the Arctic. In this study, we use terrain attributes derived from a digital elevation model, an inventory of permafrost slope disturbances known as active-layer detachments (ALDs) and generalised additive modelling to produce a map of permafrost slope disturbance susceptibility for an area on northern Melville Island, in the Canadian High Arctic. By examining terrain variables and their relative importance, we identified factors important for initiating slope disturbance. The model was calibrated and validated using 70 and 30 per cent of a data-set of 760 mapped ALDs, including disturbed and randomised undisturbed samples. The generalised additive model calibrated and validated very well, with areas under the receiver operating characteristic curve of 0.89 and 0.81, respectively, demonstrating its effectiveness at predicting disturbed and undisturbed samples. ALDs were most likely to occur below the marine limit on slope angles between 3 and 10° and in areas with low values of potential incoming solar radiation (north-facing slopes).

IMPROVING THE PERFORMANCE OF DATABASE-CENTRIC APPLICATIONS THROUGH PROGRAM ANALYSIS

Modern software applications are becoming more dependent on database management systems (DBMSs). DBMSs are usually used as black boxes by software developers. For example, Object-Relational Mapping (ORM) is one of the most popular database abstraction approaches that developers use nowadays. Using ORM, objects in Object-Oriented languages are mapped to records in the database, and object manipulations are automatically translated to SQL queries. As a result of such conceptual abstraction, developers do not need deep knowledge of databases; however, all too often this abstraction leads to inefficient and incorrect database access code. Thus, this thesis proposes a series of approaches to improve the performance of database-centric software applications that are implemented using ORM. Our approaches focus on troubleshooting and detecting inefficient (i.e., performance problems) database accesses in the source code, and we rank the detected problems based on their severity. We first conduct an empirical study on the maintenance of ORM code in both open source and industrial applications. We find that ORM performance-related configurations are rarely tuned in practice, and there is a need for tools that can help improve/tune the performance of ORM-based applications. Thus, we propose approaches along two dimensions to help developers improve the performance of ORM-based applications: 1) helping developers write more performant ORM code; and 2) helping developers configure ORM configurations. To provide tooling support to developers, we first propose static analysis approaches to detect performance anti-patterns in the source code. We automatically rank the detected anti-pattern instances according to their performance impacts. Our study finds that by resolving the detected anti-patterns, the application performance can be improved by 34% on average. We then discuss our experience and lessons learned when integrating our anti-pattern detection tool into industrial practice. We hope our experience can help improve the industrial adoption of future research tools. However, as static analysis approaches are prone to false positives and lack runtime information, we also propose dynamic analysis approaches to further help developers improve the performance of their database access code. We propose automated approaches to detect redundant data access anti-patterns in the database access code, and our study finds that resolving such redundant data access anti-patterns can improve application performance by an average of 17%. Finally, we propose an automated approach to tune performance-related ORM configurations using both static and dynamic analysis. Our study shows that our approach can help improve application throughput by 27--138%. Through our case studies on real-world applications, we show that all of our proposed approaches can provide valuable support to developers and help improve application performance significantly.