Materialized views techniques, implementations, and applications

"When an application is built, an underlying data model is chosen to make that application effective. Frequently, other applications need the same data, only modeled differently. The solution of copying the underlying data and modeling is costly in terms of storage and makes data maintenance an...

Full description

Bibliographic Details
Main Author: Gupta, Ashish
Other Authors: Mumick, Inderpal Singh
Format: eBook
Language:English
Published: Cambridge, Mass. MIT Press 1999
Subjects:
Online Access:
Collection: MIT Press eBook Archive - Collection details see MPG.ReNa
LEADER 02778nmm a2200349 u 4500
001 EB002070613
003 EBX01000000000000001210703
005 00000000000000.0
007 cr|||||||||||||||||||||
008 220922 ||| eng
020 |a 0262287501 
020 |a 9780262287500 
020 |a 9780585331744 
020 |a 058533174X 
050 4 |a QA76.9.D3 
100 1 |a Gupta, Ashish 
245 0 0 |a Materialized views  |h Elektronische Ressource  |b techniques, implementations, and applications  |c edited by Ashish Gupta, Inderpal Singh Mumick ; foreword by Jeffrey D. Ullman 
260 |a Cambridge, Mass.  |b MIT Press  |c 1999 
300 |a xix, 589 pages  |b illustrations 
653 |a COMPUTER SCIENCE/General 
653 |a Materialized views (Computer science) 
653 |a Database management 
653 |a Data warehousing 
700 1 |a Mumick, Inderpal Singh 
041 0 7 |a eng  |2 ISO 639-2 
989 |b MITArchiv  |a MIT Press eBook Archive 
028 5 0 |a 10.7551/mitpress/4472.001.0001 
776 |z 0262571226 
776 |z 9780262571227 
856 4 0 |u https://doi.org/10.7551/mitpress/4472.001.0001?locatt=mode:legacy  |x Verlag  |3 Volltext 
082 0 |a 005.74/068 
520 |a "When an application is built, an underlying data model is chosen to make that application effective. Frequently, other applications need the same data, only modeled differently. The solution of copying the underlying data and modeling is costly in terms of storage and makes data maintenance and evolution impossible. View mechanisms are a technique to model data differently for various applications without affecting the underlying format and structure of the data. The technique enables applications to customize shared data objects without affecting other applications that use the same objects. The growing data-manipulation needs of companies cannot be met by existing legacy systems that contain valuable data. Thus view mechanisms are becoming increasingly important as a way to model and use legacy data in new applications. Materialized views are views that have been computed and stored in databases. Because they reduce the need to recompute the view and/or data being queried, they speed up the querying of large amounts of data. Further, because they provide a systematic way to describe how to recompute the data, maintenance and evolution can be automated. Materialized views are especially useful in data warehousing, query optimization, integrity constraint maintenance, online analytical processing, and applications such as billing, banking, and retailing. This comprehensive volume, with a foreword by Jeff Ullman of Stanford University, will serve as a reference for students and commercial users, and encourage further use and development of materialized views."