The Database Knowledgebase on the Web

KNOWLEDGEBASE:

SQL

Oracle

MySQL

Postgres 

General topics 

Glossary 

Glossary

Select a letter to browse the glossary. You may also enter a search phrase in the Google search box below to search the entire site.

0 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z


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.

Contact: Lewis Cunningham
lewisc@databasewisdom.com

About us

Contact us

Support us

Authors, Share Your Book with Millions of Readers

Search Database Wisdom