This is a great article covering the ecosystem but has not covered one of the key advancements in this area in the past 40 to 50 years., which is IVM (incremental view maintenance).
The topic could start from database “views” and how analytical queries are basically different views of the same underlying data and how IVM solves the batch+stream unification and real-time queries over data elegantly. Tying change data capture into the picture as well.
The company “Feldera” and its founding folks are the leading researchers/experts on IVM and it’s becoming increasingly relevant for all kinds of workloads.