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:
“I don’t say ‘tis impossible for an impudent man not to rise in the world, but a moderate merit with a large share of impudence is more probable to be advanced than the greatest qualifications without it.”
—Mary Wortley, Lady Montagu (1689–1762)
“There is the view that poetry should improve your life. I think people confuse it with the Salvation Army.”
—John Ashbery (b. 1927)
““It looks as if
Some pallid thing had squashed its features flat
And its eyes shut with overeagerness
To see what people found so interesting
In one another, and had gone to sleep
Of its own stupid lack of understanding,
Or broken its white neck of mushroom stuff
Short off, and died against the windowpane.””
—Robert Frost (1874–1963)