Real-Time Collaborative Analysis with (Almost) Pure SQL: A Case Study in Biogeochemical Oceanography
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.
Speaker Details
Daniel Halperin is a postdoctoral researcher with the University of Washington eScience Institute, where he is trying to transform the way and pace at which science progresses. He earned his Ph.D. at UW in 2012 in the area of wireless networking.
- Series:
- Microsoft Research Talks
- Date:
- Speakers:
- Daniel Halperin
- Affiliation:
- University of Washington
Series: Microsoft Research Talks
-
DIABLo: a Deep Individual-Agnostic Binaural Localizer
Speakers:- Shoken Kaneko
-
A Tale of Two Cities: Software Developers in Practice During the COVID-19 Pandemic
Speakers:- Denae Ford Robinson
-
Recent Efforts Towards Efficient And Scalable Neural Waveform Coding
Speakers:- Kai Zhen
-
-
Audio-based Toxic Language Detection
Speakers:- Midia Yousefi
-
What Kind of Computation is Human Cognition? A Brief History of Thought (Episode 2/2)
Speakers:- Paul Smolensky
-
From SqueezeNet to SqueezeBERT: Developing Efficient Deep Neural Networks
Speakers:- Forrest Iandola,
- Sujeeth Bharadwaj
-
Hope Speech and Help Speech: Surfacing Positivity Amidst Hate
Speakers:- Ashique Khudabukhsh
-
What Kind of Computation is Human Cognition? A Brief History of Thought (Episode 1/2)
Speakers:- Paul Smolensky
-
An Ethical Crisis in Computing?
Speakers:- Eric Horvitz,
- Moshe Y. Vardi
-
Towards Mainstream Brain-Computer Interfaces (BCIs)
Speakers:- Brendan Allison
-
-
'F' to 'A' on the N.Y. Regents Science Exams: An Overview of the Aristo Project
Speakers:- Peter Clark
-
Checkpointing the Un-checkpointable: the Split-Process Approach for MPI and Formal Verification
Speakers:- Gene Cooperman
-
Learning Structured Models for Safe Robot Control
Speakers:- Subramanian Ramamoorthy
-
Non-linear Invariants for Control-Command Systems
Speakers:- Pierre Roux
-
Distributed Entity Resolution for Computational Social Science
Speakers:- Rebecca C. Steorts
-
The Worst Form Including All Those Others: Canada’s Experiments with Online Voting
Speakers:- Aleksander Essex
-
How Not to Prove Your Election Outcome
Speakers:- Vanessa Teague
-
Dashboard Mechanisms for Online Marketplaces
Speakers:- Jason Hartline
-
Compacting the Uncompactable: The Mesh Compacting Memory Allocator
Speakers:- Emery Berger
-
Tea: A High-level Language and Runtime System for Automating Statistical Analysis
Speakers:- Eunice Jun
-
Resource-Efficient Redundancy for Large-Scale Data Processing and Storage Systems
Speakers:- Rashmi Vinayak
-
Battling Unfair Demons in Peer Review
Speakers:- Nihar Shah
-
Sequential Estimation of Quantiles with Applications to A/B-testing and Best-arm Identification
Speakers:- Aaditya Ramdas