News for hackers. Stuff that matters.
Re:Chronon, Airbnb's ML Feature Platform, Is Now Open Source by ezvz on Tuesday April 09, 2024 @05:14PM (#39984329)
6NF works well for some temporal data, but I haven't seen it work well for windowed aggregations because the start/end time format of saving values doesn't handle events "falling out of the window" too well. At least the examples I've seen have values change due to explicit mutation events.
Re:Chronon, Airbnb's ML Feature Platform, Is Now Open Source by hobs on Tuesday April 09, 2024 @07:32PM (#39985426)
Agree, you don't really want to pre-aggregate your temporal data, or it will effectively only aggregate at each row-time boundary and the value is lower than just keeping the individual calculations.