Glossary

Materialized View - Also referred to as an MV, a materialized view is like a regular view in that it is defined with a query. But, instead of being instantiated when run, the MV is instantiated in advance and the data is stored in a table (which can be indexed, partitioned, etc). The data can be manually refreshed, scheduled or fast refreshed. A fast refresh tries to update the stored data automagically when the tables in the underlying query change.

MySQL - The most popular open source database in wide spread use. MySQL was developed by MySQL AB. The company was sold to Sun in 2008. MySQL can be considered a light weight, enterprise class database. It is superior for many web functions but fails in areas related to functionality and stability.