{"id":189894,"date":"2013-08-29T00:00:00","date_gmt":"2013-09-04T14:27:37","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/msr-research-item\/real-time-collaborative-analysis-with-almost-pure-sql-a-case-study-in-biogeochemical-oceanography\/"},"modified":"2016-08-02T06:11:37","modified_gmt":"2016-08-02T13:11:37","slug":"real-time-collaborative-analysis-with-almost-pure-sql-a-case-study-in-biogeochemical-oceanography","status":"publish","type":"msr-video","link":"https:\/\/www.microsoft.com\/en-us\/research\/video\/real-time-collaborative-analysis-with-almost-pure-sql-a-case-study-in-biogeochemical-oceanography\/","title":{"rendered":"Real-Time Collaborative Analysis with (Almost) Pure SQL: A Case Study in Biogeochemical Oceanography"},"content":{"rendered":"<div class=\"asset-content\">\n<p>What would you do to help more than 40 scientists, coming together from all over the US for 2 days, extract high-level insights from a pile of loosely-linked spreadsheets? In this talk, I will discuss our field experiment using SQL-as-a-Service to support &#8220;instant analysis&#8221; of oceanographic data in real-time. I will tell you about our work as &#8220;SQL stenographers&#8221; \u2013 capturing scientific discussion in real-time, integrating relevant data, and populating visualizations to help test hypotheses interactively. We found that not only was it feasible to support interactive Q&A on the fly, but that we significantly increased the value of the meeting&#8217;s &#8220;face time&#8221;. With this field test, we also uncovered new research challenges for database systems to support scientific query.<\/p>\n<\/div>\n<p><!-- .asset-content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What would you do to help more than 40 scientists, coming together from all over the US for 2 days, extract high-level insights from a pile of loosely-linked spreadsheets? In this talk, I will discuss our field experiment using SQL-as-a-Service to support &#8220;instant analysis&#8221; of oceanographic data in real-time. I will tell you about our [&hellip;]<\/p>\n","protected":false},"featured_media":197880,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","msr_hide_image_in_river":0,"footnotes":""},"research-area":[],"msr-video-type":[206954],"msr-locale":[268875],"msr-post-option":[],"msr-session-type":[],"msr-impact-theme":[],"msr-pillar":[],"msr-episode":[],"msr-research-theme":[],"class_list":["post-189894","msr-video","type-msr-video","status-publish","has-post-thumbnail","hentry","msr-video-type-microsoft-research-talks","msr-locale-en_us"],"msr_download_urls":"","msr_external_url":"https:\/\/youtu.be\/4wOiJHH1gI\/","msr_secondary_video_url":"","msr_video_file":"","_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video\/189894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-video"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video\/189894\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media\/197880"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=189894"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=189894"},{"taxonomy":"msr-video-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video-type?post=189894"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=189894"},{"taxonomy":"msr-post-option","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-post-option?post=189894"},{"taxonomy":"msr-session-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-session-type?post=189894"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=189894"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=189894"},{"taxonomy":"msr-episode","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-episode?post=189894"},{"taxonomy":"msr-research-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-research-theme?post=189894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}