Advanced View Features
Various database management systems have extended the views from read-only subsets of data.
Oracle Database introduced the concept of materialized views: pre-executed, non-virtual views commonly used in data warehousing. They give a static snapshot of the data and may include data from remote sources. The accuracy of a materialized view depends on the frequency or trigger mechanisms behind its updates. IBM DB2 provides so-called "materialized query tables" (MQTs) for the same purpose. Microsoft SQL Server introduced in its 2000 version indexed views which only store a separate index from the table, but not the entire data.
Read more about this topic: View (database)
Famous quotes containing the words advanced, view and/or features:
“Among the earliest institutions to be invented, if I read the stars right, is a Protestant monastery, a place of elegant seclusion where melancholy gentlemen and ladies may go to spend the advanced session of life in drinking milk, walking the woods & reading the Bible and the poets.”
—Ralph Waldo Emerson (1803–1882)
“The population question is the real riddle of the sphinx, to which no political Oedipus has as yet found the answer. In view of the ravages of the terrible monster over-multiplication, all other riddle sink into insignificance.”
—Thomas Henry Huxley (1825–95)
“The features of our face are hardly more than gestures which force of habit made permanent. Nature, like the destruction of Pompeii, like the metamorphosis of a nymph into a tree, has arrested us in an accustomed movement.”
—Marcel Proust (1871–1922)