[Mobilitydb-dev] question regarding the database schema

[SAKR Mahmoud]

Hi Manda,
First thing to think of is how to group your data. Typical choices are: group by vehicle, group by vehicle trip, group by vehicle hour, etc.
Then per group you create one temporal value per type of telematics. That is a temporal float for fuel level, a temporal boolean for braking is active, etc. As such one tuple will represent one group, and it will have a temporal attribute per telematic type.
I hope this helps. Otherwise, feel free to connect again.


Best regards,
Mahmoud SAKR


________________________________
From: Mobilitydb-dev <mobilitydb-dev-bounces at lists.osgeo.org> on behalf of Manda Awad via Mobilitydb-dev <mobilitydb-dev at lists.osgeo.org>
Sent: Wednesday, October 11, 2023 10:21 AM
To: mobilitydb-dev at lists.osgeo.org <mobilitydb-dev at lists.osgeo.org>
Subject: [Mobilitydb-dev] question regarding the database schema

Hello team,

I hope you are doing well.

I am reaching out to ask you about the best way to store data in mobilitydb, I have a lot of telematics data for example (fuel level, acceleration readings, rpm, braking is active, .....) and many more, what is the best way to store these data in mobilitydb?

Thanks! Regards
Manda Awad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-dev/attachments/20231030/6a510f12/attachment.htm>