SQL in HPC

Arecibo Data Gateway: http://arecibo.tc.cornell.edu

• Provides access to pulsar search data from the Arecibo Observatory (radio telescope)
• Pulsar Search data resides in SQL Server database
• Uses pre-defined queries and searches and allows ad-hoc access
• Provides visual tools, scientists navigate data and perform analysis

Bioinformatics & Cycle-Scavenging: http://www.tc.cornell.edu/biocontest/

• Lightweight client installed on laptops, desktops, and even tablets.
• WebServices provide secure and legitimate data access.
• SQL Server well suited to 'checkout' problem sets and 'checkin' results
• more details

Predicting Microbial Diversity with C# and SQL Server

• Variation of Bioinformatics & Cycle-Scavenging project: uses compute nodes to do work in place of distributed clients.
• More computationally intesive.
• Tighter control over 'workflow' but, not much.
• Research Overview, Data Pipeline, Database Schema

An Operational System to Estimate Right Whale Feeding Areas from Satellite Data: http://sonofstager.tc.cornell.edu/RightWhales

• forecast potential right whale feeding areas based on the distribution of their main prey, Calanus finmarchicus, and sea-surface temperature gradients
• 10 partitioned tables of chlorophyll data (110-490 million rows each)
• 9 partitioned tables of sea temp data (120-580 million rows each)
• more details