Conor Cunningham

Learn More
PIVOT and UNPIVOT, two operators on tabular data that exchange rows and columns, enable data transformations useful in data modeling, data analysis, and data presentation. They can quite easily be implemented inside a query processor, much like select, project, and join. Such a design provides opportunities for better performance, both during query(More)
OBJECTIVES (1) Investigate whether clustered cardiometabolic risk score, cardiorespiratory fitness (CRF), sedentary time (ST), and body mass index Z-scores (BMI Z-scores), differed between participants that met and did not achieve ≥60 min of daily moderate to vigorous intensity physical activity (MVPA). (2) Compare clustered cardiometabolic risk score, BMI(More)
This paper presents an architecture overview of the distributed, heterogeneous query processor (DHQP) in the Microsoft SQL server database system to enable queries over a large collection of diverse data sources. The paper highlights three salient aspects of the architecture. First, the system introduces well-defined abstractions such as connections,(More)
The future of solid organ transplantation is challenged by an increasing shortage of available allografts. Xenotransplantation of genetically modified porcine organs offers an answer to this problem. Strategies of genetic modification have ‘humanized’ the porcine model towards clinical relevance. Most notably, these approaches have aimed at either antigen(More)
While there are known performance trade-offs between database page buffer pool and query execution memory allocation policies, little has been written on the impact of query compilation memory use on overall throughput of the database management system (DBMS). We present a new aspect of the query optimization problem and discuss a solution implemented in(More)
When SQL Azure was released in August 2009, it was the first database service of its kind along multiple axes, compared to other Cloud services: shared nothing architecture and log-based replication; support for full ACID properties; providing consistency and high availability; and by offering near 100% compatibility with on-premise SQL Server delivered a(More)
OBJECTIVES To evaluate the ability of BMI, WC, and WHtR to identify increased cardiometabolic risk in pre-adolescents. METHODS This is a cross-sectional study involving 192 children (10.92 ± 0.58 years, 56% female) from the United Kingdom between 2010 and 2013. Receiver operating characteristic curves determined the discriminatory ability of BMI, WC and(More)
This study compared children's physical activity (PA) levels, the prevalence of children meeting current guidelines of ≥60 minutes of daily moderate to vigorous PA (MVPA), and PA-health associations using individually calibrated (IC) and empirical accelerometer cutpoints. Data from 75 (n = 32 boys) 10-12 year old children were included in this study.(More)
PIVOT and UNPIVOT, two operators on tabular data that exchange rows and columns, enable data transformations useful in data modeling, data analysis, and data presentation. They can quite easily be implemented inside a query processor, much like select, project, and join. Such a design provides opportunities for better performance, both during query(More)
  • 1