Overview

Astrophysicists studying binary stars use a program called POSYDON (POpulation SYnthesis with Detailed binary-evolution simulatiONs) to simulate binary star interactions. Studying stars directly can be time-consuming and costly, so astrophysicists often conduct primary research via simulations before verifying their results with real astronomical observations. In particular, POSYDON studies systems where two stars interact with each other.

Given the number of simulations it performs and the criteria it collects, POSYDON generates a large amount of data and stores this across numerous spreadsheet files in Comma Separated Values (CSV) format. Due to the dispersed nature of the data, there is currently no efficient way to search and analyze the information. To address this, our project will provide a software tool to import this data into a common location. Following data processing, users will be able to search collected binary star data using standard English language requests, by utilizing pre-generated queries, or by writing custom queries using Structured Query Language (SQL).

Without a tool such as this, users would have difficulty formulating their requests for obtaining particular subsets of the simulated data that satisfies their desired properties. Specifically, for every desired query, a complex program will need to be constructed - as opposed to having a compact, high-level language providing a declarative ("what") without the need for procedural ("how") details. By simplifying data access and supporting custom data, this project aims to make binary star data querying more accessible to students, educators, and researchers, allowing for greater collaboration. In addition, similar queries can be reused almost verbatim by changing the values in their parameters.


Team Members

James Byrd

Database Backend, Cyber Specialist

Computer Engineering and Cybersecurity student interested in Network Security and Penetration Testing.

Eamon Collins

Client Contact, Database Backend Private Image

Computer Engineering Student with a passion for RF and Embedded Systems.

Alek Norris

Database Backend, Cyber Specialist

Cyber Security Engineering student with a passion for Penetration Testing, Cryptography, and Secure Systems Design.

Alex Polston

Database Backend, Cyber Specialist

Cyber Security Engineering student with an interest in Penetration Testing and Digital Forensics.

Andrew Snyder

Database Backend, Cyber Specialist

Computer Engineering student with an interest in backend development and cloud computing.

Svyatoslav Varnitskyy

GUI Specialist, Database Backend

Software Engineering Major from the Chicago suburbs.

Semester 1, Fall Semester:

Fall Weekly Reports

Report 1
Report 2
Report 3
Report 4
Report 5
Report 6
Report 7
Report 8
Report 9
Report 10

Fall Lightning Talks

Lightning Talk 1: Product Research
Lightning Talk 2: Problem and Users
Lightning Talk 3: User Needs and Requirements
Lightning Talk 4: Project Planning
Lightning Talk 5: Detailed Design
Lightning Talk 6: Contextualization / Design Check-In
Lightning Talk 7: Prototyping
Lightning Talk 8: Ethics
Final Presentation SD491

Fall Design Documents

Design Doc 1: Introduction
Design Doc 2: Requirements
Design Doc 3: Project Plan
Design Doc 4: Design
Design Doc

Semester 2, Spring Semester:

Spring Bi-Weekly Reports

Bi-Weekly Status Report 1
Bi-Weekly Status Report 2
Bi-Weekly Status Report 3
Bi-Weekly Status Report 4
Bi-Weekly Status Report 5
Bi-Weekly Status Report 6

Final Design Document and Code

Final Design Doc
Codebase on Github

Presentation and Demo Material

Poster
Final Presentation pdf
Final Presentation pptx
Demo Video Long
Demo Video Short No Audio