Comment by apavlo

Postgres is not every system. Just because it requires manually refreshing matviews doesn't mean that every DBMS works that way.

Seriously, read a textbook:

http://db.cs.duke.edu/papers/fntdb12-ChirkovaYang-mat_views....