1. Work 01
  2. Craft 02
  3. Research 03
  4. About 04
  5. Writing 05
  6. Contact 06
Email LinkedIn GitHub CV
All work

12 / 12 · Database systems

CubeSat Telemetry

Exploring telemetry data management for a self-healing satellite database through a synthetic-data case study.

Downlink · 6 channels

Break it. Watch it heal.

Records
0
Faults
0
Repaired
0
Quarantined
0
Integrity
100%
SeqUTCBat VTemp °CSolar mAGyro °/sMag µTRSSICRC32Quality
Category
Database systems · Engineering
Team
Four members
Engine
SQLite · Python
Data
NASA ELFIN-B telemetry · synthetic faults

What it does

  1. A working prototype tested on real NASA ELFIN-B spacecraft telemetry with artificially injected corruption.
  2. SQLite with write-ahead logging, SHA-256 integrity checks, Isolation Forest anomaly detection and temporal-interpolation recovery — each repair is verified, versioned and logged with where it came from.
  3. On-board database design on SQLite: a 12-table schema in Third Normal Form.
  4. Per-record CRC32 checksums, write-ahead logging and trigger-based version history.
  5. Layered fault detection and interpolation-based recovery with quality flags.
  6. Telemetry processing evaluated on simulated six-channel data with injected faults.
  7. Limitations documented; replay on real flight data left as future work.

Radiation bit flips, sensor glitches and replayed frames quietly corrupt satellite data. The project asks whether standard database techniques, applied record by record, can make that data repair itself. The course case study was evaluated on synthetic data; the prototype runs on real ELFIN-B telemetry with injected faults.

Case study, no public link.

How it's built

01 · Data architecturespace segment → ground segment
SPACE SEGMENT · CubeSat on-board computerGROUND SEGMENTperiodic scanUPDATEanomaly eventsdownlinkSubsystem sensorsEPS · ADCS · OBC6 channels @ 0.1 HzADC countsIngestion & validationCHECK range / cadenceUNIQUE(sensor_id, ts)CRC32 per recordOn-board DBSQLite · WAL journal12 tables · 3NFtriggers · versionsprovenanceIntegrity monitorCRC scan (SQL UDF)grid-gap detectorPRAGMA integrity_checkAnomaly detectorrobust z-score (MAD)3-orbit seasonal baselineglitch vs. real eventRecovery engineinterpolate ≤ 1 minelse mark MISSINGlog + version rowMission-priority enginephase · criticalityanomaly eventsstorage / energyCompression controllerlossless: critical, eventsadaptive: nominal (k=4)aggressive: storage-criticalSync engine (DTN-aware)delta: version >synced_versionconflict rulesMission operationsv_data_health viewanomaly reviewtelecommandsGround replica DBsame schemaGROUND_VERIFIED rowsconflict_logGround stationUHF 9.6 kbit/s~8 min passes4 passes / day
02 · On-board schema12 tables · 3NF · hover a table
1Nhas1Nrecords1Nversioned by1Npacked into1Nraises1Nrepaired by1Ndisputed in1Ntriggers1Nresolves1Nentered as1NhostsSUBSYSTEMPKsubsystem_idnamecriticalSENSORPKsensor_idFKsubsystem_idname, unitmin_val, max_valquantumnoise_sigmaTELEMETRYPKtelemetry_idFKsensor_idtsvaluequalitychecksumversionsynced_versionRECORD_VERSIONPKversion_idFKtelemetry_idold_value, new_valueold_quality, new_qualitychanged_atCOMPRESSED_BLOCKPKblock_idFKsensor_idstart_ts, end_tscodec, kraw_bytes, comp_bytespayload, crcANOMALY_EVENTPKevent_idFKsensor_idstart_ts, end_tspeak_devseverityRECOVERY_ACTIONPKaction_idFKtelemetry_idfault_typemethodconfidenceCONFLICT_LOGPKconflict_idFKsession_idFKtelemetry_idonboard_valueground_valuewinnerMISSION_PHASEPKphase_idnamecompression_modePHASE_LOGPKlog_idFKphase_idFKevent_idstart_ts, end_tsGROUND_STATIONPKstation_idnamelat, lonSYNC_SESSIONPKsession_idFKstation_idaos_ts, los_tsdelta_bytes, full_bytesblocks_sentPK primary key · FK foreign key · 1 — N one-to-many · all tables in 3NF · hover a table