what is the correct name for "rich" views? I was reading about this the other day that with a good DB you can create a view of data, that is automatically updated and cached 

say you have:


time user was online
this is measured with 2 datetimes, start and end date
many entries
what is the total time? 


this would be an example of a "rich" view

a view that selects all entries, and adds up the dates, and provides them in a view

when a value is updated, automatically the view is updated

now I don't know the word for it. 

What is the proper term for it? 

I know mysql does not support it (at least that is what I think)
Materialized view.

Overview of Materialized Views

Materialized Views