Probing the Mysteries of Saturn’s E-Ring with PostgreSQL

Explore the fascinating world of Saturn's E-Ring through a conference talk that combines astronomy, data analysis, and PostgreSQL. Dive into the fictional work of aerospace startup Red:4 as they prepare for humanity's return to Saturn in 2020. Learn how to build and analyze historical datasets using instrument data from the Cassini mission, with a focus on the enigmatic moon Enceladus. Discover techniques for flyby speed calculation, chemistry analysis, and get a glimpse of the planned machine learning system for the future SELFI probe. Throughout the presentation, gain insights into SQL, database design, and the ethical considerations surrounding predictive data analysis. Follow along as the speaker uncovers the story hidden within the data, demonstrating how to overcome challenges such as Excel leap year bugs and complex data transformations. Gain valuable knowledge about working with astronomical instruments, analyzing chemical compositions, and linking data points to draw meaningful conclusions about the possibility of life beyond Earth.

Introduction
Cassini
Data Discovery
Data Analysis
Transform Data
Excel Leap Year Bug
The Data
The Main Character
The First Task
The Instruments
The IMS Data
The Easy Way
The Problems
Speed Data
Analysis Window
Chemical Analysis
Questioning Life
Analysis on the Day
Linking on the Peak
Conclusion