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
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 1Report 2
Report 3
Report 4
Report 5
Report 6
Report 7
Report 8
Report 9
Report 10
Fall Lightning Talks
Lightning Talk 1: Product ResearchLightning 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: IntroductionDesign 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 1Bi-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 DocCodebase on Github
Presentation and Demo Material
PosterFinal Presentation pdf
Final Presentation pptx
Demo Video Long
Demo Video Short No Audio