The historian add much indirection and, with partitioning, a variable list of tables to work with. A dedicated table can be simple, and with the use of lead()/lag() functions, easy to query for interval lengths. This post discusses the technique:
{ Note that MySQL can do window aggregates now. But I still recommend MariaDB or PostgreSQL. }