RealTime Collaborative Analysis with (Almost) Pure SQL: A Case Study in Biogeochemical Oceanography

Channel:
Microsoft Research
Subscribers:
344,000
Published on ● Video Link: https://www.youtube.com/watch?v=4wOiJHH01gI


Duration: 45:03
23 views
0

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 "instant analysis" of oceanographic data in real-time. I will tell you about our work as "SQL stenographers" -- 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's "face time". With this field test, we also uncovered new research challenges for database systems to support scientific query.



Other Videos By Microsoft Research


2016-07-26Collaborative, Large-Scale Data Analytics and Visualization with Python
2016-07-26Gap Probabilities for Zeroes of Stationary Gaussian Functions
2016-07-26Random Walks on Groups and the Kaimanovich-Vershik Conjecture for Lamplighter Groups
2016-07-26Sensing without Sensors
2016-07-26Optimal Falsifications for Cyber-Physical Systems using Trajectory Splicing
2016-07-26A Sensor Fusion Approach towards Gesture Recognition on the Wearable Ring Form Factor
2016-07-26Digital Traces in Online Places: Methods, Software, and Applications for Social Behavioral Research
2016-07-26Stabilizer: Statistically Sound Performance Evaluation
2016-07-26Revenue maximization and prophet inequalities
2016-07-26On the Number of Matroids
2016-07-26RealTime Collaborative Analysis with (Almost) Pure SQL: A Case Study in Biogeochemical Oceanography
2016-07-26Who is Afraid of Vectors�Optimizing Cryptography Using SSE, AVX, NEON, and Co.
2016-07-26Programming with People: Integrating Human-Based and Digital Computation
2016-07-26ISHI Connects Us: Social Gaming with the Skype Team
2016-07-26Monitoring the Snowpack in Remote, Ungauged Mountains from Satellite and Computers
2016-07-26A Logical Revolution
2016-07-26Online Node-weighted Steiner Forest and Extensions
2016-07-26Optimal Pairings on Abelian Varieties with Theta Functions
2016-07-26Using Crowd Agents to Create Deployable Intelligent Systems
2016-07-26Quantum Speedup by Quantum Annealing
2016-07-26Creating Comics and Cartoons on Mobile Devices


Tags:
microsoft research