Creating view or materialized view on top of streaming data and accessing it frequently will increase the cost like anything. One better solution can be write the data in the table in flatten format.