Decrypting HRV data from healthdb_secure.sqlite

Hello, i am currently working on an university project about the forensic usage of fitness tracker data. To this point I already extracted the healthdb_secure.sqlite database from an encrypted iPhone Backup. I was able to get all data visualized in the HealthApp. At least I got one problem. The heart rate variability. I can extract the summarized value shown in the health app, but I got big issues to get the beat to beat measurement. I am stuck at this point:

The hrv entries can be found in the samples table under the data_type = 139. With a left outer join with associations on samples.data_id = associations.child_id you get the corresponding parent_id. Only for each parent_id there is an entry in the binary_samples table with an associated byte array.

I am currently trying to decode this byte array, but it’s very hard to get data from this.

so my question is, if anybody knows how to decode this byte array or if somebody know how to get the beat to beat measurement for each heart rate variability entry.

best regards

GeekM11 -- did anyone get back to you on this? I'm interested in hearing the response here to your question.

Decrypting HRV data from healthdb_secure.sqlite
 
 
Q